View: Reopening Projects Worksheet

RotoID: PM0201
Table: PMROH
Protocol: Header, Key auto generate
DLL:PMROH

Compositions: 2

RotoID Tables Title DLL
PM0202 PMROD Reopen Worksheet Detail PMROD
PM0204 PMRODD Reopen Worksheet Accounts PMRODD

Keys: 2

Title Fields
Sequence SEQ
Worksheet Number WORKID

Fields: 26

Field Index Type Title Attributes Presentation
SEQ 1 Long Sequence E A K R 
WORKID 2 String*30 Worksheet Number E A  Mask: %-16C
DESC 3 String*60 Description E A X 
NEXTDTL 4 Long Next Detail Number A C 
JOUDATE 5 Date Worksheet Date A 
FISCALYEAR 6 String*4 Fiscal Year A 
FISCALPER 7 Integer Fiscal Period A  List:14 entries
0 =
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
COMPLETE 8 Integer Status E A  List:4 entries
0 = New
10 = Entered
30 = Approved
40 = Posted
NUMDTL 9 Long Number of Details A C 
PRINTSTAT 10 Boolean Printed E A  List:2 entries
0 = False
1 = True
REVERSE 11 Integer Reverse Entries for Completed Project Account Method ^5 A 
TDEBIT 12 BCD*10.3 Total Debits A C 
TCREDIT 13 BCD*10.3 Total Credits A C 
CREATEBY 14 String*8 Created By A C 
CREATEDT 15 Date Created On A C 
CREATETM 16 Time Created At A C 
APPROVEBY 17 String*8 Approved By A C 
APPROVEDT 18 Date Approved On A C 
APPROVETM 19 Time Approved At A C 
POSTEDBY 20 String*8 Posted By A C 
POSTEDDT 21 Date Posted On A C 
POSTEDTM 22 Time Posted At A C 
GLHDESC 23 String*60 G/L Entry Description E A 
DATEBUS 24 Date Posting Date A 
ENTEREDBY 25 String*8 Entered By E A C 
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

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