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 |