ChargeLinkedTxn Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ID 12 VARCHAR 75
TxnID 12 VARCHAR 36 True False False False %s TxnID 2.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 2.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 2.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 2.0 US, CA, UK
TxnNumber 4 INTEGER 9 True False False False %12.0f 2.0 US, CA, UK
CustomerRef_ListID 12 VARCHAR 36 True False False True %s ListID 2.0 US, CA, UK
CustomerRef_FullName 12 VARCHAR 209 True False False True %s FullName 2.0 US, CA, UK
TxnDate 91 DATE 10 True False False False CCCC-MM-DD 2.0 US, CA, UK
TxnDateMacro 12 VARCHAR 25 True False False False
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYear
ThisFiscalYearToDate
Yesterday
LastWeek
LastWeekToDate
LastMonth
LastMonthToDate
LastCalendarQuarter
LastCalendarQuarterToDate
LastFiscalQuarter
LastFiscalQuarterToDate
LastCalendarYear
LastCalendarYearToDate
LastFiscalYear
LastFiscalYearToDate
NextWeek
NextFourWeeks
NextMonth
NextCalendarQuarter
NextCalendarYear
NextFiscalQuarter
NextFiscalYear
 2.0 US, CA, UK
RefNumber 12 VARCHAR 11 True False False False %s 2.0 US, CA, UK
ItemRef_ListID 12 VARCHAR 36 True False False True %s ListID 2.0 US, CA, UK
ItemRef_FullName 12 VARCHAR 159 True False False True %s FullName 2.0 US, CA, UK
InventorySiteRef_ListID 12 VARCHAR 36 True False False True %s ListID 10.0 US, CA, UK
InventorySiteRef_FullName 12 VARCHAR 31 True False False True %s Name 10.0 US, CA, UK
Quantity 3 DECIMAL 18 True False False False %10.5f 2.0 US, CA, UK
UnitOfMeasure 12 VARCHAR 31 True False False False %s 7.0 US, CA, UK
Rate 3 DECIMAL 18 True False False False %10.5f 2.0 US, CA, UK
OptionForPriceRuleConflict 12 VARCHAR 36 %s 2.0 US, CA, UK
Amount 3 DECIMAL 15 True False False False %10.2f 2.0 US, CA, UK
BalanceRemaining 3 DECIMAL 15 True False False False %10.2f 2.0 US, CA, UK
Description 12 VARCHAR 4095 True False False False %s 2.0 US, CA, UK
ARAccountRef_ListID 12 VARCHAR 36 True False False False %s 2.0 US, CA, UK
ARAccountRef_FullName 12 VARCHAR 159 True False False False %s 2.0 US, CA, UK
ClassRef_ListID 12 VARCHAR 36 True False False False %s 2.0 US, CA, UK
ClassRef_FullName 12 VARCHAR 159 True False False False %s 2.0 US, CA, UK
BilledDate 91 DATE 6 True False False False CCCC-MM-DD 2.0 US, CA, UK
DueDate 10 DATE 6 True False False False CCCC-MM-DD 2.0 US, CA, UK
OverrideItemAccountRef_ListID 12 VARCHAR 36 True False False False %s ListID 2.0 US, CA, UK
OverrideItemAccountRef_FullName 12 VARCHAR 159 True False False False %s FullName 2.0 US, CA, UK
OverrideUOMSetRef_ListID 12 VARCHAR 36 ListID 7.0 US, CA, UK
OverrideUOMSetRef_FullName 12 VARCHAR 31 Name 7.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 9.0 US, CA, UK
LinkedTxn_TxnID 12 VARCHAR 36 True False False False %s 3.0 US, CA, UK
LinkedTxn_TxnType 12 VARCHAR 21 True False False False
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
LiabilityAdjustment
Paycheck
PayrollLiabilityCheck
PurchaseOrder
ReceivePayment
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
Transfer
VendorCredit
YTDAdjustment
ARRefundCreditCard
 3.0 US, CA, UK
LinkedTxn_TxnDate 91 DATE 10 True False False False CCCC-MM-DD 3.0 US, CA, UK
LinkedTxn_RefNumber 12 VARCHAR 20 True False False False %s 3.0 US, CA, UK
LinkedTxn_LinkType 12 VARCHAR 8 True False False False
AMTTYPE
QUANTYPE
 3.0 US, CA, UK
LinkedTxn_Amount 2 NUMERIC 15 True False False False %10.2f 3.0 US, CA, UK