TABLE DETAIL REFERENCE: ItemDiscount
(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
ItemDesc12 VARCHAR 4095TrueTrueTrueFalse%s
SalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
DiscountRate3 DECIMAL 16TrueTrueTrueTrue%8.5f
DiscountRatePercent3 DECIMAL 15TrueTrueTrueTrue%7.5f
AccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
AccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes