AP_PAYMENT_REQUESTS_INT
This table contains the invoice data interfaced for One Time Payment.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
AP_PAYMENT_REQUESTS_INT_PK |
PAYMENT_REQUEST_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAYMENT_REQUEST_INTERFACE_ID | NUMBER | 18 | Yes | Interface identifier that uniquely identifies a payment request line record. | |
| INVOICE_ID | NUMBER | 18 | Yes | Invoice identifier that uniquely identifies payment request and its lines. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: request identifier of the interface load job that created the row. | |
| INVOICE_NUM | VARCHAR2 | 50 | Unique number for payment request. | ||
| INVOICE_DATE | DATE | Date on which payment request is submitted. | |||
| AMOUNT | NUMBER | Yes | The invoice line amount to import for payment. | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Currency of the payment request. | ||
| ACCTS_PAY_CODE_CONCATENATED | VARCHAR2 | 250 | Account to which liability is recorded in accrual basis of accounting. | ||
| SOURCE | VARCHAR2 | 80 | Yes | Name of the external system from which a payment request is imported. | |
| PARTY_NAME | VARCHAR2 | 360 | Yes | Name of the party to whom the payment is to be made. | |
| PARTY_TYPE | VARCHAR2 | 30 | Type of party making the payment. | ||
| ADDRESS_LINE1 | VARCHAR2 | 240 | First line of the party address. | ||
| ADDRESS_LINE2 | VARCHAR2 | 240 | Second line of the party address. | ||
| ADDRESS_LINE3 | VARCHAR2 | 240 | Third line of the party address. | ||
| ADDRESS_LINE4 | VARCHAR2 | 240 | Fourth line of the party address. | ||
| ADDRESS_LINES_PHONETIC | VARCHAR2 | 560 | Phonetic or Kana representation of the Kanji address lines used in Japan. | ||
| ADDR_ELEMENT_ATTRIBUTE1 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
| ADDR_ELEMENT_ATTRIBUTE2 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
| ADDR_ELEMENT_ATTRIBUTE3 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
| ADDR_ELEMENT_ATTRIBUTE4 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
| ADDR_ELEMENT_ATTRIBUTE5 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
| BUILDING | VARCHAR2 | 240 | Specific building name or number at a given address. | ||
| FLOOR_NUMBER | VARCHAR2 | 40 | Specific floor number at a given address or in a particular building when building number is provided. | ||
| CITY | VARCHAR2 | 60 | City of party to whom the payment is to be made. | ||
| STATE | VARCHAR2 | 60 | State of party to whom the payment is to be made. | ||
| PROVINCE | VARCHAR2 | 60 | Province of party to whom the payment is to be made. | ||
| COUNTY | VARCHAR2 | 60 | County of party to whom the payment is to be made. | ||
| POSTAL_CODE | VARCHAR2 | 60 | Postal code of party to whom the payment is to be made. | ||
| POSTAL_PLUS4_CODE | VARCHAR2 | 10 | Four digit extension to postal code. | ||
| COUNTRY | VARCHAR2 | 60 | Location of the address by country. | ||
| ADDRESSEE | VARCHAR2 | 360 | Person or recipient located at the address. | ||
| GLOBAL_LOCATION_NUMBER | VARCHAR2 | 40 | Number that uniquely identifies each global location in a trading partner enterprise. | ||
| PARTY_SITE_LANGUAGE | VARCHAR2 | 4 | Operating language of the party site address. | ||
| PHONE_COUNTRY_CODE | VARCHAR2 | 10 | Country code for the telephone number. | ||
| PHONE_AREA_CODE | VARCHAR2 | 10 | Area code for address phone number. | ||
| PHONE | VARCHAR2 | 40 | Phone number of the party receiving payment. | ||
| PHONE_EXTENSION | VARCHAR2 | 20 | Phone extension of the party receiving payment. | ||
| REMIT_ADVICE_EMAIL | VARCHAR2 | 255 | E-mail address of the payee to whom the payment is to be made. | ||
| PARTY_ORIG_SYSTEM | VARCHAR2 | 30 | Party identifier from the original system or external source. | ||
| PARTY_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Party reference from the original system or external source. | ||
| THIRD_PARTY_REGISTRATION_NUM | VARCHAR2 | 60 | Unique identifier assigned to a party or party site by a tax authority. | ||
| BANK_COUNTRY_CODE | VARCHAR2 | 2 | Country code of the bank account of payee. | ||
| BANK_NAME | VARCHAR2 | 360 | Name of the payee bank to whom the payment is to be made. | ||
| BANK_NUMBER | VARCHAR2 | 30 | Number of the payee bank to whom the payment is to be made. | ||
| BANK_ACCOUNT_NUM | VARCHAR2 | 100 | Bank account number of the payee. | ||
| BANK_ACCOUNT_NAME | VARCHAR2 | 80 | Name of the payee bank account. | ||
| BANK_BRANCH_NAME | VARCHAR2 | 360 | Name of the branch of the payee bank. | ||
| BRANCH_NUMBER | VARCHAR2 | 30 | Number of the bank branch. This is known as routing transit number in US and Canada. | ||
| EFT_SWIFT_CODE | VARCHAR2 | 30 | SWIFT or Bank Identification Code (BIC) of the bank branch. | ||
| BANK_ACCOUNT_CURRENCY_CODE | VARCHAR2 | 15 | Currency code of the bank account of payee. | ||
| IBAN | VARCHAR2 | 50 | International Bank Account Number of payee. | ||
| BANK_ACCOUNT_TYPE | VARCHAR2 | 25 | Type of bank account such as SAVINGS and CHECKING. | ||
| SECONDARY_ACCOUNT_REFERENCE | VARCHAR2 | 30 | Account number reference such as Building Society Roll Number. | ||
| CHECK_DIGITS | VARCHAR2 | 30 | One or more digits used to validate a bank account number. | ||
| BANK_ACCOUNT_DESCRIPTION | VARCHAR2 | 240 | Description of the payee bank account. | ||
| BANK_ACCOUNT_NAME_ALT | VARCHAR2 | 320 | Alternate account name of the bank account of payee. | ||
| OPERATING_UNIT | VARCHAR2 | 240 | Sold-to business unit name for which the transaction is being created. | ||
| LEGAL_ENTITY_NAME | VARCHAR2 | 240 | The name of the legal entity that belongs to your own corporate structure (enterprise). | ||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Code identifying the payment method. | ||
| TERMS_NAME | VARCHAR2 | 50 | Name of the payment terms used to create installments and to calculate due dates, discount dates, and discount amounts for each invoice. | ||
| INVOICE_DESCRIPTION | VARCHAR2 | 240 | Information describing the invoice created for payment. | ||
| GROUP_ID | VARCHAR2 | 80 | Name or number assigned to the import set containing payment requests. | ||
| PAY_GROUP_LOOKUP_CODE | VARCHAR2 | 25 | Used to group payment requests into a single pay run. | ||
| DOC_CATEGORY_CODE | VARCHAR2 | 30 | Value used to classify documents for document sequencing purposes. | ||
| VOUCHER_NUM | VARCHAR2 | 50 | Number assigned to a document used for internal purposes. | ||
| REQUESTER_FIRST_NAME | VARCHAR2 | 150 | First name of the person requesting the items. | ||
| REQUESTER_LAST_NAME | VARCHAR2 | 150 | Last name of the person requesting the items. | ||
| PAYMENT_PRIORITY | NUMBER | 2 | Number representing payment priority of a scheduled payment. The valid value is any number between 1 and 99. | ||
| PAYMENT_REASON_COMMENTS | VARCHAR2 | 240 | Comments indicating the reason for creating the payment. | ||
| LINE_NUMBER | NUMBER | 18 | The number of the invoice line. | ||
| DIST_CODE_CONCATENATED | VARCHAR2 | 250 | Account combination used for creating invoice distribution. | ||
| LINE_DESCRIPTION | VARCHAR2 | 240 | Line description. | ||
| LINE_REQUESTER_FIRST_NAME | VARCHAR2 | 150 | First name of the person requesting the items. | ||
| LINE_REQUESTER_LAST_NAME | VARCHAR2 | 150 | Last name of the person requesting the items. | ||
| DISTRIBUTION_SET_NAME | VARCHAR2 | 50 | Used to create invoice distributions automatically when you do not want to enter invoice distribution information manually. | ||
| LINE_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Type of line for payment request to be imported. | ||
| STATUS | VARCHAR2 | 25 | Status of payment request imported for payment. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| 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 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| REFERENCE_KEY1 | VARCHAR2 | 150 | Captures invoice reference information from non-Oracle application. Free text field. Not validated. | ||
| REFERENCE_KEY2 | VARCHAR2 | 150 | Captures invoice reference information from non-Oracle application. Free text field. Not validated. | ||
| REFERENCE_KEY3 | VARCHAR2 | 150 | Captures invoice reference information from non-Oracle application. Free text field. Not validated. | ||
| REFERENCE_KEY4 | VARCHAR2 | 150 | Captures invoice reference information from non-Oracle application. Free text field. Not validated. | ||
| REFERENCE_KEY5 | VARCHAR2 | 150 | Captures invoice reference information from non-Oracle application. Free text field. Not validated. | ||
| PARTY_ID | NUMBER | 18 | Oracle internal use only. Unique party identifier. | ||
| PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. Unique party site identifier. | ||
| EXTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | External bank account identifier. Unique External bank account identifier. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| LINE_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield for Invoice line. | ||
| LINE_ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield for Invoice line. | |||
| LINE_ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield for Invoice line. | |||
| LINE_ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield for Invoice line. | |||
| LINE_ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield for Invoice line. | |||
| LINE_ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield for Invoice line. | |||
| LINE_ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield for Invoice line. | |||
| LINE_ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield for Invoice line. | |||
| LINE_ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield for Invoice line. | |||
| LINE_ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield for Invoice line. | |||
| LINE_ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield for Invoice line. | |||
| NEW_INVOICE_ID | NUMBER | 18 | Unique invoice identifier. It is the unique value of the successfully imported invoice. | ||
| 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. | |
| LOCATION_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Original system reference for the party site address. | ||
| BATCH_ID | NUMBER | 18 | Unique identifier for a customer import batch process. | ||
| FILE_RECORD_NUM | NUMBER | 10 | This column is used by the import wizard to relate a record in the interface table to the file row. | ||
| UPLOAD_STATUS | VARCHAR2 | 30 | Upload status of this record. | ||
| UPLOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: Indicates the request ID of the parent job that processes this record. | ||
| ACCOUNT_SUFFIX | VARCHAR2 | 30 | One to three digit number at the end of the account number that determines the kind of account. | ||
| PAYMENT_REASON_CODE | VARCHAR2 | 30 | A unique identification that provides additional payment details to the payment system or bank. The Payment Code Type must be Payment Reason. Values are created and visible in the Manage Payment Codes user interface. | ||
| ATTACHMENT_URL | VARCHAR2 | 4000 | Invoice attachments of type URL. | ||
| REMITTANCE_MESSAGE1 | VARCHAR2 | 150 | Remittance message text used in payment processing. Free text field. Not validated. | ||
| REMITTANCE_MESSAGE2 | VARCHAR2 | 150 | Remittance message text used in payment processing. Free text field. Not validated. | ||
| REMITTANCE_MESSAGE3 | VARCHAR2 | 150 | Remittance message text used in payment processing. Free text field. Not validated. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_PAYMENT_REQUESTS_INT_N1 | Non Unique | Default | INVOICE_ID, LOAD_REQUEST_ID |
| AP_PAYMENT_REQUESTS_INT_N2 | Non Unique | Default | REQUEST_ID, STATUS |
| AP_PAYMENT_REQUESTS_INT_N3 | Non Unique | Default | SOURCE, GROUP_ID |
| AP_PAYMENT_REQUESTS_INT_N4 | Non Unique | Default | BATCH_ID, UPLOAD_STATUS, FILE_RECORD_NUM |
| AP_PAYMENT_REQUESTS_INT_U1 | Unique | Default | PAYMENT_REQUEST_INTERFACE_ID |