Table: Aged Documents

Table: ARAGED
View: AR0125
Record length: 397
Flags: A R 

Keys: 1

Title  Flags  Fields

Primary Key  AGESEQ, RECORDNO, IDCUST, IDINVC, RECTYPE, CNTSEQ

Fields: 43

Field  Type  Title  Presentation 

AGESEQ  Long  Aging Sequence Number   
RECORDNO  Long  Record Number   
IDCUST  String*12  Customer Number  Mask: %-12C
IDINVC  String*22  Document Number  Mask: %-22C
RECTYPE  Integer  Record Type  List: 2 entries
0=Document
1=Applied Detail
CNTSEQ  Long  Detail Sequence Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
IDRMIT  String*24  Check/Receipt Number  Mask: %-24C
TRXTYPETXT  Integer  Document Type   
TRXTYPEID  Integer  Transaction Type   
DATEINVC  Date  Document Date   
DATEBUS  Date  Posting Date   
DATEDUE  Date  Due Date   
IDMEMOXREF  String*22  Reference Document No.   
AMTINVCTC  BCD*10.3  Invoice Amount (Source)   
AMTINVCHC  BCD*10.3  Invoice Amount (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  Customer Balance Due (Source)   
AMTBALDUEH  BCD*10.3  Customer Balance Due (Functional)   

This page was generated on 2008-May-01

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