View: Charges Detail

RotoID: PM0055
Table: PMCHRGD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMCHRGD

Compositions: 2

RotoID Tables Title DLL
PM0054 PMCHRGH Charges PMCHRGH
PM0523 PMCHGDO Charges Detail Optional Field PMCHGDO

Keys: 3

Title Fields
Sequence/Line Number SEQ, LINENO
Charge Number/Line Number CHRGNO, LINENO
Sequence/Detail Number SEQ, DETAILNUM

Fields: 59

Field Index Type Title Attributes Presentation
SEQ 1 Long Sequence E A K R 
LINENO 2 Long Line Number E A K R 
CHRGNO 3 String*16 Charge Number A C  Mask: %-16C
FMTCONTNO 4 String*16 ^1 E A X  Mask: %-16C
CONTRACT 5 String*16 Unformatted ^1 E A X  Mask: %-16C
PROJECT 6 String*16 ^2 E A X  Mask: %-16N
CATEGORY 7 String*16 ^3 E A X  Mask: %-16N
RESOURCE 8 String*24 Resource E A X  Mask: %-24C
CHARGECODE 9 String*16 Charge Code E A X  Mask: %-16N
DESC 10 String*60 Description E A X 
TYPE 11 Integer Cost Class A  List:6 entries
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
QUANTITY 12 BCD*10.5 Quantity A X 
ARITEM 13 String*16 A/R Item No. A X  Mask: %-16C
UOM 14 String*10 Unit of Measure A X  Mask: %-10C
COMMENTS 15 String*250 Comments A X 
BILLTYPE 16 Integer Billing Type A X  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
BILLRATE 17 BCD*10.6 Billing Amount A X 
EXTBILLSR 18 BCD*10.3 Extended Billing Amount A X 
EXTBILLHM 19 BCD*10.3 Reserved A 
BILLCCY 20 String*3 Billing Currency A  Mask: %-3N
DETAILNUM 21 Long Detail Number E A 
TAUTH1 22 String*12 Tax Authority 1 A  Mask: %-12N
TAUTH2 23 String*12 Tax Authority 2 A  Mask: %-12N
TAUTH3 24 String*12 Tax Authority 3 A  Mask: %-12N
TAUTH4 25 String*12 Tax Authority 4 A  Mask: %-12N
TAUTH5 26 String*12 Tax Authority 5 A  Mask: %-12N
TCLASS1 27 Integer Tax Class 1 A X 
TCLASS2 28 Integer Tax Class 2 A X 
TCLASS3 29 Integer Tax Class 3 A X 
TCLASS4 30 Integer Tax Class 4 A X 
TCLASS5 31 Integer Tax Class 5 A X 
TINCLUDED1 32 Boolean Tax Included 1 A X 
TINCLUDED2 33 Boolean Tax Included 2 A X 
TINCLUDED3 34 Boolean Tax Included 3 A X 
TINCLUDED4 35 Boolean Tax Included 4 A X 
TINCLUDED5 36 Boolean Tax Included 5 A X 
CONTSTYLE 37 Integer ^1 Style A C  List:2 entries
1 = Standard
2 = Basic
PROJTYPE 38 Integer ^2 Type A C  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
CUSTOMER 39 String*12 Customer A C  Mask: %-12C
REVREC 40 Integer Accounting Method 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 41 Integer Invoice Type A C  List:2 entries
1 = Item
2 = Summary
VALUES 42 Long Optional Fields A C 
TAUTH1DESC 950 String*60 Description A C 
TAUTH2DESC 951 String*60 Description A C 
TAUTH3DESC 952 String*60 Description A C 
TAUTH4DESC 953 String*60 Description A C 
TAUTH5DESC 954 String*60 Description A C 
TCLAS1DESC 955 String*60 Description A C 
TCLAS2DESC 956 String*60 Description A C 
TCLAS3DESC 957 String*60 Description A C 
TCLAS4DESC 958 String*60 Description A C 
TCLAS5DESC 959 String*60 Description A C 
FUNCTION 1001 Integer Function E A C  List:2 entries
0 = None
10 = Load Optional Fields
ITEMDESC 1005 String*60 Description A C 
RESDESC 1006 String*60 Description A C 
HASOPT 1014 Boolean Optional Fields E A C  List:2 entries
0 = No
1 = Yes
CONTDESC 1009 String*60 Description A C 
PROJDESC 1010 String*60 Description A C 
CATDESC 1011 String*60 Description A C 

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