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_DOCS_PAYABLE_ALL

Object Details

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

IBY_DOCS_PAYABLE_ALL stores Oracle Payments' representation of source products' documents payable. A document payable is a supplier invoice or similar document that needs to be paid. This table contains the identifier for the source product's document payable. In addition, this table contains whatever document information is necessary for payment processing.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_DOCS_PAYABLE_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOCUMENT_PAYABLE_ID
IBY_DOCS_PAYABLE_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_DATE
IBY_DOCS_PAYABLE_ALL_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_FORMAT_CODE
IBY_DOCS_PAYABLE_ALL_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERNAL_BANK_ACCOUNT_ID
IBY_DOCS_PAYABLE_ALL_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_STATUS
IBY_DOCS_PAYABLE_ALL_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CALLING_APP_ID CALLING_APP_DOC_UNIQUE_REF1 CALLING_APP_DOC_UNIQUE_REF2 CALLING_APP_DOC_UNIQUE_REF3 CALLING_APP_DOC_UNIQUE_REF4 CALLING_APP_DOC_UNIQUE_REF5
IBY_DOCS_PAYABLE_ALL_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORMATTING_PAYMENT_ID
IBY_DOCS_PAYABLE_ALL_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REJECTED_DOCS_GROUP_ID
IBY_DOCS_PAYABLE_ALL_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPLETED_PMTS_GROUP_ID
IBY_DOCS_PAYABLE_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SERVICE_REQUEST_ID
IBY_DOCS_PAYABLE_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXTERNAL_BANK_ACCOUNT_ID
IBY_DOCS_PAYABLE_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_METHOD_CODE
IBY_DOCS_PAYABLE_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_PROFILE_ID
IBY_DOCS_PAYABLE_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_ID
IBY_DOCS_PAYABLE_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXT_PAYEE_ID
IBY_DOCS_PAYABLE_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_REASON_CODE
IBY_DOCS_PAYABLE_ALL_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_CHANNEL_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
PAY_PROC_TRXN_TYPE_CODE	VARCHAR2	(100)	Yes	Type of payment processing transaction or document
CALLING_APP_ID	NUMBER	(15)	Yes	Calling product Identifier
CALLING_APP_DOC_REF_NUMBER	VARCHAR2	(100)	Yes	Reference number entered by user of the source product. Need not be unique
DOCUMENT_PAYABLE_ID	NUMBER	(15)	Yes	Oracle Payments' unique internal document payable Identifier
PAYMENT_FUNCTION	VARCHAR2	(30)	Yes	Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
PAYMENT_DATE	DATE		Yes	Payment date
DOCUMENT_DATE	DATE		Yes	Date of document
DOCUMENT_TYPE	VARCHAR2	(30)	Yes	Type of document payable. Values from the IBY_DOCUMENT_TYPES lookup include INVOICE.
DOCUMENT_STATUS	VARCHAR2	(30)	Yes	Document status. Values from the lookup IBY_DOCS_PAYABLE_STATUSES include PAYMENT CREATED.
DOCUMENT_CURRENCY_CODE	VARCHAR2	(10)	Yes	Document currency code
DOCUMENT_AMOUNT	NUMBER		Yes	Total amount in document currency
PAYMENT_CURRENCY_CODE	VARCHAR2	(10)	Yes	Payment currency code
PAYMENT_AMOUNT	NUMBER		Yes	Amount to be paid in payment currency
PAYMENT_SERVICE_REQUEST_ID	NUMBER	(15)	Yes	Identifier of the payment process request in which this document was submitted
PAYMENT_METHOD_CODE	VARCHAR2	(30)	Yes	Payment method Identifier
EXCLUSIVE_PAYMENT_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether this document payable should not be grouped with any other documents payable.
STRAIGHT_THROUGH_FLAG	VARCHAR2	(1)	Yes	When processing type Printed and if automatically print after formatting check box is selected, the flag is set to Y, otherwise N. Similarly, when processing type is electronic and payment completion point is selected as when payment instruction is transmitted, the flag is set to Y, otherwise, N.
EXT_PAYEE_ID	NUMBER	(15)	Yes	External payee Identifier
PAYEE_PARTY_ID	NUMBER	(15)	Yes	TCA party Identifier
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Legal entity Identifier
ORG_ID	NUMBER	(15)	Yes	Unique internal identifier of the Operating Unit. Validated against HR_OPERATING_UNITS.ORGANIZATION_ID.
ALLOW_REMOVING_DOCUMENT_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether this document can be removed from a payment or payment process request.AP is passing this value to Payments but no specific processing is happening based on this flag.
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.
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.
CALLING_APP_DOC_UNIQUE_REF1	VARCHAR2	(100)	Yes	Source product''s first unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF2	VARCHAR2	(100)		Source product''s second unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF3	VARCHAR2	(100)		Source product''s third unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF4	VARCHAR2	(100)		Source product''s fourth unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF5	VARCHAR2	(100)		Source product''s fifth unique document payable Identifier
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.
PARTY_SITE_ID	NUMBER	(15)		Party Site identifier Party Site Unique identifier from TCA tables. Validated against HZ_PARTY_SITES.PARTY_SITE_ID.
SUPPLIER_SITE_ID	NUMBER	(15)		Supplier site identifier. Validated against PO_VENDOR_SITES_ALL.VENDOR_SITE_ID.
BENEFICIARY_PARTY	NUMBER	(15)		Beneficiary party if payment is made through a third party
ORG_TYPE	VARCHAR2	(30)	Yes	Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity.
ANTICIPATED_VALUE_DATE	DATE			Anticipated value date
PO_NUMBER	VARCHAR2	(255)		Purchase order numbers to which this document is matched. If multiple purchase orders, value is comma delimited
DOCUMENT_DESCRIPTION	VARCHAR2	(255)		Document description
DOCUMENT_CURRENCY_TAX_AMOUNT	NUMBER			Tax amount in document currency
DOCUMENT_CURR_CHARGE_AMOUNT	NUMBER			Charge amount in document currency
AMOUNT_WITHHELD	NUMBER			Amount withheld in payment currency
PAYMENT_CURR_DISCOUNT_TAKEN	NUMBER			Discount taken in payment currency
DISCOUNT_DATE	DATE			Discount date
PAYMENT_DUE_DATE	DATE			Date on which the payment is due
PAYMENT_PROFILE_ID	NUMBER	(15)		Payment process profile Identifier
PAYMENT_ID	NUMBER	(15)		Payment Identifier. This field is populated once this document has been grouped into a payment.
FORMATTING_PAYMENT_ID	NUMBER	(15)		Formatting payment Identifier. This field identifies the payment stub on which this document's details are printed. This field is populated when the document has been grouped into a payment.
INTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)		Internal bank account Identifier
EXTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)		External bank account Identifier
BANK_CHARGE_BEARER	VARCHAR2	(30)		Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
INTEREST_RATE	NUMBER			Interest rate on which this document payable was created if it is an interest invoice
PAYMENT_GROUPING_NUMBER	NUMBER	(15)		This attribute is used to link a set of documents payable. All documents payable that have the same payment grouping number are grouped into a single payment.
PAYMENT_REASON_CODE	VARCHAR2	(30)		Payment reason code
PAYMENT_REASON_COMMENTS	VARCHAR2	(240)		Free text field available for entering a reason for the payment
SETTLEMENT_PRIORITY	VARCHAR2	(30)		Priority with which the financial institution or payment system settles payment for this document. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY.
REMITTANCE_MESSAGE1	VARCHAR2	(150)		Remittance message for use in payment processing
REMITTANCE_MESSAGE2	VARCHAR2	(150)		Remittance message for use in payment processing
REMITTANCE_MESSAGE3	VARCHAR2	(150)		Remittance message for use in payment processing
UNIQUE_REMITTANCE_IDENTIFIER	VARCHAR2	(30)		Unique remittance Identifier provided by the payee
URI_CHECK_DIGIT	VARCHAR2	(2)		Unique remittance Identifier check digit
DELIVERY_CHANNEL_CODE	VARCHAR2	(30)		Delivery channel code
PAYMENT_FORMAT_CODE	VARCHAR2	(30)		Payment format code
DOCUMENT_SEQUENCE_ID	NUMBER			Sequential numbering document sequence Identifier
DOCUMENT_SEQUENCE_VALUE	NUMBER			Sequence number of document payable
DOCUMENT_CATEGORY_CODE	VARCHAR2	(30)		Sequential numbering document category
BANK_ASSIGNED_REF_CODE	VARCHAR2	(30)		Payment system-provided reference code for this document
REMIT_TO_LOCATION_ID	NUMBER	(15)		Remit-To address Identifier
COMPLETED_PMTS_GROUP_ID	NUMBER	(15)		Identifier of a group of payments, which include this document, that were marked complete. The value is from the sequence IBY_COMPLETED_PMTS_GROUP_S.
REJECTED_DOCS_GROUP_ID	NUMBER	(15)		Identifier of a group of documents payable, including this one, which were rejected together. The value is from the sequence IBY_REJECTED_DOCS_S.
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
ADDRESS_SOURCE	VARCHAR2	(30)		Source of the address. Possible values from the lookup IBY_ADDRESS_SOURCE_TYPES include TCA and HR.
EMPLOYEE_ADDRESS_CODE	VARCHAR2	(30)		Type of address. Possible values include HOME and OFFICE.
EMPLOYEE_PERSON_ID	NUMBER	(15)		Employee person Identifier
EMPLOYEE_PAYMENT_FLAG	VARCHAR2	(1)		Y or N flag indicating whether the payment is of the employee payment type
EMPLOYEE_ADDRESS_ID	NUMBER	(15)		HR Identifier of the address
EXT_INV_PAYEE_ID	NUMBER	(22)		This would be same as EXT_PAYEE_ID if there is no third payments agreement for the trading partner on the invoice. If there is a third party payment agreement with any payee for the trading partner, then this is same as the trading partner on the invoice.
INV_PAYEE_PARTY_ID	NUMBER	(22)		This would be same as PAYEE_PARTY_ID if there is no third payments agreement for the trading partner on the invoice. If there is a third party payment agreement with any payee for the trading partner, then this is the same as the trading partner on the invoice.
INV_PARTY_SITE_ID	NUMBER	(22)		This would be same as PARTY_SITE_ID if there is no third payments agreement for the trading partner on the invoice. If there is a third party payment agreement with any payee for the trading partner, then this is the same as the trading partners site id on the invoice.
INV_SUPPLIER_SITE_ID	NUMBER	(22)		This would be same as SUPPLIER_SITE_ID if there is no third payments agreement for the trading partner on the invoice. If there is a third party payment agreement with any payee for the trading partner, then this is same as the trading partners supplier site id on the invoice.
INV_BENEFICIARY_PARTY	NUMBER	(22)		This field always displays the same value as BENEFICIARY_PARTY.
RELATIONSHIP_ID	NUMBER	(22)		Identifies the relation ship between payee and original trading partner. key from IBY_EXT_PAYEE_RELATIONSHIPS.
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(240)		Global Descriptive Flexfield structure defining column.
GLOBAL_ATTRIBUTE1	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE2	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE3	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE4	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE5	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE6	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE7	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE8	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE9	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE10	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE11	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE12	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE13	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE14	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE15	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE16	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE17	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE18	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE19	VARCHAR2	(240)		Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE20	VARCHAR2	(240)		Global Descriptive Flexfield segment.
AFFECTS_REJECTION_LEVEL	VARCHAR2	(1)

Query Text

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


SELECT PAY_PROC_TRXN_TYPE_CODE
,      CALLING_APP_ID
,      CALLING_APP_DOC_REF_NUMBER
,      DOCUMENT_PAYABLE_ID
,      PAYMENT_FUNCTION
,      PAYMENT_DATE
,      DOCUMENT_DATE
,      DOCUMENT_TYPE
,      DOCUMENT_STATUS
,      DOCUMENT_CURRENCY_CODE
,      DOCUMENT_AMOUNT
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_AMOUNT
,      PAYMENT_SERVICE_REQUEST_ID
,      PAYMENT_METHOD_CODE
,      EXCLUSIVE_PAYMENT_FLAG
,      STRAIGHT_THROUGH_FLAG
,      EXT_PAYEE_ID
,      PAYEE_PARTY_ID
,      LEGAL_ENTITY_ID
,      ORG_ID
,      ALLOW_REMOVING_DOCUMENT_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      CALLING_APP_DOC_UNIQUE_REF1
,      CALLING_APP_DOC_UNIQUE_REF2
,      CALLING_APP_DOC_UNIQUE_REF3
,      CALLING_APP_DOC_UNIQUE_REF4
,      CALLING_APP_DOC_UNIQUE_REF5
,      LAST_UPDATE_LOGIN
,      PARTY_SITE_ID
,      SUPPLIER_SITE_ID
,      BENEFICIARY_PARTY
,      ORG_TYPE
,      ANTICIPATED_VALUE_DATE
,      PO_NUMBER
,      DOCUMENT_DESCRIPTION
,      DOCUMENT_CURRENCY_TAX_AMOUNT
,      DOCUMENT_CURR_CHARGE_AMOUNT
,      AMOUNT_WITHHELD
,      PAYMENT_CURR_DISCOUNT_TAKEN
,      DISCOUNT_DATE
,      PAYMENT_DUE_DATE
,      PAYMENT_PROFILE_ID
,      PAYMENT_ID
,      FORMATTING_PAYMENT_ID
,      INTERNAL_BANK_ACCOUNT_ID
,      EXTERNAL_BANK_ACCOUNT_ID
,      BANK_CHARGE_BEARER
,      INTEREST_RATE
,      PAYMENT_GROUPING_NUMBER
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_COMMENTS
,      SETTLEMENT_PRIORITY
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      UNIQUE_REMITTANCE_IDENTIFIER
,      URI_CHECK_DIGIT
,      DELIVERY_CHANNEL_CODE
,      PAYMENT_FORMAT_CODE
,      DOCUMENT_SEQUENCE_ID
,      DOCUMENT_SEQUENCE_VALUE
,      DOCUMENT_CATEGORY_CODE
,      BANK_ASSIGNED_REF_CODE
,      REMIT_TO_LOCATION_ID
,      COMPLETED_PMTS_GROUP_ID
,      REJECTED_DOCS_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ADDRESS_SOURCE
,      EMPLOYEE_ADDRESS_CODE
,      EMPLOYEE_PERSON_ID
,      EMPLOYEE_PAYMENT_FLAG
,      EMPLOYEE_ADDRESS_ID
,      EXT_INV_PAYEE_ID
,      INV_PAYEE_PARTY_ID
,      INV_PARTY_SITE_ID
,      INV_SUPPLIER_SITE_ID
,      INV_BENEFICIARY_PARTY
,      RELATIONSHIP_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      AFFECTS_REJECTION_LEVEL
FROM IBY.IBY_DOCS_PAYABLE_ALL;

Dependencies

[top of page]

IBY.IBY_DOCS_PAYABLE_ALL does not reference any database object

IBY.IBY_DOCS_PAYABLE_ALL is referenced by following:

IBY: IBY_DOCS_PAYABLE_ALL#