IBY_HOOK_DOCS_IN_PMT

Details

Schema: FUSION
Object owner: IBY
Object type: TABLE

Primary Key

Name	Columns
IBY_HOOK_DOCS_IN_PMT_T_PK	DOCUMENT_PAYABLE_ID

Columns

Name
PAYMENT_IDNUMBER18YesOracle internal use only. DOCUMENT_PAYABLE_IDNUMBER18YesOracle internal use only. CALLING_APP_IDNUMBER18YesOracle internal use only. CALLING_APP_DOC_UNIQUE_REF1NUMBER18YesOracle internal use only. CALLING_APP_DOC_UNIQUE_REF2NUMBER18Oracle internal use only. CALLING_APP_DOC_UNIQUE_REF3NUMBER18Oracle internal use only. CALLING_APP_DOC_UNIQUE_REF4NUMBER18Oracle internal use only. CALLING_APP_DOC_UNIQUE_REF5NUMBER18Oracle internal use only. DOCUMENT_AMOUNTNUMBERYesOracle internal use only. DOCUMENT_CURRENCY_CODEVARCHAR210YesOracle internal use only. AMOUNT_WITHHELDNUMBEROracle internal use only. DONT_PAY_FLAGVARCHAR21Oracle internal use only. DONT_PAY_REASON_CODEVARCHAR230Oracle internal use only. DONT_PAY_DESCRIPTIONVARCHAR2255Oracle internal use only. PAY_PROC_TRXN_TYPE_CODEVARCHAR2100YesOracle 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. PAYMENT_CURR_DISCOUNT_TAKENNUMBEROracle 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.

Name

PAYMENT_IDNUMBER18YesOracle internal use only.

DOCUMENT_PAYABLE_IDNUMBER18YesOracle internal use only.

CALLING_APP_IDNUMBER18YesOracle internal use only.

CALLING_APP_DOC_UNIQUE_REF1NUMBER18YesOracle internal use only.

CALLING_APP_DOC_UNIQUE_REF2NUMBER18Oracle internal use only.

CALLING_APP_DOC_UNIQUE_REF3NUMBER18Oracle internal use only.

CALLING_APP_DOC_UNIQUE_REF4NUMBER18Oracle internal use only.

CALLING_APP_DOC_UNIQUE_REF5NUMBER18Oracle internal use only.

DOCUMENT_AMOUNTNUMBERYesOracle internal use only.

DOCUMENT_CURRENCY_CODEVARCHAR210YesOracle internal use only.

AMOUNT_WITHHELDNUMBEROracle internal use only.

DONT_PAY_FLAGVARCHAR21Oracle internal use only.

DONT_PAY_REASON_CODEVARCHAR230Oracle internal use only.

DONT_PAY_DESCRIPTIONVARCHAR2255Oracle internal use only.

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

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

Indexes

Index	Uniqueness	Columns
IBY_HOOK_DOCS_IN_PMT_T_PK	Unique	DOCUMENT_PAYABLE_ID