Table: RR Worksheet Header Audit

Table: PMRWHA
View: PM0095
Record length: 275
Flags: A R 

Keys: 3

Title  Flags  Fields
Sequence  SEQ
Worksheet Number  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 2008-May-01

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