| SEQ |
Long |
Sequence |
|
| LINENUM |
Long |
Line Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| WORKID |
String*30 |
Worksheet Number |
Mask: %-16C |
| CUSTLINE |
Long |
Customer Line Number |
|
| DETAILNUM |
Long |
Detail Line Number |
|
| CUSTOMER |
String*12 |
Customer |
Mask: %-12C |
| NAMECUST |
String*60 |
Customer Name |
|
| TEXTDESC |
String*60 |
Description |
|
| CONTRACT |
String*16 |
^1 |
Mask: %-16C |
| PROJECT |
String*16 |
^2 |
Mask: %-16N |
| CATEGORY |
String*16 |
^3 |
Mask: %-16N |
| RESOURCE |
String*24 |
Resource |
|
| COSTTYPE |
Integer |
Cost Class |
|
| PROJTYPE |
Integer |
Project Type |
List:3 entries
| 1 |
= |
Time and Materials |
| 2 |
= |
Fixed Price |
| 3 |
= |
Cost Plus |
|
| 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 |
|
| TRANSNUM |
Long |
Transaction Number |
|
| BILSTATUS |
Integer |
Status |
List:2 entries
|
| BILLTYPE |
Integer |
Billing Type |
List:3 entries
| 2 |
= |
Billable |
| 3 |
= |
No Charge |
| 1 |
= |
Non-billable |
|
| GLACCT |
String*45 |
G/L Account |
Mask: %-45C |
| ACCTDESC |
String*60 |
Account Description |
|
| QUANTITY |
BCD*10.5 |
Quantity |
|
| UNITPRICE |
BCD*10.6 |
Unit Price |
|
| BILLPER |
BCD*5.5 |
Percentage Complete |
|
| BILAMTSR |
BCD*10.3 |
Extended Amount (Source) |
|
| BILAMTHM |
BCD*10.3 |
Extended Amount (Functional) |
|
| ARITEM |
String*16 |
A/R Item Number |
|
| ARUOM |
String*10 |
A/R Unit of Measure |
|
| COMMENT |
String*250 |
Comment |
|
| STATUS |
Integer |
Status |
List:2 entries
| 1 |
= |
Not Posted |
| 2 |
= |
Posted |
|
| TRANSDATE |
Date |
Transaction Date |
|
| RETPERCENT |
BCD*5.5 |
Retainage Percentage |
|
| RETPERIOD |
Integer |
Retention Period |
|
| FMTCONTNO |
String*16 |
^1 |
Mask: %-16C |
| 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 |
|
| REFERENCE |
String*60 |
Reference |
|
| MODULE |
String*4 |
Module |
|
| INVTYPE |
Integer |
Invoice Type |
List:2 entries
|
| DOCTYPE |
Integer |
Document Type |
List:32 entries
| 0 |
= |
None |
| 1 |
= |
Invoice |
| 2 |
= |
Debit Note |
| 3 |
= |
Credit Note |
| 4 |
= |
Interest |
| 5 |
= |
Prepayment |
| 6 |
= |
Unapplied Cash |
| 7 |
= |
Material Usage |
| 8 |
= |
Material Return |
| 9 |
= |
Equipment Usage |
| 10 |
= |
Timecard |
| 11 |
= |
Charges |
| 12 |
= |
Adjustment |
| 13 |
= |
Retainage Invoice |
| 14 |
= |
Retainage Credit Note |
| 15 |
= |
Retainage Debit Note |
| 16 |
= |
Purchase Order |
| 17 |
= |
P/O Receipt |
| 18 |
= |
P/O Return |
| 19 |
= |
P/O Invoice |
| 20 |
= |
P/O Credit Note |
| 21 |
= |
P/O Debit Note |
| 22 |
= |
Opening Balance |
| 23 |
= |
Manual Check |
| 24 |
= |
Cost |
| 25 |
= |
Check Reversal |
| 26 |
= |
Material Internal Usage |
| 27 |
= |
Order Entry |
| 28 |
= |
O/E Shipment |
| 29 |
= |
O/E Invoice |
| 30 |
= |
O/E Debit Note |
| 31 |
= |
O/E Credit Note |
|
| DOCNUM |
String*24 |
Document Number |
|
| EXTAMTSR |
BCD*10.3 |
Amount Originally on PMTRAN |
|
| BILLAMTC |
BCD*10.3 |
Amount BILLAMTC was updated by |
|
| VALUES |
Long |
Optional Fields |
|
|