Database Schema for

Data Dictionary -- AP - Statutory Extensions

Srl. No.	Table Name	Comment
1	apswht_cert_info_dtl	to store certificate information details
2	aps_mntax_inv_dtl	To store Information of Maintain Tax Invoice Detail
3	aps_othdoc_vw	to store other documents view
4	APS_Prt_Tax_Rpt_Hdr	To Store Information of Part Tax Report Header
5	APS_SBEA_Batchid_Table	To Store Information Of SBEA Batch id
6	aps_tax_inv_acct_info_dtl	to store infromation of tax investment account information details
7	aps_tax_inv_dtl	to store the information about tax investnebt details
8	aps_whtdoc_vw	aps_whtdoc_vw
9	APS_WHT_SupCategory_CerType_Met	to store informayion about sup category
10	Spy_Voucher_WHTSlip_Dtl	to store information of Supplier voucher with holding Slip detail
11	Spy_Voucher_WHT_Hdr	to store information of Supplier voucher with holding tax header
12	WHT_NumGen_Metadata	To store information of number generated Metadata


Table Name :	apswht_cert_info_dtl
Comment :	to store certificate information details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ouid	fin_ctxt_ouinstance	Int(4)	Yes	ouid	No
mode	fin_desc20	Varchar(20)	Yes	mode	No
suppliername	fin_txt255	Varchar(255)	Yes	suppliername	No
vouchertype	fin_desc20	Varchar(20)	Yes	vouchertype	No
voucherno	fin_desc40	Varchar(40)	Yes	voucherno	No
doctype	fin_desc20	Varchar(20)	Yes	doctype	No
docno	fin_desc40	Varchar(40)	Yes	docno	No
taxableamt	fin_amount	Numeric(13)	Yes	taxableamt	No
taxamt	fin_amount	Numeric(13)	Yes	taxamt	No
netpayment	fin_amount	Numeric(13)	Yes	netpayment	No
whtsupplier	fin_desc20	Varchar(20)	Yes	whtsupplier	No
whtsuppliername	fin_txt255	Varchar(255)	Yes	whtsuppliername	No
withhelddate	fin_date	Datetime(8)	Yes	withhelddate	No
whtcerttype	fin_desc20	Varchar(20)	Yes	whtcerttype	No
whtcertno	fin_desc20	Varchar(20)	Yes	whtcertno	No
tcdcode	fin_tcdcodes	Varchar(25)	Yes	tcdcode	No
tcdvarient	fin_tcdcodes	Varchar(25)	Yes	tcdvarient	No
remarkothers	fin_txt255	Varchar(255)	Yes	remarkothers	No
line_no	fin_ilistinf	Varchar(8000)	Yes	line_no	No
docline	fin_designparamcode	Varchar(5)	Yes	docline	No
remarks	fin_txt255	Varchar(255)	Yes	remarks	No
refno	fin_txt255	Varchar(255)	Yes	refno	No
whtsupplieraddr	fin_txt255	Varchar(255)	Yes	whtsupplieraddr	No
paymentdate	fin_date	Datetime(8)	Yes	paymentdate	No
paybatchno	fin_desc40	Varchar(40)	Yes	paybatchno	No
suppliercategory	fin_desc40	Varchar(40)	Yes	suppliercategory	No
whtpayerinfp	fin_desc20	Varchar(20)	Yes	whtpayerinfp	No
taxclass	fin_desc20	Varchar(20)	Yes	taxclass	No
taxcategory	fin_desc40	Varchar(40)	Yes	taxcategory	No
accountcode	fin_accountcode	Varchar(32)	Yes	accountcode	No
accountdesc	fin_desc40	Varchar(40)	Yes	accountdesc	No
registrationno	fin_desc40	Varchar(40)	Yes	registrationno	No
defaulttransoff	fin_desc40	Varchar(40)	Yes	defaulttransoff	No
whtstatus	fin_desc40	Varchar(40)	Yes	whtstatus	No
createdby	fin_desc40	Varchar(40)	Yes	createdby	No
createddate	fin_date	Datetime(8)	Yes	createddate	No
lastprintby	fin_desc40	Varchar(40)	Yes	lastprintby	No
lastprintdate	fin_date	Datetime(8)	Yes	lastprintdate	No
taxincidence	fin_desc40	Varchar(40)	Yes	taxincidence	No
whtcreatedby	fin_desc40	Varchar(40)	Yes	whtcreatedby	No
whtcreateddate	fin_date	Datetime(8)	Yes	whtcreateddate	No
whtmodifiedby	fin_desc40	Varchar(40)	Yes	whtmodifiedby	No
whtmodifieddate	fin_date	Datetime(8)	Yes	whtmodifieddate	No
lineid	fin_int	Int(4)	No	lineid	Yes
Groupby	fin_type	Varchar(25)	No	Groupby	No
bckupdatekey	fin_int	Int(4)	No	bckupdatekey	No
lineflag	fin_flag	Varchar(25)	No	lineflag	No
certificate_key	fin_rowno	Int(4)	No	certificate_key	No
docdate	fin_date	Datetime(8)	No	docdate	No


Table Name :	aps_mntax_inv_dtl
Comment :	To store Information of Maintain Tax Invoice Detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MTI_Ou_id	udd_ctxt_ouinstance	int(4)	No	MaintainTax Invoice OU Id	Yes
MTI_Credit_Doc_No	udd_documentno	varchar(40)	No	maintainTax Invoice Credit Document Number	Yes
MTI_Pay_Voucher	fin_documentno	varchar(40)	Yes	Maintain Tax Invoice Pay Voucher	No
MTI_Tax_Inv_No	udd_documentno	varchar(40)	Yes	Maintain Tax Invoice Number	No
MTI_Tax_Inv_Date	udd_datetime1	datetime(8)	Yes	Maintain Ta Invoice Date	No
jn_voucher_no	fin_documentno	varchar(40)	Yes	Journal Voucher Number	No


Table Name :	aps_othdoc_vw
Comment :	to store other documents view


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_companycode	fin_companycode	Varchar(10)	No	tran_companycode	No
tran_ou	fin_ouinstid	Int(4)	No	tran_ou	No
tran_fb_id	fin_financebookid	Varchar(20)	Yes	tran_fb_id	No
tran_type	fin_vouchertype	Varchar(20)	Yes	tran_type	No
tran_no	fin_documentnumber	Varchar(18)	No	tran_no	No
tran_date	datetime	Datetime(8)	Yes	tran_date	No
tran_line_no	fin_int	Int(4)	No	tran_line_no	No
tran_tax_type	int	Int(4)	Yes	tran_tax_type	No
tran_itmtcdcode	int	Int(4)	Yes	tran_itmtcdcode	No
tran_itmtcdvar	int	Int(4)	Yes	tran_itmtcdvar	No
tran_tcdcurr	fin_currencycode	Varchar(5)	Yes	tran_tcdcurr	No
tran_tcdamt	numeric	Numeric(17)	Yes	tran_tcdamt	No
tran_inv_base_amt	numeric	Numeric(17)	Yes	tran_inv_base_amt	No
tran_tcd_base_amt	numeric	Numeric(17)	Yes	tran_tcd_base_amt	No
tran_taxable_tran_amt	int	Int(4)	Yes	tran_taxable_tran_amt	No
tran_taxable_base_amt	int	Int(4)	Yes	tran_taxable_base_amt	No
tran_tax_incidence	udd_taxinci	Varchar(40)	No	tran_tax_incidence	No
tran_tax_nature	udd_taxnat	Varchar(25)	No	tran_tax_nature	No
tran_exchrate_type	int	Int(4)	Yes	tran_exchrate_type	No
tran_amount	numeric	Numeric(17)	Yes	tran_amount	No
tran_exchange_rate	fin_amount	Numeric(13)	Yes	tran_exchange_rate	No
taxattr_erate_type	int	Int(4)	Yes	taxattr_erate_type	No
taxattr_acct_event	fin_quickcodes	Varchar(25)	Yes	taxattr_acct_event	No
taxattr_exchrate_ref	int	Int(4)	Yes	taxattr_exchrate_ref	No
taxattr_prov_acct_flag	int	Int(4)	Yes	taxattr_prov_acct_flag	No
tran_currency	fin_currencycode	Varchar(5)	Yes	tran_currency	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
taxattr_tax_category	int	Int(4)	Yes	taxattr_tax_category	No
taxattr_tax_class	int	Int(4)	Yes	taxattr_tax_class	No
taxinvoiced	fin_flag	Varchar(25)	No	taxinvoiced	No
account_code	fin_accountcode	Varchar(32)	Yes	account_code	No
supplier_id	fin_vendorcode	Varchar(45)	Yes	supplier_id	No
remarks	fin_text255	Varchar(255)	Yes	remarks	No


Table Name :	APS_Prt_Tax_Rpt_Hdr
Comment :	To Store Information of Part Tax Report Header


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PTR_Ou_id	udd_ctxt_ouinstance	int(4)	No	Part Ou Id	Yes
PTR_Tax_Rpt_Run	udd_documentno	varchar(40)	No	Part Tax Report Run	Yes
PTR_Status	udd_docstatus	varchar(15)	Yes	Part Status	No
PTR_Fin_Year	udd_financeyearrange	varchar(40)	Yes	Part Finance year	No
PTR_Fin_Period	udd_financeperiodrange	varchar(40)	Yes	Part Finance Period	No
PTR_Tax_Type	udd_quickcode	varchar(25)	Yes	Part Tax type	No
PTR_Report_Type	udd_quickcode	varchar(25)	Yes	Part report type	No
PTR_Period_Stdt	udd_datetime1	datetime(8)	Yes	Part Period Start Date	No
PTR_Period_Enddt	udd_datetime1	datetime(8)	Yes	Part Period End Date	No


Table Name :	APS_SBEA_Batchid_Table
Comment :	To Store Information Of SBEA Batch id


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
Run_No	udd_documentno	varchar(40)	Yes	Run number	No
Batch_Id	udd_documentno	varchar(40)	Yes	Batch id	No
Guid	udd_guid	varchar(40)	Yes	Guid	No
Batch_Status	udd_flag	varchar(25)	Yes	Batch Status	No


Table Name :	aps_tax_inv_acct_info_dtl
Comment :	to store infromation of tax investment account information details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	Int(4)	Yes	ou_id	No
taxinv_id	fin_int	Int(4)	Yes	taxinv_id	No
posting_line_no	fin_lineno	Int(4)	Yes	posting_line_no	No
voucher_no	fin_documentno	varchar(40)	Yes	voucher_no	No
voucher_type	fin_type	Varchar(25)	Yes	voucher_type	No
voucher_date	fin_date	Datetime(8)	No	voucher_date	No
ref_doc_no	fin_documentno	varchar(40)	Yes	ref_doc_no	No
ref_doc_type	fin_type	Varchar(25)	Yes	ref_doc_type	No
ref_doc_ou	fin_ouinstid	Int(4)	Yes	ref_doc_ou	No
account_code	fin_accountcode	Varchar(32)	Yes	account_code	No
drcr_flag	fin_drcridentifier	Varchar(6)	Yes	drcr_flag	No
account_type	fin_accounttype	Varchar(15)	Yes	account_type	No
fin_post_date	fin_date	Datetime(8)	Yes	fin_post_date	No
tran_currency	fin_currency	Varchar(5)	Yes	tran_currency	No
tran_amount	fin_amount	Numeric(13)	Yes	tran_amount	No
exchange_rate	fin_exchangerate	Numeric(9)	Yes	exchange_rate	No
base_amount	fin_amount	Numeric(13)	Yes	base_amount	No
pbcur_erate	fin_exchangerate	Numeric(9)	Yes	pbcur_erate	No
par_base_amount	fin_amount	Numeric(13)	Yes	par_base_amount	No
fb_id	fin_buid	Varchar(20)	Yes	fb_id	No
costcenter_code	fin_costcentercode	Varchar(10)	Yes	costcenter_code	No
analysis_code	fin_analysiscode	Varchar(5)	Yes	analysis_code	No
subanal_code	fin_subanalysiscode	Varchar(5)	Yes	subanal_code	No
timestamp	fin_int	Int(4)	Yes	timestamp	No
created_by	fin_ctxt_user	Varchar(30)	Yes	created_by	No
created_date	fin_date	Datetime(8)	Yes	created_date	No
modified_by	fin_ctxt_user	Varchar(30)	Yes	modified_by	No
modified_date	fin_date	Datetime(8)	Yes	modified_date	No
replication_key	uniqueidentifier	Varchar(160)	No	replication_key	No


Table Name :	aps_tax_inv_dtl
Comment :	to store the information about tax investnebt details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MnTax_lineid	fin_int	Int(4)	No	MnTax_lineid	Yes
MnTax_OuId	fin_ouinstid	Int(4)	Yes	MnTax_OuId	No
MnTax_Mode	fin_mode	Varchar(15)	Yes	MnTax_Mode	No
MnTax_FinanceBook	fin_financebook	Varchar(40)	Yes	MnTax_FinanceBook	No
MnTax_Suppname	fin_supplier	Varchar(160)	Yes	MnTax_Suppname	No
MnTax_SuppDocNo	fin_documentno	varchar(40)	Yes	MnTax_SuppDocNo	No
MnTax_CrDocType	fin_doctype	Varchar(40)	Yes	MnTax_CrDocType	No
MnTax_CrDocNo	fin_documentno	varchar(40)	Yes	MnTax_CrDocNo	No
MnTax_LineChk	fin_flag	Varchar(25)	Yes	MnTax_LineChk	No
MnTax_CrDocLineno	fin_lineno	Int(4)	Yes	MnTax_CrDocLineno	No
MnTax_Taxable_Amt_basecurr	fin_amount	Numeric(13)	Yes	MnTax_Taxable_Amt_basecurr	No
MnTax_Tax_Amt_basecurr	fin_amount	Numeric(13)	Yes	MnTax_Tax_Amt_basecurr	No
MnTax_TaxInvno	fin_documentno	varchar(40)	Yes	MnTax_TaxInvno	No
MnTax_TaxInvDate	fin_date	Datetime(8)	Yes	MnTax_TaxInvDate	No
MnTax_TaxInvSuppCode	fin_suppliercode	Varchar(16)	Yes	MnTax_TaxInvSuppCode	No
MnTax_TaxInvSuppName	fin_suppliername	Varchar(40)	Yes	MnTax_TaxInvSuppName	No
MnTax_JVRemarks	fin_txt255	Varchar(255)	Yes	MnTax_JVRemarks	No
MnTax_Ref_no	fin_documentno	varchar(40)	Yes	MnTax_Ref_no	No
MnTax_Remarks	fin_txt255	Varchar(255)	Yes	MnTax_Remarks	No
MnTax_CrDocCurr	fin_currencycode	Varchar(5)	Yes	MnTax_CrDocCurr	No
MnTax_CrDocAmt	fin_amount	Numeric(13)	Yes	MnTax_CrDocAmt	No
MnTax_CostCenter	fin_workcenter	Varchar(80)	Yes	MnTax_CostCenter	No
MnTax_Analysiscode	fin_analysiscode	Varchar(5)	Yes	MnTax_Analysiscode	No
MnTax_Subanalysiscode	fin_subanalysiscode	Varchar(5)	Yes	MnTax_Subanalysiscode	No
MnTax_Expclass	fin_classification	Varchar(20)	Yes	MnTax_Expclass	No
MnTax_TCDcode	fin_itemcode	Varchar(40)	Yes	MnTax_TCDcode	No
MnTax_TCDvariant	fin_itemcode	Varchar(40)	Yes	MnTax_TCDvariant	No
MnTax_TaxCurr	fin_currencycode	Varchar(5)	Yes	MnTax_TaxCurr	No
Mntax_TaxIncidence	fin_itemcode	Varchar(40)	Yes	Mntax_TaxIncidence	No
MnTax_Taxclass	fin_classification	Varchar(20)	Yes	MnTax_Taxclass	No
MnTax_TaxCategory	fin_category	Varchar(15)	Yes	MnTax_TaxCategory	No
MnTax_AcctCode	fin_accountcode	Varchar(32)	Yes	MnTax_AcctCode	No
MnTax_AcctDesc	fin_accountdesc	Varchar(60)	Yes	MnTax_AcctDesc	No
MnTax_AcctStatus	fin_status	Varchar(25)	Yes	MnTax_AcctStatus	No
MnTax_PayDate	fin_date	Datetime(8)	Yes	MnTax_PayDate	No
MnTax_PayVoucherno	fin_documentno	varchar(40)	Yes	MnTax_PayVoucherno	No
MnTax_JVpostDate	fin_date	Datetime(8)	Yes	MnTax_JVpostDate	No
MnTax_PostDocType	fin_desc120	Varchar(120)	Yes	MnTax_PostDocType	No
MnTax_PostDocno	fin_documentno	varchar(40)	Yes	MnTax_PostDocno	No
MnTax_PostDocDt	fin_date	Datetime(8)	Yes	MnTax_PostDocDt	No
MnTax_Regno	fin_documentno	varchar(40)	Yes	MnTax_Regno	No
MnTax_Address_cat	fin_category	Varchar(15)	Yes	MnTax_Address_cat	No
MnTax_Spec2000code	fin_txt20	Varchar(20)	Yes	MnTax_Spec2000code	No
MnTax_hdntrantype	fin_doctype	Varchar(40)	Yes	MnTax_hdntrantype	No
MnTax_Flag	fin_flag	Varchar(25)	Yes	MnTax_Flag	No
MnTax_backupdate_key	fin_flag	Varchar(25)	Yes	MnTax_backupdate_key	No


Table Name :	aps_whtdoc_vw
Comment :	aps_whtdoc_vw


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_companycode	fin_companycode	Varchar(10)	No	tran_companycode	No
tran_ou	fin_ouinstid	Int(4)	No	tran_ou	No
tran_fb_id	fin_financebookid	Varchar(20)	Yes	tran_fb_id	No
tran_type	fin_vouchertype	Varchar(20)	Yes	tran_type	No
tran_no	fin_documentnumber	Varchar(18)	No	tran_no	No
tran_date	datetime	Datetime(8)	Yes	tran_date	No
tran_line_no	fin_int	Int(4)	No	tran_line_no	No
tran_tax_type	int	Int(4)	Yes	tran_tax_type	No
tran_itmtcdcode	int	Int(4)	Yes	tran_itmtcdcode	No
tran_itmtcdvar	int	Int(4)	Yes	tran_itmtcdvar	No
tran_tcdcurr	fin_currencycode	Varchar(5)	Yes	tran_tcdcurr	No
tran_tcdamt	numeric	Numeric(17)	Yes	tran_tcdamt	No
tran_inv_base_amt	numeric	Numeric(17)	Yes	tran_inv_base_amt	No
tran_tcd_base_amt	numeric	Numeric(17)	Yes	tran_tcd_base_amt	No
tran_taxable_tran_amt	int	Int(4)	Yes	tran_taxable_tran_amt	No
tran_taxable_base_amt	int	Int(4)	Yes	tran_taxable_base_amt	No
tran_tax_incidence	udd_taxinci	Varchar(40)	No	tran_tax_incidence	No
tran_tax_nature	udd_taxnat	Varchar(25)	No	tran_tax_nature	No
tran_exchrate_type	int	Int(4)	Yes	tran_exchrate_type	No
Tran_amount	numeric	Numeric(17)	Yes	Tran_amount	No
tran_exchange_rate	fin_amount	Numeric(13)	Yes	tran_exchange_rate	No
taxattr_erate_type	int	Int(4)	Yes	taxattr_erate_type	No
taxattr_acct_event	fin_quickcodes	Varchar(25)	Yes	taxattr_acct_event	No
taxattr_exchrate_ref	int	Int(4)	Yes	taxattr_exchrate_ref	No
taxattr_prov_acct_flag	int	Int(4)	Yes	taxattr_prov_acct_flag	No
tran_currency	fin_currencycode	Varchar(5)	Yes	tran_currency	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
taxattr_tax_category	int	Int(4)	Yes	taxattr_tax_category	No
taxattr_tax_class	int	Int(4)	Yes	taxattr_tax_class	No
taxinvoiced	fin_flag	Varchar(25)	No	taxinvoiced	No
account_code	fin_accountcode	Varchar(32)	Yes	account_code	No
supplier_Id	fin_vendorcode	Varchar(45)	Yes	supplier_Id	No
remarks	fin_text255	Varchar(255)	Yes	remarks	No
wht_tax_certified	fin_flag	Varchar(25)	No	wht_tax_certified	No


