# Table: Billing Worksheet Detail

Table: PMBWD
View: PM0082
Record length: 880
Flags: A R

## Keys: 4

Title | Flags | Fields
--- | --- | ---
Worksheet Number |  | SEQ, LINENUM
Detail Number |  | WORKID, DETAILNUM
Contract |  | WORKID, CUSTOMER, CONTRACT, PROJECT, CATEGORY, TRANSNUM
| D M | TRANSDATE

## Fields: 55

Field | Type | Title | Presentation
--- | --- | --- | ---
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 | Contract | Mask: %-16C
PROJECT | String*16 | Project | Mask: %-16N
CATEGORY | String*16 | Category | 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
1 | = | Invoice
2 | = | Hold
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 | Contract | 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
1 | = | Item
2 | = | Summary
DOCTYPE | Integer | Document Type | List: 23 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 Balances
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 |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.