Table: RR Worksheet Header Audit

Table: PMRWHA
View: PM0095
Record Length: 275

Flags: A R 

Keys: 3

Title Flags Fields

Sequence SEQ
Worksheet Number D  WORKID
Sequence/Worksheet Date SEQJOUDATE

Fields: 30

Field Type Title Presentation

SEQ Long Sequence
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
WORKID String*30 Worksheet Number Mask: %-16C
DESC String*60 Description
NEXTDTL Long Next Detail Number
CUTBY Integer Cutoff By List:2 entries
0 = Transaction Date
1 = Fiscal Year/Period
CUTDATE Date Cutoff Date
FISCALYEAR String*4 Cutoff Fiscal Year
FISCALPER Integer Cutoff Fiscal Period 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 Date Worksheet Date
JOUYEAR String*4 Fiscal Year
JOUPER Integer Fiscal Period 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 Integer Status List:4 entries
0 = New
10 = Entered
30 = Approved
40 = Posted
NUMDTL Long Number of Details
PRINTSTAT Boolean Printed List:2 entries
0 = False
1 = True
TRANSTAT Integer Transaction Status List:4 entries
1 = Entered
2 = Imported
3 = Generated
4 = Posted
POSTDATE Date Posted On
POSTTIME Time Posted At
CREATEBY String*8 Created By
CREATEDT Date Created On
CREATETM Time Created At
APPROVEBY String*8 Approved By
APPROVEDT Date Approved On
APPROVETM Time Approved At
POSTEDBY String*8 Posted By
GLHDESC String*60 G/L Entry Description
DATEBUS Date Posting Date