# Table: Aged Documents

Table: APAGED
View: AP0125
Record length: 668
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Primary Key |  | AGESEQ, RECORDNO, IDVEND, IDINVC, ADJNO, RECTYPE, CNTSEQ

## Fields: 58

Field | Type | Title | Presentation
--- | --- | --- | ---
AGESEQ | Long | Aging Sequence Number |
RECORDNO | Long | Record Number |
IDVEND | String*12 | Vendor Number | Mask: %-12C
IDINVC | String*22 | Document Number | Mask: %-22C
ADJNO | Long | Adjustment Sequence Number |
RECTYPE | Integer | Record Type | List: 3 entries
0 | = | Document
1 | = | Applied Detail
2 | = | Retainage Document
CNTSEQ | Long | Detail Sequence Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
IDRMIT | String*12 | Check Number | Mask: %-12D
TRXTYPETXT | Integer | Document Type |
TRXTYPEID | Integer | Transaction Type |
DATEINVC | Date | Document Date |
DATEBUS | Date | Posting Date |
DATEDUE | Date | Due Date |
SWPYSTTS | Integer | Payment Status | List: 3 entries
0 | = | Normal
1 | = | On Hold
2 | = | Forced
IDMEMOXREF | String*22 | Reference Document No. |
AMTINVCTC | BCD*10.3 | Invoice Amount (Source) |
AMTINVCHC | BCD*10.3 | Invoice Amount (Functional) |
AMTPAIDTC | BCD*10.3 | Amount Paid (Source) |
AMTPAIDHC | BCD*10.3 | Amount Paid (Functional) |
AMTDUE1TC | BCD*10.3 | Current Amount Due (Source) |
AMTDUE1HC | BCD*10.3 | Current Amount Due (Functional) |
AMTDUE2TC | BCD*10.3 | Period 1 Amount Due (Source) |
AMTDUE2HC | BCD*10.3 | Period 1 Amount Due (Functional) |
AMTDUE3TC | BCD*10.3 | Period 2 Amount Due (Source) |
AMTDUE3HC | BCD*10.3 | Period 2 Amount Due (Functional) |
AMTDUE4TC | BCD*10.3 | Period 3 Amount Due (Source) |
AMTDUE4HC | BCD*10.3 | Period 3 Amount Due (Functional) |
AMTDUE5TC | BCD*10.3 | Period 4 Amount Due (Source) |
AMTDUE5HC | BCD*10.3 | Period 4 Amount Due (Functional) |
AMTDUE6TC | BCD*10.3 | Period 5 Amount Due (Source) |
AMTDUE6HC | BCD*10.3 | Period 5 Amount Due (Functional) |
AMTDUE7TC | BCD*10.3 | Period 6 Amount Due (Source) |
AMTDUE7HC | BCD*10.3 | Period 6 Amount Due (Functional) |
AMTDUE8TC | BCD*10.3 | Period 7 Amount Due (Source) |
AMTDUE8HC | BCD*10.3 | Period 7 Amount Due (Functional) |
AMTDUE9TC | BCD*10.3 | Period 9 Amount Due (Source) |
AMTDUE9HC | BCD*10.3 | Period 9 Amount Due (Functional) |
TOTBKWDTC | BCD*10.3 | Total Backward Aging (Source) |
TOTBKWDHC | BCD*10.3 | Total Backward Aging (Functional) |
TOTFWDTC | BCD*10.3 | Total Forward Aging (Source) |
TOTFWDHC | BCD*10.3 | Total Forward Aging (Functional) |
AMTBALDUET | BCD*10.3 | Vendor Balance Due (Source) |
AMTBALDUEH | BCD*10.3 | Vendor Balance Due (Functional) |
DOCTYPE | Integer | Document Type |
SWNONRCVBL | Integer | Misc. Payment Flag |
RTGDATEDUE | Date | Date Retainage Due |
SORTVALUE1 | String*60 | Sort Field Value 1 |
SORTVALUE2 | String*60 | Sort Field Value 2 |
SORTVALUE3 | String*60 | Sort Field Value 3 |
SORTVALUE4 | String*60 | Sort Field Value 4 |
SORTTYPE1 | Integer | Sort Field Type 1 |
SORTTYPE2 | Integer | Sort Field Type 2 |
SORTTYPE3 | Integer | Sort Field Type 3 |
SORTTYPE4 | Integer | Sort Field Type 4 |

This page was generated on 2009-Nov-19

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