| SEQ |
Long |
Sequence |
|
| LINENO |
Long |
Line Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| DOCNUM |
String*24 |
Document Number |
|
| LINETYPE |
Integer |
Line Type |
List:7 entries
| 1 |
= |
Miscellaneous Cost |
| 2 |
= |
Time |
| 3 |
= |
Expense |
| 4 |
= |
Equipment |
| 5 |
= |
Material Usage |
| 6 |
= |
Material Return |
| 7 |
= |
Charge |
|
| FMTCONTNO |
String*16 |
^1 |
Mask: %-16C |
| CONTRACT |
String*16 |
^1 |
Mask: %-16C |
| PROJECT |
String*16 |
^2 |
Mask: %-16N |
| CATEGORY |
String*16 |
^3 |
Mask: %-16N |
| RESOURCE |
String*24 |
Resource |
Mask: %-16N |
| TYPE |
Integer |
Cost Class |
List:6 entries
| 1 |
= |
Labor |
| 2 |
= |
Material |
| 3 |
= |
Equipment |
| 4 |
= |
Subcontractor |
| 5 |
= |
Overhead |
| 6 |
= |
Miscellaneous |
|
| CHARGECODE |
String*16 |
Charge Code |
Mask: %-16N |
| DESC |
String*60 |
Description |
|
| QUANTITY |
BCD*10.5 |
Quantity |
|
| ARITEM |
String*16 |
A/R Item No. |
Mask: %-16C |
| ARUOM |
String*10 |
A/R Unit of Measure |
Mask: %-10C |
| UNITCOST |
BCD*10.6 |
Unit Cost |
|
| COSTCCY |
String*3 |
Cost Currency |
Mask: %-3N |
| EXTCOSTSR |
BCD*10.3 |
Extended Cost |
|
| EXTCOSTHM |
BCD*10.3 |
Extended Cost (HM) |
|
| OVERHD |
Integer |
Overhead Type |
List:3 entries
| 1 |
= |
None |
| 2 |
= |
Flat Rate Per Unit |
| 5 |
= |
Percentage of Cost |
|
| OHEADRATE |
BCD*10.6 |
Overhead Rate |
|
| HEADPER |
BCD*5.5 |
Overhead Percentage |
|
| OHSR |
BCD*10.3 |
Overhead Amount |
|
| OHHM |
BCD*10.3 |
Overhead Amount (HM) |
|
| LABOR |
Integer |
Labor Type |
|
| LABORRATE |
BCD*10.6 |
Labor Rate |
|
| LABORPER |
BCD*5.5 |
Labor Percentage |
|
| LABORSR |
BCD*10.3 |
Transaction Labor Amount (Source) |
|
| LABORHM |
BCD*10.3 |
Transaction Labor Amount (Functional) |
|
| TOTCOSTSR |
BCD*10.3 |
Total Cost |
|
| TOTCOSTHM |
BCD*10.3 |
Total Cost (HM) |
|
| COMMENTS |
String*250 |
Comments |
|
| TRANACCT |
String*45 |
Cost Account |
Mask: %-45C |
| OHACCT |
String*45 |
Overhead Account |
Mask: %-45C |
| LABORACCT |
String*45 |
Labor Account |
Mask: %-45C |
| WIPACCT |
String*45 |
Work in Progress Account |
Mask: %-45C |
| BILLTYPE |
Integer |
Billing Type |
List:3 entries
| 2 |
= |
Billable |
| 3 |
= |
No Charge |
| 1 |
= |
Non-billable |
|
| BILLRATE |
BCD*10.6 |
Billing Rate |
|
| EXTBILLSR |
BCD*10.3 |
Billing Amount |
|
| EXTBILLHM |
BCD*10.3 |
Billing Amount (HM) |
|
| BILLCCY |
String*3 |
Billing Currency |
Mask: %-3N |
| DETAILNUM |
Long |
Detail Number |
|
| TAUTH1 |
String*12 |
Tax Authority 1 |
Mask: %-12N |
| TAUTH2 |
String*12 |
Tax Authority 2 |
Mask: %-12N |
| TAUTH3 |
String*12 |
Tax Authority 3 |
Mask: %-12N |
| TAUTH4 |
String*12 |
Tax Authority 4 |
Mask: %-12N |
| TAUTH5 |
String*12 |
Tax Authority 5 |
Mask: %-12N |
| TCLASS1 |
Integer |
Tax Class 1 |
|
| TCLASS2 |
Integer |
Tax Class 2 |
|
| TCLASS3 |
Integer |
Tax Class 3 |
|
| TCLASS4 |
Integer |
Tax Class 4 |
|
| TCLASS5 |
Integer |
Tax Class 5 |
|
| TINCLUDED1 |
Boolean |
Tax Included 1 |
|
| TINCLUDED2 |
Boolean |
Tax Included 2 |
|
| TINCLUDED3 |
Boolean |
Tax Included 3 |
|
| TINCLUDED4 |
Boolean |
Tax Included 4 |
|
| TINCLUDED5 |
Boolean |
Tax Included 5 |
|
| CONTSTYLE |
Integer |
Contract Style |
List:2 entries
|
| PROJTYPE |
Integer |
Project Type |
List:3 entries
| 1 |
= |
Time and Materials |
| 2 |
= |
Fixed Price |
| 3 |
= |
Cost Plus |
|
| CUSTOMER |
String*12 |
Customer |
Mask: %-12C |
| REVREC |
Integer |
Revenue Rec. Type |
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 |
Integer |
Inventory Type |
List:2 entries
|
| VALUES |
Long |
Optional Fields |
|
| PAYTYPE |
Integer |
Pay Type |
|
| TRANSDATE |
Date |
Transaction Date |
|
| EXPENSE |
String*16 |
Expense |
|
| EXPTYPE |
Integer |
Expense Type |
|
| LOCATION |
String*6 |
Location |
|
| ICUOM |
String*10 |
I/C Unit of Measure |
Mask: %-10c |
| CONVERSION |
BCD*10.6 |
|
|
| STOCKITEM |
Boolean |
Stock Item |
|
| COSTMETHOD |
Integer |
Cost Method |
|
| UNFMTITEM |
String*24 |
Unformatted Item No. |
|
| GLDDESC |
String*60 |
G/L Detail Description |
|
| GLDREF |
String*60 |
G/L Detail Reference |
|
| GLCOMMENT |
String*250 |
G/L Detail Comment |
|
|