PJB_BILL_TRX_INT
Interface table used to import Project Contract Bill Transactions.
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJB_BILL_TRX_INT_PK |
BILL_TXN_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BILL_TXN_INTERFACE_ID | NUMBER | 18 | Yes | Unique identifier for each interface record. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Yes | Identifier of the request that loaded the imported data. | |
| PROCESSING_MODE | VARCHAR2 | 10 | Indicates the type of operation performed during import; create, update, or delete. | ||
| BILL_TRX_ID | NUMBER | 18 | Identifier of the bill transaction, also known as the bill transaction number. | ||
| BILL_GROUP | VARCHAR2 | 1000 | Free-text string tag which influences how the transactions are grouped into invoices. Transactions within the same bill group are included on the same invoice, subject to all other invoice grouping logic. | ||
| IMPORT_STATUS_CODE | VARCHAR2 | 30 | Indicates whether the record has been successfully imported (SUCCESS), import is in progress (IN_PROGRESS), or import resulted in an error (ERROR). | ||
| EXCEPTION_MESSAGE_TEXT | VARCHAR2 | 4000 | Warning or error message if importing the transaction results in an exception. | ||
| EXCEPTION_MESSAGE_CODE | VARCHAR2 | 500 | Identifier for the warning or error message if importing the transaction results in an exception. | ||
| EXCEPTION_MSG_USER_DETAILS | VARCHAR2 | 4000 | Additional details related to the warning or error if importing the transaction results in an exception. | ||
| EXCEPTION_MSG_USER_ACTIONS | VARCHAR2 | 4000 | Recommended actions related to the warning or error if importing the transaction results in an exception. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_BILL_TRX_INT_U1 | Unique | Default | BILL_TXN_INTERFACE_ID |