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 |