Advanced Users
      Back to home
      1. Help Center
      2. API and XML documentation
      3. Advanced Users

      Max Field Lengths / Character Limits

      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)

       

       

       

       

       

       

       

       

       

       

       

       

       

      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)