TABLE DETAIL REFERENCE: ItemOtherCharge
(Australia ,New Zealand,Singapore Southeast Asia VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueTrueTrueTrue%s
FullName12 VARCHAR 159TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 159TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
IsTaxIncluded-7 BIT 1TrueTrueTrueFalse
1
0
true
false
TaxCodeForPurchaseRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TaxCodeForPurchaseRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
TaxCodeForSaleRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TaxCodeForSaleRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
SalesOrPurchaseDesc12 VARCHAR 4095TrueTrueTrueFalse%s
SalesOrPurchasePrice3 DECIMAL 16TrueTrueTrueTrue%8.5f
SalesOrPurchasePricePercent3 DECIMAL 15TrueTrueTrueTrue%7.5f
SalesOrPurchaseAccountRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
SalesOrPurchaseAccountRefFullName12 VARCHAR 159TrueFalseTrueTrue%s Yes
SalesAndPurchaseSalesDesc12 VARCHAR 4095TrueTrueTrueFalse%s
SalesAndPurchaseSalesPrice3 DECIMAL 16TrueTrueTrueFalse%8.5f
SalesAndPurchaseIncomeAccountRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
SalesAndPurchaseIncomeAccountRefFullName12 VARCHAR 159TrueFalseTrueTrue%s Yes
SalesAndPurchasePurchaseDesc12 VARCHAR 4095TrueTrueTrueFalse%s
SalesAndPurchasePurchaseCost3 DECIMAL 16TrueTrueTrueFalse%8.5f
SalesAndPurchasePurchaseTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesAndPurchasePurchaseTaxCodeRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesAndPurchaseExpenseAccountRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
SalesAndPurchaseExpenseAccountRefFullName12 VARCHAR 159TrueFalseTrueTrue%s Yes
SalesAndPurchasePrefVendorRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesAndPurchasePrefVendorRefFullName12 VARCHAR 41TrueTrueTrueFalse%s Yes
SpecialItemType12 VARCHAR 24TrueFalseFalseFalse
FinanceCharge
ReimbursableExpenseGroup
ReimbursableExpenseSubtotal
Yes