# View: Equipment Audit Detail

RotoID: PM0033
Table: PMEQPDA
Protocol: Flat
DLL: PMEQIPDA

## Compositions: 0

## Keys: 3

Title | Fields
--- | ---
Posting Sequence/Line Number | POSTSEQNO, LINENO
Posting Sequence/Detail Number | POSTSEQNO, DETAILNUM
Sequence/Posting Sequence/Detail | SEQ, POSTSEQNO, DETAILNUM

## Fields: 60

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 |
EQUIPNO | 4 | String*16 | Equipment Number | E A |
FMTCONTNO | 5 | String*16 | Contract | E A |
CONTRACT | 6 | String*16 | Contract | E A |
PROJECT | 7 | String*16 | Project | E A |
CATEGORY | 8 | String*16 | Category | E A |
RESOURCE | 9 | String*24 | Equipment Code | E A |
DESC | 10 | String*60 | Description | E A |
QUANTITY | 11 | BCD*10.5 | Quantity | E A |
ARITEM | 12 | String*16 | A/R Item No. | E A |
UOM | 13 | String*10 | Unit of Measure | E A |
UNITCOST | 14 | BCD*10.6 | Unit Cost | E A |
COSTCCY | 15 | String*3 | Cost Currency | E A |
EXTCOSTSR | 16 | BCD*10.3 | Extended Cost | E A |
EXTCOSTHM | 17 | BCD*10.3 | Extended Cost | E A |
OHACCT | 18 | String*45 | Overhead Account | E A |
OVERHD | 19 | Integer | Overhead Type | E A |
OHEADRATE | 20 | BCD*10.6 | Overhead Rate | E A |
HEADPER | 21 | BCD*5.5 | Overhead Percentage | E A |
OHSR | 22 | BCD*10.3 | Transaction Overhead Amount | E A |
OHHM | 23 | BCD*10.3 | Transaction Overhead Amount | E A |
TOTCOSTSR | 24 | BCD*10.3 | Total Cost | E A |
TOTCOSTHM | 25 | BCD*10.3 | Total Cost | E A |
COMMENTS | 26 | String*250 | Comments | E A |
EQUIPACCT | 27 | String*45 | Equipment Account | E A |
WIPACCT | 28 | String*45 | Work in Progress Account | E A |
BILLTYPE | 29 | Integer | Billing Type | E A |
FIXEDBILL | 30 | Integer | Bill Amount Based On | E A |
ESTBILLCCY | 31 | Integer | Revenue And Cost Currency | E A |
BILLRATE | 32 | BCD*10.6 | Billing Rate | E A |
EXTBILLSR | 33 | BCD*10.3 | Extended Billing Amount | E A |
EXTBILLHM | 34 | BCD*10.3 | Reserved | E A |
BILLCCY | 35 | String*3 | Billing Currency | E A |
DETAILNUM | 36 | Long | Detail Number | E A |
TAUTH1 | 37 | String*12 | Tax Authority 1 | E A |
TAUTH2 | 38 | String*12 | Tax Authority 2 | E A |
TAUTH3 | 39 | String*12 | Tax Authority 3 | E A |
TAUTH4 | 40 | String*12 | Tax Authority 4 | E A |
TAUTH5 | 41 | String*12 | Tax Authority 5 | E A |
TCLASS1 | 42 | Integer | Tax Class 1 | E A |
TCLASS2 | 43 | Integer | Tax Class 2 | E A |
TCLASS3 | 44 | Integer | Tax Class 3 | E A |
TCLASS4 | 45 | Integer | Tax Class 4 | E A |
TCLASS5 | 46 | Integer | Tax Class 5 | E A |
TINCLUDED1 | 47 | Boolean | Tax Included 1 | E A |
TINCLUDED2 | 48 | Boolean | Tax Included 2 | E A |
TINCLUDED3 | 49 | Boolean | Tax Included 3 | E A |
TINCLUDED4 | 50 | Boolean | Tax Included 4 | E A |
TINCLUDED5 | 51 | Boolean | Tax Included 5 | E A |
PROJTYPE | 52 | Integer | Project Type | E A |
CONTSTYLE | 53 | Integer | Contract Style | E A C |
CUSTOMER | 54 | String*12 | Customer | E A C |
REVREC | 55 | Integer | Accounting Method | E A C |
INVTYPE | 56 | Integer | Invoice Type | E A C |
VALUES | 57 | Long | Optional Fields | E A C |
GLDDESC | 58 | String*60 | G/L Detail Description | E A |
GLDREF | 59 | String*60 | G/L Detail Reference | E A |
GLCOMMENT | 60 | String*250 | G/L Detail Comment | E A |

This page was generated on 2009-Nov-19

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