PJB_INV_LINE_DISTS
This table stores the invoice lines distributions.
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJB_INV_LINE_DISTS_PK |
INVOICE_DIST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INVOICE_DIST_ID | NUMBER | 18 | Yes | Identifier of the Invoice Line ***** | |
| LOC_NUMBER | VARCHAR2 | 240 | Letter Of Credit Number on Grants Contract BillPlan | ||
| DOC_NUMBER | VARCHAR2 | 240 | Document Number on Grants Contract BillPlan | ||
| INVOICE_ID | NUMBER | 18 | Identifier of the Invoice ***** | ||
| INVOICE_LINE_ID | NUMBER | 18 | Identifier of the invoice line ***** | ||
| INV_LINE_DIST_NUM | NUMBER | 18 | Invoice distribution number ***** | ||
| BILL_TRX_ID | NUMBER | 18 | The identifier of the expenditure item/event that is invoice distributed by the distribution line ***** | ||
| CONTRACT_ID | NUMBER | 18 | Yes | Identifier of the contract ***** | |
| CONTRACT_LINE_ID | NUMBER | 18 | Yes | Identifier of the contract line ***** | |
| CONTRACT_PROJECT_LINKAGE_ID | NUMBER | 18 | Identifier of the contract project linkage ***** | ||
| BILL_PLAN_ID | NUMBER | 18 | Yes | Identifier of the bill plan ***** | |
| MAJOR_VERSION | NUMBER | 18 | Version number of contract ***** | ||
| BILL_SET_NUM | NUMBER | 18 | Identifier of the bill set which is defined in bill plan ***** | ||
| BILL_TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Billing Transaciton Type Code ***** | ||
| TRANSACTION_ID | NUMBER | 18 | Yes | The identifier of the expenditure item/event that is invoice distributed by the distribution line ***** | |
| TP_BASE_AMOUNT | NUMBER | Transfer Price Base Amount ***** | |||
| TRANSACTION_TYPE_ID | NUMBER | 18 | Identifier of Event Type or Expenditure Item Type ***** | ||
| TRANSACTION_DATE | DATE | Date when transaction occurs ***** | |||
| LINKED_PROJECT_ID | NUMBER | 18 | Identifier of project that is linked to contract ***** | ||
| LINKED_TASK_ID | NUMBER | 18 | Identifier of task that is linked to contract ***** | ||
| TRANSACTION_PROJECT_ID | NUMBER | 18 | Identifier of project ***** | ||
| TRANSACTION_TASK_ID | NUMBER | 18 | Identifier of task ***** | ||
| BILL_RATE | NUMBER | Audit column. Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule | |||
| BILL_EMPLOYEE_BILLING_TITLE | VARCHAR2 | 80 | Employee Billing Title ***** | ||
| BILL_JOB_BILLING_TITLE | VARCHAR2 | 80 | Billing Job Title ***** | ||
| BILL_JOB_ID | NUMBER | 18 | The identifier of the effective job used when invoicing a labor item as of the last time the expenditure item was invoiced ***** | ||
| INVOICE_AMOUNT_CALC_CODE | VARCHAR2 | 30 | Audit Column for rate derivation. Valid values are Indirect(I), Overrides(O), Extension (E), Bill rates (B) , Labor Multiplier (L) ***** | ||
| INVOICE_RATE_SOURCE_ID | NUMBER | 18 | Audit Column for bill rate derivation. It stores the rate schedule id of bill rate schedule was used, override id if override used ***** | ||
| INVOICE_DENOM_RATE_ID | NUMBER | 18 | INVOICE_DENOM_RATE_ID ***** | ||
| INV_BURDEN_COMPILE_SET_ID | NUMBER | 18 | dentifier of the compiled set used to calculate a burden schedule ***** | ||
| INV_DISCOUNT_REASON_CODE | VARCHAR2 | 30 | Reason code for discount override or rate override ***** | ||
| INVOICE_DISCOUNT_PERCENTAGE | NUMBER | Discount Percentage is used to calculate the adjusted invoice and rate ***** | |||
| INVOICE_LABOR_MULTIPLIER | NUMBER | Audit Column for rate derivation ***** | |||
| INVOICE_MARKUP_PERCENTAGE | NUMBER | Audit Column for bill rate derivation. Markup Percentage used in derving bill rate was based on a markup in bill rate schedule. ***** | |||
| INV_REJECTION_REASON_CODE | VARCHAR2 | 30 | Invoice generation rejection reason code ***** | ||
| INV_WARNING_MSG_CODE | VARCHAR2 | 30 | During funds check if the transaction passes in advisory mode then this column will be updated with the apropriate warning ***** | ||
| INV_INCREMENTAL_PERCENTAGE | NUMBER | Invoice incremental percentage ***** | |||
| INVOICED_FLAG | VARCHAR2 | 1 | Indicates whether the detail line has been invoiced(included on an invoice). Default value is 'N'. | ||
| INV_DISTRIBUTION_TYPE_CODE | VARCHAR2 | 30 | Invoice distribution type code ***** | ||
| TRNS_CURRENCY_CODE | VARCHAR2 | 30 | Transaction currency for the expenditure or events. ***** | ||
| TRNS_CURR_BILLED_AMT | NUMBER | Transaction currency billed amount ***** | |||
| CONTRACT_CURRENCY_CODE | VARCHAR2 | 30 | Contract currency code ***** | ||
| CONT_CURR_INV_RATE_TYPE | VARCHAR2 | 30 | Contract Currency Rate Type Code ***** | ||
| CONT_CURR_INV_EXCHG_RATE | NUMBER | Contract currency exchange rate ***** | |||
| CONT_CURR_INV_EXCHG_DATE | DATE | Contract currency date ***** | |||
| CONT_CURR_INV_DATE_TYPE | VARCHAR2 | 30 | CONT_CURR_INV_DATE_TYPE ***** | ||
| CONT_CURR_BILLED_AMT | NUMBER | Amount in contract currency ***** | |||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 30 | Invoice currency code ***** | ||
| 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 for the Invoice Currency | |||
| INVOICE_CURR_EXCHG_DATE | DATE | Exchange Date of the Invoice Currency | |||
| INVOICE_CURR_BILLED_AMT | NUMBER | Invoice currency billed amount ***** | |||
| INVOICE_CURR_CREDIT_AMT | NUMBER | Invoice currency credit amount ***** | |||
| INVOICE_CURR_CREDIT_PCT | NUMBER | Invoice currency credit percentage ***** | |||
| PROJECT_CURRENCY_CODE | VARCHAR2 | 30 | Project currency code ***** | ||
| PROJECT_CURR_INV_RATE_TYPE | VARCHAR2 | 30 | Project Currency Rate Type ***** | ||
| PROJECT_CURR_INV_EXCHG_RATE | NUMBER | Project Exchange Rate ***** | |||
| PROJECT_CURR_INV_EXCHG_DATE | DATE | Project Exchange date ***** | |||
| PROJ_CURR_INV_DATE_TYPE | VARCHAR2 | 30 | PROJ_CURR_INV_DATE_TYPE ***** | ||
| PROJECT_CURR_BILLED_AMT | NUMBER | Amount in Project Currency ***** | |||
| LEDGER_CURRENCY_CODE | VARCHAR2 | 30 | Ledger currency code ***** | ||
| LEDGER_CURR_INV_RATE_TYPE | VARCHAR2 | 30 | Ledger Currency Rate Type ***** | ||
| LEDGER_CURR_INV_EXCHG_DATE | DATE | Ledger Exchange date ***** | |||
| LEDGER_CURR_INV_EXCHG_RATE | NUMBER | Ledger currency exchange rate ***** | |||
| LEDGER_CURR_INV_DATE_TYPE | VARCHAR2 | 30 | LEDGER_CURR_INV_DATE_TYPE ***** | ||
| LEDGER_CURR_BILLED_AMT | NUMBER | Ledger currency billed amount ***** | |||
| TRNS_CURR_CREDIT_AMT | NUMBER | TRNS_CURR_CREDIT_AMT ***** | |||
| CONT_CURR_CREDIT_AMT | NUMBER | CONT_CURR_CREDIT_AMT ***** | |||
| TRNS_CURR_CONCESSION_AMT | NUMBER | Processing column to store concession amount in transaction currency ***** | |||
| TRNS_CURR_WRITEOFF_AMT | NUMBER | Processing column to store write-off amount in transaction currency ***** | |||
| CONT_CURR_CONCESSION_AMT | NUMBER | Processing column to store concession amount in contract currency ***** | |||
| CONT_CURR_WRITEOFF_AMT | NUMBER | Processing column to store write-off amount in contract currency ***** | |||
| INV_CURR_CONCESSION_AMT | NUMBER | Concession Amount in Invoice Currency | |||
| INV_CURR_WRITEOFF_AMT | NUMBER | Write Off in Invoice Currency | |||
| CREDITED_INVOICE_ID | NUMBER | 18 | Identifier of invoice that is credited by this line ***** | ||
| CREDITED_INVOICE_LINE_ID | NUMBER | 18 | Identifier of invoice line that is credited by this line ***** | ||
| INVOICE_DATE | DATE | Invoice date ***** | |||
| REVENUE_DATE | DATE | Revenue date ***** | |||
| BILL_FROM_DATE | DATE | The date from which transactions are picked up. Expenditure items with the expenditure item date on or after the bill from date and events with completion dates on or after the bill from date may be included on an invoice. ***** | |||
| BILL_TO_DATE | DATE | The date to which transactions are picked up. Expenditure items with the expenditure item date on or before the bill to date and events with completion dates on or before the bill to date may be included on an invoice. ***** | |||
| RBS_ELEMENT_ID | NUMBER | 18 | Identifier of resource breakdown structure element ***** | ||
| READY_TO_ACCRUAL_FLAG | VARCHAR2 | 1 | Ready to accrual flag ***** | ||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Transaction accum header id ***** | ||
| CREDITED_DIST_ID | NUMBER | 18 | Identifier of distribution credited by this distribution ***** | ||
| CANCELED_FLAG | VARCHAR2 | 1 | Canceled flag ***** | ||
| BILLING_TYPE_CODE | VARCHAR2 | 30 | Yes | Identifier of billing type. IC(Inter company), IP(Inter project), EX(External) ***** | |
| OUTPUT_TAX_CLASS_CODE | VARCHAR2 | 30 | Tax calssification code ***** | ||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | The mandatory tax attribute is a classification or categorization of a transaction for tax purposes as required by a tax authority ***** | ||
| INTENDED_USE | VARCHAR2 | 240 | This optional value is a classification of the product(s) by tax authority for tax purposes. ***** | ||
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | 240 | This optional value is a classification of the product(s) by tax authority for tax purposes. It is based on the inventory item category ***** | ||
| PRODUCT_CATEGORY | VARCHAR2 | 240 | This optional value is used to classify products for tax purposes. It is used where Oracle Inventory is not installed, or is installed but not used for classifying products for tax purposes ***** | ||
| PRODUCT_TYPE | VARCHAR2 | 240 | This optional value is another product related classification in E-Business Tax. The value of product type specifies whether the transaction line is for a good, or a service, or it is a memo line ***** | ||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | 240 | This optional value is based on the default taxation country. It can also be entered by the user. ***** | ||
| ASSESSABLE_VALUE | NUMBER | Assessed value for tax calculation purposes. This optional value is to be entered in invoice currency. | |||
| PROD_FC_CATEG_ID | NUMBER | 18 | PROD_FC_CATEG_ID | ||
| INTENDED_USE_CLASSIF_ID | NUMBER | 18 | INTENDED_USE_CLASSIF_ID | ||
| OUTPUT_TAX_EXEMPT_FLAG | VARCHAR2 | 1 | Standard, Exempt, or required Allows the user to use Standard Exemption rules, force an exemption or require tax to a normally exempt invoice This is defaulted based on user setup | ||
| OUTPUT_TAX_EXMT_REASON_CODE | VARCHAR2 | 30 | Tax Exempt Reason for item lines that have tax_exempt_flag set to (E-exempt) ***** | ||
| OUTPUT_TAX_EXMT_CERT_NUMBER | VARCHAR2 | 80 | Exemption Certificate Number for item lines that have tax_exempt_flag set to (E-exempt) ***** | ||
| OUTPUT_TAX_AMT | NUMBER | Tax amount ***** | |||
| PJS_SUMMARY_ID | NUMBER | 18 | Identifier of PJS summary ***** | ||
| BILLING_EXTENSION_ID | NUMBER | 18 | Identifier of billing extension ***** | ||
| 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. | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| PRVDR_LEGAL_ENTITY_ID | NUMBER | 18 | PRVDR_LEGAL_ENTITY_ID ***** | ||
| RECVR_LEGAL_ENTITY_ID | NUMBER | 18 | RECVR_LEGAL_ENTITY_ID ***** | ||
| IC_TP_AMT_TYPE_CODE | VARCHAR2 | 30 | IC_TP_AMT_TYPE_CODE ***** | ||
| TP_INV_SCH_LINE_PERCENTAGE | NUMBER | TP_INV_SCH_LINE_PERCENTAGE ***** | |||
| TP_INV_RULE_PERCENTAGE | NUMBER | TP_INV_RULE_PERCENTAGE ***** | |||
| IC_TP_BASE_CODE | VARCHAR2 | 30 | IC_TP_BASE_CODE ***** | ||
| ACCRUED_FLAG | VARCHAR2 | 1 | ACCRUED_FLAG ***** | ||
| RATE_SOURCE_CODE | VARCHAR2 | 30 | RATE_SOURCE_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. | |
| INV_BILLING_CONTROL_ID1 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID2 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID3 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID4 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID5 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID6 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID7 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID8 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID9 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID10 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID11 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID12 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID13 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID14 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID15 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID16 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID17 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID18 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID19 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_BILLING_CONTROL_ID20 | NUMBER | 18 | Identifier of billing control for invoice funding limit ***** | ||
| INV_CURR_OVERRIDE_ID | NUMBER | 18 | Identifier for Invoice Currency Conversion Override | ||
| CONT_CURR_OVERRIDE_ID | NUMBER | 18 | Identifier for Contract Currency Conversion Override. | ||
| 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 | Identified for Net Credit . | ||
| MIGRATION_FLAG | VARCHAR2 | 1 | Flag to indicate migrated transaction. | ||
| REVERSED_DIST_ID | NUMBER | 18 | Identifier of the distribution reversed by this distribution. | ||
| CFG_DIST_EXISTS_FLAG | VARCHAR2 | 1 | Identifies if the Invoice Distribution has a record in Configurator table. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifier of the inventory item. | ||
| ITEM_ORGANIZATION_ID | NUMBER | 18 | Identifier of the inventory item organization. | ||
| UOM_CODE | VARCHAR2 | 30 | Code for the unit of measure. | ||
| INV_CURR_UNIT_PRICE | NUMBER | Unit price in invoice currency. | |||
| INV_BILLED_QUANTITY | NUMBER | Quantity that has been invoiced. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJB_INV_LINE_DISTS | pjb_invoice_headers | INVOICE_ID |
| PJB_INV_LINE_DISTS | egp_system_items_b | INVENTORY_ITEM_ID, ITEM_ORGANIZATION_ID |
| PJB_INV_LINE_DISTS | pjb_invoice_lines | INVOICE_LINE_ID |
| PJB_INV_LINE_DISTS | pjb_invoice_headers | CREDITED_INVOICE_ID |
| PJB_INV_LINE_DISTS | pjb_invoice_lines | CREDITED_INVOICE_LINE_ID |
| PJB_INV_LINE_DISTS | pjb_inv_line_dists | CREDITED_DIST_ID |
| PJB_INV_LINE_DISTS | pjb_bill_trxs | BILL_TRX_ID |
| PJB_INV_LINE_DISTS | okc_k_headers_all_b | CONTRACT_ID, MAJOR_VERSION |
| PJB_INV_LINE_DISTS | okc_k_lines_b | CONTRACT_LINE_ID, MAJOR_VERSION |
| PJB_INV_LINE_DISTS | pjf_rbs_elements | RBS_ELEMENT_ID |
| pjb_inv_line_dists | pjb_inv_line_dists | CREDITED_DIST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_INV_LINE_DISTS_N1 | Non Unique | Default | BILL_TRX_ID |
| PJB_INV_LINE_DISTS_N10 | Non Unique | Default | LAST_UPDATE_DATE |
| PJB_INV_LINE_DISTS_N11 | Non Unique | Default | INVOICE_LINE_ID |
| PJB_INV_LINE_DISTS_N12 | Non Unique | Default | ORG_ID, TRANSACTION_PROJECT_ID |
| PJB_INV_LINE_DISTS_N13 | Non Unique | Default | INVOICE_ID, TRANSACTION_PROJECT_ID |
| PJB_INV_LINE_DISTS_N14 | Non Unique | Default | CONTRACT_ID, INVOICE_ID, INV_DISTRIBUTION_TYPE_CODE |
| PJB_INV_LINE_DISTS_N2 | Non Unique | Default | CREDITED_INVOICE_ID |
| PJB_INV_LINE_DISTS_N4 | Non Unique | Default | INVOICE_ID, INVOICE_LINE_ID |
| PJB_INV_LINE_DISTS_N5 | Non Unique | Default | TRANSACTION_ID |
| PJB_INV_LINE_DISTS_N6 | Non Unique | Default | CONTRACT_ID, BILL_TRANSACTION_TYPE_CODE |
| PJB_INV_LINE_DISTS_N7 | Non Unique | Default | REQUEST_ID |
| PJB_INV_LINE_DISTS_N8 | Non Unique | Default | CONTRACT_ID, CONTRACT_LINE_ID |
| PJB_INV_LINE_DISTS_U1 | Unique | Default | INVOICE_DIST_ID |