
InventoryControl Printable Help
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
Customer No. varchar 30
Date Added datetime 8
Department varchar 20
Email varchar 250
FAX varchar 20
Home Phone varchar 20
Name varchar 100
Notes varchar 1000
Phone varchar 20
Cell Phone varchar 20
Customer Billing Address
1
varchar 100
Customer Billing Address
2
varchar 100
Customer Billing City varchar 50
Customer Billing State varchar 50
Customer Billing Postal
Code
varchar 10
Customer Billing Country varchar 50
Customer Billing Mail
Drop
varchar 20
Note: You may have multiple address information for shipping, mailing, etc.
16.4.2 Inventory Import Format:
Field Name Data Type Size (Precision,
Scale)
Date Acquired datetime 8
Date Code varchar 25
Item Description varchar 255
Item Number varchar 31
Location varchar 30
Lot varchar 25
Pallet varchar 25
PO varchar 25
Quantity decimal 9(18,4)
Serial Number varchar 25
270
Komentarze do niniejszej Instrukcji