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