PO
POOrder
PX.Objects.POView API Entity: PurchaseOrder
/entity/Default/24.200.001/PurchaseOrder151 of 151 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
OrderNbr API | 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 API | decimal(19, 4) | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryControlTotal | decimal(19, 4) | Control Total | - | |
Description:No description available | ||||
CuryDetailExtCostTotal | decimal | Detail Total | - | |
Description:The sum of the goods, services and the freight amount values. | ||||
CuryDiscTot | decimal(19, 4) | Document Discounts | - | |
Description:No description available | ||||
CuryDocumentDiscTotal | decimal(19, 4) | Document Discount | - | |
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of document discounts of the order. | ||||
CuryFreightTot | decimal(19, 4) | Freight Total | - | |
Description:The total amount on all Freight lines of the document, before Line-level discounts are applied (in the currency of the document). | ||||
CuryGoodsExtCostTotal | decimal(19, 4) | Goods | - | |
Description:The total amount on all lines of the document, except for Freight, Description and Service lines, before Line-level discounts are applied (in the currency of the document). | ||||
CuryGroupDiscTotal | decimal(19, 4) | Group Discounts | - | |
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of group discounts of the order. | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineDiscTotal | decimal(19, 4) | Line Discounts | - | |
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of line discounts of the order. | ||||
CuryLineRetainageTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryLineTotal | decimal(19, 4) | Line Total | - | |
Description:No description available | ||||
CuryOrderDiscTotal | decimal | Discount Total | - | |
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of all group, document and line discounts of the order. | ||||
CuryOrderTotal | decimal(19, 4) | Order Total | - | |
Description:No description available | ||||
CuryPrepaidTotal | decimal(19, 4) | Unbilled Prepayment Total | - | |
Description:No description available | ||||
CuryRetainageTotal | decimal(19, 4) | Retainage Total | - | |
Description:No description available | ||||
CuryRetainedDiscTotal | decimal(19, 4) | Discount on Retainage | - | |
Description:No description available | ||||
CuryRetainedTaxTotal | decimal(19, 4) | Tax on Retainage | - | |
Description:No description available | ||||
CuryServiceExtCostTotal | decimal(19, 4) | Services | - | |
Description:The total amount on all Service lines of the document, before Line-level discounts are applied (in the currency of the document). | ||||
CuryTaxTotal | decimal(19, 4) | Tax Total | - | |
Description:No description available | ||||
CuryUnbilledLineTotal | decimal(19, 4) | Unbilled Line Total | - | |
Description:No description available | ||||
CuryUnbilledOrderTotal | decimal(19, 4) | Unbilled Amount | - | |
Description:No description available | ||||
CuryUnbilledTaxTotal | decimal(19, 4) | Unbilled Tax Total | - | |
Description:No description available | ||||
CuryUnprepaidTotal | decimal(19, 4) | Unpaid Amount | - | |
Description:No description available | ||||
CuryVatExemptTotal | decimal(19, 4) | Tax Exempt Total | - | |
Description:No description available | ||||
CuryVatTaxableTotal | decimal(19, 4) | Taxable Total | - | |
Description:No description available | ||||
DefRetainagePct | decimal(9, 6) | Retainage Percent | - | |
Description:No description available | ||||
DetailExtCostTotal | decimal | - | ||
Description:The sum of the goods, services and the freight amount values. | ||||
DisableAutomaticDiscountCalculation | bit | Disable Automatic Discount Update | - | |
Description:No description available | ||||
DiscTot | decimal(19, 4) | - | ||
Description:No description available | ||||
DocumentDiscTotal | decimal(19, 4) | Document Discount | - | |
Description:The total document discount of the document, which is calculated as the sum of document discounts of the order. If the Vendor Discounts feature is not enabled on the Enable/Disable Features (CS100000) form, a user can enter a document-level discount manually. This manual discount has no discount code or sequence and is not recalculated by the system. If the manual discount needs to be changed, a user has to correct it manually. | ||||
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 | char(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 | char(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(19, 4) | - | ||
Description:The total amount on all Freight lines of the document, before Line-level discounts are applied. | ||||
GoodsExtCostTotal | decimal(19, 4) | - | ||
Description:The total amount on all lines of the document, except for Freight, Description and Service lines, before Line-level discounts are applied. | ||||
GroupDiscTotal | decimal(19, 4) | Group Discounts | - | |
Description:The total group discount of the document, which is calculated as the sum of group discounts of the order. | ||||
HasMultipleProjects | bit | - | ||
Description:A Boolean value that shows whether the purchase order contains lines for different projects. | ||||
HasUsedLineNonexistent in DB | bit | - | ||
Description:No description available | ||||
Hold API | 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 API | 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 | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime API | datetime | Last Modified On | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineDiscTotal | decimal(19, 4) | Line Discounts | - | |
Description:The total line discount of the document, which is calculated as the sum of line discounts of the order. | ||||
LineRetainageTotal | decimal(19, 4) | - | ||
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 API | decimal(19, 4) | Line Total | - | |
Description:No description available | ||||
LockCommitment | bit | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenOrderQty | decimal(25, 6) | 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:The total discount of the document, which is calculated as the sum of group, document and line discounts of the order. | ||||
OrderQty | decimal(25, 6) | Order Qty | - | |
Description:No description available | ||||
OrderTotal API | decimal(19, 4) | Order Total | - | |
Description:No description available | ||||
OrderVolume | decimal(25, 6) | Volume | - | |
Description:No description available | ||||
OrderWeight | decimal(25, 6) | 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:A reference to the Vendor. An integer identifier of the vendor, whom the AP bill will belong to. | ||||
POAccrualTypeNonexistent in DB | nchar(1) | Billing Based On | - | |
Description:No description available | ||||
PrepaidTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
PrepaymentPct | decimal(9, 6) | 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(19, 4) | - | ||
Description:No description available | ||||
RetainedDiscTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
RetainedTaxTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
RQReqNbr | nvarchar(20) | Requisition Ref. Nbr. | RQRequisition | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ServiceExtCostTotal | decimal(19, 4) | - | ||
Description:The total amount on all Service lines of the document, before Line-level discounts are applied. | ||||
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 API | 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 API | decimal(19, 4) | - | ||
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(19, 4) | - | ||
Description:No description available | ||||
UnbilledOrderQty | decimal(25, 6) | Unbilled Quantity | - | |
Description:No description available | ||||
UnbilledOrderTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
UnbilledTaxTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
UnprepaidTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
UpdateVendorCostNonexistent in DB | bit | - | ||
Description:No description available | ||||
VatExemptTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
VendorID API | 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 | ||||