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

This page was generated on 2023-Aug-31

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