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 TRANSTATEQUIPNO
Status/Equipment Number COMPLETEEQUIPNO

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 C 
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