IBY_DOCS_PAYABLE_VAL_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| CALLING_APP_ID | NUMBER | 18 | Yes | Oracle internal use only. | Active | |
| CALLING_APP_DOC_ID1 | VARCHAR2 | 100 | Oracle internal use only. | Active | ||
| CALLING_APP_DOC_ID2 | VARCHAR2 | 100 | Oracle internal use only. | Active | ||
| CALLING_APP_DOC_ID3 | VARCHAR2 | 100 | Oracle internal use only. | Active | ||
| CALLING_APP_DOC_ID4 | VARCHAR2 | 100 | Oracle internal use only. | Active | ||
| CALLING_APP_DOC_ID5 | VARCHAR2 | 100 | Oracle internal use only. | Active | ||
| PAYMENT_PROC_TRXN_TYPE_CODE | VARCHAR2 | 100 | Oracle internal use only. | Active | ||
| DOCUMENT_ID | NUMBER | 18 | Yes | Oracle internal use only. | Active | |
| DOCUMENT_AMOUNT | NUMBER | Oracle internal use only. | Active | |||
| DOCUMENT_PAYMENT_CURRENCY | VARCHAR2 | 10 | Oracle internal use only. | Active | ||
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | 1 | Oracle internal use only. | Active | ||
| DELIVERY_CHANNEL_CODE | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| DELIVERY_CHANNEL_FORMAT_VAL | VARCHAR2 | 80 | Oracle internal use only. | Active | ||
| UNIQUE_REMIT_ID_CODE | VARCHAR2 | 256 | Unique remittance Identifier provided by the payee | Active | ||
| PAYMENT_REASON_COMMENTS | VARCHAR2 | 240 | Oracle internal use only. | Active | ||
| SETTLEMENT_PRIORITY | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| REMITTANCE_MESSAGE1 | VARCHAR2 | 150 | Oracle internal use only. | Active | ||
| REMITTANCE_MESSAGE2 | VARCHAR2 | 150 | Oracle internal use only. | Active | ||
| REMITTANCE_MESSAGE3 | VARCHAR2 | 150 | Oracle internal use only. | Active | ||
| URI_CHECK_DIGIT | VARCHAR2 | 2 | Oracle internal use only. | Active | ||
| PAYMENT_GROUP_CODE | VARCHAR2 | 25 | Oracle internal use only. | Active | ||
| INT_BANK_NUM | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| INT_BANK_NAME | VARCHAR2 | 360 | Oracle internal use only. | Active | ||
| INT_BANK_NAME_ALT | VARCHAR2 | 320 | Oracle internal use only. | Active | ||
| INT_BANK_BRANCH_NUM | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| INT_BANK_BRANCH_NAME | VARCHAR2 | 360 | Oracle internal use only. | Active | ||
| INT_BANK_BRANCH_NAME_ALT | VARCHAR2 | 320 | Oracle internal use only. | Active | ||
| INT_BANK_COUNTRY | VARCHAR2 | 2 | Oracle internal use only. | Active | ||
| INT_BANK_ACCT_NUM | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| INT_BANK_ACCT_NAME | VARCHAR2 | 100 | Oracle internal use only. | Active | ||
| INT_BANK_ACCT_NAME_ALT | VARCHAR2 | 320 | Oracle internal use only. | Active | ||
| INT_BANK_ACCT_TYPE | VARCHAR2 | 25 | Oracle internal use only. | Active | ||
| INT_BANK_ACCT_CURR | VARCHAR2 | 15 | Oracle internal use only. | Active | ||
| INT_BANK_ACCT_IBAN | VARCHAR2 | 50 | Oracle internal use only. | Active | ||
| INT_BANK_ASSIGNED_ID1 | VARCHAR2 | 240 | Oracle internal use only. | Active | ||
| INT_BANK_ASSIGNED_ID2 | VARCHAR2 | 240 | Oracle internal use only. | Active | ||
| INT_EFT_USER_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| INT_BANK_ACCT_CHK_DIGITS | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| INT_EFT_REQ_IDENTIFIER | VARCHAR2 | 25 | Oracle internal use only. | Active | ||
| INT_BANK_ACCT_SHORT_NAME | VARCHAR2 | 240 | Oracle internal use only. | Active | ||
| INT_BANK_ACCT_HOLDER_NAME | VARCHAR2 | 240 | Oracle internal use only. | Active | ||
| INT_BANK_ACCT_HOLDER_NAME_ALT | VARCHAR2 | 240 | Oracle internal use only. | Active | ||
| PAYER_LE_NAME | VARCHAR2 | 240 | Oracle internal use only. | Active | ||
| PAYER_LE_COUNTRY | VARCHAR2 | 2 | Oracle internal use only. | Active | ||
| PAYER_PHONE | VARCHAR2 | 100 | Oracle internal use only. | Active | ||
| EXT_BANK_NUM | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| EXT_BANK_NAME | VARCHAR2 | 360 | Oracle internal use only. | Active | ||
| EXT_BANK_NAME_ALT | VARCHAR2 | 320 | Oracle internal use only. | Active | ||
| EXT_BANK_BRANCH_NUM | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| EXT_BANK_BRANCH_NAME | VARCHAR2 | 360 | Oracle internal use only. | Active | ||
| EXT_BANK_BRANCH_NAME_ALT | VARCHAR2 | 320 | Oracle internal use only. | Active | ||
| EXT_BANK_COUNTRY | VARCHAR2 | 2 | Oracle internal use only. | Active | ||
| EXT_BANK_BRANCH_ADDR1 | VARCHAR2 | 240 | Oracle internal use only. | Active | ||
| EXT_BANK_BRANCH_COUNTRY | VARCHAR2 | 2 | Oracle internal use only. | Active | ||
| EXT_BANK_ACCT_NUM | VARCHAR2 | 100 | Oracle internal use only. | Active | ||
| EXT_BANK_ACCT_NAME | VARCHAR2 | 80 | Oracle internal use only. | Active | ||
| EXT_BANK_BIC | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| EXT_BANK_ACCT_NAME_ALT | VARCHAR2 | 320 | Oracle internal use only. | Active | ||
| EXT_BANK_ACCT_TYPE | VARCHAR2 | 25 | Oracle internal use only. | Active | ||
| EXT_BANK_ACCT_IBAN | VARCHAR2 | 50 | Oracle internal use only. | Active | ||
| EXT_BANK_ACCT_CHK_DIGITS | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| EXT_BANK_ACCT_SHORT_NAME | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| EXT_BANK_ACCT_HOLDER_NAME | VARCHAR2 | 360 | Oracle internal use only. | Active | ||
| EXT_BANK_ACCT_HOLDER_NAME_ALT | VARCHAR2 | 320 | Oracle internal use only. | Active | ||
| PAYEE_PARTY_NAME | VARCHAR2 | 360 | Oracle internal use only. | Active | ||
| PAYEE_PARTY_ADDR1 | VARCHAR2 | 240 | Oracle internal use only. | Active | ||
| PAYEE_PARTY_ADDR2 | VARCHAR2 | 240 | Oracle internal use only. | Active | ||
| PAYEE_PARTY_ADDR3 | VARCHAR2 | 240 | Oracle internal use only. | Active | ||
| PAYEE_PARTY_CITY | VARCHAR2 | 60 | Oracle internal use only. | Active | ||
| PAYEE_PARTY_STATE | VARCHAR2 | 120 | Oracle internal use only. | Active | ||
| PAYEE_PARTY_PROVINCE | VARCHAR2 | 120 | Oracle internal use only. | Active | ||
| PAYEE_PARTY_COUNTY | VARCHAR2 | 120 | Oracle internal use only. | Active | ||
| PAYEE_PARTY_POSTAL | VARCHAR2 | 60 | Oracle internal use only. | Active | ||
| PAYEE_PARTY_COUNTRY | VARCHAR2 | 2 | Oracle internal use only. | Active | ||
| BANK_CHARGE_BEARER | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| PAYMENT_REASON_CODE | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| PAYEE_PAYMENT_FORMAT_CODE | VARCHAR2 | 30 | Oracle internal use only. | Active | ||
| PAYEE_PARTY_SITE_NAME | VARCHAR2 | 240 | Oracle internal use only. | Active | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Active | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| CALLING_APP_DOC_REF_NUMBER | VARCHAR2 | 100 | Invoice reference number.Need not be unique. | |||
| INVOICE_ORG_NAME | VARCHAR2 | 250 | Invoice business unit organization name. | |||
| PAYMENT_ORG_NAME | VARCHAR2 | 250 | Payment business unit organization name. | |||
| INVOICE_TYPE_CODE | VARCHAR2 | 80 | Invoice category, such as standard, credit memo, payment request or prepayment. | |||
| PAYEE_BANK_CURRENCY_CODE | VARCHAR2 | 20 | Supplier bank account currency code. | |||
| EXT_BANK_BRANCH_TYPE | VARCHAR2 | 30 | External Bank Branch Classification Code. Need not be unique | |||
| INT_BANK_BRANCH_TYPE | VARCHAR2 | 30 | Internal Bank Branch Classification Code. Need not be unique | |||
| INT_BANK_BIC | VARCHAR2 | 30 | Bank Branch Identification code | |||
| PAYMENT_METHOD_ALIAS | VARCHAR2 | 80 | Alias value used in the payment file | |||
| INT_BANK_BRANCH_COUNTRY | VARCHAR2 | 2 | Country of the payer bank branch country | |||
| BANK_INSTRUCTION1_CODE | VARCHAR2 | 30 | Code of the first bank instruction | |||
| BANK_INSTRUCTION2_CODE | VARCHAR2 | 30 | Code of the second bank instruction | |||
| PAYMENT_FORMAT_CODE | VARCHAR2 | 30 | Code of the Payment format used for making payment | |||
| SERVICE_LEVEL_CODE | VARCHAR2 | 30 | The service level with which payment will be delivered | |||
| PAYMENT_MODE_CODE | VARCHAR2 | 30 | Invoice payment mode identifier. | |||
| PAYMENT_INSTRUMENT_ID | NUMBER | 18 | Funding instrument used for making payments. |
Indexes
| Index | Uniqueness | Columns | Status |
|---|---|---|---|
| IBY_DOCS_PAYABLE_VAL_GT_U1 | Unique | DOCUMENT_ID | Active |