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.