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