View: Update Retainage

RotoID: PM0412
Table: PMURH
Protocol: Header, Key auto generate
DLL:PMURH

Compositions: 1

RotoID Tables Title DLL

PM0410 PMURD Update Retainage Detail PMURD

Keys: 2

Title Fields

Sequence SEQ
Retainage Number DOCNUM

Fields: 25

Field Index Type Title Attributes Presentation

SEQ 1 Long Sequence E A K R 
DOCNUM 2 String*24 Retainage Number E A  Mask: %-16C
RETTYPE 3 Integer Retainage Type E A X  List:4 entries
1 = Opening Retainage Receivable
2 = Opening Retainage Payable
3 = Invoice Retainage Receivable
4 = Invoice Retainage Payable
TRANSDATE 4 Date Transaction Date E A X 
FISCALYEAR 5 String*4 Fiscal Year A  Mask: %04D
FISCALPER 6 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
COMPLETE 7 Integer Status E A P X  List:4 entries
0 = New
10 = Entered
30 = Approved
40 = Posted
PRINTSTAT 8 Boolean Printed E A  List:2 entries
0 = False
1 = True
TRANSTAT 9 Integer Transaction Status E A  List:4 entries
1 = Entered
2 = Imported
3 = Generated
4 = Posted
REFERENCE 10 String*60 Reference E A X 
DESC 11 String*60 Description E A X 
NUMDTL 12 Long Number of Details E A C 
NEXTDTLNUM 13 Long Next Detail Number E 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 
ENTEREDBY 23 String*8 Entered By E A C 
DATEBUS 24 Date Posting Date E A X 
BMETER 1000 Integer Show progress bar during posting E A C