| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | Code | Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 2 | Name | Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | Warehouse | Warehouse | nvarchar | 8 | 0 | OWHS | | | Allow NULL? |
| 4 | SalePerson | Sales Employee | int | 6 | 0 | OSLP | -1 | | Allow NULL? |
| 5 | ICTCard | BP for Invoice + Payment | nvarchar | 15 | 0 | OCRD | | | Allow NULL? |
| 6 | CashAcct | Cash Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 7 | CheckAcct | Current Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 8 | CreditCard | Credit Card | int | 6 | 0 | OCRC | | | Allow NULL? |
| 9 | PrintRcpt | Print Receipt | char | 1 | 0 | | N | A, N, Y | Allow NULL? |
| 10 | ShortRcpt | Print Payment & Invoice in Succession | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 11 | Color | Windows Color | int | 6 | 0 | | 1 | 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 | Allow NULL? |
| 12 | Address | Address | nvarchar | 254 | 0 | | | | Allow NULL? |
| 13 | Country | Country | nvarchar | 3 | 0 | OCRY | | | Allow NULL? |
| 14 | PrintHeadr | Printing Header | nvarchar | 100 | 0 | | | | Allow NULL? |
| 15 | Phone1 | Telephone Number 1 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 16 | Phone2 | Telephone Number 2 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 17 | Fax | Fax Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 18 | E_Mail | E-Mail | nvarchar | 100 | 0 | | | | Allow NULL? |
| 19 | FrgnAddr | Address in Foreign Language | nvarchar | 254 | 0 | | | | Allow NULL? |
| 20 | FrnPrntHdr | Printing Header in Foreign Lan | nvarchar | 100 | 0 | | | | Allow NULL? |
| 21 | FrgnPhone1 | Telephone Number 1 (Foreign Lang.) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 22 | FrgnPhone2 | Telephone Number 2 (Foreign Lang.) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 23 | FrgnFax | Fax Number (Foreign Lang.) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 24 | DflTaxCode | Default Tax Code | nvarchar | 8 | 0 | OSTC | | | Allow NULL? |
| 25 | FreeZoneNo | Additional ID Number | nvarchar | 32 | 0 | | | | Allow NULL? |
| 26 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 27 | free1 | Free1 | char | 1 | 0 | | | | Allow NULL? |
| 28 | UseTax | Use Tax | char | 1 | 0 | | | N, Y | Allow NULL? |
| 29 | AdrsFromWh | Use Warehouse Address in A/P Documents | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 30 | Language | Language | int | 11 | 0 | | | | Allow NULL? |
| 31 | Font | Font | nvarchar | 50 | 0 | | | | Allow NULL? |
| 32 | FontSize | Font Size | int | 11 | 0 | | | | Allow NULL? |
| 33 | BPLId | Default Branch | int | 11 | 0 | OBPL | | | Allow NULL? |
