User Defined Stock Status

Table Name Uds_Parameter_details

Table Comment This table holds the meta data for the component. This table will exist in all the component as part of the component. This table will hold the static values like combos, combo defaults, guidance text etc. Values are stored against the screen control.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

Uds_ComponentName

varchar(80)

NOT NULL

Name of the component - BASUDSS

Yes

No

Uds_ParamCategory

varchar(10)

NOT NULL

This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.

Yes

No

Uds_ParamType

varchar(25)

NOT NULL

Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.

Yes

No

Uds_ParamCode

varchar(40)

NOT NULL

Param code is the value to be filled in the combo box or guidance text. This is actually the meta data of this component

Yes

No

Uds_Langid

numeric(10)

NOT NULL

Language id. This is the language id of the record.

Yes

No

Uds_ParamDesc

varchar(80)

NULL

Description of the combo value

No

No

Uds_CreationDate

datetime

NOT NULL

Created date of the record.

No

No

Table Name Uds_UdsAtt_Udss_Attrib_Map

Table Comment This table stores the Attribute types that are mapped to the User defined Stock status name.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

UdsAtt_org_unit

numeric(10)

NOT NULL

OU instance

Yes

Yes

UdsAtt_udss_name

varchar(40)

NOT NULL

user defined stock status name

Yes

Yes

UdsAtt_attribute_type

varchar(25)

NOT NULL

Attribute type is the param type defined in Parameter Details table. It takes following values CC    - Cycle Counting NET - Nettable PI     - Physical Inventory ST    - Stockable VA    - Valuated ALC  - Allocable OC    - Ownership-Customer OI      - Ownership-Internal OS     - Ownership-Supplier OO     - Ownership-Others DF      -Default

Yes

No

Table Name Uds_UdsMn_Udsstatus_Master

Table Comment This table contains the master details of the User defined stock status such as OU, Udss name, udds description, Status of Udss and other details.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

UdsMn_org_unit

numeric(10)

NOT NULL

ouinstance

Yes

No

UdsMn_udss_name

varchar(40)

NOT NULL

user defined stock status name The predefined user defined stock status names are: Customer Goods PBH

Yes

No

UDSMN_UDSS_NAME_UP

varchar(40)

NOT NULL

user defined stock status name in Upper Case

No

No

UdsMn_udss_desc

varchar(150)

NOT NULL

Description of user defined stock status

No

No

UdsMn_status

varchar(25)

NOT NULL

Status of the user defined stock status It may be 1.’A’ - Active 2.’I’  - Inactive

No

No

UdsMn_created_by

varchar(30)

NULL

User who created the details

No

No

UdsMn_modified_by

varchar(30)

NULL

User who modified the details

No

No

UdsMn_created_date

datetime

NULL

Date at which user created the details

No

No

UdsMn_modified_date

datetime

NULL

Date at which the user modified the details

No

No

UDSMN_SORT_BY

numeric(10)

NULL

Sort by - it will have Order by numbers by which sorting is done in stock status combo loading

No

No

UdsMn_timestamp

numeric(10)

NULL

Timestamp for the concurrent check.

No

No

Table Name Uds_UdsPart_Udss_Part_Map

Table Comment This table stores the mapping details of the stock status with part types. It stores the various part types which take the User defined stock status.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

UdsPart_udss_name

varchar(40)

NOT NULL

user defined stock status name

Yes

Yes

UdsPart_part_type

varchar(25)

NOT NULL

Part type The Part type takes the following values : CM           - component CNSMB    -Consumable KIT           - Kit RWMTR  - Raw Material SP           - Spare Part TOOL      - Tool

Yes

No

UdsPart_org_unit

numeric(10)

NOT NULL

OU instance

Yes

Yes

Table Name Uds_UdsSts_Udss_Status_Map

Table Comment This table stores the list of User defined stock status that are mapped to a particular User defined stock status ,alternatives and Order Of Preference

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

UdsSts_Conv_Prmt_Flag

varchar(25)

NOT NULL

The Conversion Permitted Flag. It takes values Y - Yes N - No

No

No

UdsSts_Alternate_Flag

varchar(25)

NOT NULL

The Alternate Flag. It takes values Y - Yes N - No

No

No

UdsSts_Pref_Order

int

NULL

Order Of Preference for Alternatives

No

No

UdsSts_org_unit

numeric(10)

NOT NULL

OU instance

Yes

Yes

UdsSts_status_mapped

varchar(40)

NOT NULL

Mapped user defined stock status name

Yes

No

UdsSts_udss_name

varchar(40)

NOT NULL

user defined stock status name

Yes

Yes

Table Name Uds_UdsTrn_Udss_Trans_Map

Table Comment This table stores the transactions allowed for a user defined stock status.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

UdsTrn_org_unit

numeric(10)

NOT NULL

OU instance

Yes

Yes

UdsTrn_udss_name

varchar(40)

NOT NULL

user defined stock status name

Yes

Yes

UdsTrn_tran_type

varchar(25)

NOT NULL

transaction code The Transaction types are: MNISU   -Maintenance Issue UPLISU - UnPlanned Issue GISU -General Issue STISU -Stock Transfer Issue ROISU -Repair Order Issue STRC- Stock Transfer Receipt STR - Stock Transfer STKCORR - Stock Correction UPR - &nbspUnplanned Receipt GR   - &nbspGoods Receipt UPR - Unplanned Receipt UNPRET - Unplanned Return MNTRET - Maintenance Return GENRET - General Return PI -Physical Inventory CC -Cycle Count MR -Material Request LOISU - Loan Order Issue LRR - Loan Rental Receipt PSPS - Part Sale Pack Slip OPBLNO - Opening Balance REISU - Rental Order Issue SSC  - &nbspStock Status Conversion CGR - Customer Goods Receipt AC - Aircraft Creation CMC -Component Creation TR - Tools return

Yes

No

UdsTrn_default_flag

varchar(25)

NULL

The Transaction type Default Flag It takes values Y - Yes N - No

No

No

Table Name UDS_USER_STOCK_STATUS_DTL

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

UDS_TRANSACTIONTYPE

varchar(25)

NOT NULL

Transaction Type

Yes

No

UDS_FUNCTIONNAME

varchar(25)

NOT NULL

Function name

Yes

No

UDS_UDSS_CODE

varchar(40)

NOT NULL

User defined Code

Yes

No

UDS_OUINSTANCE

decimal(10)

NOT NULL

OU Instance

Yes

No

UDS_UDSS_DESCRIPTION

varchar(150)

NULL

User defined stock status description

No

No

UDS_CREATED_BY

varchar(30)

NOT NULL

User who Created the details

No

No

UDS_CREATED_DATE

datetime

NOT NULL

Date at which user created the details

No

No

UDS_MODIFIED_BY

varchar(30)

NOT NULL

User who modified the details

No

No

UDS_MODIFIED_DATE

datetime

NOT NULL

Date at which the user modified the details

No

No

UDS_TIMESTAMP

decimal(10)

NOT NULL

Timestamp for the concurrency check.

No

No