POLandedCostDoc

PX.Objects.PO

54 of 54 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`Default Navigation	`nvarchar(15)`	Reference Nbr.	-
Description:No description available
	`AllocatedTotal`	`decimal(19, 4)`		-
Description:The total allocated amount of the document. Given in the base currency of the company.
	`APDocCreated`	`bit`		-
Description:No description available
	`BillDate`	`datetime2`	Bill Date	-
Description:No description available
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:No description available
	`ControlTotal`	`decimal(19, 4)`		-
Description:No description available
	`CreateBill`	`bit`	Create Bill	-
Description:Get or set CreateBill that mark current document create bill on release.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CuryAllocatedTotal`	`decimal(19, 4)`	Total Allocated Amount	-
Description:The total allocated amount of the document. Given in the currency of the document.
	`CuryControlTotal`	`decimal(19, 4)`	Control Total	-
Description:No description available
	`CuryDiscAmt`	`decimal(19, 4)`	Cash Discount	-
Description:No description available
	`CuryDocTotal`	`decimal(19, 4)`	Document Total	-
Description:The document total presented in the currency of the document. (See CuryID)
	`CuryID`Default Navigation	`nvarchar(5)`	Currency	Currency
Description:Code of the Currency of the document. Defaults to the company's base currency.
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:The identifier of the CurrencyInfo object associated with the document. Corresponds to the CurrencyInfoID field.
	`CuryLineTotal`	`decimal(19, 4)`	Amount Total	-
Description:The document total presented in the currency of the document. (See CuryID)
	`CuryTaxTotal`	`decimal(19, 4)`	Tax Total	-
Description:No description available
	`CuryVatExemptTotal`	`decimal(19, 4)`	Tax 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(19, 4)`	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(19, 4)`		-
Description:No description available
	`DiscDate`	`datetime2`	Cash Discount Date	-
Description:No description available
	`DocDate`	`datetime2`	Date	-
Description:Date of the document.
	`DocTotal`	`decimal(19, 4)`		-
Description:The document total presented in the base currency of the company. (See Company.BaseCuryID)
	`DueDate`	`datetime2`	Due Date	-
Description:No description available
	`FinPeriodID`Default Navigation	`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`Default Navigation	`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
	`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(19, 4)`		-
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.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OpenDoc`	`bit`	Open	-
Description:When set to "true" indicates that the document is open.
	`OwnerID`Default Navigation	`int`	Owner	Contact
Description:No description available
	`PayToVendorID`Default Navigation	`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.
	`Selected`Nonexistent 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(19, 4)`		-
Description:No description available
	`TaxZoneID`Default Navigation	`nvarchar(10)`	Vendor Tax Zone	TaxZone
Description:No description available
	`TermsID`Default Navigation	`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(19, 4)`		-
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(19, 4)`		-
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`Default Navigation	`int`	Vendor	BAccount
Description:Identifier of the Vendor, whom the document belongs to.
	`VendorLocationID`Default Navigation	`int`	Location	Location
Description:No description available
	`VendorRefNbr`	`nvarchar(40)`	Vendor Ref.	-
Description:No description available
	`WorkgroupID`Default Navigation	`int`	Workgroup	EPCompanyTree
Description:No description available