|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| EXOH_OuInstance | udd_ctxt_ouinstance | int(4) | No | Organisation Unit value | No |
| EXOH_Order_No | udd_documentno | varchar(40) | No | Exchange order # | No |
| EXOH_Exchange_Entity | udd_desc40 | varchar(40) | No | Exchange Entity | No |
| EXOH_Doc_Status | udd_designparamcode | varchar(5) | No | Exchange order status (Fresh, Cancelled, Confirmed, Shortclosed, Foreclosed, Closed) | No |
| EXOH_Exchg_Approval_Status | udd_designparamcode | varchar(5) | No | Approval status. This will be derived from Execution commerical service. Possible values will be Not Required, Required, Pending, Approved, Rejected | No |
| EXOH_Quote_Appr_Status | udd_designparamcode | varchar(5) | No | Quote approval status. Values will be Not Required, Required, Pending, pproved, Rejected | No |
| EXOH_Exchange_Type | udd_designparamcode | varchar(5) | No | Exchange Order Attributes Flat Exchange with repair | No |
| EXOH_Core_Status | udd_designparamcode | varchar(5) | No | It represents the status of the Core. Possible values will be Not Applicable, Pending, Closed | No |
| EXOH_Core_Avl_Status | udd_designparamcode | varchar(5) | No | It represents the availability status of the core. Possible values will be Not Applicable, Pending, Available | No |
| EXOH_Request_Status | udd_designparamcode | varchar(5) | No | It represents whether the exchange request on the core is satisfied or not. Possible values will be Pending, Open, Closed | No |
| EXOH_Initiated_As | udd_designparamcode | varchar(5) | No | Exchange Order Attributes Regular Advance exchange | No |
| EXOH_Ini_Doc_Type | udd_designparamcode | varchar(5) | No | Initiating document type (Customer Order, Material Request, Shop Work Order, Repair Order) | No |
| EXOH_Ini_Doc_No | udd_documentno | varchar(40) | No | Initiating document # | No |
| EXOH_Ini_Doc_Ou | udd_ctxt_ouinstance | int(4) | No | Initiating document OU | No |
| EXOH_Ini_By | udd_ctxt_user | varchar(30) | No | Initiated by (Employee #) | No |
| EXOH_Ini_Date | udd_datetime1 | datetime(8) | No | Initiated date | No |
| EXOH_Reason_ExchgCd | udd_quickcodes | varchar(25) | No | Reason for exchange. Will be loaded from the metadata table # LCM_EXRSN_INFO which is in logistics common master. | No |
| EXOH_Reason_Type | udd_type | varchar(25) | No | Reason type - Quick code data. The values may be "Internal" or"External" | No |
| EXOH_Exchange_MRNO | udd_documentno | varchar(40) | No | Exchange MR # which is generated on confirmation of Exchange order | No |
| EXOH_Exchange_MROu | udd_ctxt_ouinstance | int(4) | No | Exchange MR OU | No |
| EXOH_Parent_SWONO | udd_documentno | varchar(40) | No | Shop Work Order # - If the Initiating reference document is Customer order, then this value will be blank - If the Initiating reference document is Material request order, then this value will be reference document of Material request - If the Initia | No |
| EXOH_Parent_SWOOu | udd_ctxt_ouinstance | int(4) | No | Organisation unit | No |
| EXOH_Cust_Ord_No | udd_documentno | varchar(40) | No | Customer Order document # - This value will be available only if the Initiating reference document type is Customer Order | No |
| EXOH_Cust_Ord_Ou | udd_ctxt_ouinstance | int(4) | No | Organization Unit | No |
| EXOH_Customer_No | udd_vendorcode | varchar(45) | No | Customer code, if initiating reference document is customer order | No |
| EXOH_Remarks | udd_notes | varchar(2000) | No | Remarks | No |
| EXOH_Comments | udd_notes | varchar(2000) | No | Comments | No |
| EXOH_Created_By | udd_ctxt_user | varchar(30) | No | The User who created Exchange Order | No |
| EXOH_Created_Date | udd_datetime1 | datetime(8) | No | Exchange Order creation date | No |
| EXOH_Modified_By | udd_ctxt_user | varchar(30) | No | The User who recently modified Exchange Order | No |
| EXOH_Modified_Date | udd_datetime1 | datetime(8) | No | Recently modifed data time | No |
| EXOH_Approved_By | udd_ctxt_user | varchar(30) | No | The User who approved Exchange Order | No |
| EXOH_Approved_Date | udd_datetime1 | datetime(8) | No | Exchange order approved date | No |
| EXOH_Closed_By | udd_ctxt_user | varchar(30) | No | The User who closed Exchange Order | No |
| EXOH_Closed_Date | udd_datetime1 | datetime(8) | No | Exchange order closed date | No |
| EXOH_Timestamp | udd_seqno | int(4) | No | Timestamp | No |
| EXOH_App_Hold_Code | udd_quickcode | varchar(25) | No | Exchange approval hold code value | No |
| EXOH_Quote_App_Hold_Code | udd_quickcode | varchar(25) | No | Exchange order quote approval hold code | No |
| EXOH_App_InstantId | udd_unique_id | bigint(8) | No | Exchange approval - Instance ID | No |
| EXOH_Quote_App_InstantId | udd_unique_id | bigint(8) | No | Exchange order - Quote approval instance ID | No |
| EXOH_CO_Revno | udd_seqno | int(4) | No | Customer order revision number | No |
| EXOH_Adl_Ref_Doc_Type | udd_designparamcode | varchar(5) | No | Additional ref.doc type which will be updated only top assembly regular exchange with internal repair (SWO), external repair for (RO) | No |
| EXOH_Adl_Ref_Doc_No | udd_documentno | varchar(40) | No | Additional ref.doc # which will be updated only top assembly regular exchange with internal repair (SWO #), external repair for (RO #) | No |
| EXOH_Adl_Ref_Doc_OU | udd_ctxt_ouinstance | int(4) | No | Additional ref.doc OU | No |
| EXOH_Autoflag | udd_designparamcode | varchar(5) | No | Y/N Y which will represents exchange order will be generated/created automatically , N which will represents exchange order will be generated/created Manually. | No |
| EXOH_Task_Track_Id | UDD_Integer8 | bigint(8) | No | Task track id | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ExoOWN_Order_No | udd_documentno | varchar(40) | No | Exchange order # | No |
| ExoOWN_Order_Line_No | udd_seqno | int(4) | No | Exchange order line # | No |
| ExoOWN_Part_No | udd_partno | varchar(40) | No | Part # which will be exchange | No |
| ExoOWN_Serial_No | UDD_SERIALNO | varchar(40) | No | Part Serial # | No |
| ExoOWN_Lot_No | udd_lotno | varchar(18) | No | Part Lot # | No |
| ExoOWN_From_Part_Status | udd_partstatus | varchar(40) | No | Parts from stock status which will be issued/core part from status | No |
| ExoOWN_To_Part_Status | udd_partstatus | varchar(40) | No | Parts To stock status which will be issued/core part To status | No |
| ExoOWN_From_Owning_Agency | udd_desc40 | varchar(40) | No | From Owning agency which represents a Customer # | No |
| ExoOWN_From_Ownership | udd_ownership | varchar(40) | No | Parts From ownership which will be CUS or OWN or SUP | No |
| ExoOWN_From_Owning_OU | udd_ctxt_ouinstance | int(4) | No | From Owing agency Orgainsation unit value | No |
| ExoOWN_To_Owning_Agency | udd_desc40 | varchar(40) | No | To Owning agency which represents a Customer # | No |
| ExoOWN_To_Ownership | udd_ownership | varchar(40) | No | Parts To ownership which will be CUS or OWN or SUP | No |
| ExoOWN_To_Owning_OU | udd_ctxt_ouinstance | int(4) | No | To Owing agency Orgainsation unit value | No |
| ExoOWN_User | udd_ctxt_user | varchar(30) | No | Created/Modified User name | No |
| ExoOWN_DateTime | udd_datetime | varchar(30) | No | Created/Modified Date time | No |
| ExoOWN_Remarks | udd_txt150 | varchar(150) | No | Remarks if any | No |
| ExoOWN_Order_OU | udd_ctxt_ouinstance | int(4) | No | Organisation Unit value | No |
| EXOOWN_Unique_Id | udd_seqno | int(4) | No | Unique Id which is a primary constraints | No | |
| Table Name : | EXCH_EXOSRC_SOURCE_INFO |
| Comment : | Table to store the document related to Sourcing information like Issue details |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| EXOSRC_OuInstance | udd_ctxt_ouinstance | int(4) | No | Organisation Unit value | No |
| EXOSRC_Order_No | udd_documentno | varchar(40) | No | Exchange order # | No |
| EXOSRC_Line_No | udd_lineno | int(4) | No | Record line # | No |
| EXOSRC_Src_Doc_No | udd_documentno | varchar(40) | No | Triggering from which documents like issue, GR movements nd unplanned issues while sourcing part satisfied to the customer. | No |
| EXOSRC_Src_Doc_Type | udd_designparamcode | varchar(5) | No | Sourcing document types which ISU, UPISU and GR. | No |
| EXOSRC_Src_Doc_Line_No | udd_lineno | int(4) | No | Document line number. | No |
| EXOSRC_Src_Doc_PrtNo | udd_partno | varchar(40) | No | Soucing part # | No |
| EXOSRC_Src_Doc_PrtSts | udd_status | varchar(25) | No | Soucing Part Status which will be picked from stock or SWO. | No |
| EXOSRC_Src_Doc_Prt_Ownership | udd_ownership | varchar(40) | No | Parts ownership #. | No |
| EXOSRC_Src_Doc_Prt_OwnAgency | udd_desc40 | varchar(40) | No | Parts ownership which will be CUS or OWN or SUP | No |
| EXOSRC_Src_Doc_Prt_OwningOU | udd_ctxt_ouinstance | int(4) | No | Owing agency Orgainsation unit value | No |
| EXOSRC_Src_Doc_Prt_Quantity | udd_quantity | numeric(13) | No | Owning agency which represents a Customer # | No |
| EXOSRC_Src_Doc_Date | udd_datetime | varchar(30) | No | Document date | No |
| EXOSRC_Src_Doc_Status | udd_status | varchar(25) | No | Soucing document status like CONF . | No |
| EXOSRC_Src_Doc_Srl_No | UDD_SERIALNO | varchar(40) | No | Sourcing document serial # | No |
| EXOSRC_Src_Doc_Lot_No | UDD_SERIALNO | varchar(40) | No | Sourcing document Lot # | No |
| EXOSRC_Src_Doc_Warehouse | udd_warehouse | varchar(10) | No | Sourcing from which warehouse | No |
| EXOSRC_Src_Doc_Rtn_Qty | udd_quantity | numeric(13) | No | Total core quantity returned against sourcing quantity. | No |
| EXOSRC_Core_Prt_Sts_Chg_Flag | udd_designparamcode | varchar(5) | No | Yes/No, Whether Core part status changed or not. | No |
| EXOSRC_Core_Prt_Sts_Chg_SrlNo | UDD_SERIALNO | varchar(40) | No | Core part s modified serial number which will be updated only part status flag changes as "Y" | No |
| EXOSRC_Core_Prt_Sts_Chg_LotNo | udd_lotno | varchar(18) | No | Core part s modified lot number which will be updated only part status flag changes as "Y" | No |
| EXOSRC_Core_Prt_Sts_Chg_PartNo | udd_partno | varchar(40) | No | Core part # which will be updated only part status flag changes as "Y" | No |
| EXOSRC_Src_Doc_Prt_Cond | udd_designparamcode | varchar(5) | No | Core part s condition which will be updated only part status flag changes as "Y" | No |
| EXOSRC_Src_Type | udd_designparamcode | varchar(5) | No | Sourcing type which indicates whether sourcing from Inventory, Shop work order | No |
| EXOSRC_Stk_Sts_No | udd_documentno | varchar(40) | No | Stock status conversion Document # | No |
| EXOSRC_Stk_Sts_Line_No | udd_seqno | int(4) | No | Stock status conversion Document line # | No |
| EXOSRC_Stk_Sts_Ou | udd_ctxt_ouinstance | int(4) | No | Organization Unit value. | No |
| EXOSRC_Po_No | udd_documentno | varchar(40) | No | Sourcing Purchase order # which will be applicable only for part sourcing through Goods receipt which PO type "Exchange PO" | No |
| EXOSRC_Po_Line_No | udd_seqno | int(4) | No | Purchase order part line # | No |
| EXOSRC_Po_Ou | udd_ctxt_ouinstance | int(4) | No | Organisation Unit value, | No |
| EXOSRC_To_Part_Status | udd_partstatus | varchar(40) | No | Sourcign To part status | No |
| EXOSRC_Unique_Id | udd_seqno | int(4) | No | Unique Id which is a primary constraints | No |
| EXOSRC_To_Ownership | udd_ownership | varchar(40) | No | the final ownership of the part which involved in exchange | No |
| EXOSRC_To_Owning_Agency | udd_desc40 | varchar(40) | No | the owning agency of the ownership of the part which involved in exchange | No |
| EXOSRC_To_Owning_OU | udd_ctxt_ouinstance | int(4) | No | the OU of the owning agency | No | |
| Table Name : | EXCH_EXOS_EXCHG_ORD_SRC_DTL |
| Comment : | Exchange Order Sourcing Info - Table to maintain the information such as source part details which will replace the core part |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| EXOS_OuInstance | udd_ctxt_ouinstance | int(4) | No | Organisation Unit value | No |
| EXOS_Order_No | udd_documentno | varchar(40) | No | Exchange order # | No |
| EXOS_Dtl_Line_No | udd_lineno | int(4) | No | Record line # | No |
| EXOS_Line_No | udd_lineno | int(4) | No | Exchange Line # | No |
| EXOS_Disp_Line_No | udd_lineno | int(4) | No | Exchange Display line # | No |
| EXOS_Source_Type | udd_designparamcode | varchar(5) | No | Mode of source picking (Inventory or Repair) | No |
| EXOS_Src_Ref_Doc_Ou | udd_ctxt_ouinstance | int(4) | No | Organisation unit | No |
| EXOS_Src_Ref_Doc_No | udd_documentno | varchar(40) | No | Soruce Reference document # | No |
| EXOS_Src_Ref_Doc_Type | udd_designparamcode | varchar(5) | No | Soruce reference document type | No |
| EXOS_Inv_Src_Strategy | udd_designparamcode | varchar(5) | No | Determines the serial # picking strategy. (Specific or Any serial picking) | No |
| EXOS_Src_Qty | udd_quantity | numeric(13) | No | Soruce Quantity | No |
| EXOS_Exchg_Uom | udd_uom | varchar(15) | No | Units of Measurement | No |
| EXOS_Src_Part_Ou | udd_ctxt_ouinstance | int(4) | No | Organisation Unit.. | No |
| EXOS_Src_Part_No | udd_partno | varchar(40) | No | Source part # | No |
| EXOS_Src_Lot_No | udd_lotno | varchar(18) | No | Source part lot # | No |
| EXOS_Src_Serial_No | UDD_SERIALNO | varchar(40) | No | Source part serial # | No |
| EXOS_Src_Manf_Srl_No | UDD_SERIALNO | varchar(40) | No | Source manufacture part serial # | No |
| EXOS_Src_Manf_Lot_No | udd_lotno | varchar(18) | No | Source manufacture part lot # | No |
| EXOS_Src_Part_Condition | udd_designparamcode | varchar(5) | No | Source part condition | No |
| EXOS_Src_Part_Status | udd_status | varchar(25) | No | Source part status | No |
| EXOS_Ownership | udd_ownership | varchar(40) | No | Part ownership | No |
| EXOS_Owning_Agency | udd_desc40 | varchar(40) | No | Part Owning agency (Supplier / Customer ID) | No |
| EXOS_Owning_Agency_Ou | udd_ctxt_ouinstance | int(4) | No | Organisation unit. | No |
| EXOS_Src_Instruction | udd_notes | varchar(2000) | No | Sourcing instruction will be copied to Material request or Purchase request documents as remarks | No |
| EXOS_Ship_Instruction | udd_notes | varchar(2000) | No | Shipping instruction (will be used for advance exchanges) | No |
| EXOS_Src_Warehouse_Ou | udd_ctxt_ouinstance | int(4) | No | Organisation- unit | No |
| EXOS_Src_Warehouse | udd_warehouse | varchar(10) | No | Source Warehouse | No |
| EXOS_Src_Zone | udd_zone | varchar(10) | No | Source Zone | No |
| EXOS_Src_Bin | udd_bin | varchar(10) | No | Source Bin | No |
| EXOS_Src_Status | udd_status | varchar(25) | No | Refers to the current action taken against the source part. It may have the values as "Planned", "In Progress", "Closed | No |
| EXOS_Src_Donor_MRNo | udd_documentno | varchar(40) | No | Material request # which will be generated to satisfy the source part since the source part was used by the core part as exchange unit | No |
| EXOS_Src_Donor_MROu | udd_ctxt_ouinstance | int(4) | No | Organizationunit | No |
| EXOS_Task_Track_Id | UDD_Integer8 | bigint(8) | Yes | Task Track ID | No |
| EXOS_HardSwapQ | udd_seqno | int(4) | No | it represents a 1 or 0 values. If Hardswap checked means value will be 1 otherwise 0. | No |
| EXOS_Src_Mr_Line_No | udd_seqno | int(4) | No | Sourcing MR document line # | No |
| EXOS_Core_Type | udd_designparamcode | varchar(5) | No | core type | No |
| EXOS_Core_Type_id | udd_seqno | int(4) | No | core type id | No |
| EXOS_Rtn_Track_id | udd_documentno | varchar(40) | No | return track id | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| EXOTL_OuInstance | udd_ctxt_ouinstance | int(4) | No | Organisation Unit value, | No |
| EXOTL_Order_No | udd_documentno | varchar(40) | No | Exchange order # | No |
| EXOTL_Line_No | udd_lineno | int(4) | No | Exchange order line # | No |
| EXOTL_Mod_Entity_Name | UDD_TXT60 | varchar(60) | No | Table name which will be modified | No |
| EXOTL_Mod_Attribute_Name | UDD_TXT60 | varchar(60) | No | Column name which will be modified | No |
| EXOTL_SP_Name | UDD_TXT60 | varchar(60) | No | Invoked Stored Procedure name | No |
| EXOTL_Old_Value | udd_notes | varchar(2000) | No | Old value available in the table - column | No |
| EXOTL_New_Value | udd_notes | varchar(2000) | No | Changed value available in the table - column | No |
| EXOTL_Modified_By | udd_ctxt_user | varchar(30) | No | Modified by | No |
| EXOTL_Modified_Date | udd_datetime1 | datetime(8) | No | Modified datetime | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| EXPRM_COMPONENTNAME | udd_compname | varchar(40) | Yes | Component Name | No |
| EXPRM_PARAMCATEGORY | udd_paramcategory | varchar(10) | Yes | Parameter Category | No |
| EXPRM_PARAMTYPE | udd_paramtype | varchar(25) | Yes | Parameter Type | No |
| EXPRM_PARAMCODE | udd_paramcode | varchar(30) | Yes | Parameter Code | No |
| EXPRM_PARAMDESC | udd_txt150 | varchar(150) | Yes | Parameter Description | No |
| EXPRM_LANGID | udd_ctxt_language | int(4) | Yes | Language id | No |
| EXPRM_SORT_BY | udd_seqno | int(4) | Yes | Sort by | No |
| REPLICATION_KEY | _Bigint_8 | Bigint(8) | No | replication key | Yes |