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 TRANSTAT, DOCNUM
Status/Document Number COMPLETE, DOCNUM

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

This page was generated on 2022-Aug-18

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