Data Dictionary -- Supplier Balance Adjustment

Srl. No.	Table Name	Comment
1	sad_acct_info_dtl	Supplier balance adjustment accounting information detail table
2	sad_adjvoucher_hdr	Supplier balance adjustment voucher header table
3	sad_adjv_crdoc_dtl	Supplier balance adjustment credit document information detail table
4	sad_adjv_crdoc_ref	Supplier balance adjustment credit document reference detail table
5	sad_adjv_drdoc_dtl	Supplier balance adjustment debit document information detail table
6	sad_adjv_drdoc_ref	Supplier balance adjustment debit document reference detail table
7	sad_attach_notes	Supplier balance adjustment notes detail table

Table Name :	sad_acct_info_dtl
Comment :	Supplier balance adjustment accounting information detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
tran_no	fin_documentno	varchar(40)	No	Trasaction number	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
drcr_flag	fin_drcridentifier	varchar(6)	No	Debit credit flag	Yes
acct_line_no	fin_lineno	int(4)	No	Account line no	Yes
fin_post_date	datetime	Datetime(8)	Yes	Finance post date	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
basecur_erate	fin_amount	numeric(13)	Yes	Base currency exchange rate	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
pbcur_erate	fin_amount	numeric(13)	Yes	Parallel base currency exchange rate	No
par_base_amt	fin_amount	numeric(13)	Yes	Parallel currency base amount	No
fin_post_status	fin_status	varchar(25)	Yes	Finance post status	No
transaction_date	datetime	Datetime(8)	Yes	Transaction date	No
account_type	fin_accounttype	varchar(15)	Yes	Account type	No
guid	fin_guid	varchar(40)	Yes	guid	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
ref_doc_no	fin_documentno	varchar(40)	Yes	Reference document number	No
ref_tran_type	fin_transactiontype	varchar(40)	Yes	Reference transaction type	No

Table Name :	sad_adjvoucher_hdr
Comment :	Supplier balance adjustment voucher header table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
adj_voucher_no	fin_documentno	varchar(40)	No	Adjusted Voucher number	Yes
timestamp	int	int(4)	Yes	Timestamp	No
voucher_date	datetime	Datetime(8)	Yes	Voucher date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
voucher_amount	fin_amount	numeric(13)	Yes	Voucher amount	No
status	fin_status	varchar(25)	Yes	Status	No
supp_code	fin_suppliercode	varchar(16)	Yes	Supp code	No
adjust_seq	fin_docadjseqen	varchar(12)	Yes	Adjusted sequence	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
voucher_type	fin_vouchertype	varchar(20)	Yes	Voucher type	No
rev_voucher_no	fin_documentno	varchar(40)	Yes	Rev voucher no	No
reversal_date	datetime	Datetime(8)	Yes	Reversal date	No
notype_no	fin_notypeno	varchar(10)	Yes	notype_no	No
reason_code	fin_quickcodes	varchar(25)	Yes	Reason code	No
remarks	fin_comments	varchar(256)	Yes	Remarks	No
currentkey	fin_guid	varchar(40)	Yes	Current key	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	datetime	Datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	datetime	Datetime(8)	Yes	Modified date	No
voucher_tran_type	fin_transactiontype	varchar(40)	Yes	Voucher transaction type	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No

Table Name :	sad_adjv_crdoc_dtl
Comment :	Supplier balance adjustment credit document information detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
adj_voucher_no	fin_documentno	varchar(40)	No	Adj voucher number	Yes
cr_doc_ou	fin_ouinstid	int(4)	No	Credit document OU	Yes
cr_doc_no	fin_documentno	varchar(40)	No	Credit document number	Yes
term_no	fin_termnumber	varchar(20)	No	Term number	Yes
cr_doc_type	fin_transactiontype	varchar(40)	No	Credit document type	Yes
cr_doc_adj_amt	fin_amount	numeric(13)	Yes	Credit document adj amount	No
discount	fin_amount	numeric(13)	Yes	Discount	No
proposed_discount	fin_amount	numeric(13)	Yes	Proposed discount	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
au_pur_ord_ref	fin_documentno	varchar(40)	Yes	Author Purchase Order Reference	No
au_cr_doc_unadj_amt	fin_amount	numeric(13)	Yes	Author credit document unadjusted amount	No
au_cr_doc_cur	fin_currencycode	varchar(5)	Yes	Author credit document currency	No
au_crosscur_erate	fin_amount	numeric(13)	Yes	Author Cross Currency Exchange Rate	No
au_discount_date	datetime	Datetime(8)	Yes	Author Discount Date	No
au_cr_doc_date	datetime	Datetime(8)	Yes	Author credit document date	No
au_fb_id	fin_financebookid	varchar(20)	Yes	Author finance book id	No
parent_key	fin_guid	varchar(40)	Yes	Parent key	No
current_key	fin_guid	varchar(40)	Yes	Current key	No
au_disc_available	fin_amount	numeric(13)	Yes	Author Discount Available	No
au_due_date	datetime	Datetime(8)	Yes	Author Due Date	No
au_billing_point	fin_ouinstid	int(4)	Yes	Author billing point	No
vat_amount	fin_amount	numeric(13)	Yes	VAT amount	No
vat_rate	fin_amount	numeric(13)	Yes	VAT rate	No
tran_type	fin_documenttype	varchar(40)	Yes	Transaction type	No
au_sale_ord_ref	fin_documentno	varchar(40)	Yes	Author Sale Order Reference	No
voucher_tran_type	fin_transactiontype	varchar(40)	Yes	Voucher transaction type	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No

