1. Tables and Views for Financials
  2. RA_BILL_PLAN_LINES_ALL

RA_BILL_PLAN_LINES_ALL

RA_BILL_PLAN_LINES_ALL contains the changes to a recurring bill plan, including amount to credit, quantity to credit, override amount, override quantity, and effective date.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

RA_BILL_PLAN_LINES_PK

BILL_PLAN_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
BILL_PLAN_LINE_ID NUMBER 18 Yes Identifier of the recurring bill plan line.
BILL_PLAN_ID NUMBER 18 Identifier for the recurring bill plan.
LINE_NUMBER NUMBER 18 Transaction line number.
INVENTORY_ITEM_ID NUMBER 18 Identifier of the inventory item on the transaction line.
DESCRIPTION VARCHAR2 240 Description of a bill plan line.
MEMO_LINE_SEQ_ID NUMBER 18 Memo line sequence identifier.
UOM_CODE VARCHAR2 3 Unit of measure code.
QUANTITY NUMBER Total quantity of an item on the sales order line.
UNIT_SELLING_PRICE NUMBER Unit selling price on the sales order line.
AMOUNT NUMBER Total amount of an item on the sales order line.
WAREHOUSE_ID NUMBER 18 Foreign key to the HR_ORGANIZATIONS table. The warehouse identifies the ship-from location and can be used to control taxation.
TAX_CODE VARCHAR2 50 Tax rate code on the transaction line. Required if LINE_TYPE is TAX. Do not use if LINE_TYPE is CHARGES or FREIGHT.
TRX_BUSINESS_CATEGORY VARCHAR2 240 Transaction Business Category Fiscal Classification: attribute used in tax determination that classifies the type of business transaction.
INTENDED_USE_CLASSIF_ID NUMBER 18 Product Intended Use Fiscal Classification: attribute used in tax determination when the intended use of the product is a factor either for tax or the tax recovery rate.
PRODUCT_FISC_CLASSIFICATION VARCHAR2 240 Product Fiscal Classification: attribute used in tax determination for products that have a tax requirement for tax or tax reporting purposes.
PRODUCT_CATEGORY VARCHAR2 240 Product Category Fiscal Classification: attribute used in tax determination for non-inventory products that have a tax requirement for tax or tax reporting purposes.
PRODUCT_TYPE VARCHAR2 240 Attribute used in tax determination that identifies the type of product. Valid values are Goods and Services.
USER_DEFINED_FISC_CLASS VARCHAR2 30 User Defined Fiscal Classification: Attribute used in tax determination to classify any tax requirement that cannot be defined using the existing fiscal classification types.
ASSESSABLE_VALUE NUMBER Attribute used in tax determination that associates a special value with the transaction item to use as the taxable base amount.
TAX_INVOICE_NUMBER VARCHAR2 150 Number on Fiscal document generated during shipment of goods.
TAX_INVOICE_DATE DATE Creation date of the fiscal document, generated during the shipment of goods.
SALES_ORDER VARCHAR2 50 Sales order associated to the bill plan line.
SALES_ORDER_LINE VARCHAR2 30 Sales order line associated with the bill plan.
SALES_ORDER_DATE DATE Date of the sales order associated with the bill plan.
SALES_ORDER_SOURCE VARCHAR2 50 Source of the sales order associated with the bill plan.
SALES_ORDER_REVISION NUMBER Alphanumeric identifier of the sales order revision associated with the bill plan.
TAX_EXEMPT_FLAG VARCHAR2 1 Option that identifies the applicable tax exemption value for the transaction line. Valid values are Require (no exemption), Exempt, and Standard (conditionally exempt).
TAX_EXEMPT_NUMBER VARCHAR2 80 Exemption certificate number, used for transaction lines that have the TAX_EXEMPT_FLAG option set to Exempt.
TAX_EXEMPT_REASON_CODE VARCHAR2 30 Customer exemption reason, used for transaction lines that have the TAX_EXEMPT_FLAG option set to Exempt.
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 1 Option that indicates whether the tax amount on the transaction line is inclusive of tax. Valid values are YES, NO, and NULL. NULL indicates that you cannot override the tax inclusive setting.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
PRICE_EFFECTIVE_DATE DATE Date the changed price becomes effective.
NEW_PRICE NUMBER Changed price on a bill plan line.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table Foreign Table Foreign Key Column
RA_BILL_PLAN_LINES_ALL ra_bill_plans_all BILL_PLAN_ID
ra_bill_plan_history ra_bill_plan_lines_all BILL_PLAN_LINE_ID

Indexes

Index Uniqueness Tablespace Columns
RA_BILL_PLAN_LINES_N1 Non Unique Default BILL_PLAN_ID
RA_BILL_PLAN_LINES_N2 Non Unique Default MEMO_LINE_SEQ_ID
RA_BILL_PLAN_LINES_N3 Non Unique Default INVENTORY_ITEM_ID
RA_BILL_PLAN_LINES_U1 Unique Default BILL_PLAN_LINE_ID