# View: Billing Worksheet Detail

RotoID: PM0082
Table: PMBWD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: PMBWD

## Compositions: 3

RotoID | Tables | Title | DLL
--- | --- | --- | ---
PM0081 | PMBWH | Billing Worksheet | PMBWH
PM0083 | PMBWC | Billing Worksheet Customer | PMBWC
PM0544 | PMBWDO | Billing Detail Optional Field | PMBWDO

## Keys: 5

Title | Fields
--- | ---
Worksheet Number | SEQ, LINENUM
Detail Number | WORKID, DETAILNUM
Contract | WORKID, CUSTOMER, CONTRACT, PROJECT, CATEGORY, TRANSNUM
Transaction Date | TRANSDATE
Customer Line/Invoice Type | WORKID, CUSTLINE, INVTYPE

## Fields: 52

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
SEQ | 1 | Long | Sequence | E A K R |
LINENUM | 2 | Long | Line Number | E A K R |
WORKID | 3 | String*30 | Worksheet Number | E A | Mask: %-16C
CUSTLINE | 4 | Long | Customer Line Number | E A |
DETAILNUM | 5 | Long | Detail Line Number | E A |
CUSTOMER | 6 | String*12 | Customer | A | Mask: %-12C
NAMECUST | 7 | String*60 | Customer Name | A |
TEXTDESC | 8 | String*60 | Description | E A |
CONTRACT | 9 | String*16 | Contract | A | Mask: %-16C
PROJECT | 10 | String*16 | Project | A | Mask: %-16N
CATEGORY | 11 | String*16 | Category | A | Mask: %-16N
RESOURCE | 12 | String*24 | Resource | E A |
COSTTYPE | 13 | Integer | Cost Class | E A |
PROJTYPE | 14 | Integer | Project Type | E A | List: 3 entries
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
REVREC | 15 | Integer | Accounting Method | E A | 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 | 16 | Long | Transaction Number | A |
BILSTATUS | 17 | Integer | Status | E A | List: 2 entries
1 | = | Invoice
2 | = | Hold
BILLTYPE | 18 | Integer | Billing Type | A X | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
GLACCT | 19 | String*45 | G/L Account | A | Mask: %-45C
ACCTDESC | 20 | String*60 | Account Description | A |
QUANTITY | 21 | BCD*10.5 | Quantity | A X |
UNITPRICE | 22 | BCD*10.6 | Unit Price | A X |
BILLPER | 23 | BCD*5.5 | Percentage Complete | A X |
BILAMTSR | 24 | BCD*10.3 | Extended Amount (Source) | E A X |
BILAMTHM | 25 | BCD*10.3 | Extended Amount (Functional) | A X |
ARITEM | 26 | String*16 | A/R Item Number | E A |
ARUOM | 27 | String*10 | A/R Unit of Measure | E A |
COMMENT | 28 | String*250 | Comment | E A |
STATUS | 29 | Integer | Status | A | List: 2 entries
1 | = | Not Posted
2 | = | Posted
TRANSDATE | 30 | Date | Transaction Date | E A |
RETPERCENT | 31 | BCD*5.5 | Retainage Percentage | E A |
RETPERIOD | 32 | Integer | Retention Period | E A |
FMTCONTNO | 33 | String*16 | Contract | A | Mask: %-16C
TCLASS1 | 34 | Integer | Tax Class 1 | E A |
TCLASS2 | 35 | Integer | Tax Class 2 | E A |
TCLASS3 | 36 | Integer | Tax Class 3 | E A |
TCLASS4 | 37 | Integer | Tax Class 4 | E A |
TCLASS5 | 38 | Integer | Tax Class 5 | E A |
TINCLUDED1 | 39 | Boolean | Tax Included 1 | E A |
TINCLUDED2 | 40 | Boolean | Tax Included 2 | E A |
TINCLUDED3 | 41 | Boolean | Tax Included 3 | E A |
TINCLUDED4 | 42 | Boolean | Tax Included 4 | E A |
TINCLUDED5 | 43 | Boolean | Tax Included 5 | E A |
REFERENCE | 44 | String*60 | Reference | E A |
MODULE | 45 | String*4 | Module | E A |
INVTYPE | 46 | Integer | Invoice Type | E A | List: 2 entries
1 | = | Item
2 | = | Summary
DOCTYPE | 47 | Integer | Document Type | E A | 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 | 48 | String*24 | Document Number | E A |
EXTAMTSR | 49 | BCD*10.3 | Amount Originally on PMTRAN | E A |
BILLAMTC | 50 | BCD*10.3 | Amount BILLAMTC was updated by | E A |
VALUES | 51 | Long | Optional Fields | E A C |
HASOPT | 1001 | Boolean | Optional Fields | E A C | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.