| SEQ |
Long |
Sequence |
|
| LINENO |
Integer |
Line Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| DOCNUM |
String*16 |
Document Number |
Mask: %-16C |
| OPENTYPE |
Integer |
Opening Type |
List:3 entries
| 1 |
= |
Actuals |
| 2 |
= |
Activity |
| 3 |
= |
Stored |
|
| FMTCONTNO |
String*16 |
^1 |
Mask: %-16C |
| CONTRACT |
String*16 |
^1 |
Mask: %-16C |
| PROJECT |
String*16 |
^2 |
Mask: %-16N |
| COSTREV |
Integer |
Actual Type |
List:2 entries
|
| CATEGORY |
String*16 |
^3 |
Mask: %-16N |
| RESOURCE |
String*24 |
Resource |
Mask: %-24C |
| COSTTYPE |
Integer |
Cost Type |
List:7 entries
| 0 |
= |
None |
| 1 |
= |
Labor |
| 2 |
= |
Material |
| 3 |
= |
Equipment |
| 4 |
= |
Subcontractor |
| 5 |
= |
Overhead |
| 6 |
= |
Miscellaneous |
|
| DETAILNUM |
Long |
Detail Number |
|
| COMMENTS |
String*250 |
Comments |
|
| CUSTOMER |
String*12 |
Customer |
Mask: %-12C |
| BILLCCY |
String*3 |
Customer Currency |
Mask: %-3N |
| RATETYPE |
String*2 |
Rate Type |
Mask: %-2N |
| RATEOP |
Integer |
Rate Operation |
List:2 entries
|
| RATEDATE |
Date |
Rate Date |
|
| RATE |
BCD*8.7 |
Rate |
|
| RATESPREAD |
BCD*8.7 |
Rate Spread |
|
| OQTY |
BCD*10.5 |
Original Quantity |
|
| AQTY |
BCD*10.5 |
Actual Quantity |
|
| OARITEM |
String*16 |
Original A/R Item Number |
Mask: %-16C |
| OARUOM |
String*10 |
Original A/R Unit of Measure |
Mask: %-10C |
| OUNITCOST |
BCD*10.6 |
Original Unit Cost |
|
| OEXTCOSTSR |
BCD*10.3 |
Original Extended Cost |
|
| OEXTCOSTHM |
BCD*10.3 |
Original Extended Cost |
|
| AEXTCOSTSR |
BCD*10.3 |
Actual Extended Cost |
|
| AEXTCOSTHM |
BCD*10.3 |
Actual Extended Cost |
|
| OOHTYPE |
Integer |
Overhead Type |
List:4 entries
| 0 |
= |
Unknown |
| 1 |
= |
None |
| 2 |
= |
Flat Rate Per Unit |
| 5 |
= |
Percentage of Cost |
|
| OOHRATE |
BCD*10.6 |
Overhead Rate |
|
| OOHPER |
BCD*5.5 |
Overhead Percentage |
|
| OOHSR |
BCD*10.3 |
Original Overhead Estimate |
|
| OOHHM |
BCD*10.3 |
Original Overhead Estimate |
|
| AOHSR |
BCD*10.3 |
Actual Overhead |
|
| AOHHM |
BCD*10.3 |
Actual Overhead |
|
| OLABORTYPE |
Integer |
Labor Type |
List:4 entries
| 0 |
= |
Unknown |
| 1 |
= |
None |
| 2 |
= |
Flat Rate Per Labor Hour/Unit |
| 3 |
= |
Percentage of Labor Cost |
|
| OLABORRATE |
BCD*10.6 |
Labor Rate |
|
| OLABORPER |
BCD*5.5 |
Labor Percentage |
|
| OLABORSR |
BCD*10.3 |
Original Labor Amount Estimate |
|
| OLABORHM |
BCD*10.3 |
Original Labor Amount Estimate |
|
| ALABORSR |
BCD*10.3 |
Actual Labor Amount |
|
| ALABORHM |
BCD*10.3 |
Actual Labor Amount |
|
| OTOTCOSTSR |
BCD*10.3 |
Original Total Cost |
|
| OTOTCOSTHM |
BCD*10.3 |
Original Total Cost |
|
| ATOTCOSTSR |
BCD*10.3 |
Actual Total Cost |
|
| ATOTCOSTHM |
BCD*10.3 |
Actual Total Cost |
|
| OBILLTYPE |
Integer |
Billing Type |
List:4 entries
| 0 |
= |
Unknown |
| 2 |
= |
Billable |
| 3 |
= |
No Charge |
| 1 |
= |
Non-billable |
|
| OBILLRATE |
BCD*10.6 |
Original Billing Rate |
|
| OBILLSR |
BCD*10.3 |
Original Total Revenue |
|
| OBILLHM |
BCD*10.3 |
Original Total Revenue |
|
| ABILLSR |
BCD*10.3 |
Actual Total Revenue |
|
| ABILLHM |
BCD*10.3 |
Actual Total Revenue |
|
| RBILLSR |
BCD*10.3 |
Remaining to be Billed |
|
| OPROFITSR |
BCD*10.3 |
Original Profit |
|
| OPROFITHM |
BCD*10.3 |
Original Profit |
|
| APROFITSR |
BCD*10.3 |
Actual Profit |
|
| APROFITHM |
BCD*10.3 |
Actual Profit |
|
| TARRECTSSR |
BCD*10.3 |
Total A/R Customer Receipts |
|
| ARRECDATE |
Date |
Last A/R Receipt Posting Date |
|
| TAPPAYMTS |
BCD*10.3 |
Total A/P Vendor Payments |
|
| APPAYDATE |
Date |
Last A/P Payment Posting Date |
|
| COSTDATE |
Date |
Last Cost Posting Date |
|
| BILLDATE |
Date |
Last Billings Posting Date |
|
| REVRECDATE |
Date |
Last Rev. Recognition Posting Date |
|
| REVESTDATE |
Date |
Last Revised Posting Date |
|
| LSTBILLPER |
BCD*5.5 |
Last Billings Percent Complete |
|
| PODATE |
Date |
Last Purchase Order Date |
|
| PORECDATE |
Date |
Last P/O Receipt Date |
|
| PORETDATE |
Date |
Last P/O Return Date |
|
| PLSTPDATCP |
Date |
Last Canadian Payroll Posting Date |
|
| PLSTPDATUP |
Date |
Last US Payroll Posting Date |
|
| CONTSTYLE |
Integer |
^2 Style |
List:3 entries
| 0 |
= |
Unknown |
| 1 |
= |
Standard |
| 2 |
= |
Basic |
|
| PROJTYPE |
Integer |
^2 Type |
List:4 entries
| 0 |
= |
Unknown |
| 1 |
= |
Time and Materials |
| 2 |
= |
Fixed Price |
| 3 |
= |
Cost Plus |
|
| REVREC |
Integer |
Accounting Method |
List:8 entries
| 0 |
= |
Unknown |
| 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:3 entries
| 0 |
= |
Unknown |
| 1 |
= |
Item |
| 2 |
= |
Summary |
|
| REVERSED |
Integer |
Reversed |
|
| STRDQTY |
BCD*10.5 |
Stored Quantity |
|
| STRDCOSTHM |
BCD*10.3 |
Stored Cost |
|
| STRDBILLSR |
BCD*10.3 |
Stored Billable Amount |
|
| PRECOLEDSR |
BCD*10.3 |
Previous Completed Work |
|
| STRDOHHM |
BCD*10.3 |
Overhead Amount |
|
| STRDTCSTHM |
BCD*10.3 |
Total Stored Cost |
|
| COHTYPE |
Integer |
Overhead Type |
|
| COHRATE |
BCD*10.6 |
Overhead Rate |
|
| COHPER |
BCD*5.5 |
Overhead Percentage |
|
| USEAIA |
Integer |
Use AIA Report |
|
| PREAIAPAY |
BCD*10.3 |
Previous Certificates for Payment |
|
| TRANSDATE |
Date |
Transaction Date |
|
| FISCALYEAR |
String*4 |
Fiscal Year |
|
| FISCALPER |
Integer |
Fiscal Period |
|
| PRESTORED |
BCD*10.3 |
G703 Column F from Last AIA Report |
|
| PRERETAIN |
BCD*10.3 |
G703 Column I from Last AIA Report |
|
| OESHPDATE |
Date |
Last O/E Shipment Date |
|
| OEINVDATE |
Date |
Last O/E Invoice Date |
|
|