This file record layout is used to import a file to create invoice records.
Field | Length | Type | Description |
---|---|---|---|
Customer Number | 6 | Numeric | Required; must match a customer record in Accounts Receivable |
Requested By | 35 | Character | Required if Customer PO Number is blank |
Customer PO Number | 20 | Alphanumeric | Required if Requested By field is blank |
Date Requested | 8 | YYYYMMDD | Optional; can default to current date |
Description (Invoice) | 80 | Character | Required; could be workshop name and participant name; is used as the sort criteria on the invoice |
Account Code | 20 | Alphanumeric | Required |
Amount | 11 | Numeric | If blank, the field is set to zero. Decimal places are not implied. |
Reference | 20 | Character | Optional |
Due Date | 8 | YYYYMMDD | Optional |
Quantity | 7 | Numeric | Optional |
Unit of Issue | Optional, populated from list. | ||
Product Type | Optional, populated from product number. | ||
Unit Price | 11 | Numeric | Optional |
Notes: