Suppliers
less than a minute
| Name | Type | Size | Description |
|---|---|---|---|
| ACTIVEID | Long Integer | 4 | |
| ActiveTitle | Text | 255 | |
| Address1 | Text | 255 | Titel |
| Address2 | Text | 255 | Name 1 |
| Address3 | Text | 255 | Name 2 |
| Address4 | Text | 255 | Street |
| Address5 | Text | 255 | City |
| Address6 | Text | 255 | Country |
| Address7 | Text | 255 | |
| Address8 | Text | 255 | FAO |
| Address9 | Text | 255 | |
| ZipCode | Text | 255 | Zip Code (since version 12.0) |
| ColSortOutsideInside | Bool | 1 | Supplier wants the color sorting for orders from outside to inside |
| CustomerNo | Text | 255 | Customer Number |
| DelAddress1 | Text | 255 | Delivery Address - Titel |
| DelAddress2 | Text | 255 | Delivery Address - Name 1 |
| DelAddress3 | Text | 255 | Delivery Address - Name 2 |
| DelAddress4 | Text | 255 | Delivery Address - Street |
| DelAddress5 | Text | 255 | Delivery Address - City |
| DelAddress6 | Text | 255 | Delivery Address - Country |
| DelAddress7 | Text | 255 | |
| DelAddress8 | Text | 255 | Delivery Address - FAO |
| DelAddress9 | Text | 255 | |
| Text | 255 | E-Mailaddress | |
| Fax | Text | 255 | Fax number |
| LK_DeliveryAddressID | Long Integer | 4 | LOOKUP KEY refers to Address.AddressID** ** |
| LK_VendorAddressID | Long Integer | 4 | LOOKUP KEY refers to Address.AddressID** ** |
| Phone1 | Text | 255 | Phone number 1 |
| Phone2 | Text | 255 | Phone number 2 |
| PriceLevel | Datum/Uhrzeit | 8 | Date of price level |
| SupplierID | Long Integer | 4 | PRIMARY KEY |