Buyer Group

Table Name bgp_bgd_buyer_dtl

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

bgd_byr_min_val

decimal(28,8)

NULL

The field holds the minimum value allowed for the buyer

No

No

bgd_eff_to_dt

datetime

NULL

This field holds the effective to date of the record

No

No

bgd_byr_max_val

decimal(28,8)

NULL

The field holds the maximum value allowed for the buyer

No

No

bgd_buyer_type

sql_variant

NULL

This field holds the Buyer Type like Primary / Secondary

No

No

bgd_buyer_grp_code

varchar(25)

NOT NULL

This field holds the buyer group code

Yes

Yes

bgd_eff_frm_dt

datetime

NULL

This field holds the effective from date of the record

No

No

bgd_ouinstance

numeric(10)

NOT NULL

This is the ou instance in which buyer group is defined

Yes

Yes

bgd_buyer_code

varchar(15)

NOT NULL

This field holds the buyer code (employee code)

Yes

No

Table Name bgp_bgh_header

Table Comment This is the header &nbsptable which contains the buyer group code & its description

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

bgh_ouinstance

numeric(10)

NOT NULL

This is the ou instance in which buyer group code is defined

Yes

No

bgh_buyer_grp_code

varchar(25)

NOT NULL

This field holds the buyer group code

Yes

No

bgh_buyer_grp_desc

varchar(150)

NULL

This field holds the buyer group description.

No

No

BGH_BUYER_GRP_DESC_UP

varchar(150)

NULL

This field holds the buyer group description in upper case

No

No

bgh_bg_status

varchar(25)

NULL

This field holds the buyer group status Active (A) Inactive (A)

No

No

bgh_timestamp

numeric(10)

NULL

This field holds the timestamp of the record to check the record modified by the used same time

No

No

bgh_createdby

varchar(30)

NULL

This field is to capture the user who created the record

No

No

bgh_createddate

datetime

NULL

This field is to capture the created date of the record

No

No

bgh_modifiedby

varchar(30)

NULL

This field is to capture the user who modified the record

No

No

bgh_modifieddate

datetime

NULL

This field is to capture the modified date of the record .

No

No

Table Name bgp_bgh_header_tmp

Table Comment This is the header temporary table which holds the buyer group code and its description

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

bgh_guid

varchar(40)

NOT NULL

This field holds the uniquely generated guid

No

No

bgh_ouinstance

numeric(10)

NOT NULL

This is the ou instance in which buyer group code is created

No

No

bgh_buyer_grp_code

varchar(25)

NOT NULL

This field holds the buyer group code

No

No

bgh_buyer_grp_desc

varchar(150)

NULL

This field holds the buyer group description

No

No

bgh_bg_status

varchar(25)

NULL

This field holds the buyer group status. Allowed values are A-Active I- Inactive

No

No

bgh_bg_flag

varchar(1)

NULL

This is the buyer group flag used to indicate error in processing

No

No

Table Name bgp_bgpc_part_cat_mapping

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

bgpc_part_cat

varchar(25)

NOT NULL

This field holds the part category of buyer group code

Yes

No

bgpc_process_flag

varchar(25)

NOT NULL

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 part category. The system sets the field blank by default.

Yes

bgpc_buyer_grp_code

varchar(25)

NOT NULL

This field holds the buyer group code

Yes

Yes

bgpc_ouinstance

numeric(10)

NOT NULL

This is the ou instance in which Buyer group code is defined

Yes

Yes

Table Name bgp_bgpt_part_type_mapping

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

bgpt_part_type

varchar(25)

NOT NULL

This field holds the part type that are mapped to the buyer group code

Yes

No

bgpt_process_flag

varchar(25)

NOT NULL

This field holds the process 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 the field blank by default.

Yes

No

bgpt_buyer_grp_code

varchar(25)

NOT NULL

This field holds the buyer group code

Yes

Yes

bgpt_ouinstance

numeric(10)

NOT NULL

This is the ou instance in which buyer group is created

Yes

Yes

Table Name BGP_DOCUMENT_TYPE_MAPPING

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

BGDT_OUINSTANCE

int

NOT NULL

This is the ou instance in which buyer group code is defined

Yes

No

BGDT_BUYER_GRP_CODE

sql_variant

NOT NULL

This field holds the buyer group code

Yes

No

BGDT_DOCUMENT

sql_variant

NOT NULL

This field holds the Document code associated for the Buyer Group

Yes

No

BGDT_DOCUMENT_TYPE

sql_variant

NOT NULL

This field holds the document type mapped to the buyer group code.

Yes

No

BGDT_MAPPING

sql_variant

NOT NULL

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

No

bhg_ouinstance

numeric(10)

NOT NULL

This is the ou instance in which buyer group code is defined

Yes

Yes

bgh_buyer_grp_code

varchar(25)

NOT NULL

This field holds the buyer group code

Yes

Yes

BGDT_TIMESTAMP

bigint

NOT NULL

This field holds the timestamp of the record to check the record modified by another used at the same time

No

No

BGDT_CREATED_BY

sql_variant

NOT NULL

This field is to capture the user name who created the  Buyer Group

No

No

BGDT_CREATED_DATE

datetime

NOT NULL

This field is to capture the created date of the Buyer Group

No

No

BGDT_MODIFIED_BY

sql_variant

NOT NULL

This field is to capture the user name who modifies the record.

No

No

BGDT_MODIFIED_DATE

datetime

NOT NULL

This field is to capture the modified date of the record.

No

No

Table Name bgp_parameter_details

Table Comment This table holds the buyer group parameter details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

bgp_componentname

varchar(20)

NOT NULL

This field holds the Name of the component.

No

No

bgp_ParamCategory

varchar(10)

NOT 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

bgp_ParamType

varchar(25)

NOT 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

bgp_ParamCode

varchar(5)

NOT 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

bgp_ParamDesc

varchar(80)

NOT 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

bgp_Langid

numeric(10)

NOT NULL

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

No

No

bgp_Creationdate

datetime

NULL

This field holds the record created date for auditing purpose.

No

No

bgp_sort_by

numeric(10)

NULL

This field holds the default sort by code

No

No

Table Name bgp_pgdc_doc_mapping

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

bgdc_document

varchar(150)

NOT NULL

This is the document for which buyer group is assigned to. allowed values are purchase Order - PORD Blanket Purchase Order - &nbspBPUR Release Slip - RSLP Purchase Request - PREQ Repair Order - RORD Exchange Order - EORD Request for Quotation - RFQ Quotation - QUOT SubContract order - SCORD

Yes

No

bgdc_process_flag

varchar(25)

NOT NULL

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 document. The system sets the field blank by default.

Yes

bgdc_buyer_grp_code

varchar(25)

NOT NULL

This field holds the buyer group code

Yes

Yes

bgdc_ouinstance

numeric(10)

NOT NULL

This is the ou instance in which buyer group code is defined

Yes

Yes