RA_BILL_PLANS_ALL
RA_BILL_PLANS_ALL contains information about recurring bill plans, including billing frequency, contract dates, and invoice attributes.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
RA_BILL_PLAN_ALL_PK |
BILL_PLAN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BILL_PLAN_ID | NUMBER | 18 | Yes | Identifier of the recurring bill plan. | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| BILL_PLAN_NAME | VARCHAR2 | 50 | Name of the bill plan. | ||
| ACTIVE_FLAG | VARCHAR2 | 1 | Option that indicates whether the recurring bill plan is active. | ||
| BATCH_SOURCE_SEQ_ID | NUMBER | 18 | Identifier of the batch source sequence. | ||
| CUST_TRX_TYPE_SEQ_ID | NUMBER | 18 | Identifier of the transaction type sequence. | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Code that identifies the transaction currency. | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type used for the transaction currency. | ||
| EXCHANGE_RATE | NUMBER | Conversion rate used for the transaction currency. | |||
| PRIMARY_RESOURCE_SALESREP_ID | NUMBER | 18 | Identifier of the primary salesperson. | ||
| FIRST_TRANSACTION_DATE | DATE | Creation date of the first invoice generated by the bill plan. | |||
| SECOND_TRANSACTION_DATE | DATE | Creation date of the second invoice generated by the bill plan, when the first invoice was for a partial billing period. | |||
| PERIODICITY_CODE | VARCHAR2 | 30 | Frequency with which invoices are generated by the bill plan. Valid values are DAY, WEEK, MONTH, QUARTER, YEAR. | ||
| CONTRACT_START_DATE | DATE | Date the contract for the recurring bill plan begins. | |||
| CONTRACT_END_DATE | DATE | Date the contract for the recurring bill plan ends. | |||
| SECOND_BILLING_PRD_START_DATE | DATE | Start date of the billing period of the second invoice generated by the bill plan, when the first invoice was for a partial billing period. | |||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | Identifier of the bill-to customer. | ||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | Identifier of the bill-to customer site use. | ||
| BILL_TO_ADDRESS_ID | NUMBER | 18 | Identifier fo the bill-to customer site address. | ||
| BILL_TO_CONTACT_ID | NUMBER | 18 | Identifier of the bill-to customer contact. | ||
| SHIP_TO_PARTY_ID | NUMBER | 18 | Identifier of the ship-to party. | ||
| SHIP_TO_PARTY_SITE_USE_ID | NUMBER | 18 | Identifier of the ship-to party site use. | ||
| SHIP_TO_PARTY_ADDRESS_ID | NUMBER | 18 | Identifier of the ship-to party address. | ||
| SHIP_TO_PARTY_CONTACT_ID | NUMBER | 18 | Identifier of the ship-to party contact. | ||
| TERM_ID | NUMBER | 18 | Identifier of the bill plan payment terms. | ||
| RECEIPT_METHOD_ID | NUMBER | 18 | Identifier of the bill plan payment method. | ||
| PAYMENT_TRXN_EXTENSION_ID | NUMBER | 18 | Identifier of the transaction created in Oracle Fusion Payments for processing the credit card or bank account payment for the generated invoice. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Identifier of the bill plan legal entity. | ||
| GENERATE_BILL_FLAG | VARCHAR2 | 1 | Indicates whether to print the transaction. | ||
| FIRST_PTY_REG_ID | NUMBER | 18 | Tax registration number of the deploying company. | ||
| DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | Default country for tax calculation purposes. | ||
| DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Document Fiscal Classification: attribute used in tax determination for transactions that require special documentation to accompany the transaction. | ||
| SPECIAL_INSTRUCTIONS | VARCHAR2 | 240 | User-defined instructions that appear on a printed transaction. | ||
| PURCHASE_ORDER | VARCHAR2 | 50 | Purchase order number related to the transaction. | ||
| PURCHASE_ORDER_REVISION | VARCHAR2 | 50 | Revision to a purchase order number. | ||
| PURCHASE_ORDER_DATE | DATE | Date of the purchase order related to the transaction. | |||
| LAST_TRANSACTION_DATE | DATE | Parameter of the Generate Recurring Billing Data process that indicates the date of the last transaction generated by the bill plan. Used to determine the start date of new transactions generated by the next process run. | |||
| LAST_PERIOD_NUMBER | NUMBER | Parameter of the Generate Recurring Billing Data process that indicates the last period that transactions were generated by the bill plan. Used to determine the new transactions to generate by the next process run in the next period. | |||
| WAYBILL_NUMBER | VARCHAR2 | 50 | Waybill number related to the transaction. | ||
| 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. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| AI_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the AutoInvoice job that created or last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| RA_BILL_PLANS_ALL | hz_cust_accounts | BILL_TO_CUSTOMER_ID |
| ra_bill_plan_history | ra_bill_plans_all | BILL_PLAN_ID |
| ra_bill_plan_lines_all | ra_bill_plans_all | BILL_PLAN_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RA_BILL_PLANS_N1 | Non Unique | Default | BILL_TO_CUSTOMER_ID |
| RA_BILL_PLANS_N10 | Non Unique | Default | CONTRACT_START_DATE |
| RA_BILL_PLANS_N2 | Non Unique | Default | REQUEST_ID |
| RA_BILL_PLANS_N3 | Non Unique | Default | ACTIVE_FLAG |
| RA_BILL_PLANS_N4 | Non Unique | Default | PERIODICITY_CODE |
| RA_BILL_PLANS_N5 | Non Unique | Default | CREATION_DATE |
| RA_BILL_PLANS_N6 | Non Unique | Default | CONTRACT_END_DATE |
| RA_BILL_PLANS_N7 | Non Unique | Default | BATCH_SOURCE_SEQ_ID |
| RA_BILL_PLANS_N8 | Non Unique | Default | CUST_TRX_TYPE_SEQ_ID |
| RA_BILL_PLANS_N9 | Non Unique | Default | SHIP_TO_PARTY_ID |
| RA_BILL_PLANS_U1 | Unique | Default | BILL_PLAN_ID |
| RA_BILL_PLANS_U2 | Unique | Default | ORG_ID, BILL_PLAN_NAME |