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 |