Table: Billing Worksheet Detail

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

Keys: 5

Title  Flags  Fields

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

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

This page was generated on 2009-Nov-19

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