eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IBY.IBY_PAY_INSTRUCTIONS_ALL

Object Details

Object Name:	IBY_PAY_INSTRUCTIONS_ALL
Object Type:	TABLE
Owner:	IBY
FND Design Data:	IBY.IBY_PAY_INSTRUCTIONS_ALL
Subobject Name:
Status:	VALID

IBY_PAY_INSTRUCTIONS_ALL stores information on payment instructions. A payment instruction is a set of one or more payments submitted together to a payment system. This table corresponds to the Payment Instructions tab of the Funds Disbursement Process Home.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_PAY_INSTRUCTIONS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_INSTRUCTION_ID
IBY_PAY_INSTRUCTIONS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_PROFILE_ID
IBY_PAY_INSTRUCTIONS_ALL_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
IBY_PAY_INSTRUCTIONS_ALL_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_STATUS PAYMENTS_COMPLETE_CODE
IBY_PAY_INSTRUCTIONS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_DATE
IBY_PAY_INSTRUCTIONS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SERVICE_REQUEST_ID
IBY_PAY_INSTRUCTIONS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_REASON_CODE
IBY_PAY_INSTRUCTIONS_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERNAL_BANK_ACCOUNT_ID
IBY_PAY_INSTRUCTIONS_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_INSTRUCTION_STATUS
IBY_PAY_INSTRUCTIONS_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BANK_ASSIGNED_REF_CODE
IBY_PAY_INSTRUCTIONS_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAY_ADMIN_ASSIGNED_REF_CODE
IBY_PAY_INSTRUCTIONS_ALL_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
IBY_PAY_INSTRUCTIONS_ALL_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_INSTRUCTION_ID	NUMBER	(15)	Yes	Unique internal Identifier for this record. Generated using a database sequence.
PAYMENT_PROFILE_ID	NUMBER	(15)	Yes	Payment process profile Identifier
PROCESS_TYPE	VARCHAR2	(30)	Yes	Specifies the process by which payments are built into payment instructions. Values from the lookup IBY_PROCESS_TYPES include STANDARD, IMMEDIATE, and MANUAL.
PAYMENT_INSTRUCTION_STATUS	VARCHAR2	(30)	Yes	Payment instruction status. Values from the lookup IBY_PAY_INSTRUCTION_STATUSES include CREATED, FORMATTED, and TRANSMITTED.
PAYMENTS_COMPLETE_CODE	VARCHAR2	(30)	Yes	Code indicating whether payments in the payment instruction have been marked as complete. Values from the lookup IBY_PAYMENTS_COMPLETE include YES, NO, and PARTIAL.
GENERATE_SEP_REMIT_ADVICE_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether a separate remittance advice needs to be created for a payment instruction. If the flag is set to Y, then at least one payment within the payment instruction requires a separate remittance advice.
REMITTANCE_ADVICE_CREATED_FLAG	VARCHAR2	(1)	Yes	Indicates whether any separate remittance advice documents were created for a payment instruction. By default this flag is set to N.
REGULATORY_REPORT_CREATED_FLAG	VARCHAR2	(1)	Yes	Indicates whether a regulatory report, for example, for central bank reporting, has been created for a payment instruction
BILL_PAYABLE_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether a payment instruction consists of bills payable
LEGAL_ENTITY_ID	NUMBER	(15)		Legal entity Identifier of the payment instruction. This column is populated only when first party legal entity is specified as a grouping rule for payment instruction creation.
PAYMENT_COUNT	NUMBER	(15)	Yes	Number of payments comprising this instruction
POSITIVE_PAY_FILE_CREATED_FLAG	VARCHAR2	(1)	Yes	Indicates whether a positive pay file has been created for a payment instruction
PRINT_INSTRUCTION_IMMED_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether the payment instruction is printed immediately after the payment instruction is created
TRANSMIT_INSTR_IMMED_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether the payment instruction is transmitted immediately after the payment instruction is created
CREATED_BY	NUMBER	(15)	Yes	Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table
OBJECT_VERSION_NUMBER	NUMBER		Yes	Used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. This number is incremented for every update to the row through the application.
INTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)		Internal bank account Identifier of the payment instruction. This column is populated only when internal bank account is specified as a grouping rule for payment instruction creation. This column is always populated for printed payment instructions, as they are required to be created for a single internal bank account.
PAY_ADMIN_ASSIGNED_REF_CODE	VARCHAR2	(255)		Administrator assigned reference code
TRANSMISSION_DATE	DATE			Date that the payment instruction is sent to the bank
ACKNOWLEDGEMENT_DATE	DATE			Date on which the acknowledgement is received
COMMENTS	VARCHAR2	(240)		Comments entered while submitting following concurrent requests: -> ""Create Electronic Payment Instructions"" -> ""Create Printed Payment Instructions"""
BANK_ASSIGNED_REF_CODE	VARCHAR2	(30)		Payment system-provided reference code for this payment instruction
ORG_ID	NUMBER	(15)		Organization Identifier of the payment instruction. This column is populated only when first party organization is specified as a grouping rule for payment instruction creation.
ORG_TYPE	VARCHAR2	(30)		Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity.
PAYMENT_DATE	DATE			Payment date of the payment instruction. This column is populated only when payment date is specified as a grouping rule for payment instruction creation.
PAYMENT_CURRENCY_CODE	VARCHAR2	(10)		Currency of the payment instruction. This column is populated only when payment currency is specified as a grouping rule for payment instruction creation. This column is always populated for printed payment instructions, as they are required to be for a single payment currency.
PAYMENT_SERVICE_REQUEST_ID	NUMBER	(15)		Identifier of the payment process request which had its payments grouped into the payment instruction. This column is populated when payment process request is specified as a grouping rule for payment instruction creation.
PAYMENT_FUNCTION	VARCHAR2	(30)		Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
PAYMENT_REASON_CODE	VARCHAR2	(30)		Payment reason code. This column is populated when Payment Reason is specified as a grouping rule for payment instruction creation.
RFC_IDENTIFIER	VARCHAR2	(30)		Identifier of the regional finance center at the bank branch level pertaining to the payments in the instruction. This column is populated when RFC is specified as a grouping rule for payment instruction creation.
PAYMENT_REASON_COMMENTS	VARCHAR2	(240)		Free text describing a reason for the payments in the instruction. This column is populated when Payment Reason is specified as a grouping rule for payment instruction creation.
PAYMENT_DOCUMENT_ID	NUMBER	(15)		Payment document that was passed to the payment instruction creation program, if it is different from the default in the payment process profile
PRINTER_NAME	VARCHAR2	(255)		Name of the printer to be used for printed checks
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive Flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
REFERENCE_FORMAT_CODE	VARCHAR2	(30)		Reference format code
REQUEST_ID	NUMBER	(15)		Concurrent request identifier associated with the current process, used to control updates to processes that are currently active
PAYMENT_METHOD_CODE	VARCHAR2	(50)		Payment method identifier
CARD_ISSUER_FILE_SEQ_NO	NUMBER			Card Issuer file sequence number

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PAYMENT_INSTRUCTION_ID
,      PAYMENT_PROFILE_ID
,      PROCESS_TYPE
,      PAYMENT_INSTRUCTION_STATUS
,      PAYMENTS_COMPLETE_CODE
,      GENERATE_SEP_REMIT_ADVICE_FLAG
,      REMITTANCE_ADVICE_CREATED_FLAG
,      REGULATORY_REPORT_CREATED_FLAG
,      BILL_PAYABLE_FLAG
,      LEGAL_ENTITY_ID
,      PAYMENT_COUNT
,      POSITIVE_PAY_FILE_CREATED_FLAG
,      PRINT_INSTRUCTION_IMMED_FLAG
,      TRANSMIT_INSTR_IMMED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      INTERNAL_BANK_ACCOUNT_ID
,      PAY_ADMIN_ASSIGNED_REF_CODE
,      TRANSMISSION_DATE
,      ACKNOWLEDGEMENT_DATE
,      COMMENTS
,      BANK_ASSIGNED_REF_CODE
,      ORG_ID
,      ORG_TYPE
,      PAYMENT_DATE
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_SERVICE_REQUEST_ID
,      PAYMENT_FUNCTION
,      PAYMENT_REASON_CODE
,      RFC_IDENTIFIER
,      PAYMENT_REASON_COMMENTS
,      PAYMENT_DOCUMENT_ID
,      PRINTER_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REFERENCE_FORMAT_CODE
,      REQUEST_ID
,      PAYMENT_METHOD_CODE
,      CARD_ISSUER_FILE_SEQ_NO
FROM IBY.IBY_PAY_INSTRUCTIONS_ALL;

Dependencies

[top of page]

IBY.IBY_PAY_INSTRUCTIONS_ALL does not reference any database object

IBY.IBY_PAY_INSTRUCTIONS_ALL is referenced by following:

IBY: IBY_PAY_INSTRUCTIONS_ALL#