Data Dictionary -- Goods Receipt

Srl. No.	Table Name	Comment
1	GR_GRSD_GOODS_RET_SUP_DTL	This table holds the goods return details of each Part Number associated with GOODS_RECEIPT
2	GR_GRSH_GOODS_RET_SUP_HDR	This table holds the doc level attributes of a GOODS Return document . The following columns are storing paramcodes whose description is available in GR_Parameter_details table. 1.Grh_docstatus
3	GR_RRCWI_COMP_WARR_INFO	This table holds the warranty information for the part and serial component
4	GR_RRDTCD_DOC_TCD_DTL	This table holds the tcd document level details of Repair Receipt .
5	GR_RRHD_REPAIR_RECEIPT_HDR	This table holds the document level attributes for the REPAIR_RECEIPT. The following columns are storing paramcodes whose description is available in GR_Parameter_details table. 1.RRHd_RR_Type 2.RRHd_Doc_status
6	GR_RRLSNO_LOT_SLNO_DTL	This Table holds the lot and serial information for each Line Parts.
7	GR_RRPDT_REPAIR_PT_DTL	This entity holds the Receipt part Details. One Receipt may contain more than one part.
8	GR_RRPLII_PT_LT_INSP_INFO	This Table holds the Lot level part Inspection Details
9	GR_RRPMVI_PT_MOVE_INFO	This Table Holds the Part Movemnet details for the Repair receipt
10	GR_RRPMVI_PT_PENDMOVE_INFO	Posting  and  ownership details  will be populated against RR  during  acceptance if the RR is  participating with exchange scenario only.
11	GR_RRPPD_PT_POS_DTL	This table holds the Sub component details
12	GR_RRPRD_PT_REF_OBJ_DTL	This table holds the part level reference document details for the repair receipt.
13	GR_RRPSII_PT_SL_INSP_INFO	This table holds the Inspection Information of the serial controlled parts.
14	GR_RRPSPI_PT_SL_PARM_INFO	This table holds the Parameter details for the part of type component.
15	GR_RRROD_REF_OBJ_DTL	This table Holds the Refrence document details for the Repair receipt.
16	GR_RRSPI_SUB_PARM_INFO	This table holds the sub component s parameter information.
17	GR_RRSWI_SUB_WARR_INFO	This table contains the sub component warranty info

Table Name :	GR_GRSD_GOODS_RET_SUP_DTL
Comment :	This table holds the goods return details of each Part Number associated with GOODS_RECEIPT

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GRSD_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU instance ID	Yes
GRSD_GRS_NO	_varchar_40	varchar(40)	No	GRS# is unique number to identify the GOODS RETURN TO VENDOR document which is an increment over the GRS # of the most recent GRS created,as per the numbering type specified.	Yes
GRSD_GR_NO	_varchar_40	varchar(40)	No	This fiels holds the Goods Receipt Number by which the part is received.	Yes
GRSD_PART_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the part line id for which the Return details has been entered.	Yes
GRSD_REFDOC_NO	_varchar_40	varchar(40)	Yes	Reference Document Number	No
GRSD_REFDOC	_varchar_5	varchar(5)	Yes	Reference Document Type	No
GRSD_RETURN_QTY	_decimal_28_8	decimal(28)	Yes	This field is to capture the return quantity which should satisfy the following conditions. 1.No process for the returned quantity - 0 or null 2.Returned quantity > 0 3.If returned quantity is a fraction ,it needs to be validated with UOM_ADMIN com	No
GRSD_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the record created date for auditing purpose.	No
GRSD_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the login id of the record for auditing purpose.	No
GRSD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the record modified date for auditing purpose.	No
GRSD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the login id of the modified record for auditing purpose.	No
GRSD_SHIPPED_QTY	udd_quantity	numeric(13)	Yes	Shipped Quantity - After Return How many Quantities Issued.	No

Table Name :	GR_GRSH_GOODS_RET_SUP_HDR
Comment :	This table holds the doc level attributes of a GOODS Return document . The following columns are storing paramcodes whose description is available in GR_Parameter_details table. 1.Grh_docstatus

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GRSH_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the ouinstance of the document -Goods returned to the vendor	Yes
GRSH_GRS_NO	_varchar_40	varchar(40)	No	GRS# is unique number to identify the GOODS RETURN TO VENDOR document which is an increment over the GRS # of the most recent GRS created,as per the numbering type specified.	Yes
GRSH_GOODS_RETURN_DATE	_datetime_8	datetime(8)	Yes	This field holds the goods return date. the GRS Date should be lesser than or equal to current system date.	No
GRSH_OUT_PASS_NO	_varchar_40	varchar(40)	Yes	This field holds the outpassno when the goods are returned and it is entered by the user.	No
GRSH_GRS_USERSTATUS	_varchar_25	Varchar(25)	Yes	This field is to capture the user status combo with the values in Active status defined under the quickcodes of the type GRS User Status in this component	No
GRSH_GRS_TYPE	_varchar_25	Varchar(25)	Yes	This field is to capture the GRS type combo with the values Return and Scrap	No
GRSH_OUT_PASS_DATE	_datetime_8	datetime(8)	Yes	This field holds the outpassdate when the goods are returned and it is entered by the user.	No
GRSH_OUT_PASS_REMARKS	_varchar_255	varchar(255)	Yes	This field is to capture the remarks of the outpass.	No
GRSH_GRS_CATEGORY	_varchar_25	Varchar(25)	Yes	This field is to capture the GRS Category combo with the values in Active status, defined under the Quickcodes of the type GRS Category in this component	No
GRSH_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the record created date for auditing purpose.	No
GRSH_DOC_STATUS	_varchar_5	varchar(5)	Yes	This column holds the doc status of the goods returned to the vendor. Allowed values are 1.F-Fresh 2.R-Returned 3.C-Cancelled	No
GRSH_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the login id of the record for auditing purpose.	No
GRSH_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the record modified date for auditing purpose.	No
GRSH_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the login id of the modified record for auditing purpose.	No
GRSH_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	holds the timestamp value of the record	No
GRSH_GRS_NUMTYPE	_varchar_20	varchar(20)	Yes	The numbering type for GRS transaction is stored	No
GRSH_RETURN_WHNO	udd_warehouse	varchar(10)	Yes	Used to store the Return From warehouse for printing MMD.	No
GRSH_RMA_NO	udd_documentno	varchar(40)	Yes	Used to Store the RMA Number.	No
GRSH_RMA_DATE	udd_time	datetime(8)	Yes	Used to store the RMA Date.	No
GRSH_SUPP_ADDRESS_ID	_decimal_13_0	decimal(13)	Yes	Used to store the Supplier Adderess ID.	No
GRSH_SUPPLIER_ID	udd_vendorcode	varchar(45)	Yes	Used to store the Supplier number.	No

Table Name :	GR_RRCWI_COMP_WARR_INFO
Comment :	This table holds the warranty information for the part and serial component

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRCWI_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit WHere the Warranty info of the component is entered.	Yes
RRCWI_RR_NO	_varchar_40	varchar(40)	No	This field holds repair receipt number for which the information is entered.	Yes
RRCWI_PART_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the part Line Id for which the warrantry info has been entered.	Yes
RRCWI_LOT_SL_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the serial line id for which warranty info has been entered.	Yes
RRCWI_WARR_UNDER_FLAG	_varchar_5	varchar(5)	Yes	This field stores the value Y or N. If Y means the component is under warranty.	No
RRCWI_WARR_NUMBERING_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Warranty Numbering type to genrate new warranty Number for the part and serial no (component).	No
RRCWI_WARR_CATEGORY	_varchar_25	Varchar(25)	Yes	This field holds the warranty category defined in the logistics common master.	No
RRCWI_WARR_TYPE	_varchar_25	Varchar(25)	Yes	This field holds Warranty type which is defined in the logistics common master.	No
RRCWI_WARR_START_DATE	_datetime_8	datetime(8)	Yes	This Field stores the warranty start date for the component.	No
RRCWI_WARR_DURATION	_decimal_28_8	decimal(28)	Yes	This field stores the Warranty Duration period from warranty start date.	No
RRCWI_WARR_DURATION_UNIT	_varchar_10	varchar(10)	Yes	This field stores the warranty duration Unit lIke M - Months , D- Days, W- weeks	No
RRCWI_WARR_REMARKS	_varchar_255	varchar(255)	Yes	This field holds remarks entered if any when the warranty info is entered.	No
RRCWI_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field stores the date when the warranty info has been entered initially.	No
RRCWI_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the User name who entered the warranty info initially for the component	No
RRCWI_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the warranty info has been modified finally.	No
RRCWI_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user name who modified the warranty info finally.	No
RRCWI_WARR_START_BASIS	_varchar_5	varchar(5)	Yes	Warranty Begins On - Installation Date (ID) and Receipt Date (RD)	No

Table Name :	GR_RRDTCD_DOC_TCD_DTL
Comment :	This table holds the tcd document level details of Repair Receipt .

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRDTCD_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the organisation Unit Number where the Repair receipt Level TCD details entered.	Yes
RRDTCD_RR_NO	_varchar_40	varchar(40)	No	This field holds the Repair Receipt Number for which the TCD details entered.	Yes
RRDTCD_DOC_TCD_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the Tcd Line ID for each TCD Code entered for the repair receipt.	Yes
RRDTCD_TCD_OU	_decimal_10_0	decimal(10)	Yes	This field holds the organisation unit where the TCD code is created.	No
RRDTCD_TCD_CODE	_varchar_25	Varchar(25)	Yes	This field holds the TCD Code for the Repair receipt.	No
RRDTCD_TCD_VAR	_varchar_25	Varchar(25)	Yes	This field holds the TCD Variant defined for the Tcd Code for the Repair receipt.	No
RRDTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	This field holds the Tcd Rate defined for the TCD Code in The TCD component.	No
RRDTCD_TCD_AMT	_decimal_28_8	decimal(28)	Yes	This field holds the TCD Amount for the Repair Receipt.	No
RRDTCD_CURRENCY	_varchar_20	varchar(20)	Yes	Currency Information	No
RRDTCD_SUPPLIER_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	This field holds the organisation unit where the Supplier is defined.	No
RRDTCD_SUPPLIER_NO	_varchar_45	varchar(45)	Yes	This field holds the Supplier code from whom the part is received.	No
RRDTCD_REP_FLG	_varchar_5	varchar(5)	Yes	This field holds the Value Y or N. When It is comming from Repair order , It will be defaulted NULL.	No
RRDTCD_TCD_SEQNO	_decimal_10_0	decimal(10)	Yes	TCD Sequence No.	No
RRDTCD_RO_FLAG	_varchar_5	varchar(5)	Yes	RO Flag	No
RRDTCD_EXC_RATE	_decimal_28_8	decimal(28)	Yes	Exchange Rate	No
RRDTCD_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the Document TCD details entered initially for the Repair receipt.	No
RRDTCD_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the User Name who entered the TCD Deatils for the Repair Receipt initailly.	No
RRDTCD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the Document TCD details modified finally for the Repair receipt.	No
RRDTCD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the User Name who modified the TCD Deatils for the Repair Receipt finally	No
RRDTCD_COST_CENTER	_varchar_40	varchar(40)	Yes	stores the cost center for the specified account code	No
RRDTCD_ACCOUNT_TYPE	_varchar_25	Varchar(25)	Yes	stores the account type	No
RRDTCD_ACCOUNT_CODE	_char_32	char(32)	Yes	Stores the account code from Accoutnt group component	No
RRDTCD_ANALYSIS_CODE	_varchar_5	varchar(5)	Yes	stores the analysis code from the account based budget component for the passed account code	No
RRDTCD_SUBANALYSIS_CODE	_varchar_5	varchar(5)	Yes	stores the subanalysis code from the account based budget component for the passed account code	No
RRDTCD_CONTROL_ACC_TYPE	_varchar_40	varchar(40)	Yes	stores the Control Account Type from the AS component for the passed account code	No
RRDTCD_AUTO_POST_ACC_TYPE	_varchar_40	varchar(40)	Yes	stores the Automatic Posting Account Type from the AS component for the passed account code	No
RRDTCD_ACCT_CURR_CODE	_varchar_5	varchar(5)	Yes	stores the Account Currency Code from the AS component for the passed account code	No

