BT_BID_RESPONSE_LINES

Name: BT_BID_RESPONSE_LINES
Creator: Ryan Brents
License: https://creativecommons.org/licenses/by/4.0/

Response Lines

tableFINBT

BT_BID_RESPONSE_LINES — Response Lines. FIN table in the standard Ross ERP 8.0 schema: 25 columns, used by 11 programs. Columns, data types, keys, foreign keys and relationships.

Open BT_BID_RESPONSE_LINES in the interactive Data Dictionary →

Part of BT tables & objects · all tables, views & procedures

Columns

#	Column	Type	Key	Description
1	GEM_DBKEY	int		GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2	COMPANY_CODE	varchar(10)	PK	Company Code
3	DIVISION	varchar(2)	PK	Division
4	BT_BID_ID	int	PK	Bid ID
5	VENDOR_NUMBER	varchar(12)	PK FK→BT_BID_RESPONSES	Supplier Number (or ID)
6	BT_BID_LINE_NBR	smallint	PK FK→BT_BID_LINES	Bid Line Number
7	BT_DELIVERY_DATE	datetime		Delivery Date
8	BT_MANUFACTURER_ID	varchar(30)		Manufacturer
9	BT_CATALOG_NBR	varchar(8)		Catalog Number
10	SYSTEM_DATE	datetime		System Date Transaction Made
11	USERNAME	varchar(20)		Username
12	BT_VENDOR_PART_CODE	varchar(15)		Supplier Product
13	BT_VENDOR_PART_DESC	varchar(25)		Product Description
14	BT_SUBSTITUTE_FLAG	varchar(1)		Substitute
15	BT_COMMENTS	text		Comments
16	PART_CODE	varchar(15)	FK→PRODUCT_MASTER	Product
17	BT_RESPONSE_QTY	numeric(20,6)		Response Quantity
18	BT_QTY_UOM	varchar(4)	FK→UNITS_OF_MEASURE	Unit of Measure (Response Quantity)
19	BT_RESPONSE_PRICE	numeric(20,4)		Response Price
20	BT_PRICE_UOM	varchar(4)	FK→UNITS_OF_MEASURE	Unit of Measure (Bid Response Price)
21	BT_AWARDED_QTY	numeric(20,6)		Awarded Quantity
22	WAREHOUSE	varchar(2)	FK→WAREHOUSE_CONTROLS	Warehouse Code
23	LINE_TYPE	varchar(1)		Line Type
24	BT_REMARKS	text		Remarks
25	GEM_ARCHIVE_FLAG	varchar(20)		System flag indicating whether the row has been archived by the GEMBASE archive process.