PJB_BILL_PLANS_B
This table contains detailed description and instructions on how to bill the customer for the work performed. An invoice plan/revenue plan is defined in the context of a contract, and can be used by one or more contract lines. This is the MLS enabled table.
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJB_BILL_PLANS_B_PK |
BILL_PLAN_ID, MAJOR_VERSION |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| BILL_PLAN_ID | NUMBER | 18 | Yes | Composite Primary Key with Major Version. ***** | ||
| CURRENCY_OVRRD_FLAG | VARCHAR2 | 1 | CURRENCY_OVRRD_FLAG | |||
| LOC_FLAG | VARCHAR2 | 1 | LOC_FLAG | |||
| DOC_NUMBER | VARCHAR2 | 240 | DOC_NUMBER | |||
| MAJOR_VERSION | NUMBER | 18 | Yes | Major Version denotes version number of a record. ***** | ||
| VERSION_TYPE | VARCHAR2 | 1 | Yes | VERSION TYPE denotes if the record is Current or History or Amendment record. Valid values are 'C' for current, 'H' for history, and 'A' for Amendment. ***** | ||
| BILL_METHOD_ID | NUMBER | 18 | Yes | Identifier of the billing method ***** | ||
| CONTRACT_ID | NUMBER | 18 | Yes | Contract ID. ***** | ||
| 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_SITE_USE_ID | NUMBER | 18 | Customer site 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 ***** | |||
| INVOICE_CURRENCY_OPT_CODE | VARCHAR2 | 30 | Currency option for the bill plan. This should be either contract currency or bill transaction currency ***** | |||
| PAYMENT_TERM_ID | NUMBER | 18 | How often invoice should be created. ***** | |||
| BILLING_CYCLE_ID | NUMBER | 18 | 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 ***** | ||||
| BILL_SET_NUM | NUMBER | Billing set number is used to group invoices together. ***** | ||||
| LAST_BILL_TO_DATE | DATE | Date of the last processed billing transaction. ***** | ||||
| 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 ***** | |||
| 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 ***** | |||
| 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 ***** | |||
| EMP_BILL_RATE_SCH_ID | NUMBER | 18 | Identifier 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 | |||
| NL_BILL_RATE_SCH_ID | NUMBER | 18 | Identifier of the non labor bill rate schedule ***** | |||
| ORGANIZATION_ID | NUMBER | 18 | The identifier of the organization that owns the standard bill rate schedule to which the bill rate belongs ***** | |||
| 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 | |||
| JOB_BILL_RATE_SCH_ID | NUMBER | 18 | Identifier 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_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. ***** | |||
| SOURCE_BILL_PLAN_ID | NUMBER | 18 | SOURCE_BILL_PLAN_ID ***** | |||
| BILL_TYPE_CLASS_CODE | VARCHAR2 | 30 | Bill Type Class Code introduced to resolve UI issue. ***** | |||
| LABOR_TP_SCHEDULE_ID | NUMBER | 18 | Inter Company Transfer Price - Labor Schedule Id ***** | |||
| 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_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 Id ***** | |||
| 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. | ||
| 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_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Bill Plan Descriptive Flex (PJB_BILL_PLANS_DESC_FLEX) | ||
| EXTERNAL_KEY1 | VARCHAR2 | 150 | External key that uniquely identifies a record. | |||
| EXTERNAL_KEY2 | VARCHAR2 | 150 | Additional attribute to qualify external key. | |||
| 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 | |||
| INVOICE_CURR_DATE_TYPE | VARCHAR2 | 30 | Invoice Currency Date Type | |||
| INVOICE_CURR_EXCHG_DATE | DATE | Exchange Date of Invoice Currency | ||||
| LABOR_BILL_BASIS_CODE | VARCHAR2 | 30 | Labor basis for the Cost. It should be either Raw Cost or Burdened 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_MARKUP_PERCENTAGE | NUMBER | Markup percentage to be applied on the Raw Cost or Burdened Cost depending Non Labor Cost Basis. | ||||
| REPORT_TYPE_CODE | VARCHAR2 | 30 | Report type code for Federal and Non Federal reports | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJB_BILL_PLANS_B | pjb_billing_methods_b | BILL_METHOD_ID |
| PJB_BILL_PLANS_B | okc_k_headers_all_b | CONTRACT_ID, MAJOR_VERSION |
| PJB_BILL_PLANS_B | pjb_invoice_formats | LABOR_INVOICE_FORMAT_ID |
| PJB_BILL_PLANS_B | pjb_invoice_formats | NL_INVOICE_FORMAT_ID |
| PJB_BILL_PLANS_B | pjb_invoice_formats | EVENTS_INVOICE_FORMAT_ID |
| PJB_BILL_PLANS_B | pjf_ind_rate_sch_b | BURDEN_SCH_ID |
| PJB_BILL_PLANS_B | pjf_billing_cycles_b | BILLING_CYCLE_ID |
| okc_k_lines_b_h | pjb_bill_plans_b | BILL_PLAN_ID, MAJOR_VERSION |
| okc_k_lines_b_h | pjb_bill_plans_b | REVENUE_PLAN_ID, MAJOR_VERSION |
| pjb_job_title_ovrrds | pjb_bill_plans_b | BILL_PLAN_ID, MAJOR_VERSION |
| pjb_bill_plans_tl | pjb_bill_plans_b | BILL_PLAN_ID, MAJOR_VERSION |
| okc_k_lines_b | pjb_bill_plans_b | BILL_PLAN_ID, MAJOR_VERSION |
| okc_k_lines_b | pjb_bill_plans_b | REVENUE_PLAN_ID, MAJOR_VERSION |
| pjb_labor_mult_ovrrds | pjb_bill_plans_b | BILL_PLAN_ID, MAJOR_VERSION |
| pjb_bill_trxs | pjb_bill_plans_b | BILL_PLAN_ID, MAJOR_VERSION |
| pjb_bill_trxs | pjb_bill_plans_b | REVENUE_PLAN_ID, MAJOR_VERSION |
| pjb_bill_rate_ovrrds | pjb_bill_plans_b | BILL_PLAN_ID, MAJOR_VERSION |
| pjb_inv_prsntmt_options | pjb_bill_plans_b | BILL_PLAN_ID, MAJOR_VERSION |
| pjb_assignment_details | pjb_bill_plans_b | BILL_PLAN_ID, MAJOR_VERSION |
| pjb_job_assgmnt_ovrrds | pjb_bill_plans_b | BILL_PLAN_ID, MAJOR_VERSION |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_BILL_PLANS_B_N1 | Non Unique | Default | BILL_TO_CUST_ACCT_ID, CONTRACT_ID, BILL_METHOD_ID |
| PJB_BILL_PLANS_B_N2 | Non Unique | Default | VERSION_TYPE, BILL_TO_CUST_ACCT_ID |
| PJB_BILL_PLANS_B_N3 | Non Unique | Default | CONTRACT_ID, MAJOR_VERSION, BILL_PLAN_ID |
| PJB_BILL_PLANS_B_U1 | Unique | Default | BILL_PLAN_ID, MAJOR_VERSION |
| PJB_BILL_PLANS_B_U2 | Unique | Default | EXTERNAL_KEY1, EXTERNAL_KEY2 |