[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_PRICE_ADJUSTMENTS_ARCHIVE |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| FND Design Data: |  PO.PO_PRICE_ADJUSTMENTS_ARCHIVE
|
| Subobject Name: | |
| Status: | VALID |
Price Adjustment Details for PO Line - History
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PO_PRICE_ADJUSTMENTS_ARCH_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PRICE_ADJUSTMENT_ID
REVISION_NUM
|
| PO_PRICE_ADJUSTMENTS_ARCH_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PO_HEADER_ID
|
| PO_PRICE_ADJUSTMENTS_ARCH_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PO_LINE_ID
|
| PO_PRICE_ADJUSTMENTS_ARCH_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LIST_HEADER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PRICE_ADJUSTMENT_ID | NUMBER | Yes | Price Adjustment Unique Identifier | |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PO_HEADER_ID | NUMBER | Yes | PO Header Unique identifier | |
| AUTOMATIC_FLAG | VARCHAR2 | (1) | Yes | Indicates whether this is an automatic price adjustment |
| PO_LINE_ID | NUMBER | Yes | PO Line Unique Identifier | |
| ADJ_LINE_NUM | NUMBER | Price Adjustment Line Number | ||
| CONTEXT | VARCHAR2 | (30) | Descriptive flexfield Context | |
| ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ORIG_SYS_DISCOUNT_REF | VARCHAR2 | (50) | Original system discount reference | |
| CHANGE_SEQUENCE | VARCHAR2 | (50) | Change sequence | |
| LIST_HEADER_ID | NUMBER | Unique identifier of QP List Header | ||
| LIST_TYPE_CODE | VARCHAR2 | (30) | This stores the type of modifier list, for example price list, discount list or promotion | |
| LIST_LINE_ID | NUMBER | Unique Identifier of List Line | ||
| LIST_LINE_TYPE_CODE | VARCHAR2 | (30) | Type of list line | |
| MODIFIED_FROM | VARCHAR2 | (240) | Modified from | |
| MODIFIED_TO | VARCHAR2 | (240) | Modified to | |
| UPDATE_ALLOWED | VARCHAR2 | (1) | Indicates whether the price adjustment is updatable | |
| CHANGE_REASON_CODE | VARCHAR2 | (30) | Change reason code | |
| CHANGE_REASON_TEXT | VARCHAR2 | (2000) | Change reason text | |
| UPDATED_FLAG | VARCHAR2 | (1) | Indicates whether the price adjustment has been updated by user | |
| APPLIED_FLAG | VARCHAR2 | (1) | The lists or list lines that the pricing event applied | |
| OPERAND | NUMBER | Pricing operand | ||
| ARITHMETIC_OPERATOR | VARCHAR2 | (30) | Type of operand | |
| COST_ID | NUMBER | Cost Id | ||
| TAX_CODE | VARCHAR2 | (50) | Tax Code | |
| TAX_EXEMPT_FLAG | VARCHAR2 | (1) | Indicates whether tax is exempted | |
| TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | Tax exempt number | |
| TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax exempt reason code | |
| PARENT_ADJUSTMENT_ID | NUMBER | Parent adjustment id | ||
| INVOICED_FLAG | VARCHAR2 | (1) | Indicates whether the line has been invoiced | |
| ESTIMATED_FLAG | VARCHAR2 | (1) | Estimated flag | |
| INC_IN_SALES_PERFORMANCE | VARCHAR2 | (1) | Reserved for future use | |
| ADJUSTED_AMOUNT | NUMBER | Adjusted amount | ||
| PRICING_PHASE_ID | NUMBER | Pricing Phase identifier | ||
| CHARGE_TYPE_CODE | VARCHAR2 | (30) | Indicates the type of charge, used for Freight/Special Charge-type modifiers | |
| CHARGE_SUBTYPE_CODE | VARCHAR2 | (30) | Indicates the type of charge | |
| RANGE_BREAK_QUANTITY | NUMBER | Pricing request line quantity | ||
| ACCRUAL_CONVERSION_RATE | NUMBER | The rate at which a non-monetary accrual is converted to a monetary value | ||
| PRICING_GROUP_SEQUENCE | NUMBER | Indicates the pricing bucket in which the pricing engine applied the list line | ||
| ACCRUAL_FLAG | VARCHAR2 | (1) | Indicates whether the discount is an accrual or not, i.e whether it should be applied retrospectively | |
| LIST_LINE_NO | VARCHAR2 | (240) | QP Modifier number. This field is applicable in case of Coupon Issue kind of modifier line | |
| SOURCE_SYSTEM_CODE | VARCHAR2 | (30) | Source system which created QP List Header record | |
| BENEFIT_QTY | NUMBER | The accrual quantity for non-monetary accruals or, for promotional goods, item quantity | ||
| BENEFIT_UOM_CODE | VARCHAR2 | (3) | The accrual unit of measure for non-monetary accruals, or item unit of measure for promotional goods | |
| PRINT_ON_INVOICE_FLAG | VARCHAR2 | (1) | Reserved for future use | |
| EXPIRATION_DATE | DATE | Expiration date of the accrual or coupon | ||
| REBATE_TRANSACTION_TYPE_CODE | VARCHAR2 | (30) | Reserved for future use | |
| REBATE_TRANSACTION_REFERENCE | VARCHAR2 | (80) | Reserved for future use | |
| REBATE_PAYMENT_SYSTEM_CODE | VARCHAR2 | (30) | Reserved for future use | |
| REDEEMED_DATE | DATE | Reserved for future use | ||
| REDEEMED_FLAG | VARCHAR2 | (1) | Reserved for future use | |
| MODIFIER_LEVEL_CODE | VARCHAR2 | (30) | The level at which the list line qualified for the transaction | |
| PRICE_BREAK_TYPE_CODE | VARCHAR2 | (30) | Type of price break | |
| SUBSTITUTION_ATTRIBUTE | VARCHAR2 | (30) | Identifies the attribute in the TERMS context that will be substituted, used for modfiers of type Term Substitution | |
| PRORATION_TYPE_CODE | VARCHAR2 | (30) | Reserved for future use | |
| INCLUDE_ON_RETURNS_FLAG | VARCHAR2 | (1) | Applicable to modifiers of type Freight/Special Charge to indicate whether the charge should be included on a return transaction. Not used by pricing engine, for transaction system use only | |
| CREDIT_OR_CHARGE_FLAG | VARCHAR2 | (1) | Credit or charge flag | |
| AC_CONTEXT | VARCHAR2 | (150) | Descriptive flexfield Context | |
| AC_ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| AC_ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| OPERAND_PER_PQTY | NUMBER | Value of pricing request detail line | ||
| ADJUSTED_AMOUNT_PER_PQTY | NUMBER | It holds the value of the bucketed adjusted amount for line types | ||
| INTERCO_INVOICED_FLAG | VARCHAR2 | (1) | Reserved for future use | |
| INVOICED_AMOUNT | NUMBER | Reserved for future use | ||
| RETROBILL_REQUEST_ID | NUMBER | Reserved for future use | ||
| TAX_RATE_ID | NUMBER | (15) | Reserved for future use | |
| LATEST_EXTERNAL_FLAG | VARCHAR2 | (1) | Indicates whether this is the latest archived revision | |
| REVISION_NUM | NUMBER | Yes | Revision number of the record |
Cut, paste (and edit) the following text to query this object:
SELECT PRICE_ADJUSTMENT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, PO_HEADER_ID
, AUTOMATIC_FLAG
, PO_LINE_ID
, ADJ_LINE_NUM
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORIG_SYS_DISCOUNT_REF
, CHANGE_SEQUENCE
, LIST_HEADER_ID
, LIST_TYPE_CODE
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATE_ALLOWED
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, UPDATED_FLAG
, APPLIED_FLAG
, OPERAND
, ARITHMETIC_OPERATOR
, COST_ID
, TAX_CODE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, PARENT_ADJUSTMENT_ID
, INVOICED_FLAG
, ESTIMATED_FLAG
, INC_IN_SALES_PERFORMANCE
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, RANGE_BREAK_QUANTITY
, ACCRUAL_CONVERSION_RATE
, PRICING_GROUP_SEQUENCE
, ACCRUAL_FLAG
, LIST_LINE_NO
, SOURCE_SYSTEM_CODE
, BENEFIT_QTY
, BENEFIT_UOM_CODE
, PRINT_ON_INVOICE_FLAG
, EXPIRATION_DATE
, REBATE_TRANSACTION_TYPE_CODE
, REBATE_TRANSACTION_REFERENCE
, REBATE_PAYMENT_SYSTEM_CODE
, REDEEMED_DATE
, REDEEMED_FLAG
, MODIFIER_LEVEL_CODE
, PRICE_BREAK_TYPE_CODE
, SUBSTITUTION_ATTRIBUTE
, PRORATION_TYPE_CODE
, INCLUDE_ON_RETURNS_FLAG
, CREDIT_OR_CHARGE_FLAG
, AC_CONTEXT
, AC_ATTRIBUTE1
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, OPERAND_PER_PQTY
, ADJUSTED_AMOUNT_PER_PQTY
, INTERCO_INVOICED_FLAG
, INVOICED_AMOUNT
, RETROBILL_REQUEST_ID
, TAX_RATE_ID
, LATEST_EXTERNAL_FLAG
, REVISION_NUM
FROM PO.PO_PRICE_ADJUSTMENTS_ARCHIVE;
PO.PO_PRICE_ADJUSTMENTS_ARCHIVE does not reference any database object
PO.PO_PRICE_ADJUSTMENTS_ARCHIVE is referenced by following:
PO
PO_PRICE_ADJUSTMENTS_ARCHIVE#
|
|
|
|