Table Name :	GR_RRHD_REPAIR_RECEIPT_HDR
Comment :	This table holds the document level attributes for the REPAIR_RECEIPT. The following columns are storing paramcodes whose description is available in GR_Parameter_details table. 1.RRHd_RR_Type 2.RRHd_Doc_status

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRHD_CREATED_OUINSTANCE	_numeric_28_0	numeric(28)	No	This attribute holds the Organisation Unit where the Document has been created.	Yes
RRHD_RR_NO	_varchar_40	varchar(40)	No	This field holds the Document Number which is Unique and automatically generated by the system while creating a new repair receipt against a Repair Order. Using the "Document Numbering Class" component the next Document Number to be generated is ca	Yes
RRHD_RR_DATE	_datetime_8	datetime(8)	Yes	This Attribute holds the Date on which the Document (Repair Receipt) has been created. 1.Repair Receipt Date can not be greater than current date. 2 Repair Receipt Date Can not be earlier than "Repair Order Authorization date" , "Gate Pass date","	No
RRHD_DOC_STATUS	_varchar_5	varchar(5)	Yes	This field holds the status of the document. A Repair receipt can be in one of the following statuses. R - Received RF- Receipt Frozen I - Inspected M- Moved PI- Partially Inspected PM-Partially Moved	No
RRHD_REP_OUINSTANCE	_numeric_28_0	numeric(28)	Yes	This Field Captures the organisation Unit in which the Refrerred Document (Here in this case it is RO) Has been created.	No
RRHD_REP_DOC_NO	_varchar_40	varchar(40)	Yes	This field captures the Refrerred Doument No (RO Number) against which the Receipt Has been made.	No
RRHD_REP_AMEND_NO	_numeric_28_0	numeric(28)	Yes	This Field Holds the last amendment number of the referred document Number.	No
RRHD_REP_DATE	_datetime_8	datetime(8)	Yes	This Field contains the Referred Document (RO) Created date.	No
RRHD_RR_CATEGORY	_varchar_25	Varchar(25)	Yes	This Field contains the Receipt category which is defined in the common logistics master component.	No
RRHD_RR_USERSTATUS	_varchar_25	Varchar(25)	Yes	This Field contains the User Status which is defined in the common logistics master component.	No
RRHD_RR_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Receipt Type. The value could be one of the following. NM - Normal EX - Exchange	No
RRHD_DELIVERY_NOTE_NO	_varchar_40	varchar(40)	No	This Field contains Delivery Note Number sent by the Repair shop along with the goods sent by him giving all the details about the parts he is sending with reference to the RO raised on him.	No
RRHD_DELIVERY_NOTE_DATE	_datetime_8	datetime(8)	Yes	This attribute holds the Delivery Note date on which Delivery Note Number has been made by the Repaior shop.	No
RRHD_WAY_BILL_NO	_varchar_40	varchar(40)	No	This Field Holds Way Bill Number. It is the document given by the carrier along with the consignment he delivers to the receipt location. It would have details like package type, weight, carrier details and vehicle no. Etc.	No
RRHD_WAY_BILL_DATE	_datetime_8	datetime(8)	Yes	This field Holds the date when the Way Bill No has been prepared by the Carrier.	No
RRHD_GATE_PASS_NO	_varchar_40	varchar(40)	Yes	This Field Holds the Gate Pass Number. It is the entry pass given to the vehicle carrying the consignment as it enters the receipt location.	No
RRHD_GATE_PASS_DATE	_datetime_8	datetime(8)	Yes	This Field holds the Gate Pass Date.	No
RRHD_COMMENTS	udd_txt2000	varchar(2000)	Yes	This Field holds the comments which is entered by the Receiver while Receipt is prepared.	No
RRHD_FR_RCPT_DATE	_datetime_8	datetime(8)	Yes	This Field Holds the date when the receipt has been frozen.	No
RRHD_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field Holds the date on which the receipt has been Created.	No
RRHD_CREATED_BY	_varchar_30	varchar(30)	No	This attribute is used to store the User Name who has been created the document.	No
RRHD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This Filed holds the date on which the document has been modified finally.	No
RRHD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field stores the user who modified the document finally.	No
RRHD_TIMESTAMP	_numeric_28_0	numeric(28)	No	This field Used to store the number which will be incremented by whenever the document is modified. The purpose of this field is to check the concurrency of the document.	No
RRHD_RR_NUMTYPE	_varchar_5	varchar(5)	Yes	stores the numbering type for repair receipt transaction	No
RRHD_DEF_FIN_BOOK	_char_20	char(20)	Yes	stores the default finance book	No
RRHD_ACCOUNT_TYPE	_varchar_25	Varchar(25)	Yes	Holds the account type	No
RRHD_ACCOUNT_CODE	_char_32	char(32)	Yes	Stores the account code from Accoutnt group component	No
RRHD_ANALYSIS_CODE	_varchar_5	varchar(5)	Yes	stores the analysis code from the account based budget component for the passed account code	No
RRHD_SUBANALYSIS_CODE	_varchar_5	varchar(5)	Yes	stores the subanalysis code from the account based budget component for the passed account code	No
RRHD_COMPANY_CODE	_varchar_10	varchar(10)	Yes	stores the company code	No
RRHD_BUSINESS_UNIT	_varchar_10	varchar(10)	Yes	stores the business unit	No
RRHD_CONTROL_ACC_TYPE	_varchar_40	varchar(40)	Yes	stores the Control Account Type from the AS component for the passed account code	No
RRHD_AUTO_POST_ACC_TYPE	_varchar_40	varchar(40)	Yes	stores the Automatic Posting Account Type from the AS component for the passed account code	No
RRHD_ACCT_CURR_CODE	_varchar_5	varchar(5)	Yes	stores the Account Currency Code from the AS component for the passed account code	No
RRHD_FR_ACCPT_DATE	_datetime_8	datetime(8)	Yes	Freeze Acceptance Date	No
RRHD_MV_TO_WORK_CENTER	_varchar_5	varchar(5)	Yes	Move to Work Center (Y/N)	No
RRHD_QUOTEXP_ACC_TYPE	_varchar_25	Varchar(25)	Yes	Acount type	No
RRHD_QUOTEXP_ACC_CODE	_varchar_32	varchar(32)	Yes	account code	No
RRHD_QUOTEXP_AMOUNT	_decimal_28_8	decimal(28)	Yes	Quotation amount	No
RRHD_Gen_Insp_WO	_varchar_75	varchar(75)	Yes	inspection work order required or not Y - Required N - Not required	No
RRHD_Comp_WO_No	_varchar_45	varchar(45)	Yes	Generated work order number	No
RRHD_Insp_WO_Desc	_varchar_75	varchar(75)	Yes	work order description	No
RRHD_Insp_WO_Status	_varchar_15	varchar(15)	Yes	generated Work order status	No
RRHD_COM_No	_varchar_40	varchar(40)	Yes	Component number	No
RRHD_Exe_Comments	_varchar_75	varchar(75)	Yes	Comments	No
RRHD_WAREHOUSE_CODE	udd_warehouse	varchar(10)	Yes	Used to store the Receiving Warehouse.	No
RRHD_REP_QUOTE_ID	fin_lineno	int(4)	Yes	Quotation ID	No

