Web Order Data Download File Format

The Web Order Data Download file is a plain text file. It is comprised of two types of records: an order header record and line item records. The first five (5) lines are a copy of this documentation for reference and convenience. There will be one order header record for each order. The related line item records follow. Data fields are tab (ASCII character 9) delimited, while the records are newline (ASCII character 10) delimited.

Header Record Format

  • Record Type Indicator, this is always 'H' for header records
  • Order Date (mm/dd/yyyy)
  • Full Name
  • Phone Number
  • User ID
  • Order Number
  • PO Number, will be NULL when payment was made via credit card
  • Charge Code/Reference Number, value depends on whether payment was made via PO or credit card
  • Ship To Attention
  • Comments
  • Order Total
  • Order Level Accounting Data, Line 1
  • Order Level Accounting Data, Line 2
  • Order Level Accounting Data, Line 3
  • Order Level Accounting Data, Line 4
  • Order Level Accounting Data, Line 5
  • Order Level Accounting Data, Line 6

    Line Item Record Format

    • Record Type Indicator, this is always 'L' for line item records
    • Line Number
    • Catalog Number
    • Unit Of Measure
    • Description
    • Quantity Ordered
    • Comments
    • Unit Price
    • Line Total
    • Order Number
    • PO Number
    • Line Level Accounting Data, Line 1
    • Line Level Accounting Data, Line 2
    • Line Level Accounting Data, Line 3
    • Line Level Accounting Data, Line 4
    • Line Level Accounting Data, Line 5
    • Line Level Accounting Data, Line 6