Goods Receipt

Table Name GR_DTcdAP_DocTcd_Apportioned

Table Comment This table is used to store the apportioning data, i.e. if PO or GR has document level tcd and that GR has two line items and if one line item was going to be accepted then only one portion of that tcd ( for the particular part which freeze acceptance is done) alone has to be calculated and moved to stock. this has done in the apportioning logic. this was handled in freeze acceptance success ( above the finance posting)

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

DTcdAP_PartlineId

int

NOT NULL

Gr Part Line Number

No

No

DTcdAP_DTcdlineid

int

NOT NULL

Gr document Tcd Line number

DTcdAP_tcdamount_bas

bigint

NULL

tcd base amount

DTcdAP_tcdamount_par

bigint

NULL

Total tcd amount in parallel base currency

DTcdAP_ApportVal_Bas

bigint

NULL

Approved amount (accepted amount) of the total tcd amount in base currency

DTcdAP_ApportVal_Par

bigint

NULL

Approved amount (accepted amount) of the total tcd amount in parallel base currency

DTcdAP_Accrule

sql_variant

It holds the value of account rule E.g. data’s Add to stock - ATS Expense off - E

DTcdAP_Recover_Bas

bigint

The amount Recovered through TCD in base currency ( i.e if discount is tcd and wat is actual amount we recovered through that tcd)

DTcdAP_Recover_Par

bigint

The amount Recovered through TCD in parallel base currency ( i.e if discount is tcd and wat is actual amount

DTcdAP_NonRecover_Bas

bigint

The amount which not Recovered through TCD in base currency ( i.e if discount is tcd and what is actual amount )

DTcdAP_NonRecover_Par

bigint

The amount which not Recovered through TCD in parallel base currency ( i.e if discount is tcd and wat is actual amount )

DTCDAP_TCDAMOUNT_TRN

bigint

TCD amount in Transaction

DTCDAP_APPORTVAL_TRN

bigint

Approved TCD amount in Transaction

DTCDAP_NONRECOVER_TRN

bigint

Non - recovered TCD amount in Transaction

DTCDAP_RECOVER_TRN

bigint

Recovered TCD amount in Transaction

DTcdAP_GR_No

sql_variant

Gr Document number

DTcdAP_GR_Ou

int

Gr Document ou

DTcdAP_TCD_CODE

sql_variant

NOT NULL

TCD code used for that GR

DTcdAP_TCD_VARIANT

sql_variant

NULL

TCD variant of that TCD code used for that GR

dtcdap_base_exchg_rate

udd_amount

Store the exchange rate value

dtcdap_tcdamount

udd_amount

Store the tcd apportioned amount

dtcdap_apportval

udd_amount

Store the apportion value

Table Name GR_GRCWi_Comp_Warr_info

Table Comment This table holds the component’s warranty details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRCWi_Warr_Duration_Unit

varchar(10)

NULL

This field holds the duration Unit. This field may obtain one of the following values. M- Months. W-Weeks Y- Years D-Days

No

No

GRCWi_Warr_Remarks

varchar(255)

This field holds the remarks entered when the component’s warranty detail is entered.

GRCWi_Warr_Duration

decimal(28,8)

This field holds the Duration of the warranty since the warranty start date.

GRCWi_Warr_Start_Date

datetime

This field holds the warranty start date

GRCWi_Modified_By

varchar(30)

This field holds the User Name who entered the warranty info of the component finally.

GRCWi_CreatedDate

datetime

This field holds the date when the Warranty info of the component is entered initially.

GRCWi_ModifiedDate

datetime

This field holds the date when the Warranty info of the component is modified finally.

GRCWi_Created_By

varchar(30)

This field holds the User Name who entered the warranty info of the component initially.

GRCWI_WARR_START_BASIS

varchar(5)

Warranty Begins On - Installation Date (ID) and Receipt Date (RD)

GRCWi_GR_No

varchar(40)

NOT NULL

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created, as per the numbering type specified.(Foreign key reference)

Yes

Yes

GRCWi_Part_Line_Id

numeric(10)

The Grline number is an id which uniquely identifies the Document line no and its associated part details.

GRCWi_Created_Ouinstance

numeric(10)

This is the OU Instance Id where the goods receipt document is created. (Foreign key reference)

GRCWi_Warr_Type

varchar(25)

NULL

This field holds the Warranty Type defined in the logistics common master.

No

No

GRCWi_Warr_Category

varchar(25)

NULL

This field holds the Warranty category which is defined in logistics common master.

GRCWi_Lot_Sl_Line_Id

numeric(10)

NOT NULL

This field holds the line id (maintained internally) to identify a particular combination of LotNo and Serial No at any point of time.

Yes

Yes

GRCWi_Warr_Numbering_Type

varchar(5)

NULL

This field holds the Warranty Numbering type to generate a new warranty for the component which is defined in the Document Numbering class component.

No

No

GRCWi_Warr_Under_Flag

varchar(5)

NULL

This field holds the info whether the component is under warranty or Not. The values in this field could be one of the following. Y - Yes N - No

Table Name GR_GRDMvi_Doc_Move_info

Table Comment This table holds the movement info of each part number The following columns are storing paramcodes whose description is available in GR_Parameter_details table. 1.Dmvi_status

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRDMvi_Modified_By

varchar(30)

NULL

This field holds the login id of the modified record &nbspfor auditing purpose.

No

No

GRDMvi_WH_OU

numeric(10)

used to store Warehouse Created OU

GRDMvi_Part_Cost

numeric(28,8)

This field used to store the stock cost .

GRDMvi_ModifiedDate

datetime

This field holds the record modified date for auditing purpose.

GRDMvi_Created_By

varchar(30)

This field holds the login id of the record for auditing purpose.

GRDMvi_CreatedDate

datetime

This field holds the record created date for auditing purpose.

GRDMVI_WORKCENTER_OU

numeric(10)

OUInstance of Work Center

GRDMVI_WORKCENTER_NO

varchar(30)

Work Center Number

GRDMvi_Qtyin_SUOM

numeric(28,8)

Used to store Moved Quantity in stock UOM.

GRDMVI_SCH_STATUS

varchar(5)

Schedule Status

GRDMVI_MAT_REQ_OU

numeric(10)

OUInstance of Material Request

GRDMVI_PEND_QTY

numeric(28,8)

Pending quantity to be moved

GRDMVI_MOVE_TO

varchar(5)

Move to : Warehouse/Work Center

GRDMVI_MOVE_LINE_ID

numeric(10)

NOT NULL

ID which uniquely identifies movement line

Yes

GRDMVI_MR_LINE_NO

numeric(10)

NOT NULL

Line no of the pegged material request

GRDMVI_MR_SUB_LINE_NO

numeric(10)

NOT NULL

Sub Line no of the pegged material request

GRDMvi_Created_Ouinstance

numeric(10)

NOT NULL

This is the OU Instance Id where the goods receipt document is created.(Foreign key reference)

Yes

GRDMvi_Part_Line_Id

numeric(10)

NOT NULL

The Grline number is an id which uniquely identifies the Document line no and its associated part details. Clarification required from RGG for the generation of the numbers.

GRDMvi_GR_no

varchar(40)

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created,as per the numbering type specified.(Foreign key reference)

GRDMvi_Status

varchar(40)

NULL

This field is to capture one of the status values defined for the transaction type GR in the UDSS component.

No

No

GRDMvi_Bin_Id

varchar(10)

This field is to capture the zone information of the warehouse. It should satisfy the following conditions: 1.If the Zone is "free", Bin # can be null. If Zone is "normal" then check if the Bin # entered is valid for the corresponding Zone # from the storage admin component 2. bin status to be "active"

GRDMvi_Zone_Id

This field is to capture the zone information of the warehouse. It should satisfy the following conditions: 1.if the warehouse is "Free" Zone # can be null, if warehouse is "Normal" then check if the zone # entered is valid for the corresponding warehouse # from the storage admin component. 2. zone status to be  "active"

GRDMVI_MAT_REQ_NO

varchar(40)

NOT NULL

Material Request Number

Yes

GRDMvi_Doc_Move_Qty

decimal(28,8)

NULL

This field is to capture the moved quantity at GR Line # Level. It should satisfy the following conditions. 1.Moved qty can not be null 2.Moved qty can not be greater than the pending qty. 3.Moved qty can not be negative 4."moved quantity" must be equal to "accepted quantity"

No

GRDMvi_Warehouse_Id

varchar(10)

This field captures the warehouse at the GRLINE # level. It should satisfy the following conditions. 1.warehouse # can not be null 2.Warehouse is modifiable only if the warehouse modifiable field is set to yes in the system parameters 3.Warehouse is modifiable only if the parts for which warehouse details are modified are not dispositionable.

GRDMvi_Po_Sch_Id

numeric(10)

purchase order schedule id

Table Name GR_GRDTcd_Doc_TCD_dtl

Table Comment This table holds the tcd document level details of Goods Receipt . The following columns are storing paramcodes whose description is available in GR_Parameter_details table. 1.DTcd_suppliertype

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRDTcd_Doc_Tcd_SeqNo

numeric(10)

NULL

stores the user entered sequence number

No

No

GRDTcd_exchg_rate

numeric(28,8)

Holds the exchange rate between the document currency and the payment currency

GRDTcd_Account_Type

varchar(25)

Holds the account type

GRDTcd_ModifiedDate

datetime

NOT NULL

This field holds the record modified date for auditing purpose.

GRDTcd_PORSCpy_Flag

varchar(5)

NULL

Copy flag

GRDTcd_Modified_By

varchar(30)

NOT NULL

This field holds the login id of the modified record for auditing purpose.

GRDTcd_Created_By

This field holds the login id of the record for auditing purpose.

GRDTcd_Auto_Post_Acc_Type

varchar(40)

NULL

stores the Automatic Posting Account Type from the AS component for the passed account code

GRDTcd_Acct_Curr_Code

varchar(5)

stores the Account Currency Code from the AS component for the passed account code

GRDTcd_Account_Code

char(32)

Stores the account code from Account group component

GRDTcd_Analysis_Code

varchar(5)

stores the analysis code from the account based budget component for the passed account code

GRDTcd_Control_Acc_Type

varchar(40)

stores the Control Account Type from the AS component for the passed account code

GRDTcd_SubAnalysis_Code

varchar(5)

stores the subanalysis code from the account based budget component for the passed account code

GRDTCD_COST_CENTER

varchar(40)

stores the cost center for the specified account code

GRDTcd_TCD_OU

numeric(10)

TCD OU taken from TCD Component for TCD Calculation purpose

GRDTcd_TCD_Code

varchar(25)

This field is to capture the TCD code at document level. It needs to be validated with the TCD component

GRDTcd_TCD_Var

varchar(25)

This field is to capture the TCD variant at document level. It needs to be validated with the TCD component

GRDTcd_Created_Ouinstance

numeric(10)

NOT NULL

This is the OU Instance Id where the goods receipt document is created.

Yes

Yes

GRDTcd_Doc_TCD_Line_Id

numeric(10)

NOT NULL

This is the internal TCD id to identify uniquely a particular TCD line at document level

No

GRDTcd_GR_No

varchar(40)

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created,as per the numbering type specified.

Yes

GRDTcd_CreatedDate

datetime

This field holds the record created date for auditing purpose.

No

No

GRDTcd_Supplier_Type

varchar(5)

NULL

The supplier type and the supplier code should match as per the definition in the supplier component that the Gr component interacts with. [Document level TCD amounts can be paid to other suppliers apart from default supplier eg Payment of Freight charges.]

GRDTcd_Supplier_Ouinstance

numeric(10)

This column holds the supplier ouinstance even though the component cardinality GR:Supplier is N:1 to avoid joins with the views in CIM. [Document level TCD amounts can be paid to other suppliers apart from default supplier eg Payment of Freight charges.]

GRDTcd_Pay_Currency

varchar(20)

This field is to capture the payment currency associated with the supplier. [Document level TCD amounts can be paid to other suppliers apart from default supplier eg Payment of Freight charges.]

GRDTCD_CURRENCY

stores the currency

GRDTcd_TCD_Rate

decimal(28,8)

This field is to capture the TCD rate at document level. It needs to be validated with the TCD component

GRDTcd_Supplier_No

varchar(45)

This field is to capture the supplier code from the user. The supplier code entered is validated in the supplier component that the GR component interacts with. [Document level TCD amounts can be paid to other suppliers apart from default supplier eg Payment of Freight charges.]

GRDTcd_TCD_Amt

decimal(28,8)

This field is to capture the TCD amount at document level. It needs to be validated with the TCD component

Table Name GR_GRHd_Goods_Receipt_hdr

Table Comment This table holds the document level attributes for the GOODS_RECEIPT. The following columns are storing paramcodes whose description is available in GR_Parameter_details table. 1.Dhr_grtype 2.Dhr_refdoc 3.Dhr_docstatus

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRHd_Created_Ouinstance

numeric(10)

NOT NULL

This is the OU Instance Id where the goods receipt document is created.

Yes

No

GRHd_GR_No

varchar(40)

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created,as per the numbering type specified.

GRHd_GR_Date

datetime

’GR date" is the user entered date which should satisfy the following boundary conditions. 1."GR date" cannot be earlier than the "Ref document date","Delivery Note date ", "Way bill date " and  "Gate Pass date " 2."GR date" cannot be greater than the system date 3.GR date cannot be outside the time range specified for delayed/advanced delivery as per GR system parameter.

No

GRHd_GR_Userstatus

varchar(25)

NULL

This field is to capture one of the User Status values defined under the quick codes of the type User Status, in this component.

GRHd_GR_Type

varchar(5)

This field is to capture one of the Document type values. The allowed values are as follows 1) BasPo - PoType 2) BASRSS - RssType 3) BasSubconorder - SerType

GRHd_GR_Category

varchar(25)

This field is to capture one of the GR category values defined under the quick codes of the type Category, in this component.

GRHd_PO_RS_Doc_Flag

varchar(5)

NOT NULL

This field is to capture one of the reference document values . Values allowed 1.PO 2.RS 3.SCO

GRHd_PO_RS_Ouinstance

numeric(10)

NULL

This field is to capture the PO/RS OU for the given PO/RS # . Component Cardinality:  GR:PO  N:M  GR:RS  N:M Document Cardinality: GR:PO  N:1  GR:RS  N:1

GRHd_PO_RS_Doc_No

varchar(40)

NOT NULL

This field is to capture the Purchase Order No/Release Slip No . 1.If the PO/RS/SCO document has not undergone amendment, the status should be either ’Open’ or ’NTClosed’ 2. If the PO/RS/SCO document has undergone amendment, latest amended details to be fetched which is in ’OPEN’ status

GRHd_PO_RS_Date

datetime

This field holds the PO/RS document creation date. Boundary conditions: 1."GR Date" cannot be earlier than ""Ref document date". 2."Ref document date" cannot be greater than system date.

GRHD_SP_LOC_OUINSTANCE

numeric(10)

NULL

Supplier location OU Instance

GRHd_Supplier_Ouinstance

This column holds the supplier ouinstance even though the component cardinality GR:Supplier is N:1 to avoid joins with the views in CIM.

GRHd_PO_RS_Amend_No

This field holds the maximum amendment no of either the PO/RS document if the document has already been amended. If it has not undergone amendment,the amendment no value will be 0.

GRHd_Supplier_No

varchar(45)

NOT NULL

This field holds the supplier code associated with the PO(PurchaseOrder)/RS(ReleaseSlip) document.

GRHd_Delivery_Note_No

varchar(40)

This field is to hold the DeliveryNote entered by the user

GRHD_DELIVERY_NOTE_NO_UP

NULL

This field is to hold the DeliveryNote entered by the user in upper case - ORACLE

GRHd_Delivery_Note_Date

datetime

NOT NULL

This field is to hold the Delivery Date of Goods Receipt 1."Delivery Note date" cannot be earlier than the "ref. Document date" 2.Gr date cannot be earlier than "Delivery Note date "

GRHd_Way_Bill_No

varchar(40)

This field holds the way billno entered by the user.

GRHD_WAY_BILL_NO_UP

varchar(40)

NULL

This field holds the way billno entered by the user, in upper case

GRHd_Way_Bill_Date

datetime

NOT NULL

This field is to capture the way bill date which satisfy the following boundary conditions. 1.Gr date cannot be earlier than "Way bill date" 2."Delivery Note date" should be earlier than or equal to the "Way bill date"

GRHd_Gate_Pass_No

varchar(40)

NULL

This field holds the Gate Pass Number for the Goods Received. It is entered by the user.

GRHd_Gate_Pass_Date

datetime

This field holds the Gate Pass Date which satisfy the following boundary conditions 1.Gr date cannot be earlier than "Gate Pass date " 2."Delivery Note date" should be earlier than or equal to the "Gate pass date"" 3."Gate Pass Date" cannot be earlier than the "ref. Document date" 4."Way bill date" should be earlier than or equal to the "Gate pass date""

GRHd_No_Of_Packs

numeric(10)

This field holds the number of packs of the goods received."No of packs" should be greater than Zero. It can be null.

GRHd_Consign_Weight

decimal(28,8)

This field holds the "consignment weight" details of the goods received."consignment weight" should be greater than zero. It can be null.

GRHd_Inspect_Date

datetime

This field holds the date of inspection of the goods received. When the goods receipt is created,it holds null value. This column gets filled during the inspection Boundary conditions: 1.Inspected date should be greater than GR date 2.Inspected date should be greater than freeze receipt date.

GRHd_Consign_Weight_UOM

varchar(10)

This column is to hold consignment weight UOM (It got added recently because of UI change from RGG)

GRHd_Inspect_Remarks

varchar(255)

This column holds the remarks details of the inspected goods.

GRHd_Doc_TCD_Amt

decimal(28,8)

This field is the summation of all Doc level tcd amounts associated with the document

GRHd_Doc_Status

varchar(15)

NOT NULL

This is the status of the GR document. The allowed values are 1.Received 2.Receipt frozen 3.partially Inspected 4.Inspected 5.partially moved 6.Moved 7.returned 8.cancelled 9.Rejected

GRHd_comments

varchar(255)

NULL

this field stores the comment entered in the good receipt

GRHd_CreatedDate

datetime

NOT NULL

This field holds the record created date for auditing purpose.

GRHd_Created_By

varchar(30)

This field holds the login id of the record for auditing purpose.

GRHd_ModifiedDate

datetime

This field holds the record modified date for auditing purpose.

GRHd_Modified_By

varchar(30)

This field holds the login id of the modified record for auditing purpose.

GRHd_Timestamp

numeric(10)

This field holds the timestamp for concurrency check.

GRHD_FRECEIPT_DATE

datetime

NULL

Freeze Receipt Date

GRHD_FACCEPT_DATE

Freeze Acceptance Date

GRHd_Def_Fin_Book

char(20)

This field stores the default finance book from Account group component

GRHd_Account_Type

varchar(25)

Holds the account type eg: SUPPSUSP

GRHd_Account_Code

char(32)

Stores the account code from Account group component

GRHd_Analysis_Code

varchar(5)

stores the analysis code from the account based budget component for the passed account code

GRHd_SubAnalysis_Code

varchar(5)

stores the subanalysis code from the account based budget component for the passed account code

GRHd_Company_Code

varchar(10)

stores the company code from the EMOD component

GRHd_Business_Unit

varchar(10)

stores the business unit from the EMOD component

GRHd_Control_Acc_Type

varchar(40)

stores the Control Account Type from the AS component for the passed account code

GRHd_Auto_Post_Acc_Type

varchar(40)

stores the Automatic Posting Account Type from the AS component for the passed account code

GRHd_Acct_Curr_Code

varchar(5)

stores the Account Currency Code from the AS component for the passed account code

GRHd_GR_NumType

GR Numbering type stored for passing it on to workflow as a parameter

GRHD_Com_No

varchar(40)

Component number generated for that particular GR

GRHD_Gen_Insp_WO

varchar(25)

Inspect work order number generated for that particular GR

GRHD_Comp_WO_No

varchar(40)

Component work order number generated for that particular GR

GRHD_Insp_WO_Desc

varchar(75)

Inspect work order Description generated for that particular GR

GRHD_Insp_WO_Status

varchar(15)

Inspect work order status generated for that particular GR

GRHD_Exe_omments

varchar(75)

Comments

GRHD_GR_RECEIVING_WH_CODE

sql_variant

Warehouse is used to store GR Receiving Warehouse.

Table Name GR_GRIns_GR_Inspect_dtl

Table Comment This table holds Inspection Details with Attibute code and corresponding values

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRIns_Avg_Min_Value

decimal(28,8)

NULL

This field holds attribute’s Minimum Value for the part.

No

No

GRIns_Avg_Max_Value

decimal(28,8)

NULL

This field holds attribute’s Max.Value for the part.

GRIns_Avg_Value

decimal(28,8)

NULL

This field holds attribute’s Avg.Value for the part.

GRIns_Comments

varchar(255)

This field holds the comments entered by the Person who is inspecting the quality of the part.

GRIns_ModifiedDate

datetime

This field holds the date when the attribute details of the part in the receipt is modified finally.

GRIns_Avg_Qual_Value

varchar(80)

This field holds attribute’s Avg Qualifying Value for the part.

GRIns_Created_By

varchar(30)

This field holds the User name who entered the attribute details for the part in the receipt initially.

GRIns_CreatedDate

datetime

This field holds the date when the attribute detail entered for the part in the receipt initially.

GRIns_Modified_By

varchar(30)

This field holds the User Name who has modified the attribute details of the part in the receipt finally.

GRIns_GR_No

varchar(40)

NOT NULL

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created,as per the numbering type specified.(Foreign key reference)

Yes

Yes

GRIns_Part_Line_Id

numeric(10)

The Grline number is an id which uniquely identifies the Document line no and its associated part details. Clarification required from RGG for the generation of the numbers.

GRIns_GR_Ouinstance

This is the OU Instance Id where the goods receipt document is created.(Foreign key reference)

GRIns_Attribute_Type

varchar(5)

NULL

The field holds the attribute type under which the attribute is classified.

No

No

GRIns_Attribute_Code

varchar(10)

This field holds the attribute Code which has been inspected for the part.

GRIns_Lot_Sl_Line_Id

numeric(10)

NOT NULL

This field holds the line id (maintained internally) to identify a particular LotNo /Serial No uniquely at any point of time.

Yes

Yes

GRIns_Attribute_OU

numeric(10)

NOT NULL

This filed holds the Organization Unit where the Attribute is originally created.

No

No

GRIns_GR_Attribute_Id

varchar(40)

This field holds the attribute Id by which each attribute for the Lot line part is numbered sequentially under a receipt.

