PO
POReceiptEntry.POOrderS
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
Approved | bit | - | ||
Description:No description available | ||||
AttributesNonexistent in DB | string | - | ||
Description:No description available | ||||
BLOrderNbr | nvarchar(15) | POOrder | ||
Description:No description available | ||||
BLType | char(2) | POOrder | ||
Description:No description available | ||||
BaseReceivedQty | decimal | Base Received Qty. | - | |
Description:No description available | ||||
Behavior | char(1) | Workflow | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
Cancelled | bit | Cancel | - | |
Description:No description available | ||||
ClDisplayNameNonexistent in DB | string | - | ||
Description:No description available | ||||
ControlTotal | decimal | - | ||
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 | Control Total | - | |
Description:No description available | ||||
CuryDetailExtCostTotalNonexistent in DB | decimal? | Detail Total | - | |
Description:The sum of the goods, services and the freight amount values. | ||||
CuryDiscTot | decimal | Document Discounts | - | |
Description:No description available | ||||
CuryDocumentDiscTotal | decimal | 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 | 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 | 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 | 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 | 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 | - | ||
Description:No description available | ||||
CuryLineTotal | decimal | Line Total | - | |
Description:No description available | ||||
CuryOrderDiscTotalNonexistent in DB | 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 | 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:The total amount on all Service lines of the document, before Line-level discounts are applied (in the currency of the document). | ||||
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 | ||||
DetailCount | int | - | ||
Description:The number of detail lines of the document. | ||||
DetailExtCostTotalNonexistent in DB | 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 | - | ||
Description:No description available | ||||
DocumentDiscTotal | decimal | 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 | ||||
DropShipLinesCountObsolete | int | - | ||
Description:No description available | ||||
DropShipLinkedLinesCount | int | - | ||
Description:No description available | ||||
DropShipNotLinkedLinesCntr | int | - | ||
Description:No description available | ||||
DropShipOpenLinesCntr | int | - | ||
Description:No description available | ||||
DropshipExpenseRecording | nvarchar(1) | Record Drop-Ship Expenses | - | |
Description:No description available | ||||
DropshipReceiptProcessing | nvarchar(1) | Drop-Ship Receipt Processing | - | |
Description:No description available | ||||
Emailed | bit | Emailed | - | |
Description:No description available | ||||
EmailedExtNonexistent in DB | bool? | - | ||
Description:No description available | ||||
EmployeeIDNonexistent in DBObsolete | int? | Owner | EPEmployee | |
Description:No description available | ||||
EntityUsageType | char(1) | Tax Exemption Type | - | |
Description:The entity type for reporting purposes. The field is used if the system is integrated with External Tax Calculation and the External Tax Calculation Integration feature is enabled. The field can have one of the values described in . Defaults to the Tax Exemption Type that is specified for the location of the branch. | ||||
ExcludeFromIntercompanyProc | bit | Exclude from Intercompany Processing | - | |
Description:No description available | ||||
ExpectedDate | datetime | Promised On | - | |
Description:No description available | ||||
ExpirationDate | datetime | Expires On | - | |
Description:No description available | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:The tax exemption number for reporting purposes. The field is used if the system is integrated with External Tax Calculation and the External Tax Calculation Integration feature is enabled. | ||||
ExternalTaxesImportInProgressNonexistent in DB | bool? | - | ||
Description:No description available | ||||
FOBPoint | nvarchar(15) | FOB Point | FOBPoint | |
Description:No description available | ||||
FreightTot | decimal | - | ||
Description:The total amount on all Freight lines of the document, before Line-level discounts are applied. | ||||
GoodsExtCostTotal | decimal | - | ||
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 | 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 | bool? | - | ||
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:No description available | ||||
IntercompanySOCancelledNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IntercompanySONbrNonexistent in DB | string | Related Order Nbr. | SOOrder | |
Description:No description available | ||||
IntercompanySOTypeNonexistent in DB | string | Related Order Type | SOOrderType | |
Description:No description available | ||||
IntercompanySOWithEmptyInventoryNonexistent in DB | bool? | - | ||
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 | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LeftToReceiveQtyNonexistent in DB | decimal? | Open Qty. | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineDiscTotal | decimal | Line Discounts | - | |
Description:The total line discount of the document, which is calculated as the sum of line discounts of the order. | ||||
LineRetainageTotal | decimal | - | ||
Description:No description available | ||||
LineTotal | decimal | Line Total | - | |
Description:No description available | ||||
LinesStatusUpdatedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
LinesToCloseCntr | int | - | ||
Description:No description available | ||||
LinesToCompleteCntr | int | - | ||
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 | datetime | Date | - | |
Description:No description available | ||||
OrderDesc | nvarchar(60) | Description | - | |
Description:No description available | ||||
OrderDiscTotalNonexistent in DB | 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. | ||||
OrderNbr | nvarchar(15) | Order Nbr. | POOrder | |
Description:No description available | ||||
OrderQty | decimal | Order Qty | - | |
Description:No description available | ||||
OrderTotal | decimal | Order Total | - | |
Description:No description available | ||||
OrderTotalInWordsNonexistent in DB | string | - | ||
Description:No description available | ||||
OrderType | char(2) | Type | - | |
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 | bool? | - | ||
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
OwnerWorkgroupID | int | Workgroup ID | EPCompanyTree | |
Description:No description available | ||||
POAccrualTypeNonexistent in DB | string | Billing Based On | - | |
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. | ||||
PrepaidTotal | decimal | - | ||
Description:No description available | ||||
PrepaymentPct | decimal | Prepayment Percent | - | |
Description:No description available | ||||
Printed | bit | Printed | - | |
Description:No description available | ||||
PrintedExtNonexistent in DB | bool? | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
RQReqNbr | nvarchar(15) | Requisition Ref. Nbr. | RQRequisition | |
Description:No description available | ||||
ReceivedQty | decimal | Received Qty. | - | |
Description:No description available | ||||
RejectedNonexistent in DB | bool? | Reject | - | |
Description:No description available | ||||
RemitAddressID | int | PORemitAddress | ||
Description:No description available | ||||
RemitContactID | int | PORemitContact | ||
Description:No description available | ||||
RequestApprovalNonexistent in DB | bool? | 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 | ||||
SOOrderNbr | nvarchar(15) | Sales Order Nbr. | DemandSOOrder | |
Description:No description available | ||||
SOOrderType | char(2) | Sales Order Type | SOOrderType | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ServiceExtCostTotal | decimal | - | ||
Description:The total amount on all Service lines of the document, before Line-level discounts are applied. | ||||
ShipAddressID | int | POShipAddress | ||
Description:No description available | ||||
ShipContactID | int | POShipContact | ||
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 | string | - | ||
Description:No description available | ||||
SpecialLineCntr | int | - | ||
Description:No description available | ||||
SquareSumProjectID | bigint | - | ||
Description:The sum of squares of integer IDs of all projects in document's detail lines. | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
SubcontractClassIDNonexistent in DB | string | - | ||
Description:No description available | ||||
SuccessorPONbrNonexistent in DB | string | Normal PO Nbr. | POOrder | |
Description:No description available | ||||
SumProjectID | bigint | - | ||
Description:The sum of integer IDs of all projects in document's detail lines. | ||||
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 | ||||
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 | bool? | - | ||
Description:No description available | ||||
UploadFileNameCorrectorStubNonexistent in DB | bool? | - | ||
Description:Used only for attribute. | ||||
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 | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||