File format INVOICES
1 INSEQ sequence #
2 INNUM Invoice Number
3 IN_DATE Invoice Date
4 IN_ORN Original Order Number
5 IN_ODATE Original Order Date
6 IN_CUSTPO Customer PO#
7 IN_DEPT Department
8 IN_COMM_RATE % Commission, Primary
9 IN_SUBTOTAL Line Item Total. before discount
10 IN_SHIP_AMT Shipping Amount+COD+Markup
11 IN_TAX_RATE %, Sales Tax or PST (Canada)
12 IN_TAX_AMT Tax Amount in dollars (PST)
13 IN_TOTAL Invoice Total
14 IN_DUE Invoice Amount Due
15 IN_DISC_PCNT Discount Rate %
16 IN_FACTOR Invoice Factored?
17 IN_TERMS Invoice Terms Description
18 IN_SHIP_VIA Description
19 IN_FACTOR_SCHED On Factor’s Schedule
20 IN_AUNUM Post Items to Sales Account#
21 IN_SHIP_NAME Ship To Name
22 IN_SHADR1 Ship To Address 1
23 IN_SHADR2 Ship To Address 2
24 IN_SHIP_COUNTRY
26 IN_MEMO Memo, Prints on Invoice
27 IN_PRINTED Invoice Printed?
28 IN_CMSNABLE_AMT Amount the Commission is Calculated on
30 IN_TYPE O=Original Order, B=BackOrder, D=DamageReturn, R=Credit Return, C=Credit Memo, V=Void, I=Interest
31 IN_SHIPPED_DATE Date Shipped, partially implemented
32 IN_COMSN_PD Date Commission was paid
33 IN_COMSN_CK Check Number of Commission Check
34 IN_WEIGHT Weight to calculate shipping charges, (or “L” for Letter=255)
35 IN_RPCODE2 Commission Rep #2 (Split Commissions)
36 IN_COM_RATE2 % Commission, Secondary (Split Commission)
37 IN_COM_DATE2 Commission Paid Date, Secondary
38 IN_COM_CK2 Check Number, Secondary Commission
41 INPOST Posted (INVENT, CBAL, FTR)
42 IN_DAYS_PAID # of Days until Paid in Full
43 IN_DIV_CODE Division Code
44 IN_SHIP_CITY
45 IN_SHIP_STATE
46 IN_SHIP_ZIP
47 IN_COLLECTION Yes if it is in Collection
51 IN_SIZE_CAT If all items are same size Category, otherwise Blank. (OSIZE_CAT)
53 IN_RPCODE1 Rep Code, Primary
54 IN_COUNTY_CODE County Code
55 IN_TERMS_CODE Pointer to Terms Code
56 IN_TAXABLE_AMT Taxable Amount on the Invoice
57 IN_GST_RATE GST Rate in % (Canada)
58 IN_GST_AMT GST Amount (Canada)
59 IN_DUE_DATE
60 IN_CCODE Pointer to Customer Code, part implemented
61 IN_DISC_AMT Discount Amount
62 IN_PICK_NUM If Invoiced from Pick Ticket
65 IN_MEMO_INT Internal Memo (A/R Note)
68 IN_SEASON_CODE Season code (defaults from Order)
69 IN_ALT_BILLADR Use Alternate Billing Address from Customer File
70 IN_FACT_APPRNUM Factor Approval Number
71 IN_SHIP_CONTACT Shipping Contact Name
72 IN_SHIP_TEL
73 IN_SHIP_FAX
74 IN_SHIP_MEMO
… and more
PF8:
For a complete list of files and field names go to
MenusSQL > SQL Column Lookup
Modified by AG, 5-26-2026