|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Num_RowID | udd_seqno | int(4) | No | This column is used to store the Row number | No |
| Num_SysGenNo | udd_seqno | int(4) | Yes | Used to store the System Generated Number. | No |
| Num_Prefix | udd_prefix | varchar(6) | Yes | This column is used to store the Numbering Class Prefix. | No |
| Num_Suffix | udd_suffix | varchar(6) | Yes | Used to store the Numbering Class Suffix. | No |
| Num_PrefixFmt | udd_prefix | varchar(6) | Yes | Used to store the Numbering class Prefix Format. | No |
| Num_SuffixFmt | udd_suffix | varchar(6) | Yes | This column is used to store the numbering class suffix format. | No |
| Num_Numtype | udd_notypeno | varchar(5) | Yes | This column is used to store the Numbering Type. | No |
| Num_Document_No | udd_documentno | varchar(40) | Yes | This column is used to store the Document Number. | No |
| Num_Ouinstance | udd_ctxt_ouinstance | int(4) | Yes | This column is used to store the Organization Unit. | No |
| Num_UsedFlag | _bit_1 | Bit(1) | Yes | This column is used to store the Flag. | No |
| Num_DocNumEffDate | udd_time | datetime(8) | Yes | This column is used to store the Effective Date. | No |
| Num_Createddate | udd_time | datetime(8) | Yes | This column is used to store the Created Date. | No |
| Num_Modifieddate | udd_time | datetime(8) | Yes | This column is used to store the Modified Date. | No | |
| Table Name : | NUM_FNTRN_FUNCTION_TRAN_META |
| Comment : | This table will have the metadata entries containing the list of functions, and transactions available for each function. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| FNTRN_TRAN_TYPE | _varchar_25 | Varchar(25) | No | The following are the various transaction types which uses numbering class. Metadata will be available only for these transaction types. COMNO CRNO CWONO DRNO EANNO EOFCD EONO ESRNO FRNO GRNO GRVNO HWONO JLOGDISC JLOGNO LOTNO LPNO LWONO MAINTISSUE M | No |
| FNTRN_TRAN_TYPE_DESC | _varchar_80 | varchar(80) | Yes | The following are the description for the various transaction type for which metadata entries will be available. Certificate of Maint Component Replacement Component Work Order Deferment Request for CP Engineering Advice Note Fleet Campaign Directiv | No |
| FNTRN_FUNCTION_CODE | _varchar_25 | Varchar(25) | No | The following are the various function codes that will be available in the metadata... CMPMNT ENG INV LNMNT MPL PUR | No |
| FNTRN_FUNCTION_NAME | _varchar_25 | Varchar(25) | No | The following are the various function names that will be available in the metadata... Component Maintenance Engineering Inventory Line Maintenance Maintenance Planning Purchase | No |
| FNTRN_TRANSACTION_CODE | _varchar_25 | Varchar(25) | No | This is nothing but the component code which is displayed as transaction to the user. The following are the various transaction codes that will be available in the metadata... BASCAPPLNG BASCHKPACK BASCR BASCWO BASCWOREP BASDP BASEA BASEAR BASEO BA | No |
| FNTRN_TRANSACTION_DESC | _varchar_80 | varchar(80) | No | This is nothing but the component desc which is displayed as transaction desc to the user The following are the various transaction desc that will be available in the metadata... Central Planning Visit Package Component Replacement Component Work O | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Table Name : | NUM_NCDT_DATEFORMAT_ALLOWED |
| Comment : | This table contains the dateformat allowed in the Prefix or Suffix of the Numbering Class for Generating Document Number |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| NCDT_ALLWD_DT_FORMAT | _varchar_15 | varchar(15) | No | The following are the dateformat supported for prefix and suffix. ( MMDDYY ) ( DDMMYY ) ( YYYY ) ( MMYYYY ) ( -MMDD ) ( MMDD- ) ( /MMDD ) ( -DDMM ) ( /DDMM ) ( -YYYY ) ( /YYYY ) ( DDMM- ) ( -MMYY ) ( /MMYY ) ( /MM ) ( /DD ) | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| NUMAP_ORG_UNIT | _Decimal_10_0 | decimal(10) | No | Organisation Unit | Yes |
| NUMAP_NUM_TYPE_NO | _varchar_5 | varchar(5) | No | Numbering Type | Yes |
| NUMAP_TRAN_TYPE_ORG_UNIT | _Decimal_10_0 | decimal(10) | No | Transaction Type OU | Yes |
| NUMAP_TRAN_TYPE | _varchar_25 | Varchar(25) | No | Transaction Type | Yes |
| NUMAP_WORK_CENTER | _varchar_30 | varchar(30) | No | Work center | Yes |
| NUMAP_MODEL_NO | _varchar_30 | varchar(30) | No | Model number | Yes |
| NUMAP_WAREHOUSE | _varchar_30 | varchar(30) | No | Warehouse | Yes |
| NUMAP_WORKCENT_OU | _Decimal_10_0 | decimal(10) | No | Workcenter OU | Yes |
| NUMAP_MODEL_OU | _Decimal_10_0 | decimal(10) | No | Model OU | Yes |
| NUMAP_WAREHOUSE_OU | _Decimal_10_0 | decimal(10) | No | Warehouse OU | Yes |
| NUMAP_CREATED_BY | _varchar_30 | varchar(30) | Yes | Creator Id | No |
| NUMAP_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created on | No |
| NUMAP_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modifier ID | No |
| NUMAP_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified on | No | |
| Table Name : | NUM_NUMDT_NUMBERING_CLASS_DTL |
| Comment : | This table contains the Details of the Numbering Type Number like its Prefix, Suffix, Starting Number, Ending Number, Last Generated Number, Effective From Date, Effective To Date. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| NUMDT_ORG_UNIT | _decimal_10_0 | decimal(10) | No | Created OuInstance of the Numbering Type Numebr | No |
| NUMDT_NUM_TYPE_NO | _varchar_5 | varchar(5) | No | Numbering Type Number | No |
| NUMDT_PREFIX | _varchar_6 | varchar(6) | No | Prefix which is used for the Document Number Generation for this Numbering Type Number | No |
| NUMDT_SUFFIX | _varchar_6 | varchar(6) | No | Suffix which is used for Document Number Generation for this Numbering Type Number | No |
| NUMDT_START_NO | _decimal_10_0 | decimal(10) | Yes | Starting Numbering of the Document Number to be generated | No |
| NUMDT_END_NO | _decimal_10_0 | decimal(10) | Yes | Ending Number of the Document Number to be generated | No |
| NUMDT_EFF_FROM_DATE | _datetime_8 | datetime(8) | Yes | Effective From date of the Prefix-Suffix combination for the Numbering Type Number | No |
| NUMDT_EFF_TO_DATE | _datetime_8 | datetime(8) | Yes | Effective To date of the Prefix-Suffix combination for the Numbering Type Number | No |
| NUMDT_LAST_NO_GEN | _decimal_10_0 | decimal(10) | Yes | Last number of the Document Number generated using this Numbering Type Number | No |
| NUMDT_CREATED_BY | _varchar_30 | varchar(30) | Yes | User Created | No |
| NUMDT_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| NUMDT_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | User Modified | No |
| NUMDT_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No |
| NUMDT_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes |
| NUMDT_OFFLINE_AREANO | udd_documentno | varchar(40) | Yes | Offline Area No | No |
| NUMDT_ISOFFLINE | udd_designparamcode | varchar(5) | Yes | Offline check flag | No |
| created_area_code | _Varchar_40 | varchar(40) | Yes | Created area code | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| NUMDT_ORG_UNIT | _decimal_10_0 | decimal(10) | No | Created OuInstance of the Numbering Type Numebr | No |
| NUMDT_NUM_TYPE_NO | _varchar_5 | varchar(5) | No | Numbering Type Number | No |
| NUMDT_PREFIX | _varchar_6 | varchar(6) | No | Prefix which is used for the Document Number Generation for this Numbering Type Number | No |
| NUMDT_SUFFIX | _varchar_6 | varchar(6) | No | Suffix which is used for Document Number Generation for this Numbering Type Number | No |
| NUMDT_START_NO | _decimal_10_0 | decimal(10) | Yes | Starting Numbering of the Document Number to be generated | No |
| NUMDT_END_NO | _decimal_10_0 | decimal(10) | Yes | Ending Number of the Document Number to be generated | No |
| NUMDT_EFF_FROM_DATE | _datetime_8 | datetime(8) | Yes | Effective From date of the Prefix-Suffix combination for the Numbering Type Number | No |
| NUMDT_EFF_TO_DATE | _datetime_8 | datetime(8) | Yes | Effective To date of the Prefix-Suffix combination for the Numbering Type Number | No |
| NUMDT_LAST_NO_GEN | _decimal_10_0 | decimal(10) | Yes | Last number of the Document Number generated using this Numbering Type Number | No |
| NUMDT_CREATED_BY | _varchar_30 | varchar(30) | Yes | User Created | No |
| NUMDT_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| NUMDT_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | User Modified | No |
| NUMDT_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No |
| NUMDT_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp | No |
| PRE_NUMDT_LAST_NO_GEN | _decimal_10_0 | decimal(10) | Yes | Last number of the Document Number generated using this Numbering Type Number. | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Table Name : | NUM_NUMHR_NUMBERING_CLASS_HDR |
| Comment : | This table contains the header information of the Numbering Type It contains the Numbering Type Created OUInstance Numbering Type Number Numbering Type Description along with its Status |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| NUMHR_ORG_UNIT | _decimal_10_0 | decimal(10) | No | Created OuInstance of the Numbering Type No | Yes |
| NUMHR_NUM_TYPE_NO | _varchar_5 | varchar(5) | No | Numbering Type Number | Yes |
| NUMHR_NUM_TYPE_DESC | _varchar_80 | varchar(80) | No | Description of the Numbering Type Number | No |
| NUMHR_NUM_TYPE_DESC_UP | _varchar_80 | varchar(80) | No | Description in Upper Case for Oracle Compatability | No |
| NUMHR_STATUS | _varchar_5 | varchar(5) | No | Status of the Numbering Type Number. Status can be either 1. Active (A) or 2. Inactive (I) | No |
| NUMHR_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created User | No |
| NUMHR_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| NUMHR_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | User Modified | No |
| NUMHR_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No |
| NUMHR_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp | No |
| NUMHR_MODEL_OU | _decimal_10_0 | decimal(10) | Yes | Ou | No |
| NUMHR_MODEL | _varchar_20 | varchar(20) | Yes | Model | No |
| NUMHR_WORK_CENTER_OU | _decimal_10_0 | decimal(10) | Yes | Work Center Ou | No |
| NUMHR_WORK_CENTER | _varchar_30 | varchar(30) | Yes | Work Center | No |
| NUMHR_WAREHOUSE_OU | _decimal_10_0 | decimal(10) | Yes | Warejouse Ou | No |
| NUMHR_WAREHOUSE_ID | _varchar_10 | varchar(10) | Yes | Warehouse Id | No |
| NUMHR_PREPOPNUMGEN_REQ | udd_designparamcode | varchar(5) | Yes | This column is used to store the prepopulated number generated required or not. | No |
| NUMHR_PREPOPNUM_COUNT | udd_count | int(4) | Yes | This column is used to store the prepopulated count results. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| NUMHR_ORG_UNIT_FIN | udd_ctxt_ouinstance | int(4) | No | OU | No |
| NUMHR_NUM_TYPE_NO_FIN | _varchar_10 | varchar(10) | No | Numbering Type number | No |
| NUMHR_STATUS_FIN | udd_designparamcode | varchar(5) | No | Status | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Table Name : | NUM_NUMMP_NUMCLS_TRANTYPE_MAP |
| Comment : | This table contains the Numbering Type Number which are mapped to the Transaction Type with the Transaction Type OUInstance information |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| NUMMP_ORG_UNIT | _decimal_10_0 | decimal(10) | No | Created OUInstance of the Numbering Type Number | Yes |
| NUMMP_NUM_TYPE_NO | _varchar_5 | varchar(5) | No | Numbering Type Number mapped to a Transaction | Yes |
| NUMMP_TRAN_TYPE_ORG_UNIT | _decimal_10_0 | decimal(10) | No | OUInstance of the Transaction Type to which Numbering Type Number is mapped | Yes |
| NUMMP_TRAN_TYPE | _varchar_25 | Varchar(25) | No | Transaction Type to which Numbering Type Number is mapped | Yes |
| NUMMP_DEFAULT_FLAG | _varchar_5 | varchar(5) | Yes | Will take Y or N Numbering Type with default flag as Y , will form the default Numbering Type for that Transaction Type for generating Document Number for that Transaction Type | No |
| NUMMP_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created User | No |
| NUMMP_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| NUMMP_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | User Modified | No |
| NUMMP_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No |
| NUMMP_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| NUMMP_ORG_UNIT_FIN | udd_ctxt_ouinstance | int(4) | No | Orgnaization Unit | No |
| NUMMP_NUM_TYPE_NO_FIN | _varchar_10 | varchar(10) | No | Type number | No |
| NUMMP_TRAN_TYPE_FIN | udd_flag | varchar(25) | No | Transaction type | No |
| NUMMP_TRAN_TYPE_ORG_UNIT_FIN | udd_ctxt_ouinstance | int(4) | No | Transaction Type OU | No |
| NUMMP_DEFAULT_FLAG_FIN | udd_designparamcode | varchar(5) | Yes | Default Flag. | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Table Name : | NUM_USRTRN_USER_TRANTYPE_MAP |
| Comment : | This table contains the details of the Transaction Types, with the User Information who is having rights to Create Numbering Class and can map to that Transaction |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| USRTRN_ORG_UNIT | _decimal_10_0 | decimal(10) | No | OUInstance of the Transaction Type for which the User has rights to map Numbering Type information | No |
| USRTRN_USER_NAME | _varchar_30 | varchar(30) | No | User having rights to Create Numbering Class and can map to the Transaction type specified | No |
| USRTRN_FUNCTION_CODE | _varchar_25 | Varchar(25) | No | Function Code of the Transaction type specified | No |
| USRTRN_TRANSACTION_CODE | _varchar_25 | Varchar(25) | No | Transaction code for the Transaction Type specified | No |
| USRTRN_TRAN_TYPE | _varchar_25 | Varchar(25) | No | List of Transaction Types | No |
| USRTRN_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created User | No |
| USRTRN_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| USRTRN_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No |
| USRTRN_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | User Modified | No |
| USRTRN_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes |