PO
POLandedCostDocS
PX.Objects.PO53 of 53 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocType | char(1) | Type | - | |
Description:Type of the document. Possible values are: "LC" - Landed Cost, "LCC" - Correction, "LCR" - Reversal. | ||||
RefNbr | nvarchar(15) | Reference Nbr. | POLandedCostDoc | |
Description:No description available | ||||
APDocCreated | bit | - | ||
Description:No description available | ||||
BillDate | datetime2 | Bill Date | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
ControlTotal | decimal | - | ||
Description:No description available | ||||
CreateBill | bit | Create Bill | - | |
Description:Get or set CreateBill that mark current document create bill on release. | ||||
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 | ||||
CuryDiscAmt | decimal | Cash Discount | - | |
Description:No description available | ||||
CuryDocBal | decimal | Balance | - | |
Description:The open balance of the document. Given in the currency of the document. | ||||
CuryID | nvarchar(5) | Currency | Currency | |
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 | decimal | Detail Total | - | |
Description:The document total presented in the currency of the document. (See CuryID) | ||||
CuryOrigDocAmt | decimal | Amount | - | |
Description:The amount of the document. Given in the currency of the document. | ||||
CuryTaxTotal | decimal | Tax Total | - | |
Description:No description available | ||||
CuryVatExemptTotal | decimal | VAT 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 | decimal | VAT 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 | datetime2 | Cash Discount Date | - | |
Description:No description available | ||||
DocBal | decimal | - | ||
Description:The open balance of the document. Given in the base currency of the company. | ||||
DocDate | datetime2 | Date | - | |
Description:Date of the document. | ||||
DueDate | datetime2 | Due Date | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:When set to "true" indicates that the document is on hold and thus cannot be released. | ||||
INDocCreated | bit | - | ||
Description:No description available | ||||
IsTaxValid | bit | Tax 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. | ||||
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: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 | bit | Non-Taxable | - | |
Description:Get or set NonTaxable that mark current document does not impose sales taxes. | ||||
OpenDoc | bit | Open | - | |
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. | ||||
OwnerID | int | Owner | Contact | |
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. | ||||
Released | bit | Released | - | |
Description:When set to "true" indicates that the document was released. | ||||
SelectedNonexistent in DB | bit | Selected | - | |
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 | decimal | Tax Total | - | |
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Vendor Tax Zone | TaxZone | |
Description:No description available | ||||
TermsID | nvarchar(10) | Terms | Terms | |
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) | ||||
VendorID | int | Vendor | BAccount | |
Description:Identifier of the Vendor, whom the document belongs to. | ||||
VendorLocationID | int | Location | Location | |
Description:No description available | ||||
VendorRefNbr | nvarchar(40) | Vendor Ref. | - | |
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||