TABLE DETAIL REFERENCE: Charge
(UK VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
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 36TrueTrueTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueTrueTrueTrue%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYeRX<eTT
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
ItemRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
ItemRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
InventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
InventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
Quantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
UnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
OverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
OverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
Rate3 DECIMAL 18TrueTrueTrueFalse%10.5f
OptionForPriceRuleConflict12 VARCHAR 23FalseTrueTrueFalse
Zero
BasePrice
Amount3 DECIMAL 15TrueTrueTrueFalse%10.2f
BalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
Desc12 VARCHAR 4095TrueTrueTrueFalse%s
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
BilledDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
OverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
OverrideItemAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false