| SEQUENCENO |
1 |
Long |
|
E A K R |
|
| CNTBTCH |
2 |
BCD*5.0 |
Batch |
E A |
|
| LINENO |
3 |
Integer |
Line Number |
E A |
|
| CHECKNUM |
4 |
BCD*5.0 |
Check Number |
E A |
|
| FISCALYEAR |
5 |
String*4 |
Fiscal Year |
E A |
Mask: %04D |
| FISCALPER |
6 |
Integer |
Fiscal Period |
E A |
List:13 entries
| 1 |
= |
1 |
| 2 |
= |
2 |
| 3 |
= |
3 |
| 4 |
= |
4 |
| 5 |
= |
5 |
| 6 |
= |
6 |
| 7 |
= |
7 |
| 8 |
= |
8 |
| 9 |
= |
9 |
| 10 |
= |
10 |
| 11 |
= |
11 |
| 12 |
= |
12 |
| 13 |
= |
13 |
|
| JOURNLDATE |
7 |
Date |
G/L Journal Date |
E A |
|
| TRANSDATE |
8 |
Date |
Transaction Date |
E A |
|
| CURRENCY |
9 |
String*3 |
Currency |
E A |
Mask: %-3N |
| EXCHRATE |
10 |
BCD*8.7 |
Exchange Rate |
E A |
|
| RATETYPE |
11 |
String*2 |
Rate Type |
E A |
Mask: %-2N |
| RATEDATE |
12 |
Date |
Rate Date |
E A |
|
| RATEOP |
13 |
Integer |
Rate Operator |
E A |
List:2 entries
|
| CONTRACT |
14 |
String*16 |
^1 |
E A |
Mask: %-16C |
| PROJECT |
15 |
String*16 |
^2 |
E A |
Mask: %-16N |
| CATEGORY |
16 |
String*16 |
^3 |
E A |
Mask: %-16N |
| EMPLOYEE |
17 |
String*24 |
Employee |
E A |
|
| DOCTYPE |
18 |
Integer |
Document Type |
E A |
List:2 entries
| 1 |
= |
System Check |
| 2 |
= |
Manual Check |
|
| TRANSTYPE |
19 |
Integer |
Transaction Type |
E A |
List:2 entries
| 1 |
= |
Posted |
| 2 |
= |
Check Reversal |
|
| TRANSNUM |
20 |
Long |
PJC Transaction Number |
A C |
|
| EARNINGS |
21 |
String*6 |
Earnings or Deduction Code |
E A |
|
| QUANTITY |
22 |
BCD*10.5 |
Quantity |
E A |
|
| HOURS |
23 |
BCD*4.3 |
Hours |
E A |
|
| BASE |
24 |
BCD*10.3 |
Base |
E A |
|
| UNITRATE |
25 |
BCD*9.5 |
Unit Rate |
E A |
|
| PERCENT |
26 |
BCD*9.5 |
Percent |
E A |
|
| EXTAMTHM |
27 |
BCD*10.3 |
Extended Amount (HM) |
E A |
|
| EXTAMTSR |
28 |
BCD*10.3 |
Extended Amount (SR) |
E A |
|
| BILLRATE |
29 |
BCD*10.6 |
Billing Rate |
E A |
|
| BILLTYPE |
30 |
Integer |
Billing Type |
E A |
List:4 entries
| 0 |
= |
None |
| 2 |
= |
Billable |
| 3 |
= |
No Charge |
| 1 |
= |
Non-billable |
|
| WIPACCT |
31 |
String*45 |
WIP Account |
E A |
Mask: %-45C |
| TRANACCT |
32 |
String*45 |
Transaction Account |
E A |
Mask: %-45C |
| OHACCT |
33 |
String*45 |
Overhead Account |
E A C |
Mask: %-45C |
| OHAMTSR |
34 |
BCD*10.3 |
Overhead Amount |
E A C |
|
| OHAMTHM |
35 |
BCD*10.3 |
Overhead Amount |
E A C |
|
| LABACCT |
36 |
String*45 |
Labor Account |
E A C |
Mask: %-45C |
| LABORSR |
37 |
BCD*10.3 |
Labor Amount |
E A C |
|
| LABORHM |
38 |
BCD*10.3 |
Labor Amount |
E A C |
|
| ARITEM |
39 |
String*16 |
A/R Item Number |
E A |
Mask: %-16C |
| ARUOM |
40 |
String*10 |
A/R Unit of Measure |
E A |
Mask: %-10C |
| OVERHD |
41 |
Integer |
Overhead Type |
E A C |
List:3 entries
| 1 |
= |
None |
| 2 |
= |
Flat Rate Per Unit |
| 5 |
= |
Percentage of Cost |
|
| OHEADRATE |
42 |
BCD*10.6 |
Overhead Rate |
E A C |
|
| HEADPER |
43 |
BCD*5.5 |
Overhead Percentage |
E A C |
|
| LABOR |
44 |
Integer |
Labor Type |
E A C |
List:3 entries
| 1 |
= |
None |
| 2 |
= |
Flat Rate Per Labor Hour/Unit |
| 3 |
= |
Percentage of Labor Cost |
|
| LABORRATE |
45 |
BCD*10.6 |
Labor Rate |
E A C |
|
| LABORPER |
46 |
BCD*5.5 |
Labor Percentage |
E A C |
|
| DRILLSRCTY |
47 |
Integer |
Drill Down Type |
E A |
|
| DRILLDWNLK |
48 |
BCD*10.0 |
Drill Down Link |
E A |
|
| DRILLAPP |
49 |
String*2 |
Drill Down Application |
E A |
|
| PROJSTAT |
50 |
Integer |
^2 Status |
E A |
List:7 entries
| 10 |
= |
Estimate |
| 20 |
= |
Approved |
| 30 |
= |
Open |
| 40 |
= |
On Hold |
| 70 |
= |
Inactive |
| 60 |
= |
Completed |
| 50 |
= |
Closed |
|
| DIFF |
51 |
Integer |
Differential Record? |
E A |
|
| EXPENSEREI |
52 |
Integer |
Exp. Reimbursement? |
E A |
|
| RESOURCE |
53 |
String*24 |
Resource |
E A |
|
|