ARTran

PX.Objects.ARRelease 2025.2

A line of an accounts receivable invoice or memo. The record contains such information as the inventory item name, price and quantity, line discounts, and tax category. Entities of this type are edited on the Invoices and Memos (AR301000) form, which corresponds to the ARInvoiceEntry graph.

View API Entity: SalesInvoiceDetail/entity/Default/25.200.001/SalesInvoiceDetail

Select a row for its description 194 of 194 fields

	Field Name	Type	Display Name	Foreign Key
	`AccountID` API Default Navigation	`int`	Account	Account
Description:No description available
	`AccrueCost`	`bit`	Accrue Cost	-
Description:When set to "true", indicates that cost will be processed using expense accrual account.
	`AccruedCost`	`decimal`		-
Description:No description available
	`AllowControlAccountForModule`Nonexistent in DB	`string`		-
Description:No description available
	`AppointmentLineNbr`	`int`	Appointment Line Nbr.	-
Description:Appointment line nbr
	`AppointmentRefNbr`	`nvarchar(20)`	Appointment Nbr.	-
Description:Appointment ref nbr
	`AssociatedOrderLineNbr`	`int`	Associated Order Line Nbr.	-
Description:The order line associated with the transaction.
	`AutomaticDiscountsDisabled`	`bit`	Automatic Discounts Disabled	-
Description:A Boolean value that indicates whether the system does not need to calculate discounts, because they are already calculated.
	`AvalaraCustomerUsageType`	`char(1)`	Tax Exemption Type	-
Description:No description available
	`BaseQty`	`decimal`	Base Qty.	-
Description:No description available
	`BlanketLineNbr`	`int`		-
Description:No description available
	`BlanketNbr`Default Navigation	`nvarchar(15)`	Blanket SO Ref. Nbr.	SOOrder
Description:No description available
	`BlanketSplitLineNbr`	`int`		-
Description:No description available
	`BlanketType`	`char(2)`		SOBlanketOrderLink
Description:No description available
	`BranchBaseCuryID`Nonexistent in DB	`string`		-
Description:No description available
	`BranchID` API Default Navigation	`int`	Branch	Branch
Description:No description available
	`CalculateDiscountsOnImport` API Nonexistent in DB	`bool?`	Calculate automatic discounts on import	-
Description:No description available
	`Canceled`	`bit`		-
Description:When set to "true", indicates that the invoice was canceled or corrected.
	`CaseCD`Default Navigation	`nvarchar(15)`	Case ID	CRCase
Description:No description available
	`CashDiscBal`	`decimal`		-
Description:No description available
	`Comment`	`varchar(MAX)`	Equipment Action Comment	-
Description:No description available
	`Commissionable`	`bit`	Commissionable	ARTran
Description:No description available
	`CommnAmt`	`decimal`		-
Description:No description available
	`CommnPct`	`decimal`		-
Description:No description available
	`ComponentID`Default Navigation	`int`	Component ID	FSModelTemplateComponent
Description:Component ID
	`Cost`Nonexistent in DB	`decimal?`	Cost	-
Description:No description available
	`CostBasis`	`char(1)`		-
Description:No description available
	`CostBasisNull`Nonexistent in DB	`string`	Cost Based On	-
Description:No description available
	`CostCenterID`	`int`		-
Description:No description available
	`CostCodeID` API 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
	`CuryAccruedCost`	`decimal`	Cost Accrual	-
Description:No description available
	`CuryCashDiscBal`	`decimal`	Cash Discount Balance	-
Description:No description available
	`CuryCommnAmt`	`decimal`		-
Description:No description available
	`CuryDiscAmt` API	`decimal`	Discount Amount	-
Description:No description available
	`CuryExtPrice`	`decimal`	Ext. Price	-
Description:No description available
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:No description available
	`CuryInventoryID`Default NavigationNonexistent in DB	`int?`		InventoryItemCurySettings
Description:No description available
	`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 ARRegister.CuryID)
	`CuryOrigTaxableAmt`	`decimal`	Taxable Amount	-
Description:The line amount included into line balance. (Presented in the currency of the document, see ARRegister.CuryID)
	`CuryOrigTranAmt`	`decimal`	Original Amount	-
Description:No description available
	`CuryPrepaymentAmt`	`decimal`	Prepayment Amount	-
Description:Part of sales order amount which shall be paid in PPI document
	`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 ARRegister.CuryID)
	`CuryRetainedTaxableAmt`	`decimal`	Retained Taxable Amount	-
Description:The line amount that is subject to retained tax. (Presented in the currency of the document, see ARRegister.CuryID)
	`CuryTaxAmt`	`decimal`	VAT	-
Description:No description available
	`CuryTaxableAmt`	`decimal`	Net Amount	-
Description:No description available
	`CuryTranAmt` API	`decimal`	Amount	-
Description:No description available
	`CuryTranBal`	`decimal`	Balance	-
Description:No description available
	`CuryUnitPrice` API	`decimal`	Unit Price	-
Description:No description available
	`CuryUnitPriceDR`	`decimal`	Unit Price for DR	-
Description:No description available
	`CustomerID`Default Navigation	`int`	Customer	Customer
Description:No description available
	`DRTermEndDate`	`datetime`	Term End Date	-
Description:No description available
	`DRTermStartDate`	`datetime`	Term Start Date	-
Description:No description available
	`Date`	`datetime`	Expense Date	-
Description:Reference Date. May be an original expense date that is billed to the customer.
	`DefScheduleID`Default Navigation	`int`	Original Deferral Schedule	DRSchedule
Description:No description available
	`DeferredCode`Default Navigation	`nvarchar(10)`	Deferral Code	DRDeferredCode
Description:No description available
	`DisableAutomaticTaxCalculation`	`bit`	Disable Automatic Tax Calculation	-
Description:No description available
	`DiscAmt`	`decimal`		-
Description:No description available
	`DiscPct` API	`decimal`	Discount Percent	-
Description:No description available
	`DiscPctDR`	`decimal`	Discount Percent for DR	-
Description:No description available
	`DiscountID`Default Navigation	`nvarchar(10)`	Discount Code	ARDiscount
Description:No description available
	`DiscountSequenceID`	`nvarchar(10)`	Discount Sequence	-
Description:No description available
	`DiscountsAppliedToLine`	`varbinary`		-
Description:No description available
	`DocumentDiscountAmount`Nonexistent in DB	`decimal?`	Document Discount Amount	-
Description:No description available
	`DocumentDiscountRate`	`decimal`		-
Description:No description available
	`DrCr`	`char(1)`		-
Description:No description available
	`EmployeeID`	`int`		-
Description:No description available
	`EquipmentAction`	`char(2)`	Equipment Action	-
Description:No description available
	`EquipmentComponentLineNbr`Default Navigation	`int`	Component Line Nbr.	FSEquipmentComponent
Description:No description available
	`ExpenseAccountID`Default Navigation	`int`	Expense Account	Account
Description:No description available
	`ExpenseAccrualAccountID`Default Navigation	`int`	Expense Accrual Account	Account
Description:No description available
	`ExpenseAccrualSubID`Default Navigation	`int`	Expense Accrual Subaccount	Sub
Description:No description available
	`ExpenseDate`	`datetime`		-
Description:No description available
	`ExpenseSubID`Default Navigation	`int`	Expense Subaccount	Sub
Description:No description available
	`ExpireDate` API	`datetime`	Expiration Date	-
Description:No description available
	`ExtPrice`	`decimal`		-
Description:No description available
	`ExternalRef`	`nvarchar`		-
Description:External document ID that is needed to identify document for the integrations with external systems such as Commerce Edition
	`FinPeriodID`	`string`		-
Description:No description available
	`FreezeManualDisc`Nonexistent in DB	`bool?`		-
Description:No description available
	`GiftMessage`	`nvarchar(200)`	Gift Message	-
Description:The gift message for the order.
	`GrossSalesAmount`Nonexistent in DB	`decimal?`	Gross Sales Amount	-
Description:No description available
	`GroupDiscountAmount`Nonexistent in DB	`decimal?`	Group Discount Amount	-
Description:No description available
	`GroupDiscountRate`	`decimal`		-
Description:No description available
	`HasExpiredComplianceDocuments`Nonexistent in DB	`bool?`	Expired Compliance	-
Description:No description available
	`HistoryLineID`Nonexistent in DB	`int?`		-
Description:No description available
	`InventoryID` API Default Navigation	`int`	Inventory ID	InventoryItem
