Customer Goods Receipt |
|||||
|
|
|||||
|
Table Name cgr_cgropt_option_setting |
|
||||
|
|
|||||
|
Table Comment The table is use to stores option settings for Customer goods receipt pertaining to OuInstance |
|||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cgropt_OuInstance |
int |
NULL |
This field holds the OuInstance of CGR document |
No |
No |
|
cgropt_Mv_Wh_FrRcpt |
varchar() |
NULL |
This field holds the flag of Movement to Warehouse on Freeze Receipt Required (R) Not Required (N) To enable the movement of the goods to the warehouse on freezing the customer goods receipt. Else, select Not Required. The system displays Not Required by default. |
No |
No |
|
cgropt_modifiedby |
varchar() |
NULL |
This field holds the modified by of Option setting |
No |
No |
|
cgropt_modifieddate |
datetime |
NULL |
This field holds the modified date of option settings |
No |
No |
|
cgropt_timestamp |
int |
NULL |
This field holds the timestamp of option settings |
No |
No |
|
|
|||||
|
Table Name CGR_CGRPrm_parameter_details |
|
||||
|
|
|||||
|
Table Comment This field holds the CGR parameter details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
CGRprm_ComponentName |
varchar(20) |
NULL |
This field holds the Name of the component. |
No |
No |
|
CGRprm_ParamCategory |
varchar(10) |
NULL |
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. |
No |
No |
|
CGRprm_ParamType |
varchar(25) |
NULL |
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. |
No |
No |
|
CGRprm_ParamCode |
varchar(5) |
NULL |
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. |
No |
No |
|
CGRprm_Langid |
int |
NULL |
Language id. This is the language id of the record. |
No |
No |
|
CGRprm_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 |
No |
|
CGRprm_SORTBY |
int |
NULL |
This field holds the default sort by code |
No |
No |
|
CGRprm_CreationDate |
datetime |
NULL |
This field holds the record created date for auditing purpose. |
No |
No |
|
|
|||||
|
Table Name cgr_cgrptd_part_dtl |
|
||||
|
|
|||||
|
Table Comment This tables holds the Part details information for the CGR document |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cgrptd_Ouinstance |
int |
NULL |
This field is to define location code unique at Organization unit level |
No |
No |
|
cgrptd_CGRno |
varchar(40) |
NULL |
This field holds the CGR Number |
No |
No |
|
cgrptd_CGRLineNo |
int |
NULL |
This field holds the CGR line number |
No |
No |
|
cgrptd_Refdoc_LineNo |
int |
NULL |
This field holds the Reference document line number |
No |
No |
|
cgrptd_PartNo |
varchar(40) |
NULL |
This field holds the Part number |
No |
No |
|
cgrptd_part_OU |
int |
NULL |
This field holds the part OUinstance |
No |
No |
|
cgrptd_CustPartNo |
varchar(40) |
NULL |
This field holds the Customer part number |
No |
No |
|
cgrptd_ReceivedQty |
numeric(28,8) |
NULL |
This field holds the received quantity |
No |
No |
|
cgrptd_movedQty |
numeric(28,8) |
NULL |
This field holds the moved quantity |
No |
No |
|
cgrptd_Packslip_qty |
numeric(28,8) |
NULL |
This field holds the packslip quantity |
No |
No |
|
cgrptd_UOM |
varchar(10) |
NULL |
This field holds the UOM of the part |
No |
No |
|
cgrptd_stkstatus |
varchar(25) |
NULL |
This field holds the stock status of the part ,system lists all the active statuses defined for the Customer Goods” in the User Defined Stock Status” business component for the transaction type Customer Goods Receipt. |
No |
No |
|
cgrptd_Remarks |
varchar(255) |
NULL |
This field holds the remarks |
No |
No |
|
cgrptd_PackCondition |
varchar(25) |
NULL |
This field holds the packaged condition of the part(s) sent by the customer |
No |
No |
|
cgrptd_line_Status |
varchar(25) |
NULL |
This field holds the line status of each multiline Possible values are 1.Fresh (F) 2.Freeze Receipt (FR) 3.Moved (MVD) 4.Patially moved (PMVD) |
No |
No |
|
cgrptd_Wh |
varchar(10) |
NULL |
This field holds the Warehouse in which the part has to be moved |
No |
No |
|
cgrptd_WhOU |
int |
NULL |
This field holds OU in which the Warehouse has created |
No |
No |
|
cgrptd_WhZn |
varchar(10) |
NULL |
This field holds the Warehouse zone |
No |
No |
|
cgrptd_WhBin |
varchar(10) |
NULL |
This field holds the Warehouse bin |
No |
No |
|
cgrptd_Freezed_date |
varchar(15) |
NULL |
This field holds the Freezed date |
No |
No |
|
cgrptd_Material_Type |
varchar(25) |
NULL |
This field holds the system lists the following options: Main Core(MC): Indicates the part on which the maintenance work is carried out. Regular(REG): denotes other parts. |
No |
No |
|
|
|||||
|
Table Name cgr_cgrptls_lot_srl_dtl |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cgrptls_Ouinstance |
int |
NULL |
This field holds the ou instance where the document created |
No |
No |
|
cgrptls_CGRno |
varchar(40) |
NULL |
This field holds the CGR number |
No |
No |
|
cgrptls_MfgSerialNo |
varchar(40) |
NULL |
This field holds the Manufacturing serial number |
No |
No |
|
cgrptls_LotNo |
varchar(18) |
NULL |
This field holds the Lot number |
No |
No |
|
cgrptls_ComponentID |
varchar(90) |
NULL |
This field holds the Component id |
No |
No |
|
cgrptls_partcondition |
varchar(25) |
NULL |
This field captures the part condition, the values are (N)ew (Ns)New Surplus (O)verhaul (S)erviceable (U)nserviceable |
No |
No |
|
cgrptls_ReceivedQty |
numeric(28,8) |
NULL |
This field holds the received quantity |
No |
No |
|
cgrptls_MovedQty |
numeric(28,8) |
NULL |
This field holds the moved quantity |
No |
No |
|
cgrptls_Warehouse |
varchar(10) |
NULL |
This field holds the warehouse code in which part has to be moved |
No |
No |
|
cgrptls_WHBin |
varchar(10) |
NULL |
This field holds the Warehouse-Bin code in which part has to be moved |
No |
No |
|
cgrptls_WHZone |
varchar(10) |
NULL |
This field holds the Warehouse-Zone code in which part has to be moved |
No |
No |
|
cgrptls_stkstatus |
varchar(25) |
NULL |
This field holds the user-defined stock status. The system lists all the active statuses defined for the Customer Goods in the User Defined Stock Status business component for the transaction type Customer Goods Receipt. |
No |
No |
|
cgrptls_Remarks |
varchar(255) |
NULL |
This field holds the remarks |
No |
No |
|
cgrptls_PartNo |
varchar(40) |
NULL |
This field holds the part number |
No |
No |
|
cgrptls_PartOU |
int |
NULL |
This field holds the part ou in which the part has been created |
No |
No |
|
cgrptls_compidou |
varchar(90) |
NULL |
This field holds the component id ouinstance |
No |
No |
|
cgrptls_slLineNo |
int |
NULL |
This field holds the Serial line number |
No |
No |
|
cgrptls_WhOu |
int |
NULL |
This field holds the Ou instance of the warehouse |
No |
No |
|
cgrptls_Expiry_Date |
datetime |
NULL |
This field holds the Expiry date of part |
No |
No |
|
cgrptls_SysGen_Serial_no |
varchar(40) |
NULL |
This field holds the system generated serial numbers |
No |
No |
|
cgrptls_SysGen_lot_no |
varchar(18) |
NULL |
This field holds the system generated lot numbers |
No |
No |
|
cgrptls_certtype |
varchar(25) |
NULL |
added for R63 Enhancement holds information about the certificate type |
No |
No |
|
cgrptls_certno |
varchar(40) |
NULL |
added for R63 Enhancement holds information about the certificate no |
No |
No |
|
cgrptls_certdate |
varchar(25) |
NULL |
added for R63 Enhancement holds information about the certificate date |
No |
No |
|
cgrptls_authno |
varchar(40) |
NULL |
added for R63 Enhancement holds information about the authno |
No |
No |
|
|
|||||
|
Table Name CGR_CGRQc_Quick_Code |
|
||||
|
|
|||||
|
Table Comment This table holds the quick code of the CGR |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
CGRQc_OUInstance |
int |
NULL |
This is the ouinstance in which quick code is defined |
No |
No |
|
CGRQc_Quick_Code |
varchar(25) |
NULL |
This field captures the CGR quick code |
No |
No |
|
CGRQc_Type |
varchar(5) |
NULL |
This field captures the quick code type of the CGR ’CGC’ - ’CGR Category’ |
No |
No |
|
CGRQc_Desc |
varchar(80) |
NULL |
This field holds the description of the CGR |
No |
No |
|
CGRQc_Status |
varchar(15) |
NULL |
This field holds the Quick code status of the CGR 1.Active 2. Inactive |
No |
No |
|
CGRQc_CreatedDate |
varchar(15) |
NULL |
This field holds the Created Date of the record |
No |
No |
|
CGRQc_Created_By |
varchar(30) |
NULL |
This field holds the user who created the record |
No |
No |
|
CGRQc_ModifiedDate |
varchar(15) |
NULL |
This field holds the modified Date of the record |
No |
No |
|
CGRQc_Modified_By |
varchar(15) |
NULL |
This field holds the user who modified the record |
No |
No |
|
CGRQc_Timestamp |
int |
NULL |
This field holds the timestamp so that more than one user cant modified same record in the same time |
No |
No |
|
|
|||||
|
Table Name cgr_cgrref_reference_dtl |
|
||||
|
|
|||||
|
Table Comment This table stores the reference document information for the customer goods receipt. |
| ||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cgrref_Ouinstance |
int |
NULL |
This field is to define location code unique at Organization unit level |
No |
No |
|
cgrref_CGRno |
varchar(40) |
NULL |
This field holds the Customer goods Receipt number of the document |
No |
No |
|
cgrref_RefType |
varchar(40) |
NULL |
This field holds the Reference document type from the combo which is loading from Logistics common master component |
No |
No |
|
cgrref_RefDocNo |
varchar(40) |
NULL |
This field holds the Reference document number |
No |
No |
|
cgrref_FileName |
varchar(50) |
NULL |
This field holds the filename |
No |
No |
|
cgrref_Remarks |
varchar(255) |
NULL |
This field holds the Remarks |
No |
No |
|
|
|||||
|
Table Name cgr_cust_goods_rcpt_hdr |
|
||||
|
|
|||||
|
Table Comment This field holds the CGR header information of the document |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
CGRHd_Ouinstance |
int |
NULL |
This field holds the ou instance of in which CGR created |
No |
No |
|
CGRHd_CGRno |
varchar(40) |
NULL |
This field holds the CGR number |
No |
No |
|
CGRHd_ReceiptDate |
varchar(15) |
NULL |
This field holds the receipt date on which the goods are received |
No |
No |
|
CGRHd_DocUserStatus |
varchar(25) |
NULL |
This field holds the Document user status. The system lists all the Active quick codes of the type User Status as defined in the ‘Create Quick Codes activity of the current business component. Leave the field blank, if you do not wish to specify the user status. |
No |
No |
|
CGRHd_CGRCategory |
varchar(30) |
NULL |
This field holds the Active quick codes of type CGR Category. The system displays all the Active quick codes of type CGR Category. |
No |
No |
|
CGRHd_status |
varchar(15) |
NULL |
This field holds the CGR status Possible status F Fresh C Cancel FR Freezed MVD Moved PMVD Partially Moved |
No |
No |
|
CGRHd_ReferenceType |
varchar(40) |
NULL |
This field holds the type of the reference document, which could be CO - Customer Order, PO - Purchase Order OTH - Others. |
No |
No |
|
CGRHd_RefDocNo |
varchar(40) |
NULL |
This field holds the unique code identifying the reference document that is associated with the customer goods receipt |
No |
No |
|
CGRHd_RefDocDate |
varchar(15) |
NULL |
This field holds the date of the reference document |
No |
No |
|
CGRHd_OtherRefs |
varchar(255) |
NULL |
This field holds the other additional reference document pertaining to the creation of the customer goods receipt |
No |
No |
|
CGRHd_Cust_Code |
varchar(18) |
NULL |
This field holds the unique code identifying the customer |
No |
No |
|
CGRHd_DeliveryNoteDate |
varchar(15) |
NULL |
This field holds the Delivery note date |
No |
No |
|
CGRHd_DeliveryNoteNo |
varchar(40) |
NULL |
This field holds the Delivery note number |
No |
No |
|
CGRHd_GatePassDate |
varchar(15) |
NULL |
This field holds the unique code identifying the gate pass. date The receiving location issues the gate pass date. |
No |
No |
|
CGRHd_GatePassNo |
varchar(40) |
NULL |
This field holds the unique code identifying the gate pass. The receiving location issues the gate pass. |
No |
No |
|
CGRHd_WayBillDate |
varcahr(15) |
NULL |
This field holds the way bill date is issued by the person who transports the goods from the customer. |
No |
No |
|
CGRHd_WayBillNo |
varchar(40) |
NULL |
This field holds the way bill note is issued by the person who transports the goods from the customer. |
No |
No |
|
CGRHd_noofpacksgr |
int |
NULL |
This field holds the number of cartons or packages in which the customer parts has been packed |
No |
No |
|
CGRHd_FileName |
varchar(50) |
NULL |
This field holds the filename of the CGR document |
No |
No |
|
CGRHd_PackCondition |
varchar(255) |
NULL |
The packaged condition of the parts sent by the customer |
No |
No |
|
CGRHd_ConsignmentWt |
numeric(28,8) |
NULL |
This field holds the weight of the entire consignment |
No |
No |
|
CGRHd_WtUOM |
varchar(10) |
NULL |
This field holds the unit of measurement of the consignment |
No |
No |
|
CGRHd_UserDefinedDet1 |
varchar(25) |
NULL |
Any other additional details pertaining to the modification of the customer goods receipt |
No |
No |
|
CGRHd_UserDefinedDet2 |
varchar(25) |
NULL |
Any other additional details pertaining to the modification of the customer goods receipt |
No |
No |
|
CGRHd_Remarks |
varchar(255) |
NULL |
Any other additional details pertaining to the modification of the customer goods receipt |
No |
No |
|
CGRHd_DefaultWh |
varchar(10) |
NULL |
This field holds the Default warehouse of Part details multiline |
No |
No |
|
CGRHd_TimeStamp |
int |
NULL |
This field holds the timestamp of the CGR document |
No |
No |
|
CGRHd_Createdby |
varchar(30) |
NULL |
This field holds the user who Created the document |
No |
No |
|
CGRHd_CreatedDate |
varchar(15) |
NULL |
This field holds the created date in which the document created |
No |
No |
|
CGRHd_Modifiedby |
varchar(30) |
NULL |
This field holds the modified user in which the document gets modified |
No |
No |
|
CGRHd_ModifiedDate |
varchar(15) |
NULL |
This field holds the modified date in which the document gets modified |
No |
No |
|
CGRHd_CustOU |
int |
NULL |
This field holds the customer ou in which the CGR gets created |
No |
No |
|
CGRHd_WtUOMOU |
int |
NULL |
This field holds the UOM ou |
No |
No |
|
CGRHd_Wh_OU |
int |
NULL |
This field holds the warehouse ou |
No |
No |
|
CGRHd_Feezed_Date |
datetime |
NULL |
This field holds the freezed date If all the part line status are Freezed, Freezed date will update updated |
No |
No |
|
CGRHd_Moved_Date |
datetime |
NULL |
This field holds the moved date. If all the parts are moved to the warehouse. This field will be updated |
No |
No |
|
|
|
|
|
|
|