# 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 |

This page was generated on 2008-May-01

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