| 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
Manufraturing 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 Enhncement holds
information about the certificate type |
No |
No |
| cgrptls_certno |
varchar(40) |
NULL |
added for R63 Enhncement holds
information about the certificate no |
No |
No |
| cgrptls_certdate |
varchar(25) |
NULL |
added for R63 Enhncement holds
information about the certificate date |
No |
No |
| cgrptls_authno |
varchar(40) |
NULL |
added for R63 Enhncement 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 Referece
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 receip |
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 |
|
|
|
|
|
|