[Home] [Help] [Dependency Information]
Object Name: | IBY_FNDCPT_TX_EXTENSIONS# |
---|---|
Object Type: | VIEW |
Owner: | IBY |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRXN_EXTENSION_ID | NUMBER | (15) | Yes | |
PAYMENT_CHANNEL_CODE | VARCHAR2 | (30) | Yes | |
EXT_PAYER_ID | NUMBER | (15) | ||
INSTR_ASSIGNMENT_ID | NUMBER | (15) | ||
INSTRUMENT_SECURITY_CODE | VARCHAR2 | (10) | ||
INSTR_SEC_CODE_LENGTH | NUMBER | (2) | ||
VOICE_AUTHORIZATION_FLAG | VARCHAR2 | (1) | ||
VOICE_AUTHORIZATION_DATE | DATE | |||
VOICE_AUTHORIZATION_CODE | VARCHAR2 | (100) | ||
ORDER_ID | VARCHAR2 | (75) | ||
PO_NUMBER | VARCHAR2 | (100) | ||
TRXN_REF_NUMBER1 | VARCHAR2 | (30) | ||
TRXN_REF_NUMBER2 | VARCHAR2 | (30) | ||
ADDITIONAL_INFO | VARCHAR2 | (255) | ||
INSTR_CODE_SEC_SEGMENT_ID | NUMBER | (15) | ||
ENCRYPTED | VARCHAR2 | (1) | Yes | |
PO_LINE_NUMBER | VARCHAR2 | (100) | ||
ORIGIN_APPLICATION_ID | NUMBER | Yes | ||
TANGIBLEID | VARCHAR2 | (80) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
PAYMENT_SYSTEM_ORDER_NUMBER | VARCHAR2 | (80) | ||
SEQ_TYPE_LAST | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT TRXN_EXTENSION_ID
, PAYMENT_CHANNEL_CODE
, EXT_PAYER_ID
, INSTR_ASSIGNMENT_ID
, INSTRUMENT_SECURITY_CODE
, INSTR_SEC_CODE_LENGTH
, VOICE_AUTHORIZATION_FLAG
, VOICE_AUTHORIZATION_DATE
, VOICE_AUTHORIZATION_CODE
, ORDER_ID
, PO_NUMBER
, TRXN_REF_NUMBER1
, TRXN_REF_NUMBER2
, ADDITIONAL_INFO
, INSTR_CODE_SEC_SEGMENT_ID
, ENCRYPTED
, PO_LINE_NUMBER
, ORIGIN_APPLICATION_ID
, TANGIBLEID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, PAYMENT_SYSTEM_ORDER_NUMBER
, SEQ_TYPE_LAST
FROM IBY.IBY_FNDCPT_TX_EXTENSIONS#;
|
|
|