| SEQ |
1 |
Long |
Sequence |
E A K R |
|
| LINENO |
2 |
Long |
Line Number |
E A K R |
|
| DOCNUM |
3 |
String*24 |
Document Number |
E A C |
|
| LINETYPE |
4 |
Integer |
Line Type |
E A |
List: 7 entries
| 1 | = | Miscellaneous Cost | | 2 | = | Time | | 3 | = | Expense | | 4 | = | Equipment | | 5 | = | Material Usage | | 6 | = | Material Return | | 7 | = | Charge |
|
| FMTCONTNO |
5 |
String*16 |
^1 |
E A X |
Mask: %-16C |
| CONTRACT |
6 |
String*16 |
^1 |
E A X |
Mask: %-16C |
| PROJECT |
7 |
String*16 |
^2 |
E A X |
Mask: %-16N |
| CATEGORY |
8 |
String*16 |
^3 |
E A X |
Mask: %-16N |
| RESOURCE |
9 |
String*24 |
Resource |
E A P X |
Mask: %-16N |
| TYPE |
10 |
Integer |
Cost Class |
A |
List: 6 entries
| 1 | = | Labor | | 2 | = | Material | | 3 | = | Equipment | | 4 | = | Subcontractor | | 5 | = | Overhead | | 6 | = | Miscellaneous |
|
| CHARGECODE |
11 |
String*16 |
Charge Code |
E A X |
Mask: %-16N |
| DESC |
12 |
String*60 |
Description |
E A X |
|
| QUANTITY |
13 |
BCD*10.5 |
Quantity |
A X |
|
| ARITEM |
14 |
String*16 |
A/R Item No. |
A X |
Mask: %-16C |
| ARUOM |
15 |
String*10 |
A/R Unit of Measure |
A X |
Mask: %-10C |
| UNITCOST |
16 |
BCD*10.6 |
Unit Cost |
A X |
|
| COSTCCY |
17 |
String*3 |
Cost Currency |
A |
Mask: %-3N |
| EXTCOSTSR |
18 |
BCD*10.3 |
Extended Cost |
A X |
|
| EXTCOSTHM |
19 |
BCD*10.3 |
Extended Cost (HM) |
A |
|
| OVERHD |
20 |
Integer |
Overhead Type |
A C |
List: 3 entries
| 1 | = | None | | 2 | = | Flat Rate Per Unit | | 5 | = | Percentage of Cost |
|
| OHEADRATE |
21 |
BCD*10.6 |
Overhead Rate |
A |
|
| HEADPER |
22 |
BCD*5.5 |
Overhead Percentage |
A |
|
| OHSR |
23 |
BCD*10.3 |
Overhead Amount |
A |
|
| OHHM |
24 |
BCD*10.3 |
Overhead Amount (HM) |
A |
|
| LABOR |
25 |
Integer |
Labor Type |
A X |
|
| LABORRATE |
26 |
BCD*10.6 |
Labor Rate |
A X |
|
| LABORPER |
27 |
BCD*5.5 |
Labor Percentage |
A X |
|
| LABORSR |
28 |
BCD*10.3 |
Transaction Labor Amount (Source) |
A X |
|
| LABORHM |
29 |
BCD*10.3 |
Transaction Labor Amount (Functional) |
A X |
|
| TOTCOSTSR |
30 |
BCD*10.3 |
Total Cost |
A |
|
| TOTCOSTHM |
31 |
BCD*10.3 |
Total Cost (HM) |
A |
|
| COMMENTS |
32 |
String*250 |
Comments |
A X |
|
| TRANACCT |
33 |
String*45 |
Cost Account |
A X |
Mask: %-45C |
| OHACCT |
34 |
String*45 |
Overhead Account |
A |
Mask: %-45C |
| LABORACCT |
35 |
String*45 |
Labor Account |
A X |
Mask: %-45C |
| WIPACCT |
36 |
String*45 |
Work in Progress Account |
A X |
Mask: %-45C |
| BILLTYPE |
37 |
Integer |
Billing Type |
A X |
List: 3 entries
| 2 | = | Billable | | 3 | = | No Charge | | 1 | = | Non-billable |
|
| BILLRATE |
38 |
BCD*10.6 |
Billing Rate |
A X |
|
| EXTBILLSR |
39 |
BCD*10.3 |
Billing Amount |
A X |
|
| EXTBILLHM |
40 |
BCD*10.3 |
Billing Amount (HM) |
A |
|
| BILLCCY |
41 |
String*3 |
Billing Currency |
A |
Mask: %-3N |
| DETAILNUM |
42 |
Long |
Detail Number |
E A C |
|
| TAUTH1 |
43 |
String*12 |
Tax Authority 1 |
A |
Mask: %-12N |
| TAUTH2 |
44 |
String*12 |
Tax Authority 2 |
A |
Mask: %-12N |
| TAUTH3 |
45 |
String*12 |
Tax Authority 3 |
A |
Mask: %-12N |
| TAUTH4 |
46 |
String*12 |
Tax Authority 4 |
A |
Mask: %-12N |
| TAUTH5 |
47 |
String*12 |
Tax Authority 5 |
A |
Mask: %-12N |
| TCLASS1 |
48 |
Integer |
Tax Class 1 |
A X |
|
| TCLASS2 |
49 |
Integer |
Tax Class 2 |
A X |
|
| TCLASS3 |
50 |
Integer |
Tax Class 3 |
A X |
|
| TCLASS4 |
51 |
Integer |
Tax Class 4 |
A X |
|
| TCLASS5 |
52 |
Integer |
Tax Class 5 |
A X |
|
| TINCLUDED1 |
53 |
Boolean |
Tax Included 1 |
A X |
|
| TINCLUDED2 |
54 |
Boolean |
Tax Included 2 |
A X |
|
| TINCLUDED3 |
55 |
Boolean |
Tax Included 3 |
A X |
|
| TINCLUDED4 |
56 |
Boolean |
Tax Included 4 |
A X |
|
| TINCLUDED5 |
57 |
Boolean |
Tax Included 5 |
A X |
|
| CONTSTYLE |
58 |
Integer |
Contract Style |
A C X |
List: 2 entries
|
| PROJTYPE |
59 |
Integer |
Project Type |
A C X |
List: 3 entries
| 1 | = | Time and Materials | | 2 | = | Fixed Price | | 3 | = | Cost Plus |
|
| CUSTOMER |
60 |
String*12 |
Customer |
A C X |
Mask: %-12C |
| REVREC |
61 |
Integer |
Revenue Rec. Type |
A C X |
List: 7 entries
| 1 | = | Completed Project | | 2 | = | Total Cost Percentage Complete | | 3 | = | Labor Hours Percentage Complete | | 4 | = | Billings and Costs | | 5 | = | Project Percentage Complete | | 6 | = | Category Percentage Complete | | 8 | = | Accrual-Basis |
|
| INVTYPE |
62 |
Integer |
Inventory Type |
A C X |
List: 2 entries
|
| VALUES |
63 |
Long |
Optional Fields |
E A C |
|
| PAYTYPE |
64 |
Integer |
Pay Type |
A C X |
|
| TRANSDATE |
65 |
Date |
Transaction Date |
A X |
|
| EXPENSE |
66 |
String*16 |
Expense |
A X |
|
| EXPTYPE |
67 |
Integer |
Expense Type |
A X |
|
| LOCATION |
68 |
String*6 |
Location |
A X |
|
| ICUOM |
69 |
String*10 |
I/C Unit of Measure |
A X |
Mask: %-10c |
| CONVERSION |
70 |
BCD*10.6 |
|
A X |
|
| STOCKITEM |
71 |
Boolean |
Stock Item |
A C X |
|
| COSTMETHOD |
72 |
Integer |
Cost Method |
A C X |
|
| UNFMTITEM |
73 |
String*24 |
Unformatted Item No. |
A C X |
|
| GLDDESC |
74 |
String*60 |
G/L Detail Description |
A X |
|
| GLDREF |
75 |
String*60 |
G/L Detail Reference |
A X |
|
| GLCOMMENT |
76 |
String*250 |
G/L Detail Comment |
A X |
|
| FUNCTION |
1001 |
Integer |
Function onal) |
E A C |
|
| TRANDESC |
1003 |
String*60 |
Description onal) |
A C |
|
| WIPDESC |
1004 |
String*60 |
Description onal) |
A C |
|
| ITEMDESC |
1005 |
String*60 |
Description onal) |
A C |
|
| CONTDESC |
1009 |
String*60 |
Description onal) |
A C |
|
| PROJDESC |
1010 |
String*60 |
Description onal) |
A C |
|
| CATDESC |
1011 |
String*60 |
Description onal) |
A C |
|
| HASOPT |
1012 |
Boolean |
Optional Fields onal) |
E A C |
List: 2 entries
|
|