IBY_TEMP_EXT_PAYEES
IBY_TEMP_EXT_PAYEES stores payment processing attributes for external payees.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
IBY_TEMP_EXT_PAYEES_PK |
TEMP_EXT_PAYEE_ID, FEEDER_IMPORT_BATCH_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TEMP_EXT_PAYEE_ID | NUMBER | 18 | Yes | Primary identifier. Populated by Oracle. | |
STATUS | VARCHAR2 | 30 | Yes | Interface record status. Valid values: NEW, PROCESSED, REJECTED. | |
PAYMENT_FUNCTION | VARCHAR2 | 30 | Yes | Interface record type. Use: PA. | |
PARTY_ID | NUMBER | 18 | Party identifier. Use the Manage Suppliers task to identify valid values. Use either PARTY_ID or VENDOR_CODE, but not both. Foreign key to party at HZ_PARTIES_ALL.PARTY_ID. | ||
ORG_TYPE | VARCHAR2 | 30 | Oracle internal use only. Valid values: Business Group, Legal Entity, Business Unit. | ||
ORG_ID | NUMBER | 18 | Identifies the business unit. Use the Manage Business Units task to identify valid values. | ||
BANK_CHARGE_BEARER | VARCHAR2 | 30 | Party that is responsible for paying regular or express bank charges, such as payee or payer. Valid values: BEN, OUR, SHA, PAYEE_PAYS_EXPRESS. BEN means payee. OUR means payer. SHA means shared. PAYEE_PAYS_EXPRESS means express charges. | ||
PARTY_SITE_ID | NUMBER | 18 | Party site use identifier. Use the Manage Suppliers task to identify valid values. | ||
SUPPLIER_SITE_ID | NUMBER | 18 | Supplier site identifier. Use the Manage Suppliers task to identify valid values. | ||
DEFAULT_PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Default payment method. Use the Management Payment Methods task, Payment Method Codes option, to identify valid values. | ||
ECE_TP_LOCATION_CODE | VARCHAR2 | 60 | Trading partner location code for the e-Commerce Gateway. Free text field. Not validated. | ||
BANK_INSTRUCTION1_CODE | VARCHAR2 | 30 | Bank instruction code. Use the Manage Payment Codes task, Bank Instruction option to identify valid values. | ||
BANK_INSTRUCTION2_CODE | VARCHAR2 | 30 | Bank instruction code. Use the Manage Payment Codes task, Bank Instruction option to identify valid values. | ||
BANK_INSTRUCTION_DETAILS | VARCHAR2 | 255 | Additional bank instruction details. Free text field. Not validated. | ||
PAYMENT_REASON_CODE | VARCHAR2 | 30 | Payment reason code provided by government or central bank. Use the Manage Payment Codes task, Payment Reason option, to identify valid values. | ||
PAYMENT_REASON_COMMENTS | VARCHAR2 | 240 | Reason for payment. Free text field. Not validated. | ||
PAYMENT_TEXT_MESSAGE1 | VARCHAR2 | 256 | Payment message. Free text field. Not validated. | ||
PAYMENT_TEXT_MESSAGE2 | VARCHAR2 | 256 | Payment message. Free text field. Not validated. | ||
PAYMENT_TEXT_MESSAGE3 | VARCHAR2 | 256 | Payment message. Free text field. Not validated. | ||
DELIVERY_CHANNEL_CODE | VARCHAR2 | 30 | Indicates how to execute payment. Use the Manage Payment Codes task, Delivery Channel option, to identify valid values. | ||
PAYMENT_FORMAT_CODE | VARCHAR2 | 30 | Payment format code. Use the Manage Formats task, Disbursement Payment File Formats option, to identify valid values. | ||
EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | 1 | Yes | Indicates whether similar documents payable are prevented from being grouped for payment. Valid values: Y, N. | |
SETTLEMENT_PRIORITY | VARCHAR2 | 30 | Priority for executing payment. Valid values: NORMAL, EXPRESS. Valid values defined by lookup IBY_SETTLEMENT_PRIORITY. | ||
START_DATE | DATE | Yes | Date payee record becomes active. Date format: YYYY/MM/DD. Must be earlier than END_DATE. | ||
END_DATE | DATE | Yes | Date payee record becomes inactive. Date format: YYYY/MM/DD. Must be later than START_DATE. | ||
FEEDER_IMPORT_BATCH_ID | NUMBER | 18 | Yes | Unique number to identify the batch. Free text field. Not validated. | |
ORIG_SYSTEM | VARCHAR2 | 80 | Original system for the external payee. Not used for Oracle Cloud implementations. Free text field. Not validated. | ||
ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Original system reference for the external payee. Not used for Oracle Cloud implementations. Free text field. Not validated. | ||
LOCAL_INSTRUMENT_CODE | VARCHAR2 | 30 | Payment method for a specific locale. Use the Management Payment Codes task, Local Instrument option, to identify valid values. | ||
REMIT_ADVICE_DELIVERY_METHOD | VARCHAR2 | 30 | Communication method for delivering remittance advice. Valid values: EMAIL, FAX, PRINTED. | ||
REMIT_ADVICE_EMAIL | VARCHAR2 | 255 | E-mail address of the payee for receiving remittance advice. Should be in standard email format with @. Not validated. | ||
REMIT_ADVICE_FAX | VARCHAR2 | 100 | Fax number of the payee for receiving remittance advice. Free text field. Not validated. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: session login associated to the user who last updated the row. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. Incremented every time the row is updated. Compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
VENDOR_CODE | VARCHAR2 | 30 | Vendor code. Use the Manage Suppliers task to identify valid values. Use either PARTY_ID or VENDOR_CODE, but not both. | ||
VENDOR_SITE_CODE | VARCHAR2 | 240 | Vendor Site Code. Use the Manage Suppliers task to identify valid values. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: request ID of the loader job that created or last updated the row. | ||
BUSINESS_UNIT | VARCHAR2 | 240 | Indicates the business unit of the Payee |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
IBY_TEMP_EXT_PAYEES | iby_payment_methods_b | DEFAULT_PAYMENT_METHOD_CODE |
IBY_TEMP_EXT_PAYEES | iby_formats_b | PAYMENT_FORMAT_CODE |
iby_temp_pmt_instr_uses | iby_temp_ext_payees | TEMP_EXT_PARTY_ID, FEEDER_IMPORT_BATCH_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
IBY_TEMP_EXT_PAYEES_U1 | Unique | Default | TEMP_EXT_PAYEE_ID, FEEDER_IMPORT_BATCH_ID |