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 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).