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

TABLE: IBY.IBY_GEN_DOCS_PAYABLE

Object Details
Object Name: IBY_GEN_DOCS_PAYABLE
Object Type: TABLE
Owner: IBY
FND Design Data: TableIBY.IBY_GEN_DOCS_PAYABLE
Subobject Name:
Status: VALID


IBY_GEN_DOCS_PAYABLE serves as a template for source product tables or views from which Oracle Payables can import documents payable.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
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 Source product Identifier
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)
Calling application's fifth unique document payable identifier
CALLING_APP_DOC_REF_NUMBER VARCHAR2 (100) Yes Reference number entered by user of the source product. Need not be unique
CALL_APP_PAY_SERVICE_REQ_CODE VARCHAR2 (255) Yes Source product''s payment process request identifier. Since the source product''s Identifiers may be alphanumeric, even numeric document Identifiers are stored as VARCHAR2.
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_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_METHOD_CODE VARCHAR2 (30) Yes Payment method Identifier
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 (1) Yes Y or N flag indicating whether this document payable corresponds to one payment.
PAYEE_PARTY_ID NUMBER (15) Yes TCA party Identifier
PARTY_SITE_ID NUMBER (15) Yes Payee party site Identifier
SUPPLIER_SITE_ID NUMBER (15) Yes Supplier site Identifier
BENEFICIARY_PARTY NUMBER (15)
Beneficiary party, if payment is made through a third party
LEGAL_ENTITY_ID NUMBER (15) Yes Legal entity Identifier
ORG_ID NUMBER (15) Yes Organization Identifier
ORG_TYPE VARCHAR2 (30)
Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity.
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
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
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 made
PAYMENT_PROFILE_ID NUMBER (15)
Payment process profile Identifier
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 based 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
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
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_UNIQUE_REF1
,      CALLING_APP_DOC_UNIQUE_REF2
,      CALLING_APP_DOC_UNIQUE_REF3
,      CALLING_APP_DOC_UNIQUE_REF4
,      CALLING_APP_DOC_UNIQUE_REF5
,      CALLING_APP_DOC_REF_NUMBER
,      CALL_APP_PAY_SERVICE_REQ_CODE
,      PAYMENT_FUNCTION
,      PAYMENT_DATE
,      DOCUMENT_DATE
,      DOCUMENT_TYPE
,      DOCUMENT_CURRENCY_CODE
,      DOCUMENT_AMOUNT
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_AMOUNT
,      PAYMENT_METHOD_CODE
,      EXCLUSIVE_PAYMENT_FLAG
,      PAYEE_PARTY_ID
,      PARTY_SITE_ID
,      SUPPLIER_SITE_ID
,      BENEFICIARY_PARTY
,      LEGAL_ENTITY_ID
,      ORG_ID
,      ORG_TYPE
,      ALLOW_REMOVING_DOCUMENT_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      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
,      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
,      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
FROM IBY.IBY_GEN_DOCS_PAYABLE;

Dependencies

[top of page]

IBY.IBY_GEN_DOCS_PAYABLE does not reference any database object

IBY.IBY_GEN_DOCS_PAYABLE is referenced by following:

SchemaIBY
ViewIBY_GEN_DOCS_PAYABLE#