View: Equipment Audit

RotoID: PM0032
Table: PMEQPHA
Protocol: Flat
DLL:PMEQIPHA

Keys: 4

Title Fields
Posting Sequence POSTSEQNO
Sequence/Posting Sequence SEQ, POSTSEQNO
Equipment Number EQUIPNO
Sequence/Transaction Date SEQ, TRANSDATE

Fields: 32

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 
EQUIPNO 4 String*16 Equipment 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 Extended 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 E A 
TOTCOSTHM 15 BCD*10.3 Total Cost 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 
CREATEBY 22 String*8 Created By E A C 
CREATEDT 23 Date Created On E A C 
CREATETM 24 Time Created At E A C 
APPROVEBY 25 String*8 Approved By E A C 
APPROVEDT 26 Date Approved On E A C 
APPROVETM 27 Time Approved At E A C 
POSTEDBY 28 String*8 Posted By E A C 
POSTEDDT 29 Date Posted On E A C 
POSTEDTM 30 Time Posted At E A C 
GLHDESC 31 String*60 G/L Entry Description E A 
DATEBUS 32 Date Posting Date E A 

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