Table Name :	GR_RRLSNO_LOT_SLNO_DTL
Comment :	This Table holds the lot and serial information for each Line Parts.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRLSNO_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit Where the Lot and serial information is entered for the part in a receipt.	Yes
RRLSNO_RR_NO	_varchar_40	varchar(40)	No	This Field holds Repair Receipt Number.	Yes
RRLSNO_PART_LINE_ID	_decimal_10_0	decimal(10)	No	This Field stores the part Line Id ( Sequence no in which part details are stored for the Receipt)	Yes
RRLSNO_LOT_SL_LINE_ID	_decimal_10_0	decimal(10)	No	This field hold the lot serial Line Id. The part could be splitted into multiple lots if it is lot controlled or multiple serials if it is serial controlled or lot and srial controlled. This field stores the Lot line no if it is lot controlled or se	Yes
RRLSNO_ISSUE_LOT_NO	_varchar_40	varchar(40)	Yes	This Field stores the issued lot no.This Field could be null when the issued part is serail controlled or lot & serial controlled.	No
RRLSNO_RECD_LOT_NO	_varchar_40	varchar(40)	Yes	This Field stores the Received Lot No.This Field could be null when the received part is serail controlled or lot & serial controlled.	No
RRLSNO_ISSUE_SERIAL_NO	_varchar_40	varchar(40)	Yes	This Field stores the issued serial no.This Field could be null when the issued part is lot controlled or neither controlled.	No
RRLSNO_RECD_SERIAL_NO	_varchar_40	varchar(40)	Yes	This Field stores the Received serial no.This Field could be null when the received part is lot controlled or neither controlled.	No
RRLSNO_ISSUE_LOT_SL_QTY	_decimal_28_8	decimal(28)	Yes	This field stores the Issued Lot or seial qty quantity.	No
RRLSNO_RECD_LOT_SL_QTY	_decimal_28_8	decimal(28)	Yes	This field stores the received lot or serial quantity.	No
RRLSNO_LOT_UOM	_varchar_10	varchar(10)	No	This field holds Unit in which the Part is received.	No
RRLSNO_SHELF_LIFE	_decimal_28_8	decimal(28)	Yes	The Designed shelf life from Part Admin is stored at Part Level.	No
RRLSNO_SHELF_REJECT_QTY	_decimal_28_8	decimal(28)	Yes	This column holds the reject qty at lot level due to the reason Minimum shelf life defined in part admin.	No
RRLSNO_CERTIFICATE_NO	_varchar_40	varchar(40)	Yes	This Field holds the certificate No based on which the part is accepted.	No
RRLSNO_CERTIFICATE_DATE	_datetime_8	datetime(8)	Yes	This field holds the date when the certificate is issued.	No
RRLSNO_CERTIFICATE_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the certificate type defined in the logistics common master.	No
RRLSNO_CERTIFICATE_AU_NO	_varchar_40	varchar(40)	Yes	This field holds the certifiacte authorisation No.	No
RRLSNO_CERTIFICATE_REM	_varchar_255	varchar(255)	Yes	This field holds the Certificate Remarks which is entered by the User who is entreing the lot and serial info for the part line no and for the receipt.	No
RRLSNO_SYS_TRK_REF_NO	_varchar_40	varchar(40)	Yes	This field holds the System tracking Reference Number entered by the user during the inspection.	No
RRLSNO_CREATEDDATE	_datetime_8	datetime(8)	Yes	This Field holds the date when the lot and serial info is entered initially for the part line and for the receipt.	No
RRLSNO_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the User Name who has entered the lot and serial information for tyhe part line no and for the receipt.	No
RRLSNO_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the Date when the lot and serial info of the part has been modified finally.	No
RRLSNO_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user name who has modified finally the lot and serial info of the part line id and for the receipt.	No
RRLSNO_RO_SEQ_NO	_decimal_10_0	decimal(10)	Yes	repair order sequence no	No
RRLSNO_LAST_PRFDATE_TSI	_datetime_8	datetime(8)	Yes	Last Performed Date TSI	No
RRLSNO_LAST_PRFDATE_TSO	_datetime_8	datetime(8)	Yes	Last Performed Date TSO	No
RRLSNO_UPD_PARAM_FLAG	_varchar_5	varchar(5)	Yes	parameter updated flag holds Y - for updated N - for not updated	No
RRLsno_Expirydate	_datetime_8	datetime(8)	Yes	The date on which the serial number or lot number expires	No
RRLSNO_CERTIFICATE_SUPPLIER_NO	udd_vendorcode	varchar(45)	Yes	Used to store the Supplier Number.	No
RRLSNO_FILENAME	udd_filename	varchar(50)	Yes	Used to store the filename.	No
RRLSNO_ComponentId	udd_componentid	varchar(90)	Yes	This field corresponds to the Componenet id details for the given part	No
RRLSNO_Component_OU	udd_ctxt_ouinstance	int(4)	Yes	This field corresponds to the Componenet Ou for the respective Componenet id details.	No
RRLSNO_SysGen_SerialNo	udd_partserialnumber	varchar(40)	Yes	This field corresponds to the Internaly generated serial number for the given part.	No
RRLSNO_SysGen_LotNo	udd_lotno	varchar(18)	Yes	This field corresponds to the Internaly generated Lot number for the given part.	No
RRLSNO_SysGen_IssSerialNo	udd_partserialnumber	varchar(40)	Yes	Internal Serial number	No
RRLSNO_SysGen_IssLotNo	udd_lotno	varchar(18)	Yes	Internal Lot number	No
RRLSNO_ChangeType	udd_designparamcode	varchar(5)	Yes	To indicate whether it is part number change, serial number change or part and serial number change(PC - Part Change;SC - Serial Change; PSC - Part Serial Change)	No

