PJC_VALIDATION_ERRORS
This table contains the error information for all types of transactions.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
PJC_VALIDATION_ERRORS_PK |
TXN_ERROR_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TXN_ERROR_ID | NUMBER | 18 | Yes | Unique identifier of validation error. Primary Key. | |
SOURCE_TXN_ID | NUMBER | 18 | Yes | Unique identifier of a transaction in the validation interface table. | |
SOURCE_ENTITY | VARCHAR2 | 30 | Yes | Identifies the source table against which the transaction has failed validation. Examples include TXN_XFACE and XCHARGE. | |
ERROR_GROUP | VARCHAR2 | 30 | Yes | Indicates the processing stage that resulted in the error. Examples include ACCT_EVENT_GENERATION, COMMITMENT_CONTROL. | |
MESSAGE_TYPE_CODE | VARCHAR2 | 20 | Indicates the message type code. Examples include Error, Warning. | ||
APPLICATION_CODE | VARCHAR2 | 10 | Yes | The application code indicating the application to which the message belongs to. | |
MESSAGE_NAME | VARCHAR2 | 30 | Yes | The message name for project transactions for which validation was not successful. | |
TXN_REFERENCE1 | NUMBER | 18 | Reference column to identify the transaction. | ||
TOKEN_NAME1 | VARCHAR2 | 30 | Token name place holder for the messsage. | ||
TOKEN_NAME2 | VARCHAR2 | 30 | Token name place holder for the messsage. | ||
TOKEN_NAME3 | VARCHAR2 | 30 | Token name place holder for the messsage. | ||
TOKEN_VALUE1 | VARCHAR2 | 2000 | Token value place holder for the messsage. | ||
TOKEN_VALUE2 | VARCHAR2 | 2000 | Token value place holder for the messsage. | ||
TOKEN_VALUE3 | VARCHAR2 | 2000 | Token value place holder for the messsage. | ||
TOKEN_DATA_TYPE1 | VARCHAR2 | 20 | Token value data type place holder for the messsage. | ||
TOKEN_DATA_TYPE2 | VARCHAR2 | 20 | Token value data type place holder for the messsage. | ||
TOKEN_DATA_TYPE3 | VARCHAR2 | 20 | Token value data type place holder for the messsage. | ||
REQUESTID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID 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. | ||
ACCRUAL_FLAG | VARCHAR2 | 1 | Indicates whether the imported transaction is automatically reversed in the next accounting period. | ||
ACCT_BURDENED_COST | NUMBER | Burdened cost in functional currency. | |||
ACCT_CURRENCY_CODE | VARCHAR2 | 15 | Functional currency code of the operating unit to which the transaction belongs. | ||
ACCT_EXCHANGE_RATE | NUMBER | Exchange rate for the transaction. | |||
ACCT_RATE_DATE | DATE | Conversion rate date for the transaction. | |||
ACCT_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type for the transaction. | ||
ACCT_RAW_COST | NUMBER | Raw cost in functional currency. | |||
ADJUSTED_EXPENDITURE_ITEM_ID | NUMBER | 18 | The identifier of the project cost transaction adjusted by this transaction. Adjustments are entered by users with negative amounts to fully reverse a transaction, or are system generated to reverse a transaction. | ||
ADJUSTED_TXN_INTERFACE_ID | NUMBER | 18 | The Import Costs process uses this column to indicate the transaction interface identifier of an adjusted project cost transaction. | ||
TRANSFERRED_FROM_EXP_ITEM_ID | NUMBER | 18 | The identifier of the original project cost transaction from which this transaction originated. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
BILLABLE_FLAG | VARCHAR2 | 1 | Indicates if a project-related item is available to be billed to customers. | ||
BUDGET_DATE | DATE | Date for which funds must be reserved for the transaction. | |||
BURDEN_COST_CR_CCID | NUMBER | 18 | Code combination identifier of the burden cost credit account. | ||
BURDEN_COST_DR_CCID | NUMBER | 18 | Code combination identifier of the burden cost debit account. | ||
BURDENED_COST_CR_CCID | NUMBER | 18 | Code combination identifier of the burdened cost credit account. | ||
BURDENED_COST_DR_CCID | NUMBER | 18 | Code combination identifier of the burdened cost debit account. | ||
CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Indicates if a project-related item is eligible for capitalization. | ||
COMMITMENT_FLAG | VARCHAR2 | 1 | Indicates if the transaction is a commitment or actual. | ||
CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. | ||
CONTRACT_ID | NUMBER | 18 | Unique identifier of the contract. | ||
BATCH_NAME | VARCHAR2 | 200 | User-entered or system derived name for grouping of expenditures. When processed together for a transaction source, all items with the same batch name will imported into Oracle Project Costing in the same expenditure group. | ||
VALIDATION_TECH_COMPONENT | VARCHAR2 | 30 | The user interface or web service or other cloud service requesting validation for the project transaction. Examples include FBDI, ADFdi, REST. | ||
VALIDATION_MODULE | VARCHAR2 | 30 | The module validating the transaction. Examples include COST_VALIDATION, AWARD_DISTRIBUTION. | ||
VALIDATION_SCOPE | VARCHAR2 | 30 | The validation scope for the transaction. Valid values include SKIP, NULL. A value of SKIP will bypass all validations and NULL will enforce all validations. | ||
DENOM_BURDENED_COST | NUMBER | Total project cost in the transaction currency for a project that is enabled for burdening, including the burden cost. | |||
DENOM_CURRENCY_CODE | VARCHAR2 | 15 | The currency in which the cost was incurred. | ||
DENOM_RAW_COST | NUMBER | Raw cost in the transaction currency. | |||
DOC_ENTRY_CODE | VARCHAR2 | 30 | Name of the document entry used to capture the transaction. | ||
DOC_ENTRY_ID | NUMBER | 18 | Projects-relates sub-categorication of the document type that is creating this transaction. | ||
DOCUMENT_CODE | VARCHAR2 | 20 | Internally used code. This is defaulted to DOCUMENT_ID for user-defined documents. | ||
DOCUMENT_ID | NUMBER | 18 | Identifier for the Projects-related categorization of the document type that is creating this transaction. | ||
EXPENDITURE_ITEM_DATE | DATE | Date on which the transaction was recorded. | |||
EXPENDITURE_ITEM_ID | NUMBER | 18 | The system-generated number that uniquely identifies the project cost transaction. | ||
EXPENDITURE_TYPE_ID | NUMBER | 18 | Identifier of the expenditure type. | ||
GL_DATE | DATE | The date used to determine the accounting period for a transaction. | |||
HCM_ASSIGNMENT_ID | NUMBER | 18 | The person assignment for which the transaction was created. | ||
INTERFACE_ID | NUMBER | 18 | System-generated number that identifies all the transactions processed by a given concurrent request. | ||
INVENTORY_ITEM_ID | NUMBER | 18 | The inventory item associated with the transaction. | ||
NET_ZERO_ADJUSTMENT_FLAG | VARCHAR2 | 1 | Identifies whether the item is fully reversed or the item is one of the adjusting items that fully reverses another item. Generate draft invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice. | ||
NON_LABOR_RESOURCE_ID | NUMBER | 18 | Identifier of the non-labor resource utilized when incurring the transaction charge. | ||
NON_LABOR_RESOURCE_ORG_ID | NUMBER | 18 | Non-labor resource organization identifier. | ||
ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
ORGANIZATION_ID | NUMBER | 18 | Identifier of the expenditure organization. | ||
ORIG_TRANSACTION_REFERENCE | VARCHAR2 | 120 | Original transaction reference of the transaction. | ||
PERSON_ID | NUMBER | 18 | Identifier of the human resources person related to this transaction. | ||
PERSON_JOB_ID | NUMBER | 18 | Identifier of the job that is being performed by the person that incurred the transaction that was charged to the task. | ||
PERSON_TYPE | VARCHAR2 | 30 | Identifies the type of person - employee or contingent worker. | ||
PROJECT_ID | NUMBER | 18 | Identifier of the project to which the transaction is charged. | ||
QUANTITY | NUMBER | Number of units for the transaction. | |||
RAW_COST_CR_CCID | NUMBER | 18 | Code combination identifier of the raw cost credit account. | ||
RAW_COST_DR_CCID | NUMBER | 18 | Code combination identifier of the raw cost debit account. | ||
RECEIPT_CURRENCY_AMOUNT | NUMBER | Receipt currency amount of the transaction. | |||
RECEIPT_CURRENCY_CODE | VARCHAR2 | 15 | Receipt currency code of the transaction. | ||
RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
REVERSED_ORIG_TXN_REFERENCE | VARCHAR2 | 120 | The transaction reference for the original transaction that is reversed. | ||
SYSTEM_LINKAGE | VARCHAR2 | 30 | Identifier of the system linkage for the transaction. | ||
TASK_ID | NUMBER | 18 | Identifier of the task to which the transaction belongs. | ||
TRANSACTION_SOURCE_CODE | VARCHAR2 | 30 | The descriptive name of the transaction source. | ||
TRANSACTION_SOURCE_ID | NUMBER | 18 | Identifier of the transaction source. | ||
TRANSACTION_STATUS_CODE | VARCHAR2 | 2 | Indicates the status of the transaction. | ||
UNMATCHED_NEGATIVE_TXN_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is for the reversal of a matched transaction. | ||
USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: user defined segment of the user descriptive flexfield. | ||
USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: user defined segment of the user descriptive flexfield. | ||
USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: user defined segment of the user descriptive flexfield. | ||
USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: user defined segment of the user descriptive flexfield. | ||
USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: user defined segment of the user descriptive flexfield. | ||
USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: user defined segment of the user descriptive flexfield. | ||
USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: user defined segment of the user descriptive flexfield. | ||
USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: user defined segment of the user descriptive flexfield. | ||
USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: user defined segment of the user descriptive flexfield. | ||
USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: user defined segment of the user descriptive flexfield. | ||
PATC_RESERVED_NUM_1 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_2 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_3 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_4 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_5 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_6 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_7 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_8 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_9 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_10 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_11 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_12 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_13 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_14 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_NUM_15 | NUMBER | 18 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_1 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_2 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_3 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_4 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_5 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_6 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_7 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_8 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_9 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_10 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_11 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_12 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_13 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_14 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_CHAR_15 | VARCHAR2 | 150 | Reserved for Projects - future functionality. | ||
PATC_RESERVED_DATE_1 | DATE | Reserved for Projects - future functionality. | |||
PATC_RESERVED_DATE_2 | DATE | Reserved for Projects - future functionality. | |||
PATC_RESERVED_DATE_3 | DATE | Reserved for Projects - future functionality. | |||
PATC_RESERVED_DATE_4 | DATE | Reserved for Projects - future functionality. | |||
PATC_RESERVED_DATE_5 | DATE | Reserved for Projects - future functionality. | |||
VENDOR_ID | NUMBER | 18 | Indicates the vendor identifier for transaction. | ||
WORK_TYPE_ID | NUMBER | 18 | Identifier of the work type for the transaction. | ||
DESTINATION_TYPE_CODE | VARCHAR2 | 30 | The destination type code for a purchase requisition. Examples include Expense, Inventory. | ||
TRANSACTION_NUMBER | VARCHAR2 | 240 | Alphanumeric transaction number that uniquely identifies the subledger transaction within the application. Examples include Purchase Order Number, Invoice Number. | ||
SOURCE_ID_1 | NUMBER | 18 | The distribution line identifier. | ||
SOURCE_ID_2 | NUMBER | 18 | The distribution line identifier. | ||
SOURCE_ID_3 | NUMBER | 18 | The distribution line identifier. | ||
SOURCE_ID_4 | NUMBER | 18 | The distribution line identifier. | ||
SOURCE_ID_5 | NUMBER | 18 | The distribution line identifier. | ||
SOURCE_ID_6 | NUMBER | 18 | The distribution line identifier. | ||
BILL_TO_ID | NUMBER | 18 | Reference to the unique identifier for the Bill-to Customer location used on an internal sales order. | ||
SHIP_TO_ID | NUMBER | 18 | Reference to the unique identifier for the Ship-to Party Site used on an internal sales order. | ||
BUSINESS_UNIT | VARCHAR2 | 240 | Indicates the business unit associated to the row. | ||
USER_TRANSACTION_SOURCE | VARCHAR2 | 240 | The descriptive name of the transaction source. | ||
DOCUMENT_NAME | VARCHAR2 | 240 | Projects-related categorization of the document type that is creating this transaction. | ||
DOC_ENTRY_NAME | VARCHAR2 | 240 | Name of the document entry used to capture the transaction. | ||
PROJECT_NUMBER | VARCHAR2 | 25 | Number of the project to which the transaction is charged. | ||
PROJECT_NAME | VARCHAR2 | 240 | Name of the project to which the transaction is charged. | ||
TASK_NUMBER | VARCHAR2 | 100 | Number of the task to which the transaction is charged. | ||
TASK_NAME | VARCHAR2 | 255 | Name of the task to which the transaction is charged. | ||
PERSON_NUMBER | VARCHAR2 | 30 | Number that uniquely identifies the person who is associated with the transaction. | ||
PERSON_NAME | VARCHAR2 | 2000 | Name that uniquely identifies the person who is associated with the transaction. | ||
HCM_ASSIGNMENT_NAME | VARCHAR2 | 80 | Name of the human resources assignment of the person that incurred the transaction that was charged to the project. | ||
EXPENDITURE_TYPE | VARCHAR2 | 240 | A classification of cost that is assigned to the transaction. | ||
ORGANIZATION_NAME | VARCHAR2 | 240 | Name of the expenditure organization to which the transaction is charged. | ||
NON_LABOR_RESOURCE | VARCHAR2 | 240 | Name of the non labor resource utilized when incurring the transaction charge. | ||
NON_LABOR_RESOURCE_ORG | VARCHAR2 | 240 | The organization that owns the nonlabor resource incurring the transaction charge. | ||
UNIT_OF_MEASURE_CODE | VARCHAR2 | 30 | Indicates the unit of measure code for transaction. | ||
UNIT_OF_MEASURE_NAME | VARCHAR2 | 80 | Name of the unit of measure for the item that is requested, ordered, or supplied. | ||
WORK_TYPE_NAME | VARCHAR2 | 240 | Name of the work type for the transaction. | ||
SUPPLIER_NUMBER | VARCHAR2 | 30 | Number of the supplier that provided the goods or services that resulted in the transaction. | ||
SUPPLIER_NAME | VARCHAR2 | 360 | Name of the supplier that provided the goods or services that resulted in the transaction. | ||
INVENTORY_ITEM_NUMBER | VARCHAR2 | 300 | Number of the inventory item for the transaction. | ||
RAW_COST_CR_ACCOUNT | VARCHAR2 | 2000 | The ledger account that receives the credit amount for the raw cost associated with the transaction. | ||
RAW_COST_DR_ACCOUNT | VARCHAR2 | 2000 | The ledger account that receives the debit amount for the raw cost associated with the transaction. | ||
BURDENED_COST_CR_ACCOUNT | VARCHAR2 | 2000 | The ledger account that receives the credit amount for the burdened cost associated with the transaction. | ||
BURDENED_COST_DR_ACCOUNT | VARCHAR2 | 2000 | The ledger account that receives the debit amount for the burdened cost associated with the transaction. | ||
BURDEN_COST_CR_ACCOUNT | VARCHAR2 | 2000 | The ledger account that receives the credit amount for the burden cost associated with the transaction. | ||
BURDEN_COST_DR_ACCOUNT | VARCHAR2 | 2000 | The ledger account that receives the debit amount for the burden cost associated with the transaction. | ||
CONTRACT_NUMBER | VARCHAR2 | 120 | Number of the contract for the transaction of a sponsored project. | ||
CONTRACT_NAME | VARCHAR2 | 300 | Name of the contract for the transaction of a sponsored project. | ||
FUNDING_SOURCE_NUMBER | VARCHAR2 | 50 | Number of the funding source of a transaction for a sponsored project. | ||
FUNDING_SOURCE_NAME | VARCHAR2 | 240 | Name of the funding source of a transaction for a sponsored project. | ||
SPONSORED_FLAG | VARCHAR2 | 1 | Indicates whether projects classified with this project type are sponsored projects. | ||
REFERENCE_DATE_TABLE | VARCHAR2 | 30 | The table name from which the START_DATE and END_DATE column values are derived. | ||
REFERENCE_DATE_COLUMN | DATE | The date column name of the entity associated to the transaction. Examples include project start date column name. | |||
REFERENCE_START_DATE | DATE | The start date of the entity associated to the transaction. Examples include start date of a project or task. | |||
REFERENCE_END_DATE | DATE | The end date of the entity associated to the transaction. Examples include start date of a project or task. | |||
REFERENCE_PRE_DATE | DATE | The pre-date of the entity. Examples include pre-award spending date of the contract. | |||
REFERENCE_STATUS_TABLE | VARCHAR2 | 30 | The table name from which the STATUS column values are derived. | ||
REFERENCE_STATUS_COLUMN | VARCHAR2 | 200 | The status column name of the entity associated to the transaction. Examples include project status column name. | ||
REFERENCE_STATUS_VALUE | VARCHAR2 | 60 | The status value of the entity associated to the transaction. Examples include status value of a project. | ||
REFERENCE_FLAG_TABLE | VARCHAR2 | 30 | The table name from which the FLAG column values are derived. | ||
REFERENCE_FLAG_COLUMN | VARCHAR2 | 200 | The flag column name of the entity associated to the transaction. Examples include allow duplicate reference column name. | ||
REFERENCE_FLAG_VALUE | VARCHAR2 | 60 | The flag value of the entity associated to the transaction. Examples include allow duplicate reference of a document. | ||
TXN_CONTROL_ID | NUMBER | 18 | Internal identifier of the transaction control record. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PJC_VALIDATION_ERRORS_N1 | Non Unique | Default | INTERFACE_ID, SOURCE_TXN_ID, MESSAGE_NAME |
PJC_VALIDATION_ERRORS_N2 | Non Unique | Default | TRANSACTION_NUMBER, SOURCE_ID_1, SOURCE_ID_2, SOURCE_ID_3, SOURCE_ID_4, SOURCE_ID_5, SOURCE_ID_6 |
PJC_VALIDATION_ERRORS_N3 | Non Unique | Default | ORIG_TRANSACTION_REFERENCE, TRANSACTION_SOURCE_CODE |
PJC_VALIDATION_ERRORS_N4 | Non Unique | Default | CREATION_DATE |
PJC_VALIDATION_ERRORS_U1 | Unique | Default | TXN_ERROR_ID |