TABLE DETAIL REFERENCE: ChargeLinkedTxn
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueFalseFalseTrue%s Yes
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
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
RefNumber12 VARCHAR 11TrueFalseFalseFalse%s
ItemRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
ItemRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
InventorySiteRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
InventorySiteRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
InventorySiteLocationRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
InventorySiteLocationRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
Quantity3 DECIMAL 18TrueFalseFalseFalse%10.5f
UnitOfMeasure12 VARCHAR 31TrueFalseFalseFalse%s Yes
OverrideUOMSetRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
OverrideUOMSetRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
Rate3 DECIMAL 18TrueFalseFalseFalse%10.5f
OptionForPriceRuleConflict12 VARCHAR 23FalseFalseFalseFalse
Zero
BasePrice
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
BalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
Desc12 VARCHAR 4095TrueFalseFalseFalse%s
ARAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ARAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ClassRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
BilledDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
DueDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
OverrideItemAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
OverrideItemAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
LinkedTxnSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
LinkedTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
LinkedTxnTxnType12 VARCHAR 21TrueFalseFalseFalse
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
LinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
LinkedTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
LinkedTxnLinkType12 VARCHAR 8TrueFalseFalseFalse
AMTTYPE
QUANTYPE
LinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey