POR_REQ_SPLIT_LINES_GT
「グローバル一時」表
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: POR
-
オブジェクト・タイプ: TABLE
-
表領域: Default
主キー
| 名前 | 列 |
|---|---|
|
POR_REQ_SPLIT_LINES_GT_PK |
REQUISITION_LINE_ID, BID_NUMBER, BID_LINE_NUMBER |
列
| 名前 | データ型 | 長さ | 非null | コメント |
|---|---|---|---|---|
| AUCTION_HEADER_ID | NUMBER | AUCTION_HEADER_ID | ||
| BID_NUMBER | NUMBER | Yes | BID_NUMBER | |
| BID_LINE_NUMBER | NUMBER | Yes | BID_LINE_NUMBER | |
| REQUISITION_HEADER_ID | NUMBER | Yes | REQUISITION_HEADER_ID | |
| REQUISITION_LINE_ID | NUMBER | Yes | REQUISITION_LINE_ID | |
| ALLOCATED_QTY | NUMBER | ALLOCATED_QTY | ||
| NEW_REQ_LINE_ID | NUMBER | NEW_REQ_LINE_ID | ||
| NEW_LINE_NUM | NUMBER | NEW_LINE_NUM | ||
| TOTAL_ALLOC_REQ_LINE_QTY | NUMBER | TOTAL_ALLOC_REQ_LINE_QTY | ||
| REQUISITION_LINE_QTY | NUMBER | REQUISITION_LINE_QTY | ||
| MIN_BID_NUMBER | NUMBER | MIN_BID_NUMBER | ||
| MIN_BID_LINE_NUMBER | NUMBER | MIN_BID_LINE_NUMBER | ||
| RECORD_STATUS | VARCHAR2 | 1 | RECORD_STATUS |
索引
| 索引 | 一意性 | 列 |
|---|---|---|
| POR_REQ_SPLIT_LINES_GT_U1 | 一意 | BID_NUMBER, BID_LINE_NUMBER, REQUISITION_LINE_ID |
| POR_REQ_SPLIT_LINES_GT_U2 | 一意 | REQUISITION_LINE_ID, BID_NUMBER, BID_LINE_NUMBER |