# View: RR Worksheet Header Audit

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

## Compositions: 0

## 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 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.