# Table: Refund Entries

Table: ARRFH
View: AR0141
Record length: 824
Flags: A R

## Keys: 3

Title | Flags | Fields
--- | --- | ---
Entry Number |  | CNTBTCH, CNTITEM
Customer Number | D M | IDCUST
Document Number | D M | IDINVC

## Fields: 66

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*5.0 | Check Number |
LONGSERIAL | Long | 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 |

This page was generated on 2008-May-01

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