Ac refund
|
Initial Build |
2006.02 |
|
Prefix |
ref |
|
Group Item |
Refund |
Overview
Refund
Columns
Accounting Tables
- ac_invoice
- ac_invoice_detail
- ac_batch
- ac_gl_account
- All Accounting Tables
| Name | Description | Datatype | Notes |
|---|---|---|---|
| ref_key | Primary Key | av_key | |
| ref_code | Refund Code | nvarchar(50) | |
| ref_bat_key | Refund Batch | av_key | |
| ref_cst_key | Customer | av_key | |
| ref_bat_close_flag | Batch Closed? | av_flag | |
| ref_post_flag | Posted Flag | av_flag | |
| ref_trx_date | Refund Date | av_date | |
| ref_check_number | Check Number | nvarchar(10) | |
| ref_check_date | Check Date | av_date | |
| ref_other_ref_number | Reference Number | nvarchar(20) | |
| ref_add_user | Add User | av_user | |
| ref_add_date | Add Date | av_date | |
| ref_change_user | Change User | av_user | |
| ref_change_date | Change Date | av_date | |
| ref_delete_flag | Delete Flag | av_delete_flag | |
| ref_entity_key | Entity Key | av_key | |
| ref_cur_key | Currency | av_key | Added in 2008.01 for Multi-Currency |
Parent Tables
| Parent Table | Parent Key | Child Key | Join |
|---|---|---|---|
| ac_batch | bat_key | ref_bat_key | ref_bat_key = bat_key |
| co_customer | cst_key | ref_cst_key | ref_cst_key = cst_key |
Child Tables
| Child Table | Parent Key | Child Key | Join |
|---|---|---|---|
| ac_refund_detail | ref_key | rfd_ref_key | rfd_ref_key = ref_key |