PJB_BILL_TRXS
This table stores the billing transaction.
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJB_BILL_TRXS_PK |
BILL_TRX_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| BILL_TRX_ID | NUMBER | 18 | Yes | Identifier of the Billing Transaction ***** | ||
| CONTRACT_ID | NUMBER | 18 | Yes | Identifier of the contract ***** | ||
| CONTRACT_LINE_ID | NUMBER | 18 | Identifier of the contract line ***** | |||
| CONTRACT_CONTRIBUTION_PCT | NUMBER | contract contribution percentage ***** | ||||
| CONTRACT_PROJECT_LINKAGE_ID | NUMBER | 18 | Identifier of contract project linkage ***** | |||
| BILL_PLAN_ID | NUMBER | 18 | Yes | Identifier of the bill plan ***** | ||
| MAJOR_VERSION | NUMBER | 18 | major version number of okc table ***** | |||
| LINKED_PROJECT_ID | NUMBER | 18 | Identifier of linked project ***** | |||
| LINKED_TASK_ID | NUMBER | 18 | Identifier of linked task ***** | |||
| MANUAL_FLAG | VARCHAR2 | 1 | Indicator if this distribution is create manually ***** | |||
| REVENUE_PLAN_ID | NUMBER | 18 | Identifier of the revenue plan ***** | |||
| RBS_ELEMENT_ID | NUMBER | 18 | Identifier of the resource member ***** | |||
| BILL_TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Indicator of billing transaction type ***** | |||
| LAST_INV_LINE_DIST_NUM | NUMBER | 18 | Last invoice distribution number ***** | |||
| TRANSACTION_ID | NUMBER | 18 | Expenditure_item_id or Event id ***** | |||
| TRANSACTION_TYPE_ID | NUMBER | 18 | Event or Expenditure transaction type ***** | |||
| TRANSACTION_DATE | DATE | transaction date ***** | ||||
| TRANSACTION_PROJECT_ID | NUMBER | 18 | Identifier of transaction project ***** | |||
| TRANSACTION_TASK_ID | NUMBER | 18 | Identifier of transaction task ***** | |||
| BILL_RATE | NUMBER | Bill rate ***** | ||||
| BILL_EMPLOYEE_BILLING_TITLE | VARCHAR2 | 80 | Employee billing title ***** | |||
| BILL_JOB_BILLING_TITLE | VARCHAR2 | 80 | Job title ***** | |||
| BILL_JOB_ID | NUMBER | 18 | Identifier of job ***** | |||
| INVOICE_AMOUNT_CALC_CODE | VARCHAR2 | 30 | INVOICE_AMOUNT_CALC_CODE ***** | |||
| INVOICE_RATE_SOURCE_ID | NUMBER | 18 | INVOICE_RATE_SOURCE_ID ***** | |||
| INVOICE_DENOM_RATE_ID | NUMBER | 18 | INVOICE_DENOM_RATE_ID ***** | |||
| INV_BURDEN_COMPILE_SET_ID | NUMBER | 18 | INV_BURDEN_COMPILE_SET_ID ***** | |||
| INV_DISCOUNT_REASON_CODE | VARCHAR2 | 30 | For Invoice :Reason code for discount override or rate override | |||
| INVOICE_DISCOUNT_PERCENTAGE | NUMBER | INVOICE_DISCOUNT_PERCENTAGE ***** | ||||
| INVOICE_LABOR_MULTIPLIER | NUMBER | INVOICE_LABOR_MULTIPLIER ***** | ||||
| INVOICE_MARKUP_PERCENTAGE | NUMBER | INVOICE_MARKUP_PERCENTAGE ***** | ||||
| INV_REJECTION_REASON_CODE | VARCHAR2 | 30 | INV_REJECTION_REASON_CODE ***** | |||
| INVOICE_WARNING_MSG_CODE | VARCHAR2 | 30 | INVOICE_WARNING_MSG_CODE ***** | |||
| INV_INCREMENTAL_PERCENTAGE | NUMBER | INV_INCREMENTAL_PERCENTAGE ***** | ||||
| INVOICE_BILLED_PERCENTAGE | NUMBER | INVOICE_BILLED_PERCENTAGE ***** | ||||
| INVOICE_DISTRIBUTED_FLAG | VARCHAR2 | 1 | INVOICE_DISTRIBUTED_FLAG ***** | |||
| INV_ADJ_ELIGIBILITY_FLAG | VARCHAR2 | 1 | INV_ADJ_ELIGIBILITY_FLAG ***** | |||
| INVOICE_NET_ZERO_ADJ_FLAG | VARCHAR2 | 1 | INVOICE_NET_ZERO_ADJ_FLAG ***** | |||
| INVOICE_RECALC_FLAG | VARCHAR2 | 1 | INVOICE_RECALC_FLAG ***** | |||
| INVOICE_ACTIVE_FLAG | VARCHAR2 | 1 | INVOICE_ACTIVE_FLAG ***** | |||
| REVENUE_AMOUNT_CALC_CODE | VARCHAR2 | 30 | REVENUE_AMOUNT_CALC_CODE ***** | |||
| REVENUE_RATE_SOURCE_ID | NUMBER | 18 | REVENUE_RATE_SOURCE_ID ***** | |||
| REVENUE_DENOM_RATE_ID | NUMBER | 18 | REVENUE_DENOM_RATE_ID ***** | |||
| REV_BURDEN_COMPILE_SET_ID | NUMBER | 18 | REV_BURDEN_COMPILE_SET_ID ***** | |||
| REV_DISCOUNT_REASON_CODE | VARCHAR2 | 30 | For Revenue :Reason code for discount override or rate override ***** | |||
| REVENUE_DISCOUNT_PERCENTAGE | NUMBER | Percentage Revenue Accrued ***** | ||||
| REVENUE_LABOR_MULTIPLIER | NUMBER | Audit column for rate derivation. The labor multiplier is used to derive the distribution amount. From Labor_Multiplier table ***** | ||||
| REVENUE_MARKUP_PERCENTAGE | NUMBER | REVENUE_MARKUP_PERCENTAGE ***** | ||||
| REV_REJECTION_REASON_CODE | VARCHAR2 | 30 | REV_REJECTION_REASON_CODE ***** | |||
| REVENUE_WARNING_MSG_CODE | VARCHAR2 | 30 | REVENUE_WARNING_MSG_CODE ***** | |||
| REV_INCREMENTAL_PERCENTAGE | NUMBER | REV_INCREMENTAL_PERCENTAGE ***** | ||||
| REVENUE_RECOGZD_PERCENTAGE | NUMBER | REVENUE_RECOGZD_PERCENTAGE ***** | ||||
| REVENUE_RECOGNZD_FLAG | VARCHAR2 | 1 | REVENUE_RECOGNZD_FLAG ***** | |||
| REV_ADJ_ELIGIBILITY_FLAG | VARCHAR2 | 1 | REV_ADJ_ELIGIBILITY_FLAG ***** | |||
| REVENUE_NET_ZERO_ADJ_FLAG | VARCHAR2 | 1 | REVENUE_NET_ZERO_ADJ_FLAG ***** | |||
| REVENUE_RECALC_FLAG | VARCHAR2 | 1 | REVENUE_RECALC_FLAG ***** | |||
| REVENUE_ACTIVE_FLAG | VARCHAR2 | 1 | REVENUE_ACTIVE_FLAG ***** | |||
| CONTRACT_CURRENCY_CODE | VARCHAR2 | 30 | Contract currency code ***** | |||
| CONT_CURR_INV_RATE_TYPE | VARCHAR2 | 30 | CONT_CURR_INV_RATE_TYPE ***** | |||
| CONT_CURR_INV_EXCHG_DATE | DATE | CONT_CURR_INV_EXCHG_DATE ***** | ||||
| CONT_CURR_INV_EXCHG_RATE | NUMBER | CONT_CURR_INV_EXCHG_RATE ***** | ||||
| CONT_CURR_INV_TXN_AMT | NUMBER | CONT_CURR_INV_TXN_AMT ***** | ||||
| CONT_CURR_INV_ELIGIBLE_AMT | NUMBER | CONT_CURR_INV_ELIGIBLE_AMT ***** | ||||
| CONT_CURR_INV_QUALIFIED_AMT | NUMBER | CONT_CURR_INV_QUALIFIED_AMT ***** | ||||
| CONT_CURR_BILLED_AMT | NUMBER | CONT_CURR_BILLED_AMT ***** | ||||
| CONT_CURR_INV_CREDIT_AMT | NUMBER | CONT_CURR_INV_CREDIT_AMT ***** | ||||
| CONT_CURR_REV_RATE_TYPE | VARCHAR2 | 30 | CONT_CURR_REV_RATE_TYPE ***** | |||
| CONT_CURR_REV_EXCHG_DATE | DATE | CONT_CURR_REV_EXCHG_DATE ***** | ||||
| CONT_CURR_REV_EXCHG_RATE | NUMBER | CONT_CURR_REV_EXCHG_RATE ***** | ||||
| CONT_CURR_REV_TXN_AMT | NUMBER | CONT_CURR_REV_TXN_AMT ***** | ||||
| CONT_CURR_REV_ELIGIBLE_AMT | NUMBER | CONT_CURR_REV_ELIGIBLE_AMT ***** | ||||
| CONT_CURR_REV_QUALIFIED_AMT | NUMBER | CONT_CURR_REV_QUALIFIED_AMT ***** | ||||
| CONT_CURR_REV_RECOGNZED_AMT | NUMBER | CONT_CURR_REV_RECOGNZED_AMT ***** | ||||
| CONT_CURR_REV_CREDIT_AMT | NUMBER | CONT_CURR_REV_CREDIT_AMT ***** | ||||
| TRNS_CURRENCY_CODE | VARCHAR2 | 30 | TRNS_CURRENCY_CODE ***** | |||
| TRNS_CURR_INV_TXN_AMT | NUMBER | TRNS_CURR_INV_TXN_AMT ***** | ||||
| TRNS_CURR_INV_ELIGIBLE_AMT | NUMBER | TRNS_CURR_INV_ELIGIBLE_AMT ***** | ||||
| TRNS_CURR_INV_QUALIFIED_AMT | NUMBER | TRNS_CURR_INV_QUALIFIED_AMT ***** | ||||
| TRNS_CURR_BILLED_AMT | NUMBER | TRNS_CURR_BILLED_AMT ***** | ||||
| TRNS_CURR_INV_CREDIT_AMT | NUMBER | TRNS_CURR_INV_CREDIT_AMT ***** | ||||
| TRNS_CURR_REV_TXN_AMT | NUMBER | TRNS_CURR_REV_TXN_AMT ***** | ||||
| TRNS_CURR_REV_ELIGIBLE_AMT | NUMBER | TRNS_CURR_REV_ELIGIBLE_AMT ***** | ||||
| TRNS_CURR_REV_QUALIFIED_AMT | NUMBER | TRNS_CURR_REV_QUALIFIED_AMT ***** | ||||
| TRNS_CURR_REV_RECOGNZED_AMT | NUMBER | TRNS_CURR_REV_RECOGNZED_AMT ***** | ||||
| TRNS_CURR_REV_CREDIT_AMT | NUMBER | TRNS_CURR_REV_CREDIT_AMT ***** | ||||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 30 | Invoice Currency. | |||
| INVOICE_CURR_RATE_TYPE | VARCHAR2 | 30 | Rate type of the Invoice Currency. | |||
| INVOICE_CURR_DATE_TYPE | VARCHAR2 | 30 | Rate Date type of the Invoice Currency. | |||
| INVOICE_CURR_EXCHG_RATE | NUMBER | Exchange Rate of the Invoice Currency. | ||||
| INVOICE_CURR_EXCHG_DATE | DATE | Exchange Date of the Invoice Currency. | ||||
| INV_CURR_TXN_AMT | NUMBER | Transaction Amount in Invoice Currency. | ||||
| INV_CURR_ELIGIBLE_AMT | NUMBER | Eligible Amount in Invoice Currency. | ||||
| INV_CURR_QUALIFIED_AMT | NUMBER | Qualified Amount in Invoice Currency. | ||||
| INV_CURR_BILLED_AMT | NUMBER | Billed Amount in Invoice Currency. | ||||
| INV_CURR_CREDIT_AMT | NUMBER | Credit Amount in Invoice Currency. | ||||
| REV_CURR_TXN_AMT | NUMBER | Transaction Amount in Revenue Currency. | ||||
| REV_CURR_ELIGIBLE_AMT | NUMBER | Eligible Amount in Revenue Currency. | ||||
| REV_CURR_QUALIFIED_AMT | NUMBER | Qualified Amount in Revenue Currency. | ||||
| REV_CURR_RECOGNZD_AMT | NUMBER | Revenue Recongized Amount in Revenue Currency | ||||
| REV_CURR_CREDIT_AMT | NUMBER | Credit Amount in Revenue Currency. | ||||
| INVOICE_DATE | DATE | invoice date ***** | ||||
| REVENUE_DATE | DATE | revenue date ***** | ||||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | TXN_ACCUM_HEADER_ID ***** | |||
| CONT_CURR_CONCESSION_AMT | NUMBER | Concession amount in contract currency ***** | ||||
| TRNS_CURR_CONCESSION_AMT | NUMBER | Concession amount in transaction currency ***** | ||||
| INV_CURR_CONCESSION_AMT | NUMBER | Concession Amount in Invoice Currency. | ||||
| CONCESSION_PERCENTAGE | NUMBER | Concession percentage ***** | ||||
| CONT_CURR_WRITEOFF_AMT | NUMBER | write off amount in contract currency ***** | ||||
| TRNS_CURR_WRITEOFF_AMT | NUMBER | Write-off amount in transaction currency ***** | ||||
| INV_CURR_WRITEOFF_AMT | NUMBER | Write Off Amount in Invoice Currency. | ||||
| WRITEOFF_PERCENTAGE | NUMBER | Concession percentage ***** | ||||
| BILL_FROM_DATE | DATE | bill from date ***** | ||||
| BILL_TO_DATE | DATE | bill to date ***** | ||||
| REVENUE_CATEGORY_CODE | VARCHAR2 | 30 | REVENUE_CATEGORY_CODE ***** | |||
| REVENUE_CLASSIFICATION_CODE | VARCHAR2 | 30 | REVENUE_CLASSIFICATION_CODE ***** | |||
| BILLING_TYPE_CODE | VARCHAR2 | 30 | Yes | Identifier of billing type. IC(Inter company), IP(Inter project), EX(External) ***** | ||
| EVENT_ID | NUMBER | 18 | Used to mark schedule payment event id on the expenditure bill transactions by invoice ***** | |||
| BILLING_EXTENSION_ID | NUMBER | 18 | Identifier of billing extension ***** | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| EXCEPTION_FLAG | VARCHAR2 | 1 | Indicator of exception. When exceptions occur, this flag is updated ***** | |||
| PRVDR_LEGAL_ENTITY_ID | NUMBER | 18 | PRVDR_LEGAL_ENTITY_ID ***** | |||
| RECVR_LEGAL_ENTITY_ID | NUMBER | 18 | RECVR_LEGAL_ENTITY_ID ***** | |||
| TP_INV_SCH_LINE_PERCENTAGE | NUMBER | TP_INV_SCH_LINE_PERCENTAGE ***** | ||||
| TP_REV_SCH_LINE_PERCENTAGE | NUMBER | TP_REV_SCH_LINE_PERCENTAGE ***** | ||||
| TP_INV_RULE_PERCENTAGE | NUMBER | TP_INV_RULE_PERCENTAGE ***** | ||||
| TP_REV_RULE_PERCENTAGE | NUMBER | TP_REV_RULE_PERCENTAGE ***** | ||||
| RATE_SOURCE_CODE | VARCHAR2 | 30 | RATE_SOURCE_CODE ***** | |||
| IC_TP_BASE_CODE | VARCHAR2 | 30 | IC_TP_BASE_CODE ***** | |||
| IC_TP_AMT_TYPE_CODE | VARCHAR2 | 30 | IC_TP_AMT_TYPE_CODE ***** | |||
| LAST_REV_LINE_NUM | NUMBER | 18 | LAST_REV_LINE_NUM ***** | |||
| BILLING_RESOURCE_ID | NUMBER | 18 | BILLING_RESOURCE_ID ***** | |||
| INVOICE_DENORM_RATE_ID | NUMBER | 18 | INVOICE_DENORM_RATE_ID ***** | |||
| REVENUE_DENORM_RATE_ID | NUMBER | 18 | REVENUE_DENORM_RATE_ID ***** | |||
| LATEST_INVOICE_DIST_ID | NUMBER | 18 | LATEST_INVOICE_DIST_ID ***** | |||
| OUTPUT_TAX_CLASS_CODE | VARCHAR2 | 150 | OUTPUT_TAX_CLASS_CODE ***** | |||
| 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. | |||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
| INV_BILLING_CONTROL_ID1 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID2 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID3 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID4 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID5 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID6 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID7 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID8 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID9 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID10 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID11 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID12 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID13 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID14 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID15 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID16 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID17 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID18 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID19 | NUMBER | 18 | Identifier of the billing control ***** | |||
| INV_BILLING_CONTROL_ID20 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID1 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID2 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID3 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID4 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID5 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID6 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID7 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID8 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID9 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID10 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID11 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID12 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID13 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID14 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID15 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID16 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID17 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID18 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID19 | NUMBER | 18 | Identifier of the billing control ***** | |||
| REV_BILLING_CONTROL_ID20 | NUMBER | 18 | Identifier of the billing control ***** | |||
| TP_BASE_AMOUNT | NUMBER | Trasfer Price Base Amount ***** | ||||
| AMENDMENT_FLAG | VARCHAR2 | 1 | AMENDMENT_FLAG ***** | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Billing Transaction (PJB_BILL_TRXS_FLEX) | |||
| REV_CURR_CONV_OVRRIDE_ID | NUMBER | 18 | Identifier for Bill Transaction to Invoice Currency Conversion Override for Revenue processing. | |||
| CONT_CURR_REV_OVRRIDE_ID | NUMBER | 18 | Identifier for Bill Transaction to Contract Currency Override for Revenue processing. | |||
| CONT_CURR_INV_OVRRIDE_ID | NUMBER | 18 | Identifier for Bill Transaction to Contract Currency Override for Invoice processing. | |||
| INV_CURR_CONV_OVRRIDE_ID | NUMBER | 18 | Identifier for Bill Transaction to Invoice Currency Conversion Override for Invoice processing. | |||
| WORK_TYPE_ID | NUMBER | 18 | Identifier for a worktype assigned to a transaction. | |||
| ORIGINAL_WORK_TYPE_ID | NUMBER | 18 | Identifier for a worktype assigned to a transaction. | |||
| GROUP_ON_WORK_TYPE_FLAG | VARCHAR2 | 1 | Flag to indicate transaction grouping on Work type. When set to 'Y' : Invoice line is grouped on Work type, 'N' : Invoice line is not grouped on Work type. Used by invoice generation process. Not for display. | |||
| NET_CREDIT_FLAG | VARCHAR2 | 1 | Identifier for Net Credit. | |||
| ORIGINAL_DIST_ID | NUMBER | 18 | Identifier for Original Invoice Distribution. | |||
| ORIGINAL_INVOICE_ID | NUMBER | 18 | Identifier of Original Invoice. | |||
| ORIGINAL_INVOICE_LINE_ID | NUMBER | 18 | Identifier of Original Invoice Line. | |||
| LOC_NUMBER | VARCHAR2 | 240 | Identifier for LOC Number. | |||
| DOC_NUMBER | VARCHAR2 | 240 | Identifier for DOC Number. | |||
| MIGRATION_FLAG | VARCHAR2 | 1 | Flag to indicate migrated transaction. | |||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifier of the inventory item. | |||
| ITEM_ORGANIZATION_ID | NUMBER | 18 | Identifier of the inventory item organization. | |||
| REV_QUANTITY | NUMBER | Actual quantity as obtained from the transaction for revenue. | ||||
| INV_QUANTITY | NUMBER | Actual quantity as obtained from the transaction for invoicing. | ||||
| REV_QUALIFIED_QUANTITY | NUMBER | Quantity that is found to be qualified for revenue in terms of the available funding amount. | ||||
| INV_QUALIFIED_QUANTITY | NUMBER | Quantity that is found to be qualified for invoicing in terms of the available funding amount. | ||||
| REV_RECOGNZD_QUANTITY | NUMBER | Quantity that has been revenue recognized. | ||||
| INV_BILLED_QUANTITY | NUMBER | Quantity that has been invoiced. | ||||
| INV_CREDITED_QUANTITY | NUMBER | Quantity that has been credited. | ||||
| UOM_CODE | VARCHAR2 | 30 | Code for the unit of measure. | |||
| TRNS_CURR_REV_UNIT_PRICE | NUMBER | Unit price in transaction currency for revenue. | ||||
| TRNS_CURR_INV_UNIT_PRICE | NUMBER | Unit price in transaction currency for invoicing. | ||||
| INV_CREDITED_PERCENT | NUMBER | Percentage credited during adjustment processing | ||||
| CREATED_BY_PROCESS | VARCHAR2 | 30 | Indicates the process name that creates the record. Possible values INVGEN, REVGEN, INVWRK. | |||
| REV_FROM_DATE | DATE | From Date of the revenue process when the record is updated through revenue process. | ||||
| REV_TO_DATE | DATE | To Date of the revenue process when the record is updated through revenue process. | ||||
| INV_FROM_DATE | DATE | From Date of the invoice process when the record is updated through invoice process. | ||||
| INV_TO_DATE | DATE | To Date of the invoice process when the record is updated through invoice process. | ||||
| DERIVED_BILL_RATE | NUMBER | Unit price in bill transaction currency, derived from the bill rate setup for rate-based contract lines, used to calculate the derived potential amount in bill transaction currency. For all other applicable sources of bill transaction the unit price for revenue recognition and invoicing are stored in TRNS_CURR_REV_UNIT_PRICE and TRNS_CURR_INV_UNIT_PRICE respectively. | ||||
| DERIVED_DISCOUNT_PERCENTAGE | NUMBER | Discount percentage, derived from the bill rate setup for rate-based contract lines, used to calculate the derived bill amount. | ||||
| DERIVED_LABOR_MULTIPLIER | NUMBER | Multiplier, derived from the bill rate setup for rate-based contract lines, used in conjunction with labor cost to calculate the derived bill amount. | ||||
| DERIVED_MARKUP_PERCENTAGE | NUMBER | Markup percentage, derived from the bill rate setup for rate-based contract lines, used to calculate the derived bill amount. | ||||
| DERIVED_TRNS_CURR_TXN_AMT | NUMBER | Potential amount to be billed in bill transaction currency, prior to applying the contract contribution percentage and performing billing control limit checking. | ||||
| INV_GROUP_ATTRIBUTE_VALUES | VARCHAR2 | 4000 | List of attribute values, based on the attributes specified on the applicable invoice format and separated by a delimiter, used to group transactions into invoice lines. | |||
| INV_GROUP_ATTRIBUTE_DESC | VARCHAR2 | 4000 | List of attribute names, as specified on the applicable invoice format and separated by a delimiter, used to group transactions into invoice lines. | |||
| INV_LINE_DESCRIPTION | VARCHAR2 | 240 | Formatted combination of attribute values and text that describes the products, projects, services or goods being charged to the customer on each line of an invoice. | |||
| APPLICABLE_FLAG | VARCHAR2 | 1 | Indicator whether the bill transaction is applicable for invoicing, revenue recognition, or both. | |||
| SOURCE_REFERENCE_ID | NUMBER | 18 | Identifier of the set containing the source transaction related to this bill transaction. For example, where a bill transaction relates to a project cost transaction, this is the identifier of the expenditure batch. | |||
| PREPROCESS_STATUS_FLAG | VARCHAR2 | 1 | Indicator whether the bill transaction is pending rate derivation or ready for invoicing and/or revenue recognition. | |||
| USER_ADJUSTED_FLAG | VARCHAR2 | 1 | Indicator whether the amounts derived by the application, such as bill rate, bill quantity or bill amount, have been overridden by a user. | |||
| CONT_CURR_INV_DATE_TYPE | VARCHAR2 | 30 | Indicator of which date, the transaction date, transaction accounting date, or a user-specified fixed date, to use when converting various invoice amounts from bill transaction currency to contract currency. | |||
| SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | 30 | Classification of the source transaction’s expenditure type, used to control invoicing or revenue recognition for the entire class. | |||
| BILLING_STATUS_CODE | VARCHAR2 | 30 | The billing status of the bill transaction. | |||
| TRNS_CURR_WIP_AMT | NUMBER | The amount remaining to be billed in bill transaction currency, This amount is also referred to as the work-in-progress (or WIP) amount. | ||||
| TRNS_CURR_CNTRB_PCT_TXN_AMT | NUMBER | The potential amount to be billed in transaction currency, after applying the contract contribution percentage. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJB_BILL_TRXS | pjb_bill_plans_b | BILL_PLAN_ID, MAJOR_VERSION |
| PJB_BILL_TRXS | okc_k_headers_all_b | CONTRACT_ID, MAJOR_VERSION |
| PJB_BILL_TRXS | okc_k_lines_b | CONTRACT_LINE_ID, MAJOR_VERSION |
| PJB_BILL_TRXS | pjf_rbs_elements | RBS_ELEMENT_ID |
| PJB_BILL_TRXS | pjb_bill_plans_b | REVENUE_PLAN_ID, MAJOR_VERSION |
| PJB_BILL_TRXS | egp_system_items_b | INVENTORY_ITEM_ID, ITEM_ORGANIZATION_ID |
| pjb_errors | pjb_bill_trxs | BILL_TRX_ID |
| pjb_inv_line_dists | pjb_bill_trxs | BILL_TRX_ID |
| pjb_rev_distributions | pjb_bill_trxs | BILL_TRX_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_BILL_TRXS_N1 | Non Unique | Default | CONTRACT_ID, CONTRACT_LINE_ID, INV_ADJ_ELIGIBILITY_FLAG |
| PJB_BILL_TRXS_N2 | Non Unique | Default | CONTRACT_ID, CONTRACT_LINE_ID, LINKED_PROJECT_ID |
| PJB_BILL_TRXS_N3 | Non Unique | Default | TRANSACTION_ID, BILL_TRANSACTION_TYPE_CODE |
| PJB_BILL_TRXS_N4 | Non Unique | Default | INV_BURDEN_COMPILE_SET_ID |
| PJB_BILL_TRXS_N5 | Non Unique | Default | REV_BURDEN_COMPILE_SET_ID |
| PJB_BILL_TRXS_N6 | Non Unique | Default | REQUEST_ID |
| PJB_BILL_TRXS_N7 | Non Unique | Default | CONTRACT_ID, CONTRACT_LINE_ID, REV_ADJ_ELIGIBILITY_FLAG |
| PJB_BILL_TRXS_N8 | Non Unique | Default | BILL_PLAN_ID, CONTRACT_ID, INVOICE_DISTRIBUTED_FLAG |
| PJB_BILL_TRXS_N9 | Non Unique | Default | CONTRACT_ID, CONTRACT_LINE_ID, BILL_PLAN_ID, PREPROCESS_STATUS_FLAG |
| PJB_BILL_TRXS_U1 | Unique | Default | CONTRACT_ID, CONTRACT_LINE_ID, CONTRACT_PROJECT_LINKAGE_ID, BILL_TRANSACTION_TYPE_CODE, TRANSACTION_ID, INVOICE_ACTIVE_FLAG |
| PJB_BILL_TRXS_U2 | Unique | Default | BILL_TRX_ID, CONTRACT_ID, CONTRACT_LINE_ID |
| PJB_BILL_TRXS_U3 | Unique | Default | BILL_TRX_ID |