Table: Revenue Recognition Worksheet

Table: PMRWH
View: PM0091
Record Length: 283

Flags: A R 

Keys: 2

Title Flags Fields

Sequence SEQ
Worksheet Number WORKID

Fields: 31

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
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
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
POSTEDDT Date Posted On
POSTEDTM Time Posted At
GLHDESC String*60 G/L Entry Description
JOUYEAR String*4 Fiscal Year Mask: %04D
JOUPER Integer Fiscal Period List:13 entries
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
DATEBUS Date Posting Date
ENTEREDBY String*8 Entered By