| 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
|
| 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 |
|
|