|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CRD_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Comp Replacement OU Instance | Yes |
| CRD_ROTABLEREPLCMTNO | _varchar_40 | varchar(40) | No | Component Replacement No | Yes |
| CRD_POSITIONCODE | _varchar_25 | Varchar(25) | Yes | Position Code in the Configuration F - "Free Positions" A - "All" | No |
| CRD_SORCDOCTYPE | _varchar_5 | varchar(5) | Yes | Source Doc Type LMW - " LINE WORK ORDER" TCHLG - "TECHNICAL LOG" CWO - "COMPONENT WORK ORDER" HWO - "HANGAR WORK ORDER" O - "OTHERS" | No |
| CRD_SOURCEDOCUMENTNO | _varchar_40 | varchar(40) | Yes | Source Document No | No |
| CRD_STATIONCODE | _varchar_32 | varchar(32) | Yes | Station Code where CR has been recorded. | No |
| CRD_AIRCRAFTCODE | _varchar_30 | varchar(30) | Yes | Aircraft Registration Number. | No |
| CRD_NHACOMPONENTID | _varchar_90 | varchar(90) | Yes | NHA (Next Higher Assembly) Component ID | No |
| CRD_REMOVEDCOMPONENTID | _varchar_90 | varchar(90) | Yes | Removed Component Id | No |
| CRD_ITEMTAGNO | _varchar_40 | varchar(40) | Yes | Tag No | No |
| CRD_PROCESSACTION | _varchar_5 | varchar(5) | Yes | Process Action tasken. | No |
| CRD_ROTABLEREMBY | _varchar_15 | varchar(15) | Yes | Replacement Created by. | No |
| CRD_REMOVALDATE | _datetime_8 | datetime(8) | Yes | Removal Date. | No |
| CRD_REMOVALTIME | _datetime_8 | datetime(8) | Yes | Removal Time. | No |
| CRD_REMTYPE | _varchar_5 | varchar(5) | Yes | Removal Type. | No |
| CRD_BASREMOVAL | _varchar_5 | varchar(5) | Yes | Basic Removal (Yes/No) | No |
| CRD_REASONFORREPL | _varchar_25 | Varchar(25) | Yes | Reason for Removal. | No |
| CRD_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks. | No |
| CRD_SOURCEOFPART | _varchar_5 | varchar(5) | Yes | Source of Installed Part | No |
| CRD_INCOMINGCOMPONENTID | _varchar_90 | varchar(90) | Yes | Incoming Component Id. | No |
| CRD_INSTALLATIONDATE | _datetime_8 | datetime(8) | Yes | Installation Date. | No |
| CRD_INSTALLATIONTIME | _datetime_8 | datetime(8) | Yes | Installation Time. | No |
| CRD_INSTALLEDBY | _varchar_30 | varchar(30) | Yes | Installaed by. | No |
| CRD_STATUS | _varchar_5 | varchar(5) | Yes | Status of Replacement. | No |
| CRD_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created by. | No |
| CRD_CREATION_DATE | _datetime_8 | datetime(8) | Yes | Creation Date. | No |
| CRD_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified by. | No |
| CRD_MODIFICATION_DATE | _datetime_8 | datetime(8) | Yes | Modification Date. | No |
| CRD_REMCONFIRMEDBY | _varchar_30 | varchar(30) | Yes | Removal Confirmed by. | No |
| CRD_REMCONFIRMEDDATE | _datetime_8 | datetime(8) | Yes | Removal Confirmation Date. | No |
| CRD_REPLCONFIRMEDBY | _varchar_30 | varchar(30) | Yes | Replacement Confirmed by. | No |
| CRD_REPLCONFIRMEDDATE | _datetime_8 | datetime(8) | Yes | Replacement Confirmed date. | No |
| CRD_REVERSEBY | _varchar_30 | varchar(30) | Yes | Replacement Reversed by. | No |
| CRD_REVERSEDATE | _datetime_8 | datetime(8) | Yes | Replacement Reversal Date. | No |
| CRD_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | TimeStamp of the Record. | No |
| CRD_REMCOMPCREATEDOU | _decimal_10_0 | decimal(10) | Yes | OUInatance. | No |
| CRD_INSTALLCOMPCREATEDOU | _decimal_10_0 | decimal(10) | Yes | OUInstance. | No |
| CRD_OUTPARTNO | _varchar_40 | varchar(40) | Yes | Outgoing Part Number. | No |
| CRD_OUTPARTSERIALNO | _varchar_40 | varchar(40) | Yes | Outgoing Serial Number. | No |
| CRD_ATANUMBER | _varchar_16 | varchar(16) | Yes | Ata Number. | No |
| CRD_REMOVALDATEUTC | _datetime_8 | datetime(8) | Yes | UTC Removal Date. | No |
| CRD_REMOVALTIMEUTC | _datetime_8 | datetime(8) | Yes | UTC Removal Time. | No |
| CRD_INSTALLATIONDATEUTC | _datetime_8 | datetime(8) | Yes | UTC Installation Date. | No |
| CRD_INSTALLATIONTIMEUTC | _datetime_8 | datetime(8) | Yes | UTC Installation Time. | No |
| CRD_NOTYPENO | _varchar_5 | varchar(5) | Yes | Numbering type of the CR. | No |
| CRD_WF_NEW_STATE | _varchar_15 | varchar(15) | Yes | Work Flow Status. | No |
| CRD_WF_DOC_KEY | _varchar_128 | varchar(128) | Yes | Work Document Kay. | No |
| CRD_ATTACHSTATUS_REM | _varchar_25 | Varchar(25) | Yes | Attachment Status. | No |
| CRD_ATTACHSTATUS_INST | _varchar_25 | Varchar(25) | Yes | CR attachment status | No |
| CRD_RECORDMODE | _varchar_25 | Varchar(25) | Yes | Replacement Record Mode. | No |
| CRD_COMMENTS | _varchar_255 | varchar(255) | Yes | CR Comments. | No |
| crd_wrnty_procsd | udd_txt5 | varchar(5) | Yes | crd_wrnty_procsd | No |
| CRD_RETURN_FLAG | udd_designparamcode | varchar(5) | Yes | Return flag | No |
| CRD_SOSDISP | udd_designparamcode | varchar(5) | Yes | sos disposition | No |
| CRD_SOS_INITIATED_DATETIME | _datetime_8 | datetime(8) | Yes | initiated date and time | No |
| CRD_SOS_INITIATED_BY | udd_ctxt_user | varchar(30) | Yes | initiated by | No |
| CRD_SOS_DURATION | udd_schvalue | numeric(13) | Yes | sos duration | No |
| CRD_SOS_DURATION_UOM | udd_designparamcode | varchar(5) | Yes | duration in unit of measurement | No |
| CRD_SOS_DUEDATETIME | _datetime_8 | datetime(8) | Yes | due date | No |
| CRD_SOS_REF_DTL | udd_txt255 | varchar(255) | Yes | SOS Reference Detail | No |
| CRD_SOS_REMARKS | udd_txt255 | varchar(255) | Yes | remarks | No |
| CRD_INCOMINGPARTNO | udd_partno | varchar(40) | Yes | attached partno | No |
| CRD_INCOMINGPARTSERIALNO | udd_partserialnumber | varchar(40) | Yes | attached serial no | No |
| CRD_SOS_CF_NFF_UPDATE_DATE | _datetime_8 | datetime(8) | Yes | SOS Updated date | No |
| CRD_SOS_CF_NFF_UPDATE_BY | udd_ctxt_user | varchar(30) | Yes | SOS Updated by | No |
| CRD_ACCEPTANCEREF | udd_txt255 | varchar(255) | Yes | Acceptance Ref | No |
| crd_effectivitynotes | udd_txt2000 | varchar(2000) | Yes | crd_effectivitynotes | No |
| CRD_INCOMINGMFRNO | _Varchar_40 | varchar(40) | Yes | Incoming Mfr no | No |
| CRD_INCOMINGMFRPARTNO | _Varchar_45 | varchar(45) | Yes | Incoming Part no | No |
| CRD_OUTMFRNO | _Varchar_40 | varchar(40) | Yes | Removal Mfr no | No |
| CRD_OUTMFRPARTNO | _Varchar_45 | varchar(45) | Yes | Removal Mfr.Partno | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CRHIS_OUINSTANCE | _decimal_9_0 | decimal(9) | No | ouinstance | Yes |
| CRHIS_ROTABLEREPLCMTNO | udd_documentno | varchar(40) | No | replacementno | Yes |
| CRHIS_HISSEQNO | udd_seqno | int(4) | No | seq no | Yes |
| CRHIS_POSITIONCODE | udd_flag | varchar(25) | Yes | position code of the attached part | No |
| CRHIS_SORCDOCTYPE | udd_flag | varchar(25) | Yes | source document type | No |
| CRHIS_SOURCEDOCUMENTNO | udd_documentno | varchar(40) | Yes | source documentno | No |
| CRHIS_STATIONCODE | udd_oucode | varchar(32) | Yes | Station Code | No |
| CRHIS_AIRCRAFTCODE | udd_aircraftnumber | varchar(30) | Yes | aircraft code | No |
| CRHIS_NHACOMPONENTID | udd_componentid | varchar(90) | Yes | next high assemb of the component | No |
| CRHIS_REMOVEDCOMPONENTID | udd_componentid | varchar(90) | Yes | Removed Component Id | No |
| CRHIS_OUTPARTNO | udd_partno | varchar(40) | Yes | removel part | No |
| CRHIS_OUTPARTSERIALNO | udd_partserialnumber | varchar(40) | Yes | removal serial | No |
| CRHIS_ATANUMBER | udd_atanumber | varchar(16) | Yes | Ata Number. | No |
| CRHIS_PROCESSACTION | udd_designparamcode | varchar(5) | Yes | process action | No |
| CRHIS_ROTABLEREMBY | _varchar_15 | varchar(15) | Yes | removed by | No |
| CRHIS_REMOVALDATE | _datetime_8 | datetime(8) | Yes | removal date | No |
| CRHIS_REMOVALTIME | _datetime_8 | datetime(8) | Yes | removal time | No |
| CRHIS_REASONFORREPL | udd_flag | varchar(25) | Yes | Reason for removal. | No |
| CRHIS_INCOMINGCOMPONENTID | udd_componentid | varchar(90) | Yes | Incoming component id | No |
| CRHIS_INCOMINGPARTNO | udd_partno | varchar(40) | Yes | Incoming part no | No |
| CRHIS_INCOMINGPARTSERIALNO | udd_partserialnumber | varchar(40) | Yes | Incoming serial no | No |
| CRHIS_INSTALLATIONDATE | _datetime_8 | datetime(8) | Yes | Installation date | No |
| CRHIS_INSTALLATIONTIME | _datetime_8 | datetime(8) | Yes | Installation Time. | No |
| CRHIS_INSTALLEDBY | udd_ctxt_user | varchar(30) | Yes | Installed by | No |
| CRHIS_STATUS | udd_designparamcode | varchar(5) | Yes | Status of Replacement. | No |
| CRHIS_REMARKS | udd_txt255 | varchar(255) | Yes | Remarks | No |
| CRHIS_RECORDMODE | udd_flag | varchar(25) | Yes | Record mode | No |
| CRHIS_CREATED_BY | udd_ctxt_user | varchar(30) | Yes | Created by. | No |
| CRHIS_CREATION_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| CRHIS_MODIFIED_BY | udd_ctxt_user | varchar(30) | Yes | Modified by. | No |
| CRHIS_MODIFICATION_DATE | _datetime_8 | datetime(8) | Yes | Modified date | No |
| CRHIS_MODIFIED_SRC | udd_ctxt_service | varchar(32) | Yes | Modified Source | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| nrd_ouinstance | udd_ctxt_ouinstance | int(4) | No | Ouinstance | Yes |
| nrd_cr_no | udd_documentno | varchar(40) | No | CR no | Yes |
| nrd_positioncode | udd_positioncode | varchar(25) | Yes | positioncode | No |
| nrd_sorcdoctype | udd_documenttype | varchar(40) | Yes | source document type | No |
| nrd_sourcedocumentno | udd_documentno | varchar(40) | Yes | Source documentno | No |
| nrd_aircraftcode | udd_aircraftnumber | varchar(30) | Yes | aircraftcode | No |
| nrd_nhacomponentid | udd_componentid | varchar(90) | Yes | nhacomponentid | No |
| nrd_rempartcreatedou | udd_ctxt_ouinstance | int(4) | Yes | removal part ouinstance | No |
| nrd_outpartno | udd_partno | varchar(40) | Yes | removal partno | No |
| nrd_outpartserialno | udd_partserialnumber | varchar(40) | Yes | Removal serialno | No |
| nrd_outpartlotno | udd_lotnumber | varchar(28) | Yes | Removal lotno | No |
| nrd_atanumber | udd_atanumber | varchar(16) | Yes | Ata number | No |
| nrd_itemtagno | udd_documentno | varchar(40) | Yes | Item tagno | No |
| nrd_processaction | udd_flag | varchar(25) | Yes | processaction | No |
| nrd_removed_by | udd_hrempcode | varchar(20) | Yes | removed by | No |
| nrd_removed_date | _datetime_8 | datetime(8) | Yes | removed date | No |
| nrd_removaldateutc | _datetime_8 | datetime(8) | Yes | removal date | No |
| nrd_remtype | udd_removaltype | varchar(25) | Yes | removal type | No |
| nrd_basremoval | udd_flag | varchar(25) | Yes | basremoval | No |
| nrd_reasonforrepl | udd_reasonforremoval | varchar(20) | Yes | reason for replacement | No |
| nrd_remarks | udd_txt255 | varchar(255) | Yes | remarks | No |
| nrd_sourceofpart | udd_txt150 | varchar(150) | Yes | source of part | No |
| nrd_installcompcreatedou | udd_ctxt_ouinstance | int(4) | Yes | installation ounistance | No |
| nrd_incomingcomponentid | udd_componentid | varchar(90) | Yes | incoming componentid | No |
| nrd_installationdate | _datetime_8 | datetime(8) | Yes | installation date | No |
| nrd_installationdateutc | _datetime_8 | datetime(8) | Yes | installationdateutc | No |
| nrd_installedby | udd_hrempcode | varchar(20) | Yes | installed by | No |
| nrd_status | udd_status | varchar(25) | Yes | status | No |
| nrd_part_condition | udd_flag | varchar(25) | Yes | part condition | No |
| nrd_created_by | udd_hrempcode | varchar(20) | Yes | created by | No |
| nrd_creation_date | _datetime_8 | datetime(8) | Yes | creation date | No |
| nrd_modified_by | udd_hrempcode | varchar(20) | Yes | modified by | No |
| nrd_modification_date | _datetime_8 | datetime(8) | Yes | modification date | No |
| nrd_remconfirmedby | udd_hrempcode | varchar(20) | Yes | removal confirmedby | No |
| nrd_remconfirmeddate | _datetime_8 | datetime(8) | Yes | removal confirmeddate | No |
| nrd_replconfirmedby | udd_hrempcode | varchar(20) | Yes | replacement confirmedby | No |
| nrd_replconfirmeddate | _datetime_8 | datetime(8) | Yes | replacement confirmeddate | No |
| nrd_reverseby | udd_hrempcode | varchar(20) | Yes | reverseby | No |
| nrd_reversedate | _datetime_8 | datetime(8) | Yes | reversedate | No |
| nrd_recordmode | udd_flag | varchar(25) | Yes | recordmode | No |
| nrd_comments | udd_txt255 | varchar(255) | Yes | comments | No |
| nrd_wrnty_procsd | udd_txt5 | varchar(5) | Yes | warenty proces | No |
| nrd_sos_dispos | udd_designparamcode | varchar(5) | Yes | disposition | No |
| NRD_SOS_INITIATED_DATETIME | _datetime_8 | datetime(8) | Yes | initiated date and time | No |
| NRD_SOS_INITIATED_BY | udd_ctxt_user | varchar(30) | Yes | initiated by | No |
| NRD_SOS_DURATION | udd_schvalue | numeric(13) | Yes | duration | No |
| NRD_SOS_DURATION_UOM | udd_designparamcode | varchar(5) | Yes | duration in unit of measurement | No |
| NRD_SOS_DUEDATETIME | _datetime_8 | datetime(8) | Yes | due date | No |
| NRD_SOS_REF_DTL | udd_txt255 | varchar(255) | Yes | reference detail | No |
| NRD_SOS_REMARKS | udd_txt255 | varchar(255) | Yes | sos remarks | No |
| NRD_SOS_CF_NFF_UPDATE_DATE | _datetime_8 | datetime(8) | Yes | NRD SOS Updated date | No |
| NRD_SOS_CF_NFF_UPDATE_BY | datetime | Datetime(8) | Yes | NRD SOS Updated by | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| bu_id | fin_buid | varchar(20) | No | bu_id | No |
| ou_id | fin_ouinstid | int(4) | No | ouninstance | No |
| company_code | fin_companycode | varchar(10) | No | company code | No |
| event | fin_event | varchar(40) | No | event | No |
| finance_book | fin_financebookid | varchar(20) | No | finance book | No |
| account_code | fin_accountcode | varchar(32) | No | account code | No |
| effective_from_date | fin_date | datetime(8) | Yes | effective from date | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | cost center | No |
| effective_to_date | fin_date | datetime(8) | Yes | effective to date | No |
| addln_para_yn | fin_flag | varchar(25) | Yes | addln_para_yn | No |
| ma_createdby | fin_maccreatedby | varchar(40) | Yes | createdby | No |
| ma_createddate | fin_maccreateddate | datetime(8) | Yes | createddate | No |
| ma_modifiedby | fin_maccreatedby | varchar(40) | Yes | modifiedby | No |
| ma_modifieddate | fin_maccreateddate | datetime(8) | Yes | modifieddate | No |
| ma_timestamp | fin_mactimestamp | int(4) | Yes | timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| bu_id | fin_buid | varchar(20) | No | bu_id | No |
| ou_id | fin_ouinstid | int(4) | No | ouinstance | No |
| company_code | fin_companycode | varchar(10) | No | companycode | No |
| event | fin_event | varchar(40) | No | event | No |
| finance_book | fin_financebookid | varchar(20) | No | finance book | No |
| account_code | fin_accountcode | varchar(32) | No | account code | No |
| usage_id | fin_usageid | varchar(20) | Yes | usage id | No |
| effective_from_date | fin_date | datetime(8) | No | effective from date | No |
| item_type | fin_itemtype | varchar(25) | Yes | item type | No |
| item_group | fin_itemstatus | varchar(10) | Yes | item group | No |
| receipt_at | fin_location | varchar(16) | Yes | receipt at | No |
| docu_type | fin_documenttype | varchar(40) | Yes | document type | No |
| item_code | fin_itemcode | varchar(40) | Yes | item code | No |
| supplier_code | fin_suppliercode | varchar(16) | Yes | supplier code | No |
| stock_status | fin_status | varchar(25) | Yes | stock status | No |
| requester | fin_employeecode | varchar(20) | Yes | requester | No |
| number_series | fin_notypeno | varchar(10) | Yes | number series | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | cost center | No |
| effective_to_date | fin_date | datetime(8) | Yes | effective to date | No |
| ma_createdby | fin_maccreatedby | varchar(40) | Yes | createdby | No |
| ma_createddate | fin_maccreateddate | datetime(8) | Yes | createddate | No |
| ma_modifiedby | fin_maccreatedby | varchar(40) | Yes | modifiedby | No |
| ma_modifieddate | fin_maccreateddate | datetime(8) | Yes | modifieddate | No |
| ma_timestamp | fin_mactimestamp | int(4) | Yes | timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| bu_id | fin_buid | varchar(20) | No | bu_id | Yes |
| ou_id | fin_ouinstid | int(4) | No | ouinstance | Yes |
| company_code | fin_companycode | varchar(10) | No | company code | Yes |
| event | fin_event | varchar(40) | No | event | Yes |
| finance_book | fin_financebookid | varchar(20) | No | finance book | Yes |
| account_code | fin_accountcode | varchar(32) | No | account code | Yes |
| usage_id | fin_usageid | varchar(20) | No | usage id | Yes |
| effective_from_date | fin_date | datetime(8) | No | effective from date | Yes |
| supplier_group | fin_suppliergroup | varchar(20) | Yes | supplier group | No |
| supplier_code | fin_suppliercode | varchar(16) | Yes | supplier code | No |
| receipt_at | fin_location | varchar(16) | Yes | receipt at | No |
| number_series | fin_notypeno | varchar(10) | Yes | number series | No |
| item_group | fin_itemstatus | varchar(10) | Yes | itemgroup | No |
| item_code | fin_itemcode | varchar(40) | Yes | item code | No |
| item_variant | fin_variant | varchar(8) | Yes | item variant | No |
| folder | fin_folder | varchar(40) | Yes | folder | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | cost center | No |
| effective_to_date | fin_date | datetime(8) | Yes | effective to date | No |
| ma_createdby | fin_maccreatedby | varchar(40) | Yes | createdby | No |
| ma_createddate | fin_maccreateddate | datetime(8) | Yes | createddate | No |
| ma_modifiedby | fin_maccreatedby | varchar(40) | Yes | modifiedby | No |
| ma_modifieddate | fin_maccreateddate | datetime(8) | Yes | modifieddate | No |
| ma_timestamp | fin_mactimestamp | int(4) | Yes | timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| bu_id | fin_buid | varchar(20) | No | bu_id | No |
| ou_id | fin_ouinstid | int(4) | No | ounistance | No |
| company_code | fin_companycode | varchar(10) | No | company code | No |
| finance_book | fin_financebookid | varchar(20) | No | finance book | No |
| account_code | fin_accountcode | varchar(32) | No | account code | No |
| event | fin_event | varchar(40) | No | event | No |
| effective_from_date | fin_macdate | datetime(8) | Yes | effective from date | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | cost center | No |
| effective_to_date | fin_date | datetime(8) | Yes | effective to date | No |
| addln_para_yn | fin_flag | varchar(25) | Yes | addln_para_yn | No |
| ma_createdby | fin_maccreatedby | varchar(40) | Yes | createdby | No |
| ma_createddate | fin_maccreateddate | datetime(8) | Yes | createddate | No |
| ma_modifiedby | fin_maccreatedby | varchar(40) | Yes | modifiedby | No |
| ma_modifieddate | fin_maccreateddate | datetime(8) | Yes | modifieddate | No |
| ma_timestamp | fin_mactimestamp | int(4) | Yes | timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| bu_id | fin_buid | varchar(20) | No | bu_id | Yes |
| ou_id | fin_ouinstid | int(4) | No | ouinstance | Yes |
| company_code | fin_companycode | varchar(10) | No | company code | Yes |
| event | fin_event | varchar(40) | No | event | Yes |
| finance_book | fin_financebookid | varchar(20) | No | finance book | Yes |
| account_code | fin_accountcode | varchar(32) | No | account code | Yes |
| tcd_code | fin_tcdcode | varchar(10) | No | tcd code | Yes |
| tcd_variant | fin_tcdcode | varchar(10) | No | tcd variant | Yes |
| usage_id | fin_usageid | varchar(20) | No | usage id | Yes |
| effective_from_date | fin_date | datetime(8) | No | effective from date | Yes |
| supplier_group | fin_suppliergroup | varchar(20) | Yes | supplier group | No |
| supplier_code | fin_suppliercode | varchar(16) | Yes | supplier code | No |
| receipt_at | fin_location | varchar(16) | Yes | receipt at | No |
| number_series | fin_notypeno | varchar(10) | Yes | number series | No |
| folder | fin_folder | varchar(40) | Yes | folder | No |
| transport_mode | fin_transportationmode | varchar(25) | Yes | transport mode | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | cost center | No |
| effective_to_date | fin_date | datetime(8) | Yes | effective to date | No |
| ma_createdby | fin_maccreatedby | varchar(40) | Yes | createdby | No |
| ma_createddate | fin_maccreateddate | datetime(8) | Yes | createddate | No |
| ma_modifiedby | fin_maccreatedby | varchar(40) | Yes | modifiedby | No |
| ma_modifieddate | fin_maccreateddate | datetime(8) | Yes | modifieddate | No |
| ma_timestamp | fin_mactimestamp | int(4) | Yes | timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| bu_id | fin_buid | varchar(20) | No | bu_id | Yes |
| ou_id | fin_ouinstid | int(4) | No | ouinstance | Yes |
| company_code | fin_companycode | varchar(10) | No | company code | Yes |
| account_code | fin_accountcode | varchar(32) | No | account code | Yes |
| finance_book | fin_financebookid | varchar(20) | No | finance book | Yes |
| event | fin_event | varchar(40) | No | event | Yes |
| effective_from_date | fin_date | datetime(8) | Yes | effective from date | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | cost center | No |
| tcd_code | fin_tcdcode | varchar(10) | Yes | tcd code | No |
| tcd_variant | fin_tcdcode | varchar(10) | Yes | tcd variant | No |
| effective_to_date | fin_date | datetime(8) | Yes | effective to date | No |
| addln_para_yn | fin_flag | varchar(25) | Yes | addln_para_yn | No |
| ma_createdby | fin_maccreatedby | varchar(40) | Yes | createdby | No |
| ma_createddate | fin_maccreateddate | datetime(8) | Yes | createddate | No |
| ma_modifiedby | fin_maccreatedby | varchar(40) | Yes | modifiedby | No |
| ma_modifieddate | fin_maccreateddate | datetime(8) | Yes | modifieddate | No |
| ma_timestamp | fin_mactimestamp | int(4) | Yes | ma_timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| bu_id | fin_buid | varchar(20) | No | bu_id | No |
| ou_id | fin_ouinstid | int(4) | No | ouinstance | No |
| company_code | fin_companycode | varchar(10) | No | company code | No |
| finance_book | fin_financebookid | varchar(20) | No | finance book | No |
| account_code | fin_accountcode | varchar(32) | No | account code | No |
| usage_id | fin_usageid | varchar(20) | Yes | usage id | No |
| effective_from_date | fin_date | datetime(8) | No | effective from date | No |
| cust_group | fin_code | varchar(6) | Yes | cust_group | No |
| cust_code | fin_customer_id | varchar(18) | Yes | cust_code | No |
| ship_to_id | fin_id | varchar(6) | Yes | ship_to_id | No |
| sale_type | fin_quickcode | varchar(20) | Yes | sale_type | No |
| sale_order_type | fin_quickcode | varchar(20) | Yes | sale_order_type | No |
| processing_action | fin_quickcode | varchar(20) | Yes | processing_action | No |
| number_series | fin_notypeno | varchar(10) | Yes | number_series | No |
| item_group | fin_itemstatus | varchar(10) | Yes | item_group | No |
| item_code | fin_itemcode | varchar(40) | Yes | item_code | No |
| item_variant | fin_variant | varchar(8) | Yes | item_variant | No |
| folder | fin_folder | varchar(40) | Yes | folder | No |
| ship_to_point | fin_ouinstid | int(4) | Yes | ship_to_point | No |
| delivery_area_code | fin_deliveryarea | varchar(18) | Yes | delivery_area_code | No |
| order_point | fin_ouinstid | int(4) | Yes | order_point | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | cost_center | No |
| effective_to_date | fin_date | datetime(8) | Yes | effective_to_date | No |
| ma_createdby | fin_maccreatedby | varchar(40) | Yes | ma_createdby | No |
| ma_createddate | fin_maccreateddate | datetime(8) | Yes | ma_createddate | No |
| ma_modifiedby | fin_maccreatedby | varchar(40) | Yes | ma_modifiedby | No |
| ma_modifieddate | fin_maccreateddate | datetime(8) | Yes | ma_modifieddate | No |
| ma_timestamp | fin_mactimestamp | int(4) | Yes | ma_timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| bu_id | fin_buid | varchar(20) | No | bu_id | Yes |
| ou_id | fin_ouinstid | int(4) | No | ou_id | Yes |
| company_code | fin_companycode | varchar(10) | No | company_code | Yes |
| account_code | fin_accountcode | varchar(32) | No | account_code | Yes |
| finance_book | fin_financebookid | varchar(20) | No | finance_book | Yes |
| effective_from_date | fin_date | datetime(8) | No | effective_from_date | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | Yes | ou_id | No |
| company_code | fin_companycode | varchar(10) | Yes | company_code | No |
| account_code | fin_accountcode | varchar(32) | Yes | account_code | No |
| customer_group | fin_code | varchar(6) | Yes | customer_group | No |
| num_type | fin_notypeno | varchar(10) | Yes | num_type | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | cost_center | No |
| ccdesc | fin_description | varchar(100) | Yes | ccdesc | No |
| effective_from | fin_date | datetime(8) | Yes | effective_from | No |
| effective_to | fin_date | datetime(8) | Yes | effective_to | No |
| packslip_category | fin_quickcode | varchar(20) | Yes | packslip_category | No |
| order_loc | fin_location | varchar(16) | Yes | order_loc | No |
| ship_loc | fin_location | varchar(16) | Yes | ship_loc | No |
| warehouse | fin_warehouse | varchar(10) | Yes | warehouse | No |
| part_no | fin_partno | varchar(40) | Yes | part_no | No |
| part_type | fin_flag | varchar(25) | Yes | part_type | No |
| part_category | fin_parttype | varchar(25) | Yes | part_category | No |
| part_condition | fin_flag | varchar(25) | Yes | part_condition | No |
| stock_status | fin_partstatus | varchar(40) | Yes | stock_status | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | createdby | No |
| createddate | fin_date | datetime(8) | Yes | createddate | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | modifiedby | No |
| modifieddate | fin_date | datetime(8) | Yes | modifieddate | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | Yes | ou_id | No |
| company_code | fin_companycode | varchar(10) | Yes | company_code | No |
| account_code | fin_accountcode | varchar(32) | Yes | account_code | No |
| customer_group | fin_code | varchar(6) | Yes | customer_group | No |
| num_type | fin_notypeno | varchar(10) | Yes | num_type | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | cost_center | No |
| ccdesc | fin_description | varchar(100) | Yes | ccdesc | No |
| effective_from | fin_date | datetime(8) | Yes | effective_from | No |
| effective_to | fin_date | datetime(8) | Yes | effective_to | No |
| rental_category | fin_quickcode | varchar(20) | Yes | rental_category | No |
| order_loc | fin_location | varchar(16) | Yes | order_loc | No |
| issue_loc | fin_oudescription | varchar(256) | Yes | issue_loc | No |
| warehouse | fin_warehouse | varchar(10) | Yes | warehouse | No |
| part_no | fin_partno | varchar(40) | Yes | part_no | No |
| part_type | fin_flag | varchar(25) | Yes | part_type | No |
| part_category | fin_quickcode | varchar(20) | Yes | part_category | No |
| return_loc | fin_location | varchar(16) | Yes | return_loc | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | createdby | No |
| createddate | fin_date | datetime(8) | Yes | createddate | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | modifiedby | No |
| modifieddate | fin_date | datetime(8) | Yes | modifieddate | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | Yes | ou_id | No |
| company_code | fin_companycode | varchar(10) | Yes | company_code | No |
| account_code | fin_accountcode | varchar(32) | Yes | account_code | No |
| customer_group | fin_code | varchar(6) | Yes | customer_group | No |
| num_type | fin_notypeno | varchar(10) | Yes | num_type | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | cost_center | No |
| ccdesc | fin_description | varchar(100) | Yes | ccdesc | No |
| effective_from | fin_date | datetime(8) | Yes | effective_from | No |
| effective_to | fin_date | datetime(8) | Yes | effective_to | No |
| order_category | fin_quickcode | varchar(20) | Yes | order_category | No |
| order_loc | fin_location | varchar(16) | Yes | order_loc | No |
| execution_facility | fin_flag2 | varchar(25) | Yes | execution_facility | No |
| execution_loc | fin_oucode | varchar(32) | Yes | execution_loc | No |
| work_center | fin_txt80 | varchar(80) | Yes | work_center | No |
| aircraft_model | fin_aircraftnumber | varchar(30) | Yes | aircraft_model | No |
| part_category | fin_quickcode | varchar(20) | Yes | part_category | No |
| component_type | fin_flag | varchar(25) | Yes | component_type | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | createdby | No |
| createddate | fin_date | datetime(8) | Yes | createddate | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | modifiedby | No |
| modifieddate | fin_date | datetime(8) | Yes | modifieddate | No |
| PART_GROUP | fin_text | varchar(256) | Yes | PART_GROUP | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| cost_center | fin_costcentercode | varchar(10) | Yes | cost_center | No |
| work_center | fin_txt80 | varchar(80) | Yes | work_center | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| bu_id | fin_buid | varchar(20) | No | bu_id | Yes |
| ou_id | fin_ouinstid | int(4) | No | ou_id | Yes |
| company_code | fin_companycode | varchar(10) | No | company_code | Yes |
| event | fin_event | varchar(40) | No | event | Yes |
| finance_book | fin_financebookid | varchar(20) | No | finance_book | Yes |
| account_code | fin_accountcode | varchar(32) | No | account_code | Yes |
| tcd_code | fin_tcdcode | varchar(10) | No | tcd_code | Yes |
| tcd_variant | fin_tcdcode | varchar(10) | No | tcd_variant | Yes |
| usage_id | fin_usageid | varchar(20) | No | usage_id | Yes |
| effective_from_date | fin_date | datetime(8) | No | effective_from_date | Yes |
| cust_group | fin_code | varchar(6) | Yes | cust_group | No |
| cust_code | fin_customer_id | varchar(18) | Yes | cust_code | No |
| ship_to_id | fin_id | varchar(6) | Yes | ship_to_id | No |
| sale_type | fin_quickcode | varchar(20) | Yes | sale_type | No |
| sale_order_type | fin_quickcode | varchar(20) | Yes | sale_order_type | No |
| processing_action | fin_quickcode | varchar(20) | Yes | processing_action | No |
| number_series | fin_notypeno | varchar(10) | Yes | number_series | No |
| folder | fin_folder | varchar(40) | Yes | folder | No |
| ship_to_point | fin_ouinstid | int(4) | Yes | ship_to_point | No |
| delivery_area_code | fin_deliveryarea | varchar(18) | Yes | delivery_area_code | No |
| order_point | fin_ouinstid | int(4) | Yes | order_point | No |
| transport_mode | fin_transportationmode | varchar(25) | Yes | transport_mode | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | cost_center | No |
| effective_to_date | fin_date | datetime(8) | Yes | effective_to_date | No |
| ma_createdby | fin_maccreatedby | varchar(40) | Yes | ma_createdby | No |
| ma_createddate | fin_maccreateddate | datetime(8) | Yes | ma_createddate | No |
| ma_modifiedby | fin_maccreatedby | varchar(40) | Yes | ma_modifiedby | No |
| ma_modifieddate | fin_maccreateddate | datetime(8) | Yes | ma_modifieddate | No |
| ma_timestamp | fin_mactimestamp | int(4) | Yes | ma_timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| bu_id | fin_buid | varchar(20) | No | bu_id | No |
| ou_id | fin_ouinstid | int(4) | No | ou_id | No |
| company_code | fin_companycode | varchar(10) | No | company_code | No |
| account_code | fin_accountcode | varchar(32) | No | account_code | No |
| finance_book | fin_financebookid | varchar(20) | No | finance_book | No |
| event | fin_event | varchar(40) | No | event | No |
| effective_from_date | fin_date | datetime(8) | No | effective_from_date | No |
| cost_center | fin_costcentercode | varchar(10) | Yes | cost_center | No |
| tcd_code | fin_tcdcode | varchar(10) | Yes | tcd_code | No |
| tcd_variant | fin_tcdcode | varchar(10) | Yes | tcd_variant | No |
| effective_to_date | fin_date | datetime(8) | Yes | effective_to_date | No |
| addln_para_yn | fin_flag | varchar(25) | Yes | addln_para_yn | No |
| ma_createdby | fin_maccreatedby | varchar(40) | Yes | ma_createdby | No |
| ma_createddate | fin_maccreateddate | datetime(8) | Yes | ma_createddate | No |
| ma_modifiedby | fin_maccreatedby | varchar(40) | Yes | ma_modifiedby | No |
| ma_modifieddate | fin_maccreateddate | datetime(8) | Yes | ma_modifieddate | No |
| ma_timestamp | fin_mactimestamp | int(4) | Yes | ma_timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ALUD_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| ALUD_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| ALUD_CALENDAR | _varchar_16 | varchar(16) | No | Calendar | Yes |
| ALUD_PERIOD_NO | _decimal_9_0 | decimal(9) | No | Period no | Yes |
| ALUD_LAST_CALCULATED_DATE | _datetime_8 | datetime(8) | Yes | Last calculated date | No |
| ALUD_LAST_MODIFIED_BY | _char_30 | char(30) | Yes | Last modified by | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| AMR_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| AMR_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| AMR_CALENDAR_NO | _varchar_16 | varchar(16) | No | Calender | Yes |
| AMR_MONTH | _decimal_17_0 | decimal(17) | No | Month | Yes |
| AMR_YEAR | _decimal_17_0 | decimal(17) | No | Year | Yes |
| AMR_ATA | _varchar_16 | varchar(16) | No | ATA | Yes |
| AMR_MONTHLY_ALERT_VALUE | _decimal_13_0 | decimal(13) | Yes | Monthly Alert Value | No |
| AMR_LAST_CALCULATED_DATE | _datetime_8 | datetime(8) | Yes | Last calculated date | No |
| AMR_LAST_MODIFIED_BY | _varchar_40 | varchar(40) | Yes | Last modified by | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| APR_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| APR_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| APR_CALENDAR_NO | _varchar_16 | varchar(16) | No | Calender | Yes |
| APR_ATA | _varchar_20 | varchar(20) | No | ATA | Yes |
| APR_PERIOD | _decimal_17_0 | decimal(17) | No | Duration | Yes |
| APR_PERIOD_ALERT_VALUE | _decimal_13_0 | decimal(13) | Yes | Period of alert | No |
| APR_LAST_CALCULATED_DATE | _datetime_8 | datetime(8) | Yes | Last calculated date | No |
| APR_LAST_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Last modified by | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ARA_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| ARA_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| ARA_CALENDAR | _varchar_16 | varchar(16) | No | Calender | Yes |
| ARA_ATA | _varchar_16 | varchar(16) | No | ATA | Yes |
| ARA_RELIABILITY_ALERT | _decimal_13_0 | decimal(13) | Yes | Reliability alert | No |
| ARA_LAST_CALCULATED_DATE | _datetime_8 | datetime(8) | Yes | Last calculated date | No |
| ARA_LAST_MODIFIED_BY | _varchar_40 | varchar(40) | Yes | Last modified by | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CFH_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| CFH_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| CFH_MONTH_NO | _decimal_17_0 | decimal(17) | No | Month | Yes |
| CFH_YEAR_NO | _decimal_17_0 | decimal(17) | No | Year | Yes |
| CFH_CALENDAR_NO | _varchar_16 | varchar(16) | No | Calender | Yes |
| CFH_COMPONENT_NO | _varchar_90 | varchar(90) | No | Component id | Yes |
| CFH_PART_NO | _varchar_40 | varchar(40) | No | Part no | Yes |
| CFH_SERIAL_NO | _varchar_40 | varchar(40) | No | Serial no | Yes |
| CFH_ATA_NO | _varchar_16 | varchar(16) | Yes | ATA no | No |
| CFH_MONTH_FH | _decimal_13_0 | decimal(13) | Yes | Month FH | No |
| CFH_MONTH_FC | _decimal_13_0 | decimal(13) | Yes | Month FC | No |
| CFH_LAST_UPDATED_DATE | _datetime_8 | datetime(8) | Yes | Last modified date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CRD_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| CRD_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| CRD_COMPONENT | _varchar_90 | varchar(90) | No | Component id | Yes |
| CRD_MONTH_NO | _decimal_17_0 | decimal(17) | No | Month | Yes |
| CRD_YEAR_NO | _decimal_17_0 | decimal(17) | No | Year | Yes |
| CRD_CALENDAR | _varchar_16 | varchar(16) | No | Calender | Yes |
| CRD_SERIAL_NO | _varchar_40 | varchar(40) | No | Serial no | Yes |
| CRD_PART_NO | _varchar_40 | varchar(40) | No | Part no | Yes |
| CRD_ATA_NO | _varchar_16 | varchar(16) | No | ATA no | Yes |
| CRD_COMPONENT_OU | _decimal_17_0 | decimal(17) | Yes | component ouinstance | No |
| CRD_NO_OF_BASIC_REMOVALS | _decimal_17_0 | decimal(17) | Yes | No of basic removals | No |
| CRD_NO_OF_SCH_REMOVALS | _decimal_17_0 | decimal(17) | Yes | No of scheduled removals | No |
| CRD_NO_OF_BASIC_UNSCH_REM | _decimal_17_0 | decimal(17) | Yes | No of basic unscheduled removal | No |
| CRD_NO_OF_UNSCH_REMOVALS | _decimal_17_0 | decimal(17) | Yes | No of basic unscheduled removal | No |
| CRD_NO_OF_REMOVALS | _decimal_17_0 | decimal(17) | Yes | No of Removals | No |
| CRD_NO_OF_CONF_REMOVALS | _decimal_17_0 | decimal(17) | Yes | No of Confirm Removal | No |
| CRD_NO_OF_PREM_REMOVALS | _decimal_17_0 | decimal(17) | Yes | No of Pre Removal | No |
| CRD_NO_OF_NFF | _decimal_17_0 | decimal(17) | Yes | No of NFF | No |
| CRD_LAST_UPDATED_DATE | _datetime_8 | datetime(8) | Yes | Last updated date | No |
| CRD_REPLACEMENTNO | _varchar_40 | varchar(40) | Yes | Replacement no | No |
| CRD_UNPLAN_FLAG | _varchar_5 | varchar(5) | Yes | Unplan flag | No |
| CRD_REMOVALDATETIME | _datetime_8 | datetime(8) | Yes | Removal date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| FCRU_OUINSTANCE | _decimal_20_0 | decimal(20) | No | ouinstance | Yes |
| FCRU_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| FCRU_CALENDAR | _varchar_16 | varchar(16) | No | Calender | Yes |
| FCRU_CR_LAST_UPD_DATE | _datetime_8 | datetime(8) | Yes | CR Last modified date | No |
| FCRU_EOC_LAST_UPD_DATE | _datetime_8 | datetime(8) | Yes | EOC Last modified date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| FOS_OUINSTANCE | _decimal_16_0 | decimal(16) | No | ouinstance | Yes |
| FOS_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| FOS_SERVICE_LEVEL | _decimal_17_0 | decimal(17) | Yes | Service Level | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| FRAD_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| FRAD_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| FRAD_CALENDAR | _varchar_16 | varchar(16) | No | Calender | No |
| FRAD_PERIOD | _varchar_18 | varchar(18) | No | Period | Yes |
| FRAD_MONTHLY_ALERT_VALUE | _decimal_17_0 | decimal(17) | Yes | Monthly alert value | No |
| FRAD_RELIABILITY_ALERT | _decimal_17_0 | decimal(17) | Yes | Reliability alert | No |
| FRAD_MTBF | _decimal_17_0 | decimal(17) | Yes | FRAD_MTBF | No |
| FRAD_MTBUR | _decimal_17_0 | decimal(17) | Yes | FRAD_MTBUR | No |
| FRAD_MTBR | _decimal_17_0 | decimal(17) | Yes | FRAD_MTBR | No |
| FRAD_LAST_CALCULATED_DATE | _datetime_8 | datetime(8) | Yes | Last Calculated date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| OUINSTANCE | udd_ctxt_ouinstance | int(4) | No | ouinstance | Yes |
| CALENDAR | udd_calendar | varchar(16) | No | Calender | Yes |
| FLEET | udd_model | varchar(20) | No | Fleet | Yes |
| PERIOD | udd_calendaryear | int(4) | No | Period | Yes |
| YEARNO | udd_number | int(4) | No | Year | Yes |
| MONTHNO | udd_number | int(4) | No | Month | Yes |
| ATA | udd_atanumber | varchar(16) | No | ATA | Yes |
| PART | udd_partno | varchar(40) | No | Part no | Yes |
| ALERTFLAG | udd_flag | varchar(25) | No | Alert Flag | Yes |
| SUM_OCCURENCE | udd_number | int(4) | Yes | Sum of the occurence | No |
| SUM_TOTALFH | udd_periodnum | numeric(13) | Yes | sum of the flight hours | No |
| SUM_TOTALFC | udd_number | int(4) | Yes | Sum of the flight cycle | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| FRA_OUINSTANCE | udd_ctxt_ouinstance | int(4) | No | ouinstance | Yes |
| FRA_FLEET | udd_model | varchar(20) | No | Fleet | Yes |
| FRA_CALENDAR | udd_calendar | varchar(16) | No | Calender | Yes |
| FRA_ATA | udd_atanumber | varchar(16) | No | ATA | Yes |
| FRA_PART_NO | udd_partno | varchar(40) | No | Part no | Yes |
| FRA_ALERTFLAG | udd_flag | varchar(25) | No | Alert Flag | Yes |
| FRA_OCCURENCE | udd_number | int(4) | Yes | Occurence | No |
| FRA_ALERT_LVL | udd_reliabalert | numeric(13) | Yes | Alert Level | No |
| FRA_WATCH_LVL | udd_reliabalert | numeric(13) | Yes | Watch Level | No |
| FRA_LAST_CALCULATED_DATE | udd_datetime1 | datetime(8) | No | Last Calculated date | No |
| FRA_LAST_MODIFIED_BY | udd_ctxt_user | varchar(30) | No | Last modified by | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| FRAM_OUINSTANCE | udd_ctxt_ouinstance | int(4) | No | ouinstance | Yes |
| FRAM_CALENDAR | udd_calendar | varchar(16) | No | calender | Yes |
| FRAM_FLEET | udd_model | varchar(20) | No | Fleet | Yes |
| FRAM_PERIOD | udd_calendaryear | int(4) | No | Period | Yes |
| FRAM_YEAR | udd_number | int(4) | No | Year | Yes |
| FRAM_MONTH | udd_number | int(4) | No | Month | Yes |
| FRAM_ATA | udd_atanumber | varchar(16) | No | ATA | Yes |
| FRAM_PART_NO | udd_partno | varchar(40) | No | Part no | Yes |
| FRAM_ALERTFLAG | udd_flag | varchar(25) | No | Alert Flag | Yes |
| FRAM_OCCURENCE | udd_number | int(4) | Yes | Sum of the occurence | No |
| FRAM_TOTALFH | udd_periodnum | numeric(13) | Yes | sum of the flight hours | No |
| FRAM_TOTALFC | udd_number | int(4) | Yes | Sum of the flight cycle | No |
| FRAM_ALERTVALUE | udd_reliabalert | numeric(13) | Yes | Alert Level | No |
| FRAM_LAST_CALCULATED_DATE | udd_datetime1 | datetime(8) | No | Last Calculated date | No |
| FRAM_LAST_MODIFIED_BY | udd_ctxt_user | varchar(30) | No | Last modified by | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| OUINSTANCE | udd_ctxt_ouinstance | int(4) | No | ouinstance | Yes |
| CALENDAR | udd_calendar | varchar(16) | No | calender | Yes |
| FLEET | udd_model | varchar(20) | No | Fleet | Yes |
| PERIOD | udd_calendaryear | int(4) | No | Period | Yes |
| YEARNO | udd_number | int(4) | No | Year | Yes |
| MONTHNO | udd_number | int(4) | No | Month | Yes |
| ATA | udd_atanumber | varchar(16) | No | ATA | Yes |
| PART | udd_partno | varchar(40) | No | Part no | Yes |
| ALERTFLAG | udd_flag | varchar(25) | No | Alert Flag | Yes |
| SUM_OCCURENCE | udd_number | int(4) | Yes | Sum of the occurence | No |
| RatePer1000FH | udd_periodnum | numeric(13) | Yes | RatePer1000FH | No |
| RatePer1000FC | udd_number | int(4) | Yes | RatePer1000FC | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IAD_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| IAD_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IAD_ATA | _varchar_16 | varchar(16) | No | ATA | Yes |
| IAD_ATA_OUINSTANCE | _decimal_15_0 | decimal(15) | No | IATA ouinstance | No |
| IAD_INIT_REL_ALERT | _decimal_255_0 | decimal(255) | Yes | Initial Alert | No |
| IAD_STATUS | _varchar_15 | varchar(15) | Yes | Status | No |
| IAD_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| IAD_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created by | No |
| IAD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created date | No |
| IAD_INIT_PIPREP_ALERT | udd_reliabalert | numeric(13) | Yes | IAD_INIT_PIPREP_ALERT | No |
| IAD_INIT_DELAY_ALERT | udd_reliabalert | numeric(13) | Yes | Delay Alert | No |
| IAD_INIT_CANCEL_ALERT | udd_reliabalert | numeric(13) | Yes | Cancel Alert | No |
| IAD_INIT_RD_ALERT | udd_reliabalert | numeric(13) | Yes | IAD_INIT_RD_ALERT | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IAH_OUINSTANCE | _decimal_17_0 | decimal(17) | No | Ouinstance | Yes |
| IAH_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IAH_AS_ON_DATE | _datetime_8 | datetime(8) | Yes | As on date | No |
| IAH_EFF_TILL_DATE | _datetime_8 | datetime(8) | Yes | Effective till date | No |
| IAH_INITIAL_COMMENTS | _varchar_255 | varchar(255) | Yes | Initial comments | No |
| IAH_CONFIRM_COMMENTS | _varchar_255 | varchar(255) | Yes | Confirm comments | No |
| IAH_INITIALIZED_BY | _varchar_30 | varchar(30) | Yes | Initialised by | No |
| IAH_INITIALIZED_DATE | _datetime_8 | datetime(8) | Yes | Initiallised date | No |
| IAH_CONFIRMED_BY | _varchar_30 | varchar(30) | Yes | Confirm by | No |
| IAH_CONFIRMED_DATE | _datetime_8 | datetime(8) | Yes | Confirm date | No |
| IAH_TIMESTAMP | _decimal_17_0 | decimal(17) | Yes | Time stamp | No |
| IAH_RD_REL_ALERT | udd_reliabalert | numeric(13) | Yes | Reliability alert | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IMADD_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| IMADD_CALENDAR_NO | _varchar_16 | varchar(16) | No | calender | Yes |
| IMADD_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IMADD_MONTH | _varchar_18 | varchar(18) | No | Month | Yes |
| IMADD_YEAR | _decimal_17_0 | decimal(17) | No | Year | Yes |
| IMADD_ATA | _varchar_16 | varchar(16) | No | ATA | Yes |
| IMADD_NO_OF_DISCREPANCY | _decimal_17_0 | decimal(17) | Yes | No of Discerpency | No |
| IMADD_STATUS | _varchar_15 | varchar(15) | Yes | Status | No |
| IMADD_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| IMADD_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created by | No |
| IMADD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IMADH_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| IMADH_CALENDAR_NO | _varchar_16 | varchar(16) | No | calender no | Yes |
| IMADH_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IMADH_MONTH | _varchar_18 | varchar(18) | No | Month | Yes |
| IMADH_YEAR | _decimal_17_0 | decimal(17) | No | Year | Yes |
| IMADH_CONFIRM_COMMENTS | _varchar_255 | varchar(255) | Yes | Confirm comments | No |
| IMADH_INITIALIZED_BY | _varchar_30 | varchar(30) | Yes | Initiallised by | No |
| IMADH_INITIALIZED_DATE | _datetime_8 | datetime(8) | Yes | Initialised date | No |
| IMADH_CONFIRMED_BY | _varchar_30 | varchar(30) | Yes | Confirmed by | No |
| IMADH_CONFIRMED_DATE | _datetime_8 | datetime(8) | Yes | Confirmed date | No |
| IMADH_TIMESTAMP | _decimal_17_0 | decimal(17) | Yes | Timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IMAD_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| IMAD_CALENDAR_NO | _varchar_16 | varchar(16) | No | Calender | Yes |
| IMAD_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IMAD_MONTH | _varchar_18 | varchar(18) | No | Month | Yes |
| IMAD_YEAR | _decimal_16_0 | decimal(16) | No | Year | Yes |
| IMAD_ATA | _varchar_16 | varchar(16) | No | ATA | Yes |
| IMAD_INIT_REL_ALERT | _decimal_13_0 | decimal(13) | Yes | Reliability alert | No |
| IMAD_STATUS | _varchar_15 | varchar(15) | Yes | Status | No |
| IMAD_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| IMAD_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created by | No |
| IMAD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IMAH_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| IMAH_CALENDAR_NO | _varchar_16 | varchar(16) | No | Calender no | Yes |
| IMAH_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IMAH_MONTH | _varchar_18 | varchar(18) | No | Month | Yes |
| IMAH_YEAR | _decimal_17_0 | decimal(17) | No | Year | Yes |
| IMAH_CONFIRM_COMMENTS | _varchar_255 | varchar(255) | Yes | Confirm comments | No |
| IMAH_INITIALIZED_BY | _varchar_30 | varchar(30) | Yes | Initialised by | No |
| IMAH_INITIALIZED_DATE | _datetime_8 | datetime(8) | Yes | Initialised date | No |
| IMAH_CONFIRMED_BY | _varchar_30 | varchar(30) | Yes | Confirmed by | No |
| IMAH_CONFIRMED_DATE | _datetime_8 | datetime(8) | Yes | Confirmed date | No |
| IMAH_TIMESTAMP | _decimal_17_0 | decimal(17) | Yes | Timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IMPDD_OUINSTANCE | _decimal_17_0 | decimal(17) | No | Ouinstance | Yes |
| IMPDD_CALENDAR_NO | _varchar_16 | varchar(16) | No | calender no | Yes |
| IMPDD_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IMPDD_MONTH | _varchar_18 | varchar(18) | No | Month | Yes |
| IMPDD_YEAR | _decimal_17_0 | decimal(17) | No | Year | Yes |
| IMPDD_ATA | _varchar_16 | varchar(16) | No | ATA | Yes |
| IMPDD_PART | _varchar_40 | varchar(40) | No | Partno | Yes |
| IMPDD_NO_OF_REMOVALS | _decimal_5_0 | decimal(5) | Yes | No. of removal | No |
| IMPDD_STATUS | _varchar_15 | varchar(15) | Yes | Status | No |
| IMPDD_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| IMPDD_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created by | No |
| IMPDD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created date | No |
| IMPDD_FLYHRS | _decimal_13_0 | decimal(13) | Yes | Flying hours | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IMPDH_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| IMPDH_CALENDAR_NO | _varchar_16 | varchar(16) | No | calender no | Yes |
| IMPDH_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IMPDH_MONTH | _varchar_18 | varchar(18) | No | Month | Yes |
| IMPDH_YEAR | _decimal_17_0 | decimal(17) | No | Year | Yes |
| IMPDH_ATA | _varchar_16 | varchar(16) | No | ATA | Yes |
| IMPDH_CONFIRM_COMMENTS | _varchar_255 | varchar(255) | Yes | Confirm comments | No |
| IMPDH_INITIALIZED_BY | _varchar_30 | varchar(30) | Yes | Initialised by | No |
| IMPDH_INITIALIZED_DATE | _datetime_8 | datetime(8) | Yes | Initialised date | No |
| IMPDH_CONFIRMED_BY | _varchar_30 | varchar(30) | Yes | Confirmed by | No |
| IMPDH_CONFIRMED_DATE | _datetime_8 | datetime(8) | Yes | Confirmed date | No |
| IMPDH_TIMESTAMP | _decimal_17_0 | decimal(17) | Yes | Time stamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IMPD_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| IMPD_CALENDAR_NO | _varchar_16 | varchar(16) | No | calendar no | Yes |
| IMPD_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IMPD_MONTH | _varchar_18 | varchar(18) | No | Month | Yes |
| IMPD_YEAR | _decimal_17_0 | decimal(17) | No | Year | Yes |
| IMPD_ATA | _varchar_16 | varchar(16) | No | ATA | Yes |
| IMPD_PART | _varchar_40 | varchar(40) | No | Partno | Yes |
| IMPD_INIT_REL_ALERT | _decimal_13_0 | decimal(13) | Yes | Reliability alert | No |
| IMPD_STATUS | _varchar_15 | varchar(15) | Yes | Status | No |
| IMPD_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| IMPD_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created by | No |
| IMPD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IMPH_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| IMPH_CALENDAR_NO | _varchar_16 | varchar(16) | No | calender no | Yes |
| IMPH_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IMPH_MONTH | _varchar_18 | varchar(18) | No | Month | Yes |
| IMPH_YEAR | _decimal_17_0 | decimal(17) | No | Year | Yes |
| IMPH_ATA | _varchar_16 | varchar(16) | No | ATA | Yes |
| IMPH_CONFIRM_COMMENTS | _varchar_255 | varchar(255) | Yes | Confirm comments | No |
| IMPH_INITIALIZED_BY | _varchar_30 | varchar(30) | Yes | Initialised by | No |
| IMPH_INITIALIZED_DATE | _datetime_8 | datetime(8) | Yes | Initialised date | No |
| IMPH_CONFIRMED_BY | _varchar_30 | varchar(30) | Yes | Confirmed by | No |
| IMPH_CONFIRMED_DATE | _datetime_8 | datetime(8) | Yes | Confirmed date | No |
| IMPH_TIMESTAMP | _decimal_17_0 | decimal(17) | Yes | Time stamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IPD_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| IPD_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IPD_ATA | _varchar_16 | varchar(16) | No | ATA | Yes |
| IPD_PART | _varchar_40 | varchar(40) | No | Partno | Yes |
| IPD_PART_OUINSTANCE | _decimal_17_0 | decimal(17) | No | part ouinstance | No |
| IPD_INIT_REL_ALERT | _decimal_13_0 | decimal(13) | Yes | Reliability alert | No |
| IPD_STATUS | _varchar_15 | varchar(15) | Yes | Status | No |
| IPD_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| IPD_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created by | No |
| IPD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created date | No |
| IPD_INIT_UNSCHREM_ALERT | udd_reliabalert | numeric(13) | Yes | unsheduled removal alert | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IPH_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| IPH_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IPH_ATA | _varchar_16 | varchar(16) | No | ATA | Yes |
| IPH_ATA_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ATA ouinstance | No |
| IPH_INITIAL_COMMENTS | _varchar_255 | varchar(255) | Yes | Initial Comments | No |
| IPH_CONFIRM_COMMENTS | _varchar_255 | varchar(255) | Yes | Confirm Comments | No |
| IPH_INITIALIZED_BY | _varchar_30 | varchar(30) | Yes | Initialised by | No |
| IPH_INITIALIZED_DATE | _datetime_8 | datetime(8) | Yes | Initialised date | No |
| IPH_CONFIRMED_BY | _varchar_30 | varchar(30) | Yes | Confirmed by | No |
| IPH_CONFIRMED_DATE | _datetime_8 | datetime(8) | Yes | Confirmed date | No |
| IPH_TIMESTAMP | _decimal_17_0 | decimal(17) | Yes | Timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IUFD_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| IUFD_CALENDAR_NO | _varchar_16 | varchar(16) | No | calender no | Yes |
| IUFD_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IUFD_MONTH | _varchar_18 | varchar(18) | No | Month | Yes |
| IUFD_YEAR | _decimal_17_0 | decimal(17) | No | Year | Yes |
| IUFD_AIRCRAFT_REG_NO | _varchar_30 | varchar(30) | No | Aircraft reg no | Yes |
| IUFD_AIRCRAFT_REG_NO_OU | _decimal_17_0 | decimal(17) | Yes | AC reg Ouinstance | No |
| IUFD_FLYING_HRS | _decimal_13_0 | decimal(13) | Yes | Flying hours | No |
| IUFD_STATUS | _varchar_15 | varchar(15) | Yes | Status | No |
| IUFD_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| IUFD_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created by | No |
| IUFD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| IUFH_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| IUFH_CALENDAR_NO | _varchar_16 | varchar(16) | No | calender no | Yes |
| IUFH_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| IUFH_MONTH | _varchar_18 | varchar(18) | No | Month | Yes |
| IUFH_YEAR | _decimal_17_0 | decimal(17) | No | Year | Yes |
| IUFH_COMMENTS | _varchar_255 | varchar(255) | Yes | Comments | No |
| IUFH_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created by | No |
| IUFH_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created date | No |
| IUFH_CONFIRMED_BY | _varchar_30 | varchar(30) | Yes | Confirm by | No |
| IUFH_CONFIRMED_DATE | _datetime_8 | datetime(8) | Yes | Confirm date | No |
| IUFH_TIMESTAMP | _decimal_17_0 | decimal(17) | Yes | Time stamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| OS_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| OS_ATA_ALERT_VALUE | _varchar_20 | varchar(20) | Yes | ATA alert value | No |
| OS_PART_ALERT_VALUE | _varchar_20 | varchar(20) | Yes | Part alert value | No |
| OS_ATA_DATA | _varchar_20 | varchar(20) | Yes | ATA data | No |
| OS_PART_DATA | _varchar_20 | varchar(20) | Yes | Part ata | No |
| OS_DEFECT_RATE_CAL | _decimal_17_0 | decimal(17) | Yes | defect rate call | No |
| OS_MAX_NO_OPEN_PERIODS | _decimal_17_0 | decimal(17) | Yes | max no of open periods | No |
| OS_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created by | No |
| OS_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created date | No |
| OS_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified by | No |
| OS_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified date | No |
| OS_TIMESTAMP | _decimal_17_0 | decimal(17) | Yes | Time stamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CREL_COMPONENT_NAME | _varchar_80 | varchar(80) | No | Component name | Yes |
| CREL_PARAM_CAT | _varchar_10 | varchar(10) | No | Parameter catergory | Yes |
| CREL_PARAM_TYPE | _varchar_15 | varchar(15) | No | Parameter Type | Yes |
| CREL_PARAM_CODE | _varchar_5 | varchar(5) | No | Parameter code | Yes |
| CREL_PARAM_DESC | _varchar_80 | varchar(80) | Yes | parameter description | No |
| CREL_LANGID | _decimal_9_0 | decimal(9) | No | Language id | Yes |
| CREL_PREFIX_SORT_BY | _decimal_9_0 | decimal(9) | Yes | Orderby | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PFH_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| PFH_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| PFH_MONTH_NO | _decimal_17_0 | decimal(17) | No | Month | Yes |
| PFH_YEAR_NO | _decimal_17_0 | decimal(17) | No | Year | Yes |
| PFH_CALENDAR_NO | _varchar_16 | varchar(16) | No | calendar no | Yes |
| PFH_ATA_NO | _varchar_16 | varchar(16) | No | ATA no | Yes |
| PFH_PART_NO | _varchar_40 | varchar(40) | No | Part no | Yes |
| PFH_SERIAL_NO | _varchar_40 | varchar(40) | No | Serial no | Yes |
| PFH_MONTH_FH | _decimal_20_0 | decimal(20) | Yes | Month FH | No |
| PFH_CUM_FH | _decimal_16_0 | decimal(16) | Yes | PFH_CUM_FH | No |
| PFH_LAST_UPDATED_DATE | _datetime_8 | datetime(8) | Yes | Last updated date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PPR_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| PPR_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| PPR_CALENDAR_NO | _varchar_16 | varchar(16) | No | Calender no | Yes |
| PPR_PART | _varchar_40 | varchar(40) | No | Part no | Yes |
| PPR_ATA | _varchar_20 | varchar(20) | No | ATA | Yes |
| PPR_PERIOD | _decimal_17_0 | decimal(17) | No | period | Yes |
| PPR_PERIOD_ALERT_VALUE | _decimal_13_0 | decimal(13) | Yes | Period alert value | No |
| PPR_LAST_CALCULATED_DATE | _datetime_8 | datetime(8) | Yes | Last Calculated date | No |
| PPR_LAST_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Last modified by | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRA_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| PRA_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| PRA_CALENDAR | _varchar_16 | varchar(16) | No | calendar no | Yes |
| PRA_ATA | _varchar_16 | varchar(16) | No | ATA | Yes |
| PRA_PART_NO | _varchar_40 | varchar(40) | No | Part no | Yes |
| PRA_RELIABILITY_ALERT | _decimal_13_0 | decimal(13) | Yes | Reliability alert | No |
| PRA_LAST_CALCULATED_DATE | _datetime_8 | datetime(8) | Yes | Last calculated date | No |
| PRA_LAST_MODIFIED_BY | _varchar_40 | varchar(40) | Yes | Last modified by | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRD_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| PRD_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| PRD_CALENDAR_NO | _varchar_16 | varchar(16) | No | calendar no | Yes |
| PRD_MONTH | _decimal_17_0 | decimal(17) | No | Month | Yes |
| PRD_YEAR | _decimal_17_0 | decimal(17) | No | Year | Yes |
| PRD_PART | _varchar_40 | varchar(40) | No | Part no | Yes |
| PRD_ATA | _varchar_16 | varchar(16) | No | ATA | Yes |
| PRD_MONTHLY_ALERT_VALUE | _decimal_17_0 | decimal(17) | Yes | Monthly alert value | No |
| PRD_MTBF | _decimal_17_0 | decimal(17) | Yes | PRD_MTBF | No |
| PRD_MTBUR | _decimal_17_0 | decimal(17) | Yes | PRD_MTBUR | No |
| PRD_MTBR | _decimal_17_0 | decimal(17) | Yes | PRD_MTBR | No |
| PRD_LAST_CALCULATED_DATE | _datetime_8 | datetime(8) | Yes | Last calculated date | No |
| PRD_LAST_MODIFIED_BY | _varchar_40 | varchar(40) | Yes | Last modified by | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRD_OUINSTANCE | _decimal_17_0 | decimal(17) | No | ouinstance | Yes |
| PRD_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| PRD_MONTH_NO | _decimal_17_0 | decimal(17) | No | Month no | Yes |
| PRD_YEAR_NO | _decimal_17_0 | decimal(17) | No | Year | Yes |
| PRD_CALENDAR_NO | _varchar_16 | varchar(16) | No | Calender no | Yes |
| PRD_PART_NO | _varchar_40 | varchar(40) | No | Part no | Yes |
| PRD_ATA_NO | _varchar_16 | varchar(16) | No | ATA no | Yes |
| PRD_NO_OF_UNSCH_REMOVALS | _decimal_17_0 | decimal(17) | Yes | No .of unscheduled removal | No |
| PRD_NO_OF_REMOVALS | _decimal_17_0 | decimal(17) | Yes | No.of removals | No |
| PRD_NO_OF_CONF_REMOVALS | _decimal_17_0 | decimal(17) | Yes | No.of confirm removal | No |
| PRD_CUM_NO_OF_REMOVALS | _decimal_17_0 | decimal(17) | Yes | Cummulative No.of removals | No |
| PRD_CUM_NO_OF_UNSCH_REMOVALS | _decimal_17_0 | decimal(17) | Yes | Cummulative No.of Unschedule removals | No |
| PRD_CUM_NO_OF_CONF_REMOVALS | _decimal_17_0 | decimal(17) | Yes | Cummulative No.of Confirmed removals | No |
| PRD_LAST_UPDATED_DATE | _datetime_8 | datetime(8) | Yes | Last updated date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| RUD_OUINSTANCE | _decimal_38_0 | decimal(38) | No | ouinstance | Yes |
| RUD_FLEET | _varchar_20 | varchar(20) | No | Fleet | Yes |
| RUD_NO_CONF_FAILURES_FH | _decimal_38_0 | decimal(38) | Yes | No.of confirm failure of FH | No |
| RUD_CONF_FAILURES_FH | _decimal_20_8 | decimal(20) | Yes | confirm failure of FH | No |
| RUD_NO_CONF_FAILURES_FC | _decimal_38_0 | decimal(38) | Yes | No.of confirm failure of FC | No |
| RUD_CONF_FAILURES_FC | _decimal_20_8 | decimal(20) | Yes | confirm failure of FC | No |
| RUD_NO_NOFAULTS_FH | _decimal_38_0 | decimal(38) | Yes | No.of nofaults in FH | No |
| RUD_NOFAULTS_FH | _decimal_20_8 | decimal(20) | Yes | Nofaults in FH | No |
| RUD_NO_NOFAULTS_FC | _decimal_38_0 | decimal(38) | Yes | No.of Nofaults in FC | No |
| RUD_NOFAULTS_FC | _decimal_20_8 | decimal(20) | Yes | Nofaults in FC | No |
| RUD_MTBF | _decimal_38_0 | decimal(38) | Yes | RUD_MTBF | No |
| RUD_MTBUR | _decimal_38_0 | decimal(38) | Yes | RUD_MTBUR | No |
| RUD_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| RUD_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created by | No |
| RUD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created date | No |
| RUD_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified by | No |
| RUD_MODIFICATION_DATE | _datetime_8 | datetime(8) | Yes | Modified date | No |
| RUD_TIMESTAMP | _decimal_38_0 | decimal(38) | Yes | Timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_companycode | varchar(10) | No | Organization unit id | Yes |
| voucher_no | fin_financebookid | varchar(20) | No | Voucher number | Yes |
| timestamp | _int_0 | int(0) | Yes | Timestamp | No |
| attach_notes_desc | fin_text2500 | varchar(2500) | Yes | Attach notes description | No |
| voucher_status | fin_status | varchar(25) | Yes | Voucher status | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | createdby | No |
| createddate | _datetime_8 | datetime(8) | Yes | createddate | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | modifiedby | No |
| modifieddate | _datetime_8 | datetime(8) | Yes | modifieddate | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_companycode | varchar(10) | No | Organization unit id | Yes |
| voucher_no | fin_financebookid | varchar(20) | No | Voucher number | Yes |
| serial_no | fin_int | int(4) | No | Serial number | Yes |
| timestamp | _int_0 | int(0) | Yes | Timestamp | No |
| attach_notes_desc | fin_text2500 | varchar(2500) | Yes | Attach notes description | No |
| voucher_status | fin_status | varchar(25) | Yes | Voucher status | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | createdby | No |
| createddate | _datetime_8 | datetime(8) | Yes | createddate | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | modifiedby | No |
| modifieddate | _datetime_8 | datetime(8) | Yes | modifieddate | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | Yes | ouistance | No |
| voucher_no | fin_documentnumber | varchar(18) | Yes | voucher_no | No |
| voucher_serial_no | fin_int | int(4) | Yes | voucher_serial_no | No |
| timestamp | fin_int | int(4) | Yes | timestamp | No |
| voucher_type | fin_vouchertype | varchar(20) | Yes | voucher_type | No |
| voucher_date | fin_datetime | datetime(8) | Yes | voucher_date | No |
| fb_id | fin_financebookid | varchar(20) | Yes | fb_id | No |
| account_code | fin_accountcode | varchar(32) | Yes | account_code | No |
| drcr_flag | fin_drcridentifier | varchar(6) | Yes | drcr_flag | No |
| tran_currency | fin_currencycode | varchar(5) | Yes | tran_currency | No |
| tran_amount | fin_amount | numeric(13) | Yes | tran_amount | No |
| exchange_rate | fin_amount | numeric(13) | Yes | exchange_rate | No |
| base_amount | fin_amount | numeric(13) | Yes | base_amount | No |
| remarks | fin_text255 | varchar(255) | Yes | remarks | No |
| costcenter_code | fin_costcentercode | varchar(10) | Yes | costcenter_code | No |
| analysis_code | fin_analysiscode | varchar(5) | Yes | analysis_code | No |
| subanal_code | fin_subanalysiscode | varchar(5) | Yes | subanal_code | No |
| par_exchange_rate | fin_exchangerate | numeric(9) | Yes | par_exchange_rate | No |
| par_base_amount | fin_amount | numeric(13) | Yes | par_base_amount | No |
| tran_ou | fin_ouinstid | int(4) | Yes | tran_ou | No |
| component_name | fin_component | varchar(16) | Yes | component_name | No |
| bank_code | fin_bankcode | varchar(32) | Yes | bank_code | No |
| tran_type | fin_transactiontype | varchar(40) | Yes | tran_type | No |
| bu_id | fin_buid | varchar(20) | Yes | bu_id | No |
| company_code | fin_companycode | varchar(10) | Yes | company_code | No |
| tran_date | fin_datetime | datetime(8) | Yes | tran_date | No |
| posting_date | fin_datetime | datetime(8) | Yes | posting_date | No |
| mac_flag | fin_flag | varchar(25) | Yes | mac_flag | 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? |
| ou_id | fin_ouinstid | int(4) | No | ou_id | Yes |
| voucher_no | fin_documentnumber | varchar(18) | No | voucher_no | Yes |
| voucher_serial_no | fin_int | int(4) | No | voucher_serial_no | Yes |
| timestamp | _int_0 | int(0) | Yes | timestamp | No |
| account_code | fin_accountcode | varchar(32) | Yes | account_code | No |
| exchange_rate | fin_amount | numeric(13) | Yes | exchange_rate | No |
| base_balance | fin_amount | numeric(13) | Yes | base_balance | No |
| rev_base_balance | fin_amount | numeric(13) | Yes | rev_base_balance | No |
| exchgl_base | fin_amount | numeric(13) | Yes | exchgl_base | No |
| exchgl_baseper | fin_amount | numeric(13) | Yes | exchgl_baseper | No |
| base_drcr | fin_drcridentifier | varchar(6) | Yes | base_drcr | No |
| pbase_balance | fin_amount | numeric(13) | Yes | pbase_balance | No |
| rev_pbase_balance | fin_amount | numeric(13) | Yes | rev_pbase_balance | No |
| exchgl_pbase | fin_amount | numeric(13) | Yes | exchgl_pbase | No |
| exchgl_pbaseper | fin_amount | numeric(13) | Yes | exchgl_pbaseper | No |
| pbase_drcr | fin_drcridentifier | varchar(6) | Yes | pbase_drcr | No |
| account_balance | fin_amount | numeric(13) | Yes | account_balance | No |
| costcenter_code | fin_costcentercode | varchar(10) | Yes | costcenter_code | No |
| analysis_code | fin_analysiscode | varchar(5) | Yes | analysis_code | No |
| subanal_code | fin_subanalysiscode | varchar(5) | Yes | subanal_code | No |
| remarks | fin_text255 | varchar(255) | Yes | remarks | No |
| par_exchange_rate | fin_exchangerate | numeric(9) | Yes | par_exchange_rate | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | createdby | No |
| createddate | _datetime_8 | datetime(8) | Yes | createddate | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | modifiedby | No |
| modifieddate | _datetime_8 | datetime(8) | Yes | modifieddate | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ou_id | fin_ouinstid | int(4) | No | ou_id | Yes |
| voucher_no | fin_documentnumber | varchar(18) | No | voucher_no | Yes |
| timestamp | _int_0 | int(0) | Yes | timestamp | No |
| year_code | fin_calendarcode | varchar(10) | Yes | year_code | No |
| period_code | fin_calendarcode | varchar(10) | Yes | period_code | No |
| run_flag | fin_status | varchar(25) | Yes | run_flag | No |
| voucher_status | fin_status | varchar(25) | Yes | voucher_status | No |
| voucher_date | _datetime_8 | datetime(8) | Yes | voucher_date | No |
| numbering_type | fin_notypeno | varchar(10) | Yes | numbering_type | No |
| fb_id | fin_financebookid | varchar(20) | Yes | fb_id | No |
| currency_code | fin_currencycode | varchar(5) | Yes | currency_code | No |
| rev_voucher_no | fin_documentnumber | varchar(18) | Yes | rev_voucher_no | No |
| rev_voucher_date | _datetime_8 | datetime(8) | Yes | rev_voucher_date | No |
| rev_numbering_type | fin_notypeno | varchar(10) | Yes | rev_numbering_type | No |
| rev_year | fin_calendarcode | varchar(10) | Yes | rev_year | No |
| rev_period | fin_calendarcode | varchar(10) | Yes | rev_period | No |
| remarks | fin_comments | varchar(256) | Yes | remarks | No |
| ref_voucher_no | fin_documentnumber | varchar(18) | Yes | ref_voucher_no | No |
| simul_no | fin_documentnumber | varchar(18) | Yes | simul_no | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | createdby | No |
| createddate | _datetime_8 | datetime(8) | Yes | createddate | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | modifiedby | No |
| modifieddate | _datetime_8 | datetime(8) | Yes | modifieddate | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ADT_OUINSTANCE | udd_ctxt_ouinstance | int(4) | No | ouinstance | Yes |
| ADT_ROTABLEREPLCMTNO | _varchar_40 | varchar(40) | No | Replacement no | Yes |
| ADT_DISCREPANCYNO | _varchar_40 | varchar(40) | No | Discrepancy no | Yes |
| ADT_SOURCEDOCTYPE | _varchar_15 | varchar(15) | Yes | Source document type | No |
| ADT_SOURCEDOCNO | udd_documentno | varchar(40) | Yes | Source document no | No |
| ADT_DISCREPANCYDESC | udd_txt2000 | varchar(2000) | Yes | Discrepency Description | No |
| ADT_COMMENTS | _varchar_255 | varchar(255) | Yes | Comments | No |
| ADT_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| ADT_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created date | No |
| ADT_CREATED_BY | _varchar_9 | varchar(9) | Yes | Created by | No |
| ADT_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | modified date | No |
| ADT_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified by | No |
| ADT_STATUS | _varchar_40 | varchar(40) | Yes | Status | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ERRLOG_ERRID | _int_5 | int(5) | Yes | Error id | No |
| ERRLOG_DESC | _varchar_255 | varchar(255) | Yes | Error description | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| OSD_OUINSTANCE | _decimal_5_0 | decimal(5) | No | ouinstance | Yes |
| OSD_AUTOWARRANTYCLIAM | _varchar_5 | varchar(5) | No | Auto waranty claim | Yes |
| OSD_DEFAULTWARRANTCLIAMDESC | udd_txt150 | varchar(150) | Yes | Default waranty claim description | No |
| OSD_REPLDT_FLAG | _varchar_5 | varchar(5) | Yes | Replishment Flag | No |
| OSD_ASSSTAT_FLAG | _varchar_5 | varchar(5) | Yes | ASSSTAT FLAG | No |
| OSD_TIMESTAMP | _numeric_25_0 | numeric(25) | Yes | Timestamp | No |
| OSD_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created by | No |
| OSD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | created date | No |
| OSD_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | modified by | No |
| OSD_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | modified date | No |
| OSD_PERMIT_ERRLOG | _varchar_5 | varchar(5) | Yes | Error description | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PAD_OUINSTANCE | _decimal_25_0 | decimal(25) | No | ouinstance | Yes |
| PAD_ROTABLEREPLACMTNO | _varchar_40 | varchar(40) | No | Replacement no | Yes |
| PAD_PROCESSACTION | _varchar_25 | Varchar(25) | Yes | Process action Priority | No |
| PAD_PRIORITY | _decimal_25_0 | decimal(25) | Yes | Priority no | No |
| PAD_AOG | _varchar_25 | Varchar(25) | Yes | AOG Flag | No |
| PAD_MOVETOWORKCENTER | _varchar_30 | varchar(30) | Yes | Work center code | No |
| PAD_EXPRETDATE | _datetime_8 | datetime(8) | Yes | Expected return date | No |
| PAD_SHIPDATE | _datetime_8 | datetime(8) | Yes | Ship date | No |
| PAD_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| PAD_CWOCOMMENTS | _varchar_255 | varchar(255) | Yes | Cwo comments | No |
| PAD_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created by | No |
| PAD_CREATE_DATE | _datetime_8 | datetime(8) | Yes | Created date | No |
| PAD_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified by | No |
| PAD_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified by | No |
| PAD_EXPRETDATEUTC | _datetime_8 | datetime(8) | Yes | Expected return date UTC | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CRP_COMPONENTNAME | _varchar_20 | varchar(20) | No | Component name | Yes |
| CRP_PARAMCATEGORY | _varchar_10 | varchar(10) | No | Parameter catergory | Yes |
| CRP_PARAMTYPE | _varchar_25 | Varchar(25) | No | Parameter Type | Yes |
| CRP_PARAMCODE | _varchar_5 | varchar(5) | No | Parameter code | Yes |
| CRP_DISPLAYORDER | _decimal_20_0 | decimal(20) | Yes | Display order | No |
| CRP_LANGID | _decimal_16_0 | decimal(16) | No | launguge id | Yes |
| CRP_PARAMDESC | _varchar_25 | Varchar(25) | No | parameter description | No |
| CRP_CREATIONDATE | _datetime_8 | datetime(8) | Yes | Created date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| RRD_OUINSTANCE | _decimal_20_0 | decimal(20) | No | ounistance | Yes |
| RRD_ROTABLEREPLACMDNO | _varchar_40 | varchar(40) | No | Replacement no | Yes |
| RRD_USERDEFINED1 | _varchar_25 | Varchar(25) | Yes | RRD_USERDEFINED1 | No |
| RRD_USERDEFINED2 | _varchar_25 | Varchar(25) | Yes | RRD_USERDEFINED2 | No |
| RRD_USERDEFINED3 | _varchar_25 | Varchar(25) | Yes | RRD_USERDEFINED3 | No |
| RRD_REMARKS | _varchar_255 | varchar(255) | Yes | remarks | No |
| RRD_CREATED_BY | _varchar_30 | varchar(30) | Yes | created by | No |
| RRD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created date | No |
| RRD_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | modified by | No |
| RRD_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | modified date | No |