Data Dictionary -- Buyer Group

Srl. No.	Table Name	Comment
1	BGP_BGD_BUYER_DTL	This table holds the individual buyer details belonging to a buyer group
2	BGP_BGH_HEADER	This is the header table which contains the buyer group code & its description
3	BGP_BGPC_PART_CAT_MAPPING	This table contains the mapping details of buyer group code with part category.
4	BGP_BGPT_PART_TYPE_MAPPING	Thsi is the table in which part type mapping to the buyer group is done
5	BGP_DOCUMENT_TYPE_MAPPING	This table is used to store the mapping between Buyer group & Document Type
6	BGP_PARAMETER_DETAILS	This table holds the buyer group parameter details
7	BGP_PGDC_DOC_MAPPING	This field holds the buyer group - document mapping details

Table Name :	BGP_BGD_BUYER_DTL
Comment :	This table holds the individual buyer details belonging to a buyer group

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BGD_BUYER_GRP_CODE	_varchar_25	Varchar(25)	No	This field holds the buyer group code	Yes
BGD_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which buyer group is defined	Yes
BGD_BUYER_CODE	_varchar_15	varchar(15)	No	This field holds the buyer code(employee code)	Yes
BGD_EFF_FRM_DT	_datetime_8	datetime(8)	Yes	This field holds the effective from date of the record	No
BGD_EFF_TO_DT	_datetime_8	datetime(8)	Yes	This field holds the effective to date of the record	No
BGD_BYR_MIN_VAL	_decimal_28_8	decimal(28)	Yes	The field holds the minimum value allowed for the buyer	No
BGD_BYR_MAX_VAL	_decimal_28_8	decimal(28)	Yes	The field holds the maximum value allowed for the buyer	No
BGD_BUYER_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Buyer Type like Primary / Secondary	No

Table Name :	BGP_BGH_HEADER
Comment :	This is the header table which contains the buyer group code & its description

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BGH_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which buyer group code is created	Yes
BGH_BUYER_GRP_CODE	_varchar_25	Varchar(25)	No	This field holds the buyer group code	Yes
BGH_BUYER_GRP_DESC	_varchar_150	varchar(150)	Yes	This field holds the buyer group description.	No
BGH_BUYER_GRP_DESC_UP	_varchar_150	varchar(150)	Yes	This field holds the buyer group description in upper case	No
BGH_BG_STATUS	_varchar_25	Varchar(25)	Yes	This field holds the buyer group status Active (A) Inactive (A)	No
BGH_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the timestamp of the record to check the record modified by the used sametime	No
BGH_CREATEDBY	_varchar_30	varchar(30)	Yes	This field is to capture the user who created the record	No
BGH_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field is to capture the created date of the record	No
BGH_MODIFIEDBY	_varchar_30	varchar(30)	Yes	This field is to capture the user who modified the record	No
BGH_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field is to capture the modified date of the record .	No

Table Name :	BGP_BGPC_PART_CAT_MAPPING
Comment :	This table contains the mapping details of buyer group code with part category.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BGPC_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which Buyer group code is defined	Yes
BGPC_BUYER_GRP_CODE	_varchar_25	Varchar(25)	No	This field holds the buyer group code	Yes
BGPC_PART_CAT	_varchar_25	Varchar(25)	No	This field hold sthe part category of buyer group code	Yes
BGPC_PROCESS_FLAG	_varchar_25	Varchar(25)	No	This flag is set when the part type is mapped to the buyer group. Allowed values are 1.Yes 2.No The system displays the options, Yes and No. Select Yes, if you want to map the part category to the buyer group and No if you do not want to map the p	Yes

Table Name :	BGP_BGPT_PART_TYPE_MAPPING
Comment :	Thsi is the table in which part type mapping to the buyer group is done

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BGPT_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which buyer group is created	Yes
BGPT_BUYER_GRP_CODE	_varchar_25	Varchar(25)	No	This field holds the buyer group code	Yes
BGPT_PART_TYPE	_varchar_25	Varchar(25)	No	This field holds the part type sthat are mapped to the buyer group code	Yes
BGPT_PROCESS_FLAG	_varchar_25	Varchar(25)	No	This field holds the proces flag values. Allowed values 1.Yes (Y) 2.No (N) The system displays the options, Yes and No. Select Yes if you want to map the part type to the buyer group and No if you do not want to map the part type. The system sets	Yes

Table Name :	BGP_DOCUMENT_TYPE_MAPPING
Comment :	This table is used to store the mapping between Buyer group & Document Type

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BGDT_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	This is the ouinstance in which buyer group code is defined	Yes
BGDT_BUYER_GRP_CODE	udd_regaucode	varchar(25)	No	This field holds the buyer group code	Yes
BGDT_DOCUMENT	udd_txt150	varchar(150)	No	This field holds the Document code associated for the Buyer Group	Yes
BGDT_DOCUMENT_TYPE	udd_txt150	varchar(150)	No	This field holds the document type mapped to the buyer group code.	Yes
BGDT_MAPPING	udd_chkflag	varchar(1)	No	This flag is set when the document type is mapped to the buyer group. Allowed values are 1.Yes 2.No 3. Blank .The system displays the options Blank, Yes and No.	Yes
BGDT_TIMESTAMP	udd_hrtimestamp	numeric(9)	No	This field holds the timestamp of the record to check the record modified by another used at the sametime	No
BGDT_CREATED_BY	udd_cmnusername	varchar(30)	No	This field is to capture the user name who created the Buyer Group	No
BGDT_CREATED_DATE	udd_datetime1	datetime(8)	No	This field is to capture the created date of the Buyer Group	No
BGDT_MODIFIED_BY	udd_cmnusername	varchar(30)	No	This field is to capture the user name who modifies the record.	No
BGDT_MODIFIED_DATE	udd_datetime1	datetime(8)	No	This field is to capture the modified date of the record.	No

Table Name :	BGP_PARAMETER_DETAILS
Comment :	This table holds the buyer group parameter details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BGP_COMPONENTNAME	_varchar_20	varchar(20)	No	This field holds the Name of the component.	No
BGP_PARAMCATEGORY	_varchar_10	varchar(10)	No	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
BGP_PARAMTYPE	_varchar_25	Varchar(25)	No	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
BGP_PARAMCODE	_varchar_5	varchar(5)	No	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
BGP_PARAMDESC	_varchar_80	varchar(80)	No	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
BGP_LANGID	_decimal_10_0	decimal(10)	No	Language id. This is the language id of the record.	No
BGP_CREATIONDATE	_datetime_8	datetime(8)	Yes	This field holds the record created date for auditing purpose.	No
BGP_SORT_BY	_decimal_10_0	decimal(10)	Yes	This field holds the default sort by code	No

Table Name :	BGP_PGDC_DOC_MAPPING
Comment :	This field holds the buyer group - document mapping details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BGDC_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which buyer group code is defined	Yes
BGDC_BUYER_GRP_CODE	_varchar_25	Varchar(25)	No	This field holds the buyer group code	Yes
BGDC_DOCUMENT	_varchar_150	varchar(150)	No	This is the document for which buyer group is asssigned to. allowed values are purchase Order - PORD Blanket Purchase Order - BPUR Release Slip - RSLP Purchase Request - PREQ Repair Order - RORD Exchange Order - EORD Request for Quotation - RFQ Qu	Yes
BGDC_PROCESS_FLAG	_varchar_25	Varchar(25)	No	This the flag is set when the buyer group is mapped to the document. allowed values are 1.Yes 2.No The system displays the options, Yes and No. Select Yes, if you want to map the document to the buyer group and No if you do not want to map the do	Yes