PJB_BILLING_EVENTS_INT
interface to import Billing Events.
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJB_BILLING_EVENTS_INT_PK |
INT_REC_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INT_REC_ID | NUMBER | 18 | Yes | INT_REC_ID | |
| ORGANIZATION_NAME | VARCHAR2 | 240 | ORGANIZATION_NAME | ||
| PROCESS_REQUEST_ID | NUMBER | 18 | PROCESS_REQUEST_ID | ||
| SOURCENAME | VARCHAR2 | 80 | SOURCENAME | ||
| SOURCEREF | VARCHAR2 | 80 | SOURCEREF | ||
| CONTRACT_TYPE_NAME | VARCHAR2 | 150 | CONTRACT_TYPE_NAME | ||
| CONTRACT_NUMBER | VARCHAR2 | 120 | CONTRACT_NUMBER | ||
| CONTRACT_LINE_NUMBER | VARCHAR2 | 150 | CONTRACT_LINE_NUMBER | ||
| EVENT_TYPE_NAME | VARCHAR2 | 240 | EVENT_TYPE_NAME | ||
| EVENT_DESC | VARCHAR2 | 240 | EVENT_DESC | ||
| COMPLETION_DATE | DATE | COMPLETION_DATE | |||
| REVENUE_HOLD_FLAG | VARCHAR2 | 1 | REVENUE_HOLD_FLAG | ||
| BILL_HOLD_FLAG | VARCHAR2 | 1 | BILL_HOLD_FLAG | ||
| PROJECT_NUMBER | VARCHAR2 | 25 | PROJECT_NUMBER | ||
| TASK_NUMBER | VARCHAR2 | 100 | TASK_NUMBER | ||
| BILL_TRNS_AMOUNT | NUMBER | BILL_TRNS_AMOUNT | |||
| BILL_TRNS_CURRENCY_CODE | VARCHAR2 | 15 | BILL_TRNS_CURRENCY_CODE | ||
| LOAD_STATUS | VARCHAR2 | 10 | LOAD_STATUS | ||
| IMPORT_STATUS | VARCHAR2 | 10 | IMPORT_STATUS | ||
| LOAD_REQUEST_ID | NUMBER | 18 | LOAD_REQUEST_ID | ||
| 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. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| BATCH_NUMBER | NUMBER | 18 | Identifes unique batch number | ||
| BATCH_SEQUENCE_NUMBER | NUMBER | Identifies sequence for a batch if a contract number, type combination exceeds one batch size. | |||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR21 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR22 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR23 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR24 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR25 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR26 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR27 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR28 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR29 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR30 | VARCHAR2 | 1000 | 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. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | 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_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| REVERSE_ACCRUAL_FLAG | VARCHAR2 | 1 | Flag that indicates whether or not the event should automatically reverse in the next period. | ||
| ITEM_EVENT_FLAG | VARCHAR2 | 1 | Indicates if the event is item based or non-item based. If the value is Y, the event is item based and item and quantity should be populated on the event. If the value is N, event is non item based and amount should be populated on the event. | ||
| QUANTITY | NUMBER | Quantity of the inventory item on the event. | |||
| ITEM_NUMBER | VARCHAR2 | 300 | Inventory item number on the event. | ||
| UNIT_OF_MEASURE | VARCHAR2 | 25 | Unit of measure of the inventory item on the event. | ||
| UNIT_PRICE | NUMBER | Unit price of the inventory item on the event. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_BILLING_EVENTS_INT_N1 | Non Unique | Default | CONTRACT_NUMBER, CONTRACT_TYPE_NAME, BATCH_NUMBER |
| PJB_BILLING_EVENTS_INT_N2 | Non Unique | Default | BATCH_NUMBER, BATCH_SEQUENCE_NUMBER, PROCESS_REQUEST_ID |
| PJB_BILLING_EVENTS_INT_U1 | Unique | Default | INT_REC_ID |