Skip to main content
AP

APRecognizedTran

PX.Objects.AP.InvoiceRecognition.DACRelease 2025.2

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

Field NameTypeDisplay NameForeign Key
AccountIDDefault Navigation
intAccountAccount
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
bitAccrue Cost-
Description:When set to "true", indicates that cost will be processed using expense accrual account.
AllowControlAccountForModuleNonexistent in DB
string-
Description:No description available
AlternateIDNonexistent in DB
stringAlternate ID-
Description:No description available
AppointmentLineNbr
intAppointment Line Nbr.-
Description:No description available
AppointmentRefNbr
nvarchar(20)Appointment Nbr.-
Description:No description available
AutomaticDiscountsDisabled
bit-
Description:No description available
BaseQty
decimalBase Qty.-
Description:No description available
BaseUnreceivedQty
decimal-
Description:No description available
Box1099Default Navigation
smallint1099 BoxAP1099Box
Description:Identifier of the 1099 Box associated with the line. Defaults to the 1099 Box associated with the expense account or with the vendor.
BranchIDDefault Navigation
intBranchBranch
Description:Identifier of the Branch, to which the transaction belongs. Corresponds to the Branch.BranchID field.
CalculateDiscountsOnImportNonexistent in DB
bool?Calculate automatic discounts on import-
Description:No description available
CashDiscBal
decimal-
Description:No description available
ClassIDDefault NavigationNonexistent in DB
int?Asset ClassFixedAsset
Description:The class of asset associated with the line. Corresponds to the FixedAsset.AssetID field.
CostCodeIDDefault Navigation
intCost CodePMCostCode
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
CuryCashDiscBal
decimalCash Discount Balance-
Description:No description available
CuryDiscAmt
decimalDiscount 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)
CuryDiscCostNonexistent 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
bigintCurrencyInfo
Description:Identifier of the CurrencyInfo object associated with the transaction. Generated automatically. Corresponds to the CurrencyInfo.CurrencyInfoID field.
CuryLineAmt
decimalExt. 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
decimalOriginal Retainage-
Description:No description available
CuryOrigTaxAmt
decimalTax Amount-
Description:The amount of tax included into line balance. (Presented in the currency of the document, see APRegister.CuryID)
CuryOrigTaxableAmt
decimalTaxable Amount-
Description:The line amount included into line balance. (Presented in the currency of the document, see APRegister.CuryID)
CuryOrigTranAmt
decimalOriginal Amount-
Description:No description available
CuryPrepaymentAmt
decimalPrepayment Amount-
Description:No description available
CuryRetainageAmt
decimal-
Description:No description available
CuryRetainageBal
decimalUnreleased Retainage-
Description:No description available
CuryRetainedTaxAmt
decimalRetained Tax-
Description:The amount of retained tax (VAT) associated with the line. (Presented in the currency of the document, see APRegister.CuryID)
CuryRetainedTaxableAmt
decimalRetained Taxable Amount-
Description:The line amount that is subject to retained tax. (Presented in the currency of the document, see APRegister.CuryID)
CuryTaxAmt
decimalVAT-
Description:The amount of tax (VAT) associated with the line. (Presented in the currency of the document, see APRegister.CuryID)
CuryTaxableAmt
decimalNet Amount-
Description:The line amount that is subject to tax. (Presented in the currency of the document, see APRegister.CuryID)
CuryTranAmt
decimalAmount-
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
decimalBalance-
Description:No description available
CuryUnitCost
decimalUnit 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)
CustodianDefault NavigationNonexistent in DB
Guid?CustodianEPEmployee
Description:The employee responsible for the line.
DRTermEndDate
datetimeTerm End Date-
Description:No description available
DRTermStartDate
datetimeTerm Start Date-
Description:No description available
Date
datetimeExpense Date-
Description:Expense date. When an expense claim is released this field is set to the expense date in the resulting AP transactions.
DefScheduleIDDefault Navigation
intOriginal Deferral ScheduleDRSchedule
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.
DeferredCodeDefault Navigation
nvarchar(10)Deferral CodeDRDeferredCode
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)
DiscCostNonexistent 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
decimalDiscount 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.
DiscountIDDefault Navigation
nvarchar(10)Discount CodeAPDiscount
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
decimalEstimated 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.
FreezeManualDiscNonexistent in DB
bool?-
Description:No description available
GroupDiscountRate
decimal-
Description:The effective rate of the group-level discount associated with the line.
HasExpiredComplianceDocumentsNonexistent in DB
bool?Expired Compliance-
Description:No description available
InternalAlternateIDDefault Navigation
intInventory ID-
Description:No description available
InventoryIDDefault Navigation
intInventory IDInventoryItem
Description:Identifier of the inventory item associated with the transaction. Corresponds to the InventoryItem.InventoryID field.
InventoryIDManualInputNonexistent in DB
bool?-
Description:No description available
IsDirectTaxLine
bit-
Description:Indicates whether the line is direct tax line or not.
IsDocBilledOrClosedNonexistent in DB
bool?-
Description:No description available
IsStockItem
bit-
Description:No description available
LCDocType
char(1)LC TypePOLandedCostDoc
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
intLC LinePOLandedCostDetail
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.
LCRefNbrDefault Navigation
nvarchar(15)LC NumberPOLandedCostDoc
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.
LandedCostCodeIDDefault Navigation
nvarchar(15)Landed Cost CodeLandedCostCode
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.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
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
intLine 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
bitManual 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
bitManual Cost-
Description:No description available
Mem_PreviousPostIDNonexistent in DB
int?-
Description:No description available
Mem_TableSourceNonexistent in DB
string-
Description:No description available
NonBillable
bitNon 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.
NumOfFoundIDByAlternateNonexistent in DB
int?-
Description:No description available
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
intPO LinePOLine
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.
POLinkStatusNonexistent in DB
stringPO Link Status-
Description:No description available
PONbrDefault Navigation
nvarchar(15)PO NumberPOOrder
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.
PONumberJsonNonexistent in DB
string-
Description:No description available
POOrderType
char(2)PO TypePOOrder
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
decimalPO 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
PPVRefNbrDefault Navigation
nvarchar(15)PPV Ref. Nbr.INRegister
Description:No description available
PrepaymentAmt
decimal-
Description:No description available
PrepaymentPct
decimalPrepayment Percent-
Description:No description available
PrevPOLineNbr
int-
Description:The previous PO Line nbr before bill reclassifying
ProjectIDDefault Navigation
intProjectPMProject
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.
ProjectReclassifiedNonexistent in DB
bool?-
Description:True if the line's Project was changed
Qty
decimalQuantity-
Description:The quantity of the items or services associated with the line delivered by the vendor.
ReceiptLineNbr
intPO Receipt LinePOReceiptLine
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.
ReceiptNbrDefault 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 TypePOReceipt
Description:No description available
Reclassified
bit-
Description:True if the line was reclassified
RecognizedPOLineNbrNonexistent in DB
int?PO Line-
Description:The number of the line of a recognized purchase order.
RecognizedPONumberNonexistent in DB
stringPO Number-
Description:No description available
RecognizedSubcontractLineNbrNonexistent in DB
int?Subcontract Line-
Description:The number of the recognized subcontract line.
RecognizedSubcontractNumberNonexistent in DB
stringSubcontract Nbr.-
Description:The recognized subcontract number.
RefNbr
nvarchar(15)Reference Nbr.APRegister
Description:Reference number of the parent document.
RelatedDocNoteID
uniqueidentifierRelated Svc. Doc. Nbr.-
Description:No description available
RelatedEntityType
nvarchar(40)Related Svc. Doc. Type-
Description:No description available
Released
bitReleased-
Description:Indicates whether the line is released or not.
RequiresTermsNonexistent 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)
SelectedNonexistent in DB
bool?Selected-
Description:Indicates whether the record is selected for mass processing or not.
ServiceContractPeriodIDNonexistent in DB
int?-
Description:No description available
ServiceContractRefNbrNonexistent in DB
string-
Description:No description available
ServiceOrderLineNbr
intService Order Line Nbr.-
Description:No description available
ServiceOrderRefNbr
nvarchar(15)Service Order Nbr.-
Description:No description available
SignedCuryTranAmtNonexistent 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)
SignedQtyNonexistent in DB
decimal?-
Description:Read-only field showing the line quantity multiplied by the line sign. Based on the Qty and Sign fields.
SignedTranAmtNonexistent 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
intINSite
Description:No description available
SkipDiscNonexistent in DB
bool?-
Description:No description available
SortOrder
intLine Order-
Description:No description available
SrvOrdType
char(4)Service Order Type-
Description:No description available
SubIDDefault Navigation
intSubaccountSub
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.
SubItemIDDefault Navigation
intSubitemINSubItem
Description:No description available
SubcontractLineNbrDefault NavigationNonexistent in DB
int?Subcontract LinePOLine
Description:No description available
SubcontractNbrNonexistent in DB
stringSubcontract Nbr.-
Description:No description available
SubcontractNumberJsonNonexistent in DB
stringSubcontract Number (JSON)-
Description:The position of the subcontract number in the recognized document. The position is in JSON format.
SuppliedByVendorIDNonexistent 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
bitT5018 Service-
Description:Flag the indicates that this line should be considered a construction service for the purpose of T5018 report generation.
TaskIDDefault Navigation
intProject TaskPMTask
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)
TaxCategoryIDDefault Navigation
nvarchar(15)Tax CategoryTaxCategory
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.
TaxIDDefault Navigation
nvarchar(60)Tax IDTax
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
decimalAmount-
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
decimalBalance-
Description:No description available
TranClass
char(1)-
Description:No description available
TranDate
datetimeDocument 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.
TranIDObsolete
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. TypeAPRegister
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.
UOMDefault Navigation
nvarchar(6)UOMINUnit
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
VendorIDDefault Navigation
intVendorVendor
Description:Identifier of the Vendor, whom the parent document belongs.
tstamp
timestamp-
Description:No description available