Field Listing for Table COMPANYADDRESSES
Field: | SITENAME | 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: | DELIVERYCONTACT | Type: | VARCHAR Length: 30 |
Field: | DELIVERYPHONE | Type: | VARCHAR Length: 20 |
Field: | DELIVERYFAX | Type: | VARCHAR Length: 20 |
Field: | DELIVERYNOTES | Type: | BLOB |
Field: | REPLENISHFROMSITE | Type: | VARCHAR Length: 50 |
Field: | DEFAULTPOSWAREHOUSE | Type: | VARCHAR Length: 20 |
Field: | DEFAULTPOSLOCATION | Type: | VARCHAR Length: 20 |
Field: | DEFAULTPOSSALESTYPE | Type: | VARCHAR Length: 20 |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |