Data Dictionary -- Sundry Receipt

Srl. No.	Table Name	Comment
1	sur_fbpostings_dtl	Stores the Details about fbpostings
2	sur_notes_dtl	Stores the Detail about notes
3	sur_receipt_dtl	Stores the Details about Receipt
4	sur_receipt_hdr	Stores the Information of Header Receipt
5	sur_vataccount_dtl	Stores the Detail of VATaccount
6	sur_vatitem_dtl	Stores the Detail of VATitem

Table Name :	sur_fbpostings_dtl
Comment :	Stores the Details about fbpostings

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
tran_type	fin_transactiontypeid	varchar(10)	No	Transaction type	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
tran_no	fin_transactionnumber	varchar(18)	No	Transaction number	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
drcr_flag	fin_cmbflag	varchar(4)	No	Debit credit flag	Yes
acct_lineno	fin_lineno	int(4)	No	Accountline number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
acct_type	fin_accounttype	varchar(15)	Yes	Account type	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
declnyr_code	fin_calendarcode	varchar(10)	Yes	decl year code	No
declnprd_code	fin_financeperiod	varchar(15)	Yes	decl period code	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
tran_qty	fin_quantity	numeric(17)	Yes	Transaction quantity	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	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
bank_code	fin_bankid	varchar(20)	Yes	Bank code	No
ref_doc_no	fin_transactionnumber	varchar(18)	Yes	Reference document number	No
vendor_code	fin_vendorcode	varchar(45)	Yes	Vendor code	No
origin_ou	fin_ouinstid	int(4)	Yes	Origin OU	No
item_code	fin_itemcode	varchar(40)	Yes	Item code	No
vrnt_code	fin_variant	varchar(8)	Yes	Variant code	No
uom	fin_uomcode	varchar(10)	Yes	UOM	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
ref_tran_type	fin_transactiontype	varchar(40)	Yes	Reference transaction type	No
ref_fbid	fin_financebookid	varchar(20)	Yes	Reference finance book id	No
auth_date	fin_datetime	datetime(8)	Yes	Author date	No
post_date	fin_datetime	datetime(8)	Yes	Post date	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
component_name	fin_component	varchar(16)	Yes	Componetn name	No
vat_category	fin_vatcategory	varchar(40)	Yes	Vat category	No
vat_class	fin_vatclass	varchar(40)	Yes	Vat class	No
vat_code	fin_vatclass	varchar(40)	Yes	Vat code	No
vat_rate	fin_rate	numeric(13)	Yes	Vat rate	No
vat_inclusive	fin_cmbflag	varchar(4)	Yes	Vat inclusive	No
flag	fin_cmbflag	varchar(4)	Yes	Flag	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
receipt_type	fin_paramcode	varchar(30)	Yes	Receipt type	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
vat_line_no	fin_lineno	int(4)	Yes	Vat line number	No
doc_line_no	fin_lineno	int(4)	Yes	Document line number	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No

Table Name :	sur_notes_dtl
Comment :	Stores the Detail about notes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
receipt_no	fin_documentnumber	varchar(18)	No	Receipt number	Yes
receipt_category	fin_cmbflag	varchar(4)	No	Receipt category	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
notes_for	fin_param_text	varchar(255)	No	Notes for	Yes
notes_level	fin_param_text	varchar(255)	No	Notes level	Yes
line_no	fin_sequence	int(4)	No	Line number	Yes
receipt_type	fin_cmbflag	varchar(4)	No	Receipt type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
notes	fin_notes	varchar(2000)	Yes	Notes	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	sur_receipt_dtl
Comment :	Stores the Details about Receipt

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization id	Yes
receipt_type	fin_text	varchar(256)	No	Receipt type	Yes
receipt_no	fin_documentnumber	varchar(18)	No	Receipt number	Yes
refdoc_lineno	fin_integer8	int(4)	No	Reference document number	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
usage	fin_usageid	varchar(20)	Yes	Usage	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
currency_code	fin_currency	varchar(5)	Yes	Currency code	No
account_amount	fin_amount	numeric(13)	Yes	Account amount	No
drcr_flag	fin_cmbflag	varchar(4)	Yes	Debit credit flag	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
remarks	fin_text255	varchar(255)	Yes	Remarks	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
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
acct_type	fin_accounttype	varchar(15)	Yes	Account type	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	sur_receipt_hdr
Comment :	Stores the Information of Header Receipt

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization nid	Yes
receipt_no	fin_documentnumber	varchar(18)	No	Receipt number	Yes
receipt_type	fin_cmbflag	varchar(4)	No	Receipt type	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
receipt_date	fin_datetime	datetime(8)	Yes	Receipt date	No
receipt_category	fin_cmbflag	varchar(4)	Yes	Receipt category	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
notype_no	fin_notypeno	varchar(10)	Yes	notype_no	No
remitter_name	fin_name	varchar(60)	Yes	Remitter name	No
receipt_method	fin_paramcode	varchar(30)	Yes	Receipt method	No
receipt_mode	fin_cmbflag	varchar(4)	Yes	Receipt mode	No
receipt_route	fin_cmbflag	varchar(4)	Yes	Receipt route	No
bank_cash_code	fin_bankcashcode	varchar(32)	Yes	Ban cash code	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
receipt_amount	fin_amount	numeric(13)	Yes	Receipt amount	No
origin_no	fin_documentnumber	varchar(18)	Yes	Origin number	No
reason_code	fin_reasoncode	varchar(10)	Yes	Reason code	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
instr_no	fin_checknumber	varchar(30)	Yes	Instrument number	No
micr_no	fin_checknumber	varchar(30)	Yes	micr_no	No
instr_amount	fin_amount	numeric(13)	Yes	Instrument amount	No
instr_date	fin_datetime	datetime(8)	Yes	Instrument date	No
instr_status	fin_cmbflag	varchar(4)	Yes	Instrument status	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
card_no	fin_checknumber	varchar(30)	Yes	Card number	No
card_auth_no	fin_documentnumber	varchar(18)	Yes	Card author number	No
issuer	fin_bankdescription	varchar(40)	Yes	Issuer	No
valid_till_month	fin_finmonth	varchar(10)	Yes	Valid till month	No
valid_till_year	fin_calendaryear	int(4)	Yes	Valid till year	No
address1	fin_address	varchar(40)	Yes	Address 1	No
address2	fin_address	varchar(40)	Yes	Address 2	No
address3	fin_address	varchar(40)	Yes	Address 3	No
city	fin_city	varchar(40)	Yes	City	No
state	fin_state	varchar(40)	Yes	State	No
country	fin_country	varchar(40)	Yes	Country	No
zip_code	fin_zip	varchar(20)	Yes	Zip code	No
contact	fin_contact	varchar(40)	Yes	Contact	No
url	fin_url	varchar(50)	Yes	URL	No
mail_stop	fin_mailstop	varchar(20)	Yes	Mail stop	No
pager_no	fin_contactnumber	varchar(20)	Yes	Pager number	No
telex	fin_telex	varchar(20)	Yes	Telex	No
email_id	fin_email	varchar(60)	Yes	Email id	No
phone_no	fin_contactnumber	varchar(20)	Yes	Phone number	No
mobile_no	fin_contactnumber	varchar(20)	Yes	Mobile number	No
fax_no	fin_contactnumber	varchar(20)	Yes	Fax number	No
receipt_status	fin_statuscode	varchar(2)	Yes	Receipt status	No
rr_flag	fin_cmbflag	varchar(4)	Yes	rr_flag	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
refdoc_no	fin_documentnumber	varchar(18)	Yes	Reference document number	No
refdoc_type	fin_doctype	varchar(40)	Yes	Reference document type	No
parbaseexrate	fin_exchangerate	numeric(9)	Yes	Parallel base exchange rate	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	sur_vataccount_dtl
Comment :	Stores the Detail of VATaccount

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
receipt_type	fin_cmbflag	varchar(4)	No	Receipt type	Yes
receipt_no	fin_documentnumber	varchar(18)	No	Receipt number	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
refdoc_lineno	fin_integer8	int(4)	No	Reference document line number	Yes
vat_lineno	fin_lineno	int(4)	No	Vat line number	Yes
vataccount_lineno	fin_sequence	int(4)	No	Vat account line number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
account_type	fin_documenttype	varchar(40)	Yes	Account type	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_cmbflag	varchar(4)	Yes	Debit credit flag	No
tranvat_amount	fin_amount	numeric(13)	Yes	Transaction vat amount	No
corrtranvat_amount	fin_amount	numeric(13)	Yes	corr transaction vat amount	No
basevat_amount	fin_amount	numeric(13)	Yes	Base vat amount	No
corrbasevat_amount	fin_amount	numeric(13)	Yes	corr base vat amount	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
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
receipt_currency	fin_currencycode	varchar(5)	Yes	Receipt currency	No
account_currency	fin_currencycode	varchar(5)	Yes	Account currency	No
vataccount_currency	fin_currencycode	varchar(5)	Yes	Vat account currency	No
vatexchange_rate	fin_exchangerate	numeric(9)	Yes	Vat exchange rate	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	sur_vatitem_dtl
Comment :	Stores the Detail of VATitem

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
receipt_type	fin_cmbflag	varchar(4)	No	Receipt type	Yes
receipt_no	fin_documentnumber	varchar(18)	No	Receipt number	Yes
refdoc_lineno	fin_integer8	int(4)	No	Reference document line number	Yes
vat_lineno	fin_lineno	int(4)	No	Vat line number	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
itemtcd_code	fin_itemcode	varchar(40)	Yes	Item tcd code	No
itemtcd_vrnt	fin_itemcode	varchar(40)	Yes	Item tcd variant	No
vat_category	fin_vatcategory	varchar(40)	Yes	Vat category	No
vat_class	fin_vatclass	varchar(40)	Yes	Vat class	No
vat_code	fin_tcdcode	varchar(10)	Yes	Vat code	No
vat_rate	fin_amount	numeric(13)	Yes	Vat rate	No
vat_inclusive	fin_cmbflag	varchar(4)	Yes	Vat inclusive	No
item_amount	fin_amount	numeric(13)	Yes	Item amount	No
tranvat_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
basevat_amount	fin_amount	numeric(13)	Yes	Base vat amount	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
receipt_currency	fin_currencycode	varchar(5)	Yes	Raceipt currency	No
account_currency	fin_currencycode	varchar(5)	Yes	Account currency	No
vatexchange_rate	fin_exchangerate	numeric(9)	Yes	Vat exchange rate	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No