Table: Document Sched. Payments

Table: AROBS
View: AR0037
Record length: 298
Flags: A R 

Keys: 13

Title  Flags  Fields
Customer/Document Number  IDCUST, IDINVC, CNTPAYM
Document Number  D M  IDINVC, CNTPAYM
Order Number  D M  IDCUST, IDORDRNBR, IDINVC, CNTPAYM
PO Number  D M  IDCUST, IDCUSTPO, IDINVC, CNTPAYM
Due Date  D M  IDCUST, DATEDUE, IDINVC, CNTPAYM
Nat. Acct./Customer/Doc. No.  D M  IDNATACCT, IDCUST, IDINVC, CNTPAYM
Remaining Cust. Receipt Amount  D M  IDCUST, AMTPYMRMTC, DATEDUE, IDINVC, CNTPAYM
Paid/Doc. No.  D M  SWPAID, IDINVC, CNTPAYM
Document Date  D M  IDCUST, DATEINVC, IDINVC, CNTPAYM
Paid/Prepay. No.  D M  SWPAID, IDPREPAID
Paid/Customer/Doc. No.  D M  SWPAID, IDCUST, IDINVC, CNTPAYM
Paid/Nat. Acct./Doc. No.  D M  SWPAID, IDNATACCT, IDINVC, CNTPAYM
Shipment Number  D M  IDCUST, IDSHIPNBR, IDINVC, CNTPAYM

Fields: 31

Field  Type  Title  Presentation 
IDCUST  String*12  Customer Number  Mask: %-12C
IDINVC  String*22  Document Number  Mask: %-22C
CNTPAYM  BCD*3.0  Payment Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
IDRMIT  String*24  Receipt Number  Mask: %-24C
DATEDUE  Date  Due Date   
DATEDISC  Date  Discount Date   
SWPAID  Integer  Fully Paid Switch  List: 2 entries
0=No
1=Yes
DLNQSTTS  Integer  Reserved   
AMTDUEHC  BCD*10.3  Original Amount (Func.)   
AMTDISCHC  BCD*10.3  Original Discount (Func.)   
AMTDCSRMHC  BCD*10.3  Remaining Discount (Func.)   
AMTPYMRMHC  BCD*10.3  Remaining Amount (Func.)   
AMTDUETC  BCD*10.3  Original Amount   
AMTDISCTC  BCD*10.3  Original Discount   
AMTDSCRMTC  BCD*10.3  Remaining Discount   
AMTPYMRMTC  BCD*10.3  Remaining Amount   
IDORDRNBR  String*22  Order Number   
IDCUSTPO  String*22  PO Number   
IDNATACCT  String*12  National Account Number  Mask: %-12C
IDGRP  String*6  Group Code  Mask: %-6N
IDPREPAID  String*22  Prepay. Apply-to Doc. No.  Mask: %-22C
IDTRXTYPE  Integer  Transaction Type  List: 19 entries
1=Unapplied Cash - Posted
11=Invoice - Item Issued
12=Invoice - Summary Entered
13=Invoice - Recurring Charge
14=Invoice - Summary Issued
15=Invoice - Item Entered
21=Debit Note - Item Issued
22=Debit Note - Summary Entered
24=Debit Note - Summary Issued
25=Debit Note - Item Entered
26=Debit Note - Advance Credit Claim
31=Credit Note - Item Issued
32=Credit Note - Summary Entered
34=Credit Note - Summary Issued
35=Credit Note - Item Entered
40=Interest Charge
50=Prepayment - Posted
51=Receipt - Posted
73=Refund - Posted
TXTTRXTYPE  Integer  Document Type  List: 8 entries
1=Invoice
2=Debit Note
3=Credit Note
4=Interest
5=Unapplied Cash
10=Prepayment
11=Receipt
19=Refund
DATEINVC  Date  Document Date   
DAYSTOPAY  Integer  Number of Days to Pay   
SWJOB  Integer  Job Related  List: 2 entries
0=No
1=Yes
IDSHIPNBR  String*22  Shipment Number   

This page was generated on 2008-May-01

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