Table Name :	GR_RRPDT_REPAIR_PT_DTL
Comment :	This entity holds the Receipt part Details. One Receipt may contain more than one part.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRPDT_CREATED_OUINSTANCE	_numeric_28_0	numeric(28)	No	This field holds the Organisation Unit where the Repair receipt Has been created.	Yes
RRPDT_RR_NO	_varchar_40	varchar(40)	No	This Field Contains the Repair Receipt Number which is automatically generated by the system using "Document Numbering Class" component where the number to be genrated for the Repair receipt will be captured.	Yes
RRPDT_PART_LINE_ID	_numeric_28_0	numeric(28)	No	The receipt can be made for more than one part. This field holds part Line Id which is unique Number ,to identify the part received,starting from 1 and incremented by 1.	Yes
RRPDT_RR_LINE_NO	_numeric_28_0	numeric(28)	No	This Field is same as RRpdt_Part_Line_Id and is kept for Future enhancement. Since RR_ Line_No is Non-Editable field,It is stored same sa Part Line id.	No
RRPDT_REP_LINE_NO	_numeric_28_0	numeric(28)	Yes	This Field contains the part Line id when the part was issued for repair. (Ie Repair Order Part Line Id )	No
RRPDT_RR_PART_OUINSTANCE	_numeric_28_0	numeric(28)	Yes	This Field Stores the organisation Unit where the Received part is originally created.	No
RRPDT_REP_PART_NO	_varchar_40	varchar(40)	No	This Field stores the Issued part No.	No
RRPDT_RR_PART_NO	_varchar_40	varchar(40)	No	The Filed stores the recived part no.	No
RRPDT_PART_CONTROL_TYPE	_varchar_5	varchar(5)	Yes	This field holds the control type of the received part to identify whether the part is lot controlled or serial controlled or Lot and Serial Controlled or Neither Controlled. The values for this field could be SN - Serial Controlled. LN - Lot C	No
RRPDT_PART_SHELF_LIFE	udd_quantity	numeric(13)	Yes	The Designed shelf life from Part Admin is stored at Part Level.	No
RRPDT_RR_ISSUE_QTY	_decimal_28_8	decimal(28)	No	This Field holds the issued Number of quantity of the part.	No
RRPDT_RR_PART_COND	_varchar_5	varchar(5)	No	This Field holds the condition of the part Received. The values could be one of the following. O - Overhauled N - New S - Serviceable U - UnServiceable NS - New Surplus	No
RRPDT_RR_PART_PEND_QTY	_decimal_28_8	decimal(28)	No	This field holds pending Number of Quantity to be received.	No
RRPDT_RR_PART_RECD_QTY	_decimal_28_8	decimal(28)	No	This Field holds the Received Number of Quantity	No
RRPDT_RR_PART_UOM	_varchar_10	varchar(10)	No	This Field holds the Unit of measurement in which the part is received.	No
RRPDT_RR_INSPECT_DATE	_datetime_8	datetime(8)	Yes	This Field holds the Date when the Part is inspected.	No
RRPDT_RR_INSPECT_BY	_varchar_30	varchar(30)	Yes	This field holds the User name who has entered the Inspection Information.	No
RRPDT_RR_INSPECT_COMMENTS	_varchar_255	varchar(255)	Yes	This Field stores the comments entered by the Inspecting Person.	No
RRPDT_RR_MOVE_COMMENTS	_varchar_255	varchar(255)	Yes	This Field stores the comments entered when the part is moved to some warehouse.	No
RRPDT_RR_TOT_ISSUE_QTY	_decimal_28_8	decimal(28)	Yes	This Field stores the total issued quantity.	No
RRPDT_RR_TOT_RECPT_QTY	_decimal_28_8	decimal(28)	Yes	This Field Stores the Total Received Quantity.	No
RRPDT_PART_ACCEPT_QTY	_decimal_28_8	decimal(28)	Yes	This Field Holds the accepted Number of quantity after inspection.	No
RRPDT_PART_REJECT_QTY	_decimal_28_8	decimal(28)	Yes	This field stores the rejected number of quantities.	No
RRPDT_PART_MOVED_QTY	_decimal_28_8	decimal(28)	Yes	part moved quantity	No
RRPDT_WH_NO	_varchar_30	varchar(30)	Yes	This fiels holds the warehouse No Where the part is Moved.	No
RRPDT_CREATEDDATE	_datetime_8	datetime(8)	Yes	This filed holds the date when the receipt details stored initially.	No
RRPDT_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user who entered the receipt details.	No
RRPDT_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This Field holds the Date when the receipt detail has been modified finally.	No
RRPDT_MODIFIED_BY	_varchar_30	varchar(30)	No	This Field holds the user who modified the receipt details finally.	No
RRPDT_LINE_STATUS	_varchar_5	varchar(5)	Yes	This field holds the status of the part whether the part is inspected or moved or partially inspected or partilally Moved. The Values in this field can be one of the following. I - Inspected. PI -Partially Inspected. M - Moved	No
RRPDT_DEF_FIN_BOOK	_char_20	char(20)	Yes	Finance Book	No
RRPDT_ACCOUNT_TYPE	_varchar_25	Varchar(25)	Yes	Holds the account type	No
RRPDT_ACCOUNT_CODE	_char_32	char(32)	Yes	Stores the account code from Accoutnt group component	No
RRPDT_ANALYSIS_CODE	_varchar_5	varchar(5)	Yes	stores the analysis code from the account based budget component for the passed account code	No
RRPDT_SUBANALYSIS_CODE	_varchar_5	varchar(5)	Yes	stores the subanalysis code from the account based budget component for the passed account code	No
RRPDT_CONTROL_ACC_TYPE	_varchar_40	varchar(40)	Yes	stores the Control Account Type from the AS component for the passed account code	No
RRPDT_AUTO_POST_ACC_TYPE	_varchar_40	varchar(40)	Yes	stores the Automatic Posting Account Type from the AS component for the passed account code	No
RRPDT_ACCT_CURR_CODE	_varchar_5	varchar(5)	Yes	stores the Account Currency Code from the AS component for the passed account code	No
RRPDT_PEND_RETSUP_QTY	_decimal_28_8	decimal(28)	Yes	Pending Return Quantity	No
RRPDT_ACCT_EXP_AMT	_decimal_28_8	decimal(28)	Yes	Acceptance amount includes TCD	No
RRPDT_FACCEPT_ACC_POST_FLAG	_varchar_1	varchar(1)	Yes	postiong flag - not using now since posting is centralized	No
RRPDT_COMPUTED_COST	_decimal_28_8	decimal(28)	Yes	Computed cost for posting - not using now since posting is centralized	No
RRPDT_COMPUTED_DATE	_datetime_8	datetime(8)	Yes	Computed date	No
RRPDT_Gen_Insp_WO	_varchar_75	varchar(75)	Yes	Work order generation required or not Y - Required N - Not required	No
RRPDT_Comp_WO_No	_varchar_45	varchar(45)	Yes	Generated work order number	No
RRPDT_Insp_WO_Desc	_varchar_75	varchar(75)	Yes	Generated work order description	No
RRPDT_Insp_WO_Status	_varchar_15	varchar(15)	Yes	Generated work order status	No
RRPDT_COM_No	_varchar_40	varchar(40)	Yes	Component number.	No
RRPDT_Exe_Comments	_varchar_75	varchar(75)	Yes	Comments	No
RRPDT_PART_TYPE	udd_flag1	varchar(25)	Yes	This Fields Hold the value C/P/S C - Core Parts Of Repair Order P - Piece/Facility Parts Of Repair Order S - Spare Parts Of Repair Order	No
RRPDT_ACC_POST_FLAG	_varchar_5	varchar(5)	Yes	posting flag D - no posting happened I - posting happend for Acceptance M - posting happened for movement	No
RRPDT_MAINT_TYPE	udd_designparamcode	varchar(5)	Yes	Maintenance Type	No
RRPDT_Core_value	udd_amount	numeric(13)	Yes	Core Value	No
RRPDT_variable_value	udd_amount	numeric(13)	Yes	Variable value	No
RRPMVI_EXPPOLICY	udd_flag	varchar(25)	Yes	Expensing policy	No
RRPMVI_RESDUAL_FLAG	udd_flag	varchar(25)	Yes	Residual flag	No
RRPDT_Mandate_Param	udd_flag2	varchar(25)	Yes	This column holds the information about the parameter value availability	No
RRPDT_REP_COST	fin_amount	numeric(13)	Yes	Repair cost	No
RRPDT_BER_COST	fin_amount	numeric(13)	Yes	BER cost	No
RRPDT_EXCH_FEE	fin_amount	numeric(13)	Yes	Exchange fee	No
RRPDT_NRTN_COST	fin_amount	numeric(13)	Yes	Normal Return cost	No
RRPDT_EXCH_RATE	fin_amount	numeric(13)	Yes	Exchange rate	No
RRPDT_PART_COST	fin_amount	numeric(13)	Yes	Part Cost	No
rrpdt_mncore_cost	udd_amount	numeric(13)	Yes	Main Core cost	No
rrpdt_rtn_cost	udd_amount	numeric(13)	Yes	Return Cost	No
RRPDT_RO_PART_TYPE	udd_type	varchar(25)	No	This field corresponds to the part type defined in part master.	No
RRPDT_RO_PART_NONSTKFLG	udd_model	varchar(20)	No	This field corresponds to the non stockable flag defined in part master.	No
RRPDT_RO_PART_EXPTYPE	udd_type	varchar(25)	No	This field corresponds to the expense type defined in part master.	No
RRPDT_RO_PART_EXPOLICY	udd_designparamcode	varchar(5)	No	This field corresponds to the expense policy defined in part master.	No
RRPDT_RO_PART_LOTNOTYPE	udd_designparamcode	varchar(5)	Yes	This field corresponds to the numbering type for lot as defined in part master.	No
RRPDT_RO_PART_SLNOTYPE	udd_designparamcode	varchar(5)	Yes	This field corresponds to the numbering type for serial as defined in part master.	No
RRPDT_RO_PART_SLNOLOGIC	udd_designparamcode	varchar(5)	Yes	This field corresponds to the serial number generation logic as defined in part master.	No

Table Name :	GR_RRPLII_PT_LT_INSP_INFO
Comment :	This Table holds the Lot level part Inspection Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRPLII_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the organisation Unit where this lot level inspection details entered.	Yes
RRPLII_RR_NO	_varchar_40	varchar(40)	No	This field holds the receipt number for which the inspection has been done.	Yes
RRPLII_PART_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the part line id for which the ispection has been done	Yes
RRPLII_LOT_SL_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the Lot line id ofr which the inspection has been done.	Yes
RRPLII_ACCEPT_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the number of accepted quantity out of the lot quantity.	No
RRPLII_ACCEPT_COND	_varchar_5	varchar(5)	Yes	This field holds the condition of the part while accepting.	No
RRPLII_REJECT_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the rejected quantity out of the lot quantity. This could be Null some time.	No
RRPLII_REJECT_REASON_CODE	_varchar_25	Varchar(25)	Yes	This field holds the reason code, defined in the logistics common master, for which the quantities are rejected.	No
RRPLII_QUAR_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the number of quarantined quantity. This could be Null some time.	No
RRPLII_QUAR_REASON_CODE	_varchar_25	Varchar(25)	Yes	This field stores the reason code for which those quantity of the part are quarantined.	No
RRPLII_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field stores the date when the lot level inspection info of the part and for the lot is entered initially.	No
RRPLII_CREATED_BY	_varchar_30	varchar(30)	Yes	This field stores the User Name who has entered thel inspection info of the part and for the lot initially.	No
RRPLII_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field stores the date when inspection info of the part and for the lot is entered finally.	No
RRPLII_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field stores the user Name who has entered inspection info of the part and for the lot finally.	No

