View: Cost Entries Audit

RotoID: PM0424
Table: PMCEHA
Protocol: Flat
DLL:PMCEHA

Keys: 4

Title Fields
Posting Sequence POSTSEQNO
Sequence/Posting Sequence SEQ, POSTSEQNO
Document Number DOCNUM
Sequence/Transaction Date SEQ, TRANSDATE

Fields: 40

Field Index Type Title Attributes Presentation
POSTSEQNO 1 Long Posting Sequence E A K R 
SEQ 2 Long Sequence E A 
POSTDATE 3 Date Posting Date E A 
DOCNUM 4 String*24 Document Number E A 
TRANSDATE 5 Date Transaction Date E A 
FISCALYEAR 6 String*4 Fiscal Year E A 
FISCALPER 7 Integer Fiscal Period E A 
REFERENCE 8 String*60 Reference E A 
DESC 9 String*60 Description E A 
EXTCOSTSR 10 BCD*10.3 Extended Cost E A 
EXTCOSTHM 11 BCD*10.3 Total Cost E A 
OHSR 12 BCD*10.3 Overhead Amount E A 
OHHM 13 BCD*10.3 Overhead Amount E A 
TOTCOSTSR 14 BCD*10.3 Total Cost Amount E A 
TOTCOSTHM 15 BCD*10.3 Total Cost Amount E A 
TOTBILLSR 16 BCD*10.3 Total Billable Amount E A 
TOTBILLHM 17 BCD*10.3 Total Billable Amount E A 
TOTQTY 18 BCD*10.5 Total Quantity E A 
PRINTSTAT 19 Boolean Printed E A 
TRANSTAT 20 Integer Transaction Status E A 
VALUES 21 Long Optional Fields E A C 
ICSTAT 22 Integer I/C Stat E A 
NUMMC 23 Long Number of Miscellaneous Costs E A C 
NUMTC 24 Long Number of Timecards E A C 
NUMTE 25 Long Number of Time Expenses E A C 
NUMEQ 26 Long Number of Equipment Usages E A C 
NUMMU 27 Long Number of Material Usages E A C 
NUMMR 28 Long Number of Material Returns E A C 
NUMCH 29 Long Number of Charges E A C 
CREATEBY 30 String*8 Created By E A C 
CREATEDT 31 Date Created On E A C 
CREATETM 32 Time Created At E A C 
APPROVEBY 33 String*8 Approved By E A C 
APPROVEDT 34 Date Approved On E A C 
APPROVETM 35 Time Approved At E A C 
POSTEDBY 36 String*8 Posted By E A C 
POSTEDDT 37 Date Posted On E A C 
POSTEDTM 38 Time Posted At E A C 
GLHDESC 39 String*60 G/L Entry Description E A 
DATEBUS 40 Date Posting Date E A 

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