| CTUNIQ |
BCD*10.0 |
Contract Uniq |
|
| PLINENUM |
Long |
Line Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| ORJOHEADSR |
BCD*10.3 |
Reserved |
|
| ORJOHEADHM |
BCD*10.3 |
Original Overhead Estimate |
|
| CUROHEADSR |
BCD*10.3 |
Reserved |
|
| CUROHEADHM |
BCD*10.3 |
Current Overhead Estimate |
|
| ACTOHEADSR |
BCD*10.3 |
Reserved |
|
| ACTOHEADHM |
BCD*10.3 |
Actual Overhead |
|
| ORJLABSR |
BCD*10.3 |
Reserved |
|
| ORJLABHM |
BCD*10.3 |
Original Labor Amount Estimate |
|
| CURLABSR |
BCD*10.3 |
Reserved |
|
| CURLABHM |
BCD*10.3 |
Current Labor Amount Estimate |
|
| ACTLABSR |
BCD*10.3 |
Reserved |
|
| ACTLABHM |
BCD*10.3 |
Actual Labor Amount |
|
| ORJCHRGSR |
BCD*10.3 |
Reserved |
|
| ORJCHRGHM |
BCD*10.3 |
Reserved |
|
| CURCHRGSR |
BCD*10.3 |
Reserved |
|
| CURCHRGHM |
BCD*10.3 |
Reserved |
|
| ACTCHRGSR |
BCD*10.3 |
Actual Charge Amount |
|
| ACTCHRGHM |
BCD*10.3 |
Actual Charge Amount |
|
| ACTCHRGDSR |
BCD*10.3 |
Act Chrg Amt Billed & Deferred |
|
| ACTCHRGDHM |
BCD*10.3 |
Act Chrg Amt Billed & Deferred |
|
| RECCHRGSR |
BCD*10.3 |
Reserved |
|
| RECCHRGHM |
BCD*10.3 |
Reserved |
|
| ACTSTKRESR |
BCD*10.3 |
Reserved |
|
| ACTSTKREHM |
BCD*10.3 |
Act Cost Stock Ret to Inventory |
|
| ACTSTKRQTY |
BCD*10.5 |
Act Qty Stock Ret to Inventory |
|
| TARRECTSSR |
BCD*10.3 |
Total A/R Customer Receipts |
|
| TARRECTSHM |
BCD*10.3 |
Total A/R Customer Receipts |
|
| TAPPAYMTS |
BCD*10.3 |
Total A/P Vendor Payments |
|
| TORJCOSTSR |
BCD*10.3 |
Reserved |
|
| TORJCOSTHM |
BCD*10.3 |
Total Orig. Cost Est. |
|
| TCURCOSTSR |
BCD*10.3 |
Reserved |
|
| TCURCOSTHM |
BCD*10.3 |
Total Cur. Cost Est. |
|
| TACTCOSTSR |
BCD*10.3 |
Reserved |
|
| TACTCOSTHM |
BCD*10.3 |
Total Actual Cost |
|
| TRECCOSTSR |
BCD*10.3 |
Reserved |
|
| TRECCOSTHM |
BCD*10.3 |
Total Cost Recognized |
|
| PERTCOST |
BCD*5.5 |
Percent Total Cost |
|
| PERTREV |
BCD*5.5 |
Percent Total Revenue |
|
| TORJREVSR |
BCD*10.3 |
Total Orig. Revenue Est. |
|
| TORJREVHM |
BCD*10.3 |
Total Orig. Revenue Est. |
|
| TCURREVSR |
BCD*10.3 |
Total Cur. Revenue Est. |
|
| TCURREVHM |
BCD*10.3 |
Total Cur. Revenue Est. |
|
| TACTREVSR |
BCD*10.3 |
Total Actual Revenue |
|
| TACTREVHM |
BCD*10.3 |
Total Actual Revenue |
|
| TRECREVSR |
BCD*10.3 |
Total Revenue Recognized |
|
| TRECREVHM |
BCD*10.3 |
Total Revenue Recognized |
|
| RETARAMTSR |
BCD*10.3 |
Retainage Receivable |
|
| RETARAMTHM |
BCD*10.3 |
Retainage Receivable |
|
| RETARRECSR |
BCD*10.3 |
Retainage Amount Received in A/R |
|
| RETARRECHM |
BCD*10.3 |
Retainage Amount Received in A/R |
|
| RETAPAMT |
BCD*10.3 |
Retainage Payable |
|
| RETAPPAID |
BCD*10.3 |
Retainage Amount Paid in A/P |
|
| POAMOUNTSR |
BCD*10.3 |
Reserved |
|
| POAMOUNTHM |
BCD*10.3 |
Reserved |
|
| POQTY |
BCD*10.5 |
Committed P/O Quantity |
|
| OEAMOUNTSR |
BCD*10.3 |
Reserved |
|
| OEAMOUNTHM |
BCD*10.3 |
Recognized Loss |
|
| OEQTY |
BCD*10.5 |
Reserved |
|
| PCOMPLETEB |
BCD*5.5 |
Billings Percent Complete |
|
| PCOMPLETER |
BCD*5.5 |
RR Percent Complete |
|
| FPAMOUNTSR |
BCD*10.3 |
Fixed Price Amount |
|
| FPAMOUNTHM |
BCD*10.3 |
Fixed Price Amount |
|
| LSTBILLPER |
BCD*5.5 |
Last Billings Percent Complete |
|
| BILLAMTRSR |
BCD*10.3 |
Recognized Amount to Bill |
|
| BILLAMTRHM |
BCD*10.3 |
Recognized Amount to Bill |
|
| COSTDATE |
Date |
Last Cost Posting Date |
|
| BILLDATE |
Date |
Last Billings Posting Date |
|
| OHDATE |
Date |
Last Overhead Posting Date |
|
| CHARGEDATE |
Date |
Last Charge Posting Date |
|
| REVRECDATE |
Date |
Last Revenue Rec Posting Date |
|
| ARRECDATE |
Date |
Last A/R Receipt Posting Date |
|
| APPAYDATE |
Date |
Last A/P Payment Posting Date |
|
| TIMEDATE |
Date |
Last Timecard Posting Date |
|
| STKTRDATE |
Date |
Last Material Usage Posting Date |
|
| STKRETDATE |
Date |
Last Material Return Posting Date |
|
| EQUIPDATE |
Date |
Last Equipment Posting Date |
|
| PODATE |
Date |
Last Purchase Order Date |
|
| PORECDATE |
Date |
Last P/O Receipt Date |
|
| PORETDATE |
Date |
Last P/O Return Date |
|
| OEORDDATE |
Date |
Reserved |
|
| OEINVDATE |
Date |
Last O/E Invoice Date |
|
| PTAXTOTAL |
BCD*10.3 |
Project tax total |
|
| 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 |
|
| TAXBASES1 |
BCD*10.3 |
Tax Base 1 |
|
| TAXBASES2 |
BCD*10.3 |
Tax Base 2 |
|
| TAXBASES3 |
BCD*10.3 |
Tax Base 3 |
|
| TAXBASES4 |
BCD*10.3 |
Tax Base 4 |
|
| TAXBASES5 |
BCD*10.3 |
Tax Base 5 |
|
| TAXBASEH1 |
BCD*10.3 |
Tax Base 1 |
|
| TAXBASEH2 |
BCD*10.3 |
Tax Base 2 |
|
| TAXBASEH3 |
BCD*10.3 |
Tax Base 3 |
|
| TAXBASEH4 |
BCD*10.3 |
Tax Base 4 |
|
| TAXBASEH5 |
BCD*10.3 |
Tax Base 5 |
|
| TAXAMTS1 |
BCD*10.3 |
Tax Amount 1 |
|
| TAXAMTS2 |
BCD*10.3 |
Tax Amount 2 |
|
| TAXAMTS3 |
BCD*10.3 |
Tax Amount 3 |
|
| TAXAMTS4 |
BCD*10.3 |
Tax Amount 4 |
|
| TAXAMTS5 |
BCD*10.3 |
Tax Amount 5 |
|
| TAXAMTH1 |
BCD*10.3 |
Tax Amount 1 |
|
| TAXAMTH2 |
BCD*10.3 |
Tax Amount 2 |
|
| TAXAMTH3 |
BCD*10.3 |
Tax Amount 3 |
|
| TAXAMTH4 |
BCD*10.3 |
Tax Amount 4 |
|
| TAXAMTH5 |
BCD*10.3 |
Tax Amount 5 |
|
| ONBW |
Boolean |
On Billing Worksheet |
|
| OPENED |
Boolean |
Project Has Been Opened |
List: 2 entries
|
| BILLAMT |
BCD*10.3 |
Expected Billings |
|
| ORATEOP |
Integer |
Rate Operator |
List: 2 entries
|
| LSTRRPER |
BCD*5.5 |
Last Rev. Recognition Percentage |
|
| PRFTLOSSSR |
BCD*10.3 |
Recognized Profit / Loss |
|
| PRFTLOSSHM |
BCD*10.3 |
Recognized Profit / Loss |
|
| REVESTDATE |
Date |
Last Revised Posting Date |
|
| ONRW |
Boolean |
On RR Worksheet |
|
| OLABEMHM |
BCD*10.3 |
Original Employee Labor |
|
| CLABEMHM |
BCD*10.3 |
Current Employee Labor |
|
| ALABEMHM |
BCD*10.3 |
Actual Employee Labor |
|
| OOHEMHM |
BCD*10.3 |
Original Employee Overhead |
|
| COHEMHM |
BCD*10.3 |
Current Employee Overhead |
|
| AOHEMHM |
BCD*10.3 |
Actual Employee Overhead |
|
| OOHEQHM |
BCD*10.3 |
Original Equipment Overhead |
|
| COHEQHM |
BCD*10.3 |
Current Equipment Overhead |
|
| AOHEQHM |
BCD*10.3 |
Actual Equipment Overhead |
|
| OOHSUHM |
BCD*10.3 |
Original Subcontractor Overhead |
|
| COHSUHM |
BCD*10.3 |
Current Subcontractor Overhead |
|
| AOHSUHM |
BCD*10.3 |
Actual Subcontractor Overhead |
|
| OOHOHHM |
BCD*10.3 |
Original Overhead Overhead |
|
| COHOHHM |
BCD*10.3 |
Current Overhead Overhead |
|
| AOHOHHM |
BCD*10.3 |
Actual Overhead Overhead |
|
| OOHMIHM |
BCD*10.3 |
Original Miscellaneous Overhead |
|
| COHMIHM |
BCD*10.3 |
Current Miscellaneous Overhead |
|
| AOHMIHM |
BCD*10.3 |
Actual Miscellaneous Overhead |
|
| OOHMAHM |
BCD*10.3 |
Original Material Overhead |
|
| COHMAHM |
BCD*10.3 |
Current Material Overhead |
|
| AOHMAHM |
BCD*10.3 |
Actual Material Overhead |
|
| CDATEFROM |
Date |
Current Start Date |
|
| PROJSTYLE |
Integer |
Project Style |
List: 2 entries
|
| APTAXEXPHM |
BCD*10.3 |
Reserved |
|
| APTAXRECHM |
BCD*10.3 |
Reserved |
|
| APTAXEXCHM |
BCD*10.3 |
Reserved |
|
| APDISCHM |
BCD*10.3 |
Reserved |
|
| APINTHM |
BCD*10.3 |
Reserved |
|
| ARTAXHM |
BCD*10.3 |
Reserved |
|
| ARTAXSR |
BCD*10.3 |
Reserved |
|
| ARDISCHM |
BCD*10.3 |
Reserved |
|
| ARDISCSR |
BCD*10.3 |
Reserved |
|
| ARINTHM |
BCD*10.3 |
Reserved |
|
| ARINTSR |
BCD*10.3 |
Reserved |
|
| ARWRITEHM |
BCD*10.3 |
Reserved |
|
| ARWRITESR |
BCD*10.3 |
Reserved |
|
| PLCODE |
String*16 |
Reserved |
|
| BILLAMTC |
BCD*10.3 |
Current Billings (AR and on BW) |
|
| POCOSTHM |
BCD*10.3 |
Committed P/O Cost |
|
| POOHHM |
BCD*10.3 |
Committed P/O Overhead |
|
| POLABORHM |
BCD*10.3 |
Committed P/O Labor |
|
| POTCOSTHM |
BCD*10.3 |
Committed P/O Total Cost |
|
| POEMQTY |
BCD*10.5 |
P/O Employee Quantity |
|
| POEMOHHM |
BCD*10.3 |
P/O Employee Overhead |
|
| POEMLABHM |
BCD*10.3 |
P/O Employee Labor |
|
| POEMTCOSTH |
BCD*10.3 |
P/O Employee Total Cost |
|
| POEQQTY |
BCD*10.5 |
P/O Equipment Quantity |
|
| POEQOHHM |
BCD*10.3 |
P/O Equipment Overhead |
|
| POEQTCOSTH |
BCD*10.3 |
P/O Equipment Total Cost |
|
| POSUQTY |
BCD*10.5 |
P/O Subcontractor Quantity |
|
| POSUOHHM |
BCD*10.3 |
P/O Subcontractor Overhead |
|
| POSUTCOSTH |
BCD*10.3 |
P/O Subcontractor Total Cost |
|
| POOHQTY |
BCD*10.5 |
P/O Overhead Quantity |
|
| POOHOHHM |
BCD*10.3 |
P/O Overhead Overhead |
|
| POOHTCOSTH |
BCD*10.3 |
P/O Overhead Total Cost |
|
| POMIQTY |
BCD*10.5 |
P/O Miscellaneous Quantity |
|
| POMIOHHM |
BCD*10.3 |
P/O Miscellaneous Overhead |
|
| POMITCOSTH |
BCD*10.3 |
P/O Miscellaneous Total Cost |
|
| POMAQTY |
BCD*10.5 |
P/O Material Quantity |
|
| POMAOHHM |
BCD*10.3 |
P/O Material Overhead |
|
| POMATCOSTH |
BCD*10.3 |
P/O Material Total Cost |
|
| VALUES |
Long |
Optional Fields |
|
| CLEARED |
Integer |
Transactions have been cleared |
List: 2 entries
|
| CODETAXGRP |
String*12 |
Tax Group |
Mask: %-12N |
| CTCLASS1 |
Integer |
Customer Tax Class 1 |
|
| CTCLASS2 |
Integer |
Customer Tax Class 2 |
|
| CTCLASS3 |
Integer |
Customer Tax Class 3 |
|
| CTCLASS4 |
Integer |
Customer Tax Class 4 |
|
| CTCLASS5 |
Integer |
Customer Tax Class 5 |
|
| CTAUTH1 |
String*12 |
Customer Tax Authority 1 |
|
| CTAUTH2 |
String*12 |
Customer Tax Authority 2 |
|
| CTAUTH3 |
String*12 |
Customer Tax Authority 3 |
|
| CTAUTH4 |
String*12 |
Customer Tax Authority 4 |
|
| CTAUTH5 |
String*12 |
Customer Tax Authority 5 |
|
| LUPDATE |
Date |
Last US Payroll Posting Date |
|
| LCPDATE |
Date |
Last Canadian Payroll Posting Date |
|
| STRDCOSTHM |
BCD*10.3 |
Stored Cost |
|
| STRDBILLSR |
BCD*10.3 |
Stored Billable Amount |
|
| PRECOLEDSR |
BCD*10.3 |
Previous D + E |
|
| STRDOHHM |
BCD*10.3 |
Overhead Amount |
|
| STRDTCSTHM |
BCD*10.3 |
Total Stored Cost |
|
| TXEXPCOMHM |
BCD*10.3 |
Tax (exp) Committed (func) |
|
| TXALLCOMHM |
BCD*10.3 |
Tax (all) Committed (func) |
|
| STRDQTY |
BCD*10.5 |
Stored Quantity |
|
| PREAIAPAY |
BCD*10.3 |
Previous Certificates for Payment |
|
| PRESTORED |
BCD*10.3 |
G703 Column F from Last AIA Report |
|
| PRERETAIN |
BCD*10.3 |
G703 Column I from Last AIA Report |
|
| IDACCTSET |
String*6 |
Account Set |
Mask: %-6N |
| CUSTCCY |
String*3 |
Customer Currency |
|
| CUSCONTACT |
String*60 |
Contact |
|
| CTACTITTLE |
String*60 |
Position |
|
| CTACPHONE |
String*30 |
Phone |
Mask: %-30c |
| OTHERPHONE |
String*30 |
Other Phone |
Mask: %-30c |
| CTACFAX |
String*30 |
Fax |
Mask: %-30c |
| CTACEMAIL |
String*60 |
E-mail |
|
| MULTICUST |
Integer |
Invoice to Multiple Customers |
List: 2 entries
|
| BILLED |
Integer |
Has this Project been billed? |
|
| OESHPDATE |
Date |
Last O/E Shipment Date |
|
| PRICEOPT |
Integer |
Default Billing Rate |
List: 3 entries
| 1 | = | Billing Rate | | 2 | = | Use Customer Price List | | 3 | = | Use Specified Price List |
|
| PRICELIST |
String*6 |
Price List |
Mask: %-6N |
| OEMCHGOPT |
Integer |
O/E Miscellaneous Charges |
List: 2 entries
| 0 | = | Default Cost from Contract | | 1 | = | Default Cost from Misc. Charges |
|
| ARACCTSET |
String*6 |
A/R Account Set |
Mask: %-6N |
|