APTran2

PX.Objects.APRelease 2025.2

No summary is documented for this DAC in the release source.

Select a row for its description 151 of 151 fields

	Field Name	Type	Display Name	Foreign Key
	`AccountID`Default Navigation	`int`	Account	Account
Description:Identifier of the expense account to be updated by the transaction. Corresponds to the Account.AccountID field. Defaults to the Cost of Goods Sold account associated with the inventory item.
	`AccrueCost`	`bit`	Accrue Cost	-
Description:When set to "true", indicates that cost will be processed using expense accrual account.
	`AllowControlAccountForModule`Nonexistent in DB	`string`		-
Description:No description available
	`AppointmentLineNbr`	`int`	Appointment Line Nbr.	-
Description:No description available
	`AppointmentRefNbr`	`nvarchar(20)`	Appointment Nbr.	-
Description:No description available
	`AutomaticDiscountsDisabled`	`bit`		-
Description:No description available
	`BaseQty`	`decimal`	Base Qty.	-
Description:No description available
	`BaseUnreceivedQty`	`decimal`		-
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	`bool?`	Calculate automatic discounts on import	-
Description:No description available
	`CashDiscBal`	`decimal`		-
Description:No description available
	`ClassID`Default NavigationNonexistent in DB	`int?`	Asset Class	FixedAsset
Description:The class of asset associated with the line. Corresponds to the FixedAsset.AssetID field.
	`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`	Cash Discount Balance	-
Description:No description available
	`CuryDiscAmt`	`decimal`	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`Nonexistent in DB	`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`		-
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`	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`	Original Retainage	-
Description:No description available
	`CuryOrigTaxAmt`	`decimal`	Tax Amount	-
Description:The amount of tax included into line balance. (Presented in the currency of the document, see APRegister.CuryID)
	`CuryOrigTaxableAmt`	`decimal`	Taxable Amount	-
Description:The line amount included into line balance. (Presented in the currency of the document, see APRegister.CuryID)
	`CuryOrigTranAmt`	`decimal`	Original Amount	-
Description:No description available
	`CuryPrepaymentAmt`	`decimal`	Prepayment Amount	-
Description:No description available
	`CuryRetainageAmt`	`decimal`		-
Description:No description available
	`CuryRetainageBal`	`decimal`	Unreleased Retainage	-
Description:No description available
	`CuryRetainedTaxAmt`	`decimal`	Retained Tax	-
Description:The amount of retained tax (VAT) associated with the line. (Presented in the currency of the document, see APRegister.CuryID)
	`CuryRetainedTaxableAmt`	`decimal`	Retained Taxable Amount	-
Description:The line amount that is subject to retained tax. (Presented in the currency of the document, see APRegister.CuryID)
	`CuryTaxAmt`	`decimal`	VAT	-
Description:The amount of tax (VAT) associated with the line. (Presented in the currency of the document, see APRegister.CuryID)
	`CuryTaxableAmt`	`decimal`	Net Amount	-
Description:The line amount that is subject to tax. (Presented in the currency of the document, see APRegister.CuryID)
	`CuryTranAmt`	`decimal`	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 currency of the document, see APRegister.CuryID)
	`CuryTranBal`	`decimal`	Balance	-
Description:No description available
	`CuryUnitCost`	`decimal`	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	`Guid?`	Custodian	EPEmployee
Description:The employee responsible for the line.
	`DRTermEndDate`	`datetime`	Term End Date	-
Description:No description available
	`DRTermStartDate`	`datetime`	Term Start Date	-
Description:No description available
	`Date`	`datetime`	Expense Date	-
Description:Expense date. When an expense claim is released this field is set to the expense date in the resulting AP transactions.
	`DefScheduleID`Default Navigation	`int`	Original Deferral Schedule	DRSchedule
Description:A read-only field that shows the identifier of the schedule automatically assigned to the bill based on the deferral code. Corresponds to the DRSchedule.ScheduleID field.
	`DeferredCode`Default Navigation	`nvarchar(10)`	Deferral Code	DRDeferredCode
Description:The field holds one of the deferral codes defined in the system if the bill represents deferred expense. Corresponds to the deferral code associated with the inventory item with "Expense" account type.
	`DiscAmt`	`decimal`		-
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`Nonexistent in DB	`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)
	`DiscPct`	`decimal`	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.
	`DiscountID`Default Navigation	`nvarchar(10)`	Discount Code	APDiscount
Description:The code of the discount that has been applied to this line. This field is relevant only if the Vendor Discounts feature is enabled. Corresponds to the APDiscount.DiscountID field.
	`DiscountSequenceID`	`nvarchar(10)`	Discount Sequence	-
Description:The identifier of the discount sequence applied to the line.
	`DiscountsAppliedToLine`	`varbinary`		-
Description:No description available
	`DocumentDiscountRate`	`decimal`		-
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`	`nvarchar(1)`		-
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`	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`		-
Description:No description available
	`FinPeriodID`	`string`		-
Description:Financial period, which the line is associated with. Defaults to the document's financial period.
	`FreezeManualDisc`Nonexistent in DB	`bool?`		-
Description:No description available
	`GroupDiscountRate`	`decimal`		-
Description:The effective rate of the group-level discount associated with the line.
	`HasExpiredComplianceDocuments`Nonexistent in DB	`bool?`	Expired Compliance	-
