IBY_FNDCPT_TX_EXTENSIONS
Payment attributes for a given funds capture transaction
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
IBY_FNDCPT_TX_EXTENSIONS_PK |
TRXN_EXTENSION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRXN_EXTENSION_ID | NUMBER | 18 | Yes | Sequence: IBY_FNDCPT_TX_EXTENSIONS_S.nextval | |
| PAYMENT_CHANNEL_CODE | VARCHAR2 | 30 | Yes | Payment channel code | |
| EXT_PAYER_ID | NUMBER | 18 | Foreign key to IBY_EXTERNAL_PAYERS_ALL.EXT_PAYER_ID | ||
| INSTR_ASSIGNMENT_ID | NUMBER | 18 | This column is a foreign key to IBY_PMT_INSTR_USES_ALL.INSTRUMENT_PAYMENT_USE_ID | ||
| INSTRUMENT_SECURITY_CODE | VARCHAR2 | 10 | Instrument security code. For credit cards this is the 3 or 4-digit security code printed on the card's reverse. Also known as CVVC for MasterCard, CVV2 for Visa, and CID for American Express. This column is encrypted. | ||
| INSTR_SEC_CODE_LENGTH | NUMBER | 2 | Instrument security code length; used to help in data compression | ||
| VOICE_AUTHORIZATION_FLAG | VARCHAR2 | 1 | Y or N flag indicating this transaction has a voice authorization | ||
| VOICE_AUTHORIZATION_DATE | DATE | Voice authorization date | |||
| VOICE_AUTHORIZATION_CODE | VARCHAR2 | 100 | Voice authorization code | ||
| ORDER_ID | VARCHAR2 | 75 | Transaction order identifier | ||
| PO_NUMBER | VARCHAR2 | 100 | Purchase order number | ||
| TRXN_REF_NUMBER1 | VARCHAR2 | 30 | Transaction reference number 1; optional transaction identifier used within the calling application | ||
| TRXN_REF_NUMBER2 | VARCHAR2 | 30 | Transaction reference number 2; optional transaction identifier used within the calling application | ||
| ADDITIONAL_INFO | VARCHAR2 | 255 | Free-text field for additional information | ||
| SEC_SUBKEY_ID | NUMBER | 18 | Security sub-key | ||
| ENCRYPTED | VARCHAR2 | 1 | Yes | Whether the extension is encrypted | |
| PO_LINE_NUMBER | VARCHAR2 | 100 | Purchase order line number | ||
| ORIGIN_APPLICATION_ID | NUMBER | Yes | Originating application id | ||
| TANGIBLEID | VARCHAR2 | 80 | The tangibleid generated by IBY for the transaction. This column will be used by Oracle Payments to link the upgraded transaction extensions with their associated IBY operations. | ||
| 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. | |
| INSTR_CODE_SEC_SEGMENT_ID | NUMBER | 18 | Foreign key to IBY_SECURITY_SEGMENTS.SEC_SEGMENT_ID | ||
| PAYMENT_SYSTEM_ORDER_NUMBER | VARCHAR2 | 80 | Payment system order number. | ||
| DEBIT_AUTHORIZATION_ID | NUMBER | 18 | Debit authorization identifier. | ||
| DEBIT_AUTH_LAST_TRX_FLAG | VARCHAR2 | 1 | Indicates if the transaction is the last transaction on the recurring Debit Authorization. | ||
| RECURR_PMT_REF | VARCHAR2 | 100 | Recurring payment schedule reference identifier. | ||
| RECURR_PMT_SEQ_NUM | NUMBER | 5 | The recurring payment sequence number. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_FNDCPT_TX_EXTENSIONS | iby_fndcpt_pmt_chnnls_b | PAYMENT_CHANNEL_CODE |
| IBY_FNDCPT_TX_EXTENSIONS | iby_pmt_instr_uses_all | INSTR_ASSIGNMENT_ID |
| IBY_FNDCPT_TX_EXTENSIONS | iby_security_segments | INSTR_CODE_SEC_SEGMENT_ID |
| IBY_FNDCPT_TX_EXTENSIONS | iby_external_payers_all | EXT_PAYER_ID |
| ra_customer_trx_all | iby_fndcpt_tx_extensions | PAYMENT_TRXN_EXTENSION_ID |
| iby_fndcpt_tx_operations | iby_fndcpt_tx_extensions | TRXN_EXTENSION_ID |
| ar_cash_receipts_all | iby_fndcpt_tx_extensions | PAYMENT_TRXN_EXTENSION_ID |
| arb_payment_audit | iby_fndcpt_tx_extensions | IBY_TRXN_EXTENSION_ID |
| arb_payment_audit | iby_fndcpt_tx_extensions | PAYMENT_TRXN_EXTENSION_ID |
| ra_interface_lines_all | iby_fndcpt_tx_extensions | PAYMENT_TRXN_EXTENSION_ID |
| ra_customer_trx_lines_all | iby_fndcpt_tx_extensions | PAYMENT_TRXN_EXTENSION_ID |
| iby_fndcpt_tx_xe_copies | iby_fndcpt_tx_extensions | SOURCE_TRXN_EXTENSION_ID |
| iby_fndcpt_tx_xe_copies | iby_fndcpt_tx_extensions | COPY_TRXN_EXTENSION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_FNDCPT_TX_EXTENSIONS_IU_N2 | Non Unique | Default | INSTR_ASSIGNMENT_ID |
| IBY_FNDCPT_TX_EXTENSIONS_N3 | Non Unique | Default | PAYMENT_SYSTEM_ORDER_NUMBER |
| IBY_FNDCPT_TX_EXTENSIONS_O_N1 | Non Unique | Default | ORDER_ID |
| IBY_FNDCPT_TX_EXTENSIONS_U1 | Unique | Default | TRXN_EXTENSION_ID |