APTran

PX.Objects.AP

136 of 136 fields

	Field Name	Type	Display Name	Foreign Key
	`LineNbr`	`int`	Line Nbr.	-
Description:The number of the transaction line in the document. Note that the sequence of line numbers of the transactions belonging to a single document may include gaps.
	`RefNbr`	`nvarchar(15)`	Reference Nbr.	APInvoice
Description:Reference number of the parent document.
	`TranType`	`char(3)`	Tran. Type	-
Description:The type of the transaction. The field is determined by the type of the parent document. For the list of possible values see APRegister.DocType.
	`AccountID`Default Navigation	`int`	Account	Account
Description:No description available
	`AccrueCost`	`bit`	Accrue Cost	-
Description:No description available
	`AllowControlAccountForModule`Nonexistent in DB	`nvarchar(MAX)`		-
Description:No description available
	`AutomaticDiscountsDisabled`	`bit`		-
Description:No description available
	`BaseQty`	`decimal(25, 6)`	Base Qty.	-
Description:No description available
	`BaseUnreceivedQty`	`decimal(25, 6)`		-
Description:No description available
	`Box1099`Default Navigation	`smallint`	1099 Box	AP1099Box
Description:Identifier of the 1099 Box associated with the line. Defaults to the 1099 Box associated with the expense account or with the vendor.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:Identifier of the Branch, to which the transaction belongs. Corresponds to the Branch.BranchID field.
	`CalculateDiscountsOnImport`Nonexistent in DB	`bit`	Calculate automatic discounts on import	-
Description:No description available
	`CanViewDeferralSchedule`	`bit`		-
Description:No description available
	`CashDiscBal`	`decimal(19, 4)`		-
Description:No description available
	`ClassID`Default NavigationNonexistent in DB	`int`	Asset Class	FixedAsset
