| 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 |
Contract |
Mask: %-16C |
| CONTRACT |
String*16 |
Contract |
Mask: %-16C |
| PROJECT |
String*16 |
Project |
Mask: %-16N |
| COSTREV |
Integer |
Actual Type |
List: 2 entries
|
| CATEGORY |
String*16 |
Category |
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 |
Project Style |
List: 3 entries
| 0 | = | Unknown | | 1 | = | Standard | | 2 | = | Basic |
|
| PROJTYPE |
Integer |
Project 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
|
| 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 |
|
|