[Home] [Help] [Dependency Information]
Object Name: | IBY_EXT_FD_INS_1_0_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IBY.IBY_EXT_FD_INS_1_0_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_INSTRUCTION_ID | NUMBER | (15) | Yes | |
INSTRUCTION_CREATED_DATE | DATE | Yes | ||
PAYMENT_INSTRUCTION_STATUS | VARCHAR2 | (30) | Yes | |
INSTRUCTION_STATUS_MEANING | VARCHAR2 | (80) | Yes | QuickCode meaning |
PROCESSING_TYPE | VARCHAR2 | (30) | Yes | |
PAY_ADMIN_ASSIGNED_REF_CODE | VARCHAR2 | (255) | ||
BANK_ASSIGNED_REF_CODE | VARCHAR2 | (30) | ||
PERIODIC_SEQUENCE_NAME_1 | VARCHAR2 | (80) | ||
LAST_USED_NUMBER_1 | NUMBER | (15) | ||
PERIODIC_SEQUENCE_NAME_2 | VARCHAR2 | (80) | ||
LAST_USED_NUMBER_2 | NUMBER | (15) | ||
PERIODIC_SEQUENCE_NAME_3 | VARCHAR2 | (80) | ||
LAST_USED_NUMBER_3 | NUMBER | (15) | ||
BANK_INSTRUCTION1_CODE | VARCHAR2 | (30) | ||
BANK_INSTRUCTION1_MEANING | VARCHAR2 | (80) | ||
BANK_INSTRUCTION1_FORMAT_VALUE | VARCHAR2 | (80) | ||
BANK_INSTRUCTION2_CODE | VARCHAR2 | (30) | ||
BANK_INSTRUCTION2_MEANING | VARCHAR2 | (80) | ||
BANK_INSTRUCTION2_FORMAT_VALUE | VARCHAR2 | (80) | ||
BANK_INSTRUCTION_DETAILS | VARCHAR2 | (255) | ||
PAYMENT_TEXT_MESSAGE1 | VARCHAR2 | (150) | ||
PAYMENT_TEXT_MESSAGE2 | VARCHAR2 | (150) | ||
DECLARATION_OPTION | VARCHAR2 | (30) | ||
BEP_ACCOUNT_NAME | VARCHAR2 | (80) | ||
BEP_ACCOUNT_ID | NUMBER | (15) | ||
PAYSYS_ACCT_ATTR_CAT | VARCHAR2 | (150) | ||
COMMENTS | VARCHAR2 | (240) | ||
PI_ATTR_CAT | VARCHAR2 | (150) | ||
PAYMENT_PROFILE_ID | NUMBER | (15) | ||
SYSTEM_PROFILE_CODE | VARCHAR2 | (100) | Yes | |
PAYMENT_PROFILE_NAME | VARCHAR2 | (100) | ||
LOGICAL_GROUPING_MODE | VARCHAR2 | (50) | Specifies the grouping mode of the payment process profile | |
BATCH_BOOKING_FLAG | VARCHAR2 | (1) | Specifies whether the bank will send statement based on payment/group | |
PAYMENT_PROFILE_ATTR_CAT | VARCHAR2 | (150) | ||
PAYMENT_FORMAT_CODE | VARCHAR2 | (30) | Yes | |
PAYMENT_FORMAT_NAME | VARCHAR2 | (300) | Yes | |
PAYMENT_FORMAT_ATTR_CAT | VARCHAR2 | (150) | ||
PAYER_INSTRUMENT_COUNT | NUMBER | |||
PAYMENT_COUNT | NUMBER | (15) | Yes | |
PAYMENT_DATE | DATE | |||
PAYMENT_CURRENCY_CODE | VARCHAR2 | (10) | ||
PAYMENT_SERVICE_REQUEST_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | ||
ORG_TYPE | VARCHAR2 | (30) | ||
ORG_TYPE_MEANING | VARCHAR2 | (80) | ||
ORG_NAME | VARCHAR2 | (240) | ||
PAYMENT_REASON_CODE | VARCHAR2 | (30) | ||
PAY_REASON_MEANING | VARCHAR2 | (80) | ||
PAY_REASON_FORMAT_VALUE | VARCHAR2 | (80) | ||
PAYMENT_REASON_COMMENTS | VARCHAR2 | (240) | ||
GROUP_BY_PAYMENT_DATE | VARCHAR2 | (1) | ||
GROUP_BY_PAYMENT_CURRENCY | VARCHAR2 | (1) | ||
GROUP_BY_PAY_SERVICE_REQUEST | VARCHAR2 | (1) | ||
GROUP_BY_LEGAL_ENTITY | VARCHAR2 | (1) | ||
GROUP_BY_ORGANIZATION | VARCHAR2 | (1) | ||
GROUP_BY_PAYMENT_REASON | VARCHAR2 | (1) | ||
LEGAL_ENTITY_ID | NUMBER | (15) | ||
GROUP_BY_INTERNAL_BANK_ACCOUNT | VARCHAR2 | (1) | ||
GROUP_BY_PAYMENT_FUNCTION | VARCHAR2 | (1) | ||
GROUP_BY_RFC | VARCHAR2 | (1) | ||
GROUP_BY_PAYMENT_METHOD | VARCHAR2 | (1) | Specifies whether payments must be grouped by payment method to form instruction | |
INTERNAL_BANK_ACCOUNT_ID | NUMBER | (15) | ||
PAYMENT_FUNCTION | VARCHAR2 | (30) | ||
PAYMENT_FUNCTION_MEANING | VARCHAR2 | (80) | ||
RFC_IDENTIFIER | VARCHAR2 | (30) | ||
PAYMENT_METHOD_CODE | VARCHAR2 | (50) | Code of the payment method of the payment instruction | |
PROCESS_TYPE | VARCHAR2 | (30) | Yes | |
TOTAL_PMT_AMOUNT | NUMBER | |||
MOAC_DATA_BLOCKED_FLAG | VARCHAR2 | (1) | ||
PAYMENT_DOCUMENT_NAME | VARCHAR2 | (100) | ||
PAPER_STOCK_TYPE | VARCHAR2 | (30) | ||
PAPER_STOCK_TYPE_MEANING | VARCHAR2 | (80) | ||
CARD_ISSUER_FILE_SEQ_NO | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_INSTRUCTION_ID
, INSTRUCTION_CREATED_DATE
, PAYMENT_INSTRUCTION_STATUS
, INSTRUCTION_STATUS_MEANING
, PROCESSING_TYPE
, PAY_ADMIN_ASSIGNED_REF_CODE
, BANK_ASSIGNED_REF_CODE
, PERIODIC_SEQUENCE_NAME_1
, LAST_USED_NUMBER_1
, PERIODIC_SEQUENCE_NAME_2
, LAST_USED_NUMBER_2
, PERIODIC_SEQUENCE_NAME_3
, LAST_USED_NUMBER_3
, BANK_INSTRUCTION1_CODE
, BANK_INSTRUCTION1_MEANING
, BANK_INSTRUCTION1_FORMAT_VALUE
, BANK_INSTRUCTION2_CODE
, BANK_INSTRUCTION2_MEANING
, BANK_INSTRUCTION2_FORMAT_VALUE
, BANK_INSTRUCTION_DETAILS
, PAYMENT_TEXT_MESSAGE1
, PAYMENT_TEXT_MESSAGE2
, DECLARATION_OPTION
, BEP_ACCOUNT_NAME
, BEP_ACCOUNT_ID
, PAYSYS_ACCT_ATTR_CAT
, COMMENTS
, PI_ATTR_CAT
, PAYMENT_PROFILE_ID
, SYSTEM_PROFILE_CODE
, PAYMENT_PROFILE_NAME
, LOGICAL_GROUPING_MODE
, BATCH_BOOKING_FLAG
, PAYMENT_PROFILE_ATTR_CAT
, PAYMENT_FORMAT_CODE
, PAYMENT_FORMAT_NAME
, PAYMENT_FORMAT_ATTR_CAT
, PAYER_INSTRUMENT_COUNT
, PAYMENT_COUNT
, PAYMENT_DATE
, PAYMENT_CURRENCY_CODE
, PAYMENT_SERVICE_REQUEST_ID
, ORG_ID
, ORG_TYPE
, ORG_TYPE_MEANING
, ORG_NAME
, PAYMENT_REASON_CODE
, PAY_REASON_MEANING
, PAY_REASON_FORMAT_VALUE
, PAYMENT_REASON_COMMENTS
, GROUP_BY_PAYMENT_DATE
, GROUP_BY_PAYMENT_CURRENCY
, GROUP_BY_PAY_SERVICE_REQUEST
, GROUP_BY_LEGAL_ENTITY
, GROUP_BY_ORGANIZATION
, GROUP_BY_PAYMENT_REASON
, LEGAL_ENTITY_ID
, GROUP_BY_INTERNAL_BANK_ACCOUNT
, GROUP_BY_PAYMENT_FUNCTION
, GROUP_BY_RFC
, GROUP_BY_PAYMENT_METHOD
, INTERNAL_BANK_ACCOUNT_ID
, PAYMENT_FUNCTION
, PAYMENT_FUNCTION_MEANING
, RFC_IDENTIFIER
, PAYMENT_METHOD_CODE
, PROCESS_TYPE
, TOTAL_PMT_AMOUNT
, MOAC_DATA_BLOCKED_FLAG
, PAYMENT_DOCUMENT_NAME
, PAPER_STOCK_TYPE
, PAPER_STOCK_TYPE_MEANING
, CARD_ISSUER_FILE_SEQ_NO
FROM APPS.IBY_EXT_FD_INS_1_0_V;
|
|
|