View: Opening Balances

RotoID: PM0401
Table: PMOBH
Protocol: Header, Key auto generate
DLL:PMOBH

Compositions: 1

RotoID Tables Title DLL

PM0402 PMOBD Opening Balances Detail PMOBD

Keys: 2

Title Fields

Sequence SEQ
Document Number DOCNUM

Fields: 23

Field Index Type Title Attributes Presentation

SEQ 1 Long Sequence E A K R 
DOCNUM 2 String*16 Document Number E A  Mask: %-16C
TRANSDATE 3 Date Transaction Date E A X 
FISCALYEAR 4 String*4 Fiscal Year A  Mask: %04D
FISCALPER 5 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
REFERENCE 6 String*60 Reference E A 
DESC 7 String*60 Description E A X 
COMPLETE 8 Integer Status E A P X  List:4 entries
0 = New
10 = Entered
30 = Approved
40 = Posted
TRANSTAT 9 Integer Transaction Status E A  List:4 entries
1 = Entered
2 = Imported
3 = Generated
4 = Posted
NEXTDTLNUM 10 Long Next Detail Number E A C 
NUMDTL 11 Long Number of Details E A C 
CREATEBY 12 String*8 Created By E A C 
CREATEDT 13 Date Created On E A C 
CREATETM 14 Time Created At E A C 
APPROVEBY 15 String*8 Approved By E A C 
APPROVEDT 16 Date Approved On E A C 
APPROVETM 17 Time Approved At E A C 
POSTEDBY 18 String*8 Posted By E A C 
POSTEDDT 19 Date Posted On E A C 
POSTEDTM 20 Time Posted At E A C 
ENTEREDBY 21 String*8 Entered By E A C 
DATEBUS 22 Date Posting Date E A X 
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