CC
UpdateLevel3Data.ARTranCashSale
PX.Objects.CC166 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 | - | ||
Description:No description available | ||||
AllowControlAccountForModuleNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
AutomaticDiscountsDisabled | bit | Automatic Discounts Disabled | - | |
Description:No description available | ||||
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 | 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:No description available | ||||
CanViewDeferralSchedule | bit | - | ||
Description:No description available | ||||
CaseCD | nvarchar(15) | Case ID | CRCase | |
Description:No description available | ||||
CashDiscBal | decimal | - | ||
Description:No description available | ||||
Commissionable | bit | Commissionable | - | |
Description:No description available | ||||
CommnAmt | decimal | - | ||
Description:No description available | ||||
CommnPct | decimal | - | ||
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 | varchar(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 | decimal | Discount Amount | - | |
Description:No description available | ||||
CuryExtPrice | decimal | Ext. Price | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryInventoryIDNonexistent in DB | int | - | ||
Description:No description available | ||||
CuryOrigRetainageAmt | decimal | Original Retainage | - | |
Description:No description available | ||||
CuryOrigTaxableAmt | decimal | Taxable Amount | - | |
Description:No description available | ||||
CuryOrigTaxAmt | decimal | Tax Amount | - | |
Description:No description available | ||||
CuryOrigTranAmt | decimal | Original Amount | - | |
Description:No description available | ||||
CuryRetainageAmt | decimal | CuryRetainageAmt | - | |
Description:No description available | ||||
CuryRetainageBal | decimal | Unreleased Retainage | - | |
Description:No description available | ||||
CuryRetainedTaxableAmt | decimal | Retained Taxable Amount | - | |
Description:No description available | ||||
CuryRetainedTaxAmt | decimal | Retained Tax | - | |
Description:No description available | ||||
CuryTaxableAmt | decimal | Net Amount | - | |
Description:No description available | ||||
CuryTaxAmt | decimal | VAT | - | |
Description:No description available | ||||
CuryTranAmt | decimal | Amount | - | |
Description:No description available | ||||
CuryTranBal | decimal | Balance | - | |
Description:No description available | ||||
CuryUnitPrice | decimal | Unit Price | - | |
Description:No description available | ||||
CuryUnitPriceDR | decimal | Unit Price for DR | - | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
Date | datetime2 | Expense Date | - | |
Description:No description available | ||||
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 | - | ||
Description:No description available | ||||
DiscountID | nvarchar(10) | Discount Code | ARDiscount | |
Description:No description available | ||||
DiscountsAppliedToLine | varbinary | - | ||
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | Discount Sequence | - | |
Description:No description available | ||||
DiscPct | decimal | Discount Percent | - | |
Description:No description available | ||||
DiscPctDR | decimal | Discount Percent for DR | - | |
Description:No description available | ||||
DocumentDiscountAmount | decimal | Document Discount Amount | - | |
Description:No description available | ||||
DocumentDiscountRate | decimal | - | ||
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 | - | ||
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 | - | ||
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:No description available | ||||
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 | varchar(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:No description available | ||||
OrigDocumentDiscountRate | decimal | - | ||
Description:No description available | ||||
OrigGroupDiscountRate | decimal | - | ||
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:No description available | ||||
OrigRetainageAmt | decimal | - | ||
Description:No description available | ||||
OrigTaxableAmt | decimal | - | ||
Description:No description available | ||||
OrigTaxAmt | decimal | - | ||
Description:No description available | ||||
OrigTranAmt | decimal | - | ||
Description:No description available | ||||
PlanID | bigint | - | ||
Description:No description available | ||||
PMDeltaOption | varchar(MAX) | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
Qty | decimal | 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:No description available | ||||
RequireINUpdateNonexistent in DB | bit | - | ||
Description:No description available | ||||
RequiresTermsNonexistent in DB | bit | - | ||
Description:No description available | ||||
RetainageAmt | decimal | - | ||
Description:No description available | ||||
RetainageBal | decimal | - | ||
Description:No description available | ||||
RetainagePct | decimal | RetainagePct | - | |
Description:No description available | ||||
RetainedTaxableAmt | decimal | - | ||
Description:No description available | ||||
RetainedTaxAmt | decimal | - | ||
Description:No description available | ||||
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:No description available | ||||
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:No description available | ||||
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 | - | ||
Description:No description available | ||||
TaxAmt | decimal | - | ||
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 | - | ||
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 | 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 | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||