Table: Equipment

Table: PMEQIPH
View: PM0030
Record Length: 410

Flags: A R 

Keys: 4

Title Flags Fields

Sequence SEQ
Equipment Number EQUIPNO
Transaction Status/Equipment Num TRANSTATEQUIPNO
Status/Equipment Number M  COMPLETEEQUIPNO

Fields: 38

Field Type Title Presentation

SEQ Long Sequence
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
EQUIPNO String*16 Equipment Number Mask: %-16C
TRANSDATE Date Transaction Date
FISCALYEAR String*4 Fiscal Year Mask: %04D
FISCALPER Integer Fiscal Period 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 String*60 Reference
DESC String*60 Description
EXTCOSTSR BCD*10.3 Total Cost
EXTCOSTHM BCD*10.3 Total Cost
OHSR BCD*10.3 Overhead Amount
OHHM BCD*10.3 Overhead Amount
TOTCOSTSR BCD*10.3 Total Cost
TOTCOSTHM BCD*10.3 Total Cost
TOTBILLSR BCD*10.3 Total Billable Amount
TOTBILLHM BCD*10.3 Total Billable Amount
TOTQTY BCD*10.5 Total Quantity
COMPLETE Integer Status List:4 entries
0 = New
10 = Entered
30 = Approved
40 = Posted
PRINTSTAT Boolean Printed List:2 entries
0 = False
1 = True
TRANSTAT Integer Transaction Status List:4 entries
1 = Entered
2 = Imported
3 = Generated
4 = Posted
NEXTDTLNUM Long Next Detail Number
NUMDTL Long Number of Details
VALUES Long Optional Fields
CREATEBY String*8 Created By
CREATEDT Date Created On
CREATETM Time Created At
APPROVEBY String*8 Approved By
APPROVEDT Date Approved On
APPROVETM Time Approved At
POSTEDBY String*8 Posted By
POSTEDDT Date Posted On
POSTEDTM Time Posted At
GLHDESC String*60 G/L Entry Description
ENTEREDBY String*8 Entered By
DATEBUS Date Posting Date