View: RR Worksheet Header Audit

RotoID: PM0095
Table: PMRWHA
Protocol: Flat
DLL:PMRWHA

Keys: 3

Title Fields
Sequence SEQ
Worksheet Number WORKID
Sequence/Worksheet Date SEQ, JOUDATE

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 
NEXTDTL 4 Long Next Detail Number E A 
CUTBY 5 Integer Cutoff By E A  List:2 entries
0 = Transaction Date
1 = Fiscal Year/Period
CUTDATE 6 Date Cutoff Date E A 
FISCALYEAR 7 String*4 Cutoff Fiscal Year E A 
FISCALPER 8 Integer Cutoff Fiscal Period E 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
JOUDATE 9 Date Worksheet Date E A 
JOUYEAR 10 String*4 Fiscal Year E A 
JOUPER 11 Integer Fiscal Period E 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 12 Integer Status E A  List:4 entries
0 = New
10 = Entered
30 = Approved
40 = Posted
NUMDTL 13 Long Number of Details E A C 
PRINTSTAT 14 Boolean Printed E A  List:2 entries
0 = False
1 = True
TRANSTAT 15 Integer Transaction Status E A  List:4 entries
1 = Entered
2 = Imported
3 = Generated
4 = Posted
POSTDATE 16 Date Posted On E A 
POSTTIME 17 Time Posted At E A 
CREATEBY 18 String*8 Created By E A C 
CREATEDT 19 Date Created On E A C 
CREATETM 20 Time Created At E A C 
APPROVEBY 21 String*8 Approved By E A C 
APPROVEDT 22 Date Approved On E A C 
APPROVETM 23 Time Approved At E A C 
POSTEDBY 24 String*8 Posted By E A C 
GLHDESC 25 String*60 G/L Entry Description E A 
DATEBUS 26 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).