Table Name :	GR_RRPMVI_PT_MOVE_INFO
Comment :	This Table Holds the Part Movemnet details for the Repair receipt

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRPMVI_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the organisation Unit Number where the Movement details entered for the repair receipt.	Yes
RRPMVI_RR_NO	_varchar_40	varchar(40)	No	This field holds the Repair receipt Number for which the repair receipt details entered.	Yes
RRPMVI_PART_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the part line id which is assigned when the part details for the repair receipt is saved.	Yes
RRPMVI_LOT_SL_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the Lot or serial line id which is assigned for each lot or serial when the lot and serial info for the part is eneterd.	Yes
RRPMVI_PO_SCH_ID	_decimal_10_0	decimal(10)	No	This field holds the Ro schedule ID	Yes
RRPMVI_ZONE_ID	_varchar_10	varchar(10)	Yes	This field hold the Zone ID to which the part is moved.	No
RRPMVI_BIN_ID	_varchar_10	varchar(10)	Yes	This field Holds the Bin ID under the Zone ID to which the part is moved.	No
RRPMVI_STATUS	_varchar_25	Varchar(25)	Yes	This field holds the Status of the Movement of the Part under the reapir receipt. This values in this field could be one of the following. M - Moved. PM - Partially Moved	No
RRPMVI_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the Date when the Movement details entered initially for the part.	No
RRPMVI_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the User Name who entered the movement details for the part initially.	No
RRPMVI_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the Date when the Movement details modified finally for the part.	No
RRPMVI_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the User Name who modified the movement details for the part finally.	No
RRPMVI_MOVETOWH	_varchar_40	varchar(40)	Yes	Movement Warehouse	No
RRPMVI_SysGen_Lotno	_varchar_40	varchar(40)	Yes	This field corresponds to the Internaly generated lotnumber for the given part.	No
RRPMVI_PART_VALMETHOD	udd_designparamcode	varchar(5)	Yes	This field corresponds to the part valuation method details.	No
RRPMVI_MOVED_QTY	udd_quantity	numeric(13)	Yes	Moved Quantity	No
RRPMVI_TOSTKSTATUS	udd_desc40	varchar(40)	Yes	To Stock status	No
RRPMVI_MOVETYPE	udd_desc40	varchar(40)	Yes	Movement Type (Binning, Work Center,Ship to Customer, Ship to Suppler-Exchange)	No
RRPMVI_FINALDEST	udd_status	varchar(25)	Yes	Final Destination	No
RRPMVI_OWNERSHIP	udd_designparamcode	varchar(5)	Yes	Trading Partner Type	No
RRPMVI_OWNINGAGENCY	udd_vendorcode	varchar(45)	Yes	Trading Partner Number	No
RRPMVI_OWNINGAGENCYOU	udd_seqno	int(4)	Yes	Trading Partner OU instance	No
RRPMVI_WORKCENTERNO	udd_desc40	varchar(40)	Yes	Work Center Number	No
RRPMVI_WORKORDERNO	udd_desc40	varchar(40)	Yes	Work Order Number	No
RRPMVI_WORKORDERTYPE	udd_flag	varchar(25)	Yes	Work Order Type	No
RRPMVI_BER	udd_designparamcode	varchar(5)	Yes	If BER quantity is greater than 0 and Salvage action is By Operator in RO then this flag will be Y else N	No
RRPMVI_MR_NO	udd_documentno	varchar(40)	Yes	Material request No	No
RRPMVI_MR_LINE_NO	udd_seqno	int(4)	Yes	Material Request Line Number	No
RRPMVI_EXREF_LINENO	udd_seqno	int(4)	Yes	Exchange reference Unique id	No
RRPMVI_MOVTYP_OVERRIDE	udd_designparamcode	varchar(5)	Yes	If defaulted movement type is changed then this flag will be Y	No
RRPMVI_TO_STS_OWNERSHIP	udd_designparamcode	varchar(5)	Yes	the final owner ship of the part which involved in repair	No
RRPMVI_TO_STS_OWNINGAGENCY	udd_vendorcode	varchar(45)	Yes	the owning agency of the part which involved in repair scenario	No
RRPMVI_TO_STS_OWNINGOU	udd_seqno	int(4)	Yes	the owning agency OU	No
RRPMVI_UNIQUEID	udd_seqno	int(4)	Yes	the unique id	No
RRPMVI_MOVE_LINENO	udd_seqno	int(4)	Yes	the movement line no	No

Table Name :	GR_RRPMVI_PT_PENDMOVE_INFO
Comment :	Posting  and  ownership details  will be populated against RR  during  acceptance if the RR is  participating with exchange scenario only.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRPMVI_UNIQUE_ID	udd_seqno	int(4)	No	Unique sequence Number	Yes
RRPMVI_CREATED_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Orgainsation Unit Code	No
RRPMVI_RR_NO	udd_documentno	varchar(40)	Yes	Repair Receipt Number	No
RRPMVI_PART_LINE_ID	udd_seqno	int(4)	Yes	Part Line Number	No
RRPMVI_LOT_SL_LINE_ID	udd_seqno	int(4)	Yes	Serial lot line Number	No
RRPMVI_MOV_LINE_ID	udd_seqno	int(4)	Yes	Move Line Number	No
RRPMVI_MOVETOWH	udd_warehouse	varchar(10)	Yes	Move To Warehouse	No
RRPMVI_ZONE_ID	udd_zone	varchar(10)	Yes	Move to Zone	No
RRPMVI_BIN_ID	udd_bin	varchar(10)	Yes	Move to Bin	No
RRPMVI_STATUS	udd_partstatus	varchar(40)	Yes	Movement Status	No
RRPMVI_PENDMVD_QTY	udd_quantity	numeric(13)	Yes	Pending moved quantity	No
RRPMVI_MOVETYPE	udd_desc40	varchar(40)	Yes	Movement Type	No
RRPMVI_FINALDEST	udd_status	varchar(25)	Yes	Destination (Return to supplier inventory/return to Inventory, Return to customer Inventory)	No
RRPMVI_OWNERSHIP	udd_designparamcode	varchar(5)	Yes	Ownership (Cus-Customer, Own-Owned, Sup-Supplier)	No
RRPMVI_OWNINGAGENCY	udd_vendorcode	varchar(45)	Yes	Owning Agency Number	No
RRPMVI_OWNINGAGENCYOU	udd_ctxt_ouinstance	int(4)	Yes	Owning Agency orgainsation OU	No
RRPMVI_TOSTKSTATUS	udd_partstatus	varchar(40)	Yes	To stock status	No
RRPMVI_WORKCENTERNO	udd_desc40	varchar(40)	Yes	Work center Number	No
RRPMVI_WORKORDERNO	udd_desc40	varchar(40)	Yes	Work order Number	No
RRPMVI_WORKORDERTYPE	udd_flag	varchar(25)	Yes	Work order Type	No
RRPMVI_BER	udd_designparamcode	varchar(5)	Yes	Beyond economic repair quantity	No
RRPMVI_MR_NO	udd_documentno	varchar(40)	Yes	Material request Number	No
RRPMVI_MR_LINE_NO	udd_seqno	int(4)	Yes	Material request line Number	No
RRPMVI_EXREF_LINENO	udd_seqno	int(4)	Yes	Exchange reference Number	No
RRPMVI_ACCP_AMT	udd_amount	numeric(13)	Yes	Accepted Amount	No
RRPMVI_PART_COST	udd_amount	numeric(13)	Yes	Part cost	No
RRPMVI_MOVED_FLAG	udd_designparamcode	varchar(5)	Yes	Moved Flag	No
RRPMVI_CREATEDDATE	udd_datetime	varchar(30)	Yes	Created Date	No
RRPMVI_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	Created BY	No