Yes

Table Name GR_GRLsno_Lot_Slno_dtl

Table Comment This table holds the lot no/serial no details associated with the part number. The following columns are storing paramcodes whose description is available in GR_Parameter_details table. 1.Lsno_control_type If part number is neither serial or lot controlled Lsno_serialno,Lsno_lotno are null If part number is serial controlled  Lsno_lotno is null If part number is lot controlled Lsno_serialno is null If part number is both serial and lot controlled  Lsno_lotno is null  for serial controlled rows Lsno_serialno is null for lot controlled rows

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRLsno_Created_Ouinstance

numeric(10)

NOT NULL

This is the OU Instance Id where the goods receipt document is created.(Foreign key reference)

Yes

Yes

GRLsno_GR_No

varchar(40)

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created, as per the numbering type specified.(Foreign key reference)

GRLsno_Part_Line_Id

numeric(10)

The Grline number is an id which uniquely identifies the Document line no and its associated part details. Clarification required from RGG for the generation of the numbers.

GRLsno_Lot_Sl_Line_Id

numeric(10)

This field holds the line id(maintained internally) to identify a particular LotNo /Serial No uniquely at any point of time.

No

GRLsno_Serial_No

varchar(40)

NULL

This field holds the serial No of the part ,if exists. It can be null Details: 1.Part type can be either serial or lot controlled or none or both. 2.If the part is serial controlled then quantity is to be taken as 1 irrespective of what is entered in the quantity column. Even if it is null the quantity per serial # is to be taken as 1 3.If the part is serial controlled then ensure that serial number is entered for all the net quantity for that Gr line #. That is there must be as many serial numbers entered as the net quantity 4.The serial numbers entered for a GR line item should be unique for that part # 5.If the part is both serial and lot controlled, then serial # has to be entered. lot # may or may not be entered.

No

GRLsno_Lot_No

This field holds the Lot # if exists for the part number. It can be null Details : 1.If the part is lot controlled then ensure that at least one lot number is entered for that Gr line #. 2.If the part is both serial and lot controlled, then serial # has to be entered. lot # may or may not be entered. 3.The Lot numbers entered for a GR line item should be unique for that line item only if it is lot controlled. If it is both serial and lot controlled the lot numbers may repeat for the same line item. 4.If the part is lot controlled then ensure that the quantity column is not null and above zero against the lot numbers entered. 5.If the part is lot controlled ,the total quantity entered should be equal to the "Net quantity"

GRLsno_Certificate_Au_No

This is the certification authorize number entered by the user

GRLsno_Certificate_Date

datetime

This is the certification date entered by the user to meet the following boundary conditions. (Nullable subject to conditions) 1."certificate date" can not be later than the system date. 2."certificate date" should be earlier than or equal to the GR date. 3.If the Part has the  "minimum shelf life" defined in the part admin component then the "certificate date" can not be null. Shelf life would be calculated as follows: Shelf life = Designed shelf life- (GR date - certificate date)

GRLsno_Lot_Quar_Qty

decimal(28,8)

The column holds the quarantined quantity at lot level. (Recently changed because of RCR)

GRLsno_Certificate_No

varchar(40)

This is the certificate number for lot/serial # entered by the user.

GRLsno_Shelf_Life

varchar(5)

if the shelf life is modified in Part Admin after it is associated with GR,all the pending associated GR transactions will use the old values. Shelf life would be calculated as follows: Shelf life = Designed shelf life- (GR date - certificate date) If the Part has the  "minimum shelf life" defined in the part admin component then the "certificate date" can not be null. If the shelf life is lower than the "Minimum shelf life" defined in the Part admin , lot or serial number part is Rejected with reason code for rejection as  "Rejected for Low shelf life"

GRLsno_Certificate_Type

varchar(25)

If certificate # or authorization # is entered for a particular lot # then "certificate Type" cannot be null (Nullable subject to conditions)

GRLsno_Shelf_Reject_qty

decimal(28,8)

This column holds the reject qty at lot level due to the reason ’Minimum shelf life defined in part admin. (Recently changed because of RCR)

GRLsno_Lot_Qty

This field captures the quantity of the lot/serial no defined for the part. Clarification from RGG reqd.

GRLsno_Sys_Trk_Ref_No

varchar(40)

This is the system tracking reference no entered by the user during inspection of serial numbers. It can be null

GRLsno_CreatedDate

datetime

NOT NULL

This field holds the record created date for auditing purpose.

GRLsno_Created_By

varchar(30)

This field holds the login id of the record for auditing purpose.

GRLsno_ModifiedDate

datetime

This field holds the record modified date for auditing purpose.

GRLsno_Modified_By

varchar(30)

This field holds the login id of the modified record for auditing purpose.

GRLSNO_EXPIRY_DATE

datetime

NULL

stores the expiry date

GRLSNO_SYSGEN_LOT_NO

varchar(18)

System Generated Lot Number (Internal Lot Number)

GRLSNO_SYSGEN_SERIAL_NO

varchar(40)

System Generated Serial Number (Internal Serial Number)

GRLSNO_ASSEMBLY_STATUS

varchar(5)

Assembly Status - Dormant or Complete

GRLSNO_LAST_PRFDATE_TSI

datetime

Last Performed Date TSI

GRLSNO_LAST_PRFDATE_TSO

Last Performed Date TSO

GRLSNO_UPD_PARAM_FLAG

varchar(5)

Holds the value ’Y’ and ’N’ Y - if updated N - if not updated

GRLSNO_CERTIFICATE_SUPPLIER_NO

sql_variant

Certificate Supplier number for the Serial Number

GRLSNO_FILENAME

sql_variant

Store the Filename

GRLSNO_COMPONENT_ID

varchar(90)

NULL

This field corresponds to the Component id details for the given part

No

No

Table Name GR_GRPdt_Pt_dtl

Table Comment This table holds the part level details of a GOODS_RECEIPT The following columns are storing paramcodes whose description is available in GR_Parameter_details table. 1.Pdt_recdpartcond 2.Pdt_linestatus

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRPdt_Created_Ouinstance

numeric(10)

NOT NULL

This is the OU Instance Id where the goods receipt document is created.(Foreign key reference)

Yes

Yes

GRPdt_GR_No

varchar(40)

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created,as per the numbering type specified.(Foreign key reference)

GRPdt_Part_Line_Id

numeric(10)

The Grline number is an id which uniquely identifies the Document line no and its associated part details. Clarification required from RGG for the generation of the numbers.

No

GRPdt_GR_Line_No

numeric(10)

NULL

The Grline number is the linenumber associated with PO/RS line number

No

GRPdt_PO_RS_Line_No

numeric(10)

NOT NULL

This field corresponds to the line no of the PO/RS document.

GRPdt_PO_RS_Part_No

varchar(40)

This field corresponds to the part no associated with line no of PO/RS document.

GRPdt_GR_Part_No

varchar(40)

"Received part#" should either be the same as "Part #" or should be equivalent to any of the "Alternate Part #" defined in part admin for the ordered part #.

GRPdt_GR_Part_Ouinstance

numeric(10)

NULL

This field is to store the ouinstance of the alternate part. This value will be filled with alternate part ou if GR PART no is the alternate part no for PO_RS_PartNo else PO_RS_PART_OU.

GRPdt_Part_Control_Type

varchar(5)

The field holds the info that part no is Serial Controlled, lot no controlled, both or none. Allowed values NE - neither lot no or serial no LN - lot no SN - serial no BH - both

GRPdt_Cost

decimal(28,8)

This field holds the total cost of the part for the COST_PER quantity. Ie. Suppose Cost &nbspRs.100.00 and Cost Per is 10 means the hundred rupees is the cost of 10 quantity of part.

