TABLE DETAIL REFERENCE: CustomerAddtionalNote
(USA 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 16TrueFalseFalseFalse%s
Name12 VARCHAR 41TrueTrueTrueTrue%s
FullName12 VARCHAR 209TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 209TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
CompanyName12 VARCHAR 41TrueTrueTrueFalse%s
Salutation12 VARCHAR 15TrueTrueTrueFalse%s
FirstName12 VARCHAR 25TrueTrueTrueFalse%s
MiddleName12 VARCHAR 5TrueTrueTrueFalse%s
LastName12 VARCHAR 25TrueTrueTrueFalse%s
JobTitle12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
Phone12 VARCHAR 21TrueTrueTrueFalse%s
AltPhone12 VARCHAR 21TrueTrueTrueFalse%s
Fax12 VARCHAR 21TrueTrueTrueFalse%s
Email12 VARCHAR 1023TrueTrueTrueFalse%s
Cc12 VARCHAR 1023TrueTrueTrueFalse%s
Contact12 VARCHAR 41TrueTrueTrueFalse%s
AltContact12 VARCHAR 41TrueTrueTrueFalse%s
CustomerTypeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerTypeRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesRepRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesRepRefFullName12 VARCHAR 5TrueTrueTrueFalse%s Yes
Balance3 DECIMAL 15TrueFalseFalseFalse%10.2f
TotalBalance3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenBalance3 DECIMAL 15TrueFalseTrueFalse%10.2f
OpenBalanceDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
SalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
ItemSalesTaxRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemSalesTaxRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesTaxCountry12 VARCHAR 31TrueTrueTrueFalse
Australia
Canada
UK
ResaleNumber12 VARCHAR 15TrueTrueTrueFalse%s
AccountNumber12 VARCHAR 99TrueTrueTrueFalse%s
BusinessNumber12 VARCHAR 99TrueFalseFalseFalse%s
CreditLimit3 DECIMAL 15TrueTrueTrueFalse%10.2f
PreferredPaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PreferredPaymentMethodRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
CreditCardInfoCreditCardNumber12 VARCHAR 25TrueTrueTrueFalse%s
CreditCardInfoExpirationMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardInfoExpirationYear4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardInfoNameOnCard12 VARCHAR 41TrueTrueTrueFalse%s
CreditCardInfoCreditCardAddress12 VARCHAR 41TrueTrueTrueFalse%s
CreditCardInfoCreditCardPostalCode12 VARCHAR 41TrueTrueTrueFalse%s
JobStatus12 VARCHAR 10TrueTrueTrueFalse
None
Pending
Awarded
InProgress
Closed
NotAwarded
JobStartDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
JobProjectedEndDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
JobEndDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
JobDesc12 VARCHAR 99TrueTrueTrueFalse%s
JobTypeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JobTypeRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
Notes12 VARCHAR 4095TrueTrueTrueFalse%s
AdditionalNotesRetNoteID4 INTEGER 4TrueTrueFalseFalse%11.0f
AdditionalNotesRetDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AdditionalNotesRetNote12 VARCHAR 4095TrueTrueTrueFalse%s
PreferredDeliveryMethod12 VARCHAR 10TrueTrueTrueTrue
None
Email
Fax
IsUsingCustomerTaxCode-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PriceLevelRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PriceLevelRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ExternalGUID12 VARCHAR 40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
TaxRegistrationNumber12 VARCHAR 30TrueFalseFalseFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey