View: Cost Entries Header

RotoID: PM0420
Table: PMCEH
Protocol: Header, Key auto generate
DLL:PMCEH

Compositions: 2

RotoID Tables Title DLL

PM0422 PMCED Cost Entries Detail PMCED
PM0421 PMCEHO Cost Entries Optional Field PMCEHO

Keys: 4

Title Fields

Sequence SEQ
Document Number DOCNUM
Transaction Status/Document Numb TRANSTATDOCNUM
Status/Document Number COMPLETEDOCNUM

Fields: 46

Field Index Type Title Attributes Presentation

SEQ 1 Long Sequence E A K R 
DOCNUM 2 String*24 Document 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 Extended Cost A C 
EXTCOSTHM 9 BCD*10.3 Total Cost A C 
OHSR 10 BCD*10.3 Overhead Amount A C 
OHHM 11 BCD*10.3 Overhead Amount A C 
LABORSR 12 BCD*10.3 Labor Amount E A C 
LABORHM 13 BCD*10.3 Labor Amount E A C 
TOTCOSTSR 14 BCD*10.3 Total Cost Amount A C 
TOTCOSTHM 15 BCD*10.3 Total Cost Amount A C 
TOTBILLSR 16 BCD*10.3 Total Billable Amount A C 
TOTBILLHM 17 BCD*10.3 Total Billable Amount A C 
TOTQTY 18 BCD*10.5 Total Quantity A C 
COMPLETE 19 Integer Status E A P X  List:4 entries
0 = New
10 = Entered
30 = Approved
40 = Posted
PRINTSTAT 20 Boolean Printed E A  List:2 entries
0 = False
1 = True
TRANSTAT 21 Integer Transaction Status E A  List:4 entries
1 = Entered
2 = Imported
3 = Generated
4 = Posted
NEXTDTLNUM 22 Long Next Detail Number E A C 
NUMDTL 23 Long Number of Details E A C 
VALUES 24 Long Optional Fields E A C 
ICSTAT 25 Integer I/C Stat E A 
NUMMC 26 Long Number of Miscellaneous Costs E A C 
NUMTC 27 Long Number of Timecards E A C 
NUMTE 28 Long Number of Time Expenses E A C 
NUMEQ 29 Long Number of Equipment Usages E A C 
NUMMU 30 Long Number of Material Usages E A C 
NUMMR 31 Long Number of Material Returns E A C 
NUMCH 32 Long Number of Charges E A C 
CREATEBY 33 String*8 Created By A C 
CREATEDT 34 Date Created On A C 
CREATETM 35 Time Created At A C 
APPROVEBY 36 String*8 Approved By A C 
APPROVEDT 37 Date Approved On A C 
APPROVETM 38 Time Approved At A C 
POSTEDBY 39 String*8 Posted By A C 
POSTEDDT 40 Date Posted On A C 
POSTEDTM 41 Time Posted At A C 
GLHDESC 42 String*60 G/L Entry Description E A 
ENTEREDBY 43 String*8 Entered By E A C 
DATEBUS 44 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