Stock Issue

Table Name Issue_isuis_part_storage_dtl

Table Comment Contains Part details in the Issue

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

ISUIS_ISUATTACH_FLAG

sql_variant

NULL

ISUIS_ISUATCH_DOC_NO

char(18)

NULL

ISUIS_ISUATCH_DOC_TYPE

sql_variant

NULL

isuis_iss_computed_date

NULL

isuis_iss_computed_cost

bigint

NULL

ISUIS_Expiry_Date

char(18)

NULL

For Component type of parts, expired date will be copied from stock maint and stored here. Since expiry date cannot change for the component when it is in stock, de-normalizing and storing it here will save time in fetching..

ISUIS_CONFIRM_LOSSQTY_STKUOM

numeric(13)

NULL

Confirmed Loss Quantity

ISUIS_FRESH_RCPTQTY_STKUOM

NULL

Fresh Received Quantity

ISUIS_ISUATCH_REFDOC_NO

sql_variant

NULL

ISUIS_CONFIRM_RCPTQTY_STKUOM

numeric(13)

NULL

Confirmed Received Quantity

ISUIS_ISUATCH_REFDOC_TYPE

sql_variant

NULL

ISUIS_FRESH_LOSSQTY_STKUOM

numeric(13)

NULL

Fresh Loss Quantity

ISUIS_LineSerialNo

decimal(10)

NOT NULL

Serial Number of the Part in the Issue Document.

ISUIS_Srl_SysLine_No

sql_variant

NOT NULL

Unique Serial Number for Storage details.

ISUIS_zone_id

sql_variant

NULL

The number identifying the zone in the warehouse from where the part is issued

ISUIS_Transaction_No

varchar(40)

NOT NULL

The number identifying the issue document

ISUIS_Org_Unit

decimal(10)

NOT NULL

OU where the Issue is carried out.

ISUIS_Iss_Cost

char(18)

NULL

Issue Cost at Zone-Bin level.

ISUIS_Iss_Qty_InStkUom

bigint

NULL

Quantity being issued in the Stock Uom.

ISUIS_Iss_Qty_InReqUom

bigint

NULL

Quantity being issued in the Requested Uom.

ISUIS_bin_id

sql_variant

NULL

The number identifying the bin in the warehouse from where the part is issued.

ISUIS_Lot_no

sql_variant

NULL

The number identifying the lot to which the part belongs

ISUIS_Iss_Qty

bigint

NULL

The number of parts issued

ISUIS_serial_no

sql_variant

NULL

The number identifying the serial number of the part that is issued

Table Name Issue_Item_storage_Tmp_tbl

Table Comment Contains Part details in the Issue

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

UnPlTmp_Org_Unit

decimal(10,1)

NULL

OU where Stock Issue is carried out

UnPlTmp_Transaction_No

varchar(40)

NULL

Issue Transaction Number

UnPlTmp_LineSerialNo

decimal(10,1)

NULL

Serial Number of the Part in the Issue Document

UNPLTMP_STORAGE_SEQNO

decimal(10,1)

NULL

UnPlTmp_WareHouse

varchar(40)

NULL

The warehouse from which stock are to be/being issued

UnPlTmp_WareHouseOu

decimal(10,1)

NULL

The warehouse OU from which stock are to be/being issued

UnPlTmp_PartCrOu

decimal(10,1)

NULL

Issue Part Created OUInstance

UNPlTmp_PartPlnOu

decimal(10,1)

NULL

Issue Part Planning OUInstance

UnPlTmp_PartNo

varchar(40)

NULL

The parts # to be/being issued. Sometimes the part # may not be in the stock and an alternate part # may be issued.

UnPlTmp_Part_Status

varchar(40)

NULL

The user defined status of the parts being issued

UnPlTmp_zone_id

varchar(10)

NULL

The zone # from which stock are to be/being issued from the Warehouse

UnPlTmp_bin_id

varchar(10)

NULL

The bin # from which stock are to be/being issued

UnPlTmp_Lot_no

varchar(18)

NULL

For lot controlled parts, the lot # from which the parts are being issued.

UnPlTmp_serial_no

varchar(40)

NULL

For serial controlled parts, the exact serial # being issued. If more than one serial # are being issued

UnPlTmp_Part_Cond

varchar(25)

NULL

Issue Part condition N - New O - OverHauled S - Serviceable U - UnServiceable B - Blank

UnPlTmp_Iss_Qty

decimal(28,1)

NULL

Quantity being issued in this transaction

UnPlTmp_Tot_Avail_Qty

decimal(28,1)

NULL

Total Availability Quantity

UnPlTmp_Guid

varchar(40)

NULL

GUID generation for inserting data with unique identifier into temporary table

Table Name Issue_Unpl_Item_storage_Tmp

Table Comment Contains Part details in the Issue

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

UnPlTmp_Org_Unit

decimal(10,1)

NULL

OU where the Issue is carried out

UnPlTmp_Transaction_No

varchar(40)

NULL

Stock Issue Number

UnPlTmp_LineSerialNo

decimal(10,1)

NULL

Serial Number of the Part in the Issue Document

UnPlTmp_storage_serial

decimal(10,1)

NULL

Unique Serial Number for Storage details

UnPlTmp_GUID

varchar(40)

NULL

GUID generation for inserting data with unique identifier into temporary table

UnPlTmp_zone_id

varchar(10)

NULL

The zone # from which stock are to be/being issued from the Warehouse

UnPlTmp_bin_id

varchar(10)

NULL

The bin # from which stock are to be/being issued

UnPlTmp_Lot_number

varchar(18)

NULL

For lot controlled parts, the lot # from which the parts are being issued.

UnPlTmp_serial_no

varchar(40)

NULL

For serial controlled parts, the exact serial # being issued.

UnPlTmp_Part_Condition

varchar(25)

NULL

Issue Part condition N - New O - OverHauled S - Serviceable U - UnServiceable B - Blank

UnPlTmp_Iss_Qty

decimal(28,1)

NULL

Quantity being issued in this transaction

UnPlTmp_Iss_Qty_InStkUOM

decimal(28,1)

NULL

Quantity being issued in the Stock Uom

UnPlTmp_Iss_Qty_InReqUOM

decimal(28,1)

NULL

Quantity being issued in the Requested Uom

Table Name ISU_ISSCWOPR_CWO_PRT_DTL

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

ISSCWOPR_CWO_NO

varchar(40)

NOT NULL

The requesting document on the basis of which the transaction is to be performed.

ISSCWOPR_CWO_OUINSTANCE

decimal(10)

NOT NULL

OU corresponding to the Reference Document Number

ISSCWOPR_TASK_KEY_SEQNO

decimal(6)

NOT NULL

The Task Key SeqNo which is mapped to be Requested Part If the Task Key SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

ISSCWOPR_TASK_SEQ_NO

decimal(6)

NOT NULL

The Task SeqNo which is mapped to be Requested Part If the Task SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

ISSCWOPR_TASK_OU

decimal(10)

NOT NULL

The Task OuInstance which is mapped to be Requested Part

ISSCWOPR_TASK_NO

varchar(40)

NOT NULL

The Task Code which is mapped to be Requested Part

ISSCWOPR_REQ_PART_WH_OU

decimal(10)

NOT NULL

The warehouse OU from which stock are to be/being issued

ISSCWOPR_REQ_PART_WH_ID

varchar(10)

NOT NULL

The warehouse from which stock are to be/being issued

ISSCWOPR_REQ_PART_CRT_OU

decimal(10)

NOT NULL

The part # requested OU by the reference document

ISSCWOPR_REQ_PART_NO

varchar(40)

NOT NULL

The part # requested by the reference document

ISSCWOPR_REQ_PART_UOM

varchar(40)

NULL

The requested UOM by the reference document

ISSCWOPR_ISS_QTY_INREQUOM

decimal(28,8)

Quantity being issued in the Stock Uom

Table Name Isu_IssCwoTmp_AddMntTrn1_Tmp

Table Comment This table used to hold the Reference Document Details.This table includes Reference Document code,Warehouse,Request part, Task Details,Reference Document Schedule Date.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

AddMnt_Ouinstance

decimal(10)

NULL

OU where Reference Document is carried out

AddMnt_Guid

varchar(40)

NULL

GUID generation for inserting data with unique identifier into temporary table

AddMnt_CWo_Code

varchar(40)

NULL

The requesting document on the basis of which the Issue transaction is to be performed

AddMnt_WareHouse_Ou

decimal(10)

NULL

The warehouse ouinstance from which stock are to be/being issued

AddMnt_WareHouse_Id

varchar(10)

NULL

The warehouse from which stock are to be/being issued

AddMnt_Part_Crt_Ou

decimal(10)

NULL

Requested Part Created OUInsance

AddMnt_Part_No

varchar(40)

NULL

The part # requested by the reference document

AddMnt_Task_Ou

decimal(10)

NULL

The Task OuInstance which is mapped to be Requested Part If the task OUInstance is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

AddMnt_Task_Code

varchar(40)

NULL

The Task Code which is mapped to be Requested Part If the task Code is NULL then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

AddMnt_Task_Seq_No

decimal(6)

NULL

The Task SeqNo which is mapped to be Requested Part If the task SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

AddMnt_Task_Key_SeqNo

decimal(6)

NULL

The Task Key SeqNo which is mapped to be Requested Part If the Task Key SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

AdMnt_CWo_OU

decimal(10)

NULL

The requesting document ouinstance on the basis of which the transaction is to be performed

AddMnt_CwoSch_Date

datetime

NULL

The requesting document Schedule Date

AddMnt_Priority_No

decimal(6)

NULL

The requesting document Priority Number

AddMnt_User_Status

varchar(25)

NULL

The requesting document User Status

AddMnt_Pend_Iss_Qty

decimal(20,8)

NULL

Quantity requested - Qty already issued

Table Name Isu_IssCwoTmp_Cwo_Prt_Dtl_Tmp

Table Comment There can be one or more Issue Documents for a WorkOrder-Task-Part This table has the consolidated issue qty at workorder - task - part level

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

IssCwoTmp_Guid

varchar(40)

NOT NULL

GUID generation for inserting data with unique identifier into temporary table

IssCwoTmp_CWo_OUInstance

decimal(10)

NOT NULL

OU corresponding to the Reference Document Number

IssCwoTmp_CWo_Code

varchar(18)

NOT NULL

The requesting document on the basis of which the transaction is to be performed.

IssCwoTmp_Task_Key_SeqNo

decimal(10)

NOT NULL

The Task Key SeqNo which is mapped to be Requested Part If the Task Key SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IssCwoTmp_Task_Seq_No

decimal(10)

NOT NULL

The Task SeqNo which is mapped to be Requested Part If the Task SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IssCwoTmp_Task_OUInstance

decimal(10)

NOT NULL

The Task OuInstance which is mapped to be Requested Part If the task OUInstance is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IssCwoTmp_Task_No

varchar(40)

NOT NULL

The Task Code which is mapped to be Requested Part If the task Code is NULL then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IssCwoTmp_Part_Crt_Ou

decimal(10)

NOT NULL

The part # requested OU by the reference document

IssCwoTmp_Part_No

varchar(40)

NOT NULL

The part # requested by the reference document

IssCwoTmp_Part_Desc

varchar(80)

NULL

The part # requested desc by the reference document

IssCwoTmp_Warehouse_Ou

decimal(10)

NOT NULL

The warehouse OU from which stock are to be/being issued

IssCwoTmp_Warehouse_Id

varchar(10)

NULL

The warehouse from which stock are to be/being issued

IssCwoTmp_Req_Qty

decimal(28,8)

NULL

The requested Qty by the reference document

IssCwoTmp_Req_Uom

varchar(10)

NULL

The requested UOM by the reference document

IssCwoTmp_Pend_Iss_Qty

decimal(28,8)

NULL

Quantity requested - Qty already issued

IssCwoTmp_Srl_Lot_Flag

varchar(25)

NULL

Requested Part Control Type ’YN’ - Lot Control Part ’NY’ - Serial Control Part ’YY’ - Lot and Serial Control Part ’NN’ - Nothing

IssCwoTmp_Part_Type

varchar(5)

NULL

Requested Part Type

Table Name Isu_issopset_opt_settings

Table Comment This table is used to store the options that are set by the user. The two options are: 1. Method for Conversion of Fractional Receipt Qty. This option takes values:   Round Up,Round Down, Round Off. 2. Numbering type of the Auto Issue doc created thru Stock Transfer.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

IssOpSet_OUInstance

decimal(10)

NOT NULL

Option Setting OUInstance.

IssOpSet_Frac_Conv_Mthd_Flag

varchar(5)

NOT NULL

Method Conversion Flag Value. It is used for Rounding the Fractional Values. Rounded Up        -  RUP Rounded Down   -  RDWN Rounded Off        -  ROFF

IssOpSet_StrIsu_NoTypeNo

varchar(25)

NOT NULL

This is the numbering type that is used while automatically generating the Issue Document for AUTO Stock Transfer..

IssOpSet_Created_By

varchar(30)

NOT NULL

User who created the option settings

IssOpSet_CreatedDate

datetime

NOT NULL

Date on which the Option Setting is Created.

IssOpSet_Modified_By

varchar(30)

NOT NULL

The name of the user who last modified the options.

IssOpSet_ModifiedDate

datetime

NOT NULL

The date on which the options were last modified.

IssOpSet_Timestamp

decimal(10)

NOT NULL

Number of times the Option Settings has got modified..

Table Name Isu_issprm_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. This table is required to support multi-language.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

IssPrm_ComponentName

varchar(80)

NOT NULL

Name of the component.

IssPrm_ParamCategory

varchar(10)

NOT NULL

Category of the Parameter.

IssPrm_ParamType

varchar(25)

NOT NULL

Parameter Type.

IssPrm_ParamCode

varchar(5)

NOT NULL

Short Code to Identify the Parameter.

IssPrm_LangId

decimal(10)

NOT NULL

Language id..

IssPrm_ParamDesc

varchar(80)

NOT NULL

Description Of the Parameter.

IssPrm_Sort_By

decimal(10)

NOT NULL

Ordering the values.

Table Name Isu_issqc_quick_code

Table Comment Issue 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

IssQc_OUInstance

decimal(10)

NOT NULL

Quick Code OUInstance.

IssQc_Quick_Code

varchar(25)

NOT NULL

A unique identifier for the quick code (Alphanumeric, 25). Mandatory. This can be a combination of characters and digits and should not be left blank. Ensure that the quick code is unique for the organizational uni

IssQc_Type

varchar(5)

NOT NULL

the type for which the quick code must be created. The system provides the options “Issue Category and issue User Status.

IssQc_Desc

varchar(80)

NOT NULL

The textual description for the quick code

IssQc_Status

varchar(5)

NOT NULL

the status of the quick code. The system lists the options,Active and Inactive.

IssQc_CreatedDate

datetime

NOT NULL

The date on which the quick code was created

IssQc_Created_By

varchar(30)

NOT NULL

The name of the user who created the quick code.

IssQc_ModifiedDate

datetime

NOT NULL

The date on which the quick code was last modified.

IssQc_Modified_By

varchar(30)

NOT NULL

The name of the user who last modified the quick code. .

IssQc_Timestamp

decimal(10)

NOT NULL

Number of times the QuickCode has got modified.,

Table Name Isu_IsuCs_Issue_Cost_LF_Dtl

Table Comment For an authorized issue document, there could be one or more cost computation details.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

IsuCs_OUInstance

decimal(10)

NOT NULL

OU Instance

IsuCs_Isu_No

varchar(40)

NOT NULL

Issue Number

IsuCs_Line_No

decimal(10)

NOT NULL

Line Number

IsuCs_As_On_Date

