Table: Retainage Open Documents

Table: ARRTG
View: AR0311
Record length: 164
Flags: A R 

Keys: 1

Title  Flags  Fields

Sequence Number/Customer Number/  RTGSEQ, IDCUST, IDINVC

Fields: 19

Field  Type  Title  Presentation 

RTGSEQ  Long  Sequence Number   
IDCUST  String*12  Customer Number  Mask: %-12C
IDINVC  String*22  Document Number  Mask: %-22C
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
RTGDATEDUE  Date  Date Retainage Due   
DATEINVC  Date  Document Date   
TRXTYPETXT  Integer  Document Type  List: 7 entries
1=Invoice
2=Debit Note
3=Credit Note
4=Interest
5=Unapplied Cash
10=Prepayment
11=Receipt
AMTDUE1  BCD*10.3  Current Amount Due   
AMTDUE2  BCD*10.3  Period 1 Amount Due   
AMTDUE3  BCD*10.3  Period 2 Amount Due   
AMTDUE4  BCD*10.3  Period 3 Amount Due   
AMTDUE5  BCD*10.3  Period 4 Amount Due   
TOTAMTBKWD  BCD*10.3  Total Backward Aging   
TOTAMTFWD  BCD*10.3  Total Forward Aging   
RTGAMTTC  BCD*10.3  Amount Retained - Cust. Curr.   
RTGAMTHC  BCD*10.3  Amount Retained - Func. Curr.   

This page was generated on 2008-May-01

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