PO
POPrintOrder.POPrintOrderOwned
PX.Objects.PO151 of 151 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
OrderNbr | nvarchar(15) | Order Nbr. | POOrder | |
Description:No description available | ||||
OrderType | char(2) | Type | - | |
Description:No description available | ||||
Approved | bit | - | ||
Description:No description available | ||||
Behavior | char(1) | Workflow | - | |
Description:No description available | ||||
BLOrderNbr | nvarchar(15) | - | ||
Description:No description available | ||||
BLType | char(2) | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
Cancelled | bit | Cancel | - | |
Description:No description available | ||||
ControlTotal | decimal | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryControlTotal | decimal | Control Total | - | |
Description:No description available | ||||
CuryDetailExtCostTotal | decimal | Detail Total | - | |
Description:No description available | ||||
CuryDiscTot | decimal | Document Discounts | - | |
Description:No description available | ||||
CuryDocumentDiscTotal | decimal | Document Discount | - | |
Description:No description available | ||||
CuryFreightTot | decimal | Freight Total | - | |
Description:No description available | ||||
CuryGoodsExtCostTotal | decimal | Goods | - | |
Description:No description available | ||||
CuryGroupDiscTotal | decimal | Group Discounts | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineDiscTotal | decimal | Line Discounts | - | |
Description:No description available | ||||
CuryLineRetainageTotal | decimal | - | ||
Description:No description available | ||||
CuryLineTotal | decimal | Line Total | - | |
Description:No description available | ||||
CuryOrderDiscTotal | decimal | Discount Total | - | |
Description:No description available | ||||
CuryOrderTotal | decimal | Order Total | - | |
Description:No description available | ||||
CuryPrepaidTotal | decimal | Unbilled Prepayment Total | - | |
Description:No description available | ||||
CuryRetainageTotal | decimal | Retainage Total | - | |
Description:No description available | ||||
CuryRetainedDiscTotal | decimal | Discount on Retainage | - | |
Description:No description available | ||||
CuryRetainedTaxTotal | decimal | Tax on Retainage | - | |
Description:No description available | ||||
CuryServiceExtCostTotal | decimal | Services | - | |
Description:No description available | ||||
CuryTaxTotal | decimal | Tax Total | - | |
Description:No description available | ||||
CuryUnbilledLineTotal | decimal | Unbilled Line Total | - | |
Description:No description available | ||||
CuryUnbilledOrderTotal | decimal | Unbilled Amount | - | |
Description:No description available | ||||
CuryUnbilledTaxTotal | decimal | Unbilled Tax Total | - | |
Description:No description available | ||||
CuryUnprepaidTotal | decimal | Unpaid Amount | - | |
Description:No description available | ||||
CuryVatExemptTotal | decimal | Tax Exempt Total | - | |
Description:No description available | ||||
CuryVatTaxableTotal | decimal | Taxable Total | - | |
Description:No description available | ||||
DefRetainagePct | decimal | Retainage Percent | - | |
Description:No description available | ||||
DetailExtCostTotal | decimal | - | ||
Description:No description available | ||||
DisableAutomaticDiscountCalculation | bit | Disable Automatic Discount Update | - | |
Description:No description available | ||||
DiscTot | decimal | - | ||
Description:No description available | ||||
DocumentDiscTotal | decimal | Document Discount | - | |
Description:No description available | ||||
DontEmail | bit | Do Not Email | - | |
Description:No description available | ||||
DontPrint | bit | Do Not Print | - | |
Description:No description available | ||||
DropShipActiveLinksCountObsolete | int | - | ||
Description:No description available | ||||
DropshipExpenseRecording | varchar(1) | Record Drop-Ship Expenses | - | |
Description:No description available | ||||
DropShipLinesCountObsolete | int | - | ||
Description:No description available | ||||
DropShipLinkedLinesCount | int | - | ||
Description:No description available | ||||
DropShipNotLinkedLinesCntr | int | - | ||
Description:No description available | ||||
DropShipOpenLinesCntr | int | - | ||
Description:No description available | ||||
DropshipReceiptProcessing | varchar(1) | Drop-Ship Receipt Processing | - | |
Description:No description available | ||||
Emailed | bit | Emailed | - | |
Description:No description available | ||||
EmailedExtNonexistent in DB | bit | - | ||
Description:No description available | ||||
EmployeeIDNonexistent in DBObsolete | int | Owner | EPEmployee | |
Description:No description available | ||||
EntityUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
ExcludeFromIntercompanyProc | bit | Exclude from Intercompany Processing | - | |
Description:No description available | ||||
ExpectedDate | datetime2 | Promised On | - | |
Description:No description available | ||||
ExpirationDate | datetime2 | Expires On | - | |
Description:No description available | ||||
ExternalTaxesImportInProgressNonexistent in DB | bit | - | ||
Description:No description available | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:No description available | ||||
FOBPoint | nvarchar(15) | FOB Point | FOBPoint | |
Description:No description available | ||||
FreightTot | decimal | - | ||
Description:No description available | ||||
GoodsExtCostTotal | decimal | - | ||
Description:No description available | ||||
GroupDiscTotal | decimal | Group Discounts | - | |
Description:No description available | ||||
HasMultipleProjects | bit | - | ||
Description:No description available | ||||
HasUsedLineNonexistent in DB | bit | - | ||
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:No description available | ||||
IntercompanySOCancelledNonexistent in DB | bit | - | ||
Description:No description available | ||||
IntercompanySONbrNonexistent in DB | nvarchar(15) | Related Order Nbr. | SOOrder | |
Description:No description available | ||||
IntercompanySOTypeNonexistent in DB | nchar(2) | Related Order Type | SOOrderType | |
Description:No description available | ||||
IntercompanySOWithEmptyInventoryNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsIntercompany | bit | - | ||
Description:No description available | ||||
IsIntercompanySOCreated | bit | - | ||
Description:No description available | ||||
IsLegacyDropShip | bit | - | ||
Description:No description available | ||||
IsTaxValid | bit | Tax Is Up to Date | - | |
Description:No description available | ||||
IsUnbilledTaxValid | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineDiscTotal | decimal | Line Discounts | - | |
Description:No description available | ||||
LineRetainageTotal | decimal | - | ||
Description:No description available | ||||
LinesStatusUpdatedNonexistent in DB | bit | - | ||
Description:No description available | ||||
LinesToCloseCntr | int | - | ||
Description:No description available | ||||
LinesToCompleteCntr | int | - | ||
Description:No description available | ||||
LineTotal | decimal | Line Total | - | |
Description:No description available | ||||
LockCommitment | bit | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenOrderQty | decimal | Open Quantity | - | |
Description:No description available | ||||
OrderBasedAPBill | bit | Allow AP Bill Before Receipt | - | |
Description:No description available | ||||
OrderDate | datetime2 | Date | - | |
Description:No description available | ||||
OrderDesc | nvarchar(60) | Description | - | |
Description:No description available | ||||
OrderDiscTotal | decimal | Discount Total | - | |
Description:No description available | ||||
OrderQty | decimal | Order Qty | - | |
Description:No description available | ||||
OrderTotal | decimal | Order Total | - | |
Description:No description available | ||||
OrderVolume | decimal | Volume | - | |
Description:No description available | ||||
OrderWeight | decimal | Weight | - | |
Description:No description available | ||||
OriginalPONbr | nvarchar(15) | Originating PO Nbr. | POOrder | |
Description:No description available | ||||
OriginalPOType | char(2) | Originating PO Type | - | |
Description:No description available | ||||
OverrideCurrencyNonexistent in DB | bit | - | ||
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
OwnerWorkgroupID | int | Workgroup ID | EPCompanyTree | |
Description:No description available | ||||
PayToVendorID | int | Pay-to Vendor | Vendor | |
Description:No description available | ||||
POAccrualTypeNonexistent in DB | nchar(1) | Billing Based On | - | |
Description:No description available | ||||
PrepaidTotal | decimal | - | ||
Description:No description available | ||||
PrepaymentPct | decimal | Prepayment Percent | - | |
Description:No description available | ||||
Printed | bit | Printed | - | |
Description:No description available | ||||
PrintedExtNonexistent in DB | bit | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
RejectedNonexistent in DB | bit | Reject | - | |
Description:No description available | ||||
RemitAddressID | int | RemitAddressID | POAddress | |
Description:No description available | ||||
RemitContactID | int | POContact | ||
Description:No description available | ||||
RequestApprovalNonexistent in DB | bit | Request Approval | - | |
Description:No description available | ||||
RetainageApply | bit | Apply Retainage | - | |
Description:No description available | ||||
RetainageTotal | decimal | - | ||
Description:No description available | ||||
RetainedDiscTotal | decimal | - | ||
Description:No description available | ||||
RetainedTaxTotal | decimal | - | ||
Description:No description available | ||||
RQReqNbr | nvarchar(15) | Requisition Ref. Nbr. | RQRequisition | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ServiceExtCostTotal | decimal | - | ||
Description:No description available | ||||
ShipAddressID | int | ShipAddressID | POAddress | |
Description:No description available | ||||
ShipContactID | int | ShipContactID | POContact | |
Description:No description available | ||||
ShipDestType | char(1) | Shipping Destination Type | - | |
Description:No description available | ||||
ShipToBAccountID | int | Ship To | BAccount | |
Description:No description available | ||||
ShipToLocationID | int | Shipping Location | Location | |
Description:No description available | ||||
ShipVia | nvarchar(15) | Ship Via | Carrier | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SiteIdErrorMessageNonexistent in DB | nvarchar(150) | - | ||
Description:No description available | ||||
SOOrderNbr | nvarchar(15) | Sales Order Nbr. | SOOrder | |
Description:No description available | ||||
SOOrderType | char(2) | Sales Order Type | SOOrderType | |
Description:No description available | ||||
SpecialLineCntr | int | - | ||
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
SuccessorPONbrNonexistent in DB | nvarchar(15) | Normal PO Nbr. | POOrder | |
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxTotal | decimal | - | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Vendor Tax Zone | TaxZone | |
Description:No description available | ||||
TermsID | nvarchar(10) | Terms | Terms | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnbilledLineTotal | decimal | - | ||
Description:No description available | ||||
UnbilledOrderQty | decimal | Unbilled Quantity | - | |
Description:No description available | ||||
UnbilledOrderTotal | decimal | - | ||
Description:No description available | ||||
UnbilledTaxTotal | decimal | - | ||
Description:No description available | ||||
UnprepaidTotal | decimal | - | ||
Description:No description available | ||||
UpdateVendorCostNonexistent in DB | bit | - | ||
Description:No description available | ||||
VatExemptTotal | decimal | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal | - | ||
Description:No description available | ||||
VendorID | int | Vendor | BAccount | |
Description:No description available | ||||
VendorLocationID | int | Location | Location | |
Description:No description available | ||||
VendorRefNbr | nvarchar(40) | Vendor Ref. | - | |
Description:No description available | ||||
WorkgroupIDNonexistent in DB | int | Approval Workgroup ID | EPCompanyTree | |
Description:No description available | ||||