| CONTRACT |
1 |
String*16 |
Contract |
E A K R |
Mask: %-16C |
| PROJECT |
2 |
String*16 |
Project |
E A K R |
Mask: %-16N |
| CATEGORY |
3 |
String*16 |
Category |
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 |
Project 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 |
IC Unit of Measure |
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 |
|
|