| SEQ |
Long |
Sequence |
|
| LINENO |
Long |
Line Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| MALLOCNO |
String*16 |
Material Allocation Number |
Mask: %-16C |
| 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 |
Item Number |
Mask: %-24C |
| DESC |
String*60 |
Description |
|
| LOCATION |
String*6 |
Location |
Mask: %-6N |
| COSTMETHOD |
Integer |
Cost Method |
|
| STOCKITEM |
Boolean |
Stock Item |
|
| UOM |
String*10 |
UOM |
|
| UNFMTITEM |
String*24 |
Unformatted Item Number |
|
| DETAILNUM |
Long |
Detail Number |
|
| QUANTITY |
BCD*10.5 |
Allocated Quantity |
|
| UNITCOST |
BCD*10.6 |
Unit Cost |
|
| BILLRATE |
BCD*10.6 |
Billing Rate |
|
| BILLTYPE |
Integer |
Billing Type |
List:3 entries
| 2 |
= |
Billable |
| 3 |
= |
No Charge |
| 1 |
= |
Non-billable |
|
| EXTBILLSR |
BCD*10.3 |
Extended Billing Amount |
|
| EXTBILLHR |
BCD*10.3 |
Billing Amount (Func) |
|
| BILLCCY |
String*3 |
Billing Currency |
|
| COSTCCY |
String*3 |
Cost Currency |
|
| APERCENT |
BCD*5.5 |
Percentage Allocated |
|
| EXTCOSTSR |
BCD*10.3 |
Extended Cost |
|
| EXTCOSTHM |
BCD*10.3 |
Extended Allocated Cost |
|
| TOTCOSTSR |
BCD*10.3 |
Total Cost(Source) |
|
| TOTCOSTHM |
BCD*10.3 |
Total Cost(Func.) |
|
| OVERHD |
Integer |
Reserved |
|
| OHEADRATE |
BCD*10.6 |
Reserved |
|
| HEADPER |
BCD*5.5 |
Reserved |
|
| OHSR |
BCD*10.3 |
Stored Overhead |
|
| OHHM |
BCD*10.3 |
Overhead Allocated |
|
| COMMENTS |
String*250 |
Comments |
|
| CONTSTYLE |
Integer |
Style |
|
| PROJTYPE |
Integer |
Project Type |
List:3 entries
| 1 |
= |
Time and Materials |
| 2 |
= |
Fixed Price |
| 3 |
= |
Cost Plus |
|
| CUSTOMER |
String*12 |
Customer |
|
| REVREC |
Integer |
Accounting Method |
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 |
Invoice Type |
List:2 entries
|
| VALUES |
Long |
Optional Fields |
|
| STRDQTY |
BCD*10.5 |
Stored Quantity |
|
| STRDCOSTHM |
BCD*10.3 |
Extended Stored Cost |
|
| TRANSDATE |
Date |
Transaction Date |
|
| FISCALYEAR |
String*4 |
Fiscal Year |
|
| FISCALPER |
Integer |
Fiscal Period |
|
| CONVERSION |
BCD*10.6 |
Conversion |
|
| STRDUOM |
String*10 |
UOM |
|
| STRDCONVER |
BCD*10.6 |
Stored Conversion Factor |
|
|