IBY_DEBIT_AUTHORIZATIONS_F
This table is used to store Debit Authorization details.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
IBY_DEBIT_AUTHORIZATIONS_F_PK |
DEBIT_AUTHORIZATION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
DEBIT_AUTHORIZATION_ID | NUMBER | 18 | Yes | DebitAuthorization Identifier | |
EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
EFFECTIVE_END_DATE | DATE | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||
DEBTOR_PARTY_ID | NUMBER | 18 | Yes | Party identifier of the debtor. | |
EXTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | Yes | Foreign key to payer bank account. | |
PAYMENT_TYPE_CODE | VARCHAR2 | 30 | Determines type of mandate: either recurring or one-off. | ||
DEBIT_AUTH_METHOD | VARCHAR2 | 30 | The method of delivering the debit authorization. Values include digital signature, written document, phone, and other. | ||
AUTHORIZATION_REFERENCE_NUMBER | VARCHAR2 | 100 | Yes | Authorization reference identifier. Unique per creditor. | |
AUTHORIZATION_REVISION_NUMBER | NUMBER | 6 | Yes | Version number of debit authorization: set at 1 and increases with each new admendment. | |
CREDITOR_LEGAL_ENTITY_ID | NUMBER | 18 | Foreign key ??? legal entity of internal bank account. | ||
AMENDMENT_REASON_CODE | VARCHAR2 | 30 | Amendment reason code if debt authorization is revised ??? required for all revisions. | ||
CREDITOR_IDENTIFIER | VARCHAR2 | 150 | Creditor identifier, as provided on the debit authorization document. | ||
DIRECT_DEBIT_COUNT | NUMBER | 18 | Number of direct debit transactions created for this authorization. | ||
DIRECT_DEBIT_MAX_COUNT | NUMBER | 18 | Maximum number of direct debits allowed for this authorization. | ||
AUTH_SIGN_DATE | DATE | Date the debtor signed the debit authorization. | |||
AUTH_CANCEL_DATE | DATE | Date the debtor signed the debit authorization. | |||
PRIMARY_FLAG | VARCHAR2 | 1 | Date the debtor signed the debit authorization. | ||
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. | |
EXTERNAL_PAYER_ID | NUMBER | 18 | Maps to customer site or account through payers table. | ||
BANK_ACCOUNT_USE_ID | NUMBER | 18 | Internal Bank Account Usage reference. | ||
REQUIRES_PRE_NOTIFICATION | VARCHAR2 | 30 | Flag related to pre-notification. | ||
RECURRING_PAYMENT_TYPE | VARCHAR2 | 30 | Type of Debit Authorization, one off or recurring. | ||
DEBIT_AUTHORIZATION_VERSION | NUMBER | 18 | Version of Debit Authorization. | ||
DEBIT_AUTH_FREQUENCY | VARCHAR2 | 20 | Regularity with which direct debit instructions are to be created and processed. | ||
DEBIT_AUTH_FNL_COLLTN_DATE | DATE | Date of the final collection of a direct debit as per the debit authorization. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
IBY_DEBIT_AUTHORIZATIONS_F_N1 | Non Unique | Default | DEBTOR_PARTY_ID, EXTERNAL_BANK_ACCOUNT_ID |
IBY_DEBIT_AUTHORIZATIONS_F_N2 | Non Unique | Default | AUTHORIZATION_REFERENCE_NUMBER |
IBY_DEBIT_AUTHORIZATIONS_F_U1 | Unique | Default | DEBIT_AUTHORIZATION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE |