Data Dictionary -- Stock Transfer

Srl. No.	Table Name	Comment
1	TRN_INTERAD_ZNBNTRNSFR_ADL	This table contains the additional warehouse bin level information pertaining to Intra Stock Transfers (i.e., stock transfers that happen within a warehouse across Zones/Bins)
2	TRN_INTERDT_PARTTRNSFR_DTL	This table contains the Part level information pertaining to Inter Stock Transfers (i.e., stock transfers that happens across warehouse within the same location or different location)
3	TRN_INTERMN_STKTRNSFR_HDR	Inter Warehouse stock transfer (i.e. stock tranferred across warehouse with in the same location or stock tranferred across warehouse across locations) details are stored here. This entity is seperately kept and not stored in the same iintra warehouse ent
4	TRN_INTERSH_SHIPPING_INFO	this table contains the details about the Shipping Information.
5	TRN_INTERSRL_SERIALLOT_DTL	this table contains the details about the Part Serial Lot Information.
6	TRN_INTERTCD_TRNFR_TCD_DTL	TRN_INTERTCD_TRNFR_TCD_DTL
7	TRN_INTRAAD_ZNBNTRNSFR_ADL	This table contains the additional warehouse bin level information pertaining to Intra Stock Transfers (i.e., stock transfers that happen within a warehouse across Zones/Bins)
8	TRN_INTRADT_PARTTRNSFR_DTL	This table contains the Part level information pertaining to Intra Stock Transfers (i.e., stock transfers that happen within a warehouse across Zones/Bins)
9	TRN_INTRAMN_STKTRNSFR_HDR	This table contains the main information pertaining to Intra Stock Transfers (i.e., stock transfers that happen within a warehouse across Zones/Bins)
10	TRN_INTRASRL_SERIALLOT_DTL	used to store the intra warehouse serial lot details..
11	TRN_TRNDA_DOC_ATTACH_DTL	this table is used to store the attached reference document details
12	TRN_TRNOPT_OPTION_SETTINGS	this is used to decide whether the user wants manual or automatic stock transfer
13	TRN_TRNPRM_PARAMETER_DTL	Stores Parameter detail information. In this component, this table needs to store only search criteria message
14	TRN_TRNQC_QUICK_CODE	this table contains the details about the quick code type and their corrsponding values.

Table Name :	TRN_INTERAD_ZNBNTRNSFR_ADL
Comment :	This table contains the additional warehouse bin level information pertaining to Intra Stock Transfers (i.e., stock transfers that happen within a warehouse across Zones/Bins)

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
INTERAD_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU ID where the Inter warehouse stock transfer takes place	Yes
INTERAD_STKTRANSFER_NO	_varchar_40	varchar(40)	No	System generated Inter Warehouse Stock Transfer No	Yes
INTERAD_LINE_NO	_decimal_10_0	decimal(10)	No	System generated Line number for each part detail that needs to be tranferred across warehouse locations.	Yes
INTERAD_SEQ_NO	_decimal_10_0	decimal(10)	No	Line number of zone bin for part level	Yes
INTERAD_FROM_ZONE	_varchar_10	varchar(10)	No	Zone in the source warehouse from where the Part is to be moved from	No
INTERAD_FROM_BIN	_varchar_10	varchar(10)	No	Zone-Bin Id in the source warehouse from where the Part is to be moved from	No
INTERAD_TO_ZONE	_varchar_10	varchar(10)	No	Zone in the destination warehouse where the Part is to be moved to	No
INTERAD_TO_BIN	_varchar_10	varchar(10)	No	Zone-Bin in the destination warehouse where the Part is to be moved to	No
INTERAD_TRNSFR_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	The quantity (in the part s stock uom) that is being moved from the zone-bin of the source warehouse location to zone-bin of the destination same warehouse location	No
INTERAD_DISPLAYLINE_NO	_decimal_10_0	decimal(10)	Yes	Dis play line number for zone bin based on placement statergy	No