Table Name :	sad_adjv_crdoc_ref
Comment :	Supplier balance adjustment credit document reference detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
parent_key	fin_guid	varchar(40)	No	Parent key	Yes
ref_cr_doc_no	fin_documentno	varchar(40)	No	Reference credit document number	Yes
cr_doc_ou	fin_ouinstid	int(4)	No	Credit document OU	Yes
cr_doc_type	fin_documenttype	varchar(40)	No	Credit document type	Yes
term_no	fin_termnumber	varchar(20)	No	Term number	Yes
sale_ord_ref	fin_documentno	varchar(40)	Yes	Sale order reference	No
cr_doc_adj_amt	fin_amount	numeric(13)	Yes	Credit doc adj amount	No
au_cr_doc_unadj_amt	fin_amount	numeric(13)	Yes	Author Credit doc unadj amount	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
cr_discount	fin_amount	numeric(13)	Yes	Credit discount	No
cross_cur_erate	fin_amount	numeric(13)	Yes	Cross currency exchange rate	No

Table Name :	sad_adjv_drdoc_dtl
Comment :	Supplier balance adjustment debit document information detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
adj_voucher_no	fin_documentno	varchar(40)	No	Adj voucher number	Yes
dr_doc_ou	fin_ouinstid	int(4)	No	Debit document OU	Yes
dr_doc_type	fin_transactiontype	varchar(40)	No	Debit document type	Yes
dr_doc_no	fin_documentno	varchar(40)	No	Debit document number	Yes
term_no	fin_termnumber	varchar(20)	No	Term number	Yes
dr_doc_adj_amt	fin_amount	numeric(13)	Yes	Debit document adj amount	No
au_dr_doc_unadj_amt	fin_amount	numeric(13)	Yes	Author debit document unadjusted amount	No
au_dr_doc_amount	fin_amount	numeric(13)	Yes	Author debit document amount	No
au_dr_doc_date	datetime	Datetime(8)	Yes	Author debit document date	No
au_dr_doc_cur	fin_currencycode	varchar(5)	Yes	Author debit document currency	No
au_fb_id	fin_financebookid	varchar(20)	Yes	Author finance book id	No
parent_key	fin_guid	varchar(40)	Yes	Parent key	No
current_key	fin_guid	varchar(40)	Yes	Current key	No
timestamp	fin_number	int(4)	Yes	Timestamp	No
au_billing_point	fin_ouinstid	int(4)	Yes	Author billing point	No
tran_type	fin_documenttype	varchar(40)	Yes	Transaction type	No
voucher_tran_type	fin_transactiontype	varchar(40)	Yes	Voucher transaction type	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No

Table Name :	sad_adjv_drdoc_ref
Comment :	Supplier balance adjustment debit document reference detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
parent_key	fin_guid	varchar(40)	No	Parent key	Yes
ref_dr_doc_no	fin_documentno	varchar(40)	No	Reference debit document number	Yes
dr_doc_ou	fin_ouinstid	int(4)	No	Debit document OU	Yes
dr_doc_type	fin_documenttype	varchar(40)	No	Debit document type	Yes
term_no	fin_termnumber	varchar(20)	No	Term number	Yes
dr_doc_adj_amt	fin_amount	numeric(13)	Yes	Debit document adj amount	No
dr_doc_unadj_amt	fin_amount	numeric(13)	Yes	Debit document unadjusted amount	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
discount	fin_amount	numeric(13)	Yes	Discount	No

Table Name :	sad_attach_notes
Comment :	Supplier balance adjustment notes detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
adj_voucher_no	fin_docuemntno	varchar(18)	No	Adjustment voucher number	Yes
adj_ouid	fin_ouinstid	int(4)	No	Adjustment ou id	Yes
ref_doc_no	fin_docuemntno	varchar(18)	Yes	Reference document number	No
ref_doc_ou	fin_ouinstid	int(4)	No	Reference document OU	Yes
notes	fin_notes	varchar(2000)	Yes	Notes	No
notes_level	fin_notes_level	varchar(10)	Yes	Notes level	No
notes_for	fin_notesfor	varchar(30)	Yes	Notes for	No
std_notes_id	fin_docuemntno	varchar(18)	Yes	Std Notes ID	No
std_notes_desc	fin_description	varchar(100)	Yes	Std Notes description	No
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes