View: Revenue Recognition Worksheet

RotoID: PM0091
Table: PMRWH
Protocol: Header, Key auto generate
DLL:PMRWH

Compositions: 2

RotoID Tables Title DLL

PM0092 PMRWD RR Worksheet Detail PMRWD
PM0094 PMRWDD RR Worksheet Accounts PMRWDD

Keys: 2

Title Fields

Sequence SEQ
Worksheet Number WORKID

Fields: 32

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 E A 
CUTBY 5 Integer Cutoff By A  List:2 entries
0 = Transaction Date
1 = Fiscal Year/Period
CUTDATE 6 Date Cutoff Date A 
FISCALYEAR 7 String*4 Cutoff Fiscal Year A 
FISCALPER 8 Integer Cutoff 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
JOUDATE 9 Date Worksheet Date E A X 
COMPLETE 10 Integer Status E A  List:4 entries
0 = New
10 = Entered
30 = Approved
40 = Posted
NUMDTL 11 Long Number of Details E A C 
PRINTSTAT 12 Boolean Printed E A  List:2 entries
0 = False
1 = True
TRANSTAT 13 Integer Transaction Status E A  List:4 entries
1 = Entered
2 = Imported
3 = Generated
4 = Posted
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 
JOUYEAR 24 String*4 Fiscal Year A  Mask: %04D
JOUPER 25 Integer Fiscal Period A  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 26 Date Posting Date E A X 
ENTEREDBY 27 String*8 Entered By E A C 
CLOSEP 1000 Integer Closing E A C  List:5 entries
0 = None
1 = Prompt to close
2 = Close
3 = Don't Close
4 = Cancel Posting
CONTRACT 1001 String*16 ^1 A C 
PROJECT 1002 String*16 ^2 A C 
BCREATEGL 1003 Boolean Create G/L Batch E A C 
BMETER 1004 Integer Show progress bar during posting E A C  List:3 entries
0 = No meter
1 = Meter
2 = Meter but no cancel button