|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tran_ou | fin_ouinstid | int(4) | No | Transaction OU | No |
| tran_type | fin_cmntrantype | varchar(10) | No | Transaction type | No |
| tran_no | fin_documentno | varchar(40) | No | Transaction number | No |
| line_no | fin_number | int(4) | No | Line number | No |
| company_code | fin_companycode | varchar(10) | No | Company code | No |
| fb_id | fin_financebookid | varchar(20) | No | Finance book id | No |
| account_code | fin_accountcode | varchar(32) | No | Account code | No |
| drcr_flag | fin_drcridentifier | varchar(6) | No | Debit credit flag | No |
| component_id | fin_component | varchar(16) | Yes | Component id | No |
| txnou_id | fin_ouinstid | int(4) | Yes | txnou_id | No |
| bu_id | fin_buid | varchar(20) | Yes | Business unit id | No |
| tran_date | fin_datetime | datetime(8) | Yes | Transaction date | No |
| tran_qty | fin_quantity | numeric(17) | Yes | Transaction quantity | No |
| tran_amount_acc_cur | fin_amount | numeric(13) | Yes | Transaction amount | No |
| ctrl_acct_type | fin_accounttype | varchar(15) | Yes | Control Account type | No |
| auto_post_acct_type | fin_accounttype | varchar(15) | Yes | Auto post account type | No |
| analysis_code | fin_analysiscode | varchar(5) | Yes | Analysis code | No |
| subanalysis_code | fin_subanalysiscode | varchar(5) | Yes | Subanalysis code | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | Cost center | No |
| bank_code | fin_bankcode | varchar(32) | Yes | Bank code | No |
| item_code | fin_itemcode | varchar(40) | Yes | Item code | No |
| item_variant | fin_itemcode | varchar(40) | Yes | Item variant | No |
| uom | fin_uom | varchar(15) | Yes | UOM | No |
| supplier_code | fin_suppliercode | varchar(16) | Yes | Supplier code | No |
| acct_currency | fin_currencycode | varchar(5) | Yes | Account currency | No |
| basecur_erate | fin_exchangerate | numeric(9) | Yes | Base currency exchangerate | No |
| base_amount | fin_amount | numeric(13) | Yes | Base 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 |
| par_base_amount | fin_amount | numeric(13) | Yes | Parallel base amount | No |
| narration | fin_text255 | varchar(255) | Yes | Narration | No |
| auth_date | fin_datetime | datetime(8) | Yes | Author date | No |
| ref_doc_ou | fin_ouinstid | int(4) | Yes | Reference document OU | No |
| ref_doc_fb_id | fin_financebookid | varchar(20) | Yes | Reference document fb id | No |
| ref_doc_type | fin_cmntrantype | varchar(10) | Yes | Reference document type | No |
| ref_doc_no | fin_documentnumber | varchar(18) | Yes | Reference document number | No |
| vat_decl_year | fin_financeyear | varchar(15) | Yes | Vat daclared year | No |
| vat_decl_period | fin_financeperiod | varchar(15) | Yes | Vat declared period | No |
| vat_usage_flag | fin_chkflag | varchar(1) | Yes | Vat usage flag | 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_finrate | numeric(9) | Yes | Vat rate | No |
| posting_date | fin_datetime | datetime(8) | Yes | Posting date | No |
| posting_status | fin_status | varchar(25) | Yes | Posting status | No |
| base_currency | fin_currencycode | varchar(5) | Yes | Base currency | No |
| par_base_currency | fin_currencycode | varchar(5) | Yes | Parallel base currency | No |
| vat_posting_flag | fin_chkflag | varchar(1) | Yes | Vat posting flag | No |
| vat_posting_date | fin_datetime | datetime(8) | Yes | Vat posting date | No |
| account_type | fin_accounttype | varchar(15) | Yes | Account type | 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 |
| vat_line_no | fin_lineno | int(4) | Yes | Vat line number | No |
| ref_doclineno | fin_lineno | int(4) | Yes | Reference document line number | No |
| capitalized_amount | fin_amount | numeric(13) | Yes | Capitalized amount | No |
| cap_flag | fin_flag | varchar(25) | Yes | Capitalized flag | No |
| refdoc_fbid | fin_financebookid | varchar(20) | Yes | Reference document finance book id | No |
| refdoc_acccode | fin_accountcode | varchar(32) | Yes | Reference document account code | No |
| refdoc_cc | fin_costcentercode | varchar(10) | Yes | Reference document code | No |
| refdoc_analcode | fin_analysiscode | varchar(5) | Yes | Reference document analysis code | No |
| refdoc_subanalcode | fin_analysiscode | varchar(5) | Yes | Reference document subanalysis code | No |
| refdoc_propno | fin_documentnumber | varchar(18) | Yes | Reference document proposal number | No |
| refdoc_itemflag | fin_flag | varchar(25) | Yes | Reference document item flag | No |
| refdoc_rowid | fin_seqno | int(4) | Yes | Reference document row id | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes |
| refdoctype_code | fin_desc5 | varchar(5) | Yes | Reference document type code | No |
| refdoc_no | fin_documentno | varchar(40) | Yes | Reference document no | No |
| custorder_no | fin_documentno | varchar(40) | Yes | Customer order number | No |
| ame_no | fin_documentno | varchar(40) | Yes | AME number | No |
| swo_no | fin_documentno | varchar(40) | Yes | Shop work order number | No |
| customer_id | fin_customer_id | varchar(18) | Yes | Customer Id | No |
| supplier_id | fin_vendorcode | varchar(45) | Yes | Supplier Id | No |
| exchord_no | fin_documentno | varchar(40) | Yes | Exchange order number | No |
| exp_acct_flag | fin_designparamcode | varchar(5) | Yes | expense account flag | No |
| track_id | bigint | Bigint(8) | Yes | tracking id | No | |
| Table Name : | si_doc_balance |
| Comment : | To store information of document balance |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tran_ou | fin_ouinstname | varchar(16) | No | Transaction OU | No |
| tran_type | fin_cmntrantype | varchar(10) | No | Transaction type | No |
| tran_no | fin_documentno | varchar(40) | No | Transaction number | No |
| term_no | fin_termnumber | varchar(20) | No | Term number | No |
| lo_id | fin_loid | varchar(20) | Yes | lo id | No |
| tran_currency | fin_currency | varchar(5) | Yes | Transaction currency | No |
| tran_amount | fin_amount | numeric(13) | Yes | Transaction amount | No |
| exchange_rate | fin_exchangerate | numeric(9) | Yes | Exchange rate | No |
| base_amount | fin_amount | numeric(13) | Yes | Base amount | No |
| par_exchange_rate | fin_exchangerate | numeric(9) | Yes | Parallel exchange | No |
| par_base_amount | fin_amount | numeric(13) | Yes | Parallel base amount | No |
| doc_status | fin_partstatus | varchar(40) | Yes | Document status | No |
| adjustment_status | fin_partstatus | varchar(40) | Yes | Adjustment status | No |
| discount_amount | fin_amount | numeric(13) | Yes | Discount amount | No |
| disc_availed | fin_amount | numeric(13) | Yes | Discount availed | No |
| penalty_amount | fin_amount | numeric(13) | Yes | Penalty amount | No |
| paid_amt | fin_amount | numeric(13) | Yes | Paid amount | No |
| requested_amount | fin_amount | numeric(13) | Yes | Requested amount | No |
| adjusted_amount | fin_amount | numeric(13) | Yes | Adjusted 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 | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tran_type | fin_cmntrantype | varchar(10) | No | Transaction type | Yes |
| amt_type | fin_type | varchar(25) | No | Amount type | Yes |
| ref_tran_type | fin_cmntrantype | varchar(10) | No | Reference transaction type | Yes |
| output_val | fin_suppliercode | varchar(16) | No | Output value | Yes |
| output_val_cr | fin_suppliercode | varchar(16) | No | Output value credit | Yes |
| tran_type_cr | fin_cmntrantype | varchar(10) | No | Transaction type credit | Yes |
| multiplicn_factor | fin_number | int(4) | Yes | Multiplication factor | No |
| multiplicn_factor_cr | fin_number | int(4) | Yes | Multiplication factor credit | 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) | No | Transaction type | Yes |
| amt_type | fin_type | varchar(25) | No | Amount type | Yes |
| ref_tran_type | fin_cmntrantype | varchar(10) | No | Reference transaction type | Yes |
| target_col | fin_desc20 | varchar(20) | No | Target | Yes |
| balance_factor | fin_amount | numeric(13) | Yes | Balance factor | 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 : | si_doc_hdr |
| Comment : | To store information of document header |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tran_ou | fin_ouinstid | int(4) | No | Transaction OU | Yes |
| tran_type | fin_cmntrantype | varchar(10) | No | Transaction type | Yes |
| tran_no | fin_documentno | varchar(40) | No | Transaction number | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| tran_date | fin_datetime | datetime(8) | Yes | Transaction date | No |
| lo_id | fin_loid | varchar(20) | Yes | lo id | No |
| fb_id | fin_financebookid | varchar(20) | Yes | Finance book id | No |
| tran_currency | fin_currency | varchar(5) | Yes | Transaction currency | No |
| supplier_code | fin_vendorcode | varchar(45) | Yes | Supplier code | No |
| pay_term | fin_quickcodes | varchar(25) | Yes | Payment term | No |
| payterm_version | fin_lineno | int(4) | Yes | Payment version | No |
| tran_amount | fin_amount | numeric(13) | Yes | Transaction amount | No |
| exchange_rate | fin_exchangerate | numeric(9) | Yes | Exchange rate | No |
| base_amount | fin_amount | numeric(13) | Yes | Base amount | No |
| par_exchange_rate | fin_exchangerate | numeric(9) | Yes | Parallel exchange rate | No |
| par_base_amount | fin_amount | numeric(13) | Yes | Par base amount | No |
| doc_status | fin_partstatus | varchar(40) | Yes | Document status | No |
| reversed_docno | fin_documentno | varchar(40) | Yes | Reversed document number | No |
| reversal_date | fin_datetime | datetime(8) | Yes | Reversal date | No |
| checkseries_no | fin_checkseriesnumber | varchar(32) | Yes | Check series number | No |
| check_no | fin_checknumber | varchar(30) | Yes | Check number | No |
| bank_code | fin_bankcode | varchar(32) | Yes | Bank code | No |
| paid_status | fin_status | varchar(25) | Yes | Paid status | No |
| vat_applicable | fin_chkflag | varchar(1) | Yes | Vat applicable | No |
| average_vat_rate | fin_rate | numeric(13) | Yes | Average vat rate | No |
| discount_proportional | fin_chkflag | varchar(1) | Yes | Discount proportional | No |
| discount_amount | fin_amount | numeric(13) | Yes | Discount amount | No |
| discount_availed | fin_amount | numeric(13) | Yes | Discount availed | No |
| penalty_amount | fin_amount | numeric(13) | Yes | Penalty amount | No |
| paid_amount | fin_amount | numeric(13) | Yes | Paid amount | No |
| requested_amount | fin_amount | numeric(13) | Yes | Requested amount | No |
| adjusted_amount | fin_amount | numeric(13) | Yes | Adjusted amount | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | No |
| supp_ou | fin_ouinstid | int(4) | Yes | Supplier OU | No |
| reversed_docou | fin_ouinstid | int(4) | Yes | Reversed document OU | No |
| supp_name | udd_txt150 | varchar(150) | Yes | Supplier name | No |
| supp_inv_no | fin_docuemntno | varchar(18) | Yes | Supplier invoice number | 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 |
| bankcashcode | fin_bankcode | varchar(32) | Yes | Bank cash code | No |
| remarks | fin_txt255 | varchar(255) | Yes | Remarks | No |
| transfer_status | fin_status | varchar(25) | Yes | Transfer status | No |
| vat_incorporate_flag | fin_flag | varchar(25) | Yes | Vat incorporate flag | No |
| component_id | udd_componentid | varchar(90) | Yes | Component id | No |
| Forward_cover | fin_desc20 | varchar(20) | Yes | Forward cover | No |
| Fw_cov_flag | fin_desc20 | varchar(20) | Yes | Forward cover flag | No |
| Fw_cov_rate | fin_rate | numeric(13) | Yes | Forward cover rate | No |
| pay_priority | fin_flag1 | varchar(25) | Yes | Payment priority | No |
| supp_invoice_date | fin_date | datetime(8) | Yes | Supplier invoice date | No |
| pay_mode | fin_paymode | varchar(25) | Yes | Payment mode | No |
| pay_method | fin_method | varchar(30) | Yes | Payment method | No |
| pay_to_supp | fin_vendorcode | varchar(45) | Yes | Pay to supplier | No |
| taxdoc_flag | fin_designparamcode | varchar(5) | Yes | Tax document flag | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Tran_ou | fin_ouinstid | int(4) | Yes | Transaction OU | No |
| Tran_type | fin_cm_docdesc | varchar(100) | Yes | Transaction type | No |
| Tran_No | fin_documentno | varchar(40) | Yes | Transaction number | No |
| Pay_Ref_id | fin_documentno | varchar(40) | Yes | Payment reference ID | No |
| Pay_Ref_Details | fin_txt255 | varchar(255) | Yes | Payment reference details | No |
| Payment_Instructions | fin_txt255 | varchar(255) | Yes | Payment instructions | 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 : | si_invbrkup_dtl |
| Comment : | To store information of invoice breakup detail |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tran_ou | fin_ouinstid | int(4) | Yes | Transaction OU | No |
| tran_type | fin_cmntrantype | varchar(10) | Yes | Transaction type | No |
| tran_no | fin_documentnumber | varchar(18) | Yes | Transaction number | No |
| ref_doc_no | fin_documentnumber | varchar(18) | Yes | Reference document number | No |
| ref_doc_line_no | fin_lineno | int(4) | Yes | Reference document line number | No |
| order_no | fin_documentno | varchar(40) | Yes | Order no | No |
| order_line_no | fin_lineno | int(4) | Yes | Order line number | No |
| proposed_qty | fin_quantity | numeric(17) | Yes | Proposed quantity | No |
| proposed_amount | fin_amount | numeric(13) | Yes | Proposed amount | No |
| invoiced_qty | fin_quantity | numeric(17) | Yes | Invoiced quantity | No |
| invoiced_amount | fin_amount | numeric(13) | Yes | Invoiced amount | No |
| createddate | fin_date | datetime(8) | Yes | Created date | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | Created by | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | Modified by | No |
| modifieddate | fin_date | datetime(8) | Yes | Modified date | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Table Name : | si_line_dtl |
| Comment : | To store information of line detail |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tran_type | fin_cmntrantype | varchar(10) | No | Transaction type | No |
| tran_ou | fin_ouinstid | int(4) | No | Transaction OU | No |
| tran_no | fin_documentno | varchar(40) | No | Transaction number | No |
| line_no | fin_lineno | int(4) | No | Line number | No |
| row_type | fin_category | varchar(15) | No | Row type | No |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| lo_id | fin_loid | varchar(20) | Yes | lo id | No |
| ref_doc_type | fin_cmntrantype | varchar(10) | Yes | Reference document type | No |
| ref_doc_ou | fin_ouinstid | int(4) | Yes | Reference document OU | No |
| ref_doc_no | fin_docuemntno | varchar(18) | Yes | Reference document number | No |
| ref_doc_term_no | fin_termnumber | varchar(20) | Yes | Referemce document term number | 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 |
| uom | fin_uom | varchar(15) | Yes | UOM | No |
| item_qty | fin_quantity | numeric(17) | Yes | Item quantity | No |
| unit_price | fin_price | numeric(13) | Yes | Unit price | No |
| rate_per | fin_quantity | numeric(17) | Yes | Rate percent | No |
| item_amount | fin_amount | numeric(13) | Yes | Item amount | No |
| tax_amount | fin_amount | numeric(13) | Yes | Tax amount | No |
| disc_amount | fin_amount | numeric(13) | Yes | Discount amount | No |
| line_amount | fin_amount | numeric(13) | Yes | Line amount | No |
| capitalized_amount | fin_amount | numeric(13) | Yes | Capitalized amount | No |
| proposal_no | fin_documentnumber | varchar(18) | Yes | Proposal number | No |
| cap_doc_flag | fin_status | varchar(25) | Yes | Capitalized document flag | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | No |
| usage_id | fin_usageid | varchar(20) | Yes | Usage 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 |
| ref_no | fin_txt255 | varchar(255) | Yes | Reference number | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes |
| analysis_code | fin_analysiscode | varchar(5) | Yes | Analysis code | No |
| subanalysis_code | fin_subanalysiscode | varchar(5) | Yes | Sub analysis code | No |
| expchg_billed_val | fin_amount | numeric(13) | Yes | Expense charge billed value | No |
| expense_class | fin_quickcodes | varchar(25) | Yes | Expense class | No | |
| Table Name : | si_payment_dtl |
| Comment : | To store information of payment detail |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tran_type | fin_cmntrantype | varchar(10) | No | Transaction type | Yes |
| tran_no | fin_documentno | varchar(40) | No | Transaction number | Yes |
| term_no | fin_termnumber | varchar(20) | No | Term number | Yes |
| tran_ou | fin_ouinstid | int(4) | No | Transaction OU | Yes |
| due_date | fin_datetime | datetime(8) | Yes | Due date | No |
| due_amount_type | fin_dueamounttype | varchar(15) | Yes | Due amount type | No |
| due_precent | fin_amount | numeric(13) | Yes | Due percent | No |
| due_amount | fin_amount | numeric(13) | Yes | Due amount | No |
| disc_comp_amount | fin_amount | numeric(13) | Yes | Discount comp amount | No |
| disc_amount_type | fin_discountamounttype | varchar(15) | Yes | Discount amount type | No |
| disc_date | fin_datetime | datetime(8) | Yes | Discount date | No |
| disc_precent | fin_amount | numeric(13) | Yes | Discount percent | No |
| disc_amount | fin_amount | numeric(13) | Yes | Discount amount | No |
| penalty_precent | fin_amount | numeric(13) | Yes | Penalty percent | No |
| esr_ref_no | fin_participationid | varchar(30) | Yes | esr reference number | No |
| esr_coding_line | fin_reference_det2 | varchar(128) | Yes | esr coding line | No |
| base_due_amount | fin_amount | numeric(13) | Yes | Base due amount | No |
| base_disc_amount | fin_amount | numeric(13) | Yes | Base discount amount | No |
| lo_id | fin_loid | varchar(20) | Yes | lo id | 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_ou | fin_ouinstid | int(4) | No | Transaction OU | No |
| tran_type | fin_cmntrantype | varchar(10) | No | Transaction type | No |
| tran_no | fin_documentno | varchar(40) | No | Transaction number | No |
| term_no | fin_quickcodes | varchar(25) | Yes | Term number | No |
| amt_type | fin_type | varchar(25) | No | Amount type | No |
| dr_doc_ou | fin_ouinstid | int(4) | No | Debit document OU | No |
| dr_doc_type | fin_cmntrantype | varchar(10) | No | Debit document type | No |
| dr_doc_no | fin_documentnumber | varchar(18) | No | Debit document number | No |
| cr_doc_ou | fin_ouinstid | int(4) | No | Credit document OU | No |
| cr_doc_type | fin_cmntrantype | varchar(10) | No | Credit document type | No |
| cr_doc_no | fin_documentnumber | varchar(18) | No | Credit document number | No |
| cr_doc_term | fin_termnumber | varchar(20) | No | Credit document tem | No |
| dr_doc_term | fin_termnumber | varchar(20) | Yes | Debit document term | No |
| lo_id | fin_loid | varchar(20) | Yes | lo id | No |
| tran_date | fin_datetime | datetime(8) | Yes | Transaction date | No |
| supplier_code | fin_suppliercode | varchar(16) | Yes | Supplier code | No |
| tran_currency | fin_currency | varchar(5) | Yes | Transaction currency | No |
| tran_amount | fin_amount | numeric(13) | Yes | Transaction amount | No |
| exchange_rate | fin_exchangerate | numeric(9) | Yes | Exchange rate | No |
| basecur_erate | fin_amount | numeric(13) | Yes | Base currency exchange rate | No |
| par_exchange_rate | fin_exchangerate | numeric(9) | Yes | Parallel currency exchange rate | No |
| cross_curr_erate | fin_exchangerate | numeric(9) | Yes | Cross currency exchange rate | No |
| par_base_amount | fin_amount | numeric(13) | Yes | Parallel base amount | No |
| base_amount | fin_amount | numeric(13) | Yes | Base amount | No |
| posting_status | fin_status | varchar(25) | Yes | Posting status | No |
| posting_date | fin_datetime | datetime(8) | Yes | Paosting date | 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 |
| adjust_amount_inv_cur | fin_amount | numeric(13) | Yes | Adjust amount invoice currency | No |
| REPLICATION_KEY | bigint | Bigint(8) | No | REPLICATION KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Ouinstance ID | Yes |
| company_code | fin_companycode | varchar(10) | No | Company code | Yes |
| fb_id | fin_financebookid | varchar(20) | No | Finance book id | Yes |
| fin_year | fin_financeyear | varchar(15) | No | Financial year | Yes |
| fin_period | fin_financeperiod | varchar(15) | No | Financial period | Yes |
| supplier_code | fin_suppliercode | varchar(16) | No | Supplier code | Yes |
| account_code | fin_accountcode | varchar(32) | No | Account code | Yes |
| currency_code | fin_currencycode | varchar(5) | No | Currency code | Yes |
| balance_type | fin_currencycode | varchar(5) | No | Balance type | Yes |
| balance_currency | fin_currencycode | varchar(5) | No | Balance currency | Yes |
| account_type | fin_account_type | varchar(10) | Yes | Account type | No |
| ob_credit | fin_amount | numeric(13) | Yes | Opening balance credit | No |
| ob_debit | fin_amount | numeric(13) | Yes | Opening balance debit | No |
| period_credit | fin_amount | numeric(13) | Yes | Period credit | No |
| period_debit | fin_amount | numeric(13) | Yes | Period debit | No |
| cb_credit | fin_amount | numeric(13) | Yes | Closing balance credit | No |
| cb_debit | fin_amount | numeric(13) | Yes | Closing balance debit | No |
| created_by | fin_ctxt_user | varchar(30) | Yes | Created by | No |
| created_date | fin_datetime | datetime(8) | Yes | Created date | No |
| last_modified_by | fin_ctxt_user | varchar(30) | Yes | Last modified by | No |
| last_modified_date | fin_datetime | datetime(8) | Yes | Last modified date | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | Createdby | No |
| createddate | fin_datetime | datetime(8) | Yes | Createddate | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | Modifiedby | No |
| modifieddate | fin_datetime | datetime(8) | Yes | Modifieddate | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| guid | fin_guid | varchar(40) | Yes | Guid | No |
| supplier_code | fin_suppliercode | varchar(16) | Yes | Supplier code | No |
| currency | fin_currency | varchar(5) | Yes | Currency | No |
| tran_type | fin_cmntrantype | varchar(10) | Yes | Transaction type | No |
| tran_descr | fin_desc40 | varchar(40) | Yes | Transaction description | No |
| tran_amount | fin_amount | numeric(13) | Yes | Transaction amount | No |
| tran_date | fin_datetime | datetime(8) | No | Transaction date | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| tran_ou | fin_ouinstid | int(4) | Yes | transaction OU | No |
| tran_no | fin_documentno | varchar(40) | Yes | Transaction Number | No |
| tran_type | fin_type | varchar(25) | Yes | Transaction Type | No |
| tran_date | fin_date | datetime(8) | Yes | Transaction Date | No |
| tran_currency | fin_currency | varchar(5) | Yes | Transaction 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 Exchange rate | No |
| termno | fin_quickcodes | varchar(25) | Yes | Term Number | No |
| ref_doc_adjamt_crcurr | fin_amount | numeric(13) | Yes | Reference Document Adjust Amount Credit Currency | No |
| tcd_code | fin_itemcode | varchar(40) | Yes | TCD Code | No |
| tcd_var_code | fin_itemcode | varchar(40) | Yes | TCD Variant Code | No |
| 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 Exchange rate Date | 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 Exchange Rate | 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 TaxBase Amount | No |
| tax_erate_type | fin_quickcodes | varchar(25) | Yes | Exchange Rate Type | No |
| tax_acct_event | fin_quickcodes | varchar(25) | Yes | Acctual Event | No |
| tax_acct_ert_ref | fin_quickcodes | varchar(25) | Yes | Acctual Ert Reference | No |
| debit_doc | fin_flag | varchar(25) | Yes | Debit Document | No |
| prov_adj_flag | fin_flag | varchar(25) | Yes | Provide Adjust Flag | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch Id | No |
| paybatch_no | fin_documentno | varchar(40) | Yes | Pay Batch number | No |
| tax_prov_entry_reqd | fin_flag | varchar(25) | Yes | Tax Provide Entry Request | No |
| tcd_line_no | fin_lineno | int(4) | Yes | Tcd Line Number | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | Cost Center | No |
| analysis_code | fin_analysiscode | varchar(5) | Yes | Analysis Code | No |
| subanalysis_code | fin_analysiscode | varchar(5) | Yes | Subanlysis Code | No |
| tax_invoiced | fin_flag | varchar(25) | Yes | Tax Invoiced | No |
| replication_key | uniqueidentifier | Varchar(160) | No | Replication key | Yes |