| Data Dictionary -- Legacy Data Upload | ||||||||
| Srl. No. | Table Name | Comment |
| 1 | ldu_upload_dtl | Legacy data upload |
| Table Name : | |
| Comment : | Legacy data upload |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | Organization Unit ID | Yes |
| fb_id | fin_financebookid | varchar(20) | No | Finance Book ID | Yes |
| finance_year | fin_financeyear | varchar(15) | No | Financial Year | Yes |
| finance_period | fin_financeperiod | varchar(15) | No | Financial Period | Yes |
| account_code | fin_accountcode | varchar(32) | No | Account Code | Yes |
| timestamp | int | int(4) | No | Timestamp | No |
| currency_code | fin_currencycode | varchar(5) | Yes | Currency Code | No |
| drcr_flag | fin_drcridentifier | varchar(6) | Yes | Debit Credit Flag | No |
| base_amount | fin_amount | numeric(13) | Yes | Base Amount | No |
| tran_amount | fin_amount | numeric(13) | Yes | Transaction Amount | 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 |