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 |