KCRT_TABLE_ENTRIES_INT
The KCRT_TABLE_ENTRIES_INT interface table specifies the table fields defined in the request type for the request.
Column |
Usage |
Data Type |
Description |
---|---|---|---|
GROUP_ID |
I |
NUMBER |
Groups all the records that should be processed at the same time. Use only one GROUP_ID each time you run a report. Derived from the KNTA_INTERFACE_GROUPS_S sequence. This value should be the same as the parent's GROUP_ID in KCRT_REQUEST_INT. |
TRANSACTION_ID |
I |
NUMBER |
Uniquely identifies each transaction. |
PARENT_TRANSACTION_ID |
I |
NUMBER |
Provides the transaction ID (from KCRT_REQUEST_DETAILS_INT) of the parent table being imported. |
PARENT_FIELD_TOKEN |
I |
VARCHAR2 |
Specifies the token. |
TABLE_ENTRY_ID |
I/O |
NUMBER |
Identifies the table entry record. If left blank, the value is derived from the KCRT_TABLE_ENTRIES_S sequence. |
REQUEST_ID |
I/O |
NUMBER |
Identifies the request. This is normally left blank and is derived from the KCRT_REQUESTS_S sequence. |
PARAMETER_SET_FIELD_ID |
I/O |
NUMBER |
Specifies the field in the table to which this entry belongs. |
SEQ |
I |
NUMBER |
Provides a user-visible sequence number for the package line. This must be a unique, positive integer that does not conflict with other records being imported. |
PARAMETER_SET_CONTEXT_ID |
I/O |
NUMBER |
Sets the context identifier for the detail fields. If left blank, the value is derived from the REQUEST_TYPE_NAME. |
VISIBLE_PARAMETER1 PARAMETER1 through VISIBLE_PARAMETER50 PARAMETER50 |
I |
VARCHAR2 |
Specifies the user-defined fields attached to the user screen. This is required only if user data is defined. |
LOOKUP_TYPE1 through LOOKUP_TYPE50 |
I |
VARCHAR2 |
Identifies the lookup type for each PARAMETER. This is required only if user data is defined. |
VALIDATION_TYPE_CODE1 through VALIDATION_TYPE_CODE50 |
I |
VARCHAR2 |
Identifies the validation type code for each PARAMETER. This is required only if user data is defined. |