View: Update Retainage Detail

RotoID: PM0410
Table: PMURD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMURD

Compositions: 1

RotoID Tables Title DLL

PM0412 PMURH Update Retainage PMURH

Keys: 3

Title Fields

Sequence/Line Number SEQLINENO
Docnum/Line Number DOCNUMLINENO
Sequence/Detail Number SEQDETAILNUM

Fields: 19

Field Index Type Title Attributes Presentation

SEQ 1 Long Sequence E A K R 
LINENO 2 Integer Line Number E A K R 
DOCNUM 3 String*24 Retainage Number E A C  Mask: %-16C
RETTYPE 4 Integer Retainage Type E A C  List:4 entries
1 = Opening Retainage Receivable
2 = Opening Retainage Payable
3 = Invoice Retainage Receivable
4 = Invoice Retainage Payable
FMTCONTNO 5 String*16 ^1 E A  Mask: %-16C
CONTRACT 6 String*16 ^1 E A  Mask: %-16C
PROJECT 7 String*16 ^2 E A  Mask: %-16N
CATEGORY 8 String*16 ^3 A X  Mask: %-16N
DETAILNUM 9 Long Detail Number E A C 
CONTSTYLE 10 Integer ^1 Style E A C  List:2 entries
1 = Standard
2 = Basic
PROJTYPE 11 Integer ^2 Type E A C  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 12 Integer Accounting Method E A C 
COMMENTS 13 String*250 Comments E A 
ODOCNUM 14 String*24 Original Document Number E A 
AMOUNT 15 BCD*10.3 Retainage Amount E A 
CUSTCCY 16 String*3 Currency A C  Mask: %-3N
CONTDESC 1001 String*60 Description A C 
PROJDESC 1002 String*60 Description A C 
CATDESC 1003 String*60 Description A C