# 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 |  | SEQ, JOUDATE

## 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 |

This page was generated on 2009-Nov-19

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