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 |