IBY_HOOK_PAYMENTS

Details

Schema: FUSION
Object owner: IBY
Object type: TABLE

Primary Key

Name	Columns
IBY_HOOK_PAYMENTS_T_PK	PAYMENT_ID

Columns

Name
CALLING_APP_IDNUMBER18YesOracle internal use only CALL_APP_PAY_SERVICE_REQ_CODEVARCHAR2255YesOracle internal use only PAYMENT_SERVICE_REQUEST_IDNUMBER18YesOracle internal use only PAYMENT_IDNUMBER18YesOracle internal use only PAYMENT_AMOUNTNUMBEROracle internal use only PAYMENT_CURRENCY_CODEVARCHAR210YesOracle internal use only DONT_PAY_FLAGVARCHAR21Oracle internal use only DONT_PAY_REASON_CODEVARCHAR230Oracle internal use only DONT_PAY_DESCRIPTIONVARCHAR2255Oracle internal use only INTERNAL_BANK_ACCOUNT_IDNUMBER18YesOracle internal use only EXT_PAYEE_IDNUMBER18YesOracle internal use only PAYEE_PARTY_IDNUMBER18Oracle internal use only PARTY_SITE_IDNUMBER18Oracle internal use only SUPPLIER_SITE_IDNUMBER18Oracle internal use only ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row. ORG_TYPEVARCHAR230Oracle internal use only EXTERNAL_BANK_ACCOUNT_IDNUMBER18Oracle internal use only DISCOUNT_AMOUNT_TAKENNUMBEROracle internal use only PAYMENT_DATEDATEOracle internal use only BANK_CHARGE_AMOUNTNUMBEROracle internal use only CREATED_BYVARCHAR264YesWho column: indicates the user who created the row. CREATION_DATETIMESTAMPYesWho column: indicates the date and time of the creation of the row. LAST_UPDATED_BYVARCHAR264YesWho column: indicates the user who last updated the row. LAST_UPDATE_DATETIMESTAMPYesWho column: indicates the date and time of the last update of the row. LAST_UPDATE_LOGINVARCHAR232Who column: indicates the session login associated to the user who last updated the row. OBJECT_VERSION_NUMBERNUMBER9YesUsed 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. SETTLEMENT_PRIORITYVARCHAR230Oracle internal use only PAYMENT_PROFILE_IDNUMBER18Oracle internal use only LEGAL_ENTITY_IDNUMBER18Legal entity identifier.

Name

CALLING_APP_IDNUMBER18YesOracle internal use only

CALL_APP_PAY_SERVICE_REQ_CODEVARCHAR2255YesOracle internal use only

PAYMENT_SERVICE_REQUEST_IDNUMBER18YesOracle internal use only

PAYMENT_IDNUMBER18YesOracle internal use only

PAYMENT_AMOUNTNUMBEROracle internal use only

PAYMENT_CURRENCY_CODEVARCHAR210YesOracle internal use only

DONT_PAY_FLAGVARCHAR21Oracle internal use only

DONT_PAY_REASON_CODEVARCHAR230Oracle internal use only

DONT_PAY_DESCRIPTIONVARCHAR2255Oracle internal use only

INTERNAL_BANK_ACCOUNT_IDNUMBER18YesOracle internal use only

EXT_PAYEE_IDNUMBER18YesOracle internal use only

PAYEE_PARTY_IDNUMBER18Oracle internal use only

PARTY_SITE_IDNUMBER18Oracle internal use only

SUPPLIER_SITE_IDNUMBER18Oracle internal use only

ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row.

ORG_TYPEVARCHAR230Oracle internal use only

EXTERNAL_BANK_ACCOUNT_IDNUMBER18Oracle internal use only

DISCOUNT_AMOUNT_TAKENNUMBEROracle internal use only

PAYMENT_DATEDATEOracle internal use only

BANK_CHARGE_AMOUNTNUMBEROracle internal use only

CREATED_BYVARCHAR264YesWho column: indicates the user who created the row.

CREATION_DATETIMESTAMPYesWho column: indicates the date and time of the creation of the row.

LAST_UPDATED_BYVARCHAR264YesWho column: indicates the user who last updated the row.

LAST_UPDATE_DATETIMESTAMPYesWho column: indicates the date and time of the last update of the row.

LAST_UPDATE_LOGINVARCHAR232Who column: indicates the session login associated to the user who last updated the row.

OBJECT_VERSION_NUMBERNUMBER9YesUsed 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.

SETTLEMENT_PRIORITYVARCHAR230Oracle internal use only

PAYMENT_PROFILE_IDNUMBER18Oracle internal use only

LEGAL_ENTITY_IDNUMBER18Legal entity identifier.

Indexes

Index	Uniqueness	Columns
IBY_HOOK_PAYMENTS_T_U1	Unique	PAYMENT_ID