RFQ_SELECTION |
Default Table Name | RFQ_SELECTION |
Definition |
RFQ_SELECTION Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PROP_KEY![]() |
NUMBER(10, 0) | NO | ||
RFQ_SELECTION_KEY![]() |
NUMBER(5, 0) | NO | ||
VEND_ID![]() |
VARCHAR2(12) | NO | ||
ADDR_DC | VARCHAR2(10) | NO | ||
BUYER_ID![]() |
VARCHAR2(12) | NO | ||
ITEM_KEY | NUMBER(10, 0) | NO | ||
ITEM_ID | VARCHAR2(50) | NO | ||
ITEM_RVSN_ID | VARCHAR2(10) | NO | ||
USER_RVSN_FLD | VARCHAR2(10) | NO | ||
PROV_PART_FL | VARCHAR2(1) | NO | ||
UM_CD | VARCHAR2(3) | YES | ||
BRK_1_QTY | NUMBER(14, 4) | NO | ||
BRK_2_QTY | NUMBER(14, 4) | YES | ||
BRK_3_QTY | NUMBER(14, 4) | YES | ||
BRK_4_QTY | NUMBER(14, 4) | YES | ||
BRK_5_QTY | NUMBER(14, 4) | YES | ||
RFQ_LN_DESC | VARCHAR2(60) | NO | ||
RFQ_LN_NOTES | VARCHAR2(254) | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
TIME_STAMP | DATE | NO |
RFQ_SELECTION Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6849 | PrimaryKey | PROP_KEY, RFQ_SELECTION_KEY |
RFQ_SELECTION Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
PROP_HDR | Identifying | One To Zero or More | F21501 | PROP_KEY | NO | NO | NO | ||
VEND | Non-Identifying | One To Zero or More | F21502 | VEND_ID, COMPANY_ID | NO | NO | NO | ||
BUYER | Non-Identifying | One To Zero or More | F21503 | BUYER_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |