TABLE DETAIL REFERENCE: TaxCodePurchaseTaxRateDetail
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueFalseTrueTrue%s
Description12 VARCHAR 100TrueFalseTrueTrue%s
Active-7 BIT 1TrueFalseTrueFalse
1
0
true
false
Taxable-7 BIT 1TrueFalseTrueFalse
1
0
true
false
TaxGroup-7 BIT 1TrueFalseTrueFalse
1
0
true
false
PurchaseTaxRateListTaxRateDetailTaxRateRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
PurchaseTaxRateListRateDetailTaxRateRefFullName12 VARCHAR 100TrueFalseTrueFalse%s Yes
PurchaseTaxRateListRateDetailTaxTypeApplicable12 VARCHAR 11TrueFalseTrueFalse
TaxOnAmount
TaxOnAmountPlusTax
TaxOnTax
PurchaseTaxRateListRateDetailTaxOrder12 VARCHAR 11TrueFalseTrueTrue%s
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey