Each column in a database is required to have a name and a data type to define what value a column can hold. These are the data types/character limits stored for each column for customer orders, purchase orders and items.
Customer Order:
| Name | Type |
| Order Source | varchar(20) |
| Placed On | datetime |
| Order Reference Number | varchar(50) |
| Order Number | varchar(50) |
| Client ID (3PL only) | int(11) |
| On Hold | binary(1) |
| Hold Until | datetime |
| Project Number | varchar(20) |
| Discount Percentage | decimal(6,2) |
| Buyer Paid Shipping | decimal(18,2) |
| Shipment Carrier Code | varchar(50) |
| Shipment Service Code | varchar(50) |
| Userfield1 | varchar(100) |
| Userfield2 | varchar(100) |
| Userfield3 | varchar(100) |
| MyList1 | varchar(100) |
| MyList2 | varchar(100) |
| Ship Via | varchar(50) |
| Shipment Packaging | varchar(100) |
| Shipment Confirmation | varchar(50) |
| Dry Ice Weight | decimal(18,6) |
| Internal Note | text |
| Note From Customer | text |
| Note To Customer | text |
| Weight | decimal(18,6) |
| Ship-From Warehouse ID | int(11) |
| Secondary Notification Email | varchar(80) |
| Package SKU | varchar(40) |
Purchase Order:
| Name | Type |
| PO Number | varchar(30) |
| Required By | date |
| Ship Method | varchar(30) |
| Terms | varchar(30) |
| Project Number | varchar(20) |
| Supplier Contact | varchar(100) |
| Supplier Address1 | varchar(50) |
| Supplier Address2 | varchar(50) |
| Supplier Address3 | varchar(50) |
| Supplier City | varchar(50) |
| Supplier State | varchar(50) |
| Supplier Zip Code | varchar(20) |
| Supplier Country Code | varchar(3) |
| Created Date | datetime |
| companyname | varchar(40) |
| PO Notes | varchar(512) |
| Userfield1 | varchar(100) |
| Userfield2 | varchar(100) |
| Userfield3 | varchar(100) |
| MyList1 | varchar(100) |
| MyList2 | varchar(100) |
Customer:
| Name | Type |
| Customerid | int(11) |
| Title | varchar(20) |
| Name | varchar(50) |
| Surname | varchar(50) |
| Emailaddress | varchar(80) |
| CompanyidIndex | int(11) |
| AccountnumberIndex | varchar(50) |
| Companyname | varchar(64) |
| DeletedIndex | binary(1) |
| Deletedby | int(11) |
| Deleteddate | datetime |
| Redactionreason | varchar(256) |
| ClientidIndex | int(11) |
| Qbstatus | int(11) |
| Qbsequence | varchar(16) |
| Qblistid | varchar(50) |
| Fax | varchar(50) |
| Mobile | varchar(50) |
| Defaultdiscountpercentage | decimal(6,2) |
| Shippingbillingmode | int(11) |
| Importlogid | int(11) |
| Customertypeid | varchar(50) |
| Wholesale | tinyint(1) |
| Packingslip | varchar(50) |
| Budgetenabled | binary(1) |
| Budgetamount | decimal(12,2) |
| Budgetresetmonth | int(2) |
| Budgetresetday | int(2) |
Items:
| Name | Type |
| SKU | varchar(40) |
| UPC | varchar(30) |
| Description | varchar(150) |
| Category | varchar(50) |
| UOM | varchar(24) |
| Sales Price | decimal(18,6) |
| Weight | decimal(18,6) |
| Default Econ Order | decimal(12,2) |
| Default Lead Time | int(3) |
| Kit | int(1) |
| Perishable | binary(1) |
| Lot Tracked | binary(1) |
| Active | binary(1) |
| Non-Inventory | binary(1) |
| Assembly | binary(1) |
| Length | decimal(12,4) |
| Width | decimal(12,4) |
| Height | decimal(12,4) |
| Storage Length | decimal(18,6) |
| Storage Width | decimal(18,6) |
| Storage Height | decimal(18,6) |
| Storage Volume | decimal(18,6) |
| Serialized | binary(1) |
| Unit Cost | decimal(18,6) |
| Recommended Retail Price | decimal(18,6) |
| Userfield1 | varchar(100) |
| Userfield2 | varchar(100) |
| Userfield3 | varchar(100) |
| Notes | varchar(500) |
| Userfield4 | varchar(100) |
| Userfield5 | varchar(100) |
| Userfield6 | datetime |
| Manufacturer Website | varchar(100) |