Field Listing for Table FINANCIALCUSTOMERS

Field:CUSTOMER Type: VARCHAR Length: 50
Field:CUSTOMERTYPE Type: VARCHAR Length: 20
Field:CUSTOMERSTATUS Type: VARCHAR Length: 20
Field:CUSTOMERINVOICENAME Type: VARCHAR Length: 50
Field:CUSTOMERADDRESS1 Type: VARCHAR Length: 50
Field:CUSTOMERADDRESS2 Type: VARCHAR Length: 50
Field:CUSTOMERADDRESS3 Type: VARCHAR Length: 50
Field:CUSTOMERPOSTALCODE Type: VARCHAR Length: 20
Field:CUSTOMERSTATE Type: VARCHAR Length: 20
Field:CUSTOMERCITY Type: VARCHAR Length: 30
Field:CUSTOMERCOUNTRY Type: VARCHAR Length: 30
Field:PRIMARYCONTACT Type: VARCHAR Length: 100
Field:CUSTOMERPHONE Type: VARCHAR Length: 20
Field:CUSTOMERFAX Type: VARCHAR Length: 20
Field:CUSTOMEREMAIL Type: VARCHAR Length: 100
Field:CUSTOMERMOBILE Type: VARCHAR Length: 20
Field:CUSTOMERWEB Type: VARCHAR Length: 100
Field:CUSTOMERREGIONCODE Type: VARCHAR Length: 20
Field:CUSTOMERANALYSISCODE Type: VARCHAR Length: 20
Field:CREDITTERM Type: VARCHAR Length: 20
Field:TAXGROUP Type: VARCHAR Length: 10
Field:SALESPERSON Type: VARCHAR Length: 30
Field:SHIPPINGMETHOD Type: VARCHAR Length: 20
Field:USEBILLCUSTOMER Type: BOOLEAN
Field:BILLINGCUSTOMER Type: VARCHAR Length: 50
Field:DELIVERYADDRESS1 Type: VARCHAR Length: 50
Field:DELIVERYADDRESS2 Type: VARCHAR Length: 50
Field:DELIVERYADDRESS3 Type: VARCHAR Length: 50
Field:DELIVERYPOSTALCODE Type: VARCHAR Length: 20
Field:DELIVERYSTATE Type: VARCHAR Length: 20
Field:DELIVERYCITY Type: VARCHAR Length: 30
Field:DELIVERYCOUNTRY Type: VARCHAR Length: 30
Field:BANKACCOUNTNAME Type: VARCHAR Length: 20
Field:BANKACCOUNTNUMBER Type: VARCHAR Length: 20
Field:CURRENCYCODE Type: VARCHAR Length: 3
Field:INSERTEDORUPDATED Type: VARCHAR Length: 10
Field:BATCHFILENO Type: DOUBLE
Field:TRANSACTIONSTATUS Type: VARCHAR Length: 20
Field:TRANSACTIONMESSAGE Type: VARCHAR Length: 300
Field:SOURCESYSUNIQUEID Type: DOUBLE
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE