ARPB_TX_REFUND

Description: |
This table contains information specific for a refund adjustment, such as refund address information entered on the Refund Request Slip form, and information related to export and import to/from the AP system. Use this table in conjunction with ARPB_TX_REFUND_ADD to display the full address entered on the Refund Request Slip form.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TX_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
Payment transaction (ETR) ID that was refunded.
2 | REFUND_ADDR_NAME | VARCHAR | No |
This column contains the name for the refund address entered on the Refund Request Slip form.
3 | REFUND_ADDR_CITY | VARCHAR | No |
This column contains the city for the refund address entered on the Refund Request Slip form.
4 | REFUND_ADDR_STATE_C_NAME | VARCHAR | No |
This column contains the state for the refund address entered on the Refund Request Slip form.
May contain organization-specific values: Yes
5 | REFUND_ADDR_ZIP | VARCHAR | No |
This column contains the zip code for the refund address entered on the Refund Request Slip form.
6 | REFUND_ADDR_CUST_C_NAME | VARCHAR | No |
This column contains the custom payee used to override the refund address entered on the Refund Request Slip form.
May contain organization-specific values: Yes
No Entries Defined
7 | REFUND_ADDR_PLN_ID_BENEFIT_PLAN_NAME | VARCHAR | No |
The name of the benefit plan record.
8 | REFUND_ADDR_PYR_ID_PAYOR_NAME | VARCHAR | No |
The name of the payor.
9 | REFUND_ADDR_CVG_ID | NUMERIC | No |
This column contains the coverage used to override the refund address entered on the Refund Request Slip form.
10 | REFUND_AP_EXPORT_DT | DATETIME | No |
Date when the refund adjustment was exported to the Accounts Payable (AP) system
11 | REFUND_AP_IMPORT_DT | DATETIME | No |
Date when information was imported from Accounts Payable (AP) system to confirm a refund
12 | REFUND_CHECK_NUM | VARCHAR | No |
Check number for AP check produced as result of refund adjustment.
13 | REFUND_CHECK_AMT | NUMERIC | No |
Check amount for AP check produced as result of refund adjustment.
14 | REFUND_CHECK_DT | DATETIME | No |
Check date for AP check produced as result of refund adjustment.
15 | REFUND_COMMENT | VARCHAR | No |
Contains free text comment, with information related to a refund, imported from the Accounts Payable (AP) system
16 | REFUND_ACC_USR_ID | VARCHAR | No |
This column contains the user that accepted the Refund Request Slip form.
17 | REFUND_ACC_USR_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
18 | REFUND_ADDR_EMP_ID | VARCHAR | No |
This column contains the user that overrode the refund address entered on the Refund Request Slip form.
19 | REFUND_ADDR_EMP_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
20 | REFUND_ADDR_CNTY_C_NAME | VARCHAR | No |
The refund address county category ID for the transaction.
May contain organization-specific values: Yes
21 | REFUND_ADDR_CNTRY_C_NAME | VARCHAR | No |
The refund address country category ID for the transaction.
May contain organization-specific values: Yes
22 | REFUND_ADDR_HNUM | VARCHAR | No |
Refund address house number
23 | REFUND_ADDR_DIST_C_NAME | VARCHAR | No |
The refund address district category ID for the transaction.
May contain organization-specific values: Yes
24 | REFUND_FORCED_YN | VARCHAR | No |
If set to yes, this item indicates that the refund has been force posted or rejected (despite not having received import information from the AP system). This is only for use when refunds are held pending AP import.
May contain organization-specific values: No
Category Entries:
No
Yes
25 | REFUND_ADDR_CUST_PAYEE_ID | VARCHAR | No |
Stores the ID of the custom payee to send the refund to.
26 | REFUND_ADDR_CUST_PAYEE_ID_AGENCY_NAME | VARCHAR | No |
The name of the agency.