datetime

NOT NULL

Date

ISUCS_RATE_NO

decimal(10)

NOT NULL

Date

IsuCs_QtyInStkUom

decimal(28,8)

NULL

Quantity in Stock UOM

IsuCs_LifoFifo_Rate

decimal(28,8)

NULL

LIFO FIFO Rate

Table Name Isu_IsuDA_RefDoc_Attach_Dtl

Table Comment This entity contains reference document details for the issue document

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

IsuDA_RefDoc_No

varchar(40)

NULL

The name of the referenced document containing details of the issue.

IsuDA_File_Name

varchar(50)

NULL

The file name used for reference

IsuDA_Remarks

varchar(255)

NULL

Any additional remark or comment pertaining to the reference document.

IsuDA_Transaction_OU

decimal(10)

NOT NULL

OU where Stock Issue is carried out.

IsuDA_Ref_Doc_Type

varchar(25)

NULL

The type to which the reference document belongs.

IsuDA_Transaction_No

varchar(40)

NOT NULL

Stock Issue Number.

Table Name isu_isudt_issue_part_dtl

Table Comment This table used to hold the item details for the planned item issue transaction document. The item details includes the item code, transaction UOM, Quantity, Zone, Bin, Item stock status, value, created by and created date.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

ISUID_Org_Unit

decimal(10)

NOT NULL

OU where the Stock Issue is carried out.

ISUID_Transaction_No

varchar(40)

NOT NULL

Stock Issue Number.

ISUID_Prt_SysLine_No

decimal(10)

NOT NULL

Serial Number of the Part in the Issue Document.

ISUID_Prt_DisplayLine_No

decimal(10)

NOT NULL

Display Line Number.

ISUID_Task_Ou

decimal(10)

NULL

The Task OuInstance which is mapped to be Requested Part.

ISUID_Task_No

varchar(40)

NULL

The Task Code which is mapped to be Requested Part.

ISUID_Task_Seq_No

decimal(12)

NULL

The number identifying the task of the component work order / Line work order for which the parts must be issued.

ISUID_Task_Key_SeqNo

NULL

The Task Key SeqNo which is mapped to be Requested Part.

ISUID_Iss_Part_Pln_Ou

decimal(10)

NULL

Issue Part Planning OUInstance.

ISUID_Iss_Part_Crt_Ou

NULL

Issue Part Created OUInstance.

ISUID_Iss_Part_No

varchar(40)

NULL

The parts # to be/being issued. Sometimes the part # may not be in the stock and an alternate part # may be issued...

ISUID_Iss_Qty

decimal(28,8)

NULL

Quantity being issued in this transaction.

ISUID_Iss_Qty_Uom

varchar(10)

NULL

It is the unit of measurement in which the issue transaction is to be/being made. Conversion should have been defined between this UOM and stock UOM. .

ISUID_Iss_Qty_InStkUom

decimal(28,8)

NULL

Issue Quantity in Stock Uom.

ISUID_Iss_Qty_InReqUom

NULL

Issue Quantity in Requested Uom.

ISUID_Iss_Part_Status

varchar(40)

NULL

The user defined status of the parts being issued.

ISUID_Issue_Cost

decimal(28,8)

NULL

This column maintains the value for the Part being issued..

ISUID_Req_Part_Crt_Ou

decimal(10)

NULL

Requested Part Created OUInstance.

ISUID_Req_Part_No

varchar(40)

NULL

The parts # to be Requested.

ISUID_Req_Part_Uom

varchar(10)

NULL

Request Part Consumption Qty UOM.

ISUID_Exp_Rtn_Date

datetime

NULL

Expected Return Date of the part.

ISUID_Remarks

varchar(255)

NULL

Any other additional comment pertaining to the modification of parts issue

ISUID_StkTrnsfer_LineNo

decimal(10)

NULL

Ref.Doc. Part Line numbers.

ISUID_SCO_Ser_LineNo

decimal(10)

NULL

SubContract Order Service Line No.

ISUID_Adl_Dtl_Exists_Flag

varchar(5)

NULL

This flag indicates the existence of records in the storage detail table. .

ISUID_Acc_Usage

varchar(20)

NULL

The type of the account used.

ISUID_Finance_Book

varchar(20)

NULL

Finance Book.

ISUID_Acc_Code

varchar(32)

NULL

Accounting Code.

ISUID_Anly_Code

varchar(5)

NULL

Analysis Code.

ISUID_SubAnly_Code

varchar(5)

NULL

Sub Analysis Code.

ISUID_Cc_Usage

varchar(20)

NULL

The type of the costing used

ISUID_Costcenter_Code

varchar(10)

NULL

Cost Center Code.

ISUID_Preferred_Condn

varchar(5)

NULL

Preferred Condition.

ISUID_Reqmnt_Type

varchar(5)

NULL

Requirement Type.

ISUID_Mat_Type

varchar(5)

NULL

Material Type.

ISUID_ISUDELFLAG

varchar(5)

NULL

flag will be affected when we shortclose the mr for particular line item.

ISUID_SCL_QTY

decimal(28,2)

NULL

Short Close Qty

ISUID_SCL_QTY_INSTKUOM

NULL

Short Close Qty Uom.

ISUID_COMPUTED_COST

decimal(28,8)

NULL

Cost for the part.

ISUID_COMPUTED_DATE

datetime

NULL

computed date.

ISUID_PREVIOUS_COST

decimal(28,8)

NULL

previous cost.

ISUID_CONFIRM_RCPTQTY_STKUOM

numeric(13)

NULL

Confirmed Loss Quantity

ISUID_CONFIRM_LOSSQTY_STKUOM

numeric(13)

NULL

ISUID_FRESH_RCPTQTY_STKUOM

numeric(13)

NULL

Fresh Issued Quantity

ISUID_FRESH_LOSSQTY_STKUOM

numeric(13)

NULL

Confirmed loss Quantity

ISUID_SHIPPED_QTY

numeric(13)

NULL

Shipped Quantity Updated from Record shipping Note

ISUID_ORIGINAL_PART_STATUS

varchar(40)

NULL

Issue part status

ISUID_ISUTRDPARTNERTYPE

varchar(25)

NULL

Issue trading partner type

ISUID_ISUTRDPARTNERNO

varchar(45)

NULL

Issue trading partner number

Table Name isu_isudt_tranitem_Tmp

Table Comment This table used to hold the Part details for the Part issue transaction document. The Part details includes the Part code, transaction UOM, Quantity, Part stock status, value, created by and created date.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

IsudtTmp_Org_Unit

decimal(10)

NULL

OU where Stock Issue is carried out

IsudtTmp_Transaction_No

varchar(40)

NULL

Issue Transaction Number

IsudtTmp_LineSerial_No

decimal(12)

NULL

Serial Number of the Part in the Issue Document

IsudtTmp_Req_Part_Crt_Ou

decimal(10)

NULL

The Part# Requested OUInstance by the reference document

IsudtTmp_Req_Part_No

varchar(40)

NULL

The part # requested by the reference document

IsudtTmp_Req_Part_Uom

varchar(10)

NULL

Request Part Consumption Qty UOM

IsudtTmp_Part_Crt_Ou

decimal(10)

NULL

Issue Part Created OUInstance

IsudtTmp_Part_Pln_Ou

decimal(10)

NULL

Issue Part Planning OUInstance

IsudtTmp_Part_no

varchar(40)

NULL

The parts # to be/being issued. Sometimes the part # may not be in the stock and an alternate part # may be issued.

IsudtTmp_Iss_Qty

decimal(28,8)

NULL

Quantity being issued in this transaction

IsudtTmp_Iss_Qty_Uom

varchar(10)

NULL

It is the unit of measurement in which the issue transaction is to be/being made. Conversion should have been defined between this UOM and stock UOM.

IsudtTmp_Iss_Qty_InStkUom

decimal(28,8)

NULL

Issue Quantity in Stock Uom

IsudtTmp_Iss_Qty_InReqUom

decimal(28,8)

NULL

Issue Quantity in Requested UOM

IsudtTmp_Iss_Part_Status

varchar(40)

NULL

The user defined status of the parts being issued

IsudtTmp_Task_OU

decimal(10)

NULL

The Task OuInstance which is mapped to be Requested Part If the task OUInstance is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IsudtTmp_Task_No

varchar(40)

NULL

The Task Code which is mapped to be Requested Part If the task Code is NULL then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IsudtTmp_Task_Seq_No

decimal(10)

NULL

The Task SeqNo which is mapped to be Requested Part If the task SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IsudtTmp_Task_Key_SeqNo

NULL

The Task Key SeqNo which is mapped to be Requested Part If the Task Key SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

ISUDTTMP_REMARKS

varchar(255)

NULL

ISUDTTMP_EXP_RTN_DATE

datetime

NULL

ISUDTTMP_STKTRNSFER_LINENO

decimal(10)

NULL

IsudtTmp_Adl_Dtl_Exists_Flag

varchar(5)

NULL

This flag indicates the existence of records in the storage detail table. The values can be either ’Y’ or ’N’ ’Y’- Record(s) are available in the storage detail table ’N’ - Record(s) are not available in the storage detail.

IsudtTmp_GUID

varchar(40)

NULL

GUID generation for inserting data with unique identifier into temporary table

Table Name Isu_IsudtTmp_TranItem_Dtl_Tmp

Table Comment This table used to hold the Issue Part transaction document. The details includes the transaction type, transaction number,Issue number, Issue Requested part details , Issue part Details and Task Details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

IsudtTmp_Org_Unit

decimal(10)

NOT NULL

OU where Stock Issue is carried out

IsudtTmp_Transaction_No

varchar(40)

NOT NULL

Issue Transaction Number

IsudtTmp_GUID

varchar(40)

NOT NULL

GUID generation for inserting data with unique identifier into temporary table

IssdtTmp_Transaction_Date

sql_variant

NULL

IsudtTmp_Ref_Doc_Type

varchar(25)

NULL

The type of the document which requests the parts to be issued. Maintenance issue can be made with reference to work order, material request, component work order, line work order

IsudtTmp_Ref_Doc_No

varchar(40)

NULL

The requesting document on the basis of which the transaction is to be performed.

IsudtTmp_Receiving_Orgunit

decimal(10)

NULL

The requesting document ouinstancee on the basis of which the transaction is to be performed.

IsudtTmp_Task_Ou

decimal(10)

NULL

The Task OuInstance which is mapped to be Requested Part If the task OUInstance is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IsudtTmp_Task_No

varchar(40)

NULL

The Task Code which is mapped to be Requested Part If the task Code is NULL then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IsudtTmp_Task_Seq_No

decimal(10)

NULL

The Task SeqNo which is mapped to be Requested Part If the task SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IsudtTmp_Task_Key_SeqNo

decimal(10)

NULL

The Task Key SeqNo which is mapped to be Requested Part If the Task Key SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IsudtTmp_LineSerialNo

decimal(10)

NULL

Serial Number of the Part in the Issue Document

IsudtTmp_warehouse_org_unit

decimal(10)

NULL

The warehouse ouinstance from which stock are to be/being issued

IsudtTmp_Warehouse_id

varchar(10)

NULL

The warehouse from which stock are to be/being issued

IsudtTmp_Iss_Part_Crt_OU

decimal(10)

NULL

Issue Part Created OUInstance

IsudtTmp_Part_Pln_OU

decimal(10)

NULL

Issue Part Planning OUInstance

IsudtTmp_Iss_Part_no

varchar(40)

NULL

The parts # to be/being issued. Sometimes the part # may not be in the stock and an alternate part # may be issued.

IsudtTmp_Req_Part_Crt_Ou

decimal(10)

NULL

Requested Part Created OUInstance

IsudtTmp_Req_Part_No

varchar(40)

NULL

Requested Part No

ISUDTTMP_REQ_PART_UOM

varchar(10)

NULL

IsudtTmp_Planning_Status

varchar(40)

NULL

The user defined status of the parts being issued

IsudtTmp_Req_UOM

varchar(10)

NULL

Reference Document Requested UOM

IsudtTmp_Stock_UOM

varchar(10)

NULL

Part Stock UOM

IsudtTmp_Transaction_UOM

varchar(10)

NULL

It is the unit of measurement in which the issue transaction is to be/being made. Conversion should have been defined between this UOM and stock UOM.

IsudtTmp_UmMas_Fractions

varchar(5)

NULL

Stock UOM Fractional Value. ’Y’ or ’N’ ’Y’ - Fractional Value is allowed ’N’ - Fractional Value is not allowed

IsudtTmp_UmMas_Status

varchar(10)

NULL

Stock UOM Status. ’A’ - Active ’I’ - InActive

IsudtTmp_Conv_Factor

varchar(40)

NULL

Stock UOM Conversion Factor

IsudtTmp_Fractional_Qty

decimal(28,8)

NULL

Stock UOM Conversional Fractional Quantity

IsudtTmp_Stock_Status_Code

varchar(25)

NULL

Stock Status

IsudtTmp_Uds_TransType_Flag

varchar(25)

NULL

This flag indicates the existence of records in the storage detail table. The values can be either ’Y’ or ’N’ ’Y’- Record(s) are available in the storage detail table ’N’ - Record(s) are not available in the storage detail.

IsudtTmp_min_Issue_qty

decimal(28,8)

NULL

Minimum Issue Quantity

IsudtTmp_Maint_Usage

varchar(5)

NULL

Maintenance Usage Flag

IsudtTmp_Issue_qty

decimal(28,8)

NULL

Quantity being issued in this transaction

IsudtTmp_Iss_Qty_InReqUom

NULL

Issue Quantity In Requested UOM

IssdtTmp_Iss_Qty_InStkUom

bigint

NULL

IsudtTmp_Pending_Qty

decimal(28,8)

NULL

Quantity requested - Qty already issued

IsudtTmp_Cwo_Dtl_Exists_Flag

varchar(25)

NULL

Reference Document Existing Flag

ISUDTTMP_DESIGNEDLIFE

decimal(28,8)

NULL

ISUDTTMP_SHELFLIFEUNIT

varchar(5)

NULL

ISUDTTMP_MINLIFE

decimal(28,8)

NULL

ISUDTTMP_TRANSACTION_DATE

datetime

NULL

ISUDTTMP_ISS_QTY_INSTKUOM

decimal(28,8)

NULL

ISUDTTMP_STKTRANSFER_LINENO

decimal(10)

NULL

ISUDTTMP_PRTEXPRTNDATE

datetime

NULL

ISUDTTMP_WFCURRENTSTATE

varchar(10)

NULL

ISUDTTMP_ISS_COST

decimal(12)

NULL

ISUDTTMP_SER_LINENO

decimal(10)

NULL

ISUDTTMP_REQMNT_TYPE

varchar(5)

NULL

ISUDTTMP_AUTOISSUE_FLAG

varchar(1)

NULL

ISUDTTMP_ISS_PART_STATUS

varchar(40)

NULL

Table Name Isu_isuih_issue_tran_hdr

Table Comment This table used to hold the item header details for the &nbspissue transaction document. The header details includes the transaction type, number, date, warehouse from which the material is issued, reference document number if any, receiving organisation unit, created by and created date.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

ISUIH_Org_Unit

decimal(10)

NOT NULL

OU where Stock Issue is carried out.

ISUIH_Transaction_No

varchar(40)

Stock Issue Number.

ISUIH_Issue_Flag

varchar(5)

NULL

Issue Flag will indicate the activity thru which the Issue Document got created.

ISUIH_AutoIsu_Flag

varchar(5)

NULL

Automatic Issue Creation Flag ’A’  - Automatic Issue Creation ’M’  - Manual Issue Creation.

ISUIH_warehouse_org_unit

decimal(10)