Table Name :	TRN_INTERDT_PARTTRNSFR_DTL
Comment :	This table contains the Part level information pertaining to Inter Stock Transfers (i.e., stock transfers that happens across warehouse within the same location or different location)

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
INTERDT_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU ID where the Inter warehouse stock transfer takes place	Yes
INTERDT_STKTRANSFER_NO	_varchar_40	varchar(40)	No	System generated Inter Warehouse Stock Transfer No	Yes
INTERDT_LINE_NO	_decimal_10_0	decimal(10)	No	System generated Line number for each part detail that needs to be tranferred across warehouse locations.	Yes
INTERDT_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Created OU Id of the Part which needs to be moved	No
INTERDT_PART_NO	_varchar_40	varchar(40)	Yes	Part No which is to be moved across warehouse-location	No
INTERDT_REF_DOC_OU	_decimal_10_0	decimal(10)	Yes	Reference Document Ouinstance	No
INTERDT_REF_DOC_NO	_varchar_40	varchar(40)	Yes	Reference Document Number	No
INTERDT_REF_DOC_TYPE	_varchar_5	varchar(5)	Yes	Reference Document Type MR - Material Request	No
INTERDT_REF_DOC_LINENO	_decimal_10_0	decimal(10)	Yes	Reference Document Part Line No	No
INTERDT_TRNSFR_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Quantity to be transferred in it s Stock Uom	No
INTERDT_ISS_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Issued Qty in Stock Uom	No
INTERDT_PART_STATUS	_varchar_40	varchar(40)	Yes	Part Status of the part at the time of transfer	No
INTERDT_PREF_CONDITION	_varchar_25	Varchar(25)	Yes	Preferred part condition at the time of transfer	No
INTERDT_TO_WAREHOUSE_OU	_decimal_10_0	decimal(10)	Yes	Warehouse ou	No
INTERDT_TO_WAREHOUSE_ID	_varchar_10	varchar(10)	Yes	Warehouse where the stock is (to be) moved to.	No
INTERDT_ALT_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	If the part specified is not available, this will be OU ID of the alternate part that will be moved to the destination warehouse which could be in the same location or in a different location.	No
INTERDT_ALT_PART_NO	_varchar_40	varchar(40)	Yes	If the part specified is not available, this will be the alternate part that will be moved to the destination warehouse which could be in the same location or in a different location.	No
INTERDT_TRNSFR_TYPE	_varchar_5	varchar(5)	Yes	Following lists the transfer types codes and their description. Gen - General Spec - Specific	No
INTERDT_REMARKS	_varchar_255	varchar(255)	Yes	Inter Part Transfer remarks (if any)	No
INTERDT_SRLLOT_LNKFLAG	_varchar_5	varchar(5)	Yes	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	No
INTERDT_ZNBN_LNKFLAG	_varchar_5	varchar(5)	Yes	This can take the following values. Y , N , NA If the From or To Warehouse Zone-Bin details are completely entered for the Line, this will be Y If the From or To Warehouse Zone-Bin details are pending to be entered for the Line, this will be	No
INTERDT_ACC_USAGE	_varchar_20	varchar(20)	Yes	Account usage for part	No
INTERDT_FIN_BOOK	_varchar_20	varchar(20)	Yes	Finance book of the acedamic year	No
INTERDT_ACC_CODE	_varchar_32	varchar(32)	Yes	Account code for the accounting usage	No
INTERDT_ANLY_CODE	_varchar_5	varchar(5)	Yes	anlaysis code	No
INTERDT_SUBANLY_CODE	_varchar_5	varchar(5)	Yes	sub analysis code	No
INTERDT_CREATED_BY	_varchar_30	varchar(30)	Yes	create by - user name	No
INTERDT_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	created date	No
INTERDT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified by	No
INTERDT_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	modified date	No
INTERDT_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time stamp	No
INTERDT_DISPLAYLINE_NO	_decimal_10_0	decimal(10)	Yes	line number based on placement stragey	No
INTERDT_SCL_QTY_INSTKUOM	_decimal_28_2	decimal(28)	Yes	quantity in stock UOM	No
INTERDT_INTERDELFLAG	_varchar_5	varchar(5)	Yes	Deletion flag	No
INTERDT_MR_LLVL_CVDQTY_INSTKUOM	udd_quantity	numeric(13)	Yes	Line Level Quantity in Stock	No
INTERDT_SHIPBY	udd_txt20	varchar(20)	Yes	Ship By	No
INTERDT_SHIP_INSTR	udd_txt255	varchar(255)	Yes	Ship In	No
INTERDT_KNOCKOFF_STOQTY_INSTKUOM	udd_quantity	numeric(13)	Yes	Knock Off Stock Transfer Order Quantity	No

Table Name :	TRN_INTERMN_STKTRNSFR_HDR
Comment :	Inter Warehouse stock transfer (i.e. stock tranferred across warehouse with in the same location or stock tranferred across warehouse across locations) details are stored here. This entity is seperately kept and not stored in the same iintra warehouse ent

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
INTERMN_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU ID where the Inter warehouse stock transfer takes place	Yes
INTERMN_STKTRANSFER_NO	_varchar_40	varchar(40)	No	System generated Inter Warehouse Stock Transfer No	Yes
INTERMN_TRANFER_STATUS	_varchar_5	varchar(5)	Yes	Inter warehouse stock transfer status. Following could be the status for a Stock Transfer document. Draft - Drft Fresh - Frsh Authorized - Auth Cancelled - Canc ShortClosed - ShCl Closed - Clsd	No
INTERMN_USER_STATUS	_varchar_25	Varchar(25)	Yes	User defined Quick Code status for the Stock Transfer Document	No
INTERMN_NEED_DATE	_datetime_8	datetime(8)	Yes	The requested date of stock transfer.	No
INTERMN_CATEGORY	_varchar_25	Varchar(25)	Yes	User defined quick code categories of inter stock transfer	No
INTERMN_PRIORITY	_varchar_5	varchar(5)	Yes	Following lists the priority codes and description. Norm - Normal, AOG - Aircraft On Ground	No
INTERMN_TRANSFER_DATE	_datetime_8	datetime(8)	Yes	The actual date on which stock transfer is to be initiated	No
INTERMN_PART_TYPE	_varchar_5	varchar(5)	Yes	Part Type which are transacted as part of the inter stock transfer. Part type combination are defined in Logistics Common Master option settings. These Part types are used here.	No
INTERMN_ISU_LOCN	_decimal_10_0	decimal(10)	Yes	issue location	No
INTERMN_RCPT_LOCN	_decimal_10_0	decimal(10)	Yes	receipt location	No
INTERMN_FROM_WAREHOUSE_OU	_decimal_10_0	decimal(10)	Yes	Location (OU ID) from where the stock transfer is initiated (i.e. Stocking Point from where the stock transfer is initiated)	No
INTERMN_FROM_WAREHOUSE_ID	_varchar_10	varchar(10)	Yes	Warehouse from where the stock transfer is initiated	No
INTERMN_STOCK_UPD_MODE	_varchar_5	varchar(5)	Yes	Following are the codes and descriptions for the stock update mode Auto - Automatic Manl - Manual UsrDf - User Defined	No
INTERMN_REF_DOC_OU	_decimal_10_0	decimal(10)	Yes	Source reference document Ouinstance	No
INTERMN_REF_DOC_NO	_varchar_40	varchar(40)	Yes	Source reference document no (or desc) which requested for the inter stock transfer	No
INTERMN_REF_DOC_TYPE	_varchar_5	varchar(5)	Yes	Source reference document Type MR - Material Request	No
INTERMN_EMP_OU	_decimal_10_0	decimal(10)	Yes	OU ID of the Employee who initiated the inter stock transfer	No
INTERMN_EMP_CODE	_varchar_20	varchar(20)	Yes	Employee who initiated the inter stock transfer	No
INTERMN_EMP_NAME	_varchar_150	varchar(150)	Yes	Name of the employee who initiated the inter stock transfer	No
INTERMN_PHONE_NO	_varchar_70	varchar(70)	Yes	Phone no of the employee who initiated the stock transfer	No
INTERMN_REASON_DTL	_varchar_255	varchar(255)	Yes	Reason for initiating the inter stock transfer	No
INTERMN_REMARKS	_varchar_255	varchar(255)	Yes	Inter stock transfer remarks (if any)	No
INTERMN_FILENAME	_varchar_50	varchar(50)	Yes	to store the file name	No
INTERMN_AUTHORIZED_BY	_varchar_30	varchar(30)	Yes	OU ID of the employee who authorized the inter stock transfer	No
INTERMN_AUTHORIZED_DATETIME	_datetime_8	datetime(8)	Yes	Date and time on which the Inter Stock Transfer Document got authorized	No
INTERMN_CREATED_BY	_varchar_30	varchar(30)	Yes	Created Login User Name	No
INTERMN_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	Created date and time	No
INTERMN_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last modified login user name	No
INTERMN_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	Last Modified date and time	No
INTERMN_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Integer Timestamp which is maintained for concurrency	No
INTERMN_USER_DEF_1	_varchar_25	Varchar(25)	Yes	User defined field 1	No
INTERMN_USER_DEF_2	_varchar_25	Varchar(25)	Yes	User defined field 2	No
INTERMN_WF_DOC_KEY	_varchar_128	varchar(128)	Yes	Work flow document key	No
INTERMN_WF_NEW_STATE	_varchar_10	varchar(10)	Yes	work flow new status	No
INTERMN_AUTO_FLAG	_varchar_5	varchar(5)	Yes	auto matic flag for issue generation	No
INTERMN_REPLENISHMENT_FLAG	_varchar_5	varchar(5)	Yes	repleshment flag say s requiered or not	No
INTERMN_TRADPART_NO	udd_vendorcode	varchar(45)	Yes	Trading partner No	No
INTERMN_TRADPART_TYPE	udd_flag2	varchar(25)	Yes	Trading partner Type either customer or supplier	No
INTERMN_TRADPART_OU	udd_ctxt_ouinstance	int(4)	Yes	OU Instance of the trading partner	No
INTERMN_TGRISUREP	udd_flag	varchar(25)	Yes	Repleshment flag say s requiered or not.	No
INTERMN_DEFWH	udd_warehouse	varchar(10)	Yes	Default Ware House	No
INTERMN_DEFZN	udd_zone	varchar(10)	Yes	Default Zone	No
INTERMN_DEFBN	udd_bin	varchar(10)	Yes	Default Bin	No

Table Name :	TRN_INTERSH_SHIPPING_INFO
Comment :	this table contains the details about the Shipping Information.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
INTERSH_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU ID where the Inter warehouse stock transfer takes place	Yes
INTERSH_STKTRANSFER_NO	_varchar_40	varchar(40)	No	System generated Inter Warehouse Stock Transfer No	Yes
INTERSH_SHIP_BY	_varchar_25	Varchar(25)	Yes	shipped by	No
INTERSH_PACKAGE_CODE	_varchar_25	Varchar(25)	Yes	packagin code	No
INTERSH_VEHICLEORFLT_NO	_varchar_20	varchar(20)	Yes	transport vechile number	No
INTERSH_CARRIER	_varchar_150	varchar(150)	Yes	carrier name	No
INTERSH_FREIGHT_BILL_NO	_varchar_40	varchar(40)	Yes	frieght bill number	No
INTERSH_FREIGHT_AMT	_decimal_28_8	decimal(28)	Yes	frieght bill amount	No
INTERSH_FREIGHT_TERM	_varchar_150	varchar(150)	Yes	frieght terms and condition	No
INTERSH_LANDING_BILL_NO	_varchar_40	varchar(40)	Yes	landing bil number	No
INTERSH_INSURANCE_LIABILITY	_varchar_25	Varchar(25)	Yes	insurance and liabilty conditions	No
INTERSH_INSURANCE_AMT	_decimal_28_8	decimal(28)	Yes	insurance amount	No
INTERSH_WAY_BILL_NO	_varchar_40	varchar(40)	Yes	way	No
INTERSH_SHIPPING_PAY_MTHD	_varchar_150	varchar(150)	Yes	payment method for shipping agency	No
INTERSH_SHIPMENT_DATETIME	_datetime_8	datetime(8)	Yes	shippment date and time	No
INTERSH_USER_DEF_1	_varchar_30	varchar(30)	Yes	user definition 1	No
INTERSH_USER_DEF_2	_varchar_30	varchar(30)	Yes	user definition 2	No
INTERSH_REMARKS	_varchar_255	varchar(255)	Yes	remarks	No
INTERSH_CREATED_BY	_varchar_30	varchar(30)	Yes	created by	No
INTERSH_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	created date and time	No
INTERSH_MODIFIED_BY	_varchar_30	varchar(30)	Yes	modified by	No
INTERSH_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	modified date and time	No
INTERSH_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	time stamp	No

Table Name :	TRN_INTERSRL_SERIALLOT_DTL
Comment :	this table contains the details about the Part Serial Lot Information.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
INTERSRL_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU ID where the Inter warehouse stock transfer takes place	Yes
INTERSRL_STKTRANSFER_NO	_varchar_40	varchar(40)	No	System generated Inter Warehouse Stock Transfer No	Yes
INTERSRL_LINE_NO	_decimal_10_0	decimal(10)	No	System generated Line number for each part detail that needs to be tranferred across warehouse locations.	Yes
INTERSRL_SEQ_NO	_decimal_10_0	decimal(10)	No	serial lot sequence number	Yes
INTERSRL_SERIAL_NO	_varchar_40	varchar(40)	No	serial number	Yes
INTERSRL_LOT_NO	_varchar_40	varchar(40)	No	lot number	Yes
INTERSRL_TRANSFER_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	quantity to be transferred.	No
INTERSRL_REMARKS	_varchar_255	varchar(255)	Yes	remarks	No

Table Name :	TRN_INTERTCD_TRNFR_TCD_DTL
Comment :	TRN_INTERTCD_TRNFR_TCD_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
INTERTCD_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU ID where the Inter warehouse stock transfer takes place	Yes
INTERTCD_STKTRANSFER_NO	_varchar_40	varchar(40)	No	System generated Inter Warehouse Stock Transfer No	Yes
INTERTCD_LINE_NO	_decimal_10_0	decimal(10)	No	System generated Line number for each part detail that needs to be tranferred across warehouse locations. This will be 0 if the TCD info is at document level	Yes
INTERTCD_TCD_LINE_ID	_decimal_10_0	decimal(10)	No	tcd line number	Yes
INTERTCD_TCD_OU	_decimal_10_0	decimal(10)	Yes	tcd created ou.	No
INTERTCD_TCD_NO	_varchar_40	varchar(40)	Yes	tcd number	No
INTERTCD_TCD_VARIANT	_varchar_40	varchar(40)	Yes	tcd variant	No
INTERTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	tcd rate	No
INTERTCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	tcd amount	No
INTERTCD_TCD_ACCCODE	_varchar_45	varchar(45)	Yes	tcd account code	No
INTERTCD_TCD_SUPACCCODE	_varchar_45	varchar(45)	Yes	tcd supplier account code	No
INTERTCD_TCD_PAYTOSUP	_varchar_45	varchar(45)	Yes	pay to supplier code	No
INTERTCD_TCD_ACCRULE	_varchar_5	varchar(5)	Yes	account rule ATS - add to stock Exp - expensed off	No
INTERTCD_COSTCENTER_CODE	_varchar_10	varchar(10)	Yes	cost center code	No

Table Name :	TRN_INTRAAD_ZNBNTRNSFR_ADL
Comment :	This table contains the additional warehouse bin level information pertaining to Intra Stock Transfers (i.e., stock transfers that happen within a warehouse across Zones/Bins)

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
INTRAAD_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU where Intra Stock Transfer is initiated	Yes
INTRAAD_STKTRANSFER_NO	_varchar_40	varchar(40)	No	System generated Stock Transfer No	Yes
INTRAAD_LINE_NO	_decimal_10_0	decimal(10)	No	System generated Line number for each part detail that needs to be tranferred within warehouse	Yes
INTRAAD_SEQ_NO	_decimal_10_0	decimal(10)	No	zone bin sequence number	Yes
INTRAAD_FROM_ZONE	_varchar_10	varchar(10)	No	Zone in the warehouse from where the Part is to be moved from	No
INTRAAD_FROM_BIN	_varchar_10	varchar(10)	No	Zone-Bin Id in the warehouse from where the Part is to be moved from	No
INTRAAD_TO_ZONE	_varchar_10	varchar(10)	No	Zone in the warehouse where the Part is to be moved to	No
INTRAAD_TO_BIN	_varchar_10	varchar(10)	No	Zone-Bin in the warehouse where the Part is to be moved to	No
INTRAAD_TRNSFR_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	The quantity (in stock uom) that is being moved from one zone-bin of the warehouse to another zone-bin of the same warehouse	No
INTRAAD_PRTCOST	_decimal_28_8	decimal(28)	Yes	Part Cost	No

Table Name :	TRN_INTRADT_PARTTRNSFR_DTL
Comment :	This table contains the Part level information pertaining to Intra Stock Transfers (i.e., stock transfers that happen within a warehouse across Zones/Bins)

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
INTRADT_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU where Intra Stock Transfer is initiated	Yes
INTRADT_STKTRANSFER_NO	_varchar_40	varchar(40)	No	System generated Stock Transfer No	Yes
INTRADT_LINE_NO	_decimal_10_0	decimal(10)	No	System generated Line number for each part detail that needs to be tranferred within warehouse	Yes
INTRADT_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Created OU Id of the Part which needs to be moved	No
INTRADT_PART_NO	_varchar_40	varchar(40)	Yes	Part No which is to be moved with in the warehouse	No
INTRADT_TRNSFR_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Quantity requested to be transferred in it s Stock Uom	No
INTRADT_PART_STATUS	_varchar_40	varchar(40)	Yes	Part Status at the time of transfer	No
INTRADT_PREF_CONDITION	_varchar_25	Varchar(25)	Yes	Preferred part condition at the time of transfer	No
INTRADT_REMARKS	_varchar_255	varchar(255)	Yes	Part Transfer remarks (if any)	No
INTRADT_SRLLOT_LNKFLAG	_varchar_5	varchar(5)	Yes	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	No
INTRADT_ZNBN_LNKFLAG	_varchar_5	varchar(5)	Yes	This can take the following values. Y , N , NA If the From Warehouse Zone-Bin details are completely entered for the Line, this will be Y If the From Warehouse Zone-Bin details are pending to be entered for the Line, this will be N If the	No
INTRADT_CREATED_BY	_varchar_30	varchar(30)	Yes	created by	No
INTRADT_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	created datetime	No
INTRADT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	modified by	No
INTRADT_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	modified date and time	No
INTRADT_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	time stamp	No
INTRADT_STOCK_UOM	udd_unitofmeasurement	varchar(10)	Yes	Stock UOM	No

