# View: Equipment

RotoID: PM0030
Table: PMEQIPH
Protocol: Header, Key auto generate
DLL: PMEQIPH

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
PM0031 | PMEQIPD | Equipment Detail | PMEQIPD
PM0505 | PMEQHO | Equipment Optional Field | PMEQHO

## Keys: 4

Title | Fields
--- | ---
Sequence | SEQ
Equipment Number | EQUIPNO
Transaction Status/Equipment Num | TRANSTAT, EQUIPNO
Status/Equipment Number | COMPLETE, EQUIPNO

## Fields: 36

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
SEQ | 1 | Long | Sequence | E A K R |
EQUIPNO | 2 | String*16 | Equipment Number | E A | Mask: %-16C
TRANSDATE | 3 | Date | Transaction Date | E A X |
FISCALYEAR | 4 | String*4 | Fiscal Year | A | Mask: %04D
FISCALPER | 5 | Integer | Fiscal Period | A | List: 13 entries
1 | = | 1
2 | = | 2
3 | = | 3
4 | = | 4
5 | = | 5
6 | = | 6
7 | = | 7
8 | = | 8
9 | = | 9
10 | = | 10
11 | = | 11
12 | = | 12
13 | = | 13
REFERENCE | 6 | String*60 | Reference | E A X |
DESC | 7 | String*60 | Description | E A X |
EXTCOSTSR | 8 | BCD*10.3 | Total Cost | A |
EXTCOSTHM | 9 | BCD*10.3 | Total Cost | A |
OHSR | 10 | BCD*10.3 | Overhead Amount | A |
OHHM | 11 | BCD*10.3 | Overhead Amount | A |
TOTCOSTSR | 12 | BCD*10.3 | Total Cost | A |
TOTCOSTHM | 13 | BCD*10.3 | Total Cost | A |
TOTBILLSR | 14 | BCD*10.3 | Total Billable Amount | A |
TOTBILLHM | 15 | BCD*10.3 | Total Billable Amount | A |
TOTQTY | 16 | BCD*10.5 | Total Quantity | A |
COMPLETE | 17 | Integer | Status | E A P X | List: 4 entries
0 | = | New
10 | = | Entered
30 | = | Approved
40 | = | Posted
PRINTSTAT | 18 | Boolean | Printed | E A | List: 2 entries
0 | = | False
1 | = | True
TRANSTAT | 19 | Integer | Transaction Status | E A | List: 4 entries
1 | = | Entered
2 | = | Imported
3 | = | Generated
4 | = | Posted
NEXTDTLNUM | 20 | Long | Next Detail Number | E A C |
NUMDTL | 21 | Long | Number of Details | E A C |
VALUES | 22 | Long | Optional Fields | E A C |
CREATEBY | 23 | String*8 | Created By | A C |
CREATEDT | 24 | Date | Created On | A C |
CREATETM | 25 | Time | Created At | A C |
APPROVEBY | 26 | String*8 | Approved By | A C |
APPROVEDT | 27 | Date | Approved On | A C |
APPROVETM | 28 | Time | Approved At | A C |
POSTEDBY | 29 | String*8 | Posted By | A C |
POSTEDDT | 30 | Date | Posted On | A C |
POSTEDTM | 31 | Time | Posted At | A C |
GLHDESC | 32 | String*60 | G/L Entry Description | E A |
ENTEREDBY | 33 | String*8 | Entered By | E A |
DATEBUS | 34 | Date | Posting Date | E A X |
BMETER | 1000 | Integer | Show progress bar during posting | E A C | List: 3 entries
0 | = | No meter
1 | = | Meter
2 | = | Meter but no cancel button
FUNCTION | 1001 | Integer | Function | E A C | List: 2 entries
0 | = | None
10 | = | Load Optional Fields

This page was generated on 2008-May-01

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