| Field: | CUSTOMER | Type: | VARCHAR Length: 50 |
| Field: | CUSTOMERTYPE | Type: | VARCHAR Length: 20 |
| Field: | CUSTOMERSTATUS | Type: | VARCHAR Length: 20 |
| Field: | CUSTOMERSTYLE | Type: | VARCHAR Length: 10 |
| Field: | CUSTOMERINVOICENAME | Type: | VARCHAR Length: 150 |
| 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: | CUSTOMERNOTES | Type: | BLOB |
| Field: | PRINTSTATEMENT | Type: | BOOLEAN |
| Field: | PRICELEVEL | Type: | VARCHAR Length: 20 |
| Field: | DISCOUNTPERCENT | Type: | DOUBLE |
| Field: | CREDITTERM | Type: | VARCHAR Length: 20 |
| Field: | ONCREDITSTOP | Type: | BOOLEAN |
| Field: | CREDITSTOPMESSAGE | Type: | VARCHAR Length: 50 |
| Field: | CREDITWARNINGMESSAGE | Type: | VARCHAR Length: 50 |
| Field: | CREDITLIMITAPPLIES | Type: | BOOLEAN |
| Field: | CREDITLIMIT | Type: | DOUBLE |
| Field: | AGINGDAYSOVERRIDE | Type: | BOOLEAN |
| Field: | MAXDAYSAGING | Type: | INTEGER |
| Field: | LEADSOURCE | Type: | VARCHAR Length: 20 |
| Field: | TAXGROUP | Type: | VARCHAR Length: 10 |
| Field: | DEFAULTCONTRACTCODE | Type: | VARCHAR Length: 20 |
| 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: | RATELEVEL | Type: | VARCHAR Length: 20 |
| Field: | INVOICECONSOLIDATION | Type: | VARCHAR Length: 25 |
| Field: | INVOICINGGROUP | Type: | VARCHAR Length: 20 |
| Field: | STATEMENTCYCLE | Type: | VARCHAR Length: 20 |
| Field: | LASTSTATEMENTTIME | Type: | TIMESTAMP |
| Field: | PURCHASEORDERMANDATORY | Type: | BOOLEAN |
| Field: | OVERDELIVERYTOLERANCE | Type: | INTEGER |
| Field: | OUTPUTFORSALESORDER | Type: | VARCHAR Length: 20 |
| Field: | OUTPUTFORINVOICE | Type: | VARCHAR Length: 20 |
| Field: | INVOICEEMAIL | Type: | VARCHAR Length: 100 |
| Field: | INVOICEEMAILCC | Type: | VARCHAR Length: 100 |
| Field: | INVOICEEMAILBCC | Type: | VARCHAR Length: 100 |
| Field: | OUTPUTFORSTATEMENT | Type: | VARCHAR Length: 20 |
| Field: | STATEMENTEMAIL | Type: | VARCHAR Length: 100 |
| Field: | STATEMENTEMAILCC | Type: | VARCHAR Length: 100 |
| Field: | STATEMENTEMAILBCC | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_1 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_2 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_3 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_4 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_5 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_6 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_7 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_8 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALDATEFIELD_1 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_2 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_3 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_4 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_5 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_6 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_7 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_8 | Type: | DATE |
| Field: | DEFAULTPAYER | Type: | VARCHAR Length: 50 |
| Field: | DEFAULTBANK | Type: | VARCHAR Length: 30 |
| Field: | DEFAULTBRANCH | Type: | VARCHAR Length: 30 |
| Field: | DEFAULTPAYMENTMETHOD | Type: | VARCHAR Length: 20 |
| Field: | SERVICEAGREEMENT | Type: | VARCHAR Length: 30 |
| Field: | SEVERITYLEVEL | Type: | INTEGER |
| Field: | WORKSUNDAY | Type: | BOOLEAN |
| Field: | STARTSUNDAY | Type: | TIME |
| Field: | FINISHSUNDAY | Type: | TIME |
| Field: | WORKMONDAY | Type: | BOOLEAN |
| Field: | STARTMONDAY | Type: | TIME |
| Field: | FINISHMONDAY | Type: | TIME |
| Field: | WORKTUESDAY | Type: | BOOLEAN |
| Field: | STARTTUESDAY | Type: | TIME |
| Field: | FINISHTUESDAY | Type: | TIME |
| Field: | WORKWEDNESDAY | Type: | BOOLEAN |
| Field: | STARTWEDNESDAY | Type: | TIME |
| Field: | FINISHWEDNESDAY | Type: | TIME |
| Field: | WORKTHURSDAY | Type: | BOOLEAN |
| Field: | STARTTHURSDAY | Type: | TIME |
| Field: | FINISHTHURSDAY | Type: | TIME |
| Field: | WORKFRIDAY | Type: | BOOLEAN |
| Field: | STARTFRIDAY | Type: | TIME |
| Field: | FINISHFRIDAY | Type: | TIME |
| Field: | WORKSATURDAY | Type: | BOOLEAN |
| Field: | STARTSATURDAY | Type: | TIME |
| Field: | FINISHSATURDAY | Type: | TIME |
| Field: | DEFAULTLISTCODE | Type: | VARCHAR Length: 50 |
| Field: | MEMBERSHIPNUMBER | Type: | VARCHAR Length: 30 |
| Field: | POSMESSAGE | Type: | VARCHAR Length: 200 |
| Field: | UNIQUEPURCHASEORDER | Type: | BOOLEAN |
| Field: | CUSTOMERPRIORITY | Type: | BOOLEAN |
| Field: | FULLDELIVERYONLY | Type: | BOOLEAN |
| Field: | CURRENCYCODE | Type: | VARCHAR Length: 3 |
| Field: | FOREIGNCURRENCY | Type: | BOOLEAN |
| Field: | SAMEPOSTALANDPHYSICAL | Type: | BOOLEAN |
| Field: | SENDINVOICETOOTHERCUSTOMER | Type: | BOOLEAN |
| Field: | INVOICESENDTOCUSTOMER | Type: | VARCHAR Length: 50 |
| Field: | TOTALAMOUNTDUE | Type: | DOUBLE |
| Field: | TOTALAMOUNTUNAPPLIED | Type: | DOUBLE |
| Field: | OVERRIDEPRICELEVEL | Type: | VARCHAR Length: 20 |
| Field: | AVERAGEPAYMENTDAYS | Type: | DOUBLE |
| Field: | INVOICETAXROUNDING | Type: | BOOLEAN |
| Field: | COMPANYOFFICIALNUMBER | Type: | VARCHAR Length: 30 |
| Field: | EMAILINVOICETOORDER | Type: | BOOLEAN |
| Field: | EMAILDELIVERADVICE | Type: | BOOLEAN |
| Field: | DELIVERYEMAIL | Type: | VARCHAR Length: 100 |
| Field: | DELIVERYCCEMAIL | Type: | VARCHAR Length: 100 |
| Field: | DELIVERYBCCEMAIL | Type: | VARCHAR Length: 100 |
| Field: | CUSTOMERMESSAGE | Type: | VARCHAR Length: 200 |
| Field: | ORDERMESSAGE | Type: | VARCHAR Length: 200 |
| Field: | INVOICEMESSAGE | Type: | VARCHAR Length: 200 |
| Field: | PAYMENTMESSAGE | Type: | VARCHAR Length: 200 |
| Field: | EXTERNALCODE | Type: | VARCHAR Length: 50 |
| Field: | BUSINESSCATEGORY | Type: | VARCHAR Length: 100 |
| Field: | PRODUCTSANDSERVICES | Type: | BLOB |
| Field: | PROSPECTCONVERSIONDATE | Type: | DATE |
| Field: | SERVICEZONE | Type: | VARCHAR Length: 30 |
| Field: | EXPIRYDAYSREMAINING | Type: | INTEGER |
| Field: | MOBILITYNOTES | Type: | BLOB |
| Field: | MOBILITYPASSWORD | Type: | VARCHAR Length: 30 |
| Field: | SYSDATECREATED | Type: | TIMESTAMP |
| Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
| Field: | SYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
| Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |
| Field: | MOBILITYBTOBACTIVE | Type: | BOOLEAN |
| Field: | MOBILITYLINKEDEMPLOYEE | Type: | VARCHAR Length: 30 |
| Field: | MOBILITYEMAILADDRESS | Type: | VARCHAR Length: 255 |