|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tran_ou | fin_ouinstid | int(4) | No | Tran Ou | Yes |
| tran_no | fin_documentno | varchar(40) | No | Tran Number | Yes |
| tran_type | fin_type | varchar(25) | No | Tran Type | Yes |
| tran_date | fin_date | datetime(8) | Yes | Tran Date | No |
| tran_currency | fin_currency | varchar(5) | Yes | Tran Currency | No |
| ref_doc_no | fin_documentno | varchar(40) | Yes | Reference Document number | No |
| ref_doc_type | fin_type | varchar(25) | Yes | Reference Document type | No |
| ref_doc_date | fin_date | datetime(8) | Yes | Reference Document date | No |
| ref_doc_curr | fin_currency | varchar(5) | Yes | Reference Document Currency | No |
| fb_id | fin_financebookid | varchar(20) | Yes | Finance book id | No |
| ref_doc_erate | fin_exchangerate | numeric(9) | Yes | Reference document erate | No |
| termno | fin_quickcodes | varchar(25) | Yes | Term number | No |
| ref_doc_adjamt_crcurr | fin_amount | numeric(13) | Yes | Reference Document adjustment amount | No |
| tcd_line_no | fin_lineno | int(4) | Yes | Tcd Line number | No |
| tcd_code | fin_itemcode | varchar(40) | No | Tcd code | Yes |
| tcd_var_code | fin_itemcode | varchar(40) | No | Tcd Variance Code | Yes |
| tcd_currency | fin_currency | varchar(5) | Yes | Tcd Currency | No |
| tax_nature | fin_quickcodes | varchar(25) | Yes | Tax Nature | No |
| tcd_erate_date | fin_date | datetime(8) | Yes | Tcd Erate Type | No |
| prorated_taxable_tran_amt | fin_amount | numeric(13) | Yes | Prorated taxable transaction amount | No |
| prorated_tax_tran_amt | fin_amount | numeric(13) | Yes | prorated tax transaction amount | No |
| prorated_tax_erate | fin_amount | numeric(13) | Yes | Prorated tax erate | No |
| prorated_taxable_base_amt | fin_amount | numeric(13) | Yes | Prorated taxable base amount | No |
| prorated_tax_base_amt | fin_amount | numeric(13) | Yes | prorated tax base amount | No |
| tax_erate_type | fin_quickcodes | varchar(25) | Yes | Tax erate type | No |
| tax_acct_event | fin_quickcodes | varchar(25) | Yes | Tax accounting event | No |
| tax_acct_ert_ref | fin_quickcodes | varchar(25) | Yes | tax account erate reference | No |
| tax_prov_entry_reqd | fin_flag | varchar(25) | Yes | Tax prov entry required | No |
| paybatch_no | fin_documentno | varchar(40) | Yes | paybatch number | No |
| debit_doc | fin_flag | varchar(25) | Yes | Debit document | No |
| prov_adj_flag | fin_flag | varchar(25) | Yes | provisional adjustment flag | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | No | |
| Table Name : | spy_acct_info_dtl |
| Comment : | To store information of account information detail |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization unit id | No |
| posting_line_no | fin_int | int(4) | Yes | Posting line number | No |
| tran_no | fin_transactionnumber | varchar(18) | No | Trasaction number | No |
| tran_type | fin_transactiontype | varchar(40) | No | Transaction type | No |
| account_code | fin_accountcode | varchar(32) | No | Account code | No |
| drcr_flag | fin_drcridentifier | varchar(6) | No | Debit credit flag | No |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| account_type | fin_accounttype | varchar(15) | Yes | Account type | No |
| fin_post_date | fin_datetime | datetime(8) | Yes | Finance post date | No |
| currency_code | fin_currency | 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_buid | 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_exchangerate | numeric(9) | Yes | Base currency exchange rate | No |
| base_amount | fin_amount | numeric(13) | Yes | Base amount | No |
| pbcur_erate | fin_exchangerate | numeric(9) | 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 |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | No |
| paybatch_no | fin_documentno | varchar(40) | Yes | Pay batch number | No |
| bu_id | fin_buid | varchar(20) | Yes | Business unit id | 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 |
| mac_post_flag | fin_flag | varchar(25) | Yes | Mac post flag | No |
| CR_DOCNO | fin_transactionnumber | varchar(18) | Yes | CR document number | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| voucher_no | fin_documentnumber | varchar(18) | No | Voucher number | No |
| ref_doc_no | fin_documentnumber | varchar(18) | No | Referene document number | No |
| ref_doc_ou | fin_ouinstid | int(4) | No | Reference document OU | No |
| std_notes_id | fin_docuemntno | varchar(18) | No | Standard notes id | No |
| std_notes_desc | fin_description | varchar(100) | Yes | Standard notes description | No |
| paybatch_no | fin_documentnumber | varchar(18) | Yes | Paybatch number | No |
| 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 |
| vouch_ouid | fin_ouinstid | int(4) | Yes | Voucher organization unit id | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | Yes | TCD ou id | No |
| paybatch_no | fin_documentnumber | varchar(18) | No | Paybatch number | Yes |
| voucher_no | fin_documentnumber | varchar(18) | Yes | Voucher number | No |
| tran_type | fin_type | varchar(25) | No | Transaction type | Yes |
| cr_doc_no | fin_documentnumber | varchar(18) | No | Cr document number | Yes |
| cr_doc_ou | fin_ouinstname | varchar(16) | Yes | Cr document ou | No |
| cr_doc_cur | fin_currency | varchar(5) | Yes | Cr document currency | No |
| line_no | fin_lineno | int(4) | No | Line number | Yes |
| tcdno | fin_itemcode | varchar(40) | No | TCD number | Yes |
| tcdvar | fin_itemcode | varchar(40) | No | TCD variance | Yes |
| tcdcurr | fin_currency | varchar(5) | Yes | TCD currency | No |
| tcdlevel | fin_chkflag | varchar(1) | Yes | TCD level | No |
| taxableamt | fin_amount | numeric(13) | Yes | Taxable amount | No |
| taxamttcdcurr | fin_amount | numeric(13) | Yes | Tax amount currency | No |
| totinvamt | fin_amount | numeric(13) | Yes | Total invoice amount | No |
| dueamt | fin_amount | numeric(13) | Yes | Due amount | No |
| taxamtinvcurr | fin_amount | numeric(13) | Yes | Tax amount invoice currency | No |
| created_by | fin_ctxt_user | varchar(30) | Yes | created by | No |
| created_date | datetime | Datetime(8) | Yes | Created date | No |
| acct_event | fin_event | varchar(40) | Yes | Accounting Event | No |
| tax_erate_type | fin_type | varchar(25) | Yes | Tax Erate Type | No |
| acct_erate_date_type | fin_type | varchar(25) | Yes | Account Erate Type | No |
| adj_erate_date | fin_date | datetime(8) | Yes | Erate date | No |
| adj_acct_erate | fin_exchangerate | numeric(9) | Yes | Account Date | No |
| adj_tax_base_amt | fin_amount | numeric(13) | Yes | Tax Base Amount | No |
| cr_doc_date | fin_date | datetime(8) | Yes | Credit document date | No |
| payment_date | fin_date | datetime(8) | Yes | Payment date | No |
| adj_whttax_base_amt | fin_amount | numeric(13) | Yes | with holding tax base amount | No |
| term_no | fin_termnumber | varchar(20) | No | Term Number | Yes | |
| Table Name : | spy_paybatch_dtl |
| Comment : | To store information of payment batch detail |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization unit id | No |
| paybatch_no | fin_documentnumber | varchar(18) | No | Paybatch number | No |
| cr_doc_ou | fin_ouinstname | varchar(16) | No | Credit document OU | No |
| cr_doc_no | fin_documentnumber | varchar(18) | No | Credit document number | No |
| term_no | fin_termnumber | varchar(20) | No | Term number | No |
| tran_type | fin_type | varchar(25) | No | Transaction type | No |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| cr_doc_type | fin_doctype | varchar(40) | Yes | Credit document type | No |
| pay_currency | fin_currency | varchar(5) | Yes | Payment currency | No |
| tran_amount | fin_amount | numeric(13) | Yes | Transaction amount | No |
| discount | fin_amount | numeric(13) | Yes | Discount | No |
| penalty | fin_amount | numeric(13) | Yes | Penalty | No |
| pay_mode | fin_paymode | varchar(25) | Yes | Payment mode | No |
| proposed_penalty | fin_amount | numeric(13) | Yes | Proposed penalty | No |
| proposed_discount | fin_amount | numeric(13) | Yes | Proposed discount | No |
| basecur_erate | fin_exchangerate | numeric(9) | Yes | Base current exchange rate | No |
| crosscur_erate | fin_exchangerate | numeric(9) | Yes | Cross current exchange rate | No |
| supp_ctrl_acct | fin_accountcode | varchar(32) | Yes | Supplier control account | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | No |
| lsv_id | fin_documentno | varchar(40) | Yes | lsv id | No |
| esr_line | fin_reference_det2 | varchar(128) | Yes | esr line | 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 |
| parbasecur_erate | fin_exchangerate | numeric(9) | Yes | Parallel base currency exchange rate | No |
| payref_id | fin_documentnumber | varchar(18) | Yes | Payment reference id | No |
| Exchrate | fin_amount | numeric(13) | Yes | Exchange rate | No |
| Pay_Instruction | fin_description | varchar(100) | Yes | Payment instruction | No |
| eft_suppbanktype | fin_type | varchar(25) | Yes | Effective supplier bank type | No |
| bank_type | fin_type | varchar(25) | Yes | Bank type | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes |
| proposed_wht | fin_amount | numeric(13) | Yes | Proposed what | No |
| applied_wht | fin_amount | numeric(13) | Yes | Applied what | No |
| pay_curr_erate | Fin_exchangerate | numeric(9) | Yes | Pay Currency Exchange rate | No |
| pay_curr_amount | fin_amount | numeric(13) | Yes | Pay Currency Amount | No | |
| Table Name : | spy_paybatch_hdr |
| Comment : | To store information of payment batch header |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization unit id | Yes |
| paybatch_no | fin_documentnumber | varchar(18) | No | Paybatch number | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| paybatch_notype | fin_notypeno | varchar(10) | Yes | Paybatch number type | No |
| voucher_notype | fin_notypeno | varchar(10) | Yes | Voucher number type | No |
| request_date | fin_datetime | datetime(8) | Yes | Request date | No |
| pay_date | fin_datetime | datetime(8) | Yes | Payment date | No |
| payment_route | fin_route | varchar(10) | Yes | Payment route | No |
| pay_mode | fin_paymode | varchar(25) | Yes | Payment mode | No |
| paygroup_no | fin_paygroup | varchar(10) | Yes | Paygroup number | No |
| relpay_ou | fin_ouinstname | varchar(16) | Yes | Repayment OU | No |
| pay_chargeby | fin_suppliercode | varchar(16) | Yes | Payment charge by | No |
| priority | fin_priority | varchar(12) | Yes | Priority | No |
| fb_id | fin_financebookid | varchar(20) | Yes | Finance book id | No |
| status | fin_status | varchar(25) | Yes | Status | No |
| pay_currency | fin_currency | varchar(5) | Yes | Pay currency | No |
| basecur_erate | fin_exchangerate | numeric(9) | Yes | Base currency exchange rate | No |
| tran_type | fin_type | varchar(25) | Yes | Transaction type | No |
| remarks | fin_text255 | varchar(255) | Yes | Remarks | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | 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 |
| elect_payment | fin_option | varchar(20) | Yes | Electronic payment | No |
| fw_cover_flag | fin_desc20 | varchar(20) | Yes | Forward cover flag | No |
| bankcurr | fin_currencycode | varchar(5) | Yes | Bank Currency | No |
| paytobnkcurr_erate | Fin_exchangerate | numeric(9) | Yes | Pay to bank Curr Exhange rate | No |
| bnktobasecurr_erate | Fin_exchangerate | numeric(9) | Yes | Bank to base Currency Exchange rate | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| username | fin_username | varchar(25) | No | Username | No |
| notypeno | fin_notypeno | varchar(10) | No | notypeno | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Table Name : | spy_paygroup_dtl |
| Comment : | To store information of payment group detail |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization unit id | No |
| paygroup_no | fin_paygroup | varchar(10) | No | Payment group number | No |
| number | fin_number | int(4) | No | Number | No |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| billing_point | fin_ouinstname | varchar(16) | Yes | Billing point | No |
| doc_type | fin_documenttype | varchar(40) | Yes | Document type | No |
| from_document | fin_documentnumber | varchar(18) | Yes | From document | No |
| to_document | fin_documentnumber | varchar(18) | Yes | To document | 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 |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Table Name : | spy_paygroup_hdr |
| Comment : | To store information of payment group header |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization unit id | Yes |
| paygroup_no | fin_paygroup | varchar(10) | No | Payment group number | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| paygroup_desc | fin_paygroupdescription | varchar(40) | Yes | Payment group description | No |
| pay_mode | fin_paymode | varchar(25) | Yes | Payment mode | No |
| voc_paymode | fin_paymode | varchar(25) | Yes | voc payment mode | No |
| from_amount | fin_amount | numeric(13) | Yes | From amount | No |
| to_amount | fin_amount | numeric(13) | Yes | To amount | No |
| max_limit_amount | fin_amount | numeric(13) | Yes | Maximum limit amount | No |
| bank_cash_code | fin_bankcashcode | varchar(32) | Yes | Bank cash code | No |
| fb_id | fin_financebookid | varchar(20) | Yes | Finance book id | No |
| fin_year | fin_calendarcode | varchar(10) | Yes | Financial year | No |
| fin_period | fin_calendarcode | varchar(10) | Yes | Financial period | No |
| calendar_year | fin_calendaryear | int(4) | Yes | Calendar year | No |
| document_currency | fin_currencycode | varchar(5) | Yes | Document currency | No |
| to_date | fin_datetime | datetime(8) | Yes | To date | No |
| from_date | fin_datetime | datetime(8) | Yes | From date | No |
| month | fin_finmonth | varchar(10) | Yes | Month | No |
| group_by | fin_group | varchar(25) | Yes | Group by | No |
| fortnight | fin_fortnight | varchar(10) | Yes | Fortnight | No |
| no_of_vouchers | fin_number | int(4) | Yes | Number of vouchers | No |
| date_option | fin_option | varchar(20) | Yes | Date option | No |
| elec_payment | fin_option | varchar(20) | Yes | Electronic payment | No |
| pay_thru_date | fin_option | varchar(20) | Yes | Payment through date | No |
| supp_area | fin_ouinstname | varchar(16) | Yes | Supplier area | No |
| document_priority | fin_priority | varchar(12) | Yes | Document priority | No |
| supplier_priority | fin_priority | varchar(12) | Yes | Supplier priority | No |
| sort_by | fin_sort | varchar(20) | Yes | Sort by | No |
| status | fin_status | varchar(25) | Yes | Status | No |
| from_supplier | fin_suppliercode | varchar(16) | Yes | From supplier | No |
| from_paytosupp | fin_suppliercode | varchar(16) | Yes | From paytosupplier | No |
| to_paytosupp | fin_suppliercode | varchar(16) | Yes | To paytosupplier | No |
| to_supplier | fin_suppliercode | varchar(16) | Yes | To supplier | No |
| week_no | fin_week | int(4) | Yes | Week number | No |
| payment_route | fin_route | varchar(10) | Yes | Payment route | No |
| def_crdoc_paymode | fin_flag | varchar(25) | Yes | Credit document paymode | 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 |
| suppliergroup | fin_suppliergroup | varchar(20) | Yes | Supplier group | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization unit id | Yes |
| paybatch_no | fin_documentnumber | varchar(18) | No | Paybatch number | Yes |
| pay_currency | fin_currency | varchar(5) | No | Payment currency | Yes |
| bank_cash_code | fin_bankcashcode | varchar(32) | No | Bank cash code | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| acct_currency | fin_currencycode | varchar(5) | Yes | Account currency | No |
| basecur_erate | fin_exchangerate | numeric(9) | Yes | Base currency exchange rate | No |
| pay_amount | fin_amount | numeric(13) | Yes | Payment amount | No |
| account_balance | fin_amount | numeric(13) | Yes | Account balance | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | 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 | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tran_type | fin_cmntrantype | varchar(10) | Yes | Transaction type | No |
| tran_ou | fin_ouinstid | int(4) | Yes | Transaction OU | No |
| tran_no | fin_documentnumber | varchar(18) | Yes | Trasaction number | No |
| line_no | fin_lineno | int(4) | Yes | Line no | No |
| item_tcd_code | fin_itemcode | varchar(40) | Yes | Item TCD Code | No |
| item_tcd_var | fin_itemcode | varchar(40) | Yes | Item TCD Variant | No |
| tcd_version | fin_macseqno | int(4) | Yes | TCD Version | No |
| timestamp | int | int(4) | Yes | Timestamp | No |
| item_type | fin_abbreviation | varchar(3) | Yes | Item type | No |
| tcd_level | fin_chkflag | varchar(1) | Yes | TCD level | No |
| tcd_rate | fin_amount | numeric(13) | Yes | TCD rate | No |
| taxable_amount | fin_amount | numeric(13) | Yes | Taxable amount | No |
| tcd_amount | fin_amount | numeric(13) | Yes | TCD amount | No |
| tcd_currency | fin_currency | varchar(5) | Yes | TCD currency | No |
| usage | fin_finusage | varchar(40) | Yes | Usage | No |
| base_amount | fin_amount | numeric(13) | Yes | Base amount | No |
| par_base_amount | fin_amount | numeric(13) | Yes | Parallel 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 |
| tcd_account | fin_accountcode | varchar(32) | Yes | TCD account | No |
| remarks | fin_text255 | varchar(255) | Yes | Remarks | No |
| createdby | fin_user | varchar(15) | Yes | Created by | No |
| createddate | datetime | Datetime(8) | Yes | Created date | No |
| modifiedby | fin_user | varchar(15) | Yes | Modified by | No |
| modifieddate | datetime | Datetime(8) | Yes | Modified date | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes | |
| Table Name : | spy_prepay_vch_dtl |
| Comment : | To store information of prepayment voucher detail |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization unit id | No |
| voucher_no | fin_documentnumber | varchar(18) | No | Voucher number | No |
| ordering_ou | fin_ouinstid | int(4) | No | Ordering OU | No |
| ref_doc_no | fin_documentnumber | varchar(18) | No | Reference document number | No |
| tran_type | fin_type | varchar(25) | No | Transaction type | No |
| doc_type | fin_documenttype | varchar(40) | No | Document type | No |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| pay_amount | fin_amount | numeric(13) | Yes | Payment amount | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | 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 |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Table Name : | spy_prepay_vch_hdr |
| Comment : | To store information of prepayment voucher header |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization unit id | Yes |
| voucher_no | fin_documentnumber | varchar(18) | No | Voucher number | Yes |
| tran_type | fin_type | varchar(25) | No | Transaction type | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| voucher_type | fin_documenttype | varchar(40) | Yes | Voucher type | No |
| request_date | fin_datetime | datetime(8) | Yes | Request date | No |
| fb_id | fin_financebookid | varchar(20) | Yes | Finance book id | No |
| supp_code | fin_suppliercode | varchar(16) | Yes | Supplier code | No |
| payment_route | fin_route | varchar(10) | Yes | Payment route | No |
| pay_mode | fin_paymode | varchar(25) | Yes | Payment mode | No |
| priority | fin_priority | varchar(12) | Yes | Priority | No |
| pay_currency | fin_currency | varchar(5) | Yes | Payment currency | No |
| exchange_rate | fin_exchangerate | numeric(9) | Yes | Exchange rate | No |
| dd_charges | fin_ddoption | varchar(10) | Yes | DD charges | No |
| pay_amount | fin_amount | numeric(13) | Yes | Payment amount | No |
| pay_amt_bef_round | fin_amount | numeric(13) | Yes | Payment amount before round | No |
| roundoff_amt | fin_amount | numeric(13) | Yes | Roundoff amount | No |
| par_exchange_rate | fin_exchangerate | numeric(9) | Yes | Parallel exchange rate | No |
| pay_date | fin_datetime | datetime(8) | Yes | Payment date | No |
| bank_cash_code | fin_bankcashcode | varchar(32) | Yes | Bank cash code | No |
| relpay_ou | fin_ouinstname | varchar(16) | Yes | relpay OU | No |
| reason_code | fin_quickcodes | varchar(25) | Yes | Reason code | No |
| hld_reason_code | fin_quickcodes | varchar(25) | Yes | Hold reason code | No |
| remarks | fin_desc255 | varchar(255) | Yes | Remarks | No |
| hld_remarks | fin_remarks | varchar(100) | Yes | Hold remarks | No |
| rev_remarks | fin_remarks | varchar(100) | Yes | Reversal remarks | No |
| rev_date | fin_datetime | datetime(8) | Yes | Reversal date | No |
| notype_no | fin_notypeno | varchar(10) | Yes | notype number | No |
| supp_area | fin_ouinstname | varchar(16) | Yes | Supplier area | No |
| supp_doc_no | fin_documentnumber | varchar(18) | Yes | Supplier document number | No |
| supp_doc_date | fin_datetime | datetime(8) | Yes | Supplier document date | No |
| supp_doc_amt | fin_amount | numeric(13) | Yes | Supplier document amount | No |
| supp_prepay_acct | fin_accountcode | varchar(32) | Yes | Supplier prepay account | No |
| bank_cash_acct | fin_accountcode | varchar(32) | Yes | Bak cash account | No |
| supp_receipt_no | fin_documentnumber | varchar(18) | Yes | Supplier receipt number | No |
| receipt_date | fin_datetime | datetime(8) | Yes | Receipt date | No |
| status | fin_status | varchar(25) | Yes | Status | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | 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 | Modifieddate | No |
| Pay_Ref_id | fin_documentno | varchar(40) | Yes | Payment reference id | No |
| bank_type | fin_type | varchar(25) | Yes | Bank type | No |
| eft_suppbanktype | fin_type | varchar(25) | Yes | Supplier bank type | No |
| taxkey | fin_taxkey | varchar(15) | Yes | Tax key | No |
| tax_amount | fin_amount | numeric(13) | Yes | Tax amount | No |
| tran_amount | fin_amount | numeric(13) | Yes | Transaction amount | No | |
| Table Name : | spy_vat_info_dtl |
| Comment : | To store information of vat information detail |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization unit id | No |
| posting_line_no | fin_lineno | int(4) | No | Posting line number | No |
| tran_no | fin_transactionnumber | varchar(18) | No | Transaction number | No |
| tran_type | fin_transactiontype | varchar(40) | No | Transaction type | No |
| account_code | fin_accountcode | varchar(32) | No | Account code | No |
| drcr_flag | fin_drcridentifier | varchar(6) | No | Debit credit flag | No |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| account_type | fin_accounttype | varchar(15) | Yes | Account type | No |
| fin_post_date | fin_datetime | datetime(8) | Yes | Finance post date | No |
| currency_code | fin_currency | 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_buid | 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_exchangerate | numeric(9) | Yes | Base currency exchange rate | No |
| base_amount | fin_amount | numeric(13) | Yes | Base amount | No |
| pbcur_erate | fin_exchangerate | numeric(9) | Yes | Parallel base currency exchange rate | No |
| par_base_amt | fin_amount | numeric(13) | Yes | Parallel base amount | No |
| fin_post_status | fin_status | varchar(25) | Yes | Finance post status | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | No |
| paybatch_no | fin_documentno | varchar(40) | Yes | Paybatch number | No |
| bu_id | fin_buid | varchar(20) | Yes | Business unit id | 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 |
| cr_doc_no | fin_documentno | varchar(40) | Yes | Credit document number | No |
| term_no | fin_termnumber | varchar(20) | Yes | Term number | No |
| cr_doc_type | fin_doctype | varchar(40) | Yes | Credit document type | No |
| cr_doc_ou | fin_ouinstid | int(4) | Yes | Credit | No |
| vat_tran_amt | fin_amount | numeric(13) | Yes | Vat transaction amount | No |
| vat_base_amt | fin_amount | numeric(13) | Yes | Vat base amount | No |
| vat_ded_base_amt | fin_amount | numeric(13) | Yes | Vat ded base amount | No |
| vat_nonded_base_amt | fin_amount | numeric(13) | Yes | Vat nonded base amount | No |
| vat_category | fin_vatcategory | varchar(40) | Yes | Vat category | No |
| vat_class | fin_vatclass | varchar(40) | Yes | Vat class | No |
| vat_rate | fin_amount | numeric(13) | Yes | Vat rate | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Table Name : | spy_vat_ref |
| Comment : | To store information of vat reference |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization unit id | Yes |
| paybatch_no | fin_documentnumber | varchar(18) | No | Paybatch number | Yes |
| batch_id | fin_guid | varchar(40) | No | Batch id | No |
| tran_no | fin_docuemntno | varchar(18) | No | Transaction number | No |
| ref_dr_doc_no | fin_docuemntno | varchar(18) | No | Reference document | 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 |
| tran_type | fin_documenttype | varchar(40) | No | Transaction type | Yes |
| term_no | fin_termnumber | varchar(20) | No | Term number | Yes |
| vat_tran_amt | fin_amount | numeric(13) | Yes | Vat transaction amount | No |
| vat_base_amt | fin_amount | numeric(13) | Yes | Vat base amount | No |
| vat_ded_base_amt | fin_amount | numeric(13) | Yes | Vat ded base amount | No |
| vat_nonded_base_amt | fin_amount | numeric(13) | Yes | Vat nonded base amount | No |
| vat_category | fin_vatcategory | varchar(40) | Yes | Vat category | No |
| vat_rate | fin_amount | numeric(13) | Yes | Vat rate | No |
| vat_class | fin_vatclass | varchar(40) | Yes | Vat class | No | |
| Table Name : | spy_voucher_dtl |
| Comment : | To store information of voucher detail |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization unit id | No |
| paybatch_no | fin_documentnumber | varchar(18) | No | Paybatch number | No |
| voucher_no | fin_documentnumber | varchar(18) | No | Voucher number | No |
| cr_doc_ou | fin_ouinstname | varchar(16) | No | Credit document OU | No |
| cr_doc_no | fin_documentnumber | varchar(18) | No | Debit document number | No |
| term_no | fin_termnumber | varchar(20) | No | Term number | No |
| tran_type | fin_type | varchar(25) | No | Transaction type | No |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| cr_doc_amount | fin_amount | numeric(13) | Yes | Credit document amount | No |
| cr_doc_type | fin_doctype | varchar(40) | Yes | Credit document type | No |
| pay_amount | fin_amount | numeric(13) | Yes | Payment amount | No |
| discount | fin_amount | numeric(13) | Yes | Discount | No |
| penalty | fin_amount | numeric(13) | Yes | Penalty | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | 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 |
| variance_amount | fin_amount | numeric(13) | Yes | Variance amount | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Table Name : | spy_voucher_hdr |
| Comment : | To store information of voucher header |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization unit id | Yes |
| paybatch_no | fin_documentnumber | varchar(18) | No | Paybatch number | Yes |
| voucher_no | fin_documentnumber | varchar(18) | No | Voucher number | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| voucher_amount | fin_amount | numeric(13) | Yes | Voucher amount | No |
| vouch_amt_bef | fin_amount | numeric(13) | Yes | Voucher amount befor | No |
| roundoff_amt | fin_amount | numeric(13) | Yes | Roundoff amount | No |
| exchange_rate | fin_exchangerate | numeric(9) | Yes | Exchange rate | No |
| par_exchange_rate | fin_exchangerate | numeric(9) | Yes | Parallel base exchange rate | No |
| pay_currency | fin_currency | varchar(5) | Yes | Payment currency | No |
| payee | fin_suppliercode | varchar(16) | Yes | Payee | No |
| pay_mode | fin_paymode | varchar(25) | Yes | Payment mode | No |
| bank_cash_code | fin_bankcashcode | varchar(32) | Yes | Bank cash code | No |
| priority | fin_priority | varchar(12) | Yes | Priority | No |
| dd_charges | fin_ddoption | varchar(10) | Yes | DD changes | No |
| status | fin_status | varchar(25) | Yes | Status | No |
| supp_receipt_no | fin_documentnumber | varchar(18) | Yes | Supplier receipt number | No |
| receipt_date | fin_datetime | datetime(8) | Yes | Receipt date | No |
| reason_code | fin_quickcodes | varchar(25) | Yes | Reason code | No |
| hld_reason_code | fin_quickcodes | varchar(25) | Yes | Hold reason code | No |
| hld_remarks | fin_remarks | varchar(100) | Yes | Hold remarks | No |
| rev_remarks | fin_remarks | varchar(100) | Yes | Reversal remarks | No |
| rev_date | fin_datetime | datetime(8) | Yes | Reversal date | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | No |
| supp_acct_in | fin_accounttype | varchar(15) | Yes | Supplier account information | No |
| supp_bank_ref | fin_bankcode | varchar(32) | Yes | Supplier bank reference | No |
| supp_acc_no | fin_accountcode | varchar(32) | Yes | Supplier account number | No |
| lsv_id | fin_documentno | varchar(40) | Yes | lsv id | No |
| esr_line | fin_reference_det2 | varchar(128) | Yes | esr line | 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 |
| line_no | fin_number | int(4) | No | Line number | No |
| eft_suppbanktype | fin_type | varchar(25) | Yes | Supplier bank type | No |
| bank_type | fin_type | varchar(25) | Yes | Bank type | No |
| supplier_code | fin_supplier | nvarchar(160) | Yes | Supplier code | No |
| bankcurr | fin_currencycode | varchar(5) | Yes | Bank Currency | No |
| paytobnkcurr_erate | Fin_exchangerate | numeric(9) | No | Pay to Bank currency Exchange rate | No |
| bnktobasecurr_erate | Fin_exchangerate | numeric(9) | No | Bank to base Currency Exchange rate | No |