Data Dictionary -- Goods Inward

Srl. No.	Table Name	Comment
1	GI_GIACCA_CostAmend_info	Table to store GI cost amendment information
2	GI_GIACREV_ACCP_INFO	Table to store Reverse Inspection details
3	GI_GIAC_ACCP_INFO	Inspection details
4	GI_GICA_ConfAccp_MetaData	Parameter details to controls service call during Inspection
5	GI_GICONF_REV_LOG_DTL	Reversal Log details
6	GI_GICPDREV_WRKREQ_CUSTPARTS	Reverse Main core additional information
7	GI_GICPD_WRKREQ_CUSTPARTS	Main core additional information
8	GI_GICR_RUpd_CnfRcpt_MetaData	Parameter details to controls service call during Receipt confirmation
9	GI_GIHDREV_RECEIPT_HDR	Reverse Receipt header details
10	GI_GIHD_RECEIPT_HDR	Receipt header details
11	GI_GIINSPRT_STATEDEFN_DTL	GI Inspect part state definition details
12	GI_GIINSREV_CHKLIST_ATTR_INFO	Reverse Inspection checklist details
13	GI_GIINS_CHKLIST_ATTR_INFO	Inspection checklist details
14	GI_GIMGR_STATEDEFN_DTL	GI State migration details
15	GI_GIMP_MvPrt_MetaData	Parameter details to controls service call during Movement
16	GI_GIMVREV_PART_MOVINFO	Reverse Movement details
17	GI_GIMV_PART_MOVINFO	Movement details
18	GI_GIOWN_COND_LOG_DTL	Reverse conditional LOG
19	GI_GIPDREV_PART_DTL	Reverse Part level details
20	GI_GIPD_PART_DTL	Part level details
21	GI_GIPRM_PARAM_DTL	Parameter description details
22	GI_GIPRT_STATUS_MSTR	GI Status description details
23	GI_GIQPH_QUAR_PARTS_HIS	Quarentined parts history
24	GI_GIQPREV_QUAR_PARTS	Reverse Quarentined parts information
25	GI_GIQP_QUAR_PARTS	Quarentined parts latest information
26	GI_GIRR_MIGRATION_DTL	GI RR migration details
27	GI_GISLDREV_SRL_LOT_DTL	Reverse Serial and lot details
28	GI_GISLD_SRL_LOT_DTL	Serial and lot details
29	GI_GISUPLMREV_SUPPLM_INFO	Reverse Supplimentary details either part or document level
30	GI_GISUPLM_SUPPLM_INFO	Supplimentary details eother part or document level
31	GI_GITCDCACA_CONFACCP_TCD_DTL	Confirm acceptance TCD details
32	GI_GITCDCAREV_CONFACCP_TCD_DTL	Reverse Apportioned level of add to stock TCDs defined in ref document
33	GI_GITCDCA_CONFACCP_TCD_DTL	Apportioned level of add to stock TCDs defined in ref document
34	GI_GITCDCRREV_CONFRCPT_TCD_DTL	Reverse Inherited TCD details for all type from reference document
35	GI_GITCDCR_CONFRCPT_TCD_DTL	Inherited TCD details for all type from reference document

Table Name :	GI_GIACCA_CostAmend_info
Comment :	Table to store GI cost amendment information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	GI_GIACREV_ACCP_INFO
Comment :	Table to store Reverse Inspection details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIACREV_REMARKS	udd_remarks	varchar(255)	Yes	This field is to capture the remarks	No

Table Name :	GI_GIAC_ACCP_INFO
Comment :	Inspection details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIAC_UNIQUE_ID	udd_seqno	int(4)	No	Unique id will be generated for each line	No
GIAC_RCPT_OU	udd_ctxt_ouinstance	int(4)	No	Receipt OU instance	No
GIAC_RCPT_NO	udd_documentno	varchar(40)	No	Receipt Document Number	No
GIAC_RCPT_TYPE	udd_designparamcode	varchar(5)	Yes	Receipt type (RP-Regular Purchase;CGR - Customer Goods Receipt)	No
GIAC_RCPT_LINE_NO	udd_lineno	int(4)	No	Receipt Line Number	No
GIAC_SRLLOT_LINENO	udd_lineno	int(4)	No	Serial Lot Line Number	No
GIAC_ACCP_LINENO	udd_lineno	int(4)	Yes	Acceptance Line Number	No
GIAC_ACCP_LINESTATUS	udd_designparamcode	varchar(5)	Yes	Acceptance Line Status(A - Accepted ; R - Received ; RJ - Rejected	No
GIAC_RCVD_PARTOU	udd_ctxt_ouinstance	int(4)	Yes	Received Part OU instance	No
GIAC_RCVD_PARTNO	udd_partno	varchar(40)	No	Received Part Number	No
GIAC_ISS_PARTOU	udd_ctxt_ouinstance	int(4)	Yes	Issued Part OU instance	No
GIAC_ISS_PARTNO	udd_partno	varchar(40)	Yes	Issued Part Number	No
GIAC_ISS_MFRSRLNO	UDD_SERIALNO	varchar(40)	Yes	Issued Manufacturer Serial Number	No
GIAC_RCVD_MFRSRLNO	UDD_SERIALNO	varchar(40)	Yes	Received Manufacturer Serial Number	No
GIAC_ISS_MFRLOTNO	udd_lotno	varchar(18)	Yes	Issued manufacturer lot no	No
GIAC_RCVD_MFRLOTNO	udd_lotno	varchar(18)	Yes	Received manufacturer Lot Number	No
GIAC_ISS_INT_SRLNO	UDD_SERIALNO	varchar(40)	Yes	Issued Internal Serial Number	No
GIAC_RCVD_INT_SRLNO	UDD_SERIALNO	varchar(40)	Yes	Received Internal Serial Number	No
GIAC_ISS_INT_LOTNO	udd_lotno	varchar(18)	Yes	Issued Internal Lot Number	No
GIAC_RCVD_INT_LOTNO	udd_lotno	varchar(18)	Yes	Received Internal Lot Number	No
GIAC_ACCP_QTY	udd_quantity	numeric(13)	Yes	Accepted Quantity	No
GIAC_UOM	udd_uom	varchar(15)	Yes	The unit of measurement mentioned in the Ref. Document used to procure the part	No
GIAC_PEND_INSP_QTY	udd_quantity	numeric(13)	Yes	Pending Inspection Quantity	No
GIAC_HAZMAT_FLAG	UDD_BIT	bit(1)	Yes	To indicate part is a hazardous part	No
GIAC_INSP_REQ_FLAG	UDD_BIT	bit(1)	No	Indicates whether inspection is required or not for the part.1 - if the part requires inspection, and 0 - if the part does not require inspection	No
GIAC_STK_FLAG	UDD_BIT	bit(1)	No	If the part is a non-stockable part(1 - If part is stockable,0 - If part is non-stockable)	No
GIAC_CONDITION	udd_designparamcode	varchar(5)	Yes	Received Part Condition(N -New, S - Serviceable, U - UnServiceable, O - Overhauled)	No
GIAC_OPERATOR_NO	udd_documentno	varchar(40)	Yes	Airline Operator Number	No
GIAC_PRT_SRL_CHANGE	udd_flag	varchar(25)	Yes	Part Serial Change	No
GIAC_REC_UPDATE	udd_flag	varchar(25)	Yes	Record Update(Not Applicable,Override,Verified)	No
GIAC_COMMENTS	udd_txt2000	varchar(2000)	Yes	Remarks entered by the user who accepted the part	No
GIAC_QUAR_QTY	udd_quantity	numeric(13)	Yes	Quarantine Quantity	No
GIAC_QUAR_COMMENTS	udd_txt2000	varchar(2000)	Yes	Any remarks specified by the warehouse clerk during quarentine	No
GIAC_QUAR_RSN	udd_flag	varchar(25)	Yes	Reason for quarantine	No
GIAC_QUAR_STATUS	udd_desc40	varchar(40)	Yes	Quarantine Status	No
GIAC_RES_RESP	udd_desc40	varchar(40)	Yes	Resolution Responsibility	No
GIAC_RES_COMMENTS	udd_txt2000	varchar(2000)	Yes	Resolution Comments	No
GIAC_QUAR_AREA	udd_desc40	varchar(40)	Yes	Quarantine Area	No
GIAC_REJ_QTY	udd_quantity	numeric(13)	Yes	Rejected Quantity	No
GIAC_REJ_REASON	udd_flag	varchar(25)	Yes	Rejected Reason	No
GIAC_CERT_TYPE	udd_flag	varchar(25)	Yes	Certificate Type	No
GIAC_CERT_NO	udd_desc40	varchar(40)	Yes	Certificate Number	No
GIAC_CERT_DATE	udd_datetime	varchar(30)	Yes	Certificate Date	No
GIAC_CERT_SUPPNO	udd_vendorcode	varchar(45)	Yes	Certificate supplier number	No
GIAC_EXPRY_DATE	udd_datetime	varchar(30)	Yes	Expiry Date	No
GIAC_SHELFLIFE_CHK	udd_flag	varchar(25)	Yes	Shelf life check(Enforce,Override)	No
GIAC_DEVIATED_PART	UDD_BIT	bit(1)	Yes	the part received is deviated from maintenance process it should have complied (1-Yes;0-No)	No
GIAC_DEVIATED_COMMENTS	UDD_Comments	char(256)	Yes	Remarks pertaining to deviated parts	No
GIAC_ISS_COMPOU	udd_ctxt_ouinstance	int(4)	Yes	Issued component ou applicable for RR	No
GIAC_ISS_COMPID	udd_componentid	varchar(90)	Yes	Issued component id applicable for RR	No
GIAC_RECV_COMPOU	udd_ctxt_ouinstance	int(4)	Yes	Received component ou	No
GIAC_RECV_COMPID	udd_componentid	varchar(90)	Yes	received component id	No
GIAC_COST	udd_cost	numeric(13)	Yes	for POGR, Derive the cost from PO for entire order qty and update in GI. Not applicable for RORR	No
GIAC_COSTPER	udd_amount	numeric(13)	Yes	for POGR, Derive the cost per from PO for entire order qty and update in GI. Its not applicable for RORR	No
GIAC_ACCT_AMT	udd_amount	numeric(13)	Yes	for POGR , cost divided by cost per multiply with accepted quantity. For RORR Maincore - addtostock scenerio, Exchange fee plus repair cost plus non returnable cost plus maincore cost. For Maincore - expense off scenerio, Main core cost and For	No
GIAC_ACCT_ATS_TCDAMT	udd_amount	numeric(13)	Yes	Accepted TCD Amount	No
GIAC_TRANAMT	udd_amount	numeric(13)	Yes	for POGR, Applicable only for exchange PO .Derive update the cost based hierarchy set in the set option. For RORR, Maincore cost plus Returnable cost plus non returnable	No
GIAC_GICOST_ERATE	udd_rate	numeric(13)	Yes	Exchange rate as defined in ERATE master	No
GIAC_ACCP_BY	udd_ctxt_user	varchar(30)	Yes	The user who accepted the receipt	No
GIAC_ACCP_DATE	udd_datetime	varchar(30)	Yes	The date on which receipt is accepted	No
GIAC_PROCESS_FLAG	udd_designparamcode	varchar(5)	Yes	Process Flag which is used internally	No
GIAC_TIMESTAMP	udd_timestamp	int(4)	Yes	Timestamp which is internally used to check if user works on the latest record set	No
GIAC_FILENAME	UDD_Comments	char(256)	Yes	File name	No
GIAC_ACCT_AMT_BASE	udd_amount	numeric(13)	Yes	Account base amount	No
GIAC_CERTIFICATE_AUNO	udd_desc40	varchar(40)	Yes	CERTIFICATE authorize number	No
GIAC_CHANGE_BASIS	udd_designparamcode	varchar(5)	Yes	Change basis	No
GIAC_CHANGE_TYPE	udd_designparamcode	varchar(5)	Yes	Change type applicable for RR	No
GIAC_COMPLIANCE_UPD_FLAG	udd_chkflag	varchar(1)	Yes	compliance flag	No
GIAC_Core_value	udd_amount	numeric(13)	Yes	Core values	No
GIAC_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	Created by	No
GIAC_CREATEDDATE	udd_datetime	varchar(30)	Yes	Created Date	No
GIAC_EXREF_PARTCOST	udd_cost	numeric(13)	Yes	Exchange reference Part cost	No
GIAC_INSP_AUTO_MOVE	udd_seqno	int(4)	Yes	inspection auto move	No
GIAC_ISS_PARTACCGRP	udd_customeraccountgroup	varchar(20)	Yes	Part account group	No
GIAC_MAINT_TYPE	udd_designparamcode	varchar(5)	Yes	Manitance type	No
GIAC_MFR_DATE	udd_datetime	varchar(30)	Yes	Manufacture Date	No
GIAC_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	Modified By	No
GIAC_MODIFIEDDATE	udd_datetime	varchar(30)	Yes	Modified Date	No
GIAC_RR_BER_COST	udd_amount	numeric(13)	Yes	Not applicable for POGR.Derived from RO for the accepted qty	No
GIAC_RR_EXCH_FEE	udd_amount	numeric(13)	Yes	Not applicable for pogr. Derived from RO for the accepted qty	No
GIAC_RR_MNCORE_COST	udd_amount	numeric(13)	Yes	Not applicable for POGR. derived from RO for the accepted quantity	No
GIAC_RR_NRTN_COST	udd_amount	numeric(13)	Yes	Not applicable for POGR. derived from RO for the accepted qty	No
GIAC_RR_REP_COST	udd_amount	numeric(13)	Yes	Not applicable for POGR. derived from RO for the accepted qty.	No
GIAC_RR_RTN_COST	udd_amount	numeric(13)	Yes	Derive from issue (returnable spare cost) for the accepted qty. Not applicable for POGR	No
GIAC_variable_value	udd_amount	numeric(13)	Yes	variable values	No
GIAC_CONF_INST_ID	udd_seqno	int(4)	Yes	Table to hold data of Confirm inspection ID	No
GIAC_REFDOC_AMENDNO	udd_seqno	int(4)	Yes	Reciept Reference document amendment number	No
GIAC_REFDOC_QUOTEID	udd_seqno	int(4)	Yes	Reciept Reference document Quote ID	No
GIAC_REMARKS	udd_remarks	varchar(255)	Yes	Table to hold inspection Remarks	No
GIAC_REV_INST_ID	udd_seqno	int(4)	Yes	Table to hold data of Reverse inspection ID	No

Table Name :	GI_GICA_ConfAccp_MetaData
Comment :	Parameter details to controls service call during Inspection

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GICA_Task	udd_flag	varchar(25)	Yes	Task Name (CONACCP -Confirm Acceptance)	No
GICA_Rcpt_Type	udd_designparamcode	varchar(5)	Yes	Receipt type (RP-Regular Purchase;CGR - Customer Goods Receipt)	No
GICA_Refdoc_Type	udd_designparamcode	varchar(5)	Yes	Reference document type(PO-Purchase Order;CO-Customer order;RS-Release Slip;OTH-Others which is applicable for direct CGR)	No
GICA_MatType	udd_designparamcode	varchar(5)	Yes	Material type (RP-Regular,CGR - Regular,Main Core)	No
GICA_Part_Type	udd_designparamcode	varchar(5)	Yes	Part Type (CM - Component part ; NCM -Non component part ; NA - Not Applicable )	No
GICA_Part_ExpType	udd_designparamcode	varchar(5)	Yes	Part Expense Type as defined In Part Admin	No
GICA_Tcd_Appor	udd_designparamcode	varchar(5)	Yes	TCD Apportion Flag ((Y -Yes ; N -No)	No
GICA_CompIdGen	udd_designparamcode	varchar(5)	Yes	Component ID Generation flag (Y - Yes ; N -No )	No
GICA_Costing	udd_designparamcode	varchar(5)	Yes	Costing Flag (Y - Yes ; N -No )	No
GICA_RefdocUpd	udd_designparamcode	varchar(5)	Yes	Reference document updation flag (Y - Yes ; N -No )	No
GICA_DrillDown	udd_designparamcode	varchar(5)	Yes	Drilldown Flag (Y - Yes ; N -No )	No
GICA_FinPost	udd_designparamcode	varchar(5)	Yes	Finance Posting Flag (Y - Yes ; N -No )	No
GICA_AplanUpd	udd_designparamcode	varchar(5)	Yes	Aplan Updation Flag ((Y -Yes ; N -No)	No
GICA_COGen	udd_designparamcode	varchar(5)	Yes	Customer Order Generation Flag (Y -Yes ; N -No)	No
GICA_VenRtngUpd	udd_designparamcode	varchar(5)	Yes	Vendor Rating Flag (Y - Yes ; N -No ))	No
REPLICATION_KEY	_Bigint_8	Bigint(8)	No	Unique id will be generated for each line	Yes
GICA_Adl_Validation	udd_designparamcode	varchar(5)	Yes	Additional Validation Check ((Y -Yes )	No

Table Name :	GI_GICONF_REV_LOG_DTL
Comment :	Reversal Log details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	GI_GICPDREV_WRKREQ_CUSTPARTS
Comment :	Reverse Main core additional information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	GI_GICPD_WRKREQ_CUSTPARTS
Comment :	Main core additional information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GICPD_UNIQUEID	udd_seqno	int(4)	No	Unique id will be generated for each line	Yes
GICPD_RCPT_NO	udd_documentno	varchar(40)	No	Receipt Document Number	No
GICPD_RCPT_TYPE	udd_designparamcode	varchar(5)	No	Receipt type (RP-Regular Purchase;CGR - Customer Goods Receipt)	Yes
GICPD_RCPT_OU	udd_ctxt_ouinstance	int(4)	No	Receipt OU instance	No
GICPD_PART_LINENO	udd_lineno	int(4)	Yes	Receipt Line Number	No
GICPD_SRLLOT_LINENO	udd_lineno	int(4)	Yes	Serial Lot Line Number	No
GICPD_RCVD_PARTOU	udd_ctxt_ouinstance	int(4)	Yes	Received Part OU instance	No
GICPD_RCVD_PARTNO	udd_partno	varchar(40)	No	Received Part Number	No
GICPD_REMD_ACCREG	udd_desc40	varchar(40)	Yes	Removed Aircraft Registration Number	No
GICPD_REMD_MFRPART	udd_partno	varchar(40)	Yes	Removed Manufacturer Part Number	No
GICPD_REMD_SRL	UDD_SERIALNO	varchar(40)	Yes	Removed Serial No	No
GICPD_REMD_DATETIME	udd_datetime	varchar(30)	Yes	Removed Date Time	No
GICPD_REML_REASON	udd_reason	varchar(256)	Yes	Removal Reason	No
GICPD_WORK_REQUESTED	udd_notes	varchar(2000)	Yes	Work requested Details	No
GICPD_REQ_MAINT_TYPE	udd_flag	varchar(25)	Yes	Repair process code as defined in Logistics Common Master	No
GICPD_MOD_INSTRUCTIONS	udd_notes	varchar(2000)	Yes	Modified Instructions	No
GICPD_CUST_PONO	udd_documentno	varchar(40)	Yes	Customer Purchase Order Number	No
GICPD_CUST_REQDDATE	udd_datetime	varchar(30)	Yes	The date on which the customer has requested the part after repair	No
GICPD_CUST_PRIORITY	udd_flag	varchar(25)	Yes	The order priority of Customer Order #	No
GICPD_RETURN_DISPSN	udd_desc40	varchar(40)	Yes	Part final destination as defined in Logistics Common Master	No
GICPD_TAT_STARTDATE	udd_datetime	varchar(30)	Yes	The starting date of the turnaround time for the part to be repaired	No
GICPD_WAR_REQUESTED	udd_seqno	int(4)	Yes	Warrenty Requested	No
GICPD_WAR_DETAILS	udd_notes	varchar(2000)	Yes	Warranty Details	No
GICPD_RMA_DETAILS	udd_flag	varchar(25)	Yes	Return Material Authorization Details	No
GICPD_CUST_MNT_REFERENCES	udd_notes	varchar(2000)	Yes	Customer Maintanance Reference Details	No
GICPD_JOBCARD_REFERENCES	udd_notes	varchar(2000)	Yes	Job Card References	No
GICPD_DISCREPANCY	udd_notes	varchar(2000)	Yes	Discrepancy Details	No
GICPD_CONTRACT	udd_documentno	varchar(40)	Yes	Contract Number	No
GICPD_CUST_ORDERNO	udd_documentno	varchar(40)	Yes	Customer order Number	No
GICPD_SWO	udd_documentno	varchar(40)	Yes	Shop work order Number	No
GICPD_COMMENTS	udd_notes	varchar(2000)	Yes	Any remarks pertaining to the part received for repair	No
GICPD_QUARANTINED	UDD_BIT	bit(1)	No	To indicate the part serial - Lot is Quarentined(1-Yes;0-No)	No
GICPD_QUAR_RES	udd_quickcode	varchar(25)	Yes	Reason for quarantine	No
GICPD_QUAR_COMMENTS	udd_notes	varchar(2000)	Yes	Any remarks pertaining to quarantine	No
GICPD_QUAR_STATUS	udd_desc40	varchar(40)	Yes	Quarantine Status	No
GICPD_RES_RESP	udd_desc40	varchar(40)	Yes	Resolution Responsibility	No
GICPD_RES_COMMENTS	udd_notes	varchar(2000)	Yes	Resolution Comments	No
GICPD_QUAR_AREA	udd_desc40	varchar(40)	Yes	Quarantine Area	No
GICPD_REPAIR_ORDERNO	udd_desc40	varchar(40)	Yes	Repair Order Number	No
GICPD_CONT_REV_NO	udd_seqno	int(4)	Yes	Contract Revision Number	No
GICPD_CONT_EFF_CODE	udd_documentno	varchar(40)	Yes	Contract Effectivity Code	No
GICPD_CONT_EFF_LINE_NO	udd_lineno	int(4)	Yes	Contract Effectivity Line Number	No
GICPD_EXECUTION_FLAG	udd_designparamcode	varchar(5)	Yes	contract s work execution facility type (INT - Internal /EXT - External)	No
GICPD_CREATEDDATE	udd_datetime	varchar(30)	Yes	The date on which receipt is created	No
GICPD_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	The user who created the receipt	No
GICPD_MODIFIEDDATE	udd_datetime	varchar(30)	Yes	The latest date on which receipt is modified	No
GICPD_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	The user who modified the receipt	No
GICPD_REMD_PARTNO	udd_partno	varchar(40)	Yes	Removed Part Number	No
GICPD_MFRNO	udd_vendorcode	varchar(45)	Yes	Manufacturer Number	No
GICPD_CO_ADV_FLAG	udd_designparamcode	varchar(5)	Yes	If the flag is AdvE - The part serial or lot combination is core due against the fetched customer order	No
GICPD_CO_LINE_NO	udd_seqno	int(4)	Yes	Customer order line number	No

Table Name :	GI_GICR_RUpd_CnfRcpt_MetaData
Comment :	Parameter details to controls service call during Receipt confirmation

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GICR_Task	udd_flag	varchar(25)	Yes	Task Name (CONFRCPT - Confirm Receipt ; RECUPD -Record Update)	No
GICR_Rcpt_Type	udd_designparamcode	varchar(5)	Yes	Receipt type (RP-Regular Purchase;CGR - Customer Goods Receipt)	No
GICR_Refdoc_Type	udd_designparamcode	varchar(5)	Yes	Reference document type(PO-Purchase Order;CO-Customer order;RS-Release Slip;OTH-Others which is applicable for direct CGR)	No
GICR_Part_Type	udd_designparamcode	varchar(5)	Yes	Part Type (CM - Component part ; NCM -Non component part ; NA - Not Applicable )	No
GICR_TcdCalc	udd_designparamcode	varchar(5)	Yes	TCD calculation flag (Y - Yes ; N -No )	No
GICR_CompIdGen	udd_designparamcode	varchar(5)	Yes	Component ID Generation flag (Y - Yes ; N -No )	No
GICR_Costing	udd_designparamcode	varchar(5)	Yes	Costing Flag (Y - Yes ; N -No )	No
GICR_RefdocUpd	udd_designparamcode	varchar(5)	Yes	Reference document updation flag (Y - Yes ; N -No )	No
GICR_DrillDown	udd_designparamcode	varchar(5)	Yes	Drilldown Flag (Y - Yes ; N -No )	No
GICR_FinPost	udd_designparamcode	varchar(5)	Yes	Finance Posting Flag (Y - Yes ; N -No )	No
GICR_VenRtngUpd	udd_designparamcode	varchar(5)	Yes	Vendor Rating Flag (Y - Yes ; N -No ))	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique id will be generated for each line	Yes

Table Name :	GI_GIHDREV_RECEIPT_HDR
Comment :	Reverse Receipt header details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	GI_GIHD_RECEIPT_HDR
Comment :	Receipt header details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIHD_UNIQUE_ID	udd_seqno	int(4)	No	Unique id will be generated for each receipt	Yes
GIHD_RCPT_OU	udd_ctxt_ouinstance	int(4)	No	Receipt OU instance	No
GIHD_RCPT_NO	udd_documentno	varchar(40)	No	Receipt Document Number	No
GIHD_RCPT_TYPE	udd_designparamcode	varchar(5)	No	Receipt type (RP-Regular Purchase;CGR - Customer Goods Receipt)	Yes
GIHD_RCPT_DOCSTATUS	udd_designparamcode	varchar(5)	Yes	Receipt document status(D- Draft F- Fresh RPI- Received Pending Inspection APM- Accepted Pending Movement RPR - Received Pending Return CA- Canceled CMP-Completed)	No
GIHD_RCPT_DATE	udd_datetime	varchar(30)	No	Receipt date	No
GIHD_WAY_BILLNO	udd_refdocno	varchar(40)	Yes	Way bill no	No
GIHD_WAY_BILLDATE	udd_datetime	varchar(30)	Yes	Way bill date	No
GIHD_RCPT_PRIORITY	udd_flag	varchar(25)	Yes	Receipt priority	No
GIHD_PACKSLIPNO	udd_documentno	varchar(40)	Yes	Pack slip number	No
GIHD_PACKSLIPDATE	udd_datetime	varchar(30)	Yes	Pack slip date	No
GIHD_RECV_LOC	udd_desc40	varchar(40)	Yes	Receiving location	No
GIHD_RECV_WH	udd_warehouse	varchar(10)	Yes	Receiving warehouse	No
GIHD_RECV_AREA	udd_desc40	varchar(40)	Yes	Receiving area	No
GIHD_SUPOU	udd_ctxt_ouinstance	int(4)	Yes	Supplier OU instance	No
GIHD_SUPNO	udd_vendorcode	varchar(45)	Yes	supplier number	No
GIHD_CUSTOU	udd_ctxt_ouinstance	int(4)	Yes	Customer OU instance	No
GIHD_CUSTNO	udd_vendorcode	varchar(45)	Yes	Customer number	No
GIHD_SUPNAME	udd_txt150	varchar(150)	Yes	Supplier name	No
GIHD_REFDOC_OU	udd_ctxt_ouinstance	int(4)	Yes	Reference document OU instance	No
GIHD_REFDOC_NO	udd_refdocno	varchar(40)	Yes	Reference document no	No
GIHD_REFDOC_DATE	udd_datetime	varchar(30)	Yes	Reference document date	No
GIHD_REFDOC_TYPE	udd_designparamcode	varchar(5)	Yes	Reference document type(PO-Purchase Order;CO-Customer order;RS-Release Slip;OTH-Others which is applicable for direct CGR)	No
GIHD_REFDOC_SUBTYPE	udd_designparamcode	varchar(5)	Yes	Reference document sub type(PO - all applicable PO types;RS -all applicable RS type; CO - all applicable shop job types; OTH - Null)	No
GIHD_REFDOC_AMENDNO	udd_seqno	int(4)	Yes	Reference document amendment no	No
GIHD_REFDOC_QUOTEID	udd_seqno	int(4)	Yes	Reference document quotation id applicable for RO	No
GIHD_NO_OF_PACKS	udd_quantity	numeric(13)	Yes	Number of packs	No
GIHD_CONSIGN_WEIGHT	udd_flag	varchar(25)	Yes	Consignment weight	No
GIHD_CONSIGN_COMMENTS	udd_notes	varchar(2000)	Yes	Consignment comments	No
GIHD_RCVDBY	udd_ctxt_user	varchar(30)	Yes	Received by	No
GIHD_GATE_PASS_NO	udd_refdocno	varchar(40)	Yes	Gate pass number	No
GIHD_GATE_PASS_DATE	udd_datetime	varchar(30)	Yes	Gate pass date	No
GIHD_RCPTCATEGORY	udd_quickcodes	varchar(25)	Yes	Receipt category as defined in quick code	No
GIHD_USERSTATUS	udd_quickcodes	varchar(25)	Yes	User status a defined in Quick code	No
GIHD_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
GIHD_TIMESTAMP	udd_timestamp	int(4)	Yes	Timestamp which is internally used to check if user works on the latest record set	No
GIHD_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	The user who created the receipt	No
GIHD_CREATEDDATE	udd_datetime	varchar(30)	Yes	The date on which receipt is created	No
GIHD_MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	The user who modified the receipt	No
GIHD_MODIFIEDDATE	udd_datetime	varchar(30)	Yes	The latest date on which receipt is modified	No
GIHD_INVALID_REFDOC_FLAG	udd_designparamcode	varchar(5)	Yes	This column will have the values as Y or N. If the GI has been created against an invalid reference document then this column will have the value as Y else N	No
GIHD_ALLPARTS_REJECTED	udd_designparamcode	varchar(5)	Yes	part rejection upadate	No
GIHD_BaseCurrency	udd_currency	varchar(20)	Yes	Base currency	No
GIHD_CANCELLATION_COMMENTS	udd_txt255	varchar(255)	Yes	cancellation comments	No
GIHD_INSP_AUTO_MOVE	udd_seqno	int(4)	Yes	inspection auto move	No
GIHD_MGR_AUTO_INSP	udd_seqno	int(4)	Yes	AUTO inspect migration	No
GIHD_MGR_AUTO_MOVE	udd_seqno	int(4)	Yes	Move parts migration	No
GIHD_MIGRATED_RR	udd_designparamcode	varchar(5)	Yes	migrated RR details	No
GIHD_Pur_Oucode	udd_ctxt_ouinstance	int(4)	Yes	purchase OU	No
GIHD_Pur_TradingPartner	udd_vendorcode	varchar(45)	Yes	Trading Partner code	No
GIHD_Purchase_For	udd_designparamcode	varchar(5)	Yes	Purchase for trading Partner info wheather supplier or self	No

Table Name :	GI_GIINSPRT_STATEDEFN_DTL
Comment :	GI Inspect part state definition details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIINSPRT_CALLING_TASK	udd_desc40	varchar(40)	Yes	Column hold value of GI inspect part Calling task	No
GIINSPRT_GUIDEDNAV	udd_designparamcode	varchar(5)	Yes	Column hold value of GI inspect part Guid	No
GIINSPRT_MOVRIGHTS	udd_designparamcode	varchar(5)	Yes	Column hold value of GI inspect part Move rights	No
GIINSPRT_RCPT_TYPE	udd_flag	varchar(25)	Yes	Column hold value of GI inspect part recepit Type	No
GIINSPRT_RCPT_STATUS	udd_flag	varchar(25)	Yes	Column hold value of GI inspect part recepit status	No
GIINSPRT_INSPREC_PEND	udd_designparamcode	varchar(5)	Yes	Column hold value of GI inspect part pending status	No
GIINSPRT_PRTLVL_QRTN	udd_designparamcode	varchar(5)	Yes	Column hold value of GI inspect part level quarantine flag	No
GIINSPRT_SUPDTLS_PEND	udd_designparamcode	varchar(5)	Yes	Column hold value of GI inspect part supplementary details pending means have to enter it in inspect parts screen	No
GIINSPRT_INSPCHKLIST_PEND	udd_designparamcode	varchar(5)	Yes	Column hold value of GI inspect part inspection pending	No
GIINSPRT_SHOWCHNG_BASIS	udd_designparamcode	varchar(5)	Yes	Column hold value of GI inspect part change Basis	No
GIINSPRT_STATEID	udd_desc40	varchar(40)	Yes	Column hold value of GI inspect part State id	No

Table Name :	GI_GIINSREV_CHKLIST_ATTR_INFO
Comment :	Reverse Inspection checklist details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	GI_GIINS_CHKLIST_ATTR_INFO
Comment :	Inspection checklist details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIINS_UNIQUEID	udd_seqno	int(4)	No	Unique id will be generated for each line	Yes
GIINS_RCPT_NO	udd_documentno	varchar(40)	No	Receipt Document Number	No
GIINS_RCPT_OU	udd_ctxt_ouinstance	int(4)	No	Receipt OU instance	No
GIINS_PARTOU	udd_ctxt_ouinstance	int(4)	Yes	Received Part OU instance	No
GIINS_PARTNO	udd_partno	varchar(40)	Yes	Received Part Number	No
GIINS_RCPT_TYPE	udd_designparamcode	varchar(5)	No	Receipt type (RP-Regular Purchase;CGR - Customer Goods Receipt)	Yes
GIINS_CHKL_ATR_CODE	udd_desc40	varchar(40)	Yes	Checklist attibute code as defined in quick code	No
GIINS_CHKL_ATR_DESC	udd_notes	varchar(2000)	Yes	Checklist attibute description as defined in quick code	No
GIINS_MAND	UDD_BIT	bit(1)	Yes	Mandatory check (1 - yes; 0 - no)	No
GIINS_VERIFIED	UDD_BIT	bit(1)	No	Indicates whether checklists are verified or not (1 - Verified ; 0 - not verified)	No
GIINS_COMMENTS	udd_notes	varchar(2000)	Yes	Remarks entered by the user who verified inspection list	No
GIINS_ATTR_TYPE	udd_flag	varchar(25)	Yes	Attribute type	No
GIINS_MINVAL_EXPEC	udd_amount	numeric(13)	Yes	Expected Minimum value	No
GIINS_MAXVAL_EXPEC	udd_amount	numeric(13)	Yes	Expected Maximum value	No
GIINS_STDVAL_EXPEC	udd_amount	numeric(13)	Yes	Expected Standard Value	No
GIINS_QUALVAL_EXPEC	udd_txt80	varchar(80)	Yes	Expected Qualitative Value	No
GIINS_AVGMIN_VAL	udd_amount	numeric(13)	Yes	Average Minimum Value	No
GIINS_AVGMAX_VAL	udd_amount	numeric(13)	Yes	Average Maximum Value	No
GIINS_AVGVAL	udd_amount	numeric(13)	Yes	Average Value	No
GIINS_QUALVAL	udd_txt80	varchar(80)	Yes	Qualitative Value	No
GIINS_APPLICABILITY_FLAG	udd_designparamcode	varchar(5)	Yes	Applicability Flag (Doc - Document ; Part - Part)	No
GIINS_LOTNO	udd_lotno	varchar(18)	Yes	This field is to capture the LOT number	No
GIINS_SERIALNO	UDD_SERIALNO	varchar(40)	Yes	This field is to capture the Serial Number	No

Table Name :	GI_GIMGR_STATEDEFN_DTL
Comment :	GI State migration details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIMGR_CALLING_TASK	udd_desc40	varchar(40)	Yes	Column hold value of GI Migration Calling task	No
GIMGR_TRANMODE	udd_flag	varchar(25)	Yes	Column hold value of GI Migration transition mode	No
GIMGR_GUIDEDNAV	udd_designparamcode	varchar(5)	Yes	Column hold value of GI Migration GUID	No
GIMGR_INSPRIGHTS	udd_designparamcode	varchar(5)	Yes	Column hold value of GI Migration Inspection rights	No
GIMGR_RCPT_TYPE	udd_flag	varchar(25)	Yes	Column hold value of GI Migration Recepit Type	No
GIMGR_RCPT_STATUS	udd_flag	varchar(25)	Yes	Column hold value of GI Migration recepit status	No
GIMGR_SHOWMFRPART	udd_flag	varchar(25)	Yes	Column hold value of GI Migration MFR part	No
GIMGR_SHOWCHNG_BASIS	udd_flag	varchar(25)	Yes	Column hold value of GI Migration change basis	No
GIMGR_PRTLVL_QRTN	udd_designparamcode	varchar(5)	Yes	Column hold value of GI Migration part level quarantine flag	No
GIMGR_SRLLVL_QRTN	udd_designparamcode	varchar(5)	Yes	Column hold value of GI Migration serial level quarantine flag	No
GIMGR_WORKREQLVL_QRTN	udd_designparamcode	varchar(5)	Yes	Column hold value of GI Migration Workrequest level quarantine flag	No
GIMGR_PEND_SUPDTLS	udd_designparamcode	varchar(5)	Yes	Column hold value of GI Migration part supplementary details pending means have to enter it in inspect parts screen	No
GIMGR_MAINCOREEXIST	udd_flag	varchar(25)	Yes	Column hold value of GI Migration Main core existance check	No
GIMGR_STATEID	udd_desc40	varchar(40)	Yes	Column hold value of GI Migration State id	No

Table Name :	GI_GIMP_MvPrt_MetaData
Comment :	Parameter details to controls service call during Movement

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIMP_Task	udd_flag	varchar(25)	Yes	Task Name (MOVPARTS)	No
GIMP_Rcpt_Type	udd_designparamcode	varchar(5)	Yes	Receipt type (RP-Regular Purchase;CGR - Customer Goods Receipt)	No
GIMP_Refdoc_Type	udd_designparamcode	varchar(5)	Yes	Reference document type(PO-Purchase Order;CO-Customer order;RS-Release Slip;OTH-Others which is applicable for direct CGR)	No
GIMP_MatType	udd_designparamcode	varchar(5)	Yes	Material type (RP-Regular,CGR - Regular,Main Core)	No
GIMP_MovType	udd_flag	varchar(25)	Yes	Movement Type (ALLOC - Allocation ; BIN - Binning ; EXTREP - External Repair ;NA - Not Applicable ; REP - Repair ;TRNSFRALLOC - Transfer Allocation ; TRNSFRREP - Transfer Repair )	No
GIMP_Costing	udd_designparamcode	varchar(5)	Yes	Costing Flag (Y - Yes ; N -No )	No
GIMP_RefdocUpd	udd_designparamcode	varchar(5)	Yes	Reference document updation flag (Y - Yes ; N -No )	No
GIMP_DrillDown	udd_designparamcode	varchar(5)	Yes	Drilldown Flag (Y - Yes ; N -No )	No
GIMP_FinPost	udd_designparamcode	varchar(5)	Yes	Finance Posting Flag (Y - Yes ; N -No )	No
GIMP_ExtStorAlloc	udd_designparamcode	varchar(5)	Yes	External Storage Allocation Flag (Y - Yes ; N -No )	No
GIMP_AutoROGen	udd_designparamcode	varchar(5)	Yes	Auto RO Generation Flag (Y - Yes ; N -No )	No
GIMP_SWOGen	udd_designparamcode	varchar(5)	Yes	SWO Generation Flag (Y - Yes ; N -No )	No
GIMP_Pegging	udd_designparamcode	varchar(5)	Yes	Receipt Pegging Flag (Y - Yes ; N -No )	No
GIMP_STTransfer	udd_designparamcode	varchar(5)	Yes	Stock Transfer Flag (Y - Yes ; N -No )	No
GIMP_AutoIssue	udd_designparamcode	varchar(5)	Yes	Auto Issue Flag (Y - Yes ; N -No )	No
GIMP_VenRtngUpd	udd_designparamcode	varchar(5)	Yes	Vendor Rating Flag (Y - Yes ; N -No ))	No
REPLICATION_KEY	_Bigint_8	Bigint(8)	No	Unique id will be generated for each line	Yes
GIMP_Adl_Validation	udd_designparamcode	varchar(5)	Yes	Additional Validation Check ((Y -Yes )	No

Table Name :	GI_GIMVREV_PART_MOVINFO
Comment :	Reverse Movement details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	GI_GIMV_PART_MOVINFO
Comment :	Movement details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIMV_UNIQUE_ID	udd_seqno	int(4)	No	Unique id will be generated for each line	Yes
GIMV_RCPT_OU	udd_ctxt_ouinstance	int(4)	No	Receipt OU instance	No
GIMV_RCPT_NO	udd_documentno	varchar(40)	No	Receipt Document Number	No
GIMV_RCPT_TYPE	udd_designparamcode	varchar(5)	No	Receipt type (RP-Regular Purchase;CGR - Customer Goods Receipt)	Yes
GIMV_RCPT_PARTOU	udd_ctxt_ouinstance	int(4)	Yes	Received Part OU instance	No
GIMV_RCPT_PARTNO	udd_partno	varchar(40)	No	Received Part Number	No
GIMV_RCPT_LINENO	udd_lineno	int(4)	Yes	Receipt Line Number	No
GIMV_SRLLOT_LINENO	udd_lineno	int(4)	Yes	Serial Lot Line Number	No
GIMV_ACCP_LINENO	udd_seqno	int(4)	Yes	Acceptance Line Number	No
GIMV_MOV_LINENO	udd_seqno	int(4)	Yes	Moved Line Number	No
GIMV_MOV_LINESTATUS	udd_designparamcode	varchar(5)	Yes	Moved Line Status (A - Accepted ; RJ - Rejected ; M - Moved	No
GIMV_MOVFLAG	udd_designparamcode	varchar(5)	Yes	Move Flag(MI - Movement Initiated , MNI - Movement Not Initiated, MVD -Moved)	No
GIMV_MOVEDQTY	udd_quantity	numeric(13)	Yes	Moved Quantity	No
GIMV_UOM	udd_uom	varchar(15)	Yes	The unit of measurement mentioned in the Ref. Document used to procure the part	No
GIMV_MVD_QTY_STKUOM	udd_quantity	numeric(13)	Yes	Moved quantity in stock unit of measurement	No
GIMV_PEND_MVDQTY	udd_quantity	numeric(13)	Yes	Pending Moved Quantity	No
GIMV_RCVD_MFRSRLNO	UDD_SERIALNO	varchar(40)	Yes	Received Manufacturer Serial Number	No
GIMV_RCVD_MFRLOTNO	udd_lotno	varchar(18)	Yes	Received Manufacturer Lot Number	No
GIMV_RCVD_INT_SRLNO	UDD_SERIALNO	varchar(40)	Yes	Received Internal Serial Number	No
GIMV_RCVD_INT_LOTNO	udd_lotno	varchar(18)	Yes	Received Internal Lot Number	No
GIMV_STOCKABLE_FLAG	UDD_BIT	bit(1)	No	If the part is a non-stockable part(1 - If part is stockable,0 - If part is non-stockable)	No
GIMV_HAZMAT_FLAG	UDD_BIT	bit(1)	No	To indicate part is a hazardous part	No
GIMV_OWNERSHIP	udd_designparamcode	varchar(5)	Yes	Ownership (SUP - Supplier, CUS - Customer, OWN - Owned)	No
GIMV_OWNINGAGENCY_OU	udd_ctxt_ouinstance	int(4)	Yes	Owning Agency Ou Instance	No
GIMV_OWNINGAGENCY	udd_vendorcode	varchar(45)	Yes	Owning Agency Number	No
GIMV_STKSTATUS	udd_partstatus	varchar(40)	Yes	Stock status mapped for the receipt type	No
GIMV_MVD_PARTCOND	udd_designparamcode	varchar(5)	Yes	Received Part Condition(N -New, S - Serviceable, U - UnServiceable, O - Overhauled)	No
GIMV_MOVETO	udd_flag	varchar(25)	Yes	Moved To	No
GIMV_WORKCENTER_OU	udd_ctxt_ouinstance	int(4)	Yes	Workcenter OU instance	No
GIMV_WORKCENTER_NO	udd_wccode	varchar(30)	Yes	Workcenter Number	No
GIMV_MVD_WHOU	udd_ctxt_ouinstance	int(4)	Yes	Moved Wharehouse OU Instance	No
GIMV_MVD_WHID	udd_warehouse	varchar(10)	Yes	Moved Wharehouse Number	No
GIMV_TRANS_WHID	udd_warehouse	varchar(10)	Yes	Transfer to Wharehouse Number	No
GIMV_MVD_ZONE	udd_zone	varchar(10)	Yes	Moved Zone	No
GIMV_MVD_BIN	udd_bin	varchar(10)	Yes	Moved Bin	No
GIMV_RCVD_COMPOU	udd_designparamcode	varchar(5)	Yes	Received component ou	No
GIMV_RCVD_COMPID	udd_wccode	varchar(30)	Yes	received component id	No
GIMV_COMMENTS	udd_notes	varchar(2000)	Yes	Remarks entered by the user who moved the part	No
GIMV_MOVEDBY	udd_ctxt_user	varchar(30)	Yes	The user who moved the receipt	No
GIMV_MVD_DATE	udd_datetime	varchar(30)	Yes	The date on which receipt is moved	No
GIMV_REFDOC_SCHID	udd_seqno	int(4)	Yes	Referrence document schedule id	No
GIMV_REFDOC_SCHSTATUS	udd_designparamcode	varchar(5)	Yes	Reference document schudule status	No
GIMV_PART_VALMETHOD	udd_designparamcode	varchar(5)	Yes	Part Value Method defined in Part Admin	No
GIMV_PARTCOST	udd_cost	numeric(13)	Yes	For POGR Non exchange PO , Moved qty multiply with (accepted amount * exchange rate) plus divided by accepted qty.For RORR, Moved qty multiply with ((accepted amount * exchange rate) plus ATS TCDamount divided by accepted qty	No
GIMV_PART_EXPTYPE	udd_designparamcode	varchar(5)	Yes	Part Expense Type defined in Part Admin	No
GIMV_PART_EXPOLICY	udd_designparamcode	varchar(5)	Yes	Part Expense Policy defined in Part Admin	No
GIMV_MOV_TYPE	udd_desc40	varchar(40)	Yes	Movement Type (Non-Stockable, Allocation, Binning, Rejection, Rejection-Return to Supplier, Rejection-Return to Customer, Rejection-Scrap, Repair, Ship to Customer, Transfer-Allocation, Transfer-Repair, External Repair	No
GIMV_MOVTO_AREA	udd_desc40	varchar(40)	Yes	Move To Area (Rejection Area, Scrap Area, Shipping Area)	No
GIMV_AREAID	udd_desc40	varchar(40)	Yes	Area ID Loaded for the corresponding Move to Area	No
GIMV_SMN_SEQNO	udd_seqno	int(4)	Yes	SMN Sequence No	No
GIMV_PROCESS_FLAG	udd_designparamcode	varchar(5)	Yes	Process Flag which is used internally	No
GIMV_MAT_REQUEST	udd_desc40	varchar(40)	Yes	Material Request Number	No
GIMV_STKTRN_NO	udd_desc40	varchar(40)	Yes	Stock Transfer Number	No
GIMV_TIMESTAMP	udd_timestamp	int(4)	Yes	Timestamp which is internally used to check if user works on the latest record set	No
GIMV_MAT_REQUEST_LINENO	udd_seqno	int(4)	Yes	Material Request Line Number	No
GIMV_ISSUE_NO	udd_desc40	varchar(40)	Yes	Issue Number	No
GIMV_PEND_MVDQTY_STKUOM	udd_quantity	numeric(13)	Yes	pending qty for movement in stock UOM	No
GIMV_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	CREATED BY	No
GIMV_WORKORDER_TYPE	udd_flag	varchar(25)	Yes	WORKORDER TYPE	No
GIMV_CREATEDDATE	udd_datetime	varchar(30)	Yes	CREATEDDATE	No
GIMV_EXREF_LINENO	udd_seqno	int(4)	Yes	line no	No
GIMV_EXREF_PARTCOST	udd_cost	numeric(13)	Yes	part cost	No
GIMV_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	modified by	No
GIMV_MODIFIEDDATE	udd_datetime	varchar(30)	Yes	modofied date	No
GIMV_TOSTK_OWNERSHIP	udd_designparamcode	varchar(5)	Yes	stock ownership	No
GIMV_TOSTK_OWNINGAGENCY	udd_vendorcode	varchar(45)	Yes	stock owning agency	No
GIMV_TOSTK_OWNINGAGENCY_OU	udd_seqno	int(4)	Yes	stock owning agency ou	No
GIMV_TOSTK_STATUS	udd_desc40	varchar(40)	Yes	stock status	No
GIMV_WORKORDER_NO	udd_desc40	varchar(40)	Yes	WORKORDER number	No

Table Name :	GI_GIOWN_COND_LOG_DTL
Comment :	Reverse conditional LOG

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	GI_GIPDREV_PART_DTL
Comment :	Reverse Part level details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	GI_GIPD_PART_DTL
Comment :	Part level details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIPD_UNIQUE_ID	udd_seqno	int(4)	No	Unique id will be generated for each line item	Yes
GIPD_RCPT_OU	udd_ctxt_ouinstance	int(4)	No	Receipt OU instance	No
GIPD_RCPT_NO	udd_documentno	varchar(40)	No	Receipt Document Number	No
GIPD_RCPT_TYPE	udd_designparamcode	varchar(5)	No	Receipt type (RP-Regular Purchase;CGR - Customer Goods Receipt)	Yes
GIPD_RCPT_LINENO	udd_lineno	int(4)	Yes	Receipt Line Number	No
GIPD_RCPT_LINESTATUS	udd_designparamcode	varchar(5)	Yes	Receipt Line status(D- Draft ,F- Fresh ,RPI- Received Pending Inspection ,APM- Accepted Pending Movement,RPR - Received Pending Return ,CA- Canceled ,CMP-Completed)	No
GIPD_RCPT_PARTOU	udd_ctxt_ouinstance	int(4)	No	Receipt part OU instance	No
GIPD_RCPT_PARTNO	udd_partno	varchar(40)	No	Receipt Part Number	No
GIPD_REFDOC_AMENDNO	udd_seqno	int(4)	Yes	Reference document amendment no	No
GIPD_REFDOC_LINENO	udd_lineno	int(4)	Yes	Reference Document Line No	No
GIPD_REFDOC_PARTOU	udd_ctxt_ouinstance	int(4)	Yes	Reference Document Part OU instance	No
GIPD_REFDOC_PARTNO	udd_partno	varchar(40)	Yes	Reference Document Part Number	No
GIPD_NO_OF_LOTS	udd_quantity	numeric(13)	Yes	The number of lots received for lot controlled parts which is used to split in serial lot info	No
GIPD_COMMENTS	udd_notes	varchar(2000)	Yes	Any remarks specified by the warehouse clerk	No
GIPD_MAT_TYPE	udd_designparamcode	varchar(5)	Yes	Material type (RP-Regular,CGR - Regular,Main Core)	No
GIPD_STKSTATUS	udd_partstatus	varchar(40)	Yes	Stock status mapped for the receipt type	No
GIPD_MOVETO_WH	udd_warehouse	varchar(10)	Yes	Warehouse to which parts need to be moved	No
GIPD_MOVETO_ZONE	udd_zone	varchar(10)	Yes	Zone in the warehouse to which parts need to be moved	No
GIPD_MOVETO_BIN	udd_bin	varchar(10)	Yes	Bin in the Warehouse,Zone to which parts need to be moved	No
GIPD_RCVD_QTY	udd_quantity	numeric(13)	No	The quantity of parts received	No
GIPD_UOM	udd_uom	varchar(15)	Yes	The unit of measurement mentioned in the Ref. Document used to procure the part	No
GIPD_RCVD_QTY_STKUOM	udd_quantity	numeric(13)	Yes	Received quantity in stock unit of measurement	No
GIPD_UOM_CON_FCTR	udd_quantity	numeric(13)	Yes	UOM Conversion factor as defined in UOM master	No
GIPD_REFDOC_WH	udd_warehouse	varchar(10)	Yes	Reference document warehouse	No
GIPD_REFDOC_COND	udd_designparamcode	varchar(5)	Yes	Reference document condition	No
GIPD_QUARANTINED	UDD_BIT	bit(1)	No	Quarentine Yes/No	No
GIPD_QUAR_REASON	udd_quickcodes	varchar(25)	Yes	Reason for quarantine	No
GIPD_QUAR_COMMENTS	udd_notes	varchar(2000)	Yes	Any remarks specified by the warehouse clerk during quarentine	No
GIPD_QUAR_STATUS	udd_desc40	varchar(40)	Yes	Quarantine Status	No
GIPD_QUAR_AREA	udd_desc40	varchar(40)	Yes	Area of quarentine	No
GIPD_INSP_AREA	udd_desc40	varchar(40)	Yes	Area of Inspection	No
GIPD_VISU_REJ_QTY	udd_quantity	numeric(13)	Yes	Visually Rejected quantity	No
GIPD_REJ_REASON	udd_quickcodes	varchar(25)	Yes	Rejection Reason	No
GIPD_RETURNED_QTY	udd_quantity	numeric(13)	Yes	Returned quantiy is backupdated for rejected parts during Move parts	No
GIPD_INVOICED_QTY	udd_quantity	numeric(13)	Yes	Invoiced quantity is backupdated during authorise invoice	No
GIPD_RES_RESP	udd_desc40	varchar(40)	Yes	Resolution Responsibility	No
GIPD_NEWPART	udd_seqno	int(4)	Yes	New Part not defined in part admin Yes/No	No
GIPD_PART_OWNERSHIP	udd_designparamcode	varchar(5)	Yes	Part Ownership (Own - Internal;SUP - Supplier;CUS - Customer)	No
GIPD_INSP_REQ_FLAG	UDD_BIT	bit(1)	No	Indicates whether inspection is required or not for the part."Yes" if the part requires inspection, and "No" if the part does not require inspection	No
GIPD_HAZMAT_FLAG	UDD_BIT	bit(1)	No	To indicate part is a hazardous part	No
GIPD_STOCKABLE_FLAG	UDD_BIT	bit(1)	No	If the part is a non-stockable part(Yes - If part is stockable,No - If part is non-stockable)	No
GIPD_PCT_FLAG	udd_designparamcode	varchar(5)	Yes	Part Control Type of the part(SRL-Serial controlled;S&L - Serial and lot controlled;LOT - lot controlled;Null - None controlled)	No
GIPD_PART_TYPE	udd_designparamcode	varchar(5)	Yes	Part Type as defined in part admin	No
GIPD_PART_CTRLTYPE	udd_designparamcode	varchar(5)	Yes	part control type in part admin (SN -serial controlled, LN- Lot controlled, NE - None controlled, BH - Both serial and lot controlled)	No
GIPD_RCPTREC_OPT_FLAG	udd_designparamcode	varchar(5)	Yes	Receipt Recording Option of the reference document	No
GIPD_PART_EXPTYPE	udd_designparamcode	varchar(5)	Yes	Part Expense Type as defined in part admin	No
GIPD_PART_EXPOLICY	udd_designparamcode	varchar(5)	Yes	Part Expense Policy as defined in part admin	No
GIPD_PART_LOTNUMTYPE	udd_designparamcode	varchar(5)	Yes	numbering type for lot controlled part as defined in part admin	No
GIPD_PART_SLNUMTYPE	udd_designparamcode	varchar(5)	Yes	numbering type for serial controlled part as defined in part admin	No
GIPD_PART_SLNOLOGIC	udd_designparamcode	varchar(5)	Yes	Serial Number Logic as defined in part admin	No
GIPD_SRLLOT_FLAG	udd_designparamcode	varchar(5)	Yes	A - serial lot info applicable;NA - Serial lot info not applicable;DE - Serial lot info already entered	No
GIPD_CUSTPRT_FLAG	udd_designparamcode	varchar(5)	Yes	A - work requested info applicable;NA - work requested info not applicable;DE - work requested info already entered	No
GIPD_SUPINFO_FLAG	udd_designparamcode	varchar(5)	Yes	A - Supplementary Info applicable;NA - Supplementary Info not applicable;DE - Supplementary Info already entered	No
GIPD_COST	udd_cost	numeric(13)	Yes	Derive the cost from PO for entire order qty and update in GI	No
GIPD_COSTPER	udd_amount	numeric(13)	Yes	Derive the cost per from PO for entire order qty and update in GI	No
GIPD_RCVDAMT	udd_amount	numeric(13)	Yes	for POGR ,cost divided by cost per is multiplied with the received qty-visually rejected at part level and serial lot level. For RORR , Sum of exchange fee plus repair cost plus BER cost	No
GIPD_ERATE	udd_rate	numeric(13)	Yes	Exchange rate as defined in ERATE master	No
GIPD_CONFRCPT_DATE	udd_datetime	varchar(30)	Yes	Date on which receipt is confirmed	No
GIPD_TRANAMT	udd_amount	numeric(13)	Yes	Transaction Amount	No
GIPD_TIMESTAMP	udd_timestamp	int(4)	Yes	Timestamp which is internally used to check if user works on the latest record set	No
GIPD_PROCESS_FLAG	udd_designparamcode	varchar(5)	Yes	To identify the records which is applicable to process for finance and drill down integration	No
GIPD_CREATEDDATE	udd_datetime	varchar(30)	Yes	The date on which receipt is created	No
GIPD_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	The user who created the receipt	No
GIPD_MODIFIEDDATE	udd_datetime	varchar(30)	Yes	The latest date on which receipt is modified	No
GIPD_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	The user who modified the receipt	No
GIPD_AVG_ERATE	udd_rate	numeric(13)	Yes	Average Exchange rate as defined in ERATE master updated during confirm inspection	No
GIPD_RES_COMMENTS	udd_notes	varchar(2000)	Yes	Resolution comments	No
GIPD_RCPT_PARTDESC	udd_item_desc	varchar(150)	Yes	description if the part #	No
GIPD_PRTDATACHG_FLAG	udd_flag	varchar(25)	Yes	If the part attributes are changed after GI Initiation the column will have the value as Y else N	No
GIPD_ALLQTY_REJECTED	udd_designparamcode	varchar(5)	Yes	Rejected quantity	No
GIPD_BER	udd_designparamcode	varchar(5)	Yes	BER value	No
GIPD_CORE_RET_OPTION	udd_designparamcode	varchar(5)	Yes	core return option	No
GIPD_ISS_PARTACCGRP	udd_customeraccountgroup	varchar(20)	Yes	account part group	No
GIPD_ISSUE_INT_LOT_NO	udd_lotno	varchar(18)	Yes	issue internal lot number	No
GIPD_ISSUE_INT_SL_NO	UDD_SERIALNO	varchar(40)	Yes	issue internal serial number	No
GIPD_ISSUE_MFRLOT_NO	udd_lotno	varchar(18)	Yes	Issue MFR lot number	No
GIPD_ISSUE_MFRSERIAL_NO	UDD_SERIALNO	varchar(40)	Yes	Issue MFR Serial number	No
GIPD_ISSUE_QTY	udd_quantity	numeric(13)	Yes	Issue quantity	No
GIPD_MGR_AUTO_INSP	udd_seqno	int(4)	Yes	Auto Inspection migration	No
GIPD_MGR_AUTO_MOVE	udd_seqno	int(4)	Yes	Auto Move migration	No
GIPD_OWNING_AGENCY	udd_vendorcode	varchar(45)	Yes	Owning agency details	No
GIPD_OWNINGAGENCY_OU	udd_ctxt_ouinstance	int(4)	Yes	Owning agency OU	No
GIPD_REP_QUOTE_ID	udd_seqno	int(4)	Yes	Repair order quote ID	No
GIPD_RO_PART_TYPE	udd_type	varchar(25)	Yes	Repair order part type	No
GIPD_RR_BER_COST	udd_amount	numeric(13)	Yes	If RORR then ,Derived from RO for the Rcvd qty excluding vis. Rej qty. Its not applicable for POGR	No
GIPD_RR_EXCH_FEE	udd_amount	numeric(13)	Yes	Derived from RO for the accepted qty. Not applicable for POGR	No
GIPD_RR_REP_COST	udd_amount	numeric(13)	Yes	If RORR then Derived from RO for the Rcvd qty excluding vis. Rej qty. Its Not applicable for POGR	No
GIPD_CONF_INST_ID	udd_seqno	int(4)	Yes	column to store confirm inspection ID	No
GIPD_Exchange_InvQty	udd_quantity	numeric(13)	Yes	To store Exchange Invioce quantity	No
GIPD_Repair_InvQty	udd_quantity	numeric(13)	Yes	To store Repair Invioce quantity	No
GIPD_REV_INST_ID	udd_seqno	int(4)	Yes	Column to store Reverse inspection ID	No
GIPD_RR_MIGRATED_AS_CLSD	udd_designparamcode	varchar(5)	Yes	To store details or Migrated RR	No
GIPD_CO_PART_TYPE	udd_type	varchar(25)	Yes	This field used to Indicate the Part type of CO based Receipt M for maincore and R for regular	No
GIPD_PACK_CODE	udd_txt20	varchar(20)	Yes	Packaging Code	No
GIPD_PACK_CONDITION	udd_notes	varchar(2000)	Yes	Packaging Condition	No
GIPD_PART_ACC_GRP	udd_customeraccountgroup	varchar(20)	Yes	This field is to capture the part account group	No

Table Name :	GI_GIPRM_PARAM_DTL
Comment :	Parameter description details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIPRM_COMPONENTNAME	udd_compname	varchar(40)	Yes	Component Name (BASGI)	No
GIPRM_PARAMCATEGORY	udd_paramcategory	varchar(10)	Yes	Parameter Category (COMBO, TEXT)	No
GIPRM_PARAMTYPE	udd_paramtype	varchar(25)	Yes	Parameter Type (REFDOCTYPE - Reference document type; DOCSTATUS - Reference Document Status; LNSTATUS - Line Status)	No
GIPRM_PARAMCODE	udd_paramcode	varchar(30)	Yes	Parameter Code	No
GIPRM_PARAMDESC	udd_txt150	varchar(150)	Yes	Parameter Description	No
GIPRM_LANGID	udd_ctxt_language	int(4)	Yes	Language ID	No
GIPRM_SORTBY	udd_seqno	int(4)	Yes	Sorted by (Ascending or Descending order)	No
REPLICATION_KEY	_Bigint_8	Bigint(8)	No	Unique id will be generated for each line	Yes

Table Name :	GI_GIPRT_STATUS_MSTR
Comment :	GI Status description details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIPRT_ORD_OF_PREF	udd_seqno	int(4)	Yes	Order of Preference	No
GIPRT_STOCKABLE	UDD_BIT	bit(1)	No	Stockable Flag (If part is stockable -1 ,if part is non stockable -0)	No
GIPRT_SRLLOT_STATUS	udd_designparamcode	varchar(5)	Yes	Serial Lot Line Status(RSCR - Rejection - Scrapped, A - Accepted, R- Received, PA - Partially Accepted, F - Fresh, RJ - Rejected, M - Moved, PM - Partially Moved,D - Draft,RTN - Rejection - Returned,CLD - Closed)	No
GIPRT_SRLLOT_STATUS_DESC	udd_txt80	varchar(80)	Yes	Serial lot Status Description	No
GIPRT_TASKTYPE	udd_designparamcode	varchar(5)	Yes	Task Type (TRAN, TERM)	No
GIPRT_PART_DERIVED_STATUS	udd_designparamcode	varchar(5)	Yes	Part Derived Status (D-Draft,F-Fresh,RPI- Received Pending Inspection,APM-Accepted Pending Movement,RPR -Received Pending Return,CLD-Closed,CMP-Completed)	No
REPLICATION_KEY	_Char_8	Char(8)	No	Unique id will be generated for each line	Yes

Table Name :	GI_GIQPH_QUAR_PARTS_HIS
Comment :	Quarentined parts history

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIQPH_UNIQUE_ID	udd_seqno	int(4)	No	Unique id will be generated for each quarantined line	Yes
GIQPH_QUAR_RECEIPTNO	udd_documentno	varchar(40)	Yes	Receipt Document Number	No
GIQPH_QUAR_RECEIPTOU	udd_ctxt_ouinstance	int(4)	Yes	Receipt OU instance	No
GIQPH_QUAR_RECEIPTTYPE	udd_designparamcode	varchar(5)	Yes	Receipt type (RP-Regular Purchase;CGR - Customer Goods Receipt)	No
GIQPH_QUAR_STAGE	udd_flag	varchar(25)	Yes	Quarantine Stage (RECUPD - Quarantined in Record update level ;SRLLOT - Quarantined in Serial Lot level ; WRCUST - Quarantined in Work Requested level ; INSPRT - Quarantined in Inspection level)	No
GIQPH_QUAR_STAGE_UNIQUEID	udd_seqno	int(4)	Yes	Staging Unique id will be generated for each corresponding line	No
GIQPH_QUAR_UNIQUEID	udd_seqno	int(4)	Yes	Unique id will be generated for each quarantine process	No
GIQPH_PART_LINENO	udd_lineno	int(4)	Yes	Part Line Number	No
GIQPH_SRLOT_LINENO	udd_lineno	int(4)	Yes	Serial Lot Line Number	No
GIQPH_ACCP_LINENO	udd_lineno	int(4)	Yes	Acceptance Line Number	No
GIQPH_QUAR_PARTNO	udd_partno	varchar(40)	Yes	Quarantined Part Number	No
GIQPH_QUAR_PARTOU	udd_ctxt_ouinstance	int(4)	Yes	Quarantined Part OU instance	No
GIQPH_QUAR_QTY	udd_quantity	numeric(13)	Yes	Quarantined Quantity	No
GIQPH_QUAR_UOM	udd_uom	varchar(15)	Yes	The unit of measurement mentioned in the Ref. Document used to procure the part	No
GIQPH_QUAR_MFRSRLNO	UDD_SERIALNO	varchar(40)	Yes	Received Manufacturer Serial Number	No
GIQPH_QUAR_MFRLOTNO	udd_lotno	varchar(18)	Yes	Received Manufacturer Lot Number	No
GIQPH_QUAR_QUARBY	udd_ctxt_user	varchar(30)	Yes	The user who quarantined the part	No
GIQPH_QUAR_FLAG	udd_flag	varchar(25)	Yes	Quarantined Flag (1 - Quarantined ; 0 - Resolved )	No
GIQPH_QUAR_REASON	udd_quickcodes	varchar(25)	Yes	Reason for quarantine	No
GIQPH_QUAR_COMMENTS	udd_notes	varchar(2000)	Yes	Any remarks specified by the warehouse clerk during quarentine	No
GIQPH_QUAR_STATUS	udd_desc40	varchar(40)	Yes	Quarentine status	No
GIQPH_RES_RESP	udd_desc40	varchar(40)	Yes	Resolution Responsibility	No
GIQPH_RES_COMMENTS	udd_notes	varchar(2000)	Yes	Remarks entered by the user who acted on the quarentined parts	No
GIQPH_QUAR_STATUS_FLAG	udd_designparamcode	varchar(5)	Yes	Quarantine Status Flag (Q - Quarantined ; R - Resolved)	No
GIQPH_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	The user who modified the receipt	No
GIQPH_MODIFIED_DATE	udd_datetime	varchar(30)	Yes	The latest date on which receipt is modified	No
GIQPH_TIMESTAMP	udd_timestamp	int(4)	Yes	Quarantined Timestamp which is internally used to check if user works on the latest record set	No

Table Name :	GI_GIQPREV_QUAR_PARTS
Comment :	Reverse Quarentined parts information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	GI_GIQP_QUAR_PARTS
Comment :	Quarentined parts latest information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIQP_UNIQUE_ID	udd_seqno	int(4)	No	Unique id will be generated for each quarantined line	Yes
GIQP_QUAR_RECEIPTNO	udd_documentno	varchar(40)	Yes	Receipt Document Number	No
GIQP_QUAR_RECEIPTOU	udd_ctxt_ouinstance	int(4)	Yes	Receipt OU instance	No
GIQP_QUAR_RECEIPTTYPE	udd_designparamcode	varchar(5)	Yes	Receipt type (RP-Regular Purchase;CGR - Customer Goods Receipt)	No
GIQP_QUAR_STAGE	udd_flag	varchar(25)	Yes	Quarantine Stage (RECUPD - Quarantined in Record update level ;SRLLOT - Quarantined in Serial Lot level ; WRCUST - Quarantined in Work Requested level ; INSPRT - Quarantined in Inspection level)	No
GIQP_QUAR_STAGE_UNIQUEID	udd_seqno	int(4)	Yes	Staging Unique id will be generated for each corresponding line	No
GIQP_PART_LINENO	udd_lineno	int(4)	Yes	Part Line Number	No
GIQP_SRLOT_LINENO	udd_lineno	int(4)	Yes	Serial Lot Line Number	No
GIQP_ACCP_LINENO	udd_lineno	int(4)	Yes	Acceptance Line Number	No
GIQP_QUAR_PARTNO	udd_partno	varchar(40)	Yes	Quarantined Part Number	No
GIQP_QUAR_PARTOU	udd_ctxt_ouinstance	int(4)	Yes	Quarantined Part OU instance	No
GIQP_QUAR_QTY	udd_quantity	numeric(13)	Yes	Quarantined Quantity	No
GIQP_QUAR_UOM	udd_uom	varchar(15)	Yes	The unit of measurement mentioned in the Ref. Document used to procure the part	No
GIQP_QUAR_MFRSRLNO	UDD_SERIALNO	varchar(40)	Yes	Received Manufacturer Serial Number	No
GIQP_QUAR_MFRLOTNO	udd_lotno	varchar(18)	Yes	Received Manufacturer Lot Number	No
GIQP_QUAR_QUARBY	udd_ctxt_user	varchar(30)	Yes	The user who quarantined the part	No
GIQP_QUAR_FLAG	udd_flag	varchar(25)	Yes	Quarantined Flag (1 - Quarantined ; 0 - Resolved )	No
GIQP_QUAR_REASON	udd_quickcodes	varchar(25)	Yes	Reason for quarantine	No
GIQP_QUAR_COMMENTS	udd_notes	varchar(2000)	Yes	Any remarks specified by the warehouse clerk during quarentine	No
GIQP_QUAR_STATUS	udd_desc40	varchar(40)	Yes	Quarentine status	No
GIQP_RES_RESP	udd_desc40	varchar(40)	Yes	Resolution Responsibility	No
GIQP_RES_COMMENTS	udd_notes	varchar(2000)	Yes	Remarks entered by the user who acted on the quarentined parts	No
GIQP_QUAR_STATUS_FLAG	udd_designparamcode	varchar(5)	Yes	Quarantine Status Flag (Q - Quarantined ; R - Resolved)	No
GIQP_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	The user who modified the receipt	No
GIQP_MODIFIED_DATE	udd_datetime	varchar(30)	Yes	The latest date on which receipt is modified	No
GIQP_TIMESTAMP	udd_timestamp	int(4)	Yes	Quarantined Timestamp which is internally used to check if user works on the latest record set	No
GIQP_STAGE_TIMESTAMP	udd_timestamp	int(4)	Yes	Timestamp which is internally used to check if user works on the latest record set	No

Table Name :	GI_GIRR_MIGRATION_DTL
Comment :	GI RR migration details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GIRR_OU	udd_desc40	varchar(40)	Yes	GI RR migration OU	No
GIRR_MIGRATED_FLAG	udd_ctxt_ouinstance	int(4)	Yes	GI RR migration check flag	No
GIRR_CREATED_DATE	udd_designparamcode	varchar(5)	Yes	GI RR migration created By	No
GIRR_CREATED_BY	udd_datetime	varchar(30)	Yes	GI RR migration created date	No
GIRR_MODIFIED_DATE	udd_ctxt_user	varchar(30)	Yes	GI RR migration modified date	No
GIRR_MODIFIED_BY	udd_datetime	varchar(30)	Yes	GI RR migration modified by	No

Table Name :	GI_GISLDREV_SRL_LOT_DTL
Comment :	Reverse Serial and lot details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	GI_GISLD_SRL_LOT_DTL
Comment :	Serial and lot details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GISLD_UNIQUE_ID	udd_seqno	int(4)	No	Unique id will be generated for each serial lot line	Yes
GISLD_RCPT_OU	udd_ctxt_ouinstance	int(4)	No	Receipt OU instance	No
GISLD_RCPT_NO	udd_documentno	varchar(40)	No	Receipt Document Number	No
GISLD_RCPT_TYPE	udd_designparamcode	varchar(5)	No	Receipt type (RP-Regular Purchase;CGR - Customer Goods Receipt)	Yes
GISLD_RCPT_LINENO	udd_lineno	int(4)	Yes	Receipt Line Number	No
GISLD_SRLLOT_LINENO	udd_lineno	int(4)	Yes	Serial Lot Line Number	No
GISLD_SRLLOT_LINE_STATUS	udd_designparamcode	varchar(5)	Yes	Serial Lot Line Status(RSCR - Rejection - Scrapped, A - Accepted, R- Received, PA - Partially Accepted, F - Fresh, RJ - Rejected, M - Moved, PM - Partially Moved,D - Draft,RTN - Rejection - Returned,CLD - Closed)	No
GISLD_ISS_PARTOU	udd_ctxt_ouinstance	int(4)	Yes	Issued Part OU instance	No
GISLD_ISS_PARTNO	udd_partno	varchar(40)	Yes	Issued Part Number	No
GISLD_RCPT_PARTOU	udd_ctxt_ouinstance	int(4)	Yes	Received Part OU instance	No
GISLD_RCPT_PARTNO	udd_partno	varchar(40)	No	Received Part Number	No
GISLD_NONE_CTRL_FLAG	UDD_BIT	bit(1)	No	If the part is none controlled this will be 1 and for others 0	No
GISLD_RCVD_QTY	udd_quantity	numeric(13)	No	Received Quantity	No
GISLD_UOM	udd_uom	varchar(15)	Yes	The unit of measurement mentioned in the Ref. Document used to procure the part	No
GISLD_ISS_MFRSRLNO	UDD_SERIALNO	varchar(40)	Yes	Issued Manufacturer Serial Number applicable for RR	No
GISLD_RCVD_MFRSRLNO	UDD_SERIALNO	varchar(40)	Yes	Received Manufacturer Serial Number	No
GISLD_ISS_MFRLOTNO	udd_lotno	varchar(18)	Yes	Issued manufacturer lot no applicable for RR	No
GISLD_RCVD_MFRLOTNO	udd_lotno	varchar(18)	Yes	Received manufacturer lot no	No
GISLD_ISS_INT_SRLNO	UDD_SERIALNO	varchar(40)	Yes	Issued internal serial no applicable for RR	No
GISLD_RCVD_INT_SRLNO	UDD_SERIALNO	varchar(40)	Yes	Received internal serial no	No
GISLD_ISS_INT_LOTNO	udd_lotno	varchar(18)	Yes	Issued internal lot no applicble for RR	No
GISLD_RCVD_INT_LOTNO	udd_lotno	varchar(18)	Yes	Received internal lot no	No
GISLD_VISU_REJ_QTY	udd_quantity	numeric(13)	Yes	Visually rejected quantity	No
GISLD_REJ_REASON	udd_quickcodes	varchar(25)	Yes	Rejection reason	No
GISLD_QUARANTINED	UDD_BIT	bit(1)	No	Quarentined(1-Yes;0-No)	No
GISLD_QUAR_REASON	udd_quickcodes	varchar(25)	Yes	Reason for quarantine	No
GISLD_QUAR_AREA	udd_desc40	varchar(40)	Yes	Quarentine area	No
GISLD_QUAR_STATUS	udd_desc40	varchar(40)	Yes	Quarentine status	No
GISLD_QUAR_COMMENTS	udd_notes	varchar(2000)	Yes	Any remarks specified by the warehouse clerk during quarentine	No
GISLD_CHANGE_TYPE	udd_flag	varchar(25)	Yes	Change type applicable for RR	No
GISLD_RCVD_PARTCOND	udd_designparamcode	varchar(5)	Yes	Received Part Condition(N -New, S - Serviceable, U - UnServiceable, O - Overhauled)	No
GISLD_OPERATOR	udd_documentno	varchar(40)	Yes	Airline Operator Number	No
GISLD_CERT_TYPE	udd_flag	varchar(25)	Yes	Certificate type	No
GISLD_CERT_NO	udd_refdocno	varchar(40)	Yes	Certificate number	No
GISLD_CERT_DATE	udd_datetime	varchar(30)	Yes	Certificate date	No
GISLD_MFR_DATE	udd_datetime	varchar(30)	Yes	Manufacturer date	No
GISLD_CERT_SUPNO	udd_vendorcode	varchar(45)	Yes	Certificate supplier number	No
GISLD_SHELFLIFE_CHK	udd_flag	varchar(25)	Yes	Shelf life check(Enforce,Override)	No
GISLD_EXPIRYDATE	udd_datetime	varchar(30)	Yes	Expiry date	No
GISLD_RES_RESP	udd_desc40	varchar(40)	Yes	Resolution Responsibility	No
GISLD_ISS_COMPOU	udd_ctxt_ouinstance	int(4)	Yes	Issued component ou applicable for RR	No
GISLD_ISS_COMPID	udd_componentid	varchar(90)	Yes	Issued component id applicable for RR	No
GISLD_RCVD_COMPOU	udd_ctxt_ouinstance	int(4)	Yes	Received component ou	No
GISLD_RCVD_COMPID	udd_componentid	varchar(90)	Yes	Received component id	No
GISLD_INSP_REQ_FLAG	UDD_BIT	bit(1)	No	Indicates whether inspection is required or not for the part.1 - if the part requires inspection, and 0 - if the part does not require inspection	No
GISLD_HAZ	UDD_BIT	bit(1)	No	To indicate part is a hazardous part	No
GISLD_STOCKABLE	UDD_BIT	bit(1)	No	If the part is a non-stockable part(1 - If part is stockable,0 - If part is non-stockable)	No
GISLD_TOT_ACCEPTED_QTY	udd_quantity	numeric(13)	Yes	Total Accepted Quantity	No
GISLD_PENDING_INSP_QTY	udd_quantity	numeric(13)	Yes	Pending inspection Quantity	No
GISLD_TOTINSP_REJ_QTY	udd_quantity	numeric(13)	Yes	Total Inspection Level Rejected Quantity	No
GISLD_TOT_MOVED_QTY	udd_quantity	numeric(13)	Yes	Total Moved Quantity	No
GISLD_DEVIATED_PART	UDD_BIT	bit(1)	No	the part received is deviated from maintenance process it should have complied (1-Yes;0-No)	No
GISLD_DEVIATED_COMMENTS	UDD_Comments	char(256)	Yes	Remarks pertaining to deviated parts	No
GISLD_ASSEMBLY_CODE	udd_designparamcode	varchar(5)	Yes	Assembly code	No
GISLD_CREATEDDATE	udd_datetime	varchar(30)	Yes	The date on which receipt is created	No
GISLD_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	The user who created the receipt	No
GISLD_MODIFIEDDATE	udd_datetime	varchar(30)	Yes	The latest date on which receipt is modified	No
GISLD_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	The user who modified the receipt	No
GISLD_TIMESTAMP	udd_timestamp	int(4)	Yes	Timestamp which is internally used to check if user works on the latest record set	No
GISLD_RES_COMMENTS	udd_notes	varchar(2000)	Yes	Remarks entered by the user who acted on the quarentined parts	No
GISLD_FILENAME	UDD_Comments	char(256)	Yes	The name of the document that is uploaded	No
GISLD_CERT_REQD	udd_seqno	int(4)	Yes	certifiacate requried Flag	No
GISLD_CERTIFICATE_AUNO	udd_desc40	varchar(40)	Yes	certificate authorize number	No
GISLD_CHANGE_BASIS	udd_designparamcode	varchar(5)	Yes	change basis	No
GISLD_ISSUE_QTY	udd_quantity	numeric(13)	Yes	issue quantity	No
GISLD_SHELF_LIFE	udd_seqno	int(4)	Yes	shelf life check	No

Table Name :	GI_GISUPLMREV_SUPPLM_INFO
Comment :	Reverse Supplimentary details either part or document level

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	GI_GISUPLM_SUPPLM_INFO
Comment :	Supplimentary details eother part or document level

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GISUPLM_UNIQUEID	udd_seqno	int(4)	No	Unique id will be generated for each supplementary entity	Yes
GISUPLM_RCPT_NO	udd_documentno	varchar(40)	No	Receipt Document Number	No
GISUPLM_RCPT_OU	udd_ctxt_ouinstance	int(4)	No	Receipt OU instance	No
GISUPLM_PART_OU	udd_ctxt_ouinstance	int(4)	Yes	Part OU Instance	No
GISUPLM_PARTNO	udd_partno	varchar(40)	Yes	Part Number	No
GISUPLM_RCPT_TYPE	udd_designparamcode	varchar(5)	No	Receipt type (RP-Regular Purchase;CGR - Customer Goods Receipt)	Yes
GISUPLM_APPLICABILITY_FLAG	udd_designparamcode	varchar(5)	Yes	Applicablility Flag either at PART level or DOC level	No
GISUPLM_SUPP_ENTITY	udd_documentno	varchar(40)	Yes	If PART - quick code value appplicable at the part level as defined in logistic quick codes; Doc - quick code value applicable at the doc level as defined in the logistic quick codes	No
GISUPLM_DESC	udd_notes	varchar(2000)	Yes	If PART - quick code description appplicable at the part level as defined in logistic quick codes; Doc - quick code description applicable at the doc level as defined in the logistic quick codes	No
GISUPLM_MANDATORY	UDD_BIT	bit(1)	No	Mandatory Check (1 - Yes; 0 - No)	No
GISUPLM_SUPP_ENTITYVAL	udd_remarks	varchar(255)	Yes	Supplementary Entity Value	No
GISUPLM_RECORD_AT	udd_designparamcode	varchar(5)	Yes	To identify whether the supplimentary details is defined either by warehouse clerk or inspector	No
GISUPLM_CREATEDBY	udd_datetime	varchar(30)	Yes	The user who created the receipt	No
GISUPLM_CREATEDDATE	udd_ctxt_user	varchar(30)	Yes	The date on which receipt is created	No
GISUPLM_MODIFIEDBY	udd_datetime	varchar(30)	Yes	The user who modified the receipt	No
GISUPLM_MODIFIEDDATE	udd_ctxt_user	varchar(30)	Yes	The latest date on which receipt is modified	No
GISUPLM_TIMESTAMP	udd_timestamp	int(4)	Yes	Timestamp which is internally used to check if user works on the latest record set	No

Table Name :	GI_GITCDCACA_CONFACCP_TCD_DTL
Comment :	Confirm acceptance TCD details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GITCDCACA_TCD_INCIDENCE	udd_taxinci	Varchar(40)	Yes	TCD Incidence	No

Table Name :	GI_GITCDCAREV_CONFACCP_TCD_DTL
Comment :	Reverse Apportioned level of add to stock TCDs defined in ref document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GITCDCAREV_TCD_INCIDENCE	udd_taxinci	Varchar(40)	Yes	TCD Incidence	No

Table Name :	GI_GITCDCA_CONFACCP_TCD_DTL
Comment :	Apportioned level of add to stock TCDs defined in ref document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GITCDCA_CREATED_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	OU instance	No
GITCDCA_RCPT_NO	udd_documentno	varchar(40)	No	Receipt Document Number	No
GITCDCA_RCPTCURRENCY	udd_currency	varchar(20)	Yes	Receipt Currency	No
GITCDCA_DOC_PRT_FLAG	udd_flag	varchar(25)	Yes	Document Part Flag	No
GITCDCA_PART_LINE_ID	udd_lineno	int(4)	No	Part Line Number	No
GITCDCA_SRLLOT_LINE_ID	udd_lineno	int(4)	No	Serial Lot Line Number	No
GITCDCA_ACCP_LINE_ID	udd_lineno	int(4)	No	Acceptance Line Number	No
GITCDCA_PART_TCD_LINE_ID	udd_lineno	int(4)	No	Part level TCD Line Number	No
GITCDCA_TCD_OU	udd_ctxt_ouinstance	int(4)	Yes	TCD OU instance	No
GITCDCA_TCD_CODE	udd_flag	varchar(25)	Yes	TCD code	No
GITCDCA_TCDCURRENCY	udd_currency	varchar(20)	Yes	TCD currency	No
GITCDCA_TCD_VAR	udd_flag	varchar(25)	Yes	TCD variance	No
GITCDCA_TCD_RATE	udd_rate	numeric(13)	Yes	TCD Rate	No
GITCDCA__PRT_TCD_SEQNO	udd_seqno	int(4)	Yes	Part level TCD Sequence Number	No
GITCDCA_TCD_BAS_ERATE	udd_rate	numeric(13)	Yes	TCD Base Rate	No
GITCDCA_RCPT_BAS_ERATE	udd_rate	numeric(13)	Yes	Receipt Base Rate	No
GITCDCA_TCD_ACCRULE	udd_designparamcode	varchar(5)	Yes	TCD Account Rule	No
GITCDCA_TCD_AMT	udd_amount	numeric(13)	Yes	TCD amount	No
GITCDCA_TCD_BASE_AMT	udd_amount	numeric(13)	Yes	TCD Base Amount	No
GITCDCA_CREATEDDATE	udd_datetime	varchar(30)	No	The date on which receipt is created	No
GITCDCA_CREATED_BY	udd_ctxt_user	varchar(30)	No	The user who created the receipt	No
REPLICATION_KEY	_Bigint_8	Bigint(8)	No	Unique id will be generated for each line	Yes
GITCDCA_RCPT_TCD_ERATE	udd_rate	numeric(13)	No	Receipt TCD Rate	Yes
GITCDCA_CHRG_TYPE	udd_designparamcode	varchar(5)	No	TCD charge type either payable or notional	Yes
GITCDCA_Cost_Entity	udd_flag	varchar(25)	No	TCD details for RO cost entity	Yes
GITCDCA_TCD_INCIDENCE	udd_taxinci	Varchar(40)	Yes	TCD Incidence	No

Table Name :	GI_GITCDCRREV_CONFRCPT_TCD_DTL
Comment :	Reverse Inherited TCD details for all type from reference document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GITCDCRREV_TCD_INCIDENCE	udd_taxinci	Varchar(40)	No	TCD Incidence	Yes

Table Name :	GI_GITCDCR_CONFRCPT_TCD_DTL
Comment :	Inherited TCD details for all type from reference document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GITCDCR_CREATED_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	OU instance	No
GITCDCR_RCPT_NO	udd_documentno	varchar(40)	No	Receipt Document Number	No
GITCDCR_RCPTCURRENCY	udd_currency	varchar(20)	Yes	Receipt Currency	No
GITCDCR_DOC_PRT_FLAG	udd_flag	varchar(25)	Yes	Document Part flag	No
GITCDCR_PART_LINE_ID	udd_lineno	int(4)	No	Receipt Line Number	No
GITCDCR_PART_TCD_LINE_ID	udd_lineno	int(4)	No	Part level TCD Line Number	No
GITCDCR_TCD_OU	udd_ctxt_ouinstance	int(4)	Yes	TCD OU instance	No
GITCDCR_TCD_CODE	udd_flag	varchar(25)	Yes	TCD code	No
GITCDCR_TCDCURRENCY	udd_currency	varchar(20)	Yes	TCD currency	No
GITCDCR_TCD_VAR	udd_flag	varchar(25)	Yes	TCD variance	No
GITCDCR_TCD_RATE	udd_rate	numeric(13)	Yes	TCD Rate	No
GITCDCR_PRT_TCD_SEQNO	udd_seqno	int(4)	Yes	Part level TCD Sequence Number	No
GITCDCR_PORSCPY_FLAG	udd_flag	varchar(25)	Yes	PO RS Copy flag(Y -Yes)	No
GITCDCR_TCD_BAS_ERATE	udd_rate	numeric(13)	Yes	TCD Base Rate	No
GITCDCR_RCPT_BAS_ERATE	udd_rate	numeric(13)	Yes	Receipt Base Rate	No
GITCDCR_TCD_ACCRULE	udd_designparamcode	varchar(5)	Yes	TCD Account Rule	No
GITCDCR_TCD_AMT	udd_amount	numeric(13)	Yes	TCD amount	No
GITCDCR_TCD_BASE_AMT	udd_amount	numeric(13)	Yes	TCD Base Amount	No
GITCDCR_CREATEDDATE	udd_datetime	varchar(30)	No	The date on which receipt is created	No
GITCDCR_CREATED_BY	udd_ctxt_user	varchar(30)	No	The user who created the receipt	No
GITCDCR_INVOICED	udd_designparamcode	varchar(5)	Yes	To check whether TCD is invoiced or not	No
REPLICATION_KEY	_Bigint_8	Bigint(8)	No	Unique id will be generated for each line	Yes
GITCDCR_CHRG_TYPE	udd_designparamcode	varchar(5)	No	Tcd Charge type either payable or notional	Yes
GITCDCR_Cost_Entity	udd_flag	varchar(25)	No	RO cost entity	Yes
GITCDCR_TCD_INCIDENCE	udd_taxinci	Varchar(40)	No	TCD Incidence	Yes