PJB_INVOICE_FORMATS
This table stores invoice and invoice line grouping rules that determine how bill transactions are consolidated into invoices and invoice lines during invoice generation. Grouping rules are associated to project contracts through bill plans. The invoice format type identifies whether a rule applies to invoice or invoice line grouping.
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJB_INVOICE_FORMATS_PK |
INVOICE_FORMAT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INVOICE_FORMAT_ID | NUMBER | 18 | Yes | The system-generated number that uniquely identifies the invoice format | |
| INVOICE_FORMAT_TYPE | VARCHAR2 | 30 | Yes | The invoice format type is set to INVOICES for invoice grouping rules, whereas for invoice line grouping rules, the invoice format type can be LABOR, NON LABOR, or EVENTS. | |
| INVOICE_GROUP_ID | NUMBER | 18 | Yes | The identifier of the invoice group that classifies the invoice format. The invoice group specifies the grouping of expenditure items | |
| NAME | VARCHAR2 | 30 | Yes | The implementation-defined name that uniquely identifies the invoice format | |
| START_DATE_ACTIVE | DATE | Yes | First effective date of the invoice format | ||
| END_DATE_ACTIVE | DATE | Last effective date for the invoice format | |||
| INTERNAL_INVOICE_FLAG | VARCHAR2 | 1 | Indicates if this invoice format is for intercompany invoicing. ***** | ||
| CUSTOMER_INVOICE_FLAG | VARCHAR2 | 1 | Indicates if this invoice format is for Customer invoicing. | ||
| FIXED_FORMAT_FLAG | VARCHAR2 | 1 | Indicates if this invoice format is of fixed format type. ***** | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJB_INVOICE_FORMATS | pjb_inv_group_headers | INVOICE_GROUP_ID |
| pjb_invoice_lines | pjb_invoice_formats | INVOICE_FORMAT_ID |
| pjb_inv_format_details | pjb_invoice_formats | INVOICE_FORMAT_ID |
| pjb_bill_plans_b | pjb_invoice_formats | LABOR_INVOICE_FORMAT_ID |
| pjb_bill_plans_b | pjb_invoice_formats | NL_INVOICE_FORMAT_ID |
| pjb_bill_plans_b | pjb_invoice_formats | EVENTS_INVOICE_FORMAT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_INVOICE_FORMATS_U2 | Unique | Default | NAME |
| PJB_INVOICE_FORMATS_U1 | Unique | Default | INVOICE_FORMAT_ID |
| PJB_INVOICE_FORMATS_N1 | Non Unique | Default | INVOICE_GROUP_ID |