Description:No description available
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CuryCashDiscBal`	`decimal(19, 4)`	Cash Discount Balance	-
Description:No description available
	`CuryDiscAmt`	`decimal(19, 4)`	Discount Amount	-
Description:The amount of the line-level discount that has been applied manually or automatically. This field is relevant only if the Vendor Discounts feature is enabled. (Presented in the currency of the document, see APRegister.CuryID)
	`CuryDiscCost`	`decimal`	Disc. Unit Cost	-
Description:The unit cost of the item or service associated with the line after discount. (Presented in the currency of the document, see APRegister.CuryID)
	`CuryExpenseAmt`	`decimal(19, 4)`		-
Description:No description available
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:Identifier of the CurrencyInfo object associated with the transaction. Generated automatically. Corresponds to the CurrencyInfo.CurrencyInfoID field.
	`CuryLineAmt`	`decimal(19, 4)`	Ext. Cost	-
Description:The extended cost of the item or service associated with the line, which is the unit price multiplied by the quantity. (Presented in the currency of the document, see APRegister.CuryID)
	`CuryOrigRetainageAmt`	`decimal(19, 4)`	Original Retainage	-
Description:No description available
	`CuryOrigTaxableAmt`	`decimal(19, 4)`	Taxable Amount	-
Description:No description available
	`CuryOrigTaxAmt`	`decimal(19, 4)`	Tax Amount	-
Description:No description available
	`CuryOrigTranAmt`	`decimal(19, 4)`	Original Amount	-
Description:No description available
	`CuryPrepaymentAmt`	`decimal(19, 4)`	Prepayment Amount	-
Description:No description available
	`CuryRetainageAmt`	`decimal(19, 4)`	CuryRetainageAmt	-
Description:No description available
	`CuryRetainageBal`	`decimal(19, 4)`	Unreleased Retainage	-
Description:No description available
	`CuryRetainedTaxableAmt`	`decimal(19, 4)`	Retained Taxable Amount	-
Description:No description available
	`CuryRetainedTaxAmt`	`decimal(19, 4)`	Retained Tax	-
Description:No description available
	`CuryTaxableAmt`	`decimal(19, 4)`	Net Amount	-
Description:No description available
	`CuryTaxAmt`	`decimal(19, 4)`	VAT	-
Description:No description available
	`CuryTranAmt`	`decimal(19, 4)`	Amount	-
Description:No description available
	`CuryTranBal`	`decimal(19, 4)`	Balance	-
Description:No description available
	`CuryUnitCost`	`decimal(19, 6)`	Unit Cost	-
Description:The unit cost of the item or service received from the vendor and associated with the line. (Presented in the currency of the document, see APRegister.CuryID)
	`Custodian`Default NavigationNonexistent in DB	`uniqueidentifier`	Custodian	EPEmployee
Description:The employee responsible for the line.
	`Date`	`datetime2`	Expense Date	-
Description:Expense date. When an expense claim is released this field is set to the expense date in the resulting AP transactions.
	`DeferredCode`Default Navigation	`nvarchar(10)`	Deferral Code	DRDeferredCode
Description:No description available
	`DefScheduleID`Default Navigation	`int`	Original Deferral Schedule	DRSchedule
Description:No description available
	`DiscAmt`	`decimal(19, 4)`		-
Description:The amount of the line-level discount that has been applied manually or automatically. This field is relevant only if the Vendor Discounts feature is enabled. (Presented in the base currency of the company, see Company.BaseCuryID)
	`DiscCost`	`decimal`		-
Description:The unit cost of the item or service associated with the line after discount. (Presented in the base currency of the company, see Company.BaseCuryID)
	`DiscountID`Default Navigation	`nvarchar(10)`	Discount Code	APDiscount
Description:No description available
	`DiscountsAppliedToLine`	`varbinary(MAX)`		-
Description:No description available
	`DiscountSequenceID`	`nvarchar(10)`	Discount Sequence	-
Description:The identifier of the discount sequence applied to the line.
	`DiscPct`	`decimal(9, 6)`	Discount Percent	-
Description:The percent of the line-level discount, that has been applied manually or automatically. This field is relevant only if the Vendor Discounts feature is enabled.
	`DocumentDiscountRate`	`decimal(21, 18)`		-
Description:The effective rate of the document-level discount associated with the line.
	`DrCr`	`char(1)`		-
Description:Indicates whether the line is of debit or credit type. Is set to the parent's APInvoice.DrCr by default.
	`DropshipExpenseRecording`	`char(1)`		-
Description:No description available
	`DRTermEndDate`	`datetime2`	Term End Date	-
Description:No description available
	`DRTermStartDate`	`datetime2`	Term Start Date	-
Description:No description available
	`EmployeeID`	`int`		-
Description:Identifier of the Employee who created the document line. Corresponds to the EPEmployee.BAccountID field. This field is not visible to user and cannot be changed by them.
	`ExpectedPPVAmount`	`decimal(19, 4)`	Estimated PPV Amount	-
Description:Expected purchase price variance amount associated with the line. (Presented in the base currency of the company, see Company.BaseCuryID) The final amount will be presented in the POPPVAmt after the AP document release.
	`ExpenseAmt`	`decimal(19, 4)`		-
Description:No description available
	`FinPeriodID`	`char(6)`		-
Description:No description available
	`FreezeManualDisc`Nonexistent in DB	`bit`		-
Description:No description available
	`GroupDiscountRate`	`decimal(21, 18)`		-
Description:The effective rate of the group-level discount associated with the line.
	`InventoryID`Default Navigation	`int`	Inventory ID	InventoryItem
Description:Identifier of the inventory item associated with the transaction. Corresponds to the InventoryItem.InventoryID field.
	`IsDirectTaxLine`	`bit`		-
Description:Indicates whether the line is direct tax line or not.
	`IsStockItem`	`bit`		-
Description:No description available
	`LandedCostCodeID`Default Navigation	`nvarchar(15)`	Landed Cost Code	LandedCostCode
Description:The landed cost code used to describe the specific landed costs incurred for the line. This code is one of the codes associated with the vendor. Corresponds to the LandedCostCode.LandedCostCodeID field.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`LCDocType`	`char(1)`	LC Type	-
Description:The type of the corresponding Landed Cost Document. Together with LCRefNbr and LCLineNbr links APTrans to the PO Orders and their lines. Corresponds to the POOrder.OrderType field. See its description for the list of allowed values.
	`LCLineNbr`	`int`	LC Line	POLandedCostDetail
Description:No description available
	`LCRefNbr`Default Navigation	`nvarchar(15)`	LC Number	POLandedCostDoc
Description:The reference number of the corresponding Landed Cost Document. Together with LCDocType and LCLineNbr links APTrans to the PO Orders and their lines. Corresponds to the POLandedCostDoc.RefNbr field.
	`LineAmt`	`decimal(19, 4)`		-
Description:The extended cost of the item or service associated with the line, which is the unit price multiplied by the quantity. (Presented in the base currency of the company, see Company.BaseCuryID)
	`LineType`	`char(2)`		-
Description:The type of the transaction line. This field is used to distinguish Discount lines from other ones. Equals ""DS"" for discounts, ""LA"" for landed-cost transactions created in AP, ""LP"" for landed-cost transactions created from PO, and empty string for common lines.
	`ManualDisc`	`bit`	Manual Discount	-
Description:When set to "true" indicates that the discount is applied to the line manually. In this case user may enter either the discount percent, or the discount amount or a predefined discount code. This field is relevant only if the Vendor Discounts feature is enabled.
	`ManualPrice`	`bit`	Manual Cost	-
Description:No description available
	`NonBillable`	`bit`	Non Billable	-
Description:When set to "true" indicates that the document line is not billable in the project. The field is relevant only in case Project module is enabled.
	`NoteID`	`uniqueidentifier`		-
Description:Identifier of the Note object, associated with the line. Corresponds to the Note.NoteID field.
	`OrigDocumentDiscountRate`	`decimal(21, 18)`		-
Description:No description available
	`OrigGroupDiscountRate`	`decimal(21, 18)`		-
Description:No description available
	`OrigLineNbr`	`int`		-
Description:No description available
	`OrigRetainageAmt`	`decimal(19, 4)`		-
Description:No description available
	`OrigTaxableAmt`	`decimal(19, 4)`		-
Description:The line amount included into line balance. (Presented in the base currency of the company, see Company.BaseCuryID)
	`OrigTaxAmt`	`decimal(19, 4)`		-
Description:The amount of tax included into line balance. (Presented in the base currency of the company, see Company.BaseCuryID)
	`OrigTranAmt`	`decimal(19, 4)`		-
Description:No description available
	`POAccrualLineNbr`	`int`		-
Description:No description available
	`POAccrualRefNoteID`	`uniqueidentifier`		-
Description:No description available
	`POAccrualType`	`char(1)`	Billing Based On	-
Description:No description available
	`POLineNbr`	`int`	PO Line	POLine
Description:The line number of the corresponding PO Line. Together with POOrderType and PONbr links AP transactions to the PO Orders and their lines. Corresponds to the POLine.LineNbr field.
	`PONbr`Default Navigation	`nvarchar(15)`	PO Number	POOrder
Description:The reference number of the corresponding PO Order. Together with POOrderType and POLineNbr links APTrans to the PO Orders and their lines. Corresponds to the POOrder.OrderNbr field.
	`POOrderType`	`char(2)`	PO Type	-
Description:The type of the corresponding PO Order. Together with PONbr and POLineNbr links APTrans to the PO Orders and their lines. Corresponds to the POOrder.OrderType field. See its description for the list of allowed values.
	`POPPVAmt`	`decimal(19, 4)`	PO PPV Amount	-
Description:Purchase price variance amount associated with the line. (Presented in the base currency of the company, see Company.BaseCuryID)
	`PPVDocType`	`char(3)`	PPV Doc. Type	-
Description:No description available
	`PPVRefNbr`Default Navigation	`nvarchar(15)`	PPV Ref. Nbr.	INRegister
Description:No description available
	`PrepaymentAmt`	`decimal(19, 4)`		-
Description:No description available
	`PrepaymentPct`	`decimal(9, 6)`	Prepayment Percent	-
Description:No description available
	`PrevPOLineNbr`	`int`		-
Description:No description available
	`ProjectID`Default Navigation	`int`	Project	PMProject
Description:The project with which the item is associated or the non-project code if the item is not intended for any project. The field is relevant only if the Project Module is enabled. Corresponds to the PMProject.ProjectID field.
	`ProjectReclassified`Nonexistent in DB	`bit`		-
Description:No description available
	`Qty`	`decimal(25, 6)`	Quantity	-
Description:The quantity of the items or services associated with the line delivered by the vendor.
	`ReceiptLineNbr`	`int`	PO Receipt Line	POReceiptLine
Description:The number of the corresponding line in the related PO Receipt. Together with ReceiptNbr field links AP transactions to PO Receipts and their lines. Corresponds to the POReceiptLine.LineNbr field.
	`ReceiptNbr`Default Navigation	`nvarchar(15)`	PO Receipt Nbr.	POReceipt
Description:The reference number of the corresponding PO Receipt. Together with ReceiptLineNbr field links AP transactions to PO Receipts and their lines. Corresponds to the POReceipt.ReceiptNbr field.
	`ReceiptType`	`char(2)`	PO Receipt Type	-
Description:No description available
	`Reclassified`	`bit`		-
Description:No description available
	`Released`	`bit`	Released	-
Description:Indicates whether the line is released or not.
	`RequiresTerms`Nonexistent in DB	`bit`		-
Description:When set to "true", indicates that the DRTermStartDate and DRTermEndDate fields are enabled and should be filled for the line. The value of this field is set by the ARInvoiceEntry and ARCashSaleEntry graphs based on the settings of the item and the Deferral Code selected for the line. In other contexts it is not populated. See the attribute on the ARInvoiceEntry.ARTran_RequiresTerms_CacheAttached handler for details.
	`RetainageAmt`	`decimal(19, 4)`		-
Description:No description available
	`RetainageBal`	`decimal(19, 4)`		-
Description:No description available
	`RetainagePct`	`decimal(9, 6)`	RetainagePct	-
Description:No description available
	`RetainedTaxableAmt`	`decimal(19, 4)`		-
Description:The line amount that is subject to retained tax. (Presented in the base currency of the company, see Company.BaseCuryID)
	`RetainedTaxAmt`	`decimal(19, 4)`		-
Description:The amount of retained tax (VAT) associated with the line. (Presented in the base currency of the company, see Company.BaseCuryID)
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:Indicates whether the record is selected for mass processing or not.
	`SignedCuryTranAmt`Nonexistent in DB	`decimal`		-
Description:Read-only field showing the signed line amount. Based on the CuryTranAmt and Sign fields. (Presented in the currency of the document, see APRegister.CuryID)
	`SignedQty`Nonexistent in DB	`decimal`		-
Description:Read-only field showing the line quantity multiplied by the line sign. Based on the Qty and Sign fields.
	`SignedTranAmt`Nonexistent in DB	`decimal`		-
Description:Read-only field showing the signed line amount. Based on the CuryTranAmt and Sign fields. (Presented in the base currency of the company, see Company.BaseCuryID)
	`SiteID`	`int`		INSite
Description:No description available
	`SkipDisc`Nonexistent in DB	`bit`		-
Description:No description available
	`SortOrder`	`int`	Line Order	-
Description:No description available
	`SubID`Default Navigation	`int`	Subaccount	Sub
Description:Identifier of the Subaccount associated with the transaction. Corresponds to the Sub.SubID field. Defaults to the Cost of Goods Sold subaccount associated with the inventory item.
	`SubItemID`Default Navigation	`int`	Subitem	INSubItem
Description:No description available
	`SuppliedByVendorID`Nonexistent in DB	`int`		Vendor
Description:A reference to the Vendor. This is non-database field. The field needs only for the discount calculation An integer identifier of the vendor that supplied the goods.
	`TaskID`Default Navigation	`int`	Project Task	PMTask
Description:No description available
	`TaxableAmt`	`decimal(19, 4)`		-
Description:The line amount that is subject to tax. (Presented in the base currency of the company, see Company.BaseCuryID)
	`TaxAmt`	`decimal(19, 4)`		-
Description:The amount of tax (VAT) associated with the line. (Presented in the base currency of the company, see Company.BaseCuryID)
	`TaxCategoryID`Default Navigation	`nvarchar(15)`	Tax Category	TaxCategory
Description:No description available
	`TaxID`Default Navigation	`nvarchar(60)`	Tax ID	Tax
Description:The identifier of the tax associated with the line.
	`TranAmt`	`decimal(19, 4)`	Amount	-
Description:The total amount for the specified quantity of items or services of this type (after discount has been taken), or the amount of debit adjustment or prepayment. (Presented in the base currency of the company, see Company.BaseCuryID)
	`TranBal`	`decimal(19, 4)`	Balance	-
Description:No description available
	`TranClass`	`char(1)`		-
Description:No description available
	`TranDate`	`datetime2`	Document Date	-
Description:The date of the transaction. Defaults to the date of the parent document.
	`TranDesc`	`nvarchar(256)`	Transaction Descr.	-
Description:The description text for the transaction.
	`TranID`Obsolete	`int`		-
Description:Internal unique identifier of the transaction line. The value is an auto-generated database identity.
	`TranPeriodID`	`char(6)`		-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available
	`UnitCost`	`decimal(19, 6)`		-
Description:No description available
	`UnreceivedQty`	`decimal(25, 6)`		-
Description:No description available
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:The unit of measure for the transaction. Corresponds to the INUnit.FromUnit field.
	`VendorID`Default Navigation	`int`	Vendor	Vendor
Description:Identifier of the Vendor, whom the parent document belongs.