Table Name :	APS_WHT_SupCategory_CerType_Met
Comment :	to store informayion about sup category


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
OU_ID	udd_ouinstid	int(4)	Yes	OU_ID	No
WHT_lineid	fin_int	Int(4)	No	WHT_lineid	Yes
WHT_Supp_Cat	fin_flag	Varchar(25)	Yes	WHT_Supp_Cat	No
WHT_Cert_Type	fin_desc20	Varchar(20)	Yes	WHT_Cert_Type	No


Table Name :	Spy_Voucher_WHTSlip_Dtl
Comment :	to store information of Supplier voucher with holding Slip detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	udd_ouinstid	int(4)	No	OU Id	Yes
WHT_SlipNo	udd_document	varchar(20)	No	With holding tax slip number	Yes
TCDno	udd_itemcode	varchar(32)	No	TCD Number	Yes
TCDVar	udd_itemcode	varchar(32)	No	TCD Variance	Yes
TaxClass	udd_taxclass	varchar(20)	Yes	Tax Class	No
Remarks	udd_txt255	varchar(255)	Yes	Remarks	No
TaxableAmt	udd_amount	numeric(13)	Yes	Taxable Amount	No
TaxAmt	udd_amount	numeric(13)	Yes	Tax Amount	No
Created_by	udd_ctxt_user	varchar(30)	Yes	Created By	No
Created_date	udd_datetime1	datetime(8)	Yes	Created Date	No
Lastmodified_by	udd_ctxt_user	varchar(30)	Yes	Last Modified By	No
Lastmodified_date	udd_datetime1	datetime(8)	Yes	Last Modified Date	No


Table Name :	Spy_Voucher_WHT_Hdr
Comment :	to store information of Supplier voucher with holding tax header


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	udd_ouinstid	int(4)	No	Ou ID	Yes
paybatch_no	udd_documentnumber	varchar(18)	Yes	Paybatch number	No
Voucher_no	udd_documentnumber	varchar(18)	Yes	Voucher Number	No
PaymentDate	udd_datetime1	datetime(8)	Yes	Payment date	No
Supplier_No	udd_vendorcode	varchar(45)	Yes	Supplier number	No
WHT_SlipType	udd_companycode	varchar(10)	Yes	With Holding Tax SlipType	No
WHT_SlipNo	udd_document	varchar(20)	No	With Holding Tax SlipNumber	Yes
WHT_Status	udd_job	varchar(35)	Yes	With Holding Tax Status	No


Table Name :	WHT_NumGen_Metadata
Comment :	To store information of number generated Metadata


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WHT_Ou	udd_ctxt_ouinstance	int(4)	Yes	With Holdin Tax OU	No
WHT_Type	udd_type	varchar(25)	Yes	With Holdin Tax Type	No
WHT_No	udd_count	int(4)	Yes	With Holdin Tax Number	No
WHT_Format	udd_dateformat	varchar(15)	Yes	With Holdin Tax Format	No
WHT_Period_Code	fin_desc20	Varchar(20)	Yes	With Holdin Period Code	No