PJB_BILL_PLANS_H_B
This table archives the detailed description and instructions on how to bill the customer for the work performed.
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
PJB_BILL_PLANS_H_B_PK |
BILL_PLAN_ID, MAJOR_VERSION |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
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. | ||
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. | ||
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PJB_BILL_PLANS_H_B_U1 | Unique | Default | BILL_PLAN_ID, MAJOR_VERSION |