|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| AC_USGDEPD_DTL_MANUF_PART_NO | udd_partno | varchar(40) | Yes | This Column Stores the Manufacturer Part Number. | No |
| AC_USGDEPD_DTL_MANUF_SERIAL_NO | udd_partserialnumber | varchar(40) | Yes | This Column Stores the Manufacturer Serial Number. | No |
| AC_USGDEPD_DTL_MANUFACTURER_NO | udd_partno | varchar(40) | Yes | This Column Stores the Manufacturer Number. | No |
| AC_USGDEPD_DTL_OU_COMPONENT | udd_componentid | varchar(90) | Yes | This Column Stores the OU Component Details. | No |
| AC_USGDEPD_DTL_OU_PART_NO | udd_partno | varchar(40) | Yes | This Column Stores the OU Part Number. | No |
| AC_USGDEPD_DTL_OU_SERIAL_NO | udd_partserialnumber | varchar(40) | Yes | This Column Stores the OU Serial Number. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| ou_id | fin_ctxt_ouinstance | int(4) | Yes | Organization unit id | No |
| tran_number | fin_transactionnumber | varchar(18) | Yes | Transaction number | No |
| asset_number | fin_assetnumber | varchar(18) | Yes | Asset number | No |
| tag_number | fin_assettagno | int(4) | Yes | Tag number | No |
| tran_type | fin_transactiontype | varchar(40) | Yes | Transaction type | No |
| tran_date | fin_datetime | datetime(8) | Yes | Transaction date | No |
| posting_date | fin_datetime | datetime(8) | Yes | Posting date | No |
| account_code | fin_accountcode | varchar(32) | Yes | Account code | No |
| drcr_flag | fin_drcridentifier | varchar(6) | Yes | Debit credit flag | No |
| currency | fin_currencycode | varchar(5) | Yes | Currency | No |
| tran_amount | fin_amount | numeric(13) | Yes | Transaction amount | No |
| fb_id | fin_financebookid | varchar(20) | Yes | Finance book amount | 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 |
| bc_erate | fin_exchangerate | numeric(9) | Yes | Base currency exchange rate | No |
| base_amount | fin_amount | numeric(13) | Yes | Base amount | No |
| pbc_erate | fin_exchangerate | numeric(9) | Yes | Parallel base currency exchange rate | No |
| pbase_amount | fin_amount | numeric(13) | Yes | Parallel base amount | No |
| account_type | fin_accounttype | varchar(15) | Yes | Account type | No |
| ussage_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 |
| newast_flag | fin_designparamcode | varchar(5) | Yes | New asset flag | No |
| asset_class | fin_assetclass | varchar(20) | Yes | Asset class | No |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes |
| remarks | fin_comments | Varchar(255) | Yes | remarks | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| guid | fin_guid | varchar(40) | Yes | Guid | No |
| ou_id | fin_ctxt_ouinstance | int(4) | Yes | Organization unit id | No |
| asset_number | fin_assetnumber | varchar(18) | Yes | Asset number | No |
| asset_desc | fin_desc40 | varchar(40) | Yes | Asset description | No |
| tag_number | fin_assettagno | int(4) | Yes | Tag number | No |
| tag_desc | fin_desc40 | varchar(40) | Yes | Tag description | No |
| transfer_number | fin_documentnumber | varchar(18) | Yes | Transfer number | No |
| transfer_date | fin_datetime | datetime(8) | Yes | Transfer date | No |
| tag_cost | fin_amount | numeric(13) | Yes | Tag cost | No |
| cum_depr_amount | fin_amount | numeric(13) | Yes | Cumulative depreciation amount | No |
| asset_book_value | fin_amount | numeric(13) | Yes | Asset book value | No |
| source_fb | fin_financebookid | varchar(20) | Yes | Source finance book | No |
| destination_fb | fin_financebookid | varchar(20) | Yes | Destination finance book | No |
| transfer_status | fin_status | varchar(25) | Yes | Transfer status | 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? |
| guid | fin_guid | varchar(40) | No | Guid | Yes |
| ou_id | fin_ctxt_ouinstance | int(4) | No | Organization unit id | Yes |
| asset_number | fin_assetnumber | varchar(18) | No | Asset number | Yes |
| tag_number | fin_assettagno | int(4) | No | Tag number | Yes |
| fb_id | fin_financebookid | varchar(20) | No | Finance book id | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| cap_number | fin_documentnumber | varchar(18) | Yes | Capitalized amount | No |
| proposal_number | fin_documentnumber | varchar(18) | Yes | Proposal number | No |
| tag_status | fin_statuscode | varchar(2) | Yes | Tag status | No |
| dest_fbid | fin_financebookid | varchar(20) | Yes | Destination finance boo id | No |
| transfer_date | fin_datetime | datetime(8) | Yes | Transfer date | No |
| asset_location | fin_assetlocation | varchar(20) | Yes | Asset location | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | Cost center | 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? |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| ou_id | fin_ctxt_ouinstance | int(4) | Yes | Organization unit id | No |
| notes_desc | fin_notes | varchar(2000) | Yes | Notes desription | No |
| transfer_no | fin_documentnumber | varchar(18) | Yes | Transfer number | No |
| retirement_no | fin_documentnumber | varchar(18) | Yes | Retirement number | No |
| reversal_no | fin_documentnumber | varchar(18) | Yes | Reversal 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 |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| ou_id | fin_ctxt_ouinstance | int(4) | Yes | Organization unit id | No |
| notes_desc | fin_notes | varchar(2000) | Yes | Notes desription | No |
| transfer_no | fin_documentnumber | varchar(18) | Yes | Transfer number | No |
| retirement_no | fin_documentnumber | varchar(18) | Yes | Retirement number | No |
| reversal_no | fin_documentnumber | varchar(18) | Yes | Reversal 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 |
| REPLICATION_KEY | fin_bigint | Bigint(8) | No | REPLICATION_KEY | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ctxt_ouinstance | int(4) | No | Organization unit id | Yes |
| parameter_type | fin_param_type | varchar(6) | No | Parameter type | Yes |
| parameter_category | fin_param_categ | varchar(16) | No | Parameter category | Yes |
| parameter_code | fin_param_code | varchar(6) | No | Parameter code | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| parameter_text | fin_param_text | varchar(255) | Yes | Parameter text | 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? |
| asset_number | fin_assetnumber | varchar(18) | No | Asset number | Yes |
| tag_number | fin_assettagno | int(4) | No | Tag number | Yes |
| ou_id | fin_ctxt_ouinstance | int(4) | No | Organization unit id | Yes |
| retirement_number | fin_documentnumber | varchar(18) | No | Retirement number | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| asset_location | fin_assetlocation | varchar(20) | Yes | Asset location | No |
| asset_class | fin_assetclass | varchar(20) | Yes | Asset class | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | Cost center | No |
| asset_cost | fin_amount | numeric(13) | Yes | Asset cost | No |
| cum_depr_amount | fin_amount | numeric(13) | Yes | Cumulative depreciation amount | No |
| asset_book_value | fin_amount | numeric(13) | Yes | Asset book value | No |
| retirement_mode | fin_type | varchar(25) | Yes | Retirement mode | No |
| retirement_date | fin_datetime | datetime(8) | Yes | Retirement date | No |
| customer | fin_customer_id | varchar(18) | Yes | Customer | No |
| claim_insurance | fin_yesnoen | varchar(10) | Yes | Claim insurance | No |
| sale_value | fin_amount | numeric(13) | Yes | Sale value | No |
| gain_loss | fin_amount | numeric(13) | Yes | Gain loss | No |
| remarks | fin_remarks | varchar(100) | Yes | Remarks | No |
| tag_status | fin_statuscode | varchar(2) | Yes | Tag status | No |
| reversal_number | fin_documentnumber | varchar(18) | Yes | Reversal number | No |
| reverse_remarks | fin_remarks | varchar(100) | Yes | Reverse remarks | No |
| invoice_number | fin_documentnumber | varchar(18) | Yes | Invoice number | 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 |
| cap_mnt_exp | fin_amount | numeric(13) | Yes | capital maintenance expenditure | No |
| cme_cum_depr_charge | fin_amount | numeric(13) | Yes | capital maintenance expenditure cumulative depreciation charge | No |
| cme_book_val | fin_amount | numeric(13) | Yes | capital maintenance expenditure book value | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ctxt_ouinstance | int(4) | No | Organization unit id | Yes |
| retirement_number | fin_documentnumber | varchar(18) | No | Retirement number | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| retirement_date | fin_datetime | datetime(8) | Yes | Retirement date | No |
| fb_id | fin_buid | varchar(20) | Yes | Finance book id | No |
| num_type | fin_notypeno | varchar(10) | Yes | Numbering type | No |
| pay_category | fin_paycategory | varchar(40) | Yes | Payment category | No |
| proposal_number | fin_documentnumber | varchar(18) | Yes | Proposal number | No |
| gen_auth_invoice | fin_yesnoen | varchar(10) | Yes | Author invoice | No |
| retirement_status | fin_status | varchar(25) | Yes | Retirement status | 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 |
| currency_code | fin_currencycode | varchar(5) | Yes | Currency code | No | |
| Table Name : | adisp_retire_refdoc_dtl |
| Comment : | History Table For Asset Retirement through Confirmation of SCRAP NOTE |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ctxt_ouinstance | int(4) | Yes | Transaction Operating Unit | No |
| asset_number | fin_assetnumber | varchar(18) | Yes | Asset Number | No |
| tag_number | fin_tag | varchar(25) | Yes | Tag Numbers of the Asset | No |
| Part_Number | fin_partno | varchar(40) | Yes | Part Number of the Part Scrapped | No |
| Serial_Number | fin_partserialnumber | varchar(40) | Yes | Part Serial Number | No |
| Inv_status | fin_status | varchar(25) | Yes | Inventory status updates as resullt of scrapping | No |
| retirement_date | fin_date | datetime(8) | Yes | Asset Retirement Date | No |
| retire_refdoc_date | fin_date | datetime(8) | Yes | Retirement Reference Document date | No |
| retire_refdoc_no | fin_documentno | varchar(40) | Yes | Retirement Reference Document Number | No |
| retire_refdoc_type | fin_quickcodes | varchar(25) | Yes | Retirement Reference Document Type | No |
| created_date | fin_datetime | datetime(8) | Yes | Created Date | No |
| created_by | fin_ctxt_user | varchar(30) | Yes | Created By | No |
| sl_no | udd_integer | varchar(30) | No | Serial Number | Yes | |
| Table Name : | adisp_ret_rep_dtl |
| Comment : | To store information of retirement report detail |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| guid | fin_guid | varchar(40) | Yes | Guid | No |
| ou_id | fin_ctxt_ouinstance | int(4) | Yes | Organization unit id | No |
| asset_number | fin_assetnumber | varchar(18) | Yes | Asset number | No |
| tag_number | fin_assettagno | int(4) | Yes | Tag number | No |
| tag_cost | fin_amount | numeric(13) | Yes | Tag cost | No |
| asset_desc | fin_desc40 | varchar(40) | Yes | Asset description | No |
| tag_desc | fin_desc40 | varchar(40) | Yes | Tag description | No |
| retirement_number | fin_documentnumber | varchar(18) | Yes | Retirement number | No |
| retirement_date | fin_datetime | datetime(8) | Yes | Retirement date | No |
| proposal_number | fin_documentnumber | varchar(18) | Yes | Proposal number | No |
| asset_book_value | fin_amount | numeric(13) | Yes | Asset book value | No |
| sale_value | fin_amount | numeric(13) | Yes | Sale value | No |
| gain_loss | fin_amount | numeric(13) | Yes | Gain loss | No |
| cum_depr | fin_amount | numeric(13) | Yes | Cumulative depreciation | No |
| reval_cost | fin_amount | numeric(13) | Yes | Revalue cost | No |
| reval_cum_depr | fin_amount | numeric(13) | Yes | Revalue cumulative depreciation | 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? |
| asset_number | fin_assetnumber | varchar(18) | No | Asset number | Yes |
| tag_number | fin_assettagno | int(4) | No | Tag number | Yes |
| ou_id | fin_ctxt_ouinstance | int(4) | No | Organization unit id | Yes |
| reversal_number | fin_documentnumber | varchar(18) | No | Reversal number | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| asset_location | fin_assetlocation | varchar(20) | Yes | Asset location | No |
| asset_class | fin_assetclass | varchar(20) | Yes | Asset class | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | Cost center | No |
| asset_cost | fin_amount | numeric(13) | Yes | Asset cost | No |
| cum_depr_amount | fin_amount | numeric(13) | Yes | Cumulative depreciation amount | No |
| asset_book_value | fin_amount | numeric(13) | Yes | Asset book value | No |
| retirement_mode | fin_type | varchar(25) | Yes | Retirement mode | No |
| retirement_date | fin_datetime | datetime(8) | Yes | Retirement date | No |
| customer | fin_customer_id | varchar(18) | Yes | Customer | No |
| claim_insurance | fin_yesnoen | varchar(10) | Yes | Claim insurance | No |
| sale_value | fin_amount | numeric(13) | Yes | Sale value | No |
| gain_loss | fin_amount | numeric(13) | Yes | Gain loss | No |
| remarks | fin_remarks | varchar(100) | Yes | Remarks | No |
| tag_status | fin_statuscode | varchar(2) | Yes | Tag status | 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 |
| cap_mnt_exp | fin_amount | numeric(13) | Yes | capital maintenance expenditure | No |
| cme_cum_depr_charge | fin_amount | numeric(13) | Yes | capital maintenance expenditure cumulative depreciation charge | No |
| cme_book_val | fin_amount | numeric(13) | Yes | capital maintenance expenditure book value | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ctxt_ouinstance | int(4) | No | Organization unit id | Yes |
| reversal_number | fin_documentnumber | varchar(18) | No | Reversal number | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| reversal_date | fin_datetime | datetime(8) | Yes | Reversal date | No |
| fb_id | fin_buid | varchar(20) | Yes | Finance book id | No |
| num_type | fin_notypeno | varchar(10) | Yes | Numbering type | No |
| reversal_status | fin_statuscode | varchar(2) | Yes | Reversal status | 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? |
| transfer_number | fin_documentnumber | varchar(18) | No | Transfer number | Yes |
| ou_id | fin_ctxt_ouinstance | int(4) | No | Organization unit id | Yes |
| asset_number | fin_assetnumber | varchar(18) | No | Asset number | Yes |
| tag_number | fin_assettagno | int(4) | No | Tag number | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| asset_grp | fin_group | varchar(25) | Yes | Asset group | No |
| asset_class | fin_assetclass | varchar(20) | Yes | Asset class | No |
| asset_location | fin_assetlocation | varchar(20) | Yes | Asset location | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | Cost center | No |
| asset_cost | fin_amount | numeric(13) | Yes | Asset cost | No |
| cum_depr_amount | fin_amount | numeric(13) | Yes | Cumulative depreciation amount | No |
| asset_book_value | fin_amount | numeric(13) | Yes | Asset book value | No |
| remarks | fin_remarks | varchar(100) | Yes | Remarks | No |
| receiving_location | fin_assetlocation | varchar(20) | Yes | Receiving location | No |
| receiving_cost_center | fin_costcentercode | varchar(10) | Yes | Receiving cost center | No |
| receipt_remarks | fin_remarks | varchar(100) | Yes | Receipt remarks | No |
| transfer_status | fin_status | varchar(25) | Yes | Transfer status | 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 |
| depr_category | fin_deprcategory | varchar(40) | Yes | Depreciation category | No |
| src_assetclass | fin_assetclass | varchar(20) | Yes | Source asset class | No |
| new_assetno | fin_assetnumber | varchar(18) | Yes | New asset number | No |
| new_tagno | fin_assettagno | int(4) | Yes | New tag number | No |
| cme_bookvalue | fin_amount | numeric(13) | Yes | Capital Maintanence Expenditure Book Value. | No |
| cme_cost | fin_amount | numeric(13) | Yes | Capital Maintanence Expenditure Cost. | No |
| cme_cum_dep | fin_amount | numeric(13) | Yes | Capital Maintanence Expenditure Cumulative depreciation. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ctxt_ouinstance | int(4) | No | Organization unit id | Yes |
| transfer_number | fin_documentnumber | varchar(18) | No | Transfer number | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| transfer_date | fin_datetime | datetime(8) | Yes | Transfer date | No |
| transfer_status | fin_status | varchar(25) | Yes | Transfer status | No |
| num_type | fin_notypeno | varchar(10) | Yes | Numbering type | No |
| source_fb_id | fin_financebookid | varchar(20) | Yes | Source financebook id | No |
| destination_fb_id | fin_financebookid | varchar(20) | Yes | Destination finance book id | No |
| confirmation_date | fin_datetime | datetime(8) | Yes | Confirmation date | 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 |
| transfer_type | fin_designparamcode | varchar(5) | Yes | Transfer type | No |