Name |
Datatype |
Length |
Prcn |
LIST_LINE_ID |
NUMBER
|
|
|
CREATION_DATE |
DATE
|
|
|
CREATED_BY |
NUMBER
|
|
|
LAST_UPDATE_DATE |
DATE
|
|
|
LAST_UPDATED_BY |
NUMBER
|
|
|
LAST_UPDATE_LOGIN |
NUMBER
|
|
|
PROGRAM_APPLICATION_ID |
NUMBER
|
|
|
PROGRAM_ID |
NUMBER
|
|
|
PROGRAM_UPDATE_DATE |
DATE
|
|
|
REQUEST_ID |
NUMBER
|
|
|
LIST_HEADER_ID |
NUMBER
|
|
|
LIST_LINE_TYPE_CODE |
VARCHAR2
|
(30)
|
|
AUTOMATIC_FLAG |
VARCHAR2
|
(1)
|
|
MODIFIER_LEVEL_CODE |
VARCHAR2
|
(30)
|
|
LIST_PRICE |
NUMBER
|
|
|
LIST_PRICE_UOM_CODE |
VARCHAR2
|
(3)
|
|
PRIMARY_UOM_FLAG |
VARCHAR2
|
(1)
|
|
INVENTORY_ITEM_ID |
NUMBER
|
|
|
ORGANIZATION_ID |
NUMBER
|
|
|
RELATED_ITEM_ID |
NUMBER
|
|
|
RELATIONSHIP_TYPE_ID |
NUMBER
|
|
|
SUBSTITUTION_CONTEXT |
VARCHAR2
|
(30)
|
|
SUBSTITUTION_ATTR |
VARCHAR2
|
(30)
|
|
SUBSTITUTION_VAL |
VARCHAR2
|
(240)
|
|
REVISION |
VARCHAR2
|
(50)
|
|
REVISION_DATE |
DATE
|
|
|
REVISION_REASON_CODE |
VARCHAR2
|
(30)
|
|
CONTEXT |
VARCHAR2
|
(30)
|
|
ATTRIBUTE1 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE2 |
VARCHAR2
|
(240)
|
|
COMMENTS |
VARCHAR2
|
(2000)
|
|
ATTRIBUTE3 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE4 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE5 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE6 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE7 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE8 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE9 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE10 |
VARCHAR2
|
(240)
|
|
INCLUDE_ON_RETURNS_FLAG |
VARCHAR2
|
(1)
|
|
ATTRIBUTE11 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE12 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE13 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE14 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE15 |
VARCHAR2
|
(240)
|
|
PRICE_BREAK_TYPE_CODE |
VARCHAR2
|
(30)
|
|
PERCENT_PRICE |
NUMBER
|
|
|
EFFECTIVE_PERIOD_UOM |
VARCHAR2
|
(3)
|
|
NUMBER_EFFECTIVE_PERIODS |
NUMBER
|
|
|
OPERAND |
NUMBER
|
|
|
ARITHMETIC_OPERATOR |
VARCHAR2
|
(30)
|
|
OVERRIDE_FLAG |
VARCHAR2
|
(1)
|
|
PRINT_ON_INVOICE_FLAG |
VARCHAR2
|
(1)
|
|
REBATE_TRANSACTION_TYPE_CODE |
VARCHAR2
|
(30)
|
|
DB_ESTIM_ACCRUAL_RATE |
NUMBER
|
|
|
PRICE_BY_FORMULA_ID |
NUMBER
|
|
|
GENERATE_USING_FORMULA_ID |
NUMBER
|
|
|
START_DATE_ACTIVE |
DATE
|
|
|
END_DATE_ACTIVE |
DATE
|
|
|
REPRICE_FLAG |
VARCHAR2
|
(1)
|
|
DB_ACCRUAL_FLAG |
VARCHAR2
|
(1)
|
|
PRICING_GROUP_SEQUENCE |
NUMBER
|
|
|
INCOMPATIBILITY_GRP_CODE |
VARCHAR2
|
(30)
|
|
LIST_LINE_NO |
VARCHAR2
|
(30)
|
|
PRODUCT_PRECEDENCE |
NUMBER
|
|
|
PRICING_PHASE_ID |
NUMBER
|
|
|
DB_EXP_PERIOD_START_DATE |
DATE
|
|
|
DB_NUMBER_EXPIRATION_PERIODS |
NUMBER
|
|
|
DB_EXPIRATION_PERIOD_UOM |
VARCHAR2
|
(3)
|
|
DB_EXPIRATION_DATE |
DATE
|
|
|
ESTIM_GL_VALUE |
NUMBER
|
|
|
DB_ACCRUAL_CONVERSION_RATE |
NUMBER
|
|
|
BENEFIT_PRICE_LIST_LINE_ID |
NUMBER
|
|
|
PRORATION_TYPE_CODE |
VARCHAR2
|
(30)
|
|
DB_BENEFIT_QTY |
NUMBER
|
|
|
DB_BENEFIT_UOM_CODE |
VARCHAR2
|
(3)
|
|
CHARGE_TYPE_CODE |
VARCHAR2
|
(30)
|
|
CHARGE_SUBTYPE_CODE |
VARCHAR2
|
(30)
|
|
BENEFIT_LIMIT |
NUMBER
|
|
|
PRICING_ATTRIBUTE_ID |
NUMBER
|
|
|
PRODUCT_ATTRIBUTE_CONTEXT |
VARCHAR2
|
(30)
|
|
PRODUCT_ATTR |
VARCHAR2
|
(30)
|
|
PRODUCT_ATTR_VAL |
VARCHAR2
|
(240)
|
|
PRODUCT_UOM_CODE |
VARCHAR2
|
(3)
|
|
COMPARISON_OPERATOR_CODE |
VARCHAR2
|
(30)
|
|
PRICING_ATTRIBUTE_CONTEXT |
VARCHAR2
|
(30)
|
|
PRICING_ATTR |
VARCHAR2
|
(30)
|
|
PRICING_ATTR_VALUE_FROM |
VARCHAR2
|
(240)
|
|
PRICING_ATTR_VALUE_TO |
VARCHAR2
|
(240)
|
|
PRICING_ATTRIBUTE_DATATYPE |
VARCHAR2
|
(30)
|
|
PRODUCT_ATTRIBUTE_DATATYPE |
VARCHAR2
|
(30)
|
|
EXCLUDER_FLAG |
VARCHAR2
|
(1)
|
|
ATTRIBUTE_GROUPING_NO |
NUMBER
|
|
|
PARENT_LIST_LINE_ID |
NUMBER
|
|
|
TO_RLTD_MODIFIER_ID |
VARCHAR2
|
(30)
|
|
RLTD_MODIFIER_GRP_NO |
VARCHAR2
|
(30)
|
|
RLTD_MODIFIER_GRP_TYPE |
VARCHAR2
|
(30)
|
|
RLTD_MODIFIER_ID |
VARCHAR2
|
(30)
|
|
PRORATION_TYPE |
VARCHAR2
|
(4000)
|
|
PRICING_PHASE |
VARCHAR2
|
(4000)
|
|
INCOMPATIBILITY_GRP |
VARCHAR2
|
(4000)
|
|
MODIFIER_LEVEL |
VARCHAR2
|
(4000)
|
|
LIST_LINE_TYPE |
VARCHAR2
|
(4000)
|
|
PRICE_BREAK_TYPE |
VARCHAR2
|
(4000)
|
|
CHARGE_NAME |
VARCHAR2
|
(4000)
|
|
FORMULA |
VARCHAR2
|
(4000)
|
|
ARITHMETIC_OPERATOR_TYPE |
VARCHAR2
|
(4000)
|
|
EXPIRATION_DATE |
DATE
|
|
|
EXPIRATION_PERIOD_START_DATE |
DATE
|
|
|
NUMBER_EXPIRATION_PERIODS |
NUMBER
|
|
|
EXPIRATION_PERIOD_UOM |
VARCHAR2
|
(3)
|
|
COUP_EXPIRATION_DATE |
DATE
|
|
|
COUP_EXP_PERIOD_START_DATE |
DATE
|
|
|
COUP_NUMBER_EXPIRATION_PERIODS |
NUMBER
|
|
|
COUP_EXPIRATION_PERIOD_UOM |
VARCHAR2
|
(3)
|
|
BRK_EXPIRATION_DATE |
DATE
|
|
|
BRK_EXPIRATION_START_DATE |
DATE
|
|
|
BRK_NUMBER_EXPIRATION_PERIODS |
NUMBER
|
|
|
BRK_EXPIRATION_PERIOD_UOM |
VARCHAR2
|
(3)
|
|
REBATE_TRANSACTION_TYPE |
VARCHAR2
|
(4000)
|
|
BRK_REB_TRANSACTION_TYPE |
VARCHAR2
|
(4000)
|
|
BENEFIT_QTY |
NUMBER
|
|
|
BENEFIT_UOM_CODE |
VARCHAR2
|
(3)
|
|
COUP_BENEFIT_QTY |
NUMBER
|
|
|
COUP_BENEFIT_UOM_CODE |
VARCHAR2
|
(3)
|
|
COUP_LIST_LINE_NO |
VARCHAR2
|
(4000)
|
|
ACCRUAL_FLAG |
VARCHAR2
|
(1)
|
|
BRK_ACCRUAL_FLAG |
VARCHAR2
|
(1)
|
|
ACCRUAL_CONVERSION_RATE |
NUMBER
|
|
|
COUP_ACCRUAL_CONVERSION_RATE |
NUMBER
|
|
|
COUP_ESTIM_ACCRUAL_RATE |
NUMBER
|
|
|
BRK_ACCRUAL_CONVERSION_RATE |
NUMBER
|
|
|
ESTIM_ACCRUAL_RATE |
NUMBER
|
|
|
BRK_ESTIM_ACCRUAL_RATE |
NUMBER
|
|
|
BREAK_LINE_TYPE_CODE |
VARCHAR2
|
(30)
|
|
BREAK_LINE_TYPE |
VARCHAR2
|
(30)
|
|
PRODUCT_ID |
VARCHAR2
|
(30)
|
|
DESCRIPTION |
VARCHAR2
|
(30)
|
|
PRICING_ATTR_SEG_NAME |
VARCHAR2
|
(4000)
|
|
PROD_ATTR_SEGMENT_NAME |
VARCHAR2
|
(4000)
|
|
RELATED_ITEM |
VARCHAR2
|
(4000)
|
|
SUBSTITUTION_ATTRIBUTE |
VARCHAR2
|
(4000)
|
|
SUBSTITUTION_VALUE |
VARCHAR2
|
(4000)
|
|
SUB_SEGMENT_NAME |
VARCHAR2
|
(4000)
|
|
PRODUCT_ATTRIBUTE_TYPE |
VARCHAR2
|
(4000)
|
|
PRODUCT_ATTR_VALUE |
VARCHAR2
|
(4000)
|
|
PRICING_ATTRIBUTE |
VARCHAR2
|
(4000)
|
|
NET_AMOUNT_FLAG |
VARCHAR2
|
(1)
|
|