|
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 "D" in the input file |
---- |
n/a |
|
2 |
PO Line Number |
Numeric |
4 |
2 |
5 |
Optional |
Optional for non-PO invoices |
PO_LN_NO |
n/a |
|
3 |
Invoice Quantity |
Decimal (14,4) |
14 |
6 |
19 |
Optional |
Quantity |
n/a |
|
|
4 |
Unit Cost |
Decimal (14,4) |
16 |
20 |
35 |
Optional |
UnitCost |
n/a |
|
|
5 |
Vendor Hours |
Decimal (14,2) |
16 |
36 |
51 |
Required |
If no vendor labor hours, "0" must be used. |
Hours |
n/a |
|
6 |
Line Notes |
Alphanumeric |
254 |
52 |
305 |
Optional |
Notes |
n/a |
|
|
7 |
Account |
Alphanumeric |
15 |
306 |
320 |
Required |
Not required if account does not require a project. |
Account |
n/a |
|
8 |
Project |
Alphanumeric |
30 |
321 |
350 |
Required |
Project |
n/a |
|
|
9 |
Organization |
Alphanumeric |
20 |
351 |
370 |
Required |
Org |
n/a |
|
|
10 |
Vendor Empl ID |
Alphanumeric |
12 |
371 |
382 |
Optional |
VendorEmpl |
n/a |
|
|
11 |
General Labor Category |
Alphanumeric |
6 |
383 |
388 |
Optional |
Required if Vendor Hours is greater than 0. |
GLCCode |
n/a |
|
12 |
Project Labor Category |
Alphanumeric |
6 |
389 |
394 |
Optional |
PLCCode |
n/a |
|
|
13 |
Description |
Alphanumeric |
30 |
395 |
424 |
Optional |
PLCCode |
n/a |
|
|
14 |
Amount |
Decimal (14,2) |
16 |
425 |
440 |
Optional |
Field is right justified with leading zeros or spaces. |
Amount |
n/a |
|
15 |
Effective Bill Date |
Date (MM/dd/yyyy) |
10 |
441 |
450 |
Optional |
Required if Vendor Hours is greater than 0. Must leave spaces to ending position if Effective Bill Date is not populated. |
Effective Bil Date |
n/a |
|
16 |
Taxable |
Alphanumeric |
1 |
450 |
450 |
Optional |
TaxableCode |
n/a |
|
|
17 |
Taxable Code |
Alphanumeric |
1 |
451 |
451 |
Optional |
TaxableCode1 |
n/a |
|
|
18 |
Tax Code |
Alphanumeric |
17 |
452 |
468 |
Optional |
TaxCode |
n/a |
|
|
19 |
Tax Amount |
Alphanumeric |
15 |
469 |
484 |
Optional |
TaxAmount |
n/a |