Document Numbering Class

Table Name Nc_parameter_details

Table Comment Parameter Table for the Numbering Class Component

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

ComponentName

varchar(80)

NOT NULL

Component Name

Yes

No

ParamCategory

varchar(25)

NOT NULL

Category of the Parameter

Yes

No

ParamType

varchar(40)

NOT NULL

Type of the Parameter

Yes

No

ParamCode

varchar(5)

NOT NULL

Code of the Parameter

Yes

No

ParamDesc

varchar(80)

NOT NULL

Detail Description of the Parameter

No

No

Langid

decimal(10)

NOT NULL

Language Id of the Parameter

No

No

CreationDate

datetime

NULL

Creation Date of the parameter

No

No

Sortby

decimal(10)

NULL

Sort by number  , by which parameter details are sorted

No

No

Table Name Num_FnTrn_Function_Tran_Meta

Table Comment This table will have the metadata entries containing the list of functions, and transactions available for each function.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

FnTrn_tran_type

varchar(25)

NOT NULL

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 MFNO MRNO MRQNO NRT PARTNO PONO PRNO SRLNO TECHLOGDISC TECHLOGNO THIRDPARTYJLOG THIRDPARTYJLOGDISC THIRDPARTYTECHLOG THIRDPARTYTECHLOGDISC UPR VPDRNO VPNO SSCNO

Yes

No

FnTrn_function_code

varchar(25)

NOT NULL

The following are the various function codes that will be available in the metadata... CMPMNT ENG INV LNMNT MPL PUR

Yes

No

FnTrn_transaction_code

varchar(25)

NOT NULL

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 BASFLTLOG BASFR BASGOODSRCPT BASISSUE BASLMC BASLW BASMATREQ BASMF BASPARTADMN BASPO BASPURREQ BASRECEIPT BASSTOCKMNT BASTASK BASWO

Yes

No

FnTrn_function_name

varchar(25)

NOT NULL

The following are the various function names that will be available in the metadata... Component Maintenance Engineering Inventory Line Maintenance  Planning Purchase

No

No

FnTrn_transaction_desc

varchar(80)

NOT NULL

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 Order Comp Work Order Actuals Discrepancy Processing Engineering Advice Note Engg Service Request Engineering Order Flight Log Aircraft Routing Goods Receipt Stock Issue Line Maintenance Control Line Work Order and Rep Material Request Maintenance Forecast Part Administration Purchase Order Purchase Requisition Stock Receipt Stock Maintenance Task Hanger Work Order

No

No

FnTrn_tran_type_desc

varchar(80)

NULL

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 Directives Engineering Order Engg Service Request Flight Route Number Goods Receipt Goods Return Hanger Work Order Journey Log Discrepancies Journey Log Lot No Generation Line Package Line Work Order Maintenance Issue Maintenance Forecast Maintenance Report Material Request Non Routine Task Part Numbering Purchase Order Purchase Requisition Serial No Generation Tech Log Discrepancies Tech Log Third Party Journey Log 3Party JLog Discrepancies Third Party Tech Log 3Party TLog Discrepancies Unplanned Receipt Deferment Request for VP Visit Package

No

No

Table Name Num_NcDt_DateFormat_Allowed

Table Comment This table contains the dateformat allowed in the Prefix or Suffix of the Numbering Class for Generating Document Number

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

NcDt_Allwd_Dt_Format

varchar(15)

NOT NULL

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’)

Yes

No

Table Name NUM_NUMAPP_NUMAPPL_NUMCLS_MAP

Table Comment To store numbering application numbering class mapping information

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

NUMAP_ORG_UNIT

decimal(10)

NOT NULL

Organisation Unit

No

No

NUMAP_NUM_TYPE_NO

varchar(5)

NOT NULL

Numbering Type

No

No

NUMAP_TRAN_TYPE_ORG_UNIT

decimal(10)

NOT NULL

Transaction Type OU

No

No

NUMAP_TRAN_TYPE

varchar(25)

NOT NULL

Transaction Type

No

No

NUMAP_WORK_CENTER

varchar(30)

NOT NULL

Work center

No

No

NUMAP_MODEL_NO

varchar(30)

NOT NULL

Model number

No

No

NUMAP_WAREHOUSE

varchar(30)

NOT NULL

Warehouse

No

No

NUMAP_WORKCENT_OU

decimal(10)

NOT NULL

Workcenter OU

No

No

NUMAP_MODEL_OU

decimal(10)

NOT NULL

Model OU

No

No

NUMAP_WAREHOUSE_OU

decimal(10)

NOT NULL

Warehouse OU

No

No

NUMAP_CREATED_BY

varchar(30)

NULL

Creator Id

No

No

NUMAP_CREATED_DATE

datetime

NULL

Created on

No

No

NUMAP_MODIFIED_BY

varchar(30)

NULL

Modifier ID

No

No

NUMAP_MODIFIED_DATE

datetime

NULL

Modified on

No

No

Table Name Num_NumDt_Numbering_Class_Dtl

Table 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.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

NumDt_org_unit

decimal(10)

NOT NULL

Created OuInstance of the Numbering Type Number

Yes

Yes

NumDt_num_type_no

varchar(5)

NOT NULL

Numbering Type Number

Yes

Yes

NumDt_prefix

varchar(6)

NOT NULL

Prefix which is used for the Document Number Generation for this Numbering Type Number

Yes

No

NumDt_suffix

varchar(6)

NOT NULL

Suffix which is used for Document Number Generation for this Numbering Type Number

Yes

No

NumDt_start_no

decimal(10)

NULL

Starting Numbering of the Document Number to be generated

No

No

NumDt_end_no

decimal(10)

NULL

Ending Number of the Document Number to be generated

No

No

NumDt_eff_from_date

datetime

NULL

Effective From date of the Prefix-Suffix combination for the Numbering Type Number

No

No

NumDt_eff_to_date

datetime

NULL

Effective To date of the Prefix-Suffix combination for the Numbering Type Number

No

No

NumDt_last_no_gen

decimal(10)

NULL

Last number of the Document Number generated using this Numbering Type Number

No

No

NumDt_created_by

varchar(30)

NULL

User Created

No

No

NumDt_created_date

datetime

NULL

Created Date

No

No

NumDt_modified_by

varchar(30)

NULL

User Modified

No

No

NumDt_modified_date

datetime

NULL

Modified Date

No

No

NumDt_timestamp

decimal(10)

NULL

Timestamp

No

No

Table Name Num_NumHr_Numbering_Class_Hdr

Table 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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

NumHr_org_unit

decimal(10)

NOT NULL

Created OuInstance of the Numbering Type No

Yes

No

NumHr_num_type_no

varchar(5)

NOT NULL

Numbering Type Number

Yes

No

NumHr_num_type_desc

varchar(80)

NOT NULL

Description of the Numbering Type Number

No

No

NumHr_num_type_desc_up

varchar(80)

NOT NULL

Description in Upper Case for Oracle Compatibility

No

No

NumHr_status

varchar(5)

NOT NULL

Status of the Numbering Type Number. Status can be either 1. Active  (A) or 2. Inactive (I)

No

No

NumHr_Model_OU

decimal(10)

NULL

Ou

No

No

NumHr_Model

varchar(20)

NULL

Model

No

No

NumHr_Work_Center_OU

decimal(10)

NULL

Work Center Ou

No

No

NumHr_Work_Center

varchar(30)

NULL

Work Center

No

No

NumHr_Warehouse_OU

decimal(10)

NULL

Warehouse Ou

No

No

NumHr_Warehouse_ID

varchar(10)

NULL

Warehouse Id

No

No

NumHr_created_by

varchar(30)

NULL

Created User

No

No

NumHr_created_date

datetime

NULL

Created Date

No

No

NumHr_modified_by

varchar(30)

NULL

User Modified

No

No

NumHr_modified_date

datetime

NULL

Modified Date

No

No

NumHr_timestamp

decimal(10)

NULL

Timestamp

No

No

Table Name NUM_NUMHR_NUMBERING_CLASS_HDR_FIN

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

NUMHR_ORG_UNIT_FIN

int

NOT NULL

OU

No

No

NUMHR_NUM_TYPE_NO_FIN

