Stock Receipt

Table Name Rec_RecDA_Doc_Attach_Dtl

Table Comment This table contains the document attachments or references to the ’Unplanned Receipt’ document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

RecDA_Doc_Id

varchar(40)

NOT NULL

Document Id

RecDA_Ref_Doc_Type

varchar(15)

NOT NULL

Reference Document Type

RecDA_File_Name

varchar(50)

NULL

Reference File Name

RecDA_Remarks

varchar(225)

NULL

Remarks (if any)

RECDA_DOCUMENT_OU

decimal(10)

NOT NULL

Document OU

RECDA_DOCUMENT_NO

varchar(40)

NOT NULL

ref document number

UprHdr_Document_OU

decimal(10)

NOT NULL

OUInstance

UprHdr_Document_No

varchar(18)

NOT NULL

UnPlanned Receipt Document Number. Textual field for recording the requesting document on the basis of which the transaction is to be performed.

Table Name REC_STMATLOSS_DTL

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

STMLD_OUINSTANCE_ID

int(4)

NULL

Material Loss Document OU

STMLD_MATLOSS_NO

varchar(40)

NULL

Material Loss DocumentNo

STMLD_SYSLINE_NO

int(4)

NOT NULL

The Line no to identify the records uniquely

STMLD_PRT_DISPLAYLINE_NO

int)4)

NULL

Sequence No

STMLD_PART_CRT_OU

int(4)

NULL

Part Created ou

STMLD_PART_PLN_OU

int(4)

NULL

Part Plan Ou

STMLD_PART_NO

varchar(40)

NULL

Material loss part No

STMLD_PART_STATUS

varchar(40)

NULL

Material Loss Part Status.

STMLD_PART_SERIAL

varchar(40)

NULL

Material Loss serial no

STMLD_PART_LOT

sql_variant

NULL

Material Loss Lot No

STMLD_ISU_QTY

numeric(13)

NULL

Issued Quantity

STMLD_RCPT_QTY

numeric(13)

NULL

receipt Quantity

STMLD_LOST_QTY

numeric(13)

NULL

Material Loss Quantity

STMLD_STOCK_UOM

varchar(15)

NULL

Stock Unit of Measurement

STMLD_ISS_PRT_LINE_NO

int

NULL

Part Line No

STMLD_ISS_STG_LINE_NO

int

NULL

Sequence No

STMLD_LOSSDETAIL

varchar(255)

NULL

Material Loss details

STMLD_COMMENT

sql_variant

NULL

materials loss comments

STMLD_LOSS_VALUE

numeric(13)

NULL

material Loss value

STMLD_TIMESTAMP

int

NULL

Timestamp

Table Name REC_STMATLOSS_HDR

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

STMLH_OUINSTANCE_ID

int(4)

NULL

Material Loss Document OU

STMLH_MATLOSS_NO

varchar(40)

NULL

Material Loss Document No

STMLH_STATUS

sql_variant

NULL

Material Loss Document Status

STMLH_RECORD_DATETIME

datetime

NULL

Material Loss Document recorded date

STMLH_CATEGORY

varchar(25)

NULL

Material Loss Document category loaded with the quick code containing ’loss category’ as its value in quick code.

STMLH_USER_STATUS

varchar(25)

NULL

Material Loss Document User Status loaded with the quick code containing ’’Loss User Status’ as its value in quick code.

STMLH_TOTAL_LOST

numeric(13)

NULL

Material Loss Document total lost value

STMLH_REC_WH_OU

int

NULL

Material Loss receiving warehouse Ou

STMLH_REC_WH

varchar(10)

NULL

Material Loss Document warehouse

STMLH_PARENTDOC_OU

int

NULL

Stock Transfer order Ou

STMLH_PARENTDOC_NO

varchar(40)

NULL

Stock Transfer order No

STMLH_PARENTDOC_TYPE

varchar(25)

NULL

Stock Transfer order Type

STMLH_REF_DOC_OU

int

NULL

Issue Document Ou

STMLH_REF_DOC_NO

varchar(40)

NULL

issue Document No

STMLH_REF_DOC_TYPE

varchar(25)

NULL

issue Document Type

STMLH_REMARKS

varchar(255)

NULL

Material Loss Document Remarks

STMLH_CANCEL_COMMENT

varchar(255)

NULL

Cancellation comments for material loss document.

STMLH_FILENAME

varchar(50)

NULL

Material loss Document File Name

STMLH_WF_DOC_KEY

varchar(25)

NULL

Work Flow

STMLH_WF_NEW_STATE

varchar(25)

NULL

work Flow

STMLH_CREATED_BY

varchar(30)

NULL

Created By

STMLH_CREATED_DATETIME

datetime

NULL

Created date

STMLH_MODIFIED_BY

varchar(30)

NULL

Modified By

STMLH_MODIFIED_DATETIME

datetime

NULL

Modified date

STMLH_APPROVED_BY

varchar(30)

NULL

Approved BY

STMLH_APPROVED_DATETIME

datetime

NULL

Approved date

STMLH_TIMESTAMP

int

NULL

time stamp

STMLH_CC_USAGE

varchar(25)

NULL

Costing usage

STMLH_TRADPARTNO

varchar(45)

NULL

trading partner No

STMLH_TRADETYPE

varchar(25)

NULL

trading partner type

STMLH_TRADEOU

int

NULL

trading partner Ou

STMLH_AUTOML_FLAG

varchar(5)

NULL

To check the status of create material

Table Name Rec_STRecDt_StkTrnfr_Dtl

Table Comment This table is used to store the part level details of stock transfer receipt.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

STRecDt_OUInstance_Id

decimal(10,1)

NOT NULL

OU Instance ID where the Stock Transfer Receipt is received

STRecDt_Receipt_No

varchar(40)

NOT NULL

System generated Receipt No for receiving the parts which are part of the Stock Transfer Document

STRecDt_Prt_SysLine_No

decimal(10)

NOT NULL

Receipt Line Number for the parts listed in the Stock Transfer Doc. This will be same as the Stock Tranfer Issue Doc line No as for one stock tranfer issue, there could be only one stock tranfer receipt document

STRecDt_Prt_DisplayLine_No

decimal(10)

NULL

Part Display Line Number

STRecDt_Part_Crt_Ou

decimal(10)

NULL

Created OU Id of the stock transferred Part

STRecDt_Part_Pln_Ou

decimal(10)

NULL

Planning OU Id of the stock transferred Part

STRecDt_Part_No

varchar(40)

NULL

Received Part No

STRecDt_Part_Status

varchar(40)

NULL

Status in which the part is received

STRecDt_Rcpt_Qty_InStkUom

decimal(28,8)

NULL

Receipt Quantity In Stock UOM

STRecDt_Remarks

varchar(255)

NULL

Stock Transfer Receipt remarks (if any) for the part

STRecDt_Iss_Line_No

decimal(10)

NULL

Issue Line number

STRecDt_Receipt_Cost

decimal(28,8)

NULL

Receipt Cost

STRecDt_Acc_Usage

varchar(20)

NULL

Accounting Usage

STRecDt_Fin_Book

varchar(20)

NULL

Finance Book

STRecDt_Acc_Code

varchar(32)

NULL

Accounting Code

STRecDt_Anly_Code

varchar(5)

NULL

Analysis Code

STRecDt_SubAnly_Code

varchar(5)

NULL

Sub Analysis Code

STRecDt_Timestamp

decimal(10)

NULL

Integer Timestamp which is maintained for concurrency

STRecDt_ZnBn_LnkFlag

varchar(5)

NULL

This can take the following values. ’Y’, ’N’ If the storage details are completely entered for the Line, this will be ’Y’ If the storage details are pending to be entered for the Line, this will be ’N’

STRecDt_SrlLot_LnkFlag

varchar(5)

NULL

This can take the following values. ’Y’, ’N’, ’NA’ If the serial Or Lot details are completely entered for the Line, this will be ’Y’ If the serial Or Lot details are pending to be entered for the Line, this will be ’N’ If the serial Or Lot detail is not applicable for the Line, it will be ’NA’

STRECDT_ADL_EXISTFLAG

varchar(5)

NULL

It hold value ’Y’ if it is visited and ’N’ if not required

STRECDT_COMPUTED_COST

decimal(28,8)

NULL

computed cost of receipt

STRECDT_COMPUTED_DATE

datetime

NULL

computed date

STRECDT_LOSSTRAN_COST

bigint

NULL

Used to store cost of part lost in transit

STRECDT_TRAN_COST

bigint

NULL

Table Name Rec_STRecMn_StkTrn_Hdr

Table Comment This table is used to store the document level information of stock transfer receipt

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

STRecMn_OUInstance_Id

decimal(10,1)

NOT NULL

OU Instance ID where the Stock Transfer Receipt is received

STRecMn_Receipt_No

varchar(40)

NOT NULL

System generated Receipt No for receiving the parts which are part of the Stock Transfer Document

STRecMn_Status

varchar(5)

NULL

Stock Transfer Receipt Status Following are the codes and description for ’Stock Status’ DR - Draft FR  - Fresh, CF  - Confirmed CN  - Cancelled

STRecMn_Date

datetime

NULL

Date on which Parts listed in Stock Transfer got received to Inventory

STRecMn_Category

varchar(25)

NULL

Stock Transfer Receipt Category. This is a user defined code as specified in Quick Code activity under the Quick Code Type ’Receipt Category’

STRecMn_User_Status

varchar(25)

NULL

User defined Statuses as defined in Quick Code activity under the quick code type ’Receipt ’User Status’.

STRecMn_StkTransfer_Ou

decimal(10,1)

NULL

OU Instance ID where the Stock Transfer Document is created

STRecMn_StkTransfer_No

varchar(40)

NULL

Stock Transfer Document No against which the receipt is made

STRecMn_Issue_Ou

decimal(10,1)

NULL

OU ID where the Stock Transfer Issue document was created

STRecMn_Issue_No

varchar(40)

NULL

Issue document reference for the ’Stock transfer’ document

STRecMn_Gate_Pass_No

varchar(40)

NULL

Gate Pass #

STRecMn_UnLoading_Doc

varchar(40)

NULL

Unloading Document No

STRecMn_Rcvd_Datetime

datetime

NULL

Date and time at which the stocks specified in the stock transfer doc got received

STRecMn_Pckg_Condition

varchar(25)

NULL

Packaging condition of the bulk stocks that got received as part of the ’Stock Transfer’ document

STRecMn_Received_By

varchar(30)

NULL

Employee Code/Name who is receiving the stocks part of the stock transfer document

STRecMn_Reference_Doc

varchar(40)

NULL

Reference doc if any

STRecMn_User_Def_1

varchar(25)

NULL

User defined additional information - &nbsp1

STRecMn_User_Def_2

varchar(25)

NULL

User defined additional information - &nbsp2

STRecMn_Remarks

varchar(255)

NULL

Remarks (if any)

STRecMn_FileName

varchar(50)

NULL

FileName

STRecMn_Wf_Doc_Key

varchar(20)

NULL

Document Number

STRecMn_Wf_New_State

varchar(128)

NULL

New State

STRecMn_Approved_By

varchar(30)

NULL

Approved login user name

STRecMn_Approved_Datetime

datetime

NULL

Approved date and time

STRecMn_Created_By

varchar(30)

NULL

Created Login User Name

STRecMn_Created_Datetime

datetime

NULL

Created date and time

STRecMn_Modified_By

varchar(30)

NULL

Last modified login user name

STRecMn_Modified_Datetime

datetime

NULL

Last Modified date and time

STRecMn_Timestamp

decimal(10,1)

NULL

Integer Timestamp which is maintained for concurrency

STRecMn_Cc_Usage

varchar(20)

NULL

Costing Usage

Table Name Rec_STRecSg_StkTrn_Storage

Table Comment This table is used to store the storage information of the stock transfer receipt

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

STRecSg_OUInstance_Id

decimal(10,1)

NOT NULL

OU Instance ID where the Stock Transfer Receipt is received

STRecSg_Receipt_No

varchar(40)

NOT NULL

System generated Receipt No for receiving the parts which are part of the Stock Transfer Document

STRecSg_Prt_SysLine_No

decimal(10)

NOT NULL

Receipt Line Number for the parts listed in the Stock Transfer Doc. This will be same as the Stock Transfer Issue Doc line No as for one stock tranfer issue, there could be only one stock tranfer receipt document

STRecSg_Stg_SysLine_No

decimal(10)

NOT NULL

System generated Unique sequence no to identify a storage allocation detail.

STRecSg_Stg_DisplayLine_No

decimal(10)

NULL

Display Line Number

STRecSg_Warehouse_Ou

decimal(10)

NULL

OU ID of the Warehouse where the stock is received

STRecSg_Warehouse_No

varchar(10)

NULL

Warehouse where the part is getting received

STRecSg_Zone_Id

varchar(10)

NULL

Zone where the part is getting received.

STRecSg_Bin_Id

varchar(10)

NULL

Bin Id where the part is getting received

STRecSg_Receipt_Cost

decimal(28,8)

NULL

Warehouse level Receipt Cost: Receipt cost includes Tax and charges apart from Issue cost, i.e. Receipt cost = Issue Cost + TC. This will be proportionated based on the line level receipt cost

STRecSg_Rcpt_Qty_InStkUom

decimal(28,8)

NULL

Part Quantity received in stock Uom into

STRECSG_CC_USAGE

varchar(20)

NULL

Holds the cost center for that transaction

Strecsg_Costcenter_Code

varchar(40)

NULL

Cost Center Code

STRECSG_LOSSTRAN_COST

bigint

NULL

Used to store the cost of parts lost in transit

STRECSG_TRAN_COST

bigint

NULL

Table Name Rec_STRecShp_StkTrn_Ship

Table Comment this table is used to stored the shipment details of the stock transfer receipt

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

STRecShp_Shipment_Datetime

datetime

NULL

Shipment Date and Time

STRecShp_User_Def_1

varchar(25)

NULL

User Definition 1

STRecShp_User_Def_2

varchar(25)

NULL

User Definition 2

STRecShp_Shipping_Pay_Mthd

varchar(150)

NULL

Shipping Pay Method

STRecShp_Way_Bill_No

varchar(40)

NULL

Way Bill Number

STRecShp_Insurance_Amt

decimal(28,8)

NULL

Insurance Amount

STRecShp_Modified_By

varchar(30)

NULL

Last Modified Login User Name

STRecShp_Modified_Datetime

datetime

NULL

Last Modified Date and Time

STRecShp_Remarks

varchar(255)

NULL

Remarks (if any)

STRecShp_Created_Datetime

datetime

NULL

Created Date and time

STRecShp_Created_By

varchar(30)

NULL

Created Login User Name

STRecShp_Timestamp

decimal(10)

NULL

TimeStamp

STRecShp_Ship_By

varchar(25)

NULL

Ship by

STRecShp_Package_Code

varchar(25)

NULL

Package Code

STRecShp_VehicleOrFlt_No

varchar(150)

NULL

Vehicle or Flight Number

STRecShp_Receipt_No

varchar(40)

NOT NULL

System generated Receipt No for receiving the parts which are part of the Stock Transfer Document

STRecShp_OUInstance_Id

decimal(10,1)

NOT NULL

OU Instance ID where the Stock Transfer Receipt is received

STRecShp_Insurance_Liability

varchar(5)

NULL

Insurance Liability

STRecShp_Freight_Term

varchar(150)

NULL

Freight Term

STRecShp_Landing_Bill_No

varchar(40)

NULL

Landing Bill Number

STRecShp_Carrier

varchar(150)

NULL

Carrier

STRecShp_Freight_Amt

decimal(28,8)

NULL

Freight Amount

STRecShp_Freight_Bill_No

varchar(40)

NULL

Freight Bil Number

Table Name Rec_STRecSrl_StkSrlLot_Dtl

Table Comment this table is used to stored the serial lot details details of the stock transfer receipt

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

STRecSrl_Receipt_No

varchar(40)

NOT NULL

System generated Receipt No for receiving the parts which are part of the Stock Transfer Document

STRecSrl_OUInstance_Id

decimal(10,1)

NOT NULL

OU Instance ID where the Stock Transfer Receipt is received

STRecSrl_Prt_SysLine_No

decimal(10)

NOT NULL

Receipt Line Number for the parts listed in the Stock Transfer Doc. This will be same as the Stock Transfer Issue Doc line No as for one stock tranfer issue, there could be only one stock tranfer receipt document

STRecSrl_Stg_SysLine_No

NOT NULL

System generated Unique sequence no to identify a storage allocation detail.

STRecSrl_Serial_No

varchar(40)

NOT NULL

Receipt Serial Number for the parts.

STRecSrl_Lot_No

varchar(18)

NOT NULL

Receipt Lot Number for the parts.

STRecSrl_Qty

decimal(28,8)

NULL

Receipt Quantity

STRecSrl_Qty_InStkUom

decimal(28,8)

NULL

Receipt Quantity of the parts in Stock UOM.

STRecSrl_New_Lot_No

varchar(18)

NULL

This will the new lot number generated for the destination ou-warehouse

STRECSRL_RECEIPT_COST

bigint

NULL

STRECSRL_TRAN_COST

bigint

NULL

Table Name Rec_STRecTcd_StkTrn_Tcd

Table Comment this table is used to stored the TCD details details of the stock transfer receipt

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Strectcd_Tcd_Acccode

varchar(32)

NULL

Accounting Code

STRecTcd_Tcd_Amount

decimal(28,8)

NULL

Tcd Amount

STRecTcd_Tcd_Rate

decimal(28,8)

NULL

Tcd Rate

Strectcd_Tcd_Accrule

varchar(25)

NULL

Accounting Rule

Strectcd_Tcd_Supacccode

varchar(32)

NULL

Supplier Accounting Code

Strectcd_Tcd_Paytosup

varchar(45)

NULL

Pay t Supplier

Strectcd_Costcenter_Code

varchar(10)

NULL

Cost Center Code

STRecTcd_Receipt_No

varchar(40)

NOT NULL

System generated Receipt No for receiving the parts which are part of the Stock Transfer Document

STRecTcd_Prt_SysLine_No

decimal(10)

NOT NULL

Receipt Line Number for the parts listed in the Stock Transfer Doc. This will be same as the Stock Transfer Issue Doc line No as for one stock transfer issue, there could be only one stock transfer receipt document This will be 0 if the TCD info is at document level

STRecTcd_OUInstance_Id

decimal(10,1)

NOT NULL

OU Instance ID where the Stock Transfer Receipt is received

STRecTcd_Tcd_Variant

varchar(25)

NULL

Tcd Variant

STRecTcd_Tcd_No

varchar(25)

NULL

Tcd Number

STRecTcd_Tcd_Line_Id

decimal(10)

NOT NULL

TCD Line Id

STRecTcd_Tcd_Ou

decimal(10)

NULL

Tcd Ouinstance

Table Name Rec_upradl_unplnRcpt_adl_info

Table Comment This table is used to store the serial and lot details for the line items which are lot / Serial controlled.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

UprAdl_Document_OU

decimal(10)

NOT NULL

UnPlanned Receipt Document OU

UprAdl_Document_No

varchar(18)

NOT NULL

UnPlanned Receipt Document No

UprAdl_Prt_SysLine_No

decimal(10)

NOT NULL

The Line no to identify the records uniquely

UprAdl_Srl_SysLine_No

decimal(10)

NOT NULL

Sequence Number

UprDtl_Part_Status

varchar(40)

NOT NULL

Part Status of the received Part

UprAdl_Srl_DisplayLine_No

decimal(10)

NULL

Display Line Number

UprAdl_Ref_Serial_No

varchar(40)

NULL

Referential Serial Number. The manufacturer’s serial number (valid for serial controlled parts)

UprAdl_Ref_Lot_No

varchar(18)

NULL

Referential Lot Number. The manufacturer’s lot number of the parts being received (valid for lot controlled parts)

UprAdl_Part_Condition

varchar(5)

NULL

The condition of the line item take values like O - Overhauled S - Serviceable U - Unserviceable and &ltSpace>

UprAdl_Serial_Running_No

decimal(10)

NULL

Serial running Number

UprAdl_Rcpt_Qty

decimal(28,8)

NULL

The quantity of the specified part (line item) being received

UprAdl_Rcpt_Qty_In_StkUom

decimal(28,8)

NULL

Receipt Quantity in Stock UOM.

UprAdl_Certificate_Type

varchar(25)

NULL

Certificate Type. It is defined in Logistics Common master component.

UprAdl_Certificate_No

varchar(40)

NULL

Certificate Number

UprAdl_Certificate_Date

datetime

NULL

Certificate Date

UprAdl_Expiry_Date

datetime

NULL

Expiry date of the component

UprAdl_Auth_No

varchar(40)

NULL

Authorization Number

UprAdl_Sys_Tracking_Ref

varchar(40)

NULL

System Tracking reference Number

UprAdl_Remarks

varchar(255)

NULL

Textual field for entering any remarks/comments regarding the transaction

UprAdl_Serial_No

varchar(40)

NULL

Internal serial number identifying the individual unit  (valid for serial controlled parts). If not provided by the user it will be generated by the system

UprAdl_Serial_No_pfx

varchar(6)

NULL

Serial Number Prefix

UprAdl_Serial_No_Sfx

varchar(6)

NULL

Serial Number Suffix

UprAdl_Lot_No

varchar(18)

NULL

Internal lot # of the part (valid for lot controlled parts). If not provided by the user it will be generated/created by the system

UprAdl_Warranty_Lapse_Date

datetime

NULL

Warranty Lapse Date

UprAdl_FileName

varchar(50)

NULL

FileName

UprAdl_TradingPartnerType

sql_variant

NULL

holds the value ’CUS’ - Customer and ’SUP’ - Supplier

UprAdl_TradingPartnerNo

sql_variant

NULL

cus\sup number

UprAdl_TradingPartnerOU

bigint

NULL

Trading partner location instance

UPRADL_PART_COST

bigint

NULL

UPRADL_TRAN_COST

bigint

NULL

Table Name Rec_UprAtt_Srl_Attrib_Info

Table Comment For a part-serial, the quantitative and qualitative attributes captured at the time of receipt are available in this table

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

UprDtl_Part_Status

varchar(40)

NOT NULL

Part Status of the received Part

UprAtt_Attribute_No

varchar(10)

NOT NULL

Attribute Code for the Part Serial Number

UprAtt_Qual_Value

varchar(80)

NULL

Qualitative value

UprAtt_Quan_Value

decimal(28,8)

NULL

Quantitative value

UprAtt_Remarks

varchar(255)

NULL

Remarks (if any)

UprAtt_Document_OU

decimal(10)

NOT NULL

UnPlanned Receipt Document OU

UprAtt_Srl_SysLine_No

decimal(10)

NOT NULL

Sequence Number

UprAtt_Document_No

varchar(18)

NOT NULL

UnPlanned Receipt Document No

UprAtt_Prt_SysLine_No

decimal(10)

NOT NULL

The Line no to identify the records uniquely

Table Name Rec_uprdtl_unplannedInfo_dtl

Table Comment This table contains the parts (and their details) that are received as part of the Unplanned Receipt Document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

UprDtl_Document_OU

decimal(10)

NOT NULL

UnPlanned Receipt Document OU

UprDtl_Document_No

varchar(18)

NOT NULL

UnPlanned Receipt Document No

UprDtl_Prt_SysLine_No

decimal(10)

NOT NULL

System Line no to identify the records uniquely

UprDtl_Part_Status

varchar(40)

NOT NULL

Part Status of the received Part

UprDtl_Prt_DisplayLine_No

decimal(10)

NULL

Line Number displayed to the user

UprDtl_Part_Crt_OU

decimal(10)

NULL

Central Reference List OUinstance

UprDtl_Part_Pln_OU

decimal(10)

NULL

Planning OUInstance

UprDtl_Part_No

varchar(40)

NULL

Code based on which the item is identified.. It is a unique code for the company. The Code of the Items which belongs to the particular bin or zone or warehouse accordingly

UprDtl_Rcpt_Qty

decimal(28,8)

NULL

The quantity of the items it can hold the fraction value with respect to the UOM

UprDtl_Rcpt_Uom

varchar(10)

NULL

The Transaction UOM ( Unit of measure ) in which the quantity has been supplied

UprDtl_Rcpt_Qty_In_StkUom

decimal(28,8)

NULL

Receipt Quantity in Stock UOM.

UprDtl_Zone_Id

varchar(10)

NULL

The Zone where the Items had been stored . the value must be present if the warehouse type is "Normal" The zone should be "##" if the warehouse type is "Free"

UprDtl_Bin_Id

varchar(10)

NULL

The Bin where the Items had been stored . the value must be present if the Zone type is "Normal" The Bin should be  "##" if the Zone type is "Free"

UprDtl_Part_Cost

decimal(28,8)

NULL

Part Cost entered by for the part at the time of receipt. For Std Part alone, whatever entered by the user is ignored and Std Part Cost for the part defined in Inventory is taken.

UprDtl_Adl_Dtl_Exists_Flag

varchar(25)

NULL

If additional information exists for this line item, then this flag will be ’Y’ else ’N’

UprDtl_Acc_Usage

varchar(20)

NULL

Accounting Usage

UprDtl_Fin_Book

NULL

Finance Book

UprDtl_Acc_Code

varchar(32)

NULL

Accounting Code

UprDtl_Anly_Code

varchar(5)

NULL

Analysis Code

UprDtl_SubAnly_Code

NULL

Sub Analysis Code

UprDtl_Created_By

varchar(30)

NOT NULL

The LoginId of the created user

UprDtl_Created_Date

datetime

NOT NULL

The date on which the receipt had been prepared

UprDtl_Modified_By

varchar(30)

NOT NULL

The loginid of the Last modified user

UprDtl_Modified_Date

datetime

NOT NULL

The Last modified date of the transaction

UprDtl_timestamp

decimal(10)

NOT NULL

Timestamp for the record

Uprdtl_Cc_Usage

varchar(20)

NULL

Costing Usage

Uprdtl_Costcenter_Code

varchar(40)

NULL

Cost Center Code

UprDtl_Price_Var

decimal(28,8)

NULL

Price

UprDtl_Price_Var_Acc

varchar(32)

NULL

UPRDTL_COMPUTED_DATE

datetime

NULL

Computed date

UPRDTL_COMPUTED_COST

decimal(28,8)

NULL

Computed cost

UPRDTL_TRAN_COST

bigint

NULL

Table Name Rec_uprhdr_unplannedInfo_hdr

Table Comment The table is used to store Unplanned receipt main information like receipt date, receipt doc status, category, Warehouse, etc

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

UprHdr_Document_OU

decimal(10)

NOT NULL

OUInstance

UprHdr_Document_No

varchar(18)

NOT NULL

UnPlanned Receipt Document Number. Textual field for recording the requesting document on the basis of which the transaction is to be performed.

UprHdr_Document_Date

datetime

NOT NULL

UnPlanned Receipt Document Date. Specifies the date at which the receipt takes place

UprHdr_Document_Status

varchar(5)

NOT NULL

UnPlanned Receipt Document Status which take values DR- Draft FR- Fresh, CF- Confirmed CN-Cancelled

UprHdr_Category

varchar(25)

NULL

Reference Category. Quick code to categorize receipt transaction as per the users need

UprHdr_User_Status

User Status. Quick code to specify the user status.

UprHdr_Part_Ownership

varchar(5)

NOT NULL

Will have values like OW - Owned SU - Supplier CU - Customer

UprHdr_Ownership_Ou

decimal(10)

NULL

Ownership Ouinstance If Part Ownership is "Supplier’ then it will have Supplier Ouinstance If Part Ownership is "Customer’ then it will have Customer Ouinstance

UprHdr_Ownership_Doc_No

varchar(150)

NULL

Part Owner ship Document No. Textual field to capture loan agreement number etc

UprHdr_Warehouse_OU

decimal(10)

NOT NULL

Warehouse OUInstance

UprHdr_Warehouse_No

varchar(10)

NOT NULL

Warehouse Number

UprHdr_Reference_Doc

varchar(40)

NULL

Reference Document Number

UprHdr_Remarks

varchar(255)

NULL

Textual field for entering any remarks/comments regarding the transaction

UprHdr_Approved_By

varchar(30)

NULL

Approved User

UprHdr_Approved_Date

datetime

NULL

Approvd Date

UprHdr_SupplierNo

varchar(45)

NULL

Supplier Number

UprHdr_CustomerNo

varchar(45)

NULL

Customer Number

UprHdr_FileName

varchar(50)

NULL

FileName

UprHdr_Acc_Usage

varchar(20)

NULL

Account Usage

UprHdr_Wf_Doc_Key

varchar(20)

NULL

Document Key

UprHdr_Wf_New_State

varchar(128)

NULL

New State

UprHdr_Created_By

varchar(30)

NOT NULL

Created User

UprHdr_Created_Date

datetime

NOT NULL

Created Date

UprHdr_Modified_By

varchar(30)

NOT NULL

Modified User

UprHdr_Modified_Date

datetime

NOT NULL

Modified Date

UprHdr_timestamp

decimal(10)

NOT NULL

Time Stamp for the record

Uprhdr_Cc_Usage

varchar(20)

NULL

Costing Usage

Table Name Rec_upropset_opt_settings

Table Comment This table is used to store the options that are set by the user. The two options are: 1. Allow Input of Stock Value for Standard Cost Parts. It takes values ’Y’ and N’.  If it is set as ’Y’, then the value entered by the user is taken as the Stock  value. If it is set as ’N’, the standard cost is taken as the Stock value. 2. Method for Conversion of Fractional Receipt Qty. This option takes values:   Round Up,Round Down, Round Off.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

UprOpSet_OUInstance

decimal(10)

NOT NULL

OUinstance

UprOpSet_StkVal_StdPrt_Flag

varchar(5)

NOT NULL

To Allow Input of Stock Value for Standard Cost Parts. It takes values ’Y’ and ’N’.

UprOpSet_Frac_Conv_Mthd_Flag

varchar(5)

NOT NULL

The option to do the Conversion of Fractional Receipt Qty. It takes values: Rounded Up  - RUP Rounded Down  - RDWN Rounded Off   - ROFF

UprOpSet_Auto_Trn_Rcpt

varchar(5)

NULL

The option to default numbering type value for Automatic Transfer receipt

UprOpSet_Created_By

varchar(30)

NOT NULL

Created user

UprOpSet_CreatedDate

datetime

NOT NULL

Record Created Date

UprOpSet_Modified_By

varchar(30)

NOT NULL

Modified User

UprOpSet_ModifiedDate

datetime

NOT NULL

Record Modified Date

UprOpSet_Timestamp

decimal(10)

NOT NULL

Timestamp for the record

Table Name Rec_UprPrm_Srl_Param_Val

Table Comment For component type of parts, their initial parameter values during the first time of their receipt are stored here.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

UprPrm_Since_Repair

decimal(28,8)

NULL

Param value Since Repair

UprPrm_Since_Overhaul

decimal(28,8)

NULL

Param value Since Overhaul

UprPrm_Since_New

decimal(28,8)

NULL

Param value Since New

UprPrm_Since_Insp

decimal(28,8)

NULL

Param value Since Inspection

UprPrm_Since_Lsv

decimal(28,8)

NULL

Param value since Last Shop Visit

UprPrm_Warranty_Value

decimal(28,8)

NULL

Warranty value

UprPrm_Document_No

varchar(18)

NOT NULL

UnPlanned Receipt Document No

UprPrm_Document_OU

decimal(10)

NOT NULL

UnPlanned Receipt Document OU

UprDtl_Part_Status

varchar(40)

NOT NULL

Part Status of the received Part

UprPrm_Param_Code

varchar(40)

NOT NULL

Parameter Code

UprPrm_Prt_SysLine_No

decimal(10)

NOT NULL

The Line no to identify the records uniquely

UprPrm_Srl_SysLine_No

decimal(10)

NOT NULL

Sequence Number

Table Name Rec_uprqc_quick_code

Table Comment Unplanned Receipt Quick Code master table which stores the quick codes defined by the user.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

UprQc_OUInstance

decimal(10)

NOT NULL

Quick Created Ouinstance

UprQc_Quick_Code

varchar(25)

NOT NULL

Quick Code Value

UprQc_Type

varchar(5)

NOT NULL

Quick Code Type RC - Receipt Category RU - Receipt User Status

UprQc_Desc

varchar(80)

NULL

Quick Code Description

UprQc_Status

varchar(5)

NULL

Quick Code Status A - Active I- Inacitve B - Blank

UprQc_CreatedDate

datetime

NULL

The Created date of the transaction

UprQc_Created_By

varchar(30)

NULL

The Created User of the transaction

UprQc_ModifiedDate

datetime

NULL

The Last modified date of the transaction

UprQc_Modified_By

varchar(30)

NULL

The Last modified user of the transaction

UprQc_Timestamp

decimal(10)

NULL

Timestamp for the record

Table Name UPR_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

UPR_ComponentName

varchar(80)

NOT NULL

Component Name

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

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

UPR_ParamCode

varchar(5)

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

UPR_LangId

decimal(10,1)

NOT NULL

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

UPR_ParamDesc

varchar(80)

NULL

Description of the combo value

UPR_Sort_By

decimal(10,1)

NULL

The order in which it has to be stored.