View: Refund Entries

RotoID: AR0141
Table: ARRFH
Protocol: Header, Key auto generate
DLL:ARRFH

Compositions: 3

RotoID Tables Title DLL
AR0140 ARRFB Refund Batches ARRFB
AR0142 ARRFD Refund Details ARRFD
AR0143 ARRFHO Refund Optional Fields ARRFHO

Keys: 3

Title Fields
Entry Number CNTBTCH, CNTITEM
Customer Number IDCUST
Document Number IDINVC

Fields: 70

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 
DOCDESC 3 String*60 Document Description E A 
DOCDATE 4 Date Document Date E A 
FISCYR 5 String*4 Fiscal Year A C  Mask: %04D
FISCPER 6 String*2 Fiscal Period A C  Mask: %02D
IDCUST 7 String*12 Customer Number E A  Mask: %-12C
IDINVC 8 String*22 Document Number E A  Mask: %-22C
AMTTC 9 BCD*10.3 Refund Amount (Customer) E A C 
AMTHC 10 BCD*10.3 Refund Amount (Functional) E A C 
CODECURN 11 String*3 Customer Currency E A C  Mask: %-3N
RATETYPE 12 String*2 Rate Type E A  Mask: %-2N
RATEDATE 13 Date Rate Date E A 
RATEEXCH 14 BCD*8.7 Exchange Rate E A 
RATEOP 15 Integer Rate Operator E A C  List:2 entries
1 = Multiply
2 = Divide
SWRATE 16 Integer Rate Override Flag E A  List:2 entries
0 = No
1 = Yes
DATECREATE 17 Date Date Created E A C 
DATELSTEDT 18 Date Date Last Edited E A C 
DETAILCNT 19 Long Number of Details E A C 
APPLYMETH 20 Integer Job Apply Method E A  List:2 entries
0 = Prorate by Amount
1 = Top Down
VALUES 21 Long Number of Optional Fields E A C 
SRCEAPPL 22 String*2 Source Application E A  Mask: %-2A
ERRBATCH 23 Long Error Batch E A C 
ERRENTRY 24 Long Error Entry E A C 
IDBANKCA 25 String*8 Cash Bank Account E A  Mask: %-8N
IDACCTCA 26 String*45 Cash GL Account E A  Mask: %-45C
CODECURNCA 27 String*3 Cash Payment Currency E A  Mask: %-3N
RATETYPECA 28 String*2 Cash Rate Type E A  Mask: %-2N
RATEDATECA 29 Date Cash Rate Date E A 
RATEEXCHCA 30 BCD*8.7 Cash Exchange Rate E A 
RATEOPCA 31 Integer Cash Rate Operator E A C  List:2 entries
1 = Multiply
2 = Divide
SWRATECA 32 Integer Cash Rate Override Flag E A  List:2 entries
0 = No
1 = Yes
AMTPCCA 33 BCD*10.3 Cash Amount (Payment) E A C 
AMTTCCA 34 BCD*10.3 Cash Amount (Customer) E A C 
AMTHCCA 35 BCD*10.3 Cash Amount (Functional) E A C 
IDBANKCK 36 String*8 Check Bank Account E A  Mask: %-8N
SWPRINT 37 Integer Check Printing Required E A  List:2 entries
0 = No
1 = Yes
SWPRINTED 38 Integer Check Has Been Printed E A  List:2 entries
0 = Not Printed
1 = Printed
CHECKNUM 39 BCD*8.0 Check Number E A 
LONGSERIAL 40 ??? Check Serial Number E A C 
CODECURNCK 41 String*3 Check Payment Currency E A  Mask: %-3N
RATETYPECK 42 String*2 Check Rate Type E A  Mask: %-2N
RATEDATECK 43 Date Check Rate Date E A 
RATEEXCHCK 44 BCD*8.7 Check Exchange Rate E A 
RATEOPCK 45 Integer Check Rate Operator E A C  List:2 entries
1 = Multiply
2 = Divide
SWRATECK 46 Integer Check Rate Override Flag E A  List:2 entries
0 = No
1 = Yes
AMTPCCK 47 BCD*10.3 Check Amount (Payment) E A C 
AMTTCCK 48 BCD*10.3 Check Amount (Customer) E A C 
AMTHCCK 49 BCD*10.3 Check Amount (Functional) E A C 
NAMERMIT 50 String*60 Remit-To Name E A 
TEXTSTRE1 51 String*60 Address Line 1 E A 
TEXTSTRE2 52 String*60 Address Line 2 E A 
TEXTSTRE3 53 String*60 Address Line 3 E A 
TEXTSTRE4 54 String*60 Address Line 4 E A 
NAMECITY 55 String*30 City E A 
CODESTTE 56 String*30 State/Prov. E A 
CODEPSTL 57 String*20 Zip/Postal Code E A 
CODECTRY 58 String*30 Country E A 
CHECKLANG 59 String*3 Check Language E A P  List:7 entries
1 = ENG
2 = FRA
3 = ESN
4 = AUS
5 = MEX
6 = CHN
7 = CHT
AMTTCCC 60 BCD*10.3 C.C. Amount (Customer) E A C 
PROCESSCMD 61 Integer Process Command E A C  List:2 entries
0 = Insert Optional Fields
1 = Void Check
ENTEREDBY 62 String*8 Entered By E A C 
DATEBUS 63 Date Posting Date E A 
CCSPSCNT 64 Long Number of SPS C.C. Details E A C 
CCORIGID 65 String*36 Original C.C. Transaction Number E A C 
CCPREVID 66 String*36 Previous C.C. Transaction Number E A 
CCPREVSTTS 67 Integer Previous C.C. Process Status E A  List:5 entries
0 = SPS Transaction Not Started
9 = SPS Credit Transaction Pending
10 = SPS Credit Transaction Completed
7 = SPS Void Transaction Pending
8 = SPS Void Transaction Completed
CCTRANID 68 String*36 Current C.C. Transaction Number E A 
CCTRANSTTS 69 Integer Current C.C. Process Status E A  List:5 entries
0 = SPS Transaction Not Started
9 = SPS Credit Transaction Pending
10 = SPS Credit Transaction Completed
7 = SPS Void Transaction Pending
8 = SPS Void Transaction Completed
PROCESSCOD 70 String*12 Processing Code E A 

This page was generated on 2022-Aug-18

© 2021 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).