NULL

OU to which the warehouse belongs to..

ISUIH_Warehouse_id

varchar(10)

NULL

The warehouse from where the parts must be issued.

ISUIH_issue_type

varchar(5)

NULL

Type of the Issue.

ISUIH_Status_code

varchar(15)

NULL

Status of the Issue Document. Can be either ’Draft’ or ’Fresh’ or ’Confirmed or ’Cancel’

ISUIH_Category

varchar(25)

NULL

The category to which the issue belongs.

ISUIH_User_Status

varchar(25)

NULL

The user status of the issue document.

ISUIH_Transaction_Date

datetime

NULL

The date on which the issue document is created for issuing the parts.

ISUIH_Remarks

varchar(255)

NULL

Any additional remark or comment pertaining to the issue document.

ISUIH_Ref_Doc_Type

varchar(25)

NULL

The type of the reference document.

ISUIH_Receiving_OrgUnit

decimal(10)

NULL

OU corresponding to the receiving org.

ISUIH_Ref_Doc_No

varchar(40)

NULL

The number identifying the reference document.

ISUIH_User_Define1

varchar(25)

NULL

Any other additional details pertaining to the modification of spares issue

ISUIH_User_Define2

varchar(25)

NULL

ISUIH_File_Name

varchar(50)

NULL

The name of the issue document file.

ISUIH_ShipDtl_Availablity

varchar(5)

NULL

Shipping Details Availability for the selected Issue No. NA     - Not Applicable AV     -  Available NAV  - Not Available

ISUIH_Acc_Usage

varchar(20)

NULL

The type of the account used

ISUIH_Cc_Usage

varchar(20)

NULL

The type of the costing used

ISUIH_Wf_Doc_Key

varchar(130)

NULL

Document Key.

ISUIH_Wf_New_State

varchar(10)

NULL

New State.

ISUIH_approved_by

varchar(30)

NULL

The name of the user who confirmed the issue document.

ISUIH_approved_date

datetime

NULL

The date on which the issue document was confirmed.

ISUIH_Created_By

varchar(30)

NULL

The name of the user who created the issue document.

ISUIH_Created_Date

datetime

NULL

The date on which the issue document was created.

ISUIH_Modified_by

varchar(30)

NULL

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

ISUIH_Modified_Date

datetime

NULL

The date on which the issue document was last modified.

ISUIH_Timestamp

decimal(10)

NULL

Number of times the Document has got modified..

ISU_MMD_REF_DOC_OU

decimal(10)

NULL

reference doc ou.

ISU_MMD_REF_DOC_NO

varchar(40)

NULL

The number identifying the reference document..

ISU_MMD_REF_DOC_LINE_NO

decimal(10)

NULL

reference doc line no.

ISU_MMD_REF_DOC_TYPE

varchar(25)

NULL

The type of the reference document. .

ISUIH_TRADINGPARTNERNO

sql_variant

NULL

The code identifying the trading partner..

ISUIH_TRADINGPARTNERTYPE

sql_variant

NULL

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

ISUIH_ISSUE_TO

sql_variant

NULL

The number identifying the employee. .

ISUIH_TRADINGPARTNEROU

int

NULL

Trading partner ou.

ISUIH_AIRCRAFTNO

varchar(30)

NULL

This field is used to capture AircraftReg No

ISUIH_WORKCENTER

varchar(30)

NULL

This field is used to capture WorkCenter No

ISUIH_DISPNO

varchar(40)

NULL

This field is used to capture discrepancy No

ISUIH_STATION

varchar(256)

NULL

This field captures station information

Table Name ISU_ISUIS_PART_STORAGE_DTL

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

ISUIS_TRANSACTION_NO

varchar(40)

NOT NULL

The number identifying the issue

ISUIS_PRT_SYSLINE_NO

decimal(10)

NOT NULL

Serial Number of the Part in the Issue Document

ISUIS_SRL_SYSLINE_NO

decimal(10)

NOT NULL

Unique Serial Number for Storage details

ISUIS_ORG_UNIT

decimal(10)

NOT NULL

OU where the Stock Issue is carried out

ISUIS_ZONE_ID

varchar(10)

NULL

The number identifying the zone in the warehouse from where the part is issued.

ISUIS_BIN_ID

varchar(10)

NULL

The number identifying the bin in the warehouse from where the part is issued.

ISUIS_LOT_NO

varchar(18)

NULL

The number identifying the lot to which the part belongs

ISUIS_SERIAL_NO

varchar(40)

NULL

The number identifying the serial number of the part that is issued.

ISUIS_PART_CONDITION

varchar(25)

NULL

The condition of the spare that is being issued. The system displays one of the following options: 1.New –indicates that the part is new. 2.Overhauled - indicates that the part is overhauled. 3.Serviceable - indicates that the part is serviceable. 4.Unserviceable - indicates that the part is unserviceable.

ISUIS_ISS_QTY

decimal(28,8)

NULL

Quantity being issued in this transaction

ISUIS_ISS_QTY_INSTKUOM

decimal(28,8)

NULL

Quantity being issued in the Stock Uom

ISUIS_ISS_QTY_INREQUOM

decimal(28,8)

NULL

Quantity being issued in the Requested Uom

ISUIS_ISS_COST

decimal(12)

NULL

This column maintains the value &nbspfor the Part being issued.

ISUIS_EXPIRY_DATE

datetime

NULL

The date of expiry of the serial # / lot # being issued

ISUIS_ISS_COMPUTED_COST

bigint

NULL

computed cost

ISUIS_ISS_COMPUTED_DATE

datetime

NULL

computed date

ISUIS_SHIPPED_QTY

datetime

NULL

Shipped Quantity Updated from shipping note page.

ISUIS_SSC_DOCNO

varchar(40)

NULL

Issue Document Number

ISUIS_ORIGINAL_LOTNO

varchar(18)

NULL

Issue Original lot number

ISUIS_ISS_TRDPARTNERTYPE

varchar(25)

NULL

Issue Trading partner type

ISUIS_ISS_TRDPARTNERNO

varchar(45)

NULL

Issue Trading partner number

Table Name Isu_IsuVwEntTmp_IssHdr_Tmp

Table Comment This table used to hold the Issue Part transaction document. The details includes the transaction type, transaction number,Issue number, Issue Requested part details , Issue part Details and Task Details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

IsuVwEntTmp_Org_Unit

decimal(10)

NOT NULL

OU where the Issue is carried out

IsuVwEntTmp_Transaction_No

varchar(40)

NOT NULL

Stock Issue Number

IsuVwEntTmp_GUID

varchar(40)

NOT NULL

GUID generation for inserting data with unique identifier into temporary table

IsuVwEntTmp_Transaction_Date

datetime

NULL

Issue Created Date

IsuVwEntTmp_Category

varchar(25)

NULL

Quick code to categorize issue transaction as per the users need

IsuVwEntTmp_Issue_Type_Code

varchar(5)

NULL

Issue type - Normal ParamCode - N

IsuVwEntTmp_Issue_Type

varchar(80)

NULL

Issue type - Normal

IsuVwEntTmp_Receiving_Org_Unit

decimal(10)

NULL

OU corresponding to the Reference Document Number

IsuVwEntTmp_OU_Desc

varchar(256)

NULL

Ou Description for entered ouinstance

IsuVwEntTmp_Ref_Doc_No

varchar(40)

NULL

The requesting document on the basis of which the Issue transaction is to be performed

IsuVwEntTmp_Ref_Doc_Type_Code

varchar(5)

NULL

The type of the document which requests the parts to be issued. Maintenance issue can be made with reference to component work order.

IsuVwEntTmp_Ref_Doc_Type

varchar(80)

NULL

IsuVwEntTmp_Status_Code

varchar(5)

NULL

Status of the Issue Document. Can be either ’Draft’ or ’Fresh’ or ’Confirmed or ’Cancel’ D    - Draft F    - Fresh C    - Cancel Co  - Confirmed

