Details:CustomerShipToAddress

TABLE DETAIL REFERENCE: CustomerShipToAddress

(Canada VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
ListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TimeCreated	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
TimeModified	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
EditSequence	12	VARCHAR	16	True	False	False	False	%s
Name	12	VARCHAR	41	True	False	False	True	%s
FullName	12	VARCHAR	209	True	False	False	False	%s
IsActive	-7	BIT	1	True	False	False	False	1 0 true false
ClassRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ClassRefFullName	12	VARCHAR	209	True	False	False	False	%s	Yes
ParentRefListID	12	VARCHAR	36	True	False	False	False	%s
ParentRefFullName	12	VARCHAR	209	True	False	False	False	%s
Sublevel	4	INTEGER	4	True	False	False	False	%11.0f
CompanyName	12	VARCHAR	41	True	False	False	False	%s
Salutation	12	VARCHAR	15	True	False	False	False	%s
FirstName	12	VARCHAR	25	True	False	False	False	%s
MiddleName	12	VARCHAR	5	True	False	False	False	%s
LastName	12	VARCHAR	25	True	False	False	False	%s
JobTitle	12	VARCHAR	41	True	False	False	False	%s
BillAddressAddr1	12	VARCHAR	41	True	False	False	False	%s
BillAddressAddr2	12	VARCHAR	41	True	False	False	False	%s
BillAddressAddr3	12	VARCHAR	41	True	False	False	False	%s
BillAddressAddr4	12	VARCHAR	41	True	False	False	False	%s
BillAddressAddr5	12	VARCHAR	41	True	False	False	False	%s
BillAddressCity	12	VARCHAR	31	True	False	False	False	%s
BillAddressState	12	VARCHAR	21	True	False	False	False	%s
BillAddressProvince	12	VARCHAR	21	True	False	False	False	%s
BillAddressCounty	12	VARCHAR	21	True	False	False	False	%s
BillAddressPostalCode	12	VARCHAR	13	True	False	False	False	%s
BillAddressCountry	12	VARCHAR	31	True	False	False	False	%s
BillAddressNote	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr1	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr2	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr3	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr4	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr5	12	VARCHAR	41	True	False	False	False	%s
ShipAddressCity	12	VARCHAR	31	True	False	False	False	%s
ShipAddressState	12	VARCHAR	21	True	False	False	False	%s
ShipAddressProvince	12	VARCHAR	21	True	False	False	False	%s
ShipAddressCounty	12	VARCHAR	21	True	False	False	False	%s
ShipAddressPostalCode	12	VARCHAR	13	True	False	False	False	%s
ShipAddressCountry	12	VARCHAR	31	True	False	False	False	%s
ShipAddressNote	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressName	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressAddr1	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressAddr2	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressAddr3	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressAddr4	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressAddr5	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressCity	12	VARCHAR	31	True	False	False	False	%s
ShipToAddressState	12	VARCHAR	21	True	False	False	False	%s
ShipToAddressPostalCode	12	VARCHAR	13	True	False	False	False	%s
ShipToAddressCountry	12	VARCHAR	31	True	False	False	False	%s
ShipToAddressNote	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressDefaultShipTo	-7	BIT	1	True	False	False	False	1 0 true false
Phone	12	VARCHAR	21	True	False	False	False	%s
AltPhone	12	VARCHAR	21	True	False	False	False	%s
Fax	12	VARCHAR	21	True	False	False	False	%s
Email	12	VARCHAR	1023	True	False	False	False	%s
Cc	12	VARCHAR	1023	True	False	False	False	%s
Contact	12	VARCHAR	41	True	False	False	False	%s
AltContact	12	VARCHAR	41	True	False	False	False	%s
AdditionalContactRef1ContactName	12	VARCHAR	40	True	False	False	False	%s
AdditionalContactRef1ContactValue	12	VARCHAR	255	True	False	False	False	%s
AdditionalContactRef2ContactName	12	VARCHAR	40	True	False	False	False	%s
AdditionalContactRef2ContactValue	12	VARCHAR	255	True	False	False	False	%s
AdditionalContactRef3ContactName	12	VARCHAR	40	True	False	False	False	%s
AdditionalContactRef3ContactValue	12	VARCHAR	255	True	False	False	False	%s
AdditionalContactRef4ContactName	12	VARCHAR	40	True	False	False	False	%s
AdditionalContactRef4ContactValue	12	VARCHAR	255	True	False	False	False	%s
AdditionalContactRef5ContactName	12	VARCHAR	40	True	False	False	False	%s
AdditionalContactRef5ContactValue	12	VARCHAR	255	True	False	False	False	%s
AdditionalContactRef6ContactName	12	VARCHAR	40	True	False	False	False	%s
AdditionalContactRef6ContactValue	12	VARCHAR	255	True	False	False	False	%s
AdditionalContactRef7ContactName	12	VARCHAR	40	True	False	False	False	%s
AdditionalContactRef7ContactValue	12	VARCHAR	255	True	False	False	False	%s
AdditionalContactRef8ContactName	12	VARCHAR	40	True	False	False	False	%s
AdditionalContactRef8ContactValue	12	VARCHAR	255	True	False	False	False	%s
CustomerTypeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CustomerTypeRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
TermsRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TermsRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
SalesRepRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesRepRefFullName	12	VARCHAR	5	True	False	False	False	%s	Yes
Balance	3	DECIMAL	18	True	False	False	False	%10.2f
TotalBalance	3	DECIMAL	18	True	False	False	False	%10.2f
OpenBalance	3	DECIMAL	18	True	False	False	False	%10.2f
OpenBalanceDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ItemSalesTaxRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ItemSalesTaxRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
SalesTaxCountry	12	VARCHAR	31	True	False	False	False	Australia Canada UK
ResaleNumber	12	VARCHAR	15	True	False	False	False	%s
AccountNumber	12	VARCHAR	99	True	False	False	False	%s
BusinessNumber	12	VARCHAR	99	True	False	False	False	%s
CreditLimit	3	DECIMAL	17	True	False	False	False	%10.2f
PreferredPaymentMethodRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
PreferredPaymentMethodRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
CreditCardInfoCreditCardNumber	12	VARCHAR	25	True	False	False	False	%s
CreditCardInfoExpirationMonth	4	INTEGER	4	True	False	False	False	%11.0f
CreditCardInfoExpirationYear	4	INTEGER	4	True	False	False	False	%11.0f
CreditCardInfoNameOnCard	12	VARCHAR	41	True	False	False	False	%s
CreditCardInfoCreditCardAddress	12	VARCHAR	41	True	False	False	False	%s
CreditCardInfoCreditCardPostalCode	12	VARCHAR	41	True	False	False	False	%s
JobStatus	12	VARCHAR	10	True	False	False	False	None Pending Awarded InProgress Closed NotAwarded
JobStartDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
JobProjectedEndDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
JobEndDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
JobDesc	12	VARCHAR	99	True	False	False	False	%s
JobTypeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
JobTypeRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
Notes	12	VARCHAR	4095	True	False	False	False	%s
PreferredDeliveryMethod	12	VARCHAR	10	True	False	False	True	None Email Fax
IsUsingCustomerTaxCode	-7	BIT	1	True	False	False	False	1 0 true false
PriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
PriceLevelRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
ExternalGUID	12	VARCHAR	40	True	False	False	False	{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
TaxRegistrationNumber	12	VARCHAR	30	True	False	False	False	{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	False	False	False	%s	Yes
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey
CustomFieldContactsBirthday	12	VARCHAR	30	True	True	True	False	%s
CustomFieldCustomerSince	12	VARCHAR	30	True	True	True	False	%s
CustomFieldSpousesName	12	VARCHAR	30	True	True	True	False	%s
CustomFieldWebsite	12	VARCHAR	30	True	True	True	False	%s

QODBC.com Tools for QuickBooks