Table Name :	GR_RRPPD_PT_POS_DTL
Comment :	This table holds the Sub component details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRPPD_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the organisation unit where the Part position details has been entered.	Yes
RRPPD_RR_NO	_varchar_40	varchar(40)	No	This field holds the Repair receipt Number for which the part position details has been entered.	Yes
RRPPD_PART_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the part line id for which this part position details has been entered.	Yes
RRPPD_LOT_SL_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the Serial line id for which the part position details has been entered.	Yes
RRPPD_PRT_POS_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the part position line id for which the details has been entered.	Yes
RRPPD_PRT_POS_CODE	_varchar_70	varchar(70)	Yes	This field contains Part- position code	No
RRPPD_PRT_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field contains organisation unit where part is originally created.	No
RRPPD_PRT_NO	_varchar_40	varchar(40)	Yes	This field holds the part number.	No
RRPPD_PRT_SL_NO	_varchar_40	varchar(40)	Yes	This filed holds serial No.	No
RRPPD_PRT_SL_COND	_varchar_25	Varchar(25)	Yes	This filed holds the part condition	No
RRPPD_CERTIFICATE_NO	_varchar_40	varchar(40)	Yes	This field contains the certificate Number	No
RRPPD_CERTIFICATE_DATE	_datetime_8	datetime(8)	Yes	This field contains the certificate date.	No
RRPPD_CERTIFICATE_TYPE	_varchar_25	Varchar(25)	Yes	This field contains certificate Type defined in the logistics common master.	No
RRPPD_CERTIFICATE_AU_NO	_varchar_40	varchar(40)	Yes	This field holds the certificate authorisation Number.	No
RRPPD_SYS_TRK_REF_NO	_varchar_40	varchar(40)	Yes	This filed holds the system tracking reference Number	No
RRPPD_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the part position details has been entered initially.	No
RRPPD_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user name who entered the part position details initially.	No
RRPPD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the part position details modified finally .	No
RRPPD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user name who modified the part position details finally.	No
RRPPD_LAST_PRFDATE_TSI	_datetime_8	datetime(8)	Yes	Last updated date - TSI	No
RRPPD_LAST_PRFDATE_TSO	_datetime_8	datetime(8)	Yes	Last updated date - TSO	No
RRPPD_UPD_PARAM_FLAG	_varchar_5	varchar(5)	Yes	Parameter flag holds Y - if updated N - not updated	No

Table Name :	GR_RRPRD_PT_REF_OBJ_DTL
Comment :	This table holds the part level reference document details for the repair receipt.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRPRD_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Ubit Number where the part level reference document details entered.	Yes
RRPRD_RR_NO	_varchar_40	varchar(40)	No	This field holds the repair receipt number for which the part is received.	Yes
RRPRD_PART_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the part line id which is assigned which updating the Repair receipt part details.	Yes
RRPRD_DOC_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the document line id given for each document which is referenced.	Yes
RRPRD_REF_DOC_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the Reference Document Type defined in the logistics common master.	No
RRPRD_REF_DOC_ID	_varchar_40	varchar(40)	Yes	This field holds the Reference Document ID entered for the document which is referred while receiving the part under the Repair receipt.	No
RRPRD_REF_DOC_FILE_NAME	_varchar_50	varchar(50)	Yes	This filed stores the file name of the document which is referenced.	No
RRPRD_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field hiolds the date when the part level reference document details entered initially.	No
RRPRD_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the User Name who entered the part level reference document detail initially.	No
RRPRD_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field hiolds the date when the part level reference document details modified finally.	No
RRPRD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the User Name who modified the part level reference document detail finally.	No

Table Name :	GR_RRPSII_PT_SL_INSP_INFO
Comment :	This table holds the Inspection Information of the serial controlled parts.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRPSII_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the organisation unit where the serial level inspection info is entered.	Yes
RRPSII_RR_NO	_varchar_40	varchar(40)	No	This field holds the receipt number for which the serial level inspection info has been entered.	Yes
RRPSII_PART_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the Part line id for which the serial level inspection info is entered	Yes
RRPSII_LOT_SL_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the serial line id for which the serial level inspection info is entered	Yes
RRPSII_INSPECT_RESULT	_varchar_5	varchar(5)	Yes	This field holds the Inspection Result for the serial line id. The value of this field may obtain one of the following. A - Accepted R - Rejected Q - Quantined	No
RRPSII_INSPECT_COND	_varchar_5	varchar(5)	Yes	This field holds the condition of the inspected part. This could be one of the following if the part type is component . N - New O - Overhauled S - Serviceable U - Unserviceable. Else N - New NS - New Surplus	No
RRPSII_REASON_CODE	_varchar_25	Varchar(25)	Yes	This field holds the Reason code , defined in the logistics common master , for which the serial is rejected.	No
RRPSII_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the serial inspection information is entered initially.	No
RRPSII_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the User Name who has entered the serial inspection details for the serial line id , part line id and for the receipt.	No
RRPSII_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when serail inspection info has been modified finally for the serila line Id , part line id and for the receipt.	No
RRPSII_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the User name who has modified the seilal inspection info finally for the serial line id , part line id and for the receipt Number.	No
RRPSII_RecordUpdate	udd_designparamcode	varchar(5)	Yes	status of the technical records update corresponding to the serial number being inspected	No
RRPSII_COMPONENT_ID	udd_componentid	varchar(90)	Yes	This field corresponds to the Componenet id details for the given part	No
RRPSII_COMPONENT_OU	udd_ctxt_ouinstance	int(4)	Yes	This field corresponds to the Componenet Ou for the respective Componenet id details.	No
rrpsii_compliance_update_flag	udd_chkflag	varchar(1)	Yes	the flag is updated-Y when compliance temp table is populated or updtaed as N	No
RRPSII_PRTSRL_CHANGE	udd_designparamcode	varchar(5)	Yes	Part Serial change applicable	No
RRPSII_DEVIATED_PARTQ	UDD_BIT	bit(1)	Yes	Deviated part flag(1-Yes;0-No)	No
RRPSII_DEVIATED_COMMENTS	udd_txt2000	varchar(2000)	Yes	Deviated comments	No

Table Name :	GR_RRPSPI_PT_SL_PARM_INFO
Comment :	This table holds the Parameter details for the part of type component.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRPSPI_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This fiels holds the organisation Unit where the parameter details entered for the part (of type component) ,serial line id, Param line id.	Yes
RRPSPI_RR_NO	_varchar_40	varchar(40)	No	This field stores the Repair receipt Number for which the component parameter details has been entered.	Yes
RRPSPI_PART_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the Part Line Id for which the parameter details has been entered.	Yes
RRPSPI_LOT_SL_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the serial line id for which the parameter details has been entered.	Yes
RRPSPI_PARAM_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the parameter Line id for which the details has been entered.	Yes
RRPSPI_AC_PARAM_CODE	_varchar_40	varchar(40)	Yes	This Field holds Range and consumption parameter code of the component ( Part and serial No combination). ( Like FC,FH,EC,EH) FC - Flight Cycles, FH - Flight Hours EC - Engine Cycles, EH - Engine Hours	No
RRPSPI_SINCE_INSPECT	_decimal_28_8	decimal(28)	Yes	This field holds the Number of counts for the parameter that happened since the component is inspected. For example For parameter FC - Since Inspect- 20 means Since the component is inspected 20 flight cycles this component has been functioned i	No
RRPSPI_SINCE_NEW	_decimal_28_8	decimal(28)	Yes	This field holds the Number of counts that happened since the component is New	No
RRPSPI_SINCE_OVERHAUL	_decimal_28_8	decimal(28)	Yes	This field holds the Number of counts that happened since the component is Overhauled	No
RRPSPI_SINCE_REPAIR	_decimal_28_8	decimal(28)	Yes	This field holds the Number of counts that happened since the component is Repaired	No
RRPSPI_SINCE_SHOP_VISIT	_decimal_28_8	decimal(28)	Yes	This field holds the Number of counts that happened since the component is Visited the shops for the correction.	No
RRPSPI_WARR_VAL	_decimal_28_8	decimal(28)	Yes	This field holds the warranty value if any for the component.	No
RRPSPI_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the parameter details entered initially.	No
RRPSPI_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the User name who entered the parameter details for the part and serial no initilally.	No
RRPSPI_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the parameter details modified finally.	No
RRPSPI_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the User Name who modified the parameter details finally.	No
RRPSPI_UOM	_varchar_10	varchar(10)	Yes	Transaction UOM	No
RRPspi_Unknown	_varchar_5	varchar(5)	Yes	Unknown	No

