Table: Refund Entries

Table: ARRFH
View: AR0141
Record Length: 959

Flags: A R 

Keys: 3

Title Flags Fields

Entry Number CNTBTCHCNTITEM
Customer Number D M  IDCUST
Document Number D M  IDINVC

Fields: 73

Field Type Title Presentation

CNTBTCH BCD*5.0 Batch Number
CNTITEM BCD*4.0 Entry Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
DOCDESC String*60 Document Description
DOCDATE Date Document Date
FISCYR String*4 Fiscal Year Mask: %04D
FISCPER String*2 Fiscal Period Mask: %02D
IDCUST String*12 Customer Number Mask: %-12C
IDINVC String*22 Document Number Mask: %-22C
AMTTC BCD*10.3 Refund Amount (Customer)
AMTHC BCD*10.3 Refund Amount (Functional)
CODECURN String*3 Customer Currency Mask: %-3N
RATETYPE String*2 Rate Type Mask: %-2N
RATEDATE Date Rate Date
RATEEXCH BCD*8.7 Exchange Rate
RATEOP Integer Rate Operator List:2 entries
1 = Multiply
2 = Divide
SWRATE Integer Rate Override Flag List:2 entries
0 = No
1 = Yes
DATECREATE Date Date Created
DATELSTEDT Date Date Last Edited
DETAILCNT Long Number of Details
APPLYMETH Integer Job Apply Method List:2 entries
0 = Prorate by Amount
1 = Top Down
VALUES Long Number of Optional Fields
SRCEAPPL String*2 Source Application Mask: %-2A
ERRBATCH Long Error Batch
ERRENTRY Long Error Entry
IDBANKCA String*8 Cash Bank Account Mask: %-8N
IDACCTCA String*45 Cash GL Account Mask: %-45C
CODECURNCA String*3 Cash Payment Currency Mask: %-3N
RATETYPECA String*2 Cash Rate Type Mask: %-2N
RATEDATECA Date Cash Rate Date
RATEEXCHCA BCD*8.7 Cash Exchange Rate
RATEOPCA Integer Cash Rate Operator List:2 entries
1 = Multiply
2 = Divide
SWRATECA Integer Cash Rate Override Flag List:2 entries
0 = No
1 = Yes
AMTPCCA BCD*10.3 Cash Amount (Payment)
AMTTCCA BCD*10.3 Cash Amount (Customer)
AMTHCCA BCD*10.3 Cash Amount (Functional)
IDBANKCK String*8 Check Bank Account Mask: %-8N
SWPRINT Integer Check Printing Required List:2 entries
0 = No
1 = Yes
SWPRINTED Integer Check Has Been Printed List:2 entries
0 = Not Printed
1 = Printed
CHECKNUM BCD*8.0 Check Number
LONGSERIAL ??? Check Serial Number
CODECURNCK String*3 Check Payment Currency Mask: %-3N
RATETYPECK String*2 Check Rate Type Mask: %-2N
RATEDATECK Date Check Rate Date
RATEEXCHCK BCD*8.7 Check Exchange Rate
RATEOPCK Integer Check Rate Operator List:2 entries
1 = Multiply
2 = Divide
SWRATECK Integer Check Rate Override Flag List:2 entries
0 = No
1 = Yes
AMTPCCK BCD*10.3 Check Amount (Payment)
AMTTCCK BCD*10.3 Check Amount (Customer)
AMTHCCK BCD*10.3 Check Amount (Functional)
NAMERMIT String*60 Remit-To Name
TEXTSTRE1 String*60 Address Line 1
TEXTSTRE2 String*60 Address Line 2
TEXTSTRE3 String*60 Address Line 3
TEXTSTRE4 String*60 Address Line 4
NAMECITY String*30 City
CODESTTE String*30 State/Prov.
CODEPSTL String*20 Zip/Postal Code
CODECTRY String*30 Country
CHECKLANG String*3 Check Language List:7 entries
1 = ENG
2 = FRA
3 = ESN
4 = AUS
5 = MEX
6 = CHN
7 = CHT
AMTTCCC BCD*10.3 C.C. Amount (Customer)
ENTEREDBY String*8 Entered By
DATEBUS Date Posting Date
CCSPSCNT Long Number of SPS C.C. Details
CCORIGID String*36 Original C.C. Transaction Number
CCPREVID String*36 Previous C.C. Transaction Number
CCPREVSTTS Integer Previous C.C. Process Status 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 String*36 Current C.C. Transaction Number
CCTRANSTTS Integer Current C.C. Process Status 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 String*12 Processing Code