View: Document Sched. Payments

RotoID: AR0037
Table: AROBS
Protocol: Flat
DLL: AROBS

Compositions: 0

Keys: 14

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

Fields: 28

Field  Index  Type  Title  Attributes  Presentation
IDCUST  1  String*12  Customer Number  E A K R  Mask: %-12C
IDINVC  2  String*22  Document Number  E A K R  Mask: %-22C
CNTPAYM  3  BCD*3.0  Payment Number  E A K R   
IDRMIT  4  String*24  Receipt Number  E A  Mask: %-24C
DATEDUE  5  Date  Due Date  E A   
DATEDISC  6  Date  Discount Date  E A   
SWPAID  7  Integer  Fully Paid Switch  E A  List: 2 entries
0=No
1=Yes
DLNQSTTS  8  Integer  Reserved  E   
AMTDUEHC  9  BCD*10.3  Original Amount (Func.)  E A   
AMTDISCHC  10  BCD*10.3  Original Discount (Func.)  E A   
AMTDCSRMHC  11  BCD*10.3  Remaining Discount (Func.)  E A   
AMTPYMRMHC  12  BCD*10.3  Remaining Amount (Func.)  E A   
AMTDUETC  13  BCD*10.3  Original Amount  E A   
AMTDISCTC  14  BCD*10.3  Original Discount  E A   
AMTDSCRMTC  15  BCD*10.3  Remaining Discount  E A   
AMTPYMRMTC  16  BCD*10.3  Remaining Amount  E A   
IDORDRNBR  17  String*22  Order Number  E A   
IDCUSTPO  18  String*22  PO Number  E A   
IDNATACCT  19  String*12  National Account Number  E A  Mask: %-12C
IDGRP  20  String*6  Group Code  E A  Mask: %-6N
IDPREPAID  21  String*22  Prepay. Apply-to Doc. No.  E A  Mask: %-22C
IDTRXTYPE  22  Integer  Transaction Type  E A  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  23  Integer  Document Type  E A  List: 8 entries
1=Invoice
2=Debit Note
3=Credit Note
4=Interest
5=Unapplied Cash
10=Prepayment
11=Receipt
19=Refund
DATEINVC  24  Date  Document Date  E A   
DAYSTOPAY  25  Integer  Number of Days to Pay  E A   
SWJOB  26  Integer  Job Related  E A  List: 2 entries
0=No
1=Yes
IDSHIPNBR  27  String*22  Shipment Number  E A   
RTGAPPLYTO  28  String*22  Original Doc. No.  E A  Mask: %-22C

This page was generated on 2009-Nov-19

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