Stock Return

Table Name RET_AWE_TRN_TMP

Table Comment Table to store details while adding Work Order

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

AWE_REFDOCLOCATION

varchar(15)

NULL

AWE_REFDOCTYPE

varchar(40)

NULL

Reference Document Type - takes values "Component Work Order", "Line Work Order" and "Return Slip"

AWE_REFDOCNO

varchar(40)

NULL

AWE_REFDOCOU

numeric(10)

NULL

AWE_GUID

varchar(40)

NULL

Table Name RET_RTNTMP_RETURN_TMP

Table Comment Table to store Return Documents during authorisation of Maintenance Return

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

RTNTMP_RETURN_NO

varchar(40)

NULL

RTNTMP_GUID

varchar(40)

NULL

Table Name RTN_RTNTMP_STKPLAN_TMP

Table Comment Table to store details of the return document containing disposition parts while confirmation

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

RTNTMP_GUID

varchar(40)

NULL

RTNTMP_REFDOCOU

numeric(10)

NULL

RTNTMP_REFDOCTYPE

varchar(10)

NULL

Refernece Document Type - "##" is the value sent

RTNTMP_REFDOCNO

varchar(40)

NULL

Reference Document No - Sent Value "DOC9999"

RTNTMP_LINE_NO

numeric(10)

NULL

RTNTMP_SUBLINE_NO

numeric(10)

NULL

RTNTMP_SCHDULE_NO

numeric(10)

NULL

RTNTMP_RTNTRANDATE

datetime

NULL

RTNTMP_RTN_QTY

numeric(28,8)

NULL

RTNTMP_RTN_TRANUOM

varchar(20)

NULL

RTNTMP_PART_PLN_OU

numeric(10)

NULL

RTNTMP_PART_CRT_OU

numeric(10)

NULL

RTNTMP_PART_NO

varchar(40)

NULL

RTNTMP_TRAN_STATUS

varchar(5)

NULL

RTNTMP_WH_CODE

varchar(20)

NULL

RTNTMP_WH_OU

numeric(10)

NULL

RTNTMP_PROCESS_FLAG

varchar(10)

NULL

Process Flag - Allowed Values being "RCPT"

Table Name Rtn_SRtnPrm_parameter_dtl

Table Comment Stores meta data Parameter detail information.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

SRtnPrm_ComponentName

varchar(20)

NOT NULL

Component Code.

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

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

SRtnPrm_ParamCode

varchar(5)

NOT NULL

Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component. List &nbspof Codes  & Description TLOG          --  &nbspTechlog HWO           --  &nbspHangar Work Order MC                --  &nbspMain Core RG                --  &nbspRegular GNISU         -- &nbspGeneral Issue UPISU         --  &nbspUnplanned Issue

SRtnPrm_Langid

numeric(10,0)

NOT NULL

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

SRtnPrm_ParamDesc

varchar(80)

NULL

Description of the Param Code.

SRtnPrm_sort_by

numeric(10,0)

NULL

The order in which the values are populated..

SRtnPrm_CreationDate

datetime

NULL

Date of Creation.

Table Name Rtn_SRtnQc_Quick_Code

Table Comment this table used to store the quick code values

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

SRtnQc_OUInstance

numeric(10,0)

NOT NULL

Quick Code OU.

SRtnQc_Quick_Code

varchar(25)

NOT NULL

Quick Code Value

SRtnQc_Type

NOT NULL

the quick code type for which quick codes have to be defined. The system provides the option Return Category and Return User Status

SRtnQc_Desc

varchar(80)

NULL

A textual description for the quick code

SRtnQc_Status

varchar(20)

NULL

Status of the Quick Code. Will have Active and Inactive as Values.

SRtnQc_CreatedDate

datetime

NULL

Date on which Quick Code was created.

SRtnQc_Created_By

varchar(18)

NULL

User who has created the Quick Code.

SRtnQc_ModifiedDate

datetime

NULL

Date on which Quick code was modified.

SRtnQc_Modified_By

varchar(18)

NULL

User who has modified the quick code.

SRtnQc_Timestamp

numeric(10,0)

NULL

TimeStamp.

Table Name RTN_SRTNTMP_CRMRT_TMP

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

SRTN_GUID

varchar(40)

NULL

GUID

varchar(40)

NULL

CONTRLTYPE

varchar(25)

NULL

Part Control Type "Serial Controlled", "Lot Controlled", "Serial-Lot Controlled" and "" are the allowd values

SRTN_CONTRLTYPE

varchar(25)

NULL

SRTN_EXPENSETYPE

varchar(25)

NULL

EXPENSETYPE

varchar(25)

NULL

Part Expense Type "Capital", "Revenue" and "" are the allowed Values

ISSUEDQTY

numeric(28,8)

NULL

Issued Qty

SRTN_ISSUEDQTY

decimal(28,8)

NULL

SRTN_ISSUEPARTOU

decimal(10)

NULL

ISSUEPARTOU

numeric(10)

NULL

SRTN_ISSUEPARTNO

varchar(40)

NULL

ISSUEPARTNO

varchar(40)

NULL

ISSUEUOM

varchar(10)

NULL

SRTN_ISSUEUOM

varchar(10)

NULL

ISSUEOU

numeric(10)

NULL

SRTN_ISSUEOU

decimal(10)

NULL

SRTN_LINENO

decimal(10)

NULL

LINENO

numeric(10)

NULL

LOTNO

varchar(18)

NULL

SRTN_LOTNO

varchar(40)

NULL

SRTN_SERIALNO

varchar(40)

NULL

SERIALNO

varchar(40)

NULL

PARTDESC

varchar(150)

NULL

SRTN_PARTDESC

varchar(150)

NULL

SRTN_PARTCONDITION

varchar(25)

NULL

PARTCONDITION

varchar(25)

NULL

Part Condition. Allowed Values being "Servicable","Unservicable","Exchange" and "Overhauled"

SRTN_RETURNBASIS

varchar(25)

NULL

RETURNBASIS

varchar(25)

NULL

Return Basis . Allowed Values are "returnable", "non-returnable" and "core-returnable"

SRTN_RETURNBASISDESC

varchar(255)

NULL

RETURNBASISDESC

varchar(255)

NULL

Description

RETURNPARTOU

numeric(10)

NULL

SRTN_RETURNPARTOU

decimal(10)

NULL

RETURNPARTNO

varchar(40)

NULL

SRTN_RETURNPARTNO

varchar(40)

NULL

RETURNQTY

numeric(28,8)

NULL

SRTN_RETURNQTY

decimal(28,8)

NULL

SRTN_RETURNSRLNO

varchar(40)

NULL

RETURNSRLNO

varchar(40)

NULL

RETURNLOTNO

varchar(18)

NULL

SRTN_RETURNLOTNO

varchar(40)

NULL

RETURNUOM

varchar(10)

NULL

SRTN_RETURNUOM

varchar(10)

NULL

SRTN_RETURNCONDITION

varchar(25)

NULL

TYPE

varchar(25)

NULL

SRTN_TYPE

varchar(25)

NULL

PARTSTATUS

varchar(25)

NULL

Part Status which takes all User defined Stock Status

CVALUE

numeric(28,8)

NULL

Cost of the Part returned

SRTN_PARTSTATUS

varchar(40)

NULL

SRTN_CVALUE

decimal(28,8)

NULL

ISSUENO

varchar(40)

NULL

TASKNO

varchar(30)

NULL

SRTN_ISSUENO

varchar(40)

NULL

WAREHOUSEID

varchar(10)

NULL

SRTN_TASKNO

varchar(30)

NULL

WAREHOUSEOU

numeric(10)

NULL

SRTN_WAREHOUSEID

varchar(10)

NULL

WAREHOUSEDESC

varchar(255)

NULL

SRTN_WAREHOUSEOU

decimal(10)

NULL

SRTN_WAREHOUSEDESC

varchar(255)

NULL

TIMESTAMP

numeric(10)

NULL

SRTN_TIMESTAMP

decimal(10)

NULL

ISSUELINENO

numeric(10)

NULL

TASKSEQNO

numeric(10)

NULL

SRTN_ISSUELINENO

decimal(10)

NULL

ISSUETYPE

varchar(5)

NULL

Issue Type . Possible Values are "Maintenance Issue", "General Issue" and "Unplanned Issue"

SRTN_TASKSEQNO

decimal(10)

NULL

SRTN_ISSUETYPE

varchar(5)

NULL

SRTN_EXPIRYDATE

datetime

NULL

SRTN_ISSUECOST

decimal(28,8)

NULL

SRTN_REFERENCE_NO

varchar(40)

NULL

SRTN_REMARKS

varchar(255)

NULL

SRTN_ACC_USAGE

varchar(20)

NULL

SRTN_CC_USAGE

varchar(20)

NULL

SRTN_MAT_TYPE

varchar(5)

NULL

SRTN_ROWCOUNT

int

NULL

SRTN_CERTNO

varchar(40)

NULL

SRTN_CERTTYPE

varchar(25)

NULL

SRTN_CERTDATE

datetime

NULL

SRTN_REFLOTNO

varchar(40)

NULL

Table Name SRN_VWRETQTY_DETAIL_TMP

Table Comment Table to Calculate Pending Returned Quantity

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

SRNTMP_GUID

varchar(40)

NOT NULL

SRNTMP_REF_DOC_NUMBER

varchar(40)

NULL

Reference Document Number for which pending return quantity is checked

SRNTMP_REF_DOC_TYPE

varchar(5)

NULL

Reference Document Type. Allowed Values are "Return Slip","Component Work Order", "Line Work Order" and Blank

SRNTMP_RETURN_NO

varchar(18)

NULL

Return Document Number

SRNTMP_RETURN_PART_NO

varchar(40)

NULL

Returned Part Number

SRNTMP_RETURN_QTY

numeric(28,8)

NULL

Quantity of the Part returned

Table Name SRTN_RTNADL_STK_RET_ADL_TMP

Table Comment Table to store Serial/Lot Details in return document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

RTNADLTMP_GUID

varchar(40)

NULL

RTNADLTMP_OUINSTANCE

numeric(10)

NULL

RTNADLTMP_RETURN_NO

varchar(18)

NULL

RTNADLTMP_RETURN_LINE_NO

numeric(10)

NULL

RTNADLTMP_SEQ_NO

numeric(10)

NULL

RTNADLTMP_ZONE_ID

varchar(10)

NULL

RTNADLTMP_BIN_ID

varchar(10)

NULL

RTNADLTMP_RET_QTY

numeric(28,8)

NULL

RTNADLTMP_RET_QTY_INSTKUOM

numeric(28,8)

NULL

RTNADLTMP_ISS_QTY_INSTKUOM

decimal(28,8)

NULL

RTNADLTMP_ISS_QTY

decimal(28,8)

NULL

RTNADLTMP_ISSUECOST

decimal(28,8)

NULL

Table Name SRtn_RtnAdl_Stk_Return_Adl

Table Comment table which is used to store the storage information for the returned parts

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

RtnAdl_Rtn_Cost

decimal(28,8)

NULL

Return Cost at Wh-Zone-Bin level

RtnAdl_Ret_Qty_InStkUom

numeric(28,8)

NULL

Quantity returned (in stock uom) to the Zone or Zone-bin

RtnAdl_Ret_Qty

numeric(28,8)

NULL

Quantity that is getting returned to the Zone or Zone-bin

RTNADL_ISS_COMPUTED_COST

decimal(28,8)

NULL

issued part cost

RtnAdl_Issue_Qty_InStkUom

decimal(28,8)

NULL

Issue Quantity in Stock uom at the time of Return document creation

RtnAdl_Issue_Cost

decimal(28,8)

NULL

Issue Cost for the Issued quantity

RTNADL_ISS_COMPUTED_DATE

datetime

NULL

date on which &nbspissued part rate is getting calculated

RtnAdl_Return_No

varchar(18)

NOT NULL

System generated number for the Return transaction based on the ’Numbering Type’ choosen

RtnAdl_OUInstance

numeric(10,0)

NOT NULL

OU ID of the ’Return’ transaction

RtnAdl_Bin_Id

varchar(10)

NULL

Zone-Bin Id to where the part is getting returned This will be NULL if the Zone is a free Zone

RtnAdl_Zone_Id

varchar(10)

NULL

Zone Id to where the Part is getting returned

RtnAdl_Rtn_SysLine_No

numeric(10,0)

NOT NULL

Line no generated for each part return instance of the return document

RtnAdl_Seq_No

numeric(10,0)

NOT NULL

Seqno is the unique number generated for each return at zone-bin level for the ReturnDoc-LineNo combination

Table Name SRtn_RtnDA_Doc_Attach_Dtl

Table Comment This table allows you to store the reference information for the return.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

RtnDA_Doc_Id

varchar(18)

NOT NULL

Document Id

RtnDA_File_Name

varchar(50)

NULL

Reference File Name

RtnDA_Remarks

varchar(255)

NULL

Remarks (if any)

RtnDA_OUInstance

numeric(10,0)

NOT NULL

OU ID of the ’Return’ transaction

RtnDA_Ref_Doc_Type

varchar(15)

NOT NULL

Reference Document Type

RtnDA_Return_No

varchar(18)

NOT NULL

System generated number for the Return transaction based on the ’Numbering Type’ choosen

Table Name SRTN_RTNDTL_IS_TMP

Table Comment Tempory Table Used to populate Data for IS

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

RTNDTL_RETURNNO

varchar(40)

NULL

Return No

RTNDTL_RETLINENO

numeric(10)

Detail Level Line &nbspNumber for the Part

RTNDTL_REFDOCNO

varchar(40)

Reference Document Number

RTNDTL_REFDOCTYPE

varchar(25)

Reference Document Type

RTNDTL_TASKSEQNO

numeric(10)

Sequence Number for the Task

RTNDTL_PARTOU

Part Created OU Id

RTNDTL_PARTNO

varchar(40)

Part Number returned

RTNDTL_PARTSRLNO

Serial Number of the Part Returned

RTNDTL_QTY

numeric(28,8)

Quantity to be returned

RTNDTL_RTNUOM

varchar(10)

UOM in which part is returned

RTNDTL_RTNWH

varchar(15)

Return Warehouse Description

RTNDTL_RTNDT

datetime

Return Date

RTNDTL_TASKOU

numeric(10)

Task OU Id

RTNDTL_TASKNO

varchar(30)

Task Number

RTNDTL_RTNWHOU

numeric(10)

Return Warehouse Id

RTNDTL_ISSPRTOU

Issued Part’s created OU id.

RTNDTL_ISSPRTNO

varchar(40)

Issued Part Number

RTNDTL_ISSPRTSRLNO

Issued Part’s Serial Number

RTNDTL_ISSQTY

numeric(28,8)

Issued Part’s Quantity

RTNDTL_ISSUOM

varchar(10)

UOM of the Issued Part

RTNDTL_QTYINSTKUOM

numeric(28,8)

Quantoty of the Part in Stock UOM

RTNDTL_GUID

varchar(40)

Guid

RTNDTL_QTYFLG

varchar(25)

RTNDTL_RETLOTNO

varchar(18)

RTNDTL_STOCKSTATUS

varchar(40)

Table Name SRTN_RTNDTL_STK_RET_DTL_TMP

Table Comment Temp Table to populate Detail Table of Return after Regeneration of Line Number

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

RTNDTLTMP_GUID

varchar(40)

NULL

Guid

RTNDTLTMP_OUINSTANCE

numeric(10)

OUInstance of the Return Document

RTNDTLTMP_RETURN_NO

varchar(18)

Return Document’s Number

RTNDTLTMP_RETURN_LINE_NO

numeric(10)

Line Number maintained at Part Level

RTNDTLTMP_ISSUE_OU

Issue Transaction’s OU

RTNDTLTMP_ISSUE_DOC_NO

varchar(18)

Issue Document Number

RTNDTLTMP_ISSUE_LINE_NO

numeric(10)

RTNDTLTMP_ISSUE_WH_OU

Issue Warehouse OU

RTNDTLTMP_ISSUE_WH_ID

varchar(10)

Issue Warehouse’s ID

RTNDTLTMP_ISSUE_PART_CRT_OU

numeric(10)

Part Created OU maintained at Issue Level

RTNDTLTMP_ISSUE_PART_NO

varchar(40)

Part NUmber maintained at Issue Level

RTNDTLTMP_ISSUE_SRL_NO

Serial Number of the Part maintained at Issue Level

RTNDTLTMP_ISSUE_LOT_NO

varchar(18)

Lot Number of the Part maintained at Issue Level

RTNDTLTMP_RETURN_PART_CRT_OU

numeric(10)

Part Created OU maintained in Return Transaction

RTNDTLTMP_RETURN_PART_NO

varchar(40)

Returned Part Number

RTNDTLTMP_RETURN_QTY

numeric(28,8)

Quantity of the Part returned

RTNDTLTMP_RETURN_UOM

varchar(10)

UOM in which part is returned

RTNDTLTMP_RET_QTY_INSTKUOM

numeric(28,8)

Quantity in Stock UOM

RTNDTLTMP_PART_CONDITION

varchar(25)

Part Condition which takes values like "Servicable","Unservicable",Exchange and "Overhauled"

RTNDTLTMP_PART_STATUS

Part Status which takes User Defined Stock Status

RTNDTLTMP_LOT_NO

varchar(18)

Lot Number of the Part returned

RTNDTLTMP_SERIAL_NO

varchar(40)

Serial NUmber of the Part returned

RTNDTLTMP_RETURN_BASIS

varchar(25)

Return Basis that takes values like "Returnable", "Non Returnable" and "Core Returnable"

RTNDTLTMP_CREATED_BY

varchar(30)

Created User Name

RTNDTLTMP_CREATED_DATETIME

datetime

Date on which record is created

RTNDTLTMP_MODIFIED_BY

varchar(30)

Modified User Name

RTNDTLTMP_MODIFIED_DATETIME

datetime

Date on which data is modfied

RTNDTLTMP_TIMESTAMP

numeric(10)

Integer TimeStasmp for maintaining concurrency

RTNDTLTMP_RTN_COST

numeric(28,8)

Cost of the Part Returned( This inclued Part Cost at Issue Level + TCD Value)

Table Name SRtn_RtnDtl_Stk_Return_Dtl

Table Comment This will have the returned part details of the Return Document. Note: &nbspIssue details will be NULL for unplanned Returns.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

RtnDtl_OUInstance

numeric(10,0)

NOT NULL

OU ID of the ’Return’ transaction.

RtnDtl_Return_No

varchar(18)

NOT NULL

System generated number for the Return transaction based on the ’Numbering Type’ choosen.

RtnDtl_Rtn_SysLine_No

numeric(10,0)

NOT NULL

Line no generated for each part return instance of the return document.

RtnDtl_Rtn_DisplayLine_No

decimal(10)

NULL

Display Line Number.

RtnDtl_Issue_OU

numeric(10,0)

NULL

For Issue based maintenance returns and inventory returns, this will have the OU ID of the Issue Document, in all other cases, this will be NULL..

RtnDtl_Issue_Doc_No

varchar(18)

NULL

For Issue based maintenance returns and inventory returns, this will have the Issue document no. In all other cases, this will be NULL..

RtnDtl_Issue_Line_No

numeric(10,0)

NULL

For Issue based maintenance returns and inventory returns, this will have the Line no of the Issued part for which the return is &nbspmade. In all other cases, this will be NULL..

RtnDtl_Issue_Wh_Ou

numeric(10,0)

NULL

This will have the OU ID of the Issue Warehouse. All planned returns are made either against the issue document or across issue doc at IssuedWarehouse-IssuePart-Srl-Lot level.

RtnDtl_Issue_Wh_Id

varchar(10)

NULL

Issue Warehouse Id. All planned returns are made either against the issue document or across issue doc at IssuedWarehouse-IssuePart-Srl-Lot level..

RtnDtl_Issue_Part_Crt_OU

numeric(10,0)

NULL

Created OU Id of the Issued part for which the return is to be made.

RtnDtl_Issue_Part_No

varchar(40)

NULL

Issued part for which the return is to be made.

RtnDtl_Issue_Part_Status

varchar(40)

NULL

Part Status.

RtnDtl_Issue_Srl_No

varchar(40)

NULL

Issue Part Serial No. All planned returns are made either against the issue document or across issue doc at IssuedWarehouse-IssuePart-Srl-Lot level.

RtnDtl_Issue_Lot_No

varchar(18)

NULL

Issue Part Lot No. All planned returns are made either against the issue document or across issue doc at IssuedWarehouse-IssuePart-Srl-Lot level.

RtnDtl_Return_Part_Crt_Ou

numeric(10,0)

NULL

Created OU Id of the Return Part No.

RtnDtl_Return_Part_No

varchar(40)

NULL

The part number of the returned part.

RtnDtl_Return_Qty

numeric(28,8)

NULL

The quantity of parts returned.

RtnDtl_Return_Uom

varchar(10)

NULL

Uom of the quantity returned.

RtnDtl_Returned_Qty_InStkUom

numeric(28,8)

NULL

Quantity returned in stock uom.

RtnDtl_Issue_Qty_InStkUom

decimal(28,8)

NULL

Issue Quantity in Stock uom at the time of Return document creation.

RtnDtl_Issue_Cost

NULL

Issue Cost for the Issued quantity.

RtnDtl_Part_Condition

varchar(25)

NULL

Condition of the part at the time of return.

RtnDtl_Part_Status

varchar(40)

NULL

Status of the returned part at the time of return.

RtnDtl_Lot_No

varchar(18)

NULL

Returned Part Lot No.

RtnDtl_New_Lot_No

varchar(40)

NULL

System Generated Lot Number(after confirmation of Return Document).

RtnDtl_Serial_No

varchar(40)

NULL

Serial Number of Part involved in the Return Document(if any).

RtnDtl_Return_Basis

varchar(25)

NULL

’Returns’ can be done on the following basis (1) Core  - Cr         -  &nbspWhen the returned part is different       &nbspfrom that of the issued part, the                             &nbspreturn will be considered to be core        &nbspreturnable provided the part is classifed as         ’core returnable’ (2) Excess  - Ex   -  &nbspWhen the issued part is not fully consumed       &nbspand the remaining/excess is returned (3) Returnable  - Rt     -  &nbspWhen the issued part is not of          &nbspconsumable kind of a part (tools for e.g.)         &nbspand it is returned back to stores..

RtnDtl_Expiry_Date

datetime

NULL

The date of expiry of the part being returned

RtnDtl_Acc_Usage

varchar(20)

NULL

The type of the accounting usage.

Rtndtl_Cc_Usage

varchar(20)

NULL

The type of the costing usage.

RtnDtl_Fin_Book

varchar(20)

NULL

Finance Book.

RtnDtl_Acc_Code

varchar(32)

NULL

Accounting Code.

RtnDtl_Anly_Code

varchar(5)

NULL

Analysis Code.

RtnDtl_SubAnly_Code

NULL

Sub Analysis Code.

Rtndtl_Costcenter_Code

varchar(10)

NULL

Cost Center Code.

RtnDtl_Created_By

varchar(30)

NULL

The name of the user who created the return document.

RtnDtl_Created_Datetime

datetime

NULL

The date on which the return document was created.

RtnDtl_Modified_By

varchar(30)

NULL

The name of the user who last modified the return document.

RtnDtl_Modified_Datetime

datetime

NULL

The date on which the return document was last modified.

RtnDtl_Timestamp

numeric(10,0)

NULL

Integer Timestamp which is maintained for concurrency.

RtnDtl_Rtn_Cost

numeric(28,8)

NULL

Cost of the Part returned.

Rtndtl_Reference_No

varchar(40)

NULL

The code identifying the reference document associated with the stock return document.

Rtndtl_Remarks

varchar(255)

NULL

Textual description of the comments.

Rtndtl_Task_No

varchar(40)

NULL

The task associated with the work order for every part returned, if the reference document type is “Component Work Order”.

Rtndtl_Task_Seq_No

decimal(12)

NULL

This field pertains to Task Serial Number.

Rtndtl_Mat_Type

varchar(5)

NULL

The material type, which could be “Main Core” or “Regular”.

RTNDTL_OWNERSHIP

varchar(5)

NULL

The owner of the part, which could be “Customer”, “Owned” or “Supplier”.

RTNDTL_OWNINGAGENCY

varchar(45)

NULL

The code identifying the agency that owns the part.

RTNDTL_OWNAGENCY_OU

decimal(10)

NULL

The ou code identifying the agency that owns the part.

RTNDTL_NEW_PART_FLG

varchar(5)

NULL

this is a flag which is used to identify whether new part has to be returned

RTNDTL_GEN_SERIAL_NO

varchar(40)

NULL

part general serial no

RTNDTL_RETURN_CLS

char(25)

NULL

return classification

RTNDTL_SERIAL_NO_PFX

varchar(6)

NULL

serial no prefix

RTNDTL_SERIAL_NO_SFX

varchar(6)

NULL

serial no suffix

RTNDTL_SERIAL_RUNNING_NO

decimal(10)

NULL

RTNDTL_MCRTNPRTCHGDFLG

varchar(5)

NULL

RTNADL_ISS_COMPUTED_COST

decimal(28,8)

NULL

issued part rate

RTNADL_ISS_COMPUTED_DATE

datetime

NULL

date on which issued part rate is getting calculated

RTNADL_CERTDATE

sql_variant

NULL

The date on which the certificate was issued

RTNADL_CERTNO

sql_variant

NULL

The number identifying the certificate.

RTNADL_CERTTYPE

sql_variant

NULL

The certificate type associated with the part.

RTNADL_RETLOTNOTYPE

sql_variant

NULL

The return lot type of the part.

RTNADL_MANUFLOTNO

sql_variant

NULL

A unique number identifying the lot number issued by the manufacturer.

RTNDTL_OVERHAUL_VALUE

bigint

NULL

RTNDTL_LEADPARAM_VALUE

bigint

NULL

RTNDTL_VARIABLE_VALUE

bigint

NULL

RTNDTL_TASK_PART_SEQ_NO

int

NULL

RTNDTL_PART_COST

bigint

NULL

RTNADL_MANUFSERIALNO

varchar(40)

NULL

To Store Manufacturer Serial No

RtnDtl_New_Serial_No

varchar(40)

NULL

To Store new serial no

RtnDtl_TaskNo_Editable_Flag

varchar(5)

NULL

TaskNo Editable flag

RTNDTL_TO_PART_STATUS

varchar()

NULL

This column is used to store To Part Status

RTNDTL_SSC_NO

varchar()

NULL

This column is used to save Stock Status conversion document

RTNDTL_SSC_LOT_NO

varchar()

NULL

This column is used to save the newly Lot # generated

Table Name SRtn_RtnMn_Stk_Return_Hdr

Table Comment This table has the details of all kinds of returns - Inventory, Maintenance and Unplanned Returns..

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

RtnMn_OUInstance

numeric(10,0)

NOT NULL

OU ID of the ’Return’ transaction.

RtnMn_Return_No

varchar(18)

NOT NULL

System generated number for the Return transaction based on the ’Numbering Type’ choosen.

RtnMn_Return_Type

varchar(5)

NULL

This flag will indicate whether the ’Return’ document is against an inventory issue (inventory/unplanned issue) or maintenance issue or is an Unplanned Return This will have the following codes and values. ’Gen’ &nbspfor General or Inventory Returns ’Mnt’ for Maintenance Returns ’URt’ for Unplanned Returns.

RtnMn_Return_Status

varchar(5)

NULL

Following are be ’Return’ document status codes and their description. Draft              - &nbspDrft Fresh             - &nbspFrsh Cancelled      - &nbspCanc Confirmed      - &nbspConf 1) Draft &nbspWhenever all details are not entered the    &nbsptransaction can be created in draft status. 2) Fresh &nbspWhenever all details are entered the Stock   &nbspReturn transaction can be created in fresh   &nbspstatus. It can be also be attained while  &nbspmodifying the transaction, which is in ’Draft’  &nbspstatus. 3) Confirmed: Stock Return attains this status in    &nbspconfirm activity when the details are    &nbspconfirmed. A confirmed Stock Return    &nbsptransaction cannot be cancelled. Only ’Fresh’    &nbsptransaction can be authorized. 4) Cancelled: Both Draft as well as Fresh    &nbsptransactions can be cancelled. Transactions    &nbspof status ’Draft’ can be cancelled in Create as    &nbspwell as Edit Stock Return activity.    &nbspTransactions of the type ’Fresh’ can be       &nbspcancelled in Edit as well as Confirmed Stock       &nbspReturn activity. .

