View: Charges Audit Detail

RotoID: PM0057
Table: PMCHGDA
Protocol: Flat
DLL:PMCHGDA

Keys: 3

Title Fields
Sequence/Line Number POSTSEQNO, LINENO
Sequence/Detail Number POSTSEQNO, DETAILNUM
Charge Seq/Post Seq/Detail Numbe SEQ, POSTSEQNO, DETAILNUM

Fields: 49

Field Index Type Title Attributes Presentation
POSTSEQNO 1 Long Posting Sequence E A K R 
LINENO 2 Long Line Number E A K R 
SEQ 3 Long Sequence E A 
CHRGNO 4 String*16 Charge Number E A  Mask: %-16C
FMTCONTNO 5 String*16 ^1 E A 
CONTRACT 6 String*16 ^1 E A  Mask: %-16C
PROJECT 7 String*16 ^2 E A  Mask: %-16N
CATEGORY 8 String*16 ^3 E A  Mask: %-16N
RESOURCE 9 String*24 Resource E A 
CHARGECODE 10 String*16 Charge Code E A  Mask: %-16N
DESC 11 String*60 Description E A 
TYPE 12 Integer Cost Class E A  List:6 entries
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
QUANTITY 13 BCD*10.5 Quantity E A 
ARITEM 14 String*16 A/R Item No. E A  Mask: %-16C
UOM 15 String*10 Unit of Measure E A 
COMMENTS 16 String*250 Comments E A 
BILLTYPE 17 Integer Billing Type E A  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
BILLRATE 18 BCD*10.6 Billing Rate E A 
EXTBILLSR 19 BCD*10.3 Extended Billing Amount E A 
EXTBILLHM 20 BCD*10.3 Reserved E A 
BILLCCY 21 String*3 Billing Currency E A  Mask: %-3N
DETAILNUM 22 Long Detail Number E A 
TAUTH1 23 String*12 Tax Authority 1 E A  Mask: %-12N
TAUTH2 24 String*12 Tax Authority 2 E A  Mask: %-12N
TAUTH3 25 String*12 Tax Authority 3 E A  Mask: %-12N
TAUTH4 26 String*12 Tax Authority 4 E A  Mask: %-12N
TAUTH5 27 String*12 Tax Authority 5 E A  Mask: %-12N
TCLASS1 28 Integer Tax Class 1 E A 
TCLASS2 29 Integer Tax Class 2 E A 
TCLASS3 30 Integer Tax Class 3 E A 
TCLASS4 31 Integer Tax Class 4 E A 
TCLASS5 32 Integer Tax Class 5 E A 
TINCLUDED1 33 Boolean Tax Included 1 E A 
TINCLUDED2 34 Boolean Tax Included 2 E A 
TINCLUDED3 35 Boolean Tax Included 3 E A 
TINCLUDED4 36 Boolean Tax Included 4 E A 
TINCLUDED5 37 Boolean Tax Included 5 E A 
PROJTYPE 38 Integer ^2 Type E A C  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
CONTSTYLE 39 Integer ^1 Style E A C  List:2 entries
1 = Standard
2 = Basic
CUSTOMER 40 String*12 Customer E A C  Mask: %-12C
REVREC 41 Integer Accounting Method E A C  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
INVTYPE 42 Integer Invoice Type E A C  List:2 entries
1 = Item
2 = Summary
VALUES 43 Long Optional Fields E A C 
UNITCOST 44 BCD*10.6 E A 
COSTCCY 45 String*3 E A 
EXTCOSTHM 46 BCD*10.3 E A 
TOTCOSTHM 55 BCD*10.3 E A 
TRANACCT 58 String*45 E A 
WIPACCT 59 String*45 E A 

This page was generated on 2023-Aug-31

© 2023 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).