|
Seq. No. |
Input Field Name |
Data Type |
Length |
Starting Position |
Ending Position |
Required or Optional |
Notes |
GL Coding Table Column |
Keyword Type |
|---|---|---|---|---|---|---|---|---|---|
|
1 |
Record Type |
Alphanumeric |
1 |
1 |
1 |
Required |
Will always be "H" in the input file |
---- |
---- |
|
2 |
Vendor ID |
Alphanumeric |
15 |
2 |
16 |
Required |
|||
|
3 |
Invoice Number |
Alphanumeric |
15 |
17 |
31 |
Required |
InvoiceNumber |
Invoice Number |
|
|
4 |
Invoice Date |
Date (MM/dd/yyyy) |
10 |
32 |
41 |
Required |
InvoiceDate |
Invoice Date |
|
|
5 |
Invoice Amount |
Decimal (14,2) |
16 |
42 |
57 |
Required |
Amount |
Invoice Amount |
|
|
6 |
PO Number |
Alphanumeric |
10 |
58 |
67 |
Optional |
---- |
PO Number |
|
|
7 |
PO Release |
Numeric |
3 |
68 |
70 |
Optional |
---- |
PO Release |
|
|
8 |
Billing Period From |
Date (MM/dd/yyyy) |
10 |
71 |
80 |
Optional |
---- |
Billing Start Date |
|
|
9 |
Billing Period To |
Date (MM/dd/yyyy) |
10 |
81 |
90 |
Optional |
---- |
Billing End Date |