# View: Charges Audit Detail

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

## Compositions: 0

## 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 2008-May-01

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