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 ^1 A  Mask: %-16C
PROJECT 10 String*16 ^2 A  Mask: %-16N
CATEGORY 11 String*16 ^3 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 ^1 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 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).