PJB_INVOICE_HEADERS
PJB_INVOICE_HEADERS stores the draft invoices generated for a project. . The transfer status of a draft invoice is maintained as follows: . Generate Invoice - Create invoice; set to Pending (P) . Transfer Invoice - If successfully transferred to AR, set to Transferred (T); Else rejected in transfer to AR, set to Rejected in Transfer (X) . Tieback Invoice - If successfully tied back from AR, set to Accepted (A). Else rejected by AR, set to Rejected (R) to be re-transferred . .
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJB_INVOICE_HEADERS_PK |
INVOICE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| INVOICE_ID | NUMBER | 18 | Yes | Identifier of the Invoices ***** | ||
| LOC_NUMBER | VARCHAR2 | 240 | Letter Of Credit Number on Gratns Contract BillPlan | |||
| DOC_NUMBER | VARCHAR2 | 240 | Document Number on Grants Contract BillPlan | |||
| CONTRACT_ID | NUMBER | 18 | Yes | The identifier of the contract that funds the invoice ***** | ||
| 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 ***** | |||
| INVOICE_NUM | NUMBER | 18 | Yes | The sequential number that identifies the draft invoice within a project ***** | ||
| INVOICE_TYPE_CODE | VARCHAR2 | 30 | Show type of Invoice. Standard/Credit Memo/Write-Off/Net Invoice/Canceled ***** | |||
| BILL_SET_NUM | NUMBER | 18 | Identifier of set of invoices created together in the same run which must be released at the same time ***** | |||
| BILL_FROM_DATE | DATE | The date through which to invoice the project. Expenditure items with the expenditure item date on or after the bill from date and events with completion dates on or after the bill through date may be included on an invoice. ***** | ||||
| BILL_TO_DATE | DATE | The date through which to invoice the project. Expenditure items with the expenditure item date on or before the bill to date and events with completion dates on or before the bill through date may be included on an invoice. ***** | ||||
| REPORTED_FROM_DATE | DATE | The date reported on the invoice as the date from which transactions are included on an invoice. | ||||
| REPORTED_TO_DATE | DATE | The date reported on the invoice as the date to which transactions are included on an invoice. | ||||
| BILL_TO_CUST_ACCT_ID | NUMBER | 18 | Yes | The identifier of the customer id to which invoices are sent ***** | ||
| BILL_TO_CONTACT_ID | NUMBER | 18 | The identifier of the contact who is a representative for the bill to customer of the project | |||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | Bill to Site identifier of the customer address ***** | |||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 30 | Yes | Invoice currency code for the draft invoice that is transferred to Oracle Receivables. ***** | ||
| GENERATION_ERROR_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates that an error was encountered during the Generate Draft Invoices program that caused the draft invoice to not be successfully generated | ||
| PA_DATE | DATE | The end date of the PA period in which the invoice was generated. The PA period is the open or future PA period on or after the latest date of the expenditure item dates and the event completion dates included on the invoice. | ||||
| INVOICE_COMMENT | VARCHAR2 | 240 | Free text comments that can be printed on an invoice. The invoice comment is defaulted from the invoice comment defined for the project. This value can be overridden by a user for each draft invoice | |||
| INVOICE_INSTRUCTIONS | VARCHAR2 | 240 | Invoice Instructions ***** | |||
| APPROVED_DATE | DATE | The date on which the draft invoice is approved | ||||
| APPROVED_BY_PERSON_ID | NUMBER | 18 | The identifier of the employee that approved the invoice | |||
| RELEASED_DATE | DATE | The date that the draft invoice was released for transfer | ||||
| RELEASED_BY_PERSON_ID | NUMBER | 18 | The identifier of the employee that released the invoice | |||
| INVOICE_DATE | DATE | The invoice date passed to Oracle Receivables which is used to calculate the invoice due date. Upon release of the invoice, this date is defaulted from the released date. The user can override the invoice date at the time of release | ||||
| RA_INVOICE_NUMBER | VARCHAR2 | 20 | The Oracle Receivables invoice number that is determined upon release of the draft invoice and passed to Oracle Receivables upon transfer. This number can be user-entered or system-generated as defined in the implementation options. | |||
| TRANSFER_STATUS_CODE | VARCHAR2 | 30 | Yes | The status of the invoice as it is transferred to Oracle Receivables | ||
| TRANSFERRED_DATE | DATE | The date that the draft invoice was transferred to the Oracle Receivables interface tables | ||||
| TRANSFER_REJECT_REASON_CODE | VARCHAR2 | 30 | The reason why the draft invoice was rejected by the Transfer Invoice program or rejected by Oracle Receivables AutoInvoice interface program ***** | |||
| GL_DATE | DATE | The date within a GL accounting period to which the invoice transactions are posted. The GL date is set by the Transfer Invoice program and is the date of the first future or open GL period in Oracle Receivables of the invoice date. | ||||
| SYSTEM_REFERENCE | NUMBER | 18 | The reference to the invoice created in Oracle Receivables from the draft invoice. The column is populated by Tieback Invoice and holds the RA_CUSTOMER_TRX.CUSTOMER_TRX_ID | |||
| CANCELLED_FLAG | VARCHAR2 | 1 | Flag that indicates that the draft invoice was credited by another draft invoice, a credit memo ***** | |||
| CONVERTED_FLAG | VARCHAR2 | 1 | Flag indicating if the invoice is converted. 'Y' denotes a converted invoice with no detail in AR as PA expects. A value of 'N' or null denotes a non-converted invoice. A converted invoice cannot be cancelled or written off. | |||
| ACCTD_CURRENCY_CODE | VARCHAR2 | 30 | The currency code associated with the ledger attached to the responsibilty used to log into the application. ***** | |||
| ACCTD_RATE_TYPE | VARCHAR2 | 30 | Accounted currency rate type for the draft invoices generated for this project customer. | |||
| ACCTD_RATE_DATE | DATE | Accounted currency rate date for the draft invoices generated for this project customer. | ||||
| ACCTD_EXCHG_RATE | NUMBER | Accounted currency exchange rate for the draft invoices generated for this project customer. | ||||
| CONTRACT_CURRENCY_CODE | VARCHAR2 | 30 | Contract Currency ***** | |||
| LANG | VARCHAR2 | 30 | The customer language corresponding to the bill to address ***** | |||
| PA_PERIOD_NAME | VARCHAR2 | 15 | Project functional currency code | |||
| GL_PERIOD_NAME | VARCHAR2 | 15 | Bill Amount in the project functional currency. This is calculated by applying the conversion rules set up for project functional currency during invoice generation. | |||
| CREDIT_MEMO_REASON_CODE | VARCHAR2 | 30 | Reason code for releasing credit invoices | |||
| PURGE_FLAG | VARCHAR2 | 1 | Flag to indicate if underlying expenditure items of an intercompany invoice are purged. | |||
| LAST_CREDIT_REQUEST_ID | NUMBER | 18 | Identifier of the last credit | |||
| INVOICE_STATUS_CODE | VARCHAR2 | 30 | Yes | Status code of invoice ***** | ||
| TAXATION_COUNTRY | VARCHAR2 | 2 | This mandatory tax attribute. The country for taxation for tax calculation purpose. ***** | |||
| DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | This optional Value. This field is entered by user when documents such as an Invoice or a credit memo need to be further classified into a sub types such as "Domestic Invoice', 'Foreign Invoice' etc. ***** | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| IN_AP_TRANSFER_STATUS_CODE | VARCHAR2 | 1 | IN_AP_TRANSFER_STATUS_CODE ***** | |||
| IN_AP_TRANSFER_ERROR_CODE | VARCHAR2 | 80 | IN_AP_TRANSFER_ERROR_CODE ***** | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| EXCEPTION_FLAG | VARCHAR2 | 1 | Indicator of exception. When exceptions occur, this flag is updated ***** | |||
| 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. | ||
| PJS_SUMMARY_ID | NUMBER | 18 | PJS_SUMMARY_ID ***** | |||
| BILLING_TYPE_CODE | VARCHAR2 | 30 | Yes | Billing Type Code. Possible values area EX, IP, IC ***** | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Header (PJB_INVOICE_HEADERS_FLEX) | ||
| REPORT_TYPE_CODE | VARCHAR2 | 30 | Federal report type code stored in bill plan. | |||
| RCVR_SETUP_CODE | VARCHAR2 | 30 | Indicates if this invoice is for all projects of a receiver business unit | |||
| EXPORT_PROCESS_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the invoice export job for co-existence | |||
| NET_CREDIT_FLAG | VARCHAR2 | 1 | Identifier for Net Credit . | |||
| MIGRATION_FLAG | VARCHAR2 | 1 | Flag to indicate migrated transaction. | |||
| LAST_UNRELEASED_BY_PERSON_ID | NUMBER | 18 | Unique identifier of the person who last unreleased the invoice. | |||
| UNRELEASE_COMMENTS | VARCHAR2 | 240 | Comments entered by the person while unreleasing the invoice. | |||
| LAST_UNRELEASED_DATE | TIMESTAMP | The date and time that the invoice was last unreleased. | ||||
| SUBMITTED_BY_PERSON_ID | NUMBER | 18 | Oracle internal use only. | |||
| SUBMITTED_DATE | TIMESTAMP | Oracle internal use only. | ||||
| DIAGNOSTIC_INFO | VARCHAR2 | 400 | Oracle internal use only. | |||
| NET_INVOICE_FLAG | VARCHAR2 | 1 | Identifies if the invoice was created with net invoice enabled. | |||
| PROJECT_ID | NUMBER | 18 | Unique Identifier of the project for the invoice. When the bill plan invoice grouping includes project, invoice transactions are separated into distinct invoices for each related project this attribute is populated with the ID. | |||
| ORIGINAL_RA_INVOICE_NUMBER | VARCHAR2 | 20 | Stores the value of the RA_INVOICE_NUMBER column before running the Confirm Invoice Acceptance Status in Receivables process. For Oracle internal use only. | |||
| BATCH_SOURCE_SEQ_ID | NUMBER | 18 | Stores the value of the Batch source sequence identifier passed on to Oracle Receivables upon transfer. For Oracle internal use only. | |||
| ACCEPTED_DATE | TIMESTAMP | Indicates the date when the invoice is accepted in AR. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJB_INVOICE_HEADERS | okc_k_headers_all_b | CONTRACT_ID, MAJOR_VERSION |
| PJB_INVOICE_HEADERS | gl_daily_conversion_types | ACCTD_RATE_TYPE |
| pjb_invoice_lines | pjb_invoice_headers | INVOICE_ID |
| pjb_invoice_lines | pjb_invoice_headers | CREDITED_INVOICE_ID |
| pjb_inv_line_dists | pjb_invoice_headers | INVOICE_ID |
| pjb_inv_line_dists | pjb_invoice_headers | CREDITED_INVOICE_ID |
| pjb_sf270_report_history | pjb_invoice_headers | INVOICE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_INVOICE_HEADERS_N10 | Non Unique | Default | ORG_ID, BILLING_TYPE_CODE, INVOICE_DATE |
| PJB_INVOICE_HEADERS_N11 | Non Unique | Default | SYSTEM_REFERENCE |
| PJB_INVOICE_HEADERS_N12 | Non Unique | Default | CONTRACT_ID, MIGRATION_FLAG |
| PJB_INVOICE_HEADERS_N2 | Non Unique | Default | TRANSFER_STATUS_CODE |
| PJB_INVOICE_HEADERS_N3 | Non Unique | Default | APPROVED_BY_PERSON_ID |
| PJB_INVOICE_HEADERS_N4 | Non Unique | Default | RELEASED_BY_PERSON_ID |
| PJB_INVOICE_HEADERS_N6 | Non Unique | Default | REQUEST_ID, GENERATION_ERROR_FLAG |
| PJB_INVOICE_HEADERS_N7 | Non Unique | Default | RA_INVOICE_NUMBER |
| PJB_INVOICE_HEADERS_N9 | Non Unique | Default | INVOICE_STATUS_CODE, EXCEPTION_FLAG |
| PJB_INVOICE_HEADERS_U1 | Unique | Default | CONTRACT_ID, INVOICE_NUM |
| PJB_INVOICE_HEADERS_U2 | Unique | Default | INVOICE_ID |