Skip to main content
PO

POLandedCostDocS

PX.Objects.PO
Field NameTypeDisplay NameForeign Key
DocType
char(1)Type-
Description:Type of the document. Possible values are: "LC" - Landed Cost, "LCC" - Correction, "LCR" - Reversal.
RefNbrDefault Navigation
nvarchar(15)Reference Nbr.POLandedCostDoc
Description:No description available
APDocCreated
bit-
Description:No description available
BillDate
datetime2Bill Date-
Description:No description available
BranchIDDefault Navigation
intBranchBranch
Description:No description available
ControlTotal
decimal-
Description:No description available
CreateBill
bitCreate Bill-
Description:Get or set CreateBill that mark current document create bill on release.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
varchar(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
CuryControlTotal
decimalControl Total-
Description:No description available
CuryDiscAmt
decimalCash Discount-
Description:No description available
CuryDocBal
decimalBalance-
Description:The open balance of the document. Given in the currency of the document.
CuryIDDefault Navigation
nvarchar(5)CurrencyCurrency
Description:Code of the Currency of the document. Defaults to the company's base currency.
CuryInfoID
bigint-
Description:The identifier of the CurrencyInfo object associated with the document. Corresponds to the CurrencyInfoID field.
CuryLineTotal
decimalDetail Total-
Description:The document total presented in the currency of the document. (See CuryID)
CuryOrigDocAmt
decimalAmount-
Description:The amount of the document. Given in the currency of the document.
CuryTaxTotal
decimalTax Total-
Description:No description available
CuryVatExemptTotal
decimalVAT Exempt Total-
Description:The part of the document total that is exempt from VAT. This total is calculated as a sum of the taxable amounts for the taxes of type VAT, which are marked as exempt and are neither statistical nor reverse. (Presented in the currency of the document, see CuryID)
CuryVatTaxableTotal
decimalVAT Taxable Total-
Description:The part of the document total, which is subject to VAT. This total is calculated as a sum of the taxable amounts for the taxes of type VAT, which are neither exempt, nor statistical, nor reverse. (Presented in the currency of the document, see CuryID)
DiscAmt
decimal-
Description:No description available
DiscDate
datetime2Cash Discount Date-
Description:No description available
DocBal
decimal-
Description:The open balance of the document. Given in the base currency of the company.
DocDate
datetime2Date-
Description:Date of the document.
DueDate
datetime2Due Date-
Description:No description available
FinPeriodIDDefault Navigation
char(6)Post Period-
Description:No description available
Hold
bitHold-
Description:When set to "true" indicates that the document is on hold and thus cannot be released.
INDocCreated
bit-
Description:No description available
IsTaxValid
bitTax Is Up to Date-
Description:When "true", indicates that the amount of tax calculated with the external External Tax Provider is up to date. If this field equals "false", the document was updated since last synchronization with the Tax Engine and taxes might need recalculation.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
varchar(8)-
Description:No description available
LastModifiedDateTime
datetimeLast Modified On-
Description:No description available
LineCntr
int-
Description:Counter of the document lines, used internally to assign numbers to newly created lines. It is not recommended to rely on this fields to determine the exact count of lines, because it might not reflect the latter under various conditions.
LineTotal
decimal-
Description:The document total presented in the base currency of the company. (See Company.BaseCuryID)
NonTaxable
bitNon-Taxable-
Description:Get or set NonTaxable that mark current document does not impose sales taxes.
OpenDoc
bitOpen-
Description:When set to "true" indicates that the document is open.
OrigDocAmt
decimal-
Description:The amount of the document. Given in the base currency of the company.
OwnerIDDefault Navigation
intOwnerContact
Description:No description available
PayToVendorIDDefault Navigation
intPay-to VendorVendor
Description:A reference to the Vendor. An integer identifier of the vendor, whom the AP bill will belong to.
Released
bitReleased-
Description:When set to "true" indicates that the document was released.
SelectedNonexistent in DB
bitSelected-
Description:No description available
Status
char(1)Status-
Description:Status of the document. The field is calculated based on the values of status flag. It can't be changed directly. The fields tht determine status of a document are: POLandedCostDocStatus.Hold, POLandedCostDocStatus.Balanced, POLandedCostDocStatus.Released. Possible values are: ""H"" - Hold, ""B"" - Balanced, ""R"" - Released. Defaults to Hold.
TaxTotal
decimalTax Total-
Description:No description available
TaxZoneIDDefault Navigation
nvarchar(10)Vendor Tax ZoneTaxZone
Description:No description available
TermsIDDefault Navigation
nvarchar(10)TermsTerms
Description:No description available
TranPeriodID
char(6)Transaction Period-
Description:Financial Period of the document. Determined by the date of the document. Unlike POLandedCostDoc.FinPeriodID the value of this field can't be overriden by user.
tstamp
timestamp-
Description:No description available
VatExemptTotal
decimal-
Description:The part of the document total that is exempt from VAT. This total is calculated as a sum of the taxable amounts for the taxes of type VAT, which are marked as exempt and are neither statistical nor reverse. (Presented in the base currency of the company, see Company.BaseCuryID)
VatTaxableTotal
decimal-
Description:The part of the document total, which is subject to VAT. This total is calculated as a sum of the taxable amounts for the taxes of type VAT, which are neither exempt, nor statistical, nor reverse. (Presented in the base currency of the company, see Company.BaseCuryID)
VendorIDDefault Navigation
intVendorBAccount
Description:Identifier of the Vendor, whom the document belongs to.
VendorLocationIDDefault Navigation
intLocationLocation
Description:No description available
VendorRefNbr
nvarchar(40)Vendor Ref.-
Description:No description available
WorkgroupIDDefault Navigation
intWorkgroupEPCompanyTree
Description:No description available