| CONTRACT |
1 |
String*16 |
^1 |
E A K R |
Mask: %-16C |
| PROJECT |
2 |
String*16 |
^2 |
E A K R |
Mask: %-16N |
| CATEGORY |
3 |
String*16 |
^3 |
E A K R |
Mask: %-16N |
| RESOURCE |
4 |
String*24 |
Resource |
E A K R |
Mask: %-24C |
| TRANSNUM |
5 |
Long |
Transaction Number |
E A K R |
|
| PROJTYPE |
6 |
Integer |
^2 Type |
E A |
|
| COSTNUM |
7 |
Long |
Cost Transaction Number |
E A |
|
| REVNUM |
8 |
Long |
Revenue Transaction Number |
E A |
|
| COSTREV |
9 |
Integer |
Cost or Revenue |
E A |
|
| DOCNUM |
10 |
String*24 |
Document Number |
E A |
|
| DOCTYPE |
11 |
Integer |
Document Type |
E A |
List:31 entries
| 1 |
= |
Invoice |
| 2 |
= |
Debit Note |
| 3 |
= |
Credit Note |
| 4 |
= |
Interest |
| 5 |
= |
Prepayment |
| 6 |
= |
Unapplied Cash |
| 7 |
= |
Material Usage |
| 8 |
= |
Material Return |
| 9 |
= |
Equipment Usage |
| 10 |
= |
Timecard |
| 11 |
= |
Charges |
| 12 |
= |
Adjustment |
| 13 |
= |
Retainage Invoice |
| 14 |
= |
Retainage Credit Note |
| 15 |
= |
Retainage Debit Note |
| 16 |
= |
Purchase Order |
| 17 |
= |
P/O Receipt |
| 18 |
= |
P/O Return |
| 19 |
= |
P/O Invoice |
| 20 |
= |
P/O Credit Note |
| 21 |
= |
P/O Debit Note |
| 22 |
= |
Opening Balance |
| 23 |
= |
Manual Check |
| 24 |
= |
Cost |
| 25 |
= |
Check Reversal |
| 26 |
= |
Material Internal Usage |
| 27 |
= |
Order Entry |
| 28 |
= |
O/E Shipment |
| 29 |
= |
O/E Invoice |
| 30 |
= |
O/E Debit Note |
| 31 |
= |
O/E Credit Note |
|
| TRANSDATE |
12 |
Date |
Transaction Date |
E A |
|
| FISCALYEAR |
13 |
String*4 |
Fiscal Year |
E A |
Mask: %04D |
| FISCALPER |
14 |
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 |
|
| REFERENCE |
15 |
String*60 |
Document Reference |
E A |
|
| DESC |
16 |
String*60 |
Document Description |
E A |
|
| BILLTYPE |
17 |
Integer |
Billing Type |
E A |
List:3 entries
| 2 |
= |
Billable |
| 3 |
= |
No Charge |
| 1 |
= |
Non-billable |
|
| TIMETYPE |
18 |
Integer |
Time Type |
E A |
|
| COSTCCY |
19 |
String*3 |
Cost Currency |
E A |
|
| ARITEM |
20 |
String*16 |
A/R Item No. |
E A |
|
| ARUOM |
21 |
String*10 |
A/R Unit of Measure |
E A |
|
| ICUOM |
22 |
String*10 |
^7 |
E A |
|
| ITEMNO |
23 |
String*24 |
Item No. |
E A |
|
| LOCATION |
24 |
String*6 |
I/C Location |
E A |
|
| QUANTITY |
25 |
BCD*10.5 |
Transaction Quantity |
E A |
|
| UNITCOST |
26 |
BCD*10.6 |
Unit Cost |
E A |
|
| BILLRATE |
27 |
BCD*10.6 |
Billing Rate |
E A |
|
| EXTCOSTHM |
28 |
BCD*10.3 |
Extended Cost Amount |
E A |
|
| EXTCOSTSR |
29 |
BCD*10.3 |
Extended Cost Amount |
E A |
|
| EXTBILLHM |
30 |
BCD*10.3 |
Extended Billing Amount |
E A |
|
| EXTBILLSR |
31 |
BCD*10.3 |
Extended Billing Amount |
E A |
|
| BILLCCY |
32 |
String*3 |
Billing Currency |
E A |
|
| LABOR |
33 |
Integer |
Labor Type |
E A |
List:3 entries
| 1 |
= |
None |
| 2 |
= |
Flat Rate Per Labor Hour/Unit |
| 3 |
= |
Percentage of Labor Cost |
|
| LABORRATE |
34 |
BCD*10.6 |
Labor Rate |
E A |
|
| LABORPER |
35 |
BCD*5.5 |
Labor Percentage |
E A |
|
| LABORSR |
36 |
BCD*10.3 |
Transaction Labor Amount |
E A |
|
| LABORHM |
37 |
BCD*10.3 |
Transaction Labor Amount |
E A |
|
| OVERHD |
38 |
Integer |
Overhead Type |
E A |
List:3 entries
| 1 |
= |
None |
| 2 |
= |
Flat Rate Per Unit |
| 5 |
= |
Percentage of Cost |
|
| OHEADRATE |
39 |
BCD*10.6 |
Overhead Rate |
E A |
|
| HEADPER |
40 |
BCD*5.5 |
Overhead Percentage |
E A |
|
| OHSR |
41 |
BCD*10.3 |
Transaction Overhead Amount |
E A |
|
| OHHM |
42 |
BCD*10.3 |
Transaction Overhead Amount |
E A |
|
| MODULE |
43 |
String*4 |
Source Module |
E A |
|
| REVBILLED |
44 |
Integer |
Has The Cost Component Been Billed |
E A |
List:7 entries
| 1 |
= |
Not Billed |
| 2 |
= |
Selected for Processing |
| 3 |
= |
Invoice Created |
| 4 |
= |
Posted |
| 5 |
= |
Deleted |
| 6 |
= |
Moved |
| 7 |
= |
On Hold |
|
| RRCOMPLETE |
45 |
Integer |
Has Revenue Recognition Been Run |
E A |
List:3 entries
| 1 |
= |
Not Processed |
| 2 |
= |
Selected for Processing |
| 3 |
= |
Posted |
|
| CVACCT |
46 |
String*45 |
Cost Variance Account |
E A |
|
| WIPACCT |
47 |
String*45 |
WIP/COS Account |
E A |
|
| TRANACCT |
48 |
String*45 |
Transaction Account |
E A |
|
| REVACCT |
49 |
String*45 |
Revenue Account |
E A |
|
| OHACCT |
50 |
String*45 |
Overhead Account |
E A |
|
| LABACCT |
51 |
String*45 |
Labor Account |
E A |
|
| REVREC |
52 |
Integer |
Accounting Method |
E A C |
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 |
53 |
Integer |
Invoice Type |
E A C |
List:2 entries
|
| EARNINGS |
54 |
String*16 |
Earnings Code |
E A |
|
| DATEBUS |
55 |
Date |
Posting Date |
E A |
|
| STAFFCODE |
56 |
String*24 |
Employee No. |
E A |
|
|