# View: Reopening Projects Worksheet

RotoID: PM0201
Table: PMROH
Protocol: Header, Key auto generate
DLL: PMROH

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
PM0202 | PMROD | Reopen Worksheet Detail | PMROD
PM0204 | PMRODD | Reopen Worksheet Accounts | PMRODD

## Keys: 2

Title | Fields
--- | ---
Sequence | SEQ
Worksheet Number | WORKID

## 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 X |
NEXTDTL | 4 | Long | Next Detail Number | A C |
JOUDATE | 5 | Date | Worksheet Date | A |
FISCALYEAR | 6 | String*4 | Fiscal Year | A |
FISCALPER | 7 | Integer | 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
COMPLETE | 8 | Integer | Status | E A | List: 4 entries
0 | = | New
10 | = | Entered
30 | = | Approved
40 | = | Posted
NUMDTL | 9 | Long | Number of Details | A C |
PRINTSTAT | 10 | Boolean | Printed | E A | List: 2 entries
0 | = | False
1 | = | True
REVERSE | 11 | Integer | Reverse Entries for Completed Project Account Method Projects | A |
TDEBIT | 12 | BCD*10.3 | Total Debits | A C |
TCREDIT | 13 | BCD*10.3 | Total Credits | A C |
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 |
DATEBUS | 24 | Date | Posting Date | A |
ENTEREDBY | 25 | String*8 | Entered By | E A |
BMETER | 1000 | Integer | Show progress bar during posting | E A C | List: 3 entries
0 | = | No meter
1 | = | Meter
2 | = | Meter but no cancel button

This page was generated on 2009-Nov-19

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