| CTUNIQ |
BCD*10.0 |
^1 Uniq |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| ORJSUBCCSR |
BCD*10.3 |
Reserved |
|
| ORJSUBCCHM |
BCD*10.3 |
Orig. Subcontractor Est. Cost |
|
| CURSUBCCSR |
BCD*10.3 |
Reserved |
|
| CURSUBCCHM |
BCD*10.3 |
Cur. Subcontractor Est. Cost |
|
| ACTSUBCCSR |
BCD*10.3 |
Reserved |
|
| ACTSUBCCHM |
BCD*10.3 |
Actual Subcontractor Cost |
|
| RECSUBCCSR |
BCD*10.3 |
Reserved |
|
| RECSUBCCHM |
BCD*10.3 |
Reserved |
|
| ORJSUBCBSR |
BCD*10.3 |
Orig. Subcontract Billing Est. |
|
| ORJSUBCBHM |
BCD*10.3 |
Orig. Subcontract Billing Est. |
|
| CURSUBCBSR |
BCD*10.3 |
Cur. Subcontract Billing Est. |
|
| CURSUBCBHM |
BCD*10.3 |
Cur. Subcontract Billing Est. |
|
| ACTSUBCBSR |
BCD*10.3 |
Actual Subcontract Amt Billed |
|
| ACTSUBCBHM |
BCD*10.3 |
Actual Subcontract Amt Billed |
|
| RECSUBCBSR |
BCD*10.3 |
Reserved |
|
| RECSUBCBHM |
BCD*10.3 |
Reserved |
|
| ORJSUBCQTY |
BCD*10.5 |
Orig. Subcontractor Qty Est. |
|
| CURSUBCQTY |
BCD*10.5 |
Cur. Subcontractor Est. |
|
| ACTSUBCQTY |
BCD*10.5 |
Actual Subcontractor Qty |
|
| ORJOHEXCSR |
BCD*10.3 |
Reserved |
|
| ORJOHEXCHM |
BCD*10.3 |
Orig. Est Overhead Expense Cost |
|
| CUROHEXCSR |
BCD*10.3 |
Reserved |
|
| CUROHEXCHM |
BCD*10.3 |
Cur. Est. Overhead Expense Cost |
|
| ACTOHEXCSR |
BCD*10.3 |
Reserved |
|
| ACTOHEXCHM |
BCD*10.3 |
Actual Overhead Expense Cost |
|
| RECOHEXCSR |
BCD*10.3 |
Reserved |
|
| RECOHEXCHM |
BCD*10.3 |
Reserved |
|
| ORJOHEXBSR |
BCD*10.3 |
Orig. Overhead Billing Est. |
|
| ORJOHEXBHM |
BCD*10.3 |
Orig. Overhead Billing Est. |
|
| CUROHEXBSR |
BCD*10.3 |
Cur. Overhead Billing Est. |
|
| CUROHEXBHM |
BCD*10.3 |
Cur. Overhead Billing Est. |
|
| ACTOHEXBSR |
BCD*10.3 |
Actual Overhead Amount Billed |
|
| ACTOHEXBHM |
BCD*10.3 |
Actual Overhead Billing Est. |
|
| RECOHEXBSR |
BCD*10.3 |
Reserved |
|
| RECOHEXBHM |
BCD*10.3 |
Reserved |
|
| ORJOHEXQTY |
BCD*10.5 |
Orig. Overhead Qty Est. |
|
| CUROHEXQTY |
BCD*10.5 |
Cur. Overhead Est. |
|
| ACTOHEXQTY |
BCD*10.5 |
Actual Overhead Qty |
|
| ORJMISCCSR |
BCD*10.3 |
Reserved |
|
| ORJMISCCHM |
BCD*10.3 |
Orig. Est. Miscellaneous Cost |
|
| CURMISCCSR |
BCD*10.3 |
Reserved |
|
| CURMISCCHM |
BCD*10.3 |
Cur. Est. Miscellaneous Cost |
|
| ACTMISCCSR |
BCD*10.3 |
Reserved |
|
| ACTMISCCHM |
BCD*10.3 |
Actual Miscellaneous Cost |
|
| RECMISCCSR |
BCD*10.3 |
Reserved |
|
| RECMISCCHM |
BCD*10.3 |
Reserved |
|
| ORJMISCBSR |
BCD*10.3 |
Orig. Miscellaneous Billing Est |
|
| ORJMISCBHM |
BCD*10.3 |
Orig. Miscellaneous Billing Est |
|
| CURMISCBSR |
BCD*10.3 |
Cur. Miscellaneous Billing Est. |
|
| CURMISCBHM |
BCD*10.3 |
Cur. Miscellaneous Billing Est. |
|
| ACTMISCBSR |
BCD*10.3 |
Actual Miscellaneous Amt Billed |
|
| ACTMISCBHM |
BCD*10.3 |
Actual Miscellaneous Amt Billed |
|
| RECMISCBSR |
BCD*10.3 |
Reserved |
|
| RECMISCBHM |
BCD*10.3 |
Reserved |
|
| ORJMISCQTY |
BCD*10.5 |
Orig. Miscellaneous Qty Est. |
|
| CURMISCQTY |
BCD*10.5 |
Cur. Miscellaneous Est. |
|
| ACTMISCQTY |
BCD*10.5 |
Actual Miscellaneous Qty |
|
| 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 |
Original Labor Amount Estimate |
|
| ORJLABHM |
BCD*10.3 |
Original Labor Amount Estimate |
|
| CURLABSR |
BCD*10.3 |
Current Labor Amount Estimate |
|
| CURLABHM |
BCD*10.3 |
Current Labor Amount Estimate |
|
| ACTLABSR |
BCD*10.3 |
Actual Labor Amount |
|
| 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 Billed |
|
| ACTCHRGHM |
BCD*10.3 |
Actual Charge Amount Billed |
|
| 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 |
|
| 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 Est. |
|
| 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 |
Reserved |
|
| OEAMOUNTSR |
BCD*10.3 |
Reserved |
|
| OEAMOUNTHM |
BCD*10.3 |
Recognized Loss |
|
| OEQTY |
BCD*10.5 |
Reserved |
|
| PCOMLETERR |
BCD*5.5 |
Recognized % Complete |
|
| FPAMOUNTSR |
BCD*10.3 |
^2 Amount |
|
| FPAMOUNTHM |
BCD*10.3 |
^2 Amount |
|
| LSTBILLPER |
BCD*5.5 |
Last Billings Percent Complete |
|
| BILLAMTSR |
BCD*10.3 |
Amt Bill Fixed Price ^1 |
|
| BILLAMTHM |
BCD*10.3 |
Amt Bill Fixed Price ^1 |
|
| 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 Rev. Recognition 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 |
Last O/E Order Date |
|
| OEINVDATE |
Date |
Last O/E Invoice Date |
|
| FUNCRND |
BCD*10.3 |
Functional Rounding Amount |
|
| NEXTTRAN |
Long |
Next Transaction Number |
|
| OPENPROJ |
Long |
Number of open ^5 |
|
| OPENED |
Boolean |
^1 Has Been Opened |
List: 2 entries
|
| BILLAMT |
BCD*10.3 |
Expected Billings |
|
| PCOMPLETEB |
BCD*5.5 |
Billings Percent Complete |
|
| 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 |
|
| CDATEFROM |
Date |
Current Start Date |
|
| PLCODE |
String*16 |
Reserved |
|
| RRMETHOD |
Integer |
Percentage Complete Method |
List: 3 entries
| 1 | = | Clear Billings and WIP During Revenue Recognition | | 0 | = | Clear Billings and WIP During Project Close | | 2 | = | From Options |
|
| NUMPROJECT |
Long |
Number of Projects |
|
| 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 |
|
| VALUES |
Long |
Optional Fields |
|
| CUSCONTACT |
String*60 |
Contact |
|
| CTACTITTLE |
String*60 |
Position |
|
| CTACPHONE |
String*30 |
Phone |
Mask: (%-3C) %-3C-%-24C |
| OTHERPHONE |
String*30 |
Other Phone |
Mask: (%-3C) %-3C-%-24C |
| CTACFAX |
String*30 |
Fax |
Mask: (%-3C) %-3C-%-24C |
| CTACEMAIL |
String*60 |
E-mail |
|
| USETAXGRP |
Boolean |
Tax Group |
|
| CODETAXGRP |
String*12 |
Tax Group |
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 |
|
| TAUTH1 |
String*12 |
Customer Tax Authority 1 |
|
| TAUTH2 |
String*12 |
Customer Tax Authority 2 |
|
| TAUTH3 |
String*12 |
Customer Tax Authority 3 |
|
| TAUTH4 |
String*12 |
Customer Tax Authority 4 |
|
| TAUTH5 |
String*12 |
Customer Tax Authority 5 |
|
| STRDCOSTHM |
BCD*10.3 |
Stored Cost |
|
| STRDBILLSR |
BCD*10.3 |
Stored Billable Amount |
|
| 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) |
|
| 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 |
|
| MULTICUST |
Integer |
Invoice to Multiple Customers |
|
| CURVAR |
Integer |
Currency different from that on project? |
|
| BONECUST |
Integer |
Allow Multiple Customers |
List: 2 entries
|
| ARACCTSET |
String*6 |
A/R Account Set |
Mask: %-6N |
|