IBY_GEN_DOCS_PAYABLE
IBY_GEN_DOCS_PAYABLE serves as a template for source product tables or views from which Oracle Payables can import documents payable.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
IBY_GEN_DOCS_PAYABLE_PK |
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 |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAY_PROC_TRXN_TYPE_CODE | VARCHAR2 | 100 | Yes | Type of payment processing transaction or document | |
| CALLING_APP_ID | NUMBER | 18 | 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 | Yes | Source product's second unique document payable Identifier | |
| CALLING_APP_DOC_UNIQUE_REF3 | VARCHAR2 | 100 | Yes | Source product's third unique document payable Identifier | |
| CALLING_APP_DOC_UNIQUE_REF4 | VARCHAR2 | 100 | Yes | Source product's fourth unique document payable Identifier | |
| CALLING_APP_DOC_UNIQUE_REF5 | VARCHAR2 | 100 | Yes | 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 | 18 | Yes | TCA party Identifier | |
| PARTY_SITE_ID | NUMBER | 18 | Yes | Payee party site Identifier | |
| SUPPLIER_SITE_ID | NUMBER | 18 | Yes | Supplier site Identifier | |
| BENEFICIARY_PARTY | NUMBER | 18 | Beneficiary party, if payment is made through a third party | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Legal entity Identifier | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| ORG_TYPE | VARCHAR2 | 30 | Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity. | ||
| INVOICING_ORG_ID | NUMBER | 18 | Invoicing business unit | ||
| INVOICING_ORG_TYPE | VARCHAR2 | 30 | Invoicing organization type | ||
| ALLOW_REMOVING_DOCUMENT_FLAG | VARCHAR2 | 1 | Yes | Yes or No flag indicating whether this document can be removed from a payment or payment process request | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| 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 | 18 | Payment process profile Identifier | ||
| INTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | Internal bank account Identifier | ||
| EXTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | 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 | 18 | 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 | 256 | 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 | 18 | Remit-To address Identifier | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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 | 18 | 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 | 18 | HR Identifier of the address | ||
| PAY_GROUP_CODE | VARCHAR2 | 25 | Groups a category of suppliers or invoices for a payment. For example, employees, merchandise, nonmerchandise, government, domestic, and international. | ||
| INVOICING_LEGAL_ENTITY_ID | NUMBER | 18 | Invoicing legal entity unique identifier. | ||
| DOC_CURRENCY_PAYMENT_AMOUNT | NUMBER | Amount to be paid in document currency | |||
| INV_EXT_PAYEE_ID | NUMBER | 18 | External payee associated with the invoice supplier | ||
| INV_PAYEE_PARTY_ID | NUMBER | 18 | Party identifier of the supplier that sends the invoice. | ||
| INV_PARTY_SITE_ID | NUMBER | 18 | Party site identifier associated with the supplier. | ||
| INV_SUPPLIER_SITE_ID | NUMBER | 18 | Supplier site identifier of the supplier that sends the invoice. | ||
| RELATIONSHIP_ID | NUMBER | 18 | Unique identifier of the relationship between payee and supplier that sends the invoice. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| BALANCING_SEGMENT_VALUE | VARCHAR2 | 25 | BALANCING_SEGMENT_VALUE |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_GEN_DOCS_PAYABLE | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| IBY_GEN_DOCS_PAYABLE | iby_ext_bank_accounts | EXTERNAL_BANK_ACCOUNT_ID |
| IBY_GEN_DOCS_PAYABLE | iby_formats_b | PAYMENT_FORMAT_CODE |
| IBY_GEN_DOCS_PAYABLE | hz_parties | PAYEE_PARTY_ID |
| IBY_GEN_DOCS_PAYABLE | hz_party_sites | PARTY_SITE_ID |
| IBY_GEN_DOCS_PAYABLE | hz_parties | BENEFICIARY_PARTY |
| IBY_GEN_DOCS_PAYABLE | xle_entity_profiles | LEGAL_ENTITY_ID |
| IBY_GEN_DOCS_PAYABLE | iby_acct_pmt_profiles_b | PAYMENT_PROFILE_ID |
| IBY_GEN_DOCS_PAYABLE | ce_bank_accounts | INTERNAL_BANK_ACCOUNT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_GEN_DOCS_PAYABLE_U1 | Unique | Default | 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 |