POSTSEQNO |
1 |
Long |
Posting Sequence |
E A K R |
|
LINENO |
2 |
Integer |
Line Number |
E A K R |
|
SEQ |
3 |
Long |
Sequence |
E A |
|
TIMECARDNO |
4 |
String*16 |
Timecard Number |
E A |
Mask: %-6N |
FMTCONTNO |
5 |
String*16 |
Contract |
E A |
|
CONTRACT |
6 |
String*16 |
Contract |
E A |
Mask: %-16C |
PROJECT |
7 |
String*16 |
Project |
E A |
Mask: %-16N |
CATEGORY |
8 |
String*16 |
Category |
E A |
Mask: %-16N |
DETAILNUM |
9 |
Long |
Detail Number |
E A |
|
EARNINGS |
10 |
String*16 |
Earnings Code |
E A |
|
DESC |
11 |
String*60 |
Description |
E A |
|
TDATE |
12 |
Date |
Transaction Date |
E A |
|
TIMETYPE |
13 |
Integer |
Time Type |
E A |
|
BILLTYPE |
14 |
Integer |
Billing Type |
E A |
List: 3 entries
2 | = | Billable | 3 | = | No Charge | 1 | = | Non-billable |
|
STARTTIME |
15 |
Time |
Start Time |
E A |
|
ENDTIME |
16 |
Time |
End Time |
E A |
|
QUANTITY |
17 |
BCD*10.2 |
Quantity |
E A |
|
ARITEM |
18 |
String*16 |
A/R Item No. |
E A |
Mask: %-16C |
UOM |
19 |
String*10 |
Unit of Measure |
E A |
|
ESTBILLCCY |
20 |
Integer |
Revenue And Cost Currency |
E A |
List: 3 entries
1 | = | Revenue and Costs in Functional Currency | 2 | = | Revenue in Customer Currency | 3 | = | Revenue and Costs in Customer Currency |
|
COSTCCY |
21 |
String*3 |
Cost Currency |
E A |
Mask: %-3N |
BILLCCY |
22 |
String*3 |
Billing Currency |
E A |
Mask: %-3N |
UNITCOST |
23 |
BCD*10.6 |
Unit Cost |
E A |
|
EXTCOSTSR |
24 |
BCD*10.3 |
Extended Cost |
E A |
|
EXTCOSTHM |
25 |
BCD*10.3 |
Extended Cost |
E A |
|
EXTBILLSR |
26 |
BCD*10.3 |
Extended Billing Amount |
E A |
|
EXTBILLHM |
27 |
BCD*10.3 |
Reserved |
E A |
|
LABACCT |
28 |
String*45 |
Labor Account |
E A |
Mask: %-45C |
LABOR |
29 |
Integer |
Labor Type |
E A |
List: 3 entries
1 | = | None | 2 | = | Flat Rate Per Labor Hour/Unit | 3 | = | Percentage of Labor Cost |
|
LABORRATE |
30 |
BCD*10.6 |
Labor Rate |
E A |
|
LABORPER |
31 |
BCD*5.5 |
Labor Percentage |
E A |
|
LABORSR |
32 |
BCD*10.3 |
Transaction Labor Amount |
E A |
|
LABORHM |
33 |
BCD*10.3 |
Transaction Labor Amount |
E A |
|
OHACCT |
34 |
String*45 |
Overhead Account |
E A |
Mask: %-45C |
OVERHD |
35 |
Integer |
Overhead Type |
E A |
List: 3 entries
1 | = | None | 2 | = | Flat Rate Per Unit | 5 | = | Percentage of Cost |
|
OHEADRATE |
36 |
BCD*10.6 |
Overhead Rate |
E A |
|
HEADPER |
37 |
BCD*5.5 |
Overhead Percentage |
E A |
|
OHSR |
38 |
BCD*10.3 |
Transaction Overhead Amount |
E A |
|
OHHM |
39 |
BCD*10.3 |
Transaction Overhead Amount |
E A |
|
BILLRATE |
40 |
BCD*10.6 |
Billing Rate |
E A |
|
TOTCOSTSR |
41 |
BCD*10.3 |
Total Cost |
E A |
|
TOTCOSTHM |
42 |
BCD*10.3 |
Total Cost |
E A |
|
TOTBILLSR |
43 |
BCD*10.3 |
Total Billable Amount |
E A |
|
TOTBILLHM |
44 |
BCD*10.3 |
Total Billable Amount |
E A |
|
PAYRACCT |
45 |
String*45 |
Payroll Account |
E A |
Mask: %-45C |
WIPACCT |
46 |
String*45 |
Work in Progress Account |
E A |
Mask: %-45C |
COMMENTS |
47 |
String*250 |
Comments |
E A |
|
FIXEDBILL |
48 |
Integer |
Bill Amount Based On |
E A |
List: 2 entries
1 | = | Invoice This Amount | 2 | = | Invoice Based on Exchange Rate |
|
RATE |
49 |
BCD*8.7 |
Exchange Rate |
E A |
|
RATETYPE |
50 |
String*2 |
Rate Type |
E A |
Mask: %-2N |
RATEDATE |
51 |
Date |
Rate Date |
E A |
|
RATEOP |
52 |
Integer |
Rate Operator |
E A |
List: 2 entries
|
RATEOVER |
53 |
Boolean |
Rate Override |
E A |
List: 2 entries
|
RATESPREAD |
54 |
BCD*8.7 |
Rate Spread |
E A |
|
TAUTH1 |
55 |
String*12 |
Tax Authority 1 |
E A |
Mask: %-12N |
TAUTH2 |
56 |
String*12 |
Tax Authority 2 |
E A |
Mask: %-12N |
TAUTH3 |
57 |
String*12 |
Tax Authority 3 |
E A |
Mask: %-12N |
TAUTH4 |
58 |
String*12 |
Tax Authority 4 |
E A |
Mask: %-12N |
TAUTH5 |
59 |
String*12 |
Tax Authority 5 |
E A |
Mask: %-12N |
TCLASS1 |
60 |
Integer |
Tax Class 1 |
E A |
|
TCLASS2 |
61 |
Integer |
Tax Class 2 |
E A |
|
TCLASS3 |
62 |
Integer |
Tax Class 3 |
E A |
|
TCLASS4 |
63 |
Integer |
Tax Class 4 |
E A |
|
TCLASS5 |
64 |
Integer |
Tax Class 5 |
E A |
|
TINCLUDED1 |
65 |
Boolean |
Tax Included 1 |
E A |
|
TINCLUDED2 |
66 |
Boolean |
Tax Included 2 |
E A |
|
TINCLUDED3 |
67 |
Boolean |
Tax Included 3 |
E A |
|
TINCLUDED4 |
68 |
Boolean |
Tax Included 4 |
E A |
|
TINCLUDED5 |
69 |
Boolean |
Tax Included 5 |
E A |
|
PROJTYPE |
70 |
Integer |
Project Type |
E A C |
List: 3 entries
1 | = | Time and Materials | 2 | = | Fixed Price | 3 | = | Cost Plus |
|
CONTSTYLE |
71 |
Integer |
Contract Style |
E A C |
List: 2 entries
|
CUSTOMER |
72 |
String*12 |
Customer |
E A C |
Mask: %-12C |
REVREC |
73 |
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 |
74 |
Integer |
Invoice Type |
E A C |
List: 2 entries
|
VALUES |
75 |
Long |
Optional Fields |
E A C |
|
ADJUSTED |
76 |
Integer |
|
E A |
|
GLDDESC |
77 |
String*60 |
G/L Detail Description |
E A |
|
GLDREF |
78 |
String*60 |
G/L Detail Reference |
E A |
|
GLCOMMENT |
79 |
String*250 |
G/L Detail Comment |
E A |
|
RESOURCE |
80 |
String*24 |
Resource |
E A |
|
|