Description:No description available
	`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.
	`IsDocBilledOrClosed`Nonexistent in DB	`bool?`		-
Description:No description available
	`IsStockItem`	`bit`		-
Description:No description available
	`LCDocType`	`char(1)`	LC Type	POLandedCostDoc
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:The line number of the corresponding Landed Cost Document Detail. Together with LCDocType and LCRefNbr links AP transactions to the Landed Cost Document and their lines. Corresponds to the POLine.LineNbr field.
	`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.
	`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
	`LineAmt`	`decimal`		-
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)
	`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.
	`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
	`Mem_PreviousPostID`Nonexistent in DB	`int?`		-
Description:No description available
	`Mem_TableSource`Nonexistent in DB	`string`		-
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 Accounting feature is enabled.
	`NoteID`	`uniqueidentifier`		-
Description:Identifier of the Note object, associated with the line. Corresponds to the Note.NoteID field.
	`OrigDocumentDiscountRate`	`decimal`		-
Description:No description available
	`OrigGroupDiscountRate`	`decimal`		-
Description:No description available
	`OrigLineNbr`	`int`		-
Description:No description available
	`OrigRetainageAmt`	`decimal`		-
Description:No description available
	`OrigTaxAmt`	`decimal`		-
Description:The amount of tax included into line balance. (Presented in the base currency of the company, see Company.BaseCuryID)
	`OrigTaxableAmt`	`decimal`		-
Description:The line amount included into line balance. (Presented in the base currency of the company, see Company.BaseCuryID)
	`OrigTranAmt`	`decimal`		-
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	POOrder
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`	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`		-
Description:No description available
	`PrepaymentPct`	`decimal`	Prepayment Percent	-
Description:No description available
	`PrevPOLineNbr`	`int`		-
Description:The previous PO Line nbr before bill reclassifying
	`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 Accounting feature is enabled. Corresponds to the PMProject.ProjectID field.
	`ProjectReclassified`Nonexistent in DB	`bool?`		-
Description:True if the line's Project was changed
	`Qty`	`decimal`	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	POReceipt
Description:No description available
	`Reclassified`	`bit`		-
Description:True if the line was reclassified
	`RefNbr`	`nvarchar(15)`	Reference Nbr.	APRegister
Description:Reference number of the parent document.
	`RelatedDocNoteID`	`uniqueidentifier`	Related Svc. Doc. Nbr.	-
Description:No description available
	`RelatedEntityType`	`nvarchar(40)`	Related Svc. Doc. Type	-
Description:No description available
	`Released`	`bit`	Released	-
Description:Indicates whether the line is released or not.
	`RequiresTerms`Nonexistent in DB	`bool?`		-
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`		-
Description:No description available
	`RetainageBal`	`decimal`		-
Description:No description available
	`RetainagePct`	`decimal`		-
Description:No description available
	`RetainedTaxAmt`	`decimal`		-
Description:The amount of retained tax (VAT) associated with the line. (Presented in the base currency of the company, see Company.BaseCuryID)
	`RetainedTaxableAmt`	`decimal`		-
Description:The line amount that is subject to retained tax. (Presented in the base currency of the company, see Company.BaseCuryID)
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:Indicates whether the record is selected for mass processing or not.
	`ServiceContractPeriodID`Nonexistent in DB	`int?`		-
Description:No description available
	`ServiceContractRefNbr`Nonexistent in DB	`string`		-
Description:No description available
	`ServiceOrderLineNbr`	`int`	Service Order Line Nbr.	-
Description:No description available
	`ServiceOrderRefNbr`	`nvarchar(15)`	Service Order Nbr.	-
Description:No description available
	`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	`bool?`		-
Description:No description available
	`SortOrder`	`int`	Line Order	-
Description:No description available
	`SrvOrdType`	`char(4)`	Service Order Type	-
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
	`SubcontractLineNbr`Default NavigationNonexistent in DB	`int?`	Subcontract Line	POLine
Description:No description available
	`SubcontractNbr`Nonexistent in DB	`string`	Subcontract Nbr.	-
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.
	`T5018Service`	`bit`	T5018 Service	-
Description:Flag the indicates that this line should be considered a construction service for the purpose of T5018 report generation.
	`TaskID`Default Navigation	`int`	Project Task	PMTask
Description:Identifier of the particular task associated with the transaction. The task belongs to the selected project Corresponds to the PMTask.TaskID field.
	`TaxAmt`	`decimal`		-
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:Identifier of the tax category associated with the line. Corresponds to the TaxCategory.TaxCategoryID field. Defaults to the tax category associated with the line item.
	`TaxID`Default Navigation	`nvarchar(60)`	Tax ID	Tax
Description:The identifier of the tax associated with the line.
	`TaxableAmt`	`decimal`		-
Description:The line amount that is subject to tax. (Presented in the base currency of the company, see Company.BaseCuryID)
	`TranAmt`	`decimal`	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`	Balance	-
Description:No description available
	`TranClass`	`char(1)`		-
Description:No description available
	`TranDate`	`datetime`	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`	`string`		-
Description:No description available
	`TranType`	`char(3)`	Tran. Type	APRegister
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.
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:The unit of measure for the transaction. Corresponds to the INUnit.FromUnit field.
	`UnitCost`	`decimal`		-
Description:/// The unit cost of the item or service received from the vendor and associated with the line. (Presented in the base currency of the company, see Company.BaseCuryID)
	`UnreceivedQty`	`decimal`		-
Description:No description available
	`VendorID`Default Navigation	`int`	Vendor	Vendor
Description:Identifier of the Vendor, whom the parent document belongs.
	`tstamp`	`timestamp`		-
Description:No description available