Table Name :	GR_RRROD_REF_OBJ_DTL
Comment :	This table Holds the Refrence document details for the Repair receipt.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRROD_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the organisation Unit Number where the refterce document details for the Repair receipt Is entered.	Yes
RRROD_RR_NO	_varchar_40	varchar(40)	No	This field holds the Repair Receipt Number for which the Reference document details has been entered.	Yes
RRROD_DOC_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the Document Line ID which is unique given for each document Referenced.	Yes
RRROD_REF_DOC_TYPE	_varchar_25	Varchar(25)	Yes	This field Holds the Reference Document Type defined in the logistics common master.	No
RRROD_REF_DOC_ID	_varchar_40	varchar(40)	Yes	This field Holds the Document ID entered for each document.	No
RRROD_REF_DOC_FILE_NAME	_varchar_50	varchar(50)	Yes	This field Holds the File Name of the Document.	No
RRROD_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field stores the date when the reference document details entered initially for the Repair receipt.	No
RRROD_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the User Name who entered reference document details initially for the reapir receipt.	No
RRROD_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field stores the date when the reference document details modified finally for the Repair receipt.	No
RRROD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the User Name who modified the reference document details finally for the reapir receipt.	No

Table Name :	GR_RRSPI_SUB_PARM_INFO
Comment :	This table holds the sub component s parameter information.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRSPI_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the organisation Unit number where repair receipt created.	Yes
RRSPI_RR_NO	_varchar_40	varchar(40)	No	This field holds the Repair receipt Number under which the parent component is received.	Yes
RRSPI_PART_LINE_ID	_decimal_10_0	decimal(10)	No	This field Holds the part Line id which is captured whiile updating the receipt part details .	Yes
RRSPI_LOT_SL_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the Serial Line Id which is captured while updating Lot and seial info for the part received.	Yes
RRSPI_PRT_POS_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the Part and position no as concatenated value.	Yes
RRSPI_PARAM_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the Parameter Line ID unique for each parameter for the sub component.	Yes
RRSPI_AC_PARAM_CODE	_varchar_40	varchar(40)	Yes	This field holds the parameter code	No
RRSPI_SINCE_INSPECT	_decimal_28_8	decimal(28)	Yes	This field holds the value for the parameter (say flight cycles). how many flight cycles it has been functioned from the point of time when it is finally inspected.	No
RRSPI_SINCE_NEW	_decimal_28_8	decimal(28)	Yes	This field holds the value for the parameter (say flight cycles). how many flight cycles it has been functioned from the point of time when it is purchased freshly.	No
RRSPI_SINCE_OVERHAUL	_decimal_28_8	decimal(28)	Yes	This field holds the value for the parameter (say flight cycles). how many flight cycles it has been functioned from the point of time when it is finally overhauled.	No
RRSPI_SINCE_REPAIR	_decimal_28_8	decimal(28)	Yes	This field holds the value for the parameter (say flight cycles). how many flight cycles it has been functioned from the point of time when it is finally Got repaired	No
RRSPI_SINCE_SHOP_VISIT	_decimal_28_8	decimal(28)	Yes	This field holds the value for the parameter (say flight cycles). how many flight cycles it has been functioned from the point of time when it is finally visited to shop	No
RRSPI_WARR_VAL	_decimal_28_8	decimal(28)	Yes	This field holds the warranty value for the component.	No
RRSPI_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the Date when the sub component s parameter details entered initailly.	No
RRSPI_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user name who entered the parameter details for the sub component initially.	No
RRSPI_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the Date when the sub component s parameter details modified finally.	No
RRSPI_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user name who modified the parameter details for the sub component finally.	No
RRSPI_UOM	_varchar_10	varchar(10)	Yes	transaction UOM	No

Table Name :	GR_RRSWI_SUB_WARR_INFO
Comment :	This table contains the sub component warranty info

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRSWI_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation unit where the sub component warranty info has been entered.	Yes
RRSWI_RR_NO	_varchar_40	varchar(40)	No	This field holds the Repair receipt number for the sub component parameter info has been entered.	Yes
RRSWI_PART_LINE_ID	_decimal_10_0	decimal(10)	No	This field hols the part line id for which the info has been entered.	Yes
RRSWI_LOT_SL_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the serial line id for which the info has been entered.	Yes
RRSWI_PRT_POS_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the part position line id for which the sub component info has been entered.	Yes
RRSWI_WARR_PARENT_FLAG	_varchar_5	varchar(5)	Yes	This field contains whether the parent component has warranty. The values could be one of the following Y - Yes N - No	No
RRSWI_WARR_UNDER_FLAG	_varchar_5	varchar(5)	Yes	This field holds info whether the sub component is under warranty or Not The values could be one of the following Y - Yes N - No	No
RRSWI_WARR_NUMBERING_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Numbering type to genrate warranty info for the sub component.	No
RRSWI_WARR_CATEGORY	_varchar_25	Varchar(25)	Yes	This field holds warranty category of the sub component which is defined inthe logistics common master.	No
RRSWI_WARR_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the warranty type define d in the logistics common master.	No
RRSWI_WARR_START_DATE	_datetime_8	datetime(8)	Yes	This field holds the start date of the warranty for the sub component.	No
RRSWI_WARR_DURATION	_decimal_28_8	decimal(28)	Yes	This field holds the duaration period since the warranty start date.	No
RRSWI_WARR_DURATION_UNIT	_varchar_5	varchar(5)	Yes	This field holds the warranty duration unit The values could be one of the following M- Months W- Weeks D- Days Y-Years	No
RRSWI_WARR_REMARKS	_varchar_255	varchar(255)	Yes	This field contains the remarks entered when the warranty info is genrated for the sub component.	No
RRSWI_CREATEDDATE	_datetime_8	datetime(8)	Yes	Thios field holds date when the sub component s warranty info is entered initially.	No
RRSWI_CREATED_BY	_varchar_30	varchar(30)	Yes	This field contains the user name who has entered the sub component s warranty info initially.	No
RRSWI_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the Date when the sub component s warranty info has been modified finally.	No
RRSWI_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user name when the sub compoenet s warranty info has been modified finally.	No
RRSWI_WARR_START_BASIS	_varchar_5	varchar(5)	Yes	Warranty Begins On - Installation Date (ID) and Receipt Date (RD)	No