Table: Update Retainage

Table: PMURH
View: PM0412
Record Length: 266

Flags: A R 

Keys: 2

Title Flags Fields

Sequence SEQ
Retainage Number DOCNUM

Fields: 28

Field Type Title Presentation

SEQ Long Sequence
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
DOCNUM String*24 Retainage Number Mask: %-16C
RETTYPE Integer Retainage Type List:4 entries
1 = Opening Retainage Receivable
2 = Opening Retainage Payable
3 = Invoice Retainage Receivable
4 = Invoice Retainage Payable
TRANSDATE Date Transaction Date
FISCALYEAR String*4 Fiscal Year Mask: %04D
FISCALPER Integer Fiscal Period 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 Integer Status List:4 entries
0 = New
10 = Entered
30 = Approved
40 = Posted
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
REFERENCE String*60 Reference
DESC String*60 Description
NUMDTL Long Number of Details
NEXTDTLNUM Long Next Detail Number
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
POSTEDDT Date Posted On
POSTEDTM Time Posted At
ENTEREDBY String*8 Entered By
DATEBUS Date Posting Date