GRPdt_Cost_Per

decimal(28,8)

This field holds the Number of quantity for which the Cost is specified in the "Grpdt_Cost" field

GRPdt_Basic_Value

decimal(28,8)

basic value of the part received

GRPdt_Part_Shelf_Life

varchar(5)

The Designed shelf life from Part Admin is stored at Part Level.

GRPdt_Part_Quar_Qty

decimal(28,8)

This field holds the "Quarantined qty" which should satisfy the following boundary conditions. 1."Quarantined qty" should not be negative. 2.The total of "quarantined Qty" and "Visual Rejection qty" can not be greater than the "Received Qty". Fractions are allowed which are validated with UOM_ADMIN component.

GRPdt_Part_Recd_Qty

decimal(28,8)

The received quantity is user enterable field which should satisfy the following boundary conditions. 1."Received quantity" for at least one line item should not be null. 2.Received quantity for the line-items which are not null, should be greater than zero 3.Received quantity for the line-items which are not null, should not be greater than Pending quantity+(Total ordered quanity*tolerance) where Pending Quantity=Order Quantity-Total Other GR Accepted Quantity.

GRPdt_Part_Vis_Rej_Qty

decimal(28,8)

This field holds the visual reject quantity which should satisfy the following boundary conditions. 1."Visual Rejection qty" should not be negative. 2.The total of "quarantined Qty" and "Visual Rejection qty" can not be greater than the "Received Qty". Fractions are allowed which are validated with UOM_ADMIN component.

GRPdt_Part_Reject_Qty

decimal(28,8)

This field holds the sum of Part Lot qty and Serial qty which are Rejected separately in two different UIs

GRPdt_Part_Accept_Qty

decimal(28,8)

This field holds the sum of Part Lot qty and Serial qty which are accepted separately in two different UIs

GRPdt_Part_Moved_Qty

decimal(28,8)

This field holds the how much part moved to warehouse out of accepted quantity.

GRPdt_Line_TCD_Amt

decimal(28,8)

This field is the summation of all the tcd amount for the associated part.

GRPdt_Line_Status

varchar(5)

This field hold the status of the line no of the GR. values allowed are 1.Received 2.Inspected 3.Moved

GRPdt_CreatedDate

datetime

NOT NULL

This field holds the record created date for auditing purpose.

GRPdt_Created_By

varchar(30)

This field holds the login id of the record for auditing purpose.

GRPdt_ModifiedDate

datetime

This field holds the record modified date for auditing purpose.

GRPdt_Modified_By

varchar(30)

This field holds the login id of the modified record for auditing purpose.

GRPdt_Part_comments

varchar(255)

NULL

This field holds the comments entered when the part is rejected or quarantined.

GRPdt_Move_Date

datetime

This field holds the record moved Date for reporting purpose

GRPdt_Move_By

varchar(30)

This field holds the record moved user

GRPdt_PORS_Insp_Typ

varchar(5)

Inspection Type

GRPDT_PEND_RETSUP_QTY

numeric(28,8)

Pending Return Quantity

GRPDT_PUR_UOM

varchar(30)

Purchase UOM

GrPdt_LotSer_QtySum

numeric(28,8)

Quantity Sum (Calculated)

GrPdt_QntLotSer_QtySum

numeric(28,8)

GRPDT_NETQTY_SUOM

numeric(28,8)

GRPDT_PURTOSTK_CF

numeric(28,8)

Purchase UOM to Stock UOM Conversion Factor

GRPDT_REF_RCPT_LIST_NO

numeric(6)

Receipt List No. from Subcontract Order

GRPDT_CONSTITUENT_TYPE

varchar(5)

Constituent Type (Subcontract Order)

GRPDT_PART_CONDITION

Part Condition

GRPdt_Def_Fin_book

varchar(20)

This field stores the default finance book from Account group component

GRPdt_Account_Type

varchar(25)

Holds the account type eg: SUPPSUSP

GRPdt_Account_Code

varchar(32)

Stores the account code from Account group component

GRPdt_Analysis_Code

varchar(5)

stores the analysis code from the account based budget component for the passed account code

GRPdt_SubAnalysis_Code

varchar(5)

stores the subanalysis code from the account based budget component for the passed account code

GRPdt_Control_Acc_Type

varchar(40)

stores the Control Account Type from the AS component for the passed account code

GRPdt_Auto_Post_Acc_Type

varchar(40)

stores the Automatic Posting Account Type from the AS component for the passed account code

GRPdt_Acct_Curr_Code

varchar(5)

stores the Account Currency Code from the AS component for the passed account code

GRPDT_ACCT_EXP_AMT

numeric(28,8)

Freeze acceptance amount include’s tcd value

GRPDT_EXCH_ACCOUNT_TYPE

varchar(25)

account posting type - not using now since posting has been centralised

GRPDT_EXCH_ACCOUNT_CODE

varchar(32)

posting account code - not using now since posting has been centralised

GRPDT_EXCH_ACCT_EXP_AMT

decimal(28,8)

Exchange po acceptance amount (for exchange issued part)

GRPDT_FACCEPT_ACC_POST_FLAG

varchar(1)

Posting flag - not using now

GRPDT_COMPUTED_COST

decimal(28,8)

Cost computed during posting

GRPDT_COMPUTED_DATE

datetime

Computed date

GRPDT_Com_No

varchar(40)

Component number

GRPDT_Gen_Insp_WO

varchar(25)

inspection work required or not Y - yes N - not required

GRPDT_Comp_WO_No

varchar(40)

Component work order number

GRPDT_Insp_WO_Desc

varchar(75)

work order description

GRPDT_Insp_WO_Status

varchar(15)

work order status

GRPDT_Exe_omments

varchar(75)

Comments

GRPDT_Financeposting_flag

varchar(5)

Finance posting flag holds the value D - draft (means finance posting not done) I   - Inspected (means posting happened for acceptance) M - Moved ( means posting happened for movement)

GRPDT_PO_RS_WAREHOUSE_NO

sql_variant

Store the Reference Document Warehouse.

GRPDT_PARAM_ENTRY

sql_variant

Mandate Parameter Entry Required or not. Yes or NO flag stored.

grpdt_base_exchange_rate

udd_amount

Store the base exchange rate Value

grpdt_expense_policy

udd_designparamcode

Store the expense policy value

grpdt_part_cost

udd_amount

Store the Part cost value

GRPDT_PART_TYPE

varchar(25)

NOT NULL

This field corresponds to the part type defined in part master.

No

No

GRPDT_PART_NONSTKFLG

varchar(25)

NOT NULL

This field corresponds to the Non stockable part as defined in part master.

No

No

GRPDT_PART_EXPTYPE

varchar(25)

NOT NULL

This field corresponds to the expense type of the part as defined in part master.

No

No

GRPDT_RCPT_RECDOPN

varchar(5)

NOT NULL

This field corresponds to the receipt record option.

No

No

GRPDT_PART_EXPOLICY

varchar(5)

NOT NULL

This field corresponds to the part expense policy as defined in part master.

No

No

GRPDT_PART_LOTNOTYPE

varchar(5)

NULL

This field corresponds to the Lot numbering type.

No

No

GRPDT_PART_SLNOTYPE

varchar(5)

NULL

This field corresponds to the Serial numbering type.

No

No

GRPDT_PART_SLNOLOGIC

varchar(5)

NULL

This field corresponds to the Serial no logic generation.

No

No

Table Name GR_GRPlii_Pt_Lt_Insp_info

Table Comment This table holds the inspection details of the lot associated with the part number The following columns are storing paramcodes whose description is available in GR_Parameter_details table. 1.Plii_inspection_type

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRPlii_Created_Ouinstance

