PJB_STD_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_std_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. | ||
| CONTRACT_PUID | VARCHAR2 | 150 | Unique identifier of the contract for which bill plans are created. | ||
| 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. | ||
| BILL_PLAN_LANG | 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. | ||
| BILL_METHOD_ID | NUMBER | 18 | Name of the billing method used in the bill plan. | ||
| BILL_METHOD_NAME | VARCHAR2 | 50 | Refer to pjb_bill_methods_tl table for functional usage. | ||
| 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 | Name of the bill plan. | ||
| BILL_PLAN_DESC | VARCHAR2 | 240 | Description of the bill plan. | ||
| BILL_SET_NUM | NUMBER | Billing set number is used to group invoices together. | |||
| ON_HOLD_FLAG | VARCHAR2 | 1 | This column is used to indicate if a bill plan record is on hold. When in hold, no billing downstream processing can occur for the bill plan or revenue plan. Allowed values are, 'Y' or 'N'. | ||
| BILL_TO_CUST_ACCT_ID | NUMBER | 18 | Customer site that the invoices should be sent to and is responsible for the payment. | ||
| BILL_TO_CUST_ACCT_NUMBER | VARCHAR2 | 30 | Customer site number that the invoices should be sent to and is responsible for the payment. | ||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | Customer site that the invoices should be sent to and is responsible for the payment. | ||
| BILL_TO_SITE_USE_LOCATION | VARCHAR2 | 150 | Customer site locatiion that the invoices should be sent to and is responsible for the payment. | ||
| BILL_TO_CONTACT_ID | NUMBER | 18 | Contact person from the Bill-To Customer Site. | ||
| BILL_TO_CONTACT_NAME | VARCHAR2 | 360 | Contact person name from the Bill-To Customer Site. | ||
| BILL_TO_CONTACT_EMAIL | VARCHAR2 | 320 | Contact person email from the Bill-To Customer Site. | ||
| INVOICE_CURRENCY_OPT_CODE | VARCHAR2 | 30 | Currency option for the bill plan. This should be either contract currency or bill transaction currency. | ||
| INV_CURR_OPT_MEANING | VARCHAR2 | 80 | Currency option for the bill plan. This should be either contract currency or bill transaction currency. | ||
| PAYMENT_TERM_ID | NUMBER | 18 | Identifier to indicate how often invoice should be created. | ||
| PAYMENT_TERM_NAME | VARCHAR2 | 15 | Payment term name to indicate how often invoice should be created. | ||
| BILLING_CYCLE_ID | NUMBER | 18 | Identifier to indicate how often invoice should be created. | ||
| BILLING_CYCLE_NAME | VARCHAR2 | 30 | Billing cycle name to indicate how often invoice should be created. | ||
| FIRST_BILLING_OFFSET_DAYS | NUMBER | Number of days that elapse between the project start date and the date of the project's first invoice. | |||
| LABOR_INVOICE_FORMAT_ID | NUMBER | 18 | A set of rules that governs the summarization of invoice distributions into invoice lines. This option is applicable for labor transactions. | ||
| LABOR_INVOICE_FORMAT_NAME | VARCHAR2 | 30 | Name of the labor invoice format rules that governs the summarization of invoice distributions into invoice lines. This option is applicable for labor transactions. | ||
| NL_INVOICE_FORMAT_ID | NUMBER | 18 | A set of rules that governs the summarization of invoice distributions into invoice lines. This option is applicable for non labor transactions. | ||
| NL_INVOICE_FORMAT_NAME | VARCHAR2 | 30 | Name of Non labor format set of rules that governs the summarization of invoice distributions into invoice lines. This option is applicable for non labor transactions. | ||
| EVENTS_INVOICE_FORMAT_ID | NUMBER | 18 | A set of rules that governs the summarization of invoice distributions into invoice lines. This option is applicable for event transactions. | ||
| EVENTS_INVOICE_FORMAT_NAME | VARCHAR2 | 30 | Name of event invoice format set of rules that governs the summarization of invoice distributions into invoice lines. This option is applicable for event transactions. | ||
| EMP_BILL_RATE_SCH_ID | NUMBER | 18 | Identifier of the employee bill rate schedule. | ||
| EMP_BILL_RATE_SCH_NAME | VARCHAR2 | 30 | Name of the employee bill rate schedule. | ||
| LABOR_SCH_FIXED_DATE | DATE | The fixed date used to determine the effective bill rates of the standard labor bill rate schedule. | |||
| LABOR_DISCOUNT_PERCENTAGE | NUMBER | The percentage to be discounted from the standard labor bill rate schedule. | |||
| LABOR_DISCOUNT_REASON_CODE | VARCHAR2 | 30 | Labor rate change reason code used in bill plan. | ||
| LABOR_DISC_REASON_MEANING | VARCHAR2 | 80 | Labor rate change reason code meaning. | ||
| NL_BILL_RATE_SCH_ID | NUMBER | 18 | Identifier of the non labor bill rate schedule. | ||
| NL_BILL_RATE_SCH_NAME | VARCHAR2 | 30 | Name of the non labor bill rate schedule. | ||
| NL_SCH_FIXED_DATE | DATE | The fixed date used to determine the effective bill rates of the standard non labor bill rate schedule. | |||
| NL_DISCOUNT_PERCENTAGE | NUMBER | The percentage to be discounted from the standard non labor bill rate schedule. | |||
| NL_DISCOUNT_REASON_CODE | VARCHAR2 | 30 | Non labor rate change discount code. | ||
| NL_DISC_REASON_MEANING | VARCHAR2 | 80 | Meaning of Non labor rate change discount code. | ||
| JOB_BILL_RATE_SCH_ID | NUMBER | 18 | Identifier of the job bill rate schedule. | ||
| JOB_BILL_RATE_SCH_NAME | VARCHAR2 | 30 | Name of the job bill rate schedule. | ||
| JOB_SET_ID | NUMBER | 18 | Identifier of the job set associated to the job bill rate schedule. | ||
| BURDEN_SCH_ID | NUMBER | 18 | Identifier of the burden schedule. | ||
| BURDEN_SCH_NAME | VARCHAR2 | 30 | Name of the burden schedule used in bill plan. | ||
| BURDEN_SCH_FIXED_DATE | DATE | The fixed date used to determine the effective rates of the burden schedule. | |||
| ENABLE_LBR_BILL_XTNSN_FLAG | VARCHAR2 | 1 | Allowed values are 'Y' or 'N'. If set to 'Y' downstream processes will use labor billing extensions. | ||
| ENABLE_NL_BILL_XTNSN_FLAG | VARCHAR2 | 1 | Allowed values are 'Y' or 'N'. If set to 'Y' downstream processes will use non labor billing extensions. | ||
| LABOR_TP_SCHEDULE_ID | NUMBER | 18 | Inter Company Transfer Price - Labor Schedule Id. | ||
| LABOR_TP_SCHEDULE_NAME | VARCHAR2 | 50 | Name of Inter Company Transfer Price - Labor Schedule. | ||
| LABOR_TP_SCH_FIXED_DATE | DATE | Inter Company Transfer Price - Labor Schedule Fixed Date. | |||
| NL_TP_SCHEDULE_ID | NUMBER | 18 | Inter Company Transfer Price - Non Labor Schedule Id. | ||
| NL_TP_SCHEDULE_NAME | VARCHAR2 | 50 | Name of Inter Company Transfer Price - Non Labor Schedule. | ||
| NL_TP_SCH_FIXED_DATE | DATE | Inter Company Transfer Price - Non Labor Schedule Fixed Date. | |||
| BILL_TO_CUSTOMER_LE_ID | NUMBER | 18 | Inter Company - Bill To Customer Legal Entity Identifier. | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 30 | Invoice in third currency for Billing Currency Type 'USER'. | ||
| INVOICE_CURR_RATE_TYPE | VARCHAR2 | 30 | Rate Type of Invoice Currency used in bill plan. | ||
| INV_CURR_RATE_USER_CONV_TYPE | VARCHAR2 | 30 | User conversion type of Invoice Currency. | ||
| INVOICE_CURR_DATE_TYPE | VARCHAR2 | 30 | Invoice Currency Date Type used in bill plan. | ||
| INV_CURR_DATE_TYPE_MEANING | VARCHAR2 | 80 | Meaning of invoice currency date type. | ||
| INVOICE_CURR_EXCHG_DATE | DATE | Exchange Date of Invoice Currency. | |||
| INVOICE_COMMENT | VARCHAR2 | 240 | User enterable Invoice coment for bill plan | ||
| INVOICE_INSTRUCTIONS | VARCHAR2 | 240 | Invoice instructions for invoices generated using this bill plan. | ||
| LABOR_BILL_BASIS_CODE | VARCHAR2 | 30 | Labor basis for the Cost. It should be either Raw Cost or Burdened Cost . | ||
| LABOR_BILL_BASIS_MEANING | VARCHAR2 | 80 | Meaning of Labor basis for the Cost. | ||
| LABOR_MARKUP_PERCENTAGE | NUMBER | Markup percentage to be applied on the Raw Cost or Burdened Cost depending Labor Cost Basis. | |||
| NL_BILL_BASIS_CODE | VARCHAR2 | 30 | Non Labor basis for the Cost. It should be either Raw Cost or Burdened Cost. | ||
| NL_BILL_BASIS_MEANING | VARCHAR2 | 80 | Meaning of Non Labor basis for the Cost. It should be either Raw Cost or Burdened Cost. | ||
| NL_MARKUP_PERCENTAGE | NUMBER | Markup percentage to be applied on the Raw Cost or Burdened Cost depending Non Labor Cost Basis. | |||
| 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. | ||
| INV_HDR_GROUPING_OPTIONS | VARCHAR2 | 2000 | Stores the list of attributes used to group invoice transactions into distinct invoices for the selected attributes. | ||
| 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 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR22 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR23 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR24 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR25 | VARCHAR2 | 240 | 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_CHAR31 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR32 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR33 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR34 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR35 | 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_STD_BILL_PLANS_INT_N1 | Non Unique | FUSION_TS_INTERFACE | CONTRACT_ID, BILL_PLAN_NAME, BATCH_ID |
| PJB_STD_BILL_PLANS_INT_N2 | Non Unique | FUSION_TS_INTERFACE | BILL_PLAN_NAME, BATCH_ID |
| PJB_STD_BILL_PLANS_INT_N3 | Non Unique | FUSION_TS_INTERFACE | BILL_PLAN_ID, BATCH_ID |
| PJB_STD_BILL_PLANS_INT_N4 | Non Unique | FUSION_TS_INTERFACE | BATCH_ID, EXT_KEY, EXT_SOURCE |
| PJB_STD_BILL_PLANS_INT_U1 | Unique | FUSION_TS_INTERFACE | BATCH_ID, INTERFACE_ROW_ID |