Table: Retainage Open Documents

Table: APRTG
View: AP0311
Record length: 164
Flags: A R 

Keys: 1

Title  Flags  Fields
Sequence Number/Vendor Number/Do  RTGSEQ, IDVEND, IDINVC

Fields: 19

Field  Type  Title  Presentation 
RTGSEQ  Long  Sequence Number   
IDVEND  String*12  Vendor 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  Invoice Date   
TXTTRXTYPE  Integer  Document Type  List: 6 entries
1=Invoice
2=Debit Note
3=Credit Note
4=Interest
10=Prepayment
11=Payment
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 - Vend. Curr.   
RTGAMTHC  BCD*10.3  Amount Retained - Func. Curr.   

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.