AR
ARTran
PX.Objects.AR166 of 166 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | ARInvoice | |
Description:No description available | ||||
TranType | char(3) | Tran. Type | - | |
Description:No description available | ||||
AccountID | int | Account | Account | |
Description:No description available | ||||
AccrueCost | bit | Accrue Cost | - | |
Description:No description available | ||||
AccruedCost | decimal(19, 6) | - | ||
Description:No description available | ||||
AllowControlAccountForModuleNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
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(25, 6) | Base Qty. | - | |
Description:No description available | ||||
BlanketLineNbr | int | - | ||
Description:No description available | ||||
BlanketNbr | nvarchar(15) | Blanket SO Ref. Nbr. | SOBlanketOrderLink | |
Description:No description available | ||||
BlanketSplitLineNbr | int | - | ||
Description:No description available | ||||
BlanketType | char(2) | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CalculateDiscountsOnImportNonexistent in DB | bit | Calculate automatic discounts on import | - | |
Description:No description available | ||||
Canceled | bit | - | ||
Description:When set to "true", indicates that the invoice was canceled or corrected. | ||||
CanViewDeferralSchedule | bit | - | ||
Description:No description available | ||||
CaseCD | nvarchar(15) | Case ID | CRCase | |
Description:No description available | ||||
CashDiscBal | decimal(19, 4) | - | ||
Description:No description available | ||||
Commissionable | bit | Commissionable | - | |
Description:No description available | ||||
CommnAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CommnPct | decimal(9, 6) | - | ||
Description:No description available | ||||
Cost | decimal | Cost | - | |
Description:No description available | ||||
CostBasis | char(1) | - | ||
Description:No description available | ||||
CostBasisNullNonexistent in DB | nchar(1) | Cost Based On | - | |
Description:No description available | ||||
CostCenterID | int | - | ||
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryAccruedCost | decimal(19, 6) | Cost Accrual | - | |
Description:No description available | ||||
CuryCashDiscBal | decimal(19, 4) | Cash Discount Balance | - | |
Description:No description available | ||||
CuryCommnAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryDiscAmt | decimal(19, 4) | Discount Amount | - | |
Description:No description available | ||||
CuryExtPrice | decimal(19, 6) | Ext. Price | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryInventoryIDNonexistent in DB | int | - | ||
Description:No description available | ||||
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 | ||||
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 | ||||
CuryUnitPrice | decimal(19, 6) | Unit Price | - | |
Description:No description available | ||||
CuryUnitPriceDR | decimal(19, 6) | Unit Price for DR | - | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
Date | datetime2 | Expense Date | - | |
Description:Reference Date. May be an original expense date that is billed to the customer. | ||||
DeferredCode | nvarchar(10) | Deferral Code | DRDeferredCode | |
Description:No description available | ||||
DefScheduleID | int | Original Deferral Schedule | DRSchedule | |
Description:No description available | ||||
DisableAutomaticTaxCalculation | bit | Disable Automatic Tax Calculation | - | |
Description:No description available | ||||
DiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
DiscountID | nvarchar(10) | Discount Code | ARDiscount | |
Description:No description available | ||||
DiscountsAppliedToLine | varbinary(MAX) | - | ||
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | Discount Sequence | - | |
Description:No description available | ||||
DiscPct | decimal(9, 6) | Discount Percent | - | |
Description:No description available | ||||
DiscPctDR | decimal(9, 6) | Discount Percent for DR | - | |
Description:No description available | ||||
DocumentDiscountAmount | decimal | Document Discount Amount | - | |
Description:No description available | ||||
DocumentDiscountRate | decimal(21, 18) | - | ||
Description:No description available | ||||
DrCr | 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:No description available | ||||
ExpenseAccountID | int | Expense Account | Account | |
Description:No description available | ||||
ExpenseAccrualAccountID | int | Expense Accrual Account | Account | |
Description:No description available | ||||
ExpenseAccrualSubID | int | Expense Accrual Subaccount | Sub | |
Description:No description available | ||||
ExpenseDate | datetime2 | - | ||
Description:No description available | ||||
ExpenseSubID | int | Expense Subaccount | Sub | |
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
ExtPrice | decimal(19, 6) | - | ||
Description:No description available | ||||
FinPeriodID | char(6) | - | ||
Description:No description available | ||||
FreezeManualDiscNonexistent in DB | bit | - | ||
Description:No description available | ||||
GrossSalesAmount | decimal | Gross Sales Amount | - | |
Description:No description available | ||||
GroupDiscountAmount | decimal | Group Discount Amount | - | |
Description:No description available | ||||
GroupDiscountRate | decimal(21, 18) | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvtDocType | char(1) | Inventory Doc. Type | - | |
Description:No description available | ||||
InvtMult | smallint | Multiplier | - | |
Description:No description available | ||||
InvtRefNbr | 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). | ||||
IsFreeNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsStockItem | bit | Is stock | - | |
Description:No description available | ||||
IsTranCostFinal | bit | - | ||
Description:No description available | ||||
ItemHasResidualNonexistent in DB | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineType | char(2) | Line Type | - | |
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | INLotSerialStatusByCostCenter | |
Description:No description available | ||||
ManualDisc | bit | Manual Discount | - | |
Description:No description available | ||||
ManualPrice | bit | Manual Price | - | |
Description:No description available | ||||
Margin | decimal | Margin | - | |
Description:No description available | ||||
MarginPercent | decimal | Margin Percent | - | |
Description:No description available | ||||
NetSalesAmount | decimal | Net Sales Amount | - | |
Description:No description available | ||||
NoteID | 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(21, 18) | - | ||
Description:No description available | ||||
OrigGroupDiscountRate | decimal(21, 18) | - | ||
Description:No description available | ||||
OrigInvoiceDate | datetime2 | Original Invoice date | - | |
Description:No description available | ||||
OrigInvoiceLineNbr | int | Orig. Inv. Line Nbr. | - | |
Description:No description available | ||||
OrigInvoiceNbr | nvarchar(15) | Orig. Inv. Nbr. | SOInvoice | |
Description:No description available | ||||
OrigInvoiceType | 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(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 | ||||
PlanID | bigint | - | ||
Description:No description available | ||||
PMDeltaOption | char(1) | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
Qty | decimal(25, 6) | Quantity | - | |
Description:No description available | ||||
ReasonCode | nvarchar(20) | Reason Code | ReasonCode | |
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
ReleasedToVerifyNonexistent in DB | bit | - | ||
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. | ||||
RequireINUpdateNonexistent in DB | bit | - | ||
Description:No description available | ||||
RequiresTermsNonexistent 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) | ||||
SalesPersonID | int | Salesperson ID | ARSalesPerTran | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | 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 | ||||
SOOrderLineNbr | int | Order Line Nbr | SOLine | |
Description:No description available | ||||
SOOrderLineOperation | char(1) | - | ||
Description:No description available | ||||
SOOrderLineSign | smallint | - | ||
Description:No description available | ||||
SOOrderNbr | nvarchar(15) | Order Nbr. | SOOrder | |
Description:No description available | ||||
SOOrderSortOrder | int | Order Sort Order | - | |
Description:No description available | ||||
SOOrderType | char(2) | Order Type | SOOrderType | |
Description:No description available | ||||
SortOrder | int | Line Nbr. | - | |
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 | nvarchar(15) | Shipment Nbr. | SOOrderShipment | |
Description:No description available | ||||
SOShipmentType | char(1) | - | ||
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
SubstitutionRequired | bit | Substitution Required | - | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TaxableAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
TaxAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TaxID | nvarchar(60) | Tax ID | Tax | |
Description:No description available | ||||
TranAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
TranBal | decimal(19, 4) | Balance | - | |
Description:No description available | ||||
TranClass | char(1) | - | ||
Description:No description available | ||||
TranCost | decimal(19, 4) | Ext. Cost | - | |
Description:No description available | ||||
TranCostOrig | decimal(19, 4) | Orig. Ext. Cost | - | |
Description:No description available | ||||
TranDate | datetime2 | Document Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Transaction Descr. | - | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnassignedQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
UnitCost | decimal | - | ||
Description:No description available | ||||
UnitPrice | decimal(19, 6) | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||