Table: Refund Details

Table: ARRFD
View: AR0142
Record length: 270
Flags: A R 

Keys: 2

Title  Flags  Fields

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

Fields: 29

Field  Type  Title  Presentation 

CNTBTCH  BCD*5.0  Batch Number   
CNTITEM  BCD*4.0  Entry Number   
CNTLINE  BCD*3.0  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
IDINVC  String*22  Document Number  Mask: %-22C
CNTPAYM  BCD*3.0  Payment Number   
PAYMTYPE  Integer  Payment Type  List: 3 entries
1=Cash
2=Check
3=Credit Card
IDBANK  String*8  C.C. Bank Account  Mask: %-8N
LONGSERIAL  Long  C.C. Bank Serial Number   
CODECURN  String*3  C.C. Payment Currency  Mask: %-3N
RATETYPE  String*2  C.C. Rate Type  Mask: %-2N
RATEDATE  Date  C.C. Rate Date   
RATEEXCH  BCD*8.7  C.C. Exchange Rate   
RATEOP  Integer  C.C. Rate Operator  List: 2 entries
1=Multiply
2=Divide
SWRATE  Integer  C.C. Rate Override Flag  List: 2 entries
0=No
1=Yes
CCTYPE  String*12  Credit Card Type  Mask: %-12N
CCNUMBER  Binary*32  Credit Card Number   
CCNAME  String*60  Credit Card Name   
CCEXP  Date  Expiry Date (mm/yy)   
CCAUTHCODE  String*20  Authorization Code   
AMTPC  BCD*10.3  Amount (Payment)   
AMTTC  BCD*10.3  Amount (Customer)   
AMTHC  BCD*10.3  Amount (Functional)   
SWJOB  Integer  Job Related  List: 2 entries
0=No
1=Yes
APPLYMETH  Integer  Job Apply Method  List: 2 entries
0=Prorate by Amount
1=Top Down
AMTJOB  BCD*10.3  Job Applied Amount   

This page was generated on 2008-May-01

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