PO_RETROPRICE_GT
GT table used by retroactive pricing to store records to be retroactively priced
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PO_LINE_ID | NUMBER | Yes | PO_LINE_ID | ||
| DOCUMENT_STATUS | VARCHAR2 | 25 | DOCUMENT_STATUS | ||
| NEW_PRICE | NUMBER | NEW_PRICE | |||
| PO_HEADER_ID | NUMBER | 18 | Yes | PO_HEADER_ID | |
| DIFF_PRICE | VARCHAR2 | 1 | DIFF_PRICE | ||
| CONFIG_COMPONENT_ID | NUMBER | Unique identifier of Configurable Option Component. | |||
| CONFIG_OPTIONS_PRICE | NUMBER | Sum of the extended price of all options chosen per unit of the purchased configuration. | |||
| CONFIG_BASE_MODEL_PRICE | NUMBER | Unit price of the base model only. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| PO_RETROPRICE_GT_N1 | Non Unique | DIFF_PRICE |
| PO_RETROPRICE_GT_N2 | Non Unique | PO_LINE_ID, PO_HEADER_ID |