numeric(10)

NOT NULL

This is the OU Instance Id where the goods receipt document is created.(Foreign key reference)

Yes

Yes

GRPlii_GR_No

varchar(40)

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created,as per the numbering type specified.(Foreign key reference)

GRPlii_Part_Line_Id

numeric(10)

The Grline number is an id which uniquely identifies the Document line no and its associated part details. Clarification required from RGG for the generation of the numbers.

GRPlii_Lot_Sl_Line_Id

numeric(10)

This field holds the line id(maintained internally) to identify a particular &nbspLotNo /Serial No uniquely at any point of time.

GRPlii_Inspect_Qty

decimal(28,8)

NULL

This field is a calculated qty which is defined as follows: 1.Non-Lot controlled parts:  Inspection qty = (Received qty - quarantined qty-visual rejection qty) 2.Lot controlled parts: Receivedqty = Lotqty = Inspectionqty

No

No

GRPlii_Accept_Qty

decimal(28,8)

This field is to hold the value of the accepted quantity at part,lot no level. 1.If "accepted quantity" is null ,it is taken as zero. 2.The "accepted qty" cant be more than the "Inspection Qty" 3.Accepted quantity can’t be negative 4.Fraction values to be validated with UOM_ADMIN component

GRPlii_Reject_Qty

decimal(28,8)

This field holds the rejected quantity at part,lot no level .Rejected quantity cannot be negative. Fraction values to be validated with UOM_ADMIN component

GRPlii_Reject_Reason_Code

varchar(25)

This field is to capture one of the   "Reason code" defined by the user using quick codes for the type Rejection.

GRPlii_Quar_Qty

decimal(28,8)

This field holds the quarantinedqty at part lot no level. Quarantinedqty cannot be negative. Fraction values to be validated with UOM_ADMIN component

GRPlii_Quar_Reason_Code

varchar(25)

This field is to capture one of the   "Reason code" defined by the user using quick codes for the type Quarantine.

GRPlii_Inspect_By

varchar(30)

This field holds the user id who has inspected the GOODS received.

GRPlii_Comments

varchar(255)

This field is to capture the comments regarding inspection entered by the user.

GRPlii_Warranty_End_Date

datetime

This field holds the warranty end date at part-lot no level.

GRPlii_CreatedDate

This field holds the record created date for auditing purpose.

GRPlii_Created_By

varchar(30)

This field holds the login id of the record for auditing purpose.

GRPlii_ModifiedDate

datetime

This field holds the record modified date for auditing purpose.

GRPlii_Modified_By

varchar(30)

This field holds the login id of the modified record for auditing purpose.

GRPlii_Insp_Flag

varchar(5)

Inspection Flag

GRPLII_LOT_NO

varchar(40)

Manufacturer Lot Number

GRPLII_SYSGEN_LOT_NO

varchar(18)

System Generated Lot Number (Internal Lot Number)

Table Name GR_GRPMvi_Pt_Move_info

Table Comment This table holds the movement info of each lot number The following columns are storing paramcodes whose description is available in GR_Parameter_details table. 1.PMvi_status

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRPMvi_Modified_By

varchar(30)

NULL

This field holds the login id of the modified record for auditing purpose.

No

No

GRPMvi_WH_OU

numeric(10)

used to store Warehouse Created OU

GRPMvi_Part_Cost

numeric(28,8)

Used to store the Stock Cost

GRPMvi_CreatedDate

datetime

This field holds the record created date for auditing purpose.

GRPMvi_ModifiedDate

datetime

This field holds the record modified date for auditing purpose.

GRPMvi_Created_By

varchar(30)

This field holds the login id of the record for auditing purpose.

GRPMvi_status

varchar(40)

This field is to capture one of the status values defined for the transaction type GR in the UDSS component.

GRPMVI_WORKCENTER_OU

numeric(10)

OUInstance of Work Center

GRPMVI_WORKCENTER_NO

varchar(30)

Work Center Number

GRPMvi_Qtyin_SUOM

numeric(28,8)

Used to store the Moved Quantity in Stock UOM

GRPMVI_SCH_STATUS

varchar(5)

Schedule Status

GRPMVI_MAT_REQ_OU

numeric(10)

OUInstance of Material Request

GRPMVI_PEND_QTY

numeric(28,8)

Pending Quantity to be moved

GRPMVI_MOVE_TO

varchar(5)

Move to : Warehouse/Work Center

GRPMvi_Lot_Sl_Line_Id

numeric(10)

NOT NULL

This field holds the line id (maintained internally) to identify a particular LotNo /Serial No uniquely at any point of time.

Yes

Yes

GRPMVI_MOVE_LINE_ID

numeric(10)

NOT NULL

ID which uniquely identifies movement line

No

GRPMVI_MR_LINE_NO

numeric(10)

NOT NULL

Line no of the pegged material request

GRPMvi_Created_Ouinstance

numeric(10)

NOT NULL

This is the OU Instance Id where the goods receipt document is created.(Foreign key reference)

Yes

GRPMvi_Part_Line_Id

numeric(10)

NOT NULL

The Grline number is an id which uniquely identifies the Document line no and its associated part details. Clarification required from RGG for the generation of the numbers.

GRPMvi_GR_No

varchar(40)

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created,as per the numbering type specified.(Foreign key reference)

GRPMvi_Part_Move_Qty

decimal(28,8)

NULL

This field holds the information about the moved qty at lotno/serial no level. It should satisfy the following conditions: 1.Moved qty should be entered at least once for each of the lot or serial number 2.The total of the Moved qty for each lot number cannot be greater than the Accepted lot qty for each of the lot. 3.The total of the moved qty for all the lot numbers should be equal to the Quantity accepted. 4.the total of the Moved qty for each of the serial # cant be greater than 1. 5.The total of the moved qty for all the serial numbers should be equal to the quantity accepted. 6.Moved qty can not be negative 7. if the moved quantity is not null and greater than zero,Part status can not be null

No

No

GRPMvi_Bin_Id

varchar(10)

This field holds the bin for the Lot/Slno. Initially it is defaulted from PO/RS component. It can be overridden by the user entry which needs to be validated with STORAGE_ADMIN component. 1.If the Zone is "free", Bin # can be null. If Zone is "normal" then check if the Bin # entered is valid for the corresponding Zone # from the storage admin componnet

GRPMvi_Zone_Id

This field holds the zone for the Lot/Slno. Initially it is defaulted from PO/RS component. It can be overridden by the user entry which needs to be validated with STORAGE_ADMIN component. 1.if the warehouse is "Free" Zone # can be null, if warehouse is "Normal" then check if the zone # entered is valid for the corresponding warehouse # from the storage admin component. 2. zone status should be "active"

GRPMVI_MR_SUB_LINE_NO

numeric(10)

NOT NULL

Sub Line no of the pegged material request

Yes

GRPMVI_MAT_REQ_NO

varchar(40)

Material Request Number

GRPMvi_Warehouse_Id

varchar(10)

NULL

This field holds the warehouse for the Lot/Slno. Initially it is defaulted from PO/RS component. It can be overridden by the user entry which needs to be validated with STORAGE_ADMIN component. 1.warehouse # should be valid for the entered transaction type "GR" 2.the warehouse status to be active. 3.Warehouse is modifiable only if the warehouse modifiable field is set to yes in the system parameters 4.Warehouse is modifiable only if the parts for which warehouse details are modified are not dispositionable.

No

GRPMvi_Po_Sch_Id

numeric(10)

NOT NULL

purchase order schedule id

GRPMVI_PART_VALMETHOD

varchar(5)

NULL

This field corresponds to the part valuation method details.

No

No

Table Name GR_GRPPD_Pt_Pos_Dtl

Table Comment This tables holds sub component information.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRPPD_Sys_Trk_Ref_No

varchar(40)

NULL

This field holds the System tracking Reference Number which is unique.

No

No

GRPPD_CreatedDate

datetime

This field holds the date when the sub component details entered initially.

GRPPD_Certificate_Au_No

varchar(40)

This field Holds the Certificate authorization Number.

GRPPD_Certificate_Type

varchar(25)

This field holds the Certificate Type defined in the logistics Common Master.

GRPPD_Certificate_Date

datetime

This Field Holds the Certificate Date.

GRPPD_LAST_PRFDATE_TSI

datetime

last preference date for parameter tsi

GRPPD_LAST_PRFDATE_TSO

datetime

last preference date for parameter tso

GRPPD_Created_By

varchar(30)

This field holds the User Name who entered the sub component details initially.

GRPPD_Modified_By

varchar(30)

This field holds the User Name who modified the sub component details finally.

GRPPD_ModifiedDate

datetime

This field holds the date when the sub component details has been modified finally.

GRPPD_UPD_PARAM_FLAG

varchar(5)

Parameter flag Y - if updated N - if not updated

GRPPD_Part_Line_Id

numeric(10)

NOT NULL

The Grline number is an id which uniquely identifies the Document line no and its associated part details. Clarification required from RGG for the generation of the numbers.

Yes

Yes

GRPPD_Lot_Sl_Line_Id

numeric(10)

NOT NULL

This field holds the line id(maintained internally) to identify a particular combination of LotNo and Serial No at any point of time.

GRPPD_Prt_Pos_Line_Id

numeric(10)

NOT NULL

This field holds the Line id for each part in the positions under the parent component.

No

GRPPD_GR_No

varchar(40)

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created,as per the numbering type specified.(Foreign key reference)

Yes

GRPPD_Created_Ouinstance

numeric(10)

This is the OU Instance Id where the goods receipt document is created.(Foreign key reference)

GRPPD_Certificate_No

varchar(40)

NULL

This field Holds the Certificate No

No

No

GRPPD_Prt_Sl_No

This field holds the part serial no .

GRPPD_Prt_Sl_Cond

varchar(5)

This field holds part condition

GRPPD_Prt_Pos_Code

varchar(25)

This field holds the Concatenated value of Part + position No under the parent component.

GRPPD_Prt_No

varchar(40)

This field holds the Part No alone under parent Component.

GRPPD_Prt_OUInstance

numeric(10)

This field holds the Organization Unit where the part is originally created.

Table Name GR_GRPRd_Pt_Ref_Obj_dtl

Table Comment This table holds the reference document details for the Goods Receipt

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRPRd_Created_Ouinstance

numeric(10)

NOT NULL

This is the OU Instance Id where the goods receipt document is created.(Foreign key reference)

Yes

Yes

GRPRd_GR_No

varchar(40)

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created,as per the numbering type specified.(Foreign key reference)

GRPRd_Part_Line_Id

numeric(10)

The Grline number is an id which uniquely identifies the Document line no and its associated part details. Clarification required from RGG for the generation of the numbers.

GRPRd_Doc_Line_Id

numeric(10)

This field holds the Document Line Id . This is just as sequence no for the document Ids.

No

GRPRd_Ref_Doc_Type

varchar(25)

NULL

This field holds the Reference Document Type defined in the logistics common master.

No

GRPRd_Ref_Doc_Id

varchar(40)

This field holds the Document ID entered by the user when entering the Reference document details.

GRPRd_Ref_Doc_File_Name

varchar(50)

This field holds the File Name( includes full path )of the document Which is referred.

GRPRd_Created_Date

datetime

This field holds the date when the Reference details entered initially.

GRPRd_Created_By

varchar(30)

This field holds the User Name who has entered the reference details initially.

GRPRd_Modified_Date

datetime

This field holds the Date when the reference details modified finally.

GRPRd_Modified_By

varchar(30)

This field stores the User Name who modified the reference details finally.

GRPRD_GR_SRLLOT_NO

sql_variant

Serial and lot number concatenation for attach documents

Table Name GR_GRPrm_parameter_details

Table Comment This table is to Store Parameter detail information of Goods Receipt component.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRPrm_ComponentName

varchar(80)

NOT NULL

This field holds the Name of the component.

Yes

No

GRPrm_ParamCategory

varchar(10)

This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.

GRPrm_ParamType

varchar(25)

Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.

GRPrm_ParamCode

varchar(5)

This is the code that may be used for data storage. This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained.

GRPrm_Langid

numeric(10)

Language id. This is the language id of the record.

GRPrm_ParamDesc

varchar(80)

NULL

Param description is the values to be filled in the combo box or guidance text. This is actually the meta data of this component

No

GRPRM_SORTBY

numeric(10)

This field stores the values based on which the records in the table are sorted

GRPrm_CreationDate

datetime

This field holds the record created date for auditing purpose.

Table Name GR_GRPsii_Pt_Sl_Insp_info

Table Comment This table holds the inspection information about the serial number

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRPsii_Created_Ouinstance

numeric(10)

NOT NULL

This is the OU Instance Id where the goods receipt document is created.(Foreign key reference)

Yes

Yes

GRPsii_GR_No

varchar(40)

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created,as per the numbering type specified.(Foreign key reference)

GRPsii_Part_Line_Id

numeric(10)

The Grline number is an id which uniquely identifies the Document line no and its associated part details. Clarification required from RGG for the generation of the numbers.

GRPsii_Lot_Sl_Line_Id

numeric(10)

This field holds the line id(maintained internally) to identify a particular combination of LotNo and Serial No at any point of time.

GRPsii_Reason_code

varchar(25)

NULL

This field holds the reason code with the quick code values defined by the user for "Rejection" and "quarantined"

No

No

GRPsii_Inspect_Result

varchar(5)

This field holds the inspection result for the part-serial #. Allowed values are 1. "Accepted" 2. "rejected" 3. "quarantined"

GRPsii_Inspect_By

varchar(30)

This field holds the inspected user at part-serial no level

GRPsii_Comments

varchar(255)

This field holds the comments for the inspection at part-serial no level.

GRPsii_Warranty_End_Date

datetime

This field holds the warranty end date at Part-Serial no level.

GRPsii_CreatedDate

datetime

This field holds the record created date for auditing purpose.

GRPsii_Created_By

varchar(30)

This field holds the login id of the record for auditing purpose.

GRPsii_ModifiedDate

datetime

This field holds the record modified date for auditing purpose.

GRPsii_Modified_By

varchar(30)

This field holds the login id of the modified record for auditing purpose.

GRPsii_Insp_Flag

varchar(5)

Inspection Flag

GRPSII_ACCEPT_QTY

numeric(28,8)

Accepted Quantity

GRPSII_QUAR_QTY

Quarantined Quantity

GRPSII_REJECT_QTY

Rejected Quantity

GRPSII_LOT_NO

varchar(40)

Manufacturer Lot Number

GRPSII_SERIAL_NO

Manufacturer Serial Number

GRPSII_SYSGEN_LOT_NO

varchar(18)

System Generated Lot Number (Internal Lot Number)

GRPSII_SYSGEN_SERIAL_NO

varchar(40)

System Generated Serial Number (Internal Serial Number)

GRPSII_RECEIVED_CONDITION

sql_variant

Received condition part condition

GRPSII_CERTIFICATE_TYPE

varchar(40)

NULL

This field corresponds to the certificate type details

No

No

GRPSII_CERTIFICATE_NO

varchar(40)

NULL

This field corresponds to the certificate No details

No

No

GRPSII_CERTIFICATE_DATE

varchar(40)

NULL

This field corresponds to the certificate Date details

No

No

GRPSII_CERTIFICATE_SUPPLIER_NO

varchar(40)

NULL

This field corresponds to the certificate Supplier details

No

No

GRPSII_CERTIFICATE_AU_NO

varchar(40)

NULL

This field corresponds to the certificate Authorised No details

No

No

GRPSII_EXPIRY_DATE

datetime)

NULL

This field corresponds to the part expire date details

No

No

GRPSII_FILENAME

varchar(50)

NULL

This field corresponds to the file name details

No

No

GRPSII_RECORDSUPDATE

varchar(5)

NULL

This field corresponds to the Record update status : ie Pending or verified or Override or Not applicable details.

No

No

GRPSII_COMPONENT_ID

varchar(90)

NULL

This field corresponds to the Component id details for the given part

No

No

GRPSII_COMPONENT_OU

int(4)

NULL

This field corresponds to the Component Ou for the respective Component id details.

No

No

Table Name GR_GRPspi_Pt_Sl_Parm_info

Table Comment This table holds the parameter details of the serial number

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRPspi_Since_Shop_Visit

decimal(28,8)

NULL

If part condition is "New" or "New Surplus", since last shop visit is zero If condition is "Overhauled" then since last shop visit is zero. If condition is "Serviceable" then Since Last Shop Visit < Since Overhaul If condition is "Serviceable" then Since Last Shop Visit >= zero Fractional values to be validated with UOM_ADMIN component

No

No

GRPSPI_WARRANTY_VAL

numeric(28,8)

warranty value

GRPspi_Since_Repair

decimal(28,8)

If part condition is "New" or "New Surplus", the since repair value is zero If condition is "Overhauled" then the since repair value is null or zero. If condition is "Serviceable" then Since Repair < Since Overhaul If condition is "Serviceable" then Since Repair >= 0 Fractional values to be validated with UOM_ADMIN component

GRPspi_Since_Overhaul

decimal(28,8)

If part condition is "New" or "New Surplus", since overhaul = 0 If condition is "Overhauled" since overhaul = 0 If condition is "Serviceable" , Since Overhaul > zero. If condition is "Serviceable" then, Since Overhaul < Since New. If condition is "Serviceable" then Since Repair < Since Overhaul If condition is "Serviceable" then Since Last Shop Visit < Since Overhaul If condition is "Serviceable" then Since Inspection must be lesser than Since Overhaul Fractional values to be validated with UOM_ADMIN component

GRPspi_Modified_By

varchar(30)

This field holds the login id of the modified record for auditing purpose.

GRPspi_CreatedDate

datetime

This field holds the record created date for auditing purpose.

GRPspi_ModifiedDate

datetime

This field holds the record modified date for auditing purpose.

GRPspi_Created_By

varchar(30)

This field holds the login id of the record for auditing purpose.

GRPspi_Unknown

varchar(5)

Unknown

GRPspi_GR_No

varchar(40)

NOT NULL

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created,as per the numbering type specified.(Foreign key reference)

Yes

Yes

GRPspi_Part_Line_Id

numeric(10)

The Grline number is an id which uniquely identifies the Document line no and its associated part details Clarification required from RGG for the generation of the numbers.

GRPspi_Created_Ouinstance

This is the OU Instance Id where the goods receipt document is created.(Foreign key reference)

GRPspi_Ac_Param_Code

varchar(40)

NULL

This column is to hold the parameter code from the aircraft component.

No

No

GRPspi_Since_New

decimal(28,8)

If part condition is "New" or "New Surplus", the SinceNew is zero. If condition is "Overhauled" then since new should be greater than zero If condition is "Overhauled" then Since New should not be null or zero. If condition is "Serviceable" then, Since New should be greater than zero. If condition is "Serviceable" then, Since Overhaul < Since New. Fractional values to be validated with UOM_ADMIN component

GRPspi_Lot_Sl_Line_Id

numeric(10)

NOT NULL

This field holds the line id(maintained internally) to identify a particular combination of LotNo and Serial No at any point of time.

Yes

Yes

GRPspi_Since_Inspect

decimal(28,8)

NULL

If part condition is "New" or "New Surplus", the Since Inspection value is zero. If condition is "Overhauled" then the Since Inspection value can be null or zero. If condition is "Serviceable" then Since Inspection < Since Overhaul If condition is "Serviceable" then Since Inspection >= 0 Fractional values to be validated with UOM_ADMIN component

No

No

GRPspi_Param_Line_Id

numeric(10)

NOT NULL

This field holds the Parameter Line Id. The purpose of this is to identify each parameter by its sequence.

Yes

Table Name GR_GRPTcd_Pt_TCD_dtl

Table Comment This table holds the tcd details of each part number The following columns are storing paramcodes whose description is available in GR_Parameter_details table. 1.PTcd_suppliertype

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

GRPTcd_PORSCpy_Flag

varchar(5)

NULL

Copy Flag

No

No

GRPTcd_exchg_rate

numeric(28,8)

Holds the exchange rate between the document currency and the payment currency

GRPTcd_Account_Type

varchar(25)

Holds the account type

GRPTcd_Prt_Tcd_SeqNo

numeric(10)

stores the user entered sequence number

GRPTcd_Modified_By

varchar(30)

NOT NULL

This field holds the login id of the modified record for auditing purpose.

GRPTcd_ModifiedDate

datetime

This field holds the record modified date for auditing purpose.

GRPTcd_Auto_Post_Acc_Type

varchar(40)

NULL

stores the Automatic Posting Account Type from the AS component for the passed account code

GRPTcd_Acct_Curr_Code

varchar(5)

stores the Account Currency Code from the AS component for the passed account code

GRPTcd_Account_Code

char(32)

Stores the account code from Account group component

GRPTcd_Analysis_Code

varchar(5)

stores the analysis code from the account based budget component for the passed account code

GRPTcd_Control_Acc_Type

varchar(40)

stores the Control Account Type from the AS component for the passed account code

GRPTcd_SubAnalysis_Code

varchar(5)

stores the subanalysis code from the account based budget component for the passed account code

GRPTCD_COST_CENTER

varchar(40)

stores the cost center for the specified account code

GRPTcd_Part_Line_Id

numeric(10)

NOT NULL

The Grline number is an id which uniquely identifies the Document line no and its associated part details. Clarification required from RGG for the generation of the numbers.

Yes

Yes

GRPTcd_Part_TCD_Line_Id

numeric(10)

NOT NULL

This is the internal TCD id to identify uniquely a particular TCD line at part level

No

GRPTcd_TCD_OU

numeric(10)

NULL

TCD OU taken from TCD Component for TCD Calculation purpose

No

GRPTcd_GR_No

varchar(40)

NOT NULL

GR# is unique number to identify the GOODS RECEIPT document which is an increment over the GR # of the most recent GR created,as per the numbering type specified.(Foreign key reference)

Yes

Yes

GRPTcd_Created_Ouinstance

numeric(10)

This is the OU Instance Id where the goods receipt document is created.(Foreign key reference)

GRPTcd_Created_By

varchar(30)

This field holds the login id of the record for auditing purpose.

No

No

GRPTcd_TCD_Amt

decimal(28,8)

NULL

This field is to capture the TCD amount at part level.It needs to be validated with the TCD component

GRPTcd_CreatedDate

datetime

NOT NULL

This field holds the record created date for auditing purpose.

GRPTcd_TCD_Code

varchar(25)

NULL

This field is to capture the TCD code at part level. It needs to be validated with the TCD component

GRPTCD_CURRENCY

varchar(20)

holds the currency

GRPTcd_TCD_Rate

decimal(28,8)