BT_BID_CLASSES

Bid Classes

tableFINBT

BT_BID_CLASSES — Bid Classes. FIN table in the standard Ross ERP 8.0 schema: 7 columns, used by 9 programs. Columns, data types, keys, foreign keys and relationships.

Open BT_BID_CLASSES in the interactive Data Dictionary →

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

Columns

#ColumnTypeKeyDescription
1GEM_DBKEYintGEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2COMPANY_CODEvarchar(10)PKCompany Code
3DIVISIONvarchar(2)PK FK→AP_CONTROLSDivision
4BT_BID_CLASS_CODEvarchar(6)PKBid Class Code
5SYSTEM_DTIMEdatetimeSystem Date/Time
6USERNAMEvarchar(20)Username
7SYS_CODE_DESCRIPTIONvarchar(30)Code Description

Referenced by · 1 foreign key

BT_BIDS