varchar(10)

NOT NULL

Numbering Type number

No

No

NUMHR_STATUS_FIN

varchar(5)

NOT NULL

Status

No

No

Table Name Num_NumMp_NumCls_TranType_Map

Table Comment This table contains the Numbering Type Number which are mapped to the Transaction Type with the Transaction Type OUInstance information

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

NumMp_created_date

datetime

NULL

Created Date

No

No

NumMp_created_by

varchar(30)

NULL

Created User

No

No

NumMp_default_flag

varchar(5)

NULL

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

No

NumMp_modified_by

varchar(30)

NULL

User Modified

No

No

NumMp_modified_date

datetime

NULL

Modified Date

No

No

NumMp_timestamp

decimal(10)

NULL

Timestamp

No

No

NumMp_num_type_no

varchar(5)

NOT NULL

Numbering Type Number mapped to a Transaction

Yes

Yes

NumMp_org_unit

decimal(10)

NOT NULL

Created OUInstance of the Numbering Type Number

Yes

Yes

FnTrn_transaction_code

varchar(25)

NOT NULL

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 BASFLTLOG BASFR BASGOODSRCPT BASISSUE BASLMC BASLW BASMATREQ BASMF BASPARTADMN BASPO BASPURREQ BASRECEIPT BASSTOCKMNT BASTASK BASWO

Yes

Yes

NumMp_tran_type

varchar(25)

NOT NULL

Transaction Type to which Numbering Type Number is mapped

Yes

Yes

FnTrn_function_code

varchar(25)

NOT NULL

The following are the various function codes that will be available in the metadata... CMPMNT ENG INV LNMNT MPL PUR

Yes

Yes

NumMp_tran_type_org_unit

decimal(10)

NOT NULL

OUInstance of the Transaction Type to which Numbering Type Number is mapped

Yes

No

Table Name NUM_NUMMP_NUMCLS_TRANTYPE_MAP_FIN

Table Comment To store numbering class trantype mappings.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

NUMMP_ORG_UNIT_FIN

int

NOT NULL

Organization Unit

No

No

NUMMP_NUM_TYPE_NO_FIN

varchar(10)

NOT NULL

Type number

No

No

NUMMP_TRAN_TYPE_FIN

varchar(25)

NOT NULL

Transaction type

No

No

NUMMP_TRAN_TYPE_ORG_UNIT_FIN

int

NOT NULL

Transaction Type OU

No

No

NUMMP_DEFAULT_FLAG_FIN

varchar(5)

NULL

Default Flag.

No

No

Table Name Num_UsrTrn_User_TranType_Map

Table 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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

UsrTrn_user_name

varchar(30)

NOT NULL

User having rights to Create Numbering Class and can map to the Transaction type specified

Yes

No

UsrTrn_function_code

varchar(25)

NOT NULL

Function Code of the Transaction type specified

Yes

No

FnTrn_function_code

varchar(25)

NOT NULL

The following are the various function codes that will be available in the metadata... CMPMNT ENG INV LNMNT MPL PUR

Yes

Yes

UsrTrn_transaction_code

varchar(25)

NOT NULL

Transaction code for the Transaction Type specified

Yes

No

UsrTrn_org_unit

decimal(10)

NOT NULL

OUInstance of the Transaction Type for which the User has rights to map Numbering Type information

Yes

No

FnTrn_transaction_code

varchar(25)

NOT NULL

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 BASFLTLOG BASFR BASGOODSRCPT BASISSUE BASLMC BASLW BASMATREQ BASMF BASPARTADMN BASPO BASPURREQ BASRECEIPT BASSTOCKMNT BASTASK BASWO

Yes

Yes

UsrTrn_tran_type

varchar(25)

List of Transaction Types

Yes

Yes

UsrTrn_created_by

varchar(30)

NULL

Created User

No

No

UsrTrn_created_date

datetime

NULL

Created Date

No

No

UsrTrn_modified_date

datetime

NULL

Modified Date

No

No

UsrTrn_modified_by

varchar(30)

NULL

User Modified

No

No

UsrTrn_timestamp

decimal(10)

NULL

Timestamp

No

No