View: Refund Details

RotoID: AR0142
Table: ARRFD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:ARRFD

Compositions: 2

RotoID Tables Title DLL
AR0141 ARRFH Refund Entries ARRFH
AR0145 ARRFDJ Refund Detail Jobs ARRFDJ

Keys: 2

Title Fields
Refund Detail Seq. Number CNTBTCH, CNTITEM, CNTLINE
Doc./Payment/Batch/Entry No. IDINVC, CNTPAYM, CNTBTCH, CNTITEM

Fields: 30

Field Index Type Title Attributes Presentation
CNTBTCH 1 BCD*5.0 Batch Number E A K R 
CNTITEM 2 BCD*4.0 Entry Number E A K R 
CNTLINE 3 BCD*3.0 Line Number E A K R 
IDINVC 4 String*22 Document Number E A  Mask: %-22C
CNTPAYM 5 BCD*3.0 Payment Number E A 
PAYMTYPE 6 Integer Payment Type E A P  List:4 entries
1 = Cash
2 = Check
3 = Credit Card
5 = SPS Credit Card
IDBANK 7 String*8 C.C. Bank Account E A  Mask: %-8N
LONGSERIAL 8 Long C.C. Bank Serial Number E A C 
CODECURN 9 String*3 C.C. Payment Currency E A  Mask: %-3N
RATETYPE 10 String*2 C.C. Rate Type E A  Mask: %-2N
RATEDATE 11 Date C.C. Rate Date E A 
RATEEXCH 12 BCD*8.7 C.C. Exchange Rate E A 
RATEOP 13 Integer C.C. Rate Operator E A C  List:2 entries
1 = Multiply
2 = Divide
SWRATE 14 Integer C.C. Rate Override Flag E A  List:2 entries
0 = No
1 = Yes
AMTPC 20 BCD*10.3 Amount (Payment) E A 
AMTTC 21 BCD*10.3 Amount (Customer) E A C 
AMTHC 22 BCD*10.3 Amount (Functional) E A C 
SWJOB 23 Integer Job Related E A C  List:2 entries
0 = No
1 = Yes
APPLYMETH 24 Integer Job Apply Method E A  List:2 entries
0 = Prorate by Amount
1 = Top Down
AMTJOB 25 BCD*10.3 Job Applied Amount E A C 
TRXTYPETXT 50 Integer Document Type E A C  List:5 entries
0 = Unknown
3 = Credit Note
5 = Unapplied Cash
10 = Prepayment
11 = Receipt
DATEINVC 51 Date Document Date E A C 
ORGDOCAMT 52 BCD*10.3 Original Amount E A C 
CURBAL 53 BCD*10.3 Current Balance E A C 
PNDBAL 54 BCD*10.3 Pending Balance E A C 
NETBAL 55 BCD*10.3 Net Balance E A C 
UNAPLAMT 56 BCD*10.3 Unapplied Job Amount E A C 
IDCUST 57 String*12 Customer Number E A C  Mask: %-12C
PROCESSCMD 59 Integer Process Command E A C  List:2 entries
0 = Clear Job Distributions
1 = Allocate Job Distributions
CCRCPTNO 60 String*22 Receipt Document Number E A 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).