IsuVwEntTmp_Status

varchar(80)

NULL

Status of the Issue Document. Can be either ’Draft’ or ’Fresh’ or ’Confirmed or ’Cancel’

IsuVwEntTmp_Warehouse_Org_Unit

decimal(10)

NULL

OU to which the warehouse belongs to

IsuVwEntTmp_Warehouse_ID

varchar(10)

NULL

Warehouse Code

IsuVwEntTmp_Warehouse_Desc

varchar(80)

NULL

Warehouse Description for selected warehouse id

IsuVwEntTmp_User_Status

varchar(25)

NULL

Quick code to user status issue transaction as per the users need

ISUVWENTTMP_SHIPPINGINFO

varchar(80)

NULL

ISUVWENTTMP_REMARKS

varchar(255)

NULL

ISUVWENTTMP_TIMESTAMP

decimal(10)

NULL

Table Name Isu_IsuVwMnTmp_TrnItm_Dtl_Tmp

Table Comment This table used to hold the Issue Part transaction document. The details includes the transaction type, transaction number,Issue number, Issue Requested part details , Issue part Details and Task Details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

IsuVwMnTmp_Org_Unit

decimal(10)

NOT NULL

OU where Stock Issue is carried out

IsuVwMnTmp_Transaction_No

varchar(40)

NOT NULL

Issue Transaction Number

IsuVwMnTmp_GUID

varchar(40)

NOT NULL

GUID generation for inserting data with unique identifier into temporary table

IsuVwMnTmp_Ref_Doc_Type

varchar(25)

NULL

Reference Document Type CWO - Component Work Order

IsuVwMnTmp_Ref_Doc_No

varchar(40)

NULL

Ref Document #.The requesting document on the basis of which the transaction is to be Performed.

IsuVwMnTmp_Receiving_Orgunit

decimal(10)

NULL

Ref Document # OU. The requesting document on the basis of which the transaction is to be performed.

IsuVwMnTmp_warehouse_org_unit

decimal(10)

NULL

The warehouse OU from which stock are to be/being issued

IsuVwMnTmp_Warehouse_id

varchar(10)

NULL

The warehouse from which stock are to be/being issued

IsuVwMnTmp_LineSerialNo

decimal(10)

NULL

Serial Number of the Part in the Issue Document

IsuVwMnTmp_Task_Ou

decimal(10)

NULL

The Task OuInstance which is mapped to be Requested Part If the task OUInstance is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IsuVwMnTmp_Task_No

varchar(30)

NULL

The Task Code which is mapped to be Requested Part If the task Code is NULL then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IsuVwMnTmp_Task_Seq_No

decimal(10)

NULL

The Task SeqNo which is mapped to be Requested Part If the task SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IsuVwMnTmp_Task_Key_SeqNo

decimal(10)

NULL

The Task Key SeqNo which is mapped to be Requested Part If the task Key SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

IsuVwMnTmp_Iss_Part_Crt_Ou

decimal(10)

NULL

Issue Part Created OUInstance

IsuVwMnTmp_Iss_Part_No

varchar(40)

NULL

The parts # to be/being issued. Sometimes the part # may not be in the stock and an alternate part # may be issued.

IsuVwMnTmp_Iss_Part_Desc

varchar(150)

NULL

Issue Part Description

IsuVwMnTmp_Req_Part_Crt_Ou

decimal(10)

NULL

Requested Part Created OUInstance

IsuVwMnTmp_Req_Part_No

varchar(40)

NULL

The part # requested by the reference document

IsuVwMnTmp_Req_Part_Desc

varchar(150)

NULL

Request Part Description

IsuVwMnTmp_Iss_Qty

decimal(28,8)

NULL

Quantity being issued in this transaction

IsuVwMnTmp_Pending_Qty

decimal(28,8)

NULL

Quantity requested - Qty already issued

IsuVwMnTmp_Txn_UOM

varchar(10)

NULL

It is the unit of measurement in which the issue transaction is to be/being made. Conversion should have been defined between this UOM and stock UOM.

IsuVwMnTmp_Req_UOM

varchar(10)

NULL

Request Part Consumption Qty UOM

IsuVwMnTmp_Part_Status

varchar(40)

NULL

The user defined status of the parts being issued

IsuVwMnTmp_Part_Type_Code

varchar(5)

NULL

Issue Part Type ParamCode

IsuVwMnTmp_Part_Type

varchar(80)

NULL

Issue Part Type

IsuVwMnTmp_Part_Ctrl_Flag

varchar(25)

NULL

Requested Part Control Type ’YN’ - Lot Control Part ’NY’ - Serial Control Part ’YY’ - Lot and Serial Control Part ’NN’ - Nothing

IsuVwMnTmp_Part_Ctrl_Type

varchar(80)

NULL

ISUVWMNTMP_EXP_RTN_DATE

datetime

NULL

ISUVWMNTMP_SUB_PART_NO

varchar(40)

NULL

ISUVWMNTMP_SUB_PART_DESC

varchar(150)

NULL

ISUVWMNTMP_PART_ISUBASIS

varchar(5)

NULL

ISUVWMNTMP_PART_ISUBASIS_DESC

varchar(25)

NULL

ISUVWMNTMP_FILENAME

varchar(80)

NULL

ISUVWMNTMP_REMARKS

varchar(150)

NULL

ISUVWMNTMP_STKTRANSFER_LINENO

decimal(10)

NULL

Table Name ISU_KNOCKED_BY_RCPT_DTL

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

ISU_DOC_OU

numeric(28)

NULL

ISU_DOC_NO

varchar(40)

NULL

ISU_LINE_NO

numeric(28)

NULL

ISU_PART_NO

varchar(40)

NULL

ISU_PART_STATUS

varchar(40)

NULL

RCPT_DOC_OU

numeric(28)

NULL

RCPT_DOC_NO

varchar(40)

NULL

RCPT_LINE_NO

numeric(28)

NULL

RCPT_TYPE

varchar(10)

NULL

RCPT_PART_NO

varchar(40)

NULL

RCPT_PART_STATUS

varchar(40)

NULL

Table Name Isu_ModMntFet2_PartDtl_Tmp

Table Comment This table used to hold the Issue Part transaction document. The details includes the transaction type, transaction number,Issue number, Issue Requested part details , Issue part Details and Task Details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

ModFetTmp_Ouinstance

decimal(10)

NULL

OU where Stock Issue is carried out

ModFetTmp_Guid

varchar(40)

NULL

GUID generation for inserting data with unique identifier into temporary table

ModFetTmp_Cwo_Ou

int

NOT NULL

Ref Document # OU. The requesting document on the basis of which the transaction is to be performed.

MODFETTMP_REFDOC_TYPE

varchar(10)

NULL

MODFETTMP_REFDOC_OU

decimal(10)

NULL

ModFetTmp_Cwo_No

sql_variant

NOT NULL

Ref Document #.The requesting document on the basis of which the transaction is to be performed.

MODFETTMP_REFDOC_NO

varchar(40)

NULL

ModFetTmp_Issue_No

varchar(18)

NULL

Issue Transaction Number

ModFetTmp_WareHouse_No

varchar(10)

NULL

The warehouse from which stock are to be/being issued

ModFetTmp_WareHouse_Ou

decimal(10)

NULL

The warehouse OU from which stock are to be/being issued

ModFetTmp_Line_No

decimal(10)

NULL

Serial Number of the Part in the Issue Document

ModFetTmp_ReqPart_CrtOU

decimal(10)

NULL

Requested Part Created OU

ModFetTmp_ReqPart_No

varchar(40)

NULL

The part # requested by the reference document

ModFetTmp_ReqPart_Desc

varchar(150)

NULL

Requested Part Description

ModFetTmp_IssPart_CrtOU

decimal(10)

NULL

Issue Part Created OUInstance

ModFetTmp_IssPart_No

varchar(40)

NULL

The parts # to be/being issued. Sometimes the part # may not be in the stock and an alternate part # may be issued.

ModFetTmp_IssPart_Desc

varchar(150)

NULL

Issue Part Description

ModFetTmp_Iss_Qty

decimal(28,8)

NULL

Quantity being issued in this transaction

ModFetTmp_Tran_UOM

varchar(10)

NULL

It is the unit of measurement in which the issue transaction is to be/being made. Conversion should have been defined between this UOM and stock UOM.

ModFetTmp_Stk_Status

varchar(40)

NULL

The user defined status of the parts being issued

ModFetTmp_Task_Ou

decimal(10)

NULL

The Task OuInstance which is mapped to be Requested Part If the task OUInstance is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

ModFetTmp_Task_No

varchar(40)

NULL

The Task Code which is mapped to be Requested Part If the task Code is NULL then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

ModFetTmp_Task_SeqNo

decimal(10)

NULL

The Task SeqNo which is mapped to be Requested Part If the task SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

ModFetTmp_Task_Key_SeqNo

decimal(10)

NULL

The Task Key SeqNo which is mapped to be Requested Part If the task Key SeqNo is 0 then the Requested part is mapped at the Component Work Order Level. Else It is mapped at the Task Level

ModFetTmp_PendIss_Qty

decimal(28,8)

NULL

Quantity requested - Qty already issued

ModFetTmp_Req_UOM

varchar(10)

NULL

It is the unit of measurement in which the issue transaction is to be/being made. Conversion should have been defined between this UOM and stock UOM.

ModFetTmp_Part_Type

varchar(5)

NULL

Issue Part Type

ModFetTmp_PartCndl_Type

varchar(5)

NULL

Requested Part Control Type ’YN’ - Lot Control Part ’NY’ - Serial Control Part ’YY’ - Lot and Serial Control Part ’NN’ - Nothing

MODFETTMP_REMARKS

varchar(255)

NULL

MODFETTMP_ISUBASIS

varchar(5)

NULL

MODFETTMP_EXPRTNDATE

datetime

NULL

MODFETTMP_PREFCOND

varchar(5)

NULL

MODFETTMP_SUBPART_CRTOU

decimal(10)

NULL

MODFETTMP_SUBPART_NO

varchar(40)

NULL

MODFETTMP_SUBPART_DESC

varchar(150)

NULL

MODFETTMP_STKTRNSF_LINENO

decimal(10)

NULL

Table Name Isu_RecShp_StkTrn_Ship_Dtl

Table Comment For Stock Transfer and Repair Order Issue, shipping details are captured for the stock that goes out of the warehouse.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

RecShp_Payment_Mthd

varchar(150)

NULL

The mode in which the payment must be made.

RecShp_Ship_DateTime

datetime

NULL

The date on which the stock was shipped.

RecShp_User_Def_Dtl1

varchar(25)

NULL

Any other additional details pertaining to the shipping details.

RecShp_Landing_Bill_No

sql_variant

NULL

Landing Bill No.

RecShp_Delivery_Note_Date

datetime

NULL

The date on which the delivery note was raised.

RecShp_Delivery_Note_No

varchar(40)

NULL

The number identifying the delivery note.

RECSHP_WAY_BILL_DATE

datetime

NULL

The date on which the waybill was raised.

RecShp_Modified_By

varchar(25)

NULL

The name of the user who last modified the issue..

RecShp_Created_Date

datetime

NULL

Created Date

RecShp_Modified_Date

datetime

NULL

The date on which the issue was last modified..

ResShp_User_Def_Dtl2

varchar(25)

NULL

Any other additional details pertaining to the shipping details.

RecShp_Remarks

varchar(255)

NULL

Any other additional comment pertaining to the shipping details.

RecShp_Created_By

varchar(25)

NULL

The name of the user who created the issue..

RecShp_File_Name

varchar(50)

NULL

The name of the issue document file.

RecShp_TimeStampInt

decimal(38)

NULL

TimeStamp.

RecShp_Ship_By

varchar(25)

NULL

Indicates the method by which the part is shipped.

RecShp_Package_Code

varchar(25)

NULL

The code identifying the package method of the part.

RecShp_VehicleOrFlt_No

varchar(20)

NULL

The number identifying the vehicle that was used to transport the stock to the specific warehouse.

RecShp_Transaction_OU

decimal(10)

NOT NULL

OU where Stock Issue is carried out.

RecShp_Recv_Point

varchar(256)

NULL

The destination organization unit of the transferred goods.

RecShp_Transaction_No

varchar(40)

NOT NULL

The number identifying the issue.

RecShp_Way_Bill_No

varchar(40)

NULL

The number identifying the document, containing a list of goods with shipping instructions related to a shipment.

RecShp_Insur_Amount

decimal(28,8)

NULL

The sum of the insurance amount.

RecShp_Insur_Liability

varchar(5)

NULL

Indicates who should bear the insurance amount, which could be any of the following: 1.Self – Indicates that the person who ships has to bear the insurance amount. 2.Third Party  - Indicate that the insurance company or any other party bears the insurance amount.

RecShp_Ship_Note_No

varchar(40)

NULL

The number identifying the shipping note created for part shipment.

RecShp_Carrier

varchar(150)

NULL

The code identifying the carrier through which the stock is shipped.

RecShp_Freight_Bill_No

sql_variant

NULL

Freight Bill No.

RecShp_Freight_Term

varchar(150)

NULL

The term of the freight.

RecShp_Freight_Amt

decimal(28,8)

NULL

The sum of freight charges that have been levied for movement of goods.

Table Name Isu_TcdDtl_StkTrnTcd_Dtl

Table Comment For Stock Transfer and Repair Order Issue, Tax & Charges details are captured for the stock that goes out of the warehouse.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

TcdDtl_Tcd_Code

varchar(25)

NULL

TCD Code from TCD Component.

TcdDtl_Tcd_Ou

decimal(10)

NOT NULL

TCD No# Created Ou.

TcdDtl_Tcd_Variant

varchar(25)

NULL

TCD Variant for the selected TCD Code.

TcdDtl_Tcd_Rate

decimal(28,8)

NULL

TCD Rate.

TcdDtl_Tcd_Amount

decimal(28,8)

NULL

TCD Amount :- Sum of all the TCD Rate for the document

ISUID_Org_Unit

decimal(10)

NOT NULL

OU where the Stock Issue is carried out.

TCDDTL_TRANSACTION_OU

decimal(10)

NOT NULL

OU where Issue is carried out.

TcdDtl_Prt_SysLine_No

decimal(10)

NOT NULL

Serial Number of the Part in the Issue Document.

ISUID_Transaction_No

varchar(40)

NOT NULL

Stock Issue Number.

TCDDTL_TRANSACTION_NO

varchar(40)

NOT NULL

Transaction No.

Table Name Isu_UpiDtl_Unplnd_Issue_Dtl

Table Comment This table used to hold the item details for the unplanned item issue transaction document. The item details includes the item code, transaction UOM, Quantity, Zone, Bin, Item stock status, value, etc

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

UpiDtl_Anly_Code

varchar(5)

NULL

Analysis Code.

UpiDtl_SubAnly_Code

varchar(5)

NULL

Sub Analysis Code.

UpiDtl_Cc_Usage

varchar(20)

NULL

The type of the costing used

UpiDtl_Acc_Code

varchar(32)

NULL

The type of the account used.

UpiDtl_Finance_Book

varchar(20)

NULL

Finance Book.

UpiDtl_Acc_Usage

varchar(20)

NULL

Accounting Usage.

UpiDtl_Adl_Dtl_Exists_Flag

varchar(5)

NULL

This flag indicates the existence of records in the storage detail table.

UPIDTL_COMPUTED_COST

decimal(28,8)

NULL

ISSUE COST

UpiDtl_Costcenter_Code

varchar(10)

NULL

Cost Center Code.

UpiDtl_Remarks

varchar(255)

NULL

Any other additional comment pertaining to the modification of spares issue

UpiDtl_Exp_Rtn_Date

