
InventoryControl Printable Help
16.4.6 Supplier Table Properties:
Field Name Data Type Size (Precision,
Scale)
Address 1 varchar 100
Address 2 varchar 100
City varchar 50
Contact Cell No varchar 20
Contact Ext. varchar 10
Contact FAX varchar 20
Contact Name varchar 50
Contact Phone varchar 20
Country varchar 50
Custom Date 1 datetime 8
Custom Date 2 datetime 8
Custom Date 3 datetime 8
Custom Date 4 datetime 8
Custom Date 5 datetime 8
Custom Number 1 decimal 9(15,4)
Custom Number 2 decimal 9(15,4)
Custom Number 3 decimal 9(15,4)
Custom Number 4 decimal 9(15,4)
Custom Number 5 decimal 9(15,4)
Custom Text 1 varchar 100
Custom Text 2 varchar 100
Custom Text 3 varchar 100
Custom Text 4 varchar 100
Custom Text 5 varchar 100
Custom Text 6 varchar 100
Custom Text 7 varchar 100
Custom Text 8 varchar 100
Custom Text 9 varchar 100
Custom Text 10 varchar 100
Email varchar 250
Extension varchar 10
FAX varchar 20
Mail Stop varchar 20
Name varchar 50
Notes varchar 1000
Phone varchar 20
Postal Code varchar 10
State varchar 50
Supplier Code varchar 30
Web Site varchar 255
274
Kommentare zu diesen Handbüchern