PJB_BILL_PLANS_INT
Interface table for importing bill and revenue plans in Fusion.
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJB_BILL_PLANS_INT_PK |
BATCH_ID, INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Batch Id is unique for a bulk import batch. | |
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | Unique identifier for each interface row within a batch. | |
| EXT_SOURCE | VARCHAR2 | 150 | Along with Ext_Key, it forms a unique key in pjb_bill_plans_b table. | ||
| EXT_KEY | VARCHAR2 | 150 | Along with Ext_Source, it forms a unique key in pjb_bill_plans_b table. | ||
| HDR_EXT_SOURCE | VARCHAR2 | 150 | Along with Hdr_Ext_Key, it forms a unique key in okc_k_headers_all_b table. | ||
| HDR_EXT_KEY | VARCHAR2 | 150 | Along with Hdr_Ext_Source, it forms a unique key in okc_k_headers_all_b table. | ||
| IMPORT_STATUS_CODE | VARCHAR2 | 30 | Gives status of a row during import. Possible values are - I(In-process), V(Valid), S(Success), W(Warning), E(Error) and X(Format error). | ||
| ACTION_CODE | VARCHAR2 | 30 | Specifies operation for a row. Possible values are NULL, INSERT, UPDATE and DELETE. | ||
| INTERNAL_ACTION_CODE | VARCHAR2 | 30 | Internal column and will be set to UPDATE or INSERT for rows with ACTION_CODE=NULL depending on row already exists or not. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| FILE_NAME_SYSTASK_ID | NUMBER | 18 | Internal column, used by file import to save the individual sys task id for each input csv file. | ||
| FILE_RECORD_NUM | NUMBER | 18 | Internal column, used by file import to save the record number in each input csv file. | ||
| LANGUAGE | VARCHAR2 | 4 | Indicates the code of the language into which the contents of the translatable columns are translated. | ||
| SOURCE_LANG_FLAG | VARCHAR2 | 1 | Indicates the code of the language in which the contents of the translatable columns were originally created is same as language column value or not. | ||
| BILL_PLAN_ID | NUMBER | 18 | Not user enterable. For Internal usage. Refer to pjb_bill_plans_b table for functional usage. | ||
| MAJOR_VERSION | NUMBER | 18 | Not user enterable. For Internal usage. Refer to pjb_bill_plans_b table for functional usage. | ||
| CONTRACT_ID | NUMBER | 18 | Not user enterable. For Internal usage. Refer to pjb_bill_plans_b table for functional usage. | ||
| BILL_METHOD_ID | NUMBER | 18 | Refer to pjb_bill_plans_b table for functional usage. | ||
| BILL_METHOD_NAME | VARCHAR2 | 50 | BILL_METHOD_NAME | ||
| BILL_METHOD_FLAG | VARCHAR2 | 1 | Not user enterable. For Internal usage. Helps in identifying bill meethod name is an invoice method or revenue method. | ||
| BILL_TYPE_CLASS_CODE | VARCHAR2 | 30 | Not user enterable. For Internal usage. | ||
| BILL_PLAN_NAME | VARCHAR2 | 30 | BILL_PLAN_NAME | ||
| BILL_PLAN_DESC | VARCHAR2 | 240 | BILL_PLAN_DESC | ||
| BILL_SET_NUM | NUMBER | BILL_SET_NUM | |||
| ON_HOLD_FLAG | VARCHAR2 | 1 | ON_HOLD_FLAG | ||
| BILL_TO_CUST_ACCT_ID | NUMBER | 18 | BILL_TO_CUST_ACCT_ID | ||
| BILL_TO_CUST_ACCT_NUMBER | VARCHAR2 | 30 | BILL_TO_CUST_ACCT_NUMBER | ||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | BILL_TO_SITE_USE_ID | ||
| BILL_TO_SITE_USE_LOCATION | VARCHAR2 | 150 | BILL_TO_SITE_USE_LOCATION | ||
| BILL_TO_CONTACT_ID | NUMBER | 18 | BILL_TO_CONTACT_ID | ||
| BILL_TO_CONTACT_NAME | VARCHAR2 | 360 | Bill-to Contact Name. It helps in uniquely identifying bill_to_contact_id. | ||
| BILL_TO_CONTACT_EMAIL | VARCHAR2 | 320 | Bill-to Contact Email. If Bill-to Contact Name can't uniquely identify Bill-to Contact Id, Bill-to Contact Email can also be provided along with Bill-to Contact Name to uniquely identify Bill-to Contact Id. | ||
| INVOICE_CURRENCY_OPT_CODE | VARCHAR2 | 30 | INVOICE_CURRENCY_OPT_CODE | ||
| INV_CURR_OPT_MEANING | VARCHAR2 | 80 | INV_CURR_OPT_MEANING | ||
| PAYMENT_TERM_ID | NUMBER | 18 | PAYMENT_TERM_ID | ||
| PAYMENT_TERM_NAME | VARCHAR2 | 15 | PAYMENT_TERM_NAME | ||
| BILLING_CYCLE_ID | NUMBER | 18 | BILLING_CYCLE_ID | ||
| BILLING_CYCLE_NAME | VARCHAR2 | 30 | BILLING_CYCLE_NAME | ||
| FIRST_BILLING_OFFSET_DAYS | NUMBER | FIRST_BILLING_OFFSET_DAYS | |||
| LABOR_INVOICE_FORMAT_ID | NUMBER | 18 | LABOR_INVOICE_FORMAT_ID | ||
| LABOR_INVOICE_FORMAT_NAME | VARCHAR2 | 30 | LABOR_INVOICE_FORMAT_NAME | ||
| NL_INVOICE_FORMAT_ID | NUMBER | 18 | NL_INVOICE_FORMAT_ID | ||
| NL_INVOICE_FORMAT_NAME | VARCHAR2 | 30 | NL_INVOICE_FORMAT_NAME | ||
| EVENTS_INVOICE_FORMAT_ID | NUMBER | 18 | EVENTS_INVOICE_FORMAT_ID | ||
| EVENTS_INVOICE_FORMAT_NAME | VARCHAR2 | 30 | EVENTS_INVOICE_FORMAT_NAME | ||
| EMP_BILL_RATE_SCH_ID | NUMBER | 18 | EMP_BILL_RATE_SCH_ID | ||
| EMP_BILL_RATE_SCH_NAME | VARCHAR2 | 30 | EMP_BILL_RATE_SCH_NAME | ||
| LABOR_SCH_FIXED_DATE | DATE | LABOR_SCH_FIXED_DATE | |||
| LABOR_DISCOUNT_PERCENTAGE | NUMBER | LABOR_DISCOUNT_PERCENTAGE | |||
| LABOR_DISCOUNT_REASON_CODE | VARCHAR2 | 30 | LABOR_DISCOUNT_REASON_CODE | ||
| LABOR_DISC_REASON_MEANING | VARCHAR2 | 80 | LABOR_DISC_REASON_MEANING | ||
| NL_BILL_RATE_SCH_ID | NUMBER | 18 | NL_BILL_RATE_SCH_ID | ||
| NL_BILL_RATE_SCH_NAME | VARCHAR2 | 30 | NL_BILL_RATE_SCH_NAME | ||
| NL_SCH_FIXED_DATE | DATE | NL_SCH_FIXED_DATE | |||
| NL_DISCOUNT_PERCENTAGE | NUMBER | NL_DISCOUNT_PERCENTAGE | |||
| NL_DISCOUNT_REASON_CODE | VARCHAR2 | 30 | NL_DISCOUNT_REASON_CODE | ||
| NL_DISC_REASON_MEANING | VARCHAR2 | 80 | NL_DISC_REASON_MEANING | ||
| JOB_BILL_RATE_SCH_ID | NUMBER | 18 | JOB_BILL_RATE_SCH_ID | ||
| JOB_BILL_RATE_SCH_NAME | VARCHAR2 | 30 | JOB_BILL_RATE_SCH_NAME | ||
| JOB_SET_ID | NUMBER | 18 | Not user enterable. For Internal usage. | ||
| BURDEN_SCH_ID | NUMBER | 18 | BURDEN_SCH_ID | ||
| BURDEN_SCH_NAME | VARCHAR2 | 30 | BURDEN_SCH_NAME | ||
| BURDEN_SCH_FIXED_DATE | DATE | BURDEN_SCH_FIXED_DATE | |||
| ENABLE_LBR_BILL_XTNSN_FLAG | VARCHAR2 | 1 | ENABLE_LBR_BILL_XTNSN_FLAG | ||
| ENABLE_NL_BILL_XTNSN_FLAG | VARCHAR2 | 1 | ENABLE_NL_BILL_XTNSN_FLAG | ||
| LABOR_TP_SCHEDULE_ID | NUMBER | 18 | LABOR_TP_SCHEDULE_ID | ||
| LABOR_TP_SCHEDULE_NAME | VARCHAR2 | 50 | LABOR_TP_SCHEDULE_NAME | ||
| LABOR_TP_SCH_FIXED_DATE | DATE | LABOR_TP_SCH_FIXED_DATE | |||
| NL_TP_SCHEDULE_ID | NUMBER | 18 | NL_TP_SCHEDULE_ID | ||
| NL_TP_SCHEDULE_NAME | VARCHAR2 | 50 | NL_TP_SCHEDULE_NAME | ||
| NL_TP_SCH_FIXED_DATE | DATE | NL_TP_SCH_FIXED_DATE | |||
| BILL_TO_CUSTOMER_LE_ID | NUMBER | 18 | BILL_TO_CUSTOMER_LE_ID | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 30 | INVOICE_CURRENCY_CODE | ||
| INVOICE_CURR_RATE_TYPE | VARCHAR2 | 30 | INVOICE_CURR_RATE_TYPE | ||
| INV_CURR_RATE_USER_CONV_TYPE | VARCHAR2 | 30 | INV_CURR_RATE_USER_CONV_TYPE | ||
| INVOICE_CURR_DATE_TYPE | VARCHAR2 | 30 | INVOICE_CURR_DATE_TYPE | ||
| INV_CURR_DATE_TYPE_MEANING | VARCHAR2 | 80 | INV_CURR_DATE_TYPE_MEANING | ||
| INVOICE_CURR_EXCHG_DATE | DATE | INVOICE_CURR_EXCHG_DATE | |||
| INVOICE_COMMENT | VARCHAR2 | 240 | INVOICE_COMMENT | ||
| INVOICE_INSTRUCTIONS | VARCHAR2 | 240 | INVOICE_INSTRUCTIONS | ||
| LABOR_BILL_BASIS_CODE | VARCHAR2 | 30 | LABOR_BILL_BASIS_CODE | ||
| LABOR_BILL_BASIS_MEANING | VARCHAR2 | 80 | LABOR_BILL_BASIS_MEANING | ||
| LABOR_MARKUP_PERCENTAGE | NUMBER | LABOR_MARKUP_PERCENTAGE | |||
| NL_BILL_BASIS_CODE | VARCHAR2 | 30 | NL_BILL_BASIS_CODE | ||
| NL_BILL_BASIS_MEANING | VARCHAR2 | 80 | NL_BILL_BASIS_MEANING | ||
| NL_MARKUP_PERCENTAGE | NUMBER | NL_MARKUP_PERCENTAGE | |||
| 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. | ||
| INTERNAL_BILL_PLAN_OVN | NUMBER | 9 | Object Version Number copied from corresponding bill plan record. This is used for UPDATE cases to see if record is updated by another user during processing of bulk import and throw error appropriately. | ||
| 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. | |
| 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_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. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_BILL_PLANS_INT_N1 | Non Unique | Default | CONTRACT_ID, BILL_PLAN_NAME, BATCH_ID |
| PJB_BILL_PLANS_INT_N2 | Non Unique | Default | BILL_PLAN_NAME |
| PJB_BILL_PLANS_INT_N3 | Non Unique | Default | BILL_PLAN_ID |
| PJB_BILL_PLANS_INT_N4 | Non Unique | Default | BATCH_ID, EXT_KEY, EXT_SOURCE |
| PJB_BILL_PLANS_INT_U1 | Unique | Default | BATCH_ID, INTERFACE_ROW_ID |