datetime

NULL

The date on which the part must be returned.

UPIDTL_COMPUTED_DATE

datetime

NULL

date on which issued part rate calculated

UpiDtl_SysLine_No

decimal(10)

NOT NULL

Line Number.

UpiDtl_DisplayLine_No

decimal(10)

NOT NULL

Display Line Number..

UpiDtl_Iss_Part_Pln_Ou

decimal(10)

NOT NULL

Issue Part Planning OUInstance.

UpiDtl_Transaction_No

varchar(40)

NOT NULL

Stock Issue Number.

UpiDtl_Transaction_OU

decimal(10)

NOT NULL

OU where Stock Issue is carried out.

UpiDtl_Issue_Cost

decimal(28,8)

NULL

This column maintains the value for the Part being issued..

UpiDtl_Isu_Qty_InStkUom

decimal(28,8)

NULL

Issue Quantity inStock Uom.

UpiDtl_Part_Status

varchar(40)

NULL

Part Status for issue part. it is udds value defined in the udds component.

UpiDtl_Iss_Part_Crt_Ou

decimal(10)

NOT NULL

Issue Part Created OUInstance.

UpiDtl_Iss_Part_No

varchar(40)

NULL

The part number to be issued.

UpiDtl_Isu_Uom

varchar(10)

NULL

Issue Transaction UOM.

UpiDtl_Isu_Qty

decimal(28,8)

NULL

The number of parts to be issued.

UPIDTL_SHIPPED_QTY

decimal(28,8)

NULL

Shipped Quantity Updated from Record shipping Note

Table Name Isu_Rec_Ship_Note_Hdr

Table Comment This table used to record the shipping note entries.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Isu_Rec_Ship_Note_OU

udd_ctxt_ouinstance

NOT NULL

Shipping Note OU.

Isu_Rec_Ship_Note_No

udd_documentno

NOT NULL

Shipping Note Number.

Isu_Rec_Ship_Num_Type

udd_quickcodes

NULL

Shipping Numbering Type.

Isu_Rec_Ship_Type

udd_quickcodes

NULL

Shipping Type

Isu_Rec_Ship_Doc_Status

udd_status

NULL

Document Status

Isu_Rec_Ship_Ship_Category

udd_quickcodes

NULL

Shipping category

Isu_Rec_Ship_User_Status

udd_quickcodes

NULL

User Status

Isu_Rec_Ship_DateTime

udd_datetime1

NULL

Shipping note date time.

Isu_Rec_Ship_Time

udd_date

NULL

Shipping time

Isu_Rec_Ship_ShipContact

udd_contact

NULL

shipping contact

Isu_Rec_Ship_ContactTele

udd_communicationid

NULL

Contact telephone 

Isu_Rec_Ship_ContactFax

udd_fax

NULL

contact fax number

Isu_Rec_Ship_ShipTo

udd_designparamcode

NULL

Shipping To

Isu_Rec_Ship_ShipToCode

udd_vendorcode

NULL

Shipping To code

Isu_Rec_Ship_AddID

udd_address

NULL

Address ID

Isu_Rec_Ship_Recipient

fin_recipe

NULL

Recipient Name

Isu_Rec_Ship_Address

udd_txt255

NULL

Shipping Address 

Isu_Rec_Ship_City

udd_city

NULL

City

Isu_Rec_Ship_State

udd_state

NULL

State

Isu_Rec_Ship_Country

udd_country

NULL

Ship to, country

Isu_Rec_Ship_Zipcode

fin_zip

NULL

ship to, code

Isu_Rec_Ship_ShipBy

udd_quickcodes

NULL

ship by 

Isu_Rec_Ship_CarrierCode

udd_quickcodes

NULL

carrier code

Isu_Rec_Ship_VehicleNo

udd_documentno

NULL

vehicle number

Isu_Rec_Ship_LandingNo

udd_documentno

NULL

Landing No

Isu_Rec_Ship_WayBillNo

udd_documentno

NULL

Waybill number

Isu_Rec_Ship_WayBillDate

udd_datetime1

NULL

Waybill date

Isu_Rec_Ship_PSNo

udd_documentno

NULL

Pack slip number

Isu_Rec_Ship_PSDate

udd_datetime1

NULL

Pack slip date

Isu_Rec_Ship_ShipPay

udd_quickcodes

NULL

ship by 

Isu_Rec_Ship_Fright

udd_amount

NULL

Fright chargers

Isu_Rec_Ship_FrightCur

udd_currency

NULL

Fright currency

Isu_Rec_Ship_FrightTerms

udd_txt2000

NULL

Fright Terms and conditions

Isu_Rec_Ship_NoOfPacks

udd_txt20

NULL

No of Packs

Isu_Rec_Ship_PackByEmp

udd_ctxt_user

NULL

Packed By Employee code

Isu_Rec_Ship_PackCode

udd_quickcodes

NULL

Package code

Isu_Rec_Ship_ContainerNo

udd_documentno

NULL

container Number

Isu_Rec_Ship_PackDim

udd_quantity

NULL

Package dimension

Isu_Rec_Ship_PackUOM

udd_uom

NULL

pack Unit of Measurement

Isu_Rec_Ship_GrossWgt

udd_quantity

NULL

Gross weight

Isu_Rec_Ship_GrossUOM

udd_uom

NULL

Gross weight UOM

Isu_Rec_Ship_HandlingTerms

udd_txt2000

NULL

Handling terms and conditions

Isu_Rec_Ship_ContPer

udd_contactperson

NULL

Contact person

Isu_Rec_Ship_ContFax

udd_fax

NULL

contact fax number

Isu_Rec_Ship_ContTele

udd_communicationid

NULL

Shipping Contact telephone

Isu_Rec_Ship_ContExtn

udd_fax

NULL

Shipping Contact extn number

Isu_Rec_Ship_ContMobile

udd_fax

NULL

contact person mobile number

Isu_Rec_Ship_ContEmail

udd_email

NULL

Contact person email iD

Isu_Rec_Ship_InsLiab

udd_designparamcode

NULL

Insurance Liability

Isu_Rec_Ship_InsAmount

udd_amount

NULL

Insurance amount

Isu_Rec_Ship_InsCur

udd_currency

NULL

Insurance Currency

Isu_Rec_Ship_InsTerms

udd_txt2000

NULL

Insurance terms and conditions

Isu_Rec_Ship_FileName

udd_filename

NULL

File name

Isu_Rec_Ship_Remarks

udd_remarks

NULL

remarks

Isu_Rec_Ship_CanCmts

udd_txt255

NULL

cancellation comments

Iss_Rec_Ship_TimeStamp

udd_timestamp

NULL

Time stamp

Isu_Rec_Ship_CreatedDate

udd_datetime1

NULL

Created Date

Isu_Rec_Ship_CreatedBy

udd_ctxt_user

NULL

Created By

Isu_Rec_Ship_ModifiedDate

udd_datetime1

NULL

Modified Date

Isu_Rec_Ship_ModifiedBy

udd_ctxt_user

NULL

Modified By

Isu_Rec_Ship_ConfirmedDate

udd_datetime1

NULL

Confirmed Date

Isu_Rec_Ship_ConfimedBy

udd_ctxt_user

NULL

Confirmed By

Table Name Isu_Rec_Ship_Note_Dtl

Table Comment This table used to record the shipping note entries - multiline level.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Isu_Rec_Ship_Dtl_OU

udd_ctxt_ouinstance

NULL

Shipping Note OU.

Isu_Rec_Ship_Dtl_NoteNo

udd_documentno

NULL

Shipping Note Number.

Isu_Rec_Ship_Dtl_LineNo

udd_seqno

NULL

Part Line No

Isu_Rec_Ship_Dtl_PartNo

udd_partno

NULL

part no

Isu_Rec_Ship_Dtl_Quantity

udd_quantity

NULL

Quantity

Isu_Rec_Ship_Dtl_UOM

udd_uom

NULL

Unit of measurement