PJB_INVOICE_LINES
PJB_INVOICE_LINES stores the lines of a draft invoice. The Generate Draft Invoice process creates an invoice line for each billing event and for each grouping of expenditure items. Groupings of expenditure items are determined by a project's invoice formats.
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJB_INVOICE_LINES_PK |
INVOICE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| INVOICE_LINE_ID | NUMBER | 18 | Yes | Identifier of the Invoice Line ***** | ||
| INVOICE_LINE_NUM | NUMBER | 18 | Yes | Invoice Line sequence number ***** | ||
| 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 | Yes | Identifier of the Invoice ***** | ||
| INVOICE_NUM | NUMBER | 18 | Yes | Draft Invoice Number that invoice line belongs to ***** | ||
| CONTRACT_ID | NUMBER | 18 | Yes | Identifier of the contract ***** | ||
| CONTRACT_LINE_ID | NUMBER | 18 | Identifier of the contract line ***** | |||
| BILL_PLAN_ID | NUMBER | 18 | Identifier of the bill plan ***** | |||
| MAJOR_VERSION | NUMBER | 18 | Version number of contract ***** | |||
| CREDITED_INVOICE_ID | NUMBER | 18 | The draft invoice number that is credited by this draft invoice. The crediting invoice may be a credit memo or a write-off ***** | |||
| CREDITED_INVOICE_LINE_ID | NUMBER | 18 | The draft invoice line number that is credited by this invoice line ***** | |||
| BILL_SET_NUM | NUMBER | 18 | Identifier of the Bill Plan ***** | |||
| INVOICE_FORMAT_ID | NUMBER | 18 | Identifier of the invoice format ***** | |||
| PAYMENT_TERM_ID | NUMBER | 18 | Indicates a unique reference for all the receipt from AR which are applied against the agreement. ***** | |||
| INV_CURR_LINE_AMT | NUMBER | Sum of Invoice distributions ***** | ||||
| INVOICE_LINE_TYPE | VARCHAR2 | 30 | Yes | The type of draft invoice line | ||
| WRITE_OFF_FLAG | VARCHAR2 | 1 | Indicator if this invoice line is write-off ***** | |||
| INVOICE_LINE_DESC | VARCHAR2 | 240 | Invoice Line description ***** | |||
| SHIP_TO_CUST_ACCT_ID | NUMBER | 18 | The identifier of the customer id that is the project customer's default work site for the project ***** | |||
| SHIP_TO_SITE_USE_ID | NUMBER | 18 | The identifier of the ship-to address and used for taxation. This column is populated only if the invoice formats groups by work site and for events using the work site of the event task ***** | |||
| SHIP_TO_CONTACT_ID | NUMBER | 18 | The identifier of the contact who is a representative for the ship to customer of the project ***** | |||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 30 | Invoice Currency Code ***** | |||
| CONTRACT_CURRENCY_CODE | VARCHAR2 | 30 | Contract Currency Code ***** | |||
| CONTRACT_CURRENCY_INV_AMT | NUMBER | Amount in Contract currency ***** | ||||
| INVOICE_CURR_CREDIT_AMT | NUMBER | Invoice Currency Credit Amount ***** | ||||
| INVOICE_CURR_CREDIT_PCT | NUMBER | Invoice Currency Credit percentage ***** | ||||
| CONTRACT_CURR_CREDIT_AMT | NUMBER | CONTRACT_CURR_CREDIT_AMT ***** | ||||
| ACCTD_CURRENCY_CODE | VARCHAR2 | 30 | The currency code associated with the ledger attached to the responsibilty used to log into the application ***** | |||
| ACCTD_CURRENCY_AMT | NUMBER | Amount in Functional Currency ***** | ||||
| TRANSLATED_TEXT | VARCHAR2 | 1000 | The translated description of the invoice line which is provided by the user and used for multilingual support. The text is free of any formatting and validation. | |||
| CREDIT_PROCESSED_FLAG | VARCHAR2 | 1 | Flag indicating whether the invoice line is selected for credit invoice processing. Applicable only for concession and write off line level credits. ***** | |||
| OUTPUT_TAX_CLASS_CODE | VARCHAR2 | 150 | eTax Change ***** | |||
| 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 | 30 | 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. | ||||
| 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) ***** | |||
| PROD_FC_CATEG_ID | NUMBER | 18 | PROD_FC_CATEG_ID | |||
| INTENDED_USE_CLASSIF_ID | NUMBER | 18 | INTENDED_USE_CLASSIF_ID | |||
| OUTPUT_TAX_AMT | NUMBER | Tax amount ***** | ||||
| EXCEPTION_FLAG | VARCHAR2 | 1 | Indicator of exception. When exceptions occur, this flag is updated ***** | |||
| IN_AP_TRANSFER_STATUS_CODE | VARCHAR2 | 1 | IN_AP_TRANSFER_STATUS_CODE ***** | |||
| IN_AP_TRANSFER_ERROR_CODE | VARCHAR2 | 80 | IN_AP_TRANSFER_ERROR_CODE ***** | |||
| RECEIVER_PROJECT_ID | NUMBER | 18 | RECEIVER_PROJECT_ID ***** | |||
| RECEIVER_TASK_ID | NUMBER | 18 | RECEIVER_TASK_ID ***** | |||
| EXPENDITURE_ORG_ID | NUMBER | 18 | EXPENDITURE_ORG_ID ***** | |||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | EXPENDITURE_TYPE_ID ***** | |||
| RATE_SOURCE_CODE | VARCHAR2 | 30 | RATE_SOURCE_CODE ***** | |||
| RECALC_EXTN_FLAG | VARCHAR2 | 1 | Recalcution extension flag ***** | |||
| 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. | |||
| 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Lines (PJB_INVOICE_LINES_FLEX) | ||
| WORK_TYPE_ID | NUMBER | 18 | Identifier for a worktype assigned to a transaction. | |||
| NET_CREDIT_FLAG | VARCHAR2 | 1 | Identifer for Net Credit. | |||
| MIGRATION_FLAG | VARCHAR2 | 1 | Flag to indicate migrated transaction. | |||
| LINKED_PROJECT_ID | NUMBER | 18 | Identifier of the project associated to the related contract line or contract lines. This value is populated if Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number. | |||
| LINKED_TASK_ID | NUMBER | 18 | Identifier of the project task associated to the related contract line or contract lines. This value is populated if Invoice Format grouping options are set to group distribution lines by Contract Line Task Name or Number. | |||
| ORIGINAL_CALCULATED_AMT | NUMBER | Sum of Invoice distributions | ||||
| 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. | ||||
| RA_CUST_TRX_ID | NUMBER | 18 | Identifier of the Oracle Receivables invoice. This column is populated by Confirm Invoice Acceptance Status in Receivables process and holds the RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID. For Oracle internal use only. | |||
| RA_CUST_TRX_LINE_ID | NUMBER | 18 | Identifier of the Oracle Receivables invoice line. This column is populated by Confirm Invoice Acceptance Status in Receivables process and holds the RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID. For Oracle internal use only. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJB_INVOICE_LINES | pjb_invoice_headers | INVOICE_ID |
| PJB_INVOICE_LINES | pjb_invoice_headers | CREDITED_INVOICE_ID |
| PJB_INVOICE_LINES | pjb_invoice_lines | CREDITED_INVOICE_LINE_ID |
| PJB_INVOICE_LINES | pjb_invoice_formats | INVOICE_FORMAT_ID |
| PJB_INVOICE_LINES | okc_k_headers_all_b | CONTRACT_ID, MAJOR_VERSION |
| PJB_INVOICE_LINES | okc_k_lines_b | CONTRACT_LINE_ID, MAJOR_VERSION |
| PJB_INVOICE_LINES | egp_system_items_b | INVENTORY_ITEM_ID, ITEM_ORGANIZATION_ID |
| pjb_invoice_lines | pjb_invoice_lines | CREDITED_INVOICE_LINE_ID |
| pjb_inv_line_dists | pjb_invoice_lines | INVOICE_LINE_ID |
| pjb_inv_line_dists | pjb_invoice_lines | CREDITED_INVOICE_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_INVOICE_LINES_N1 | Non Unique | Default | SHIP_TO_SITE_USE_ID |
| PJB_INVOICE_LINES_N2 | Non Unique | Default | INVOICE_ID, INVOICE_NUM, INVOICE_LINE_NUM |
| PJB_INVOICE_LINES_U1 | Unique | Default | CONTRACT_ID, INVOICE_ID, INVOICE_LINE_ID |
| PJB_INVOICE_LINES_U2 | Unique | Default | INVOICE_LINE_ID |
| PJB_INVOICE_LINES_U3 | Unique | Default | INVOICE_LINE_ID, INVOICE_LINE_NUM |