Table Name :	TRN_INTRAMN_STKTRNSFR_HDR
Comment :	This table contains the main information pertaining to Intra Stock Transfers (i.e., stock transfers that happen within a warehouse across Zones/Bins)

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
INTRAMN_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU where Intra Stock Transfer is initiated	Yes
INTRAMN_STKTRANSFER_NO	_varchar_40	varchar(40)	No	System generated Stock Transfer No	Yes
INTRAMN_STKTRANSFER_STATUS	_varchar_5	varchar(5)	Yes	Following could be the status for a Stock Transfer document. Draft - Drft Fresh - Frsh Authorized - Auth Cancelled - Canc ShortClosed - ShCl Closed - Clsd 1) Draft: Whenever all details are not e	No
INTRAMN_CATEGORY	_varchar_25	Varchar(25)	Yes	User defined fields (Quick Codes) to categorize Stock Transfers	No
INTRAMN_TRANSFER_DATE	_datetime_8	datetime(8)	Yes	Date on which the transfer has to be initiated	No
INTRAMN_WAREHOUSE_OU	_decimal_10_0	decimal(10)	Yes	Warehouse where in stock transfer is to be initiated	No
INTRAMN_WAREHOUSE_ID	_varchar_10	varchar(10)	Yes	OU id of the warehouse where the stock transfer is to be initiated	No
INTRAMN_USER_STATUS	_varchar_25	Varchar(25)	Yes	User defined status for the Stock Transfer document	No
INTRAMN_PART_TYPE	_varchar_5	varchar(5)	Yes	Part type that is moved from the warehouse	No
INTRAMN_REF_DOC_NO	_varchar_40	varchar(40)	Yes	Details of any reference document for which the stock transfer is initiated	No
INTRAMN_EMP_OU	_decimal_10_0	decimal(10)	Yes	OUInstance ID of the Employee who initiated the stock transfer transaction	No
INTRAMN_EMP_CODE	_varchar_20	varchar(20)	Yes	Employee Code who initiated the Stock Transfer	No
INTRAMN_EMP_NAME	_varchar_150	varchar(150)	Yes	Employee Name who initiated the Stock Transfer	No
INTRAMN_EMP_PHONE	_varchar_70	varchar(70)	Yes	Phone No of the employee who initiated the stock transfer	No
INTRAMN_REASON_DTL	_varchar_255	varchar(255)	Yes	Reason for which stock transfer is initiated.	No
INTRAMN_REMARKS	_varchar_255	varchar(255)	Yes	Stock Transfer Remarks (if any)	No
INTRAMN_AUTHORIZED_BY	_varchar_30	varchar(30)	Yes	OU ID of the employee who authorized the stock transfer	No
INTRAMN_AUTHORIZED_DATETIME	_datetime_8	datetime(8)	Yes	Datetime on which the stock transfer was authorized.	No
INTRAMN_FILENAME	_varchar_50	varchar(50)	Yes	Attached filename	No
INTRAMN_CREATED_BY	_varchar_30	varchar(30)	Yes	Created Login User Name	No
INTRAMN_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	Created date and time	No
INTRAMN_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last modified login user name	No
INTRAMN_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	Last modified date and time	No
INTRAMN_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Integer Timestamp which is maintained for concurrency	No
INTRAMN_USER_DEF_1	_varchar_25	Varchar(25)	Yes	User Defined Field 1	No
INTRAMN_USER_DEF_2	_varchar_25	Varchar(25)	Yes	User Defined Field 2	No
INTRAMN_WF_DOC_KEY	_varchar_128	varchar(128)	Yes	Work flow document key like ou~documentno..	No
INTRAMN_WF_NEW_STATE	_varchar_10	varchar(10)	Yes	work flow status	No
INTRAMN_TRADPART_NO	udd_vendorcode	varchar(45)	Yes	trading partner number owner name	No
INTRAMN_TRADPART_TYPE	udd_flag2	varchar(25)	Yes	trarding partner type CUS - Customer SUP - Supplier OWN - Internal	No
INTRAMN_TRADPART_OU	udd_ctxt_ouinstance	int(4)	Yes	ownership location..	No
INTRAMN_AUTOST_FLAG	udd_designparamcode	varchar(5)	Yes	Flag used to check the status of the intrastock transfer to be created.	No

Table Name :	TRN_INTRASRL_SERIALLOT_DTL
Comment :	used to store the intra warehouse serial lot details..

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
INTRASRL_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU where Intra Stock Transfer is initiated	Yes
INTRASRL_STKTRANSFER_NO	_varchar_40	varchar(40)	No	System generated Stock Transfer No	Yes
INTRASRL_LINE_NO	_decimal_10_0	decimal(10)	No	System generated Line number for each part detail that needs to be tranferred within warehouse	Yes
INTRASRL_SEQ_NO	_decimal_10_0	decimal(10)	No	Wareouse line number of the part	Yes
INTRASRL_KEY_SEQ_NO	_decimal_10_0	decimal(10)	No	Serial line number	Yes
INTRASRL_SERIAL_NO	_varchar_40	varchar(40)	No	internal serial number	No
INTRASRL_LOT_NO	_varchar_40	varchar(40)	No	internal lot number	No
INTRASRL_NEW_LOT_NO	_varchar_40	varchar(40)	Yes	For only lot controlled parts, new lot no is generated. This is required during stock balance updation	No
INTRASRL_TRANSFER_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	quantity transfered in stock UOM	No
INTRASRL_REMARKS	_varchar_255	varchar(255)	Yes	remarks	No
INTRASRL_PRTCOST	_decimal_28_8	decimal(28)	Yes	Parts Cost	No

