|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization unit id | Yes |
| tran_no | fin_transactionnumber | varchar(18) | No | Trasaction number | Yes |
| tran_type | fin_transactiontype | varchar(40) | No | Transaction type | Yes |
| acct_lineno | fin_lineno | int(4) | No | Account line no | Yes |
| fb_id | fin_financebookid | varchar(20) | No | Finance book id | Yes |
| acc_code | fin_accountcode | varchar(32) | No | Account code | Yes |
| drcr_flag | fin_drcridentifier | varchar(6) | No | Debit credit flag | Yes |
| timestamp | int | int(4) | Yes | Timestamp | No |
| acct_type | fin_account_type | varchar(10) | Yes | Account type | No |
| fin_post_date | datetime | Datetime(8) | Yes | Finance post date | No |
| currency | fin_currencycode | varchar(5) | Yes | Currency code | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | Cost center | No |
| tran_amt | fin_amount | numeric(13) | Yes | Transaction amount | No |
| business_unit | fin_buid | varchar(20) | Yes | Business unit id | No |
| analysis_code | fin_analysiscode | varchar(5) | Yes | Analysis code | No |
| sub_analysis_code | fin_subanalysiscode | varchar(5) | Yes | Subanalysis code | No |
| base_cur_exrate | fin_exchangerate | numeric(9) | Yes | Base currency exchange rate | No |
| base_amt | fin_amount | numeric(13) | Yes | Base amount | No |
| par_base_cur_exrate | fin_exchangerate | numeric(9) | Yes | Parallel base currency exchange rate | No |
| par_base_amt | fin_amount | numeric(13) | Yes | Parallel currency base amount | 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 | datetime | Datetime(8) | Yes | Created date | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | Modified by | No |
| modifieddate | datetime | Datetime(8) | Yes | Modified date | No | |
| Table Name : | sr_notes_dtl |
| Comment : | Supplier receipt notes detail table |
|
| 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_type | fin_cmbflag | varchar(4) | No | Receipt type | 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 |
| timestamp | 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 | datetime | Datetime(8) | Yes | Created date | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | Modified by | No |
| modifieddate | datetime | Datetime(8) | Yes | Modified date | No | |
| 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 | int | int(4) | Yes | Timestamp | No |
| origin_no | fin_documentnumber | varchar(18) | Yes | Origin number | No |
| receipt_date | datetime | Datetime(8) | Yes | Receipt date | No |
| fb_id | fin_financebookid | varchar(20) | Yes | Finance book id | No |
| notype_no | fin_notypeno | varchar(10) | Yes | notype no | No |
| receipt_status | fin_statuscode | varchar(2) | Yes | Receipt status | No |
| supplier_code | fin_suppliercode | varchar(16) | Yes | Supplier code | No |
| receipt_route | fin_cmbflag | varchar(4) | Yes | Receipt route | No |
| receipt_method | fin_cmbflag | varchar(4) | Yes | Receipt method | No |
| receipt_mode | fin_cmbflag | varchar(4) | Yes | Receipt mode | 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_bef_roff | fin_amount | numeric(13) | Yes | Receipt amount before rounding off | No |
| receipt_amount | fin_amount | numeric(13) | Yes | Receipt amount | No |
| apply | fin_cmbflag | varchar(4) | Yes | Apply | No |
| remarks | fin_txt255 | 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 | datetime | Datetime(8) | Yes | Instrument date | No |
| instr_status | fin_status | varchar(25) | Yes | Instrument status | No |
| bank_code | fin_bankcode | varchar(32) | Yes | Bank code | No |
| charges | fin_amount | numeric(13) | Yes | Charges | No |
| ref_no | fin_documentno | varchar(40) | Yes | Reference no | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | Cost center | No |
| analysis_code | fin_analysiscode | varchar(5) | Yes | Analysis code | No |
| sub_analysis_code | fin_subanalysiscode | varchar(5) | Yes | Subanalysis code | No |
| reason_code | fin_reasoncode | varchar(10) | Yes | Reason code | No |
| rr_flag | fin_cmbflag | varchar(4) | Yes | rr_flag | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | No |
| pbcexchrate | fin_exchangerate | numeric(9) | Yes | Parallel base currency exchange rate | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | Created by | No |
| createddate | datetime | Datetime(8) | Yes | Created date | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | Modified by | No |
| modifieddate | datetime | Datetime(8) | Yes | Modified date | No |