RtnMn_Category

varchar(25)

NULL

User defined return categories.

RtnMn_User_Status

varchar(25)

NULL

User defined statuses for the Return Document.

RtnMn_Warehouse_OU

int

NULL

OU Id of the warehouse where the parts are returned..

RtnMn_Warehouse

varchar(10)

NULL

The warehouse to where the parts are returned.

RtnMn_Return_Date

datetime

NULL

The date on which the parts are returned.

RtnMn_Ref_Doc_Type

varchar(10)

NULL

The type of the reference document. Tech Log – This indicates that a technical log has triggered the return document   Component Work Order – This indicates that a component work order &nbsphas triggered the return document.  &nbspReturn Slip – This indicates that a return slip has triggered the return document.  &nbspGeneral Issue – This indicates that an issue has triggered the return document. Unplanned Issue- This indicates that an unplanned issue has triggered the return document. Maintenance Material Request - This indicate that the issue raised against the “Maintenance Material Request” type of reference document has triggered the return.

RtnMn_Ref_Doc_OU

int

NULL

OU ID of the reference document no against which the return is made. .

RtnMn_Ref_Doc_No

varchar(40)

NULL

A unique number identifying the reference document based on which this return is created

RtnMn_User_Def_1

varchar(25)

NULL

User-defined details of the parts returned.

RtnMn_User_Def_2

NULL

RtnMn_Remarks

varchar(255)

NULL

Textual description of the comments.

RtnMn_Return_By

varchar(20)

NULL

The id of the person who returns the parts.

RtnMn_Return_By_Name

varchar(150)

NULL

Name of the employee who returned the parts to inventory (just a reference name is captured if returned by code is not specified)

RtnMn_Confirmed_By

varchar(30)

NULL

The name of the user who confirmed the return document.

RtnMn_Confirmed_Datetime

datetime

NULL

The date on which the return document was confirmed.

RtnMn_Return_Flag

varchar(25)

NULL

This indicates whether Return has been made at WorkOrder-Issue Doc Level or WorkOrder Level. The following will be the codes and values stored in this col ’Wo’ for WorkOrder based returns ’IsuWo’ for Issuwise return for the workorder                 &nbspdocument..

RtnMn_FileName

varchar(50)

NULL

The file name of the reference document pertaining to the stock return.

RtnMn_Acc_Usage

varchar(20)

NULL

The type of the accounting usage.

RTMMN_OWNERSHIP_OU

int

NULL

ownership ou

RtnMn_Ownership

varchar(40)

NULL

The owner of the part, which could be “Customer”, “Owned” or “Supplier”.

RtnMn_Ownership_Code

varchar(45)

NULL

The code identifying the agency that owns the part.

RtnMn_Cc_Usage

varchar(20)

NULL

The type of the costing usage.

RtnMn_Created_By

varchar(30)

NULL

The name of the user who created the return document. .

RtnMn_Created_Datetime

datetime

NULL

The date on which the return document was created.

RtnMn_Ownership_Ou

char(18)

NULL

Ownership Ouinstance.

RtnMn_Modified_By

varchar(30)

NULL

The name of the user who last modified the return document.

RtnMn_Modified_Datetime

datetime

NULL

The date on which the return document was last modified.

RtnMn_Timestamp

int

NULL

Integer Timestamp which is maintained for concurrency.

RTNMN_TradingPartnerNo

sql_variant

NULL

The code identifying the trading partner.

RTNMN_TradingPartnerType

sql_variant

NULL

The type of the trading partner, which could be “Supplier” or “Customer”.

RTNMN_TradingPartnerOU

int

NULL

trading partner ou

Table Name SRtn_URtDtl_UPl_StkRtn_Dtl

Table Comment This will have the returned part details of the Return Document. Note: &nbspIssue details will be NULL for unplanned Returns

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Urtdtl_Costcenter_Code

varchar(10)

NULL

Cost Center Code

URtDtl_SubAnly_Code

varchar(5)

NULL

Sub Analysis Code

URtDtl_Created_By

varchar(30)

NULL

Created Login User Name

URtDtl_Created_Datetime

datetime

NULL

Created date and time

URtDtl_Modified_By

varchar(30)

NULL

Last modified login user name

Urtdtl_Cc_Usage

varchar(20)

NULL

The type of the costing usage

URtDtl_Anly_Code

varchar(5)

NULL

Analysis Code

URtDtl_Fin_Book

varchar(20)

NULL

Finance Book

URtDtl_Acc_Code

varchar(32)

NULL

Accounting Code

URTDTL_ACC_USAGE

varchar(20)

NULL

The type of the accounting usage.

URTDTL_OWNINGAGENCY

varchar(45)

NULL

The code identifying the agency that owns the part.

URTDTL_OWNERSHIP

varchar(5)

NULL

The owner of the part, which could be “Customer”, “Owned” or “Supplier”.

URTDTL_OWNAGENCY_OU

decimal(10)

NULL

ou code (The code identifying the agency )

URTDTL_COMPUTED_VALUE

decimal(28,8)

NULL

the cost of the returned part

URtDtl_Modified_Datetime

datetime

NULL

Last Modified date and time

URtDtl_Timestamp

numeric(10,0)

NULL

Integer Timestamp which is maintained for concurrency

URTDTL_RETURN_CLS

char(25)

NULL

return classification

URtDtl_Reference_No

varchar(40)

NULL

Reference Number

URtDtl_Remarks

varchar(255)

NULL

Remarks

URTDTL_COMPUTED_DATE

datetime

NULL

returned part cost calculated date

URtDtl_Return_Qty

numeric(28,8)

NULL

Qty returned

URtDtl_Return_Part_No

varchar(40)

NULL

Returned Part No

URtDtl_Return_Uom

varchar(10)

NULL

Uom of the quantity returned

URtDtl_Returned_Qty_InStkUom

numeric(28,8)

NULL

Quantity returned in stock uom

URtDtl_Part_Condition

varchar(25)

NULL

Condition of the part at the time of return

URtDtl_OUInstance

numeric(10,0)

NOT NULL

OU ID of the ’Return’ transaction

URtDtl_Return_Part_Crt_Ou

numeric(10,0)

NULL

Created OU Id of the Return Part No

URtDtl_Return_No

varchar(18)

NOT NULL

System generated number for the Return transaction based on the ’Numbering Type’ choosen

URtDtl_Rtn_SysLine_No

numeric(10,0)

NOT NULL

Line no generated for each part return instance of the return document

URtDtl_Expiry_Date

datetime

NULL

Expiry Date can be reset for the component while returning

URtDtl_Zone_Id

varchar(10)

NULL

Zone where the part is getting returned. This will be NULL for free warehouse

URtDtl_Return_Condition

varchar(25)

NULL

Return Condition

URtDtl_Bin_Id

varchar(10)

NULL

Bin where the part is getting returned. This will be NULL for Free Zones

URtDtl_Part_Value

numeric(28,8)

NULL

Part Value

URtDtl_Part_Status

varchar(25)

NULL

Status of the returned part at the time of return

URtDtl_Lot_No

varchar(40)

NULL

Returned Part Lot No

URtDtl_Return_Basis

varchar(25)

NULL

’Returns’ can be done on the following basis (1) Core  - Cr         -  &nbspWhen the returned part is different       &nbspfrom that of the issued part, the                             &nbspreturn will be considered to be core        &nbspreturnable provided the part is classifed as         ’core returnable’ (2) Excess  - Ex   -  &nbspWhen the issued part is not fully consumed       &nbspand the remaining/excess is returned (3) Returnable  - Rt     -  &nbspWhen the issued part is not of          &nbspconsumable kind of a part (tools for e.g.)         &nbspand it is returned back to stores.

URtDtl_New_Lot_No

varchar(40)

NULL

New Lot Number

URtDtl_Serial_No

varchar(40)

NULL

Serial Number

Table Name SRTN_VWPENQTY_DETAIL_TMP

Table Comment Table to calculate and store pending return quantity

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

SRTNTMP_GUID

varchar(40)

NOT NULL

SRTNTMP_REF_DOC_NUMBER

varchar(40)

NULL

SRTNTMP_REF_DOC_TYPE

varchar(5)

NULL

Reference Document Type . Allowed Values are "Component Work Order","Line Work Order" and "Return Slip"

SRTNTMP_ISSUE_TRAN_NO

varchar(40)

NULL

SRTNTMP_ISSUE_PART_NO

varchar(40)

NULL

SRTNTMP_LOT_NO

varchar(40)

NULL

SRTNTMP_SRL_NO

varchar(40)

NULL

SRTNTMP_PENDING_QTY

numeric(28,8)

NULL

SRTNTMP_RETURN_BASIS

varchar(5)

NULL

Return Basis - Values are "Returnable","Core-Returnable" and "Non Returnable"

SRTNTMP_ISSUED_QTY

numeric(28,8)

NULL

SRTNTMP_ISSUED_UOM

varchar(10)

NULL

SRTNTMP_PART_TYPE

varchar(5)

NULL

Part Type - Values allowed are "Raw Material","Kit","Component’,"Consumable","Expendable" and "Tool"

SRTNTMP_RET_QTY

numeric(28,8)

NULL