Table Name :	TRN_TRNDA_DOC_ATTACH_DTL
Comment :	this table is used to store the attached reference document details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TRNDA_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU ID of the Return transaction	Yes
TRNDA_TRANSFER_NO	_varchar_40	varchar(40)	No	This could be Inter or Intra Stock Transfer No	Yes
TRNDA_INTER_OR_INTRA_FLAG	_varchar_25	Varchar(25)	No	Reference Document Type	Yes
TRNDA_SEQ_NO	_decimal_10_0	decimal(10)	No	sequence number of the reference document attached	Yes
TRNDA_DOC_TYPE	_varchar_15	varchar(15)	No	document type	No
TRNDA_DOC_ID	_varchar_40	varchar(40)	No	Document Id	No
TRNDA_FILE_NAME	_varchar_50	varchar(50)	Yes	Reference File Name	No
TRNDA_REMARKS	_varchar_255	varchar(255)	Yes	Remarks (if any)	No

Table Name :	TRN_TRNOPT_OPTION_SETTINGS
Comment :	this is used to decide whether the user wants manual or automatic stock transfer

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TRNOPT_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance ID where the Option Settings is set	Yes
TRNOPT_ISURCPT_OU_GEN_FLAG	_varchar_5	varchar(5)	Yes	Issue/Receipt Generate Mode applicable for inter warehouse stock transfer which takes place within an OU. Following are the codes and it s values Auto - Automatic Manl - Manual UsDef - User Defined	No
TRNOPT_ISURCPT_GEN_FLAG	_varchar_5	varchar(5)	Yes	Issue/Receipt Generate Mode applicable for inter warehouse stock transfer which takes place across OU/Location. Following are the codes and it s values Auto - Automatic Manl - Manual UsDef - User Defined	No
TRNOPT_AUTOSTKTRN_NUMTYPE	_varchar_5	varchar(5)	Yes	This is the numbering type that will be taken when automatic stock transfer document is generated thru stock maintenance when the level of stock goes down below the reorder or min qty during issue.	No
TRNOPT_CREATEDDATE	_datetime_8	datetime(8)	Yes	created date	No
TRNOPT_CREATED_BY	_varchar_30	varchar(30)	Yes	created by	No
TRNOPT_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	modified date	No
TRNOPT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	modified by	No
TRNOPT_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Integer Timestamp which is maintained for concurrency	No
TRNOPT_AllowMulRecForSti	udd_txt5	varchar(5)	Yes	This column is used to hold value of -Allow Multiple Stock Transfer Receipt	No

Table Name :	TRN_TRNPRM_PARAMETER_DTL
Comment :	Stores Parameter detail information. In this component, this table needs to store only search criteria message

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TRNPRM_COMPONENTNAME	_varchar_80	varchar(80)	No	Component Code	Yes
TRNPRM_PARAMCATEGORY	_varchar_10	varchar(10)	No	This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.	Yes
TRNPRM_PARAMTYPE	_varchar_25	Varchar(25)	No	Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.	Yes
TRNPRM_PARAMCODE	_varchar_5	varchar(5)	No	Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component	Yes
TRNPRM_PARAMDESC	_varchar_80	varchar(80)	Yes	Description of the Param Code	No
TRNPRM_LANGID	_decimal_10_0	decimal(10)	No	Language id. This is the language id of the record.	Yes
TRNPRM_SORT_BY	_decimal_10_0	decimal(10)	Yes	The order in which the values are populated.	No
TRNPRM_CREATIONDATE	_datetime_8	datetime(8)	Yes	created date	No

Table Name :	TRN_TRNQC_QUICK_CODE
Comment :	this table contains the details about the quick code type and their corrsponding values.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TRNQC_OUINSTANCE	_decimal_10_0	decimal(10)	No	the ou in which the quick code is created	Yes
TRNQC_QUICK_CODE	_varchar_25	Varchar(25)	No	the quick code value.	Yes
TRNQC_TYPE	_varchar_5	varchar(5)	No	the type can be either transfer category or user status. transfer category--CAT user status--US	Yes
TRNQC_DESC	_varchar_80	varchar(80)	Yes	quick code description	No
TRNQC_STATUS	_varchar_5	varchar(5)	Yes	it can be either active or inactive active--A inactive--I	No
TRNQC_CREATEDDATE	_datetime_8	datetime(8)	Yes	the created date	No
TRNQC_CREATED_BY	_varchar_30	varchar(30)	Yes	created by	No
TRNQC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	modified date	No
TRNQC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	modified by	No
TRNQC_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Integer Timestamp which is maintained for concurrency	No