Description:No description available
	`InvtDocType` API	`char(1)`	Inventory Doc. Type	-
Description:No description available
	`InvtMult`	`smallint`	Multiplier	-
Description:No description available
	`InvtRefNbr` API Default Navigation	`nvarchar(15)`	Inventory Ref. Nbr.	INRegister
Description:No description available
	`InvtReleased`	`bit`		-
Description:No description available
	`IsCancellation`	`bit`		-
Description:When set to "true", indicates that the invoice is a cancellation invoice (credit memo).
	`IsFSRelated`Nonexistent in DB	`bool?`		-
Description:Is FS related
	`IsFree`Nonexistent in DB	`bool?`		-
Description:No description available
	`IsStockItem`	`bit`	Is stock	-
Description:No description available
	`IsTranCostFinal`	`bit`		-
Description:No description available
	`ItemHasResidual`Nonexistent in DB	`bool?`		-
Description:No description available
	`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
	`LineNbr` API	`int`	Line Nbr.	-
Description:No description available
	`LineType`	`char(2)`	Line Type	-
Description:No description available
	`LocationID` API Default Navigation	`int`	Location	INLocation
Description:No description available
	`LotSerialNbr` API Default Navigation	`nvarchar(100)`	Lot/Serial Nbr.	CostCenter
Description:No description available
	`ManualDisc` API	`bit`	Manual Discount	-
Description:No description available
	`ManualPrice` API	`bit`	Manual Price	-
Description:No description available
	`Margin`Nonexistent in DB	`decimal?`	Margin	-
Description:No description available
	`MarginPercent`Nonexistent in DB	`decimal?`	Margin Percent	-
Description:No description available
	`NetSalesAmount`Nonexistent in DB	`decimal?`	Net Sales Amount	-
Description:No description available
	`NewEquipmentLineNbr`Default Navigation	`int`	Model Equipment Line Nbr.	ARTran
Description:No description available
	`NoteID` API	`uniqueidentifier`		-
Description:No description available
	`OrigDocType`	`char(3)`	Orig. Doc. Type	-
Description:The type of the original (source) document. Corresponds to the DocType field.
	`OrigDocumentDiscountRate`	`decimal`		-
Description:No description available
	`OrigGroupDiscountRate`	`decimal`		-
Description:No description available
	`OrigInvoiceDate`	`datetime`	Original Invoice date	-
Description:No description available
	`OrigInvoiceLineNbr` API	`int`	Orig. Inv. Line Nbr.	-
Description:No description available
	`OrigInvoiceNbr` API Default Navigation	`nvarchar(15)`	Orig. Inv. Nbr.	SOInvoice
Description:No description available
	`OrigInvoiceType` API	`char(3)`	Orig. Inv. Type	-
Description:No description available
	`OrigLineNbr`	`int`		-
Description:No description available
	`OrigRefNbr`	`nvarchar(15)`	Orig. Ref. Nbr.	-
Description:The reference number of the original (source) document. Corresponds to the RefNbr field.
	`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
	`PMDeltaOption`	`nvarchar`		-
Description:No description available
	`PlanID`	`bigint`		-
Description:No description available
	`PrepaymentAmt`	`decimal`		-
Description:Part of sales order amount which shall be paid in PPI document
	`PrepaymentPct`	`decimal`	Prepayment Percent	-
Description:Percent of the Sales Order amount which shall be paid in PPI document
	`ProjectID`Default Navigation	`int`	Project	PMProject
Description:No description available
	`Qty` API	`decimal`	Quantity	-
Description:No description available
	`ReasonCode`Default Navigation	`nvarchar(20)`	Reason Code	ReasonCode
Description:No description available
	`RefNbr`	`nvarchar(15)`	Reference Nbr.	ARCashSale
Description:No description available
	`RelatedDocument`Nonexistent in DB	`string`	Related Svc. Doc. Nbr.	-
Description:No description available
	`RelatedItems`Nonexistent in DB	`string`		-
Description:No description available
	`RelatedItemsRelation`Nonexistent in DB	`int?`		-
Description:No description available
	`RelatedItemsRequired`Nonexistent in DB	`int?`		-
Description:No description available
	`Released`	`bit`		-
Description:No description available
	`ReleasedToVerify`Nonexistent in DB	`bool?`		-
Description:When set, on persist checks, that the document has the corresponded Released original value. When not set, on persist checks, that Released value is not changed. Throws an error otherwise.
	`ReplaceSMEquipmentID`Default Navigation	`int`	Suspended Target Equipment ID	-
Description:No description available
	`RequireINUpdate`Nonexistent in DB	`bool?`		-
Description:No description available
	`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)
	`SMEquipmentID`Default Navigation	`int`	Target Equipment ID	ARTran
Description:No description available
	`SOOrderLineNbr` API	`int`	Order Line Nbr	SOLine
Description:No description available
	`SOOrderLineOperation`	`char(1)`		-
Description:No description available
	`SOOrderLineSign`	`smallint`		-
Description:No description available
	`SOOrderNbr` API Default Navigation	`nvarchar(15)`	Order Nbr.	SOOrder
Description:No description available
	`SOOrderSortOrder`	`int`	Order Sort Order	-
Description:No description available
	`SOOrderType` API Default Navigation	`char(2)`	Order Type	SOOrderType
Description:No description available
	`SOShipmentLineGroupNbr`	`int`		-
Description:Number of the group of shipment lines referencing the same sales order line which are invoiced together in the single invoice line.
	`SOShipmentLineNbr`	`int`		-
Description:No description available
	`SOShipmentNbr` API Default Navigation	`nvarchar(15)`	Shipment Nbr.	SOOrderShipment
Description:No description available
	`SOShipmentType`	`char(1)`		SOOrderShipment
Description:No description available
	`SalesPersonID`Default Navigation	`int`	Salesperson ID	SalesPerson
Description:No description available
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:No description available
	`ServiceContractPeriodID`	`int`	Service Contract Period	-
Description:No description available
	`ServiceContractRefNbr`	`nvarchar(15)`	Service Contract Nbr.	-
Description:No description available
	`ServiceOrderLineNbr`	`int`	Service Order Line Nbr.	-
Description:No description available
	`ServiceOrderRefNbr`	`nvarchar(15)`	Service Order Nbr.	-
Description:No description available
	`SiteID` API Default Navigation	`int`		INSite
Description:No description available
	`SkipLineDiscounts`	`bit`	Ignore Automatic Line Discounts	-
Description:Indicates (if selected) that the automatic line discounts are not applied to this line
	`SortOrder`	`int`	Line Nbr.	-
Description:No description available
	`SrvOrdType`	`char(4)`	Service Order Type	-
Description:No description available
	`SubID` API Default Navigation	`int`	Subaccount	Sub
Description:No description available
	`SubItemID` API Default Navigation	`int`	Subitem	INSubItem
Description:No description available
	`SubstitutionRequired`	`bit`	Substitution Required	-
Description:No description available
	`SuggestRelatedItems`Nonexistent in DB	`bool?`		-
Description:No description available
	`TaskID` API Default Navigation	`int`	Project Task	PMTask
Description:No description available
	`TaxAmt`	`decimal`		-
Description:No description available
	`TaxCategoryID` API Default Navigation	`nvarchar(15)`	Tax Category	TaxCategory
Description:No description available
	`TaxID`Default Navigation	`nvarchar(60)`	Tax ID	Tax
Description:No description available
	`TaxableAmt`	`decimal`		-
Description:No description available
	`TranAmt`	`decimal`		-
Description:No description available
	`TranBal`	`decimal`	Balance	-
Description:No description available
	`TranClass`	`char(1)`		-
Description:No description available
	`TranCost`	`decimal`	Ext. Cost	-
Description:No description available
	`TranCostOrig`	`decimal`	Orig. Ext. Cost	-
Description:No description available
	`TranDate`	`datetime`	Document Date	-
Description:No description available
	`TranDesc` API	`nvarchar(256)`	Transaction Descr.	-
Description:No description available
	`TranPeriodID`	`string`		-
Description:No description available
	`TranType`	`char(3)`	Tran. Type	ARRegister
Description:No description available
	`UOM` API Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:No description available
	`UnassignedQty`Nonexistent in DB	`decimal?`		-
Description:No description available
	`UnitCost`Nonexistent in DB	`decimal?`		-
Description:No description available
	`UnitPrice`	`decimal`		-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available