[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_AP_CHECKS_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | EC |
| FND Design Data: |  EC.ECE_AP_CHECKS_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
ECE_AP_CHECKS_INTERFACE contains the payment data to support the
outbound Payment Order/Remittance Advice (820/PAYORD/REMADV)
transaction. ECE_AP_CHECKS_INTERFACE contains the payment portion
of the transaction. The remittance advice portion of the transaction
is stored in ECE_AP_INVOICES_INTERFACE.
ECE_AP_CHECKS_INTERFACE is based primarily on data stored in
AP_SELECTED_INVOICE_CHECKS in Oracle Payables.
ECE_AP_CHECKS_INTERFACE includes payer and payee bank data,
payment batch number, payment amount, and check number. In addition,
it includes the data provided in Oracle Payables regarding EDI payment format,
EDI payment method, EDI remittance instruction, EDI remittance method,
and transaction handling code.
CHECKRUN_NAME is the unique primary key generated by Oracle
Payables to refer to a payment batch.
All columns denoted with "Int" or "Internal" represent Oracle
Applications internal values. All columns denoted with "Ext" or
"External" represent the equivalent external values sourced from the
ECE_XREF_DATA table if code conversion is enabled for the column.
VOID_DATE and VOID_FLAG are used for the Oracle Energy vertical
solution and therefore noted as no longer used for the standard solution.
Each row in ECE_AP_CHECKS_INTERFACE is purged after the data is
written to the data file.
TRANSACTION_RECORD_ID is the unique key that links the
ECE_AP_CHECKS_INTERFACE table to its corresponding extension table
ECE_AP_CHECKS_INTERFACE _X.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COMMUNICATION_METHOD | VARCHAR2 | (30) | Communication Method | |
| BK_TP_TEST_FLAG | VARCHAR2 | (1) | Bank Branch Test Indicator | |
| DOCUMENT_ID | VARCHAR2 | (6) | Document ID | |
| DOCUMENT_TYPE | VARCHAR2 | (30) | Document Type | |
| DOCUMENT_PURPOSE_CODE | VARCHAR2 | (2) | Document Purpose Code | |
| DOCUMENT_CODE | VARCHAR2 | (35) | Document Code | |
| BK_TP_TRANSLATOR_CODE | VARCHAR2 | (30) | Bank Branch Trading Partner Translator Code | |
| BK_TP_LOCATION_CODE_EXT | VARCHAR2 | (35) | Bank Branch Trading Partner Location Code | |
| BK_TP_DESCRIPTION | VARCHAR2 | (240) | Bank Branch Trading Partner Description | |
| BK_TP_REFERENCE_EXT1 | VARCHAR2 | (240) | Bank Branch Trading Partner Reference 1 (Ext) | |
| BK_TP_REFERENCE_EXT2 | VARCHAR2 | (240) | Bank Branch Trading Partner Reference 2 (Ext) | |
| TRANSACTION_DATE | DATE | Transaction Date/Time | ||
| RUN_ID | NUMBER | Yes | Transaction Run ID | |
| TPH_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Trading Partner Attribute Category | |
| TPH_ATTRIBUTE1 | VARCHAR2 | (150) | Trading Partner Header Attribute 1 | |
| TPH_ATTRIBUTE2 | VARCHAR2 | (150) | Trading Partner Header Attribute 2 | |
| TPH_ATTRIBUTE3 | VARCHAR2 | (150) | Trading Partner Header Attribute 3 | |
| TPH_ATTRIBUTE4 | VARCHAR2 | (150) | Trading Partner Header Attribute 4 | |
| TPH_ATTRIBUTE5 | VARCHAR2 | (150) | Trading Partner Header Attribute 5 | |
| TPH_ATTRIBUTE6 | VARCHAR2 | (150) | Trading Partner Header Attribute 6 | |
| TPH_ATTRIBUTE7 | VARCHAR2 | (150) | Trading Partner Header Attribute 7 | |
| TPH_ATTRIBUTE8 | VARCHAR2 | (150) | Trading Partner Header Attribute 8 | |
| TPH_ATTRIBUTE9 | VARCHAR2 | (150) | Trading Partner Header Attribute 9 | |
| TPH_ATTRIBUTE10 | VARCHAR2 | (150) | Trading Partner Header Attribute 10 | |
| TPH_ATTRIBUTE11 | VARCHAR2 | (150) | Trading Partner Header Attribute 11 | |
| TPH_ATTRIBUTE12 | VARCHAR2 | (150) | Trading Partner Header Attribute 12 | |
| TPH_ATTRIBUTE13 | VARCHAR2 | (150) | Trading Partner Header Attribute 13 | |
| TPH_ATTRIBUTE14 | VARCHAR2 | (150) | Trading Partner Header Attribute 14 | |
| TPH_ATTRIBUTE15 | VARCHAR2 | (150) | Trading Partner Header Attribute 15 | |
| TPD_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Trading Partner Detail Attribute Category | |
| TPD_ATTRIBUTE1 | VARCHAR2 | (150) | Trading Partner Detail Attribute 1 | |
| TPD_ATTRIBUTE2 | VARCHAR2 | (150) | Trading Partner Detail Attribute 2 | |
| TPD_ATTRIBUTE3 | VARCHAR2 | (150) | Trading Partner Detail Attribute 3 | |
| TPD_ATTRIBUTE4 | VARCHAR2 | (150) | Trading Partner Detail Attribute 4 | |
| TPD_ATTRIBUTE5 | VARCHAR2 | (150) | Trading Partner Detail Attribute 5 | |
| TRANSACTION_HANDLING_CODE | VARCHAR2 | (25) | EDI Transaction Handling Code | |
| TRANSACTION_HANDLING_CODE_EXT1 | VARCHAR2 | (80) | EDI Transaction Handling Code (Ext) | |
| CHECK_AMOUNT | NUMBER | Yes | Check Amount | |
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency Code |
| CURRENCY_CODE_EXT1 | VARCHAR2 | (80) | Currency Code (Ext) | |
| EDI_PAYMENT_METHOD | VARCHAR2 | (25) | EDI Payment Method | |
| EDI_PAYMENT_METHOD_EXT1 | VARCHAR2 | (80) | EDI Payment Method (Ext) | |
| EDI_PAYMENT_FORMAT | VARCHAR2 | (25) | EDI Payment Format for ACH | |
| EDI_PAYMENT_FORMAT_EXT1 | VARCHAR2 | (80) | EDI Payment Format for ACH (Ext) | |
| BANK_BRANCH_TYPE | VARCHAR2 | (25) | Bank Branch Type | |
| BANK_BRANCH_TYPE_EXT1 | VARCHAR2 | (80) | Bank Branch Type (Ext) | |
| BANK_ACCOUNT_TYPE | VARCHAR2 | (25) | Bank Account Type | |
| BANK_ACCOUNT_TYPE_EXT1 | VARCHAR2 | (80) | Bank Account Type (Ext) | |
| BANK_ACCOUNT_NUM | VARCHAR2 | (30) | Bank Account Number | |
| BANK_EDI_ID_NUMBER | VARCHAR2 | (30) | Bank's Trading Partner ID | |
| VENDOR_BANK_BRANCH_TYPE | VARCHAR2 | (25) | Supplier Bank Branch Type | |
| VENDOR_BANK_BRANCH_TYPE_EXT1 | VARCHAR2 | (80) | Supplier Bank Branch Type (Ext) | |
| VENDOR_BANK_ACCOUNT_TYPE | VARCHAR2 | (25) | Supplier Bank Account Type | |
| VENDOR_BANK_ACCOUNT_TYPE_EXT1 | VARCHAR2 | (80) | Supplier Bank Account Type (Ext) | |
| VENDOR_BANK_ACCOUNT_NUM | VARCHAR2 | (30) | Supplier Bank Account Number | |
| PAYMENT_DATE | DATE | Date Funds Available for Transfer | ||
| BANK_NUM | VARCHAR2 | (25) | Bank Transit Routing Number | |
| VENDOR_BANK_NUM | VARCHAR2 | (30) | Supplier Bank Routing Number | |
| EDI_REMITTANCE_METHOD | VARCHAR2 | (25) | EDI Remittance Method | |
| EDI_REMITTANCE_INSTRUCTION | VARCHAR2 | (256) | EDI Remittance Instruction | |
| CHECKRUN_NAME | VARCHAR2 | (50) | Yes | Check Run Batch Name |
| CHECK_VOUCHER_NUM | NUMBER | Voucher Number of Payment | ||
| SELECTED_CHECK_ID | NUMBER | Selected Check ID | ||
| CHECK_NUMBER | NUMBER | Yes | Check Number | |
| CUSTOMER_NUM | VARCHAR2 | (25) | Customer Number Supplier Uses for Your Company | |
| VOID_FLAG | VARCHAR2 | (1) | Void Flag | |
| VOID_DATE | DATE | Void Date | ||
| SEGMENT1 | VARCHAR2 | (30) | Supplier Number Segment 1 | |
| VENDOR_NUMBER_EXT1 | VARCHAR2 | (80) | Supplier Number (Ext) | |
| VENDOR_EDI_ID_NUMBER | VARCHAR2 | (30) | Supplier | |
| SEGMENT2 | VARCHAR2 | (30) | Supplier Key Flexfield Segment 2 | |
| SEGMENT3 | VARCHAR2 | (30) | Supplier Key Flexfield Segment 3 | |
| SEGMENT4 | VARCHAR2 | (30) | Supplier Key Flexfield Segment 4 | |
| SEGMENT5 | VARCHAR2 | (30) | Supplier Key Flexfield Segment 5 | |
| BANK_ENTITY_SITE_CODE | VARCHAR2 | (20) | Bank Branch Entity Site Code | |
| BANK_ENTITY_SITE_CODE_EXT1 | VARCHAR2 | (80) | Bank Branch Entity Site Code (Ext) | |
| BANK_NAME | VARCHAR2 | (60) | Bank Branch Name | |
| BK_ADDRESS_LINE1 | VARCHAR2 | (35) | Bank Branch Address Line 1 | |
| BK_ADDRESS_LINE2 | VARCHAR2 | (35) | Bank Branch Address Line 2 | |
| BK_ADDRESS_LINE3 | VARCHAR2 | (35) | Bank Branch Address Line 3 | |
| BK_ADDRESS_LINE4 | VARCHAR2 | (35) | Bank Branch Address Line 4 | |
| BK_CITY | VARCHAR2 | (25) | Bank Branch City | |
| BK_ZIP | VARCHAR2 | (20) | Bank Branch Zip | |
| BK_COUNTRY | VARCHAR2 | (25) | Bank Branch Country | |
| BK_COUNTRY_EXT1 | VARCHAR2 | (80) | Bank Branch Country (Ext) | |
| BK_STATE | VARCHAR2 | (25) | Bank Branch State | |
| BK_STATE_EXT1 | VARCHAR2 | (80) | Bank Branch State (Ext) | |
| BK_PROVINCE | VARCHAR2 | (25) | Bank Branch Province | |
| BK_PROVINCE_EXT1 | VARCHAR2 | (80) | Bank Branch Province (Ext) | |
| BK_CONTACT_FIRST_NAME | VARCHAR2 | (15) | Bank Contact First Name | |
| BK_CONTACT_MIDDLE_NAME | VARCHAR2 | (15) | Bank Contact Middle Name | |
| BK_CONTACT_LAST_NAME | VARCHAR2 | (20) | Bank Contact Last Name | |
| BK_CONTACT_TITLE | VARCHAR2 | (30) | Bank Contact Title | |
| BK_CONTACT_PREFIX | VARCHAR2 | (5) | Bank Contact Prefix | |
| BK_CONTACT_AREA_CODE | VARCHAR2 | (10) | Bank Contact Area Code | |
| BK_CONTACT_PHONE | VARCHAR2 | (15) | Bank Contact Phone Number | |
| VENDOR_SITE_CODE | VARCHAR2 | (15) | Supplier Site Code | |
| VENDOR_SITE_CODE_EXT1 | VARCHAR2 | (80) | Supplier Site Code (Ext) | |
| VENDOR_NAME | VARCHAR2 | (240) | Supplier Name | |
| ADDRESS_LINE1 | VARCHAR2 | (240) | Supplier Site Address Line 1 | |
| ADDRESS_LINE2 | VARCHAR2 | (240) | Supplier Site Address Line 2 | |
| ADDRESS_LINE3 | VARCHAR2 | (240) | Supplier Site Address Line 3 | |
| ADDRESS_LINE4 | VARCHAR2 | (240) | Supplier Site Address Line 4 | |
| CITY | VARCHAR2 | (25) | Supplier Site City | |
| ZIP | VARCHAR2 | (20) | Supplier Site Zip Code | |
| COUNTRY | VARCHAR2 | (25) | Supplier Site Country | |
| COUNTRY_EXT1 | VARCHAR2 | (80) | Supplier Site Country (Ext) | |
| STATE | VARCHAR2 | (25) | Supplier Site State | |
| STATE_EXT1 | VARCHAR2 | (80) | Supplier Site State (Ext) | |
| PROVINCE | VARCHAR2 | (25) | Supplier Site Province | |
| PROVINCE_EXT1 | VARCHAR2 | (80) | Supplier Site Province (Ext) | |
| TRANSACTION_RECORD_ID | NUMBER | Unique identifier which links the transaction base table to its associated extension table. | ||
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| REQUEST_ID | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
| DOCUMENT_STANDARD | VARCHAR2 | (30) | EDI Document Standard | |
| BK_EFT_SWIFT_CODE | VARCHAR2 | (12) | Bank Branch EFT Swift Code | |
| SBK_BANK_BRANCH_NUMBER | VARCHAR2 | (25) | Supplier Bank Branch Number | |
| SBK_BANK_BRANCH_NAME | VARCHAR2 | (60) | Supplier Bank Branch Name | |
| SBK_ADDRESS_LINE1 | VARCHAR2 | (35) | Supplier Bank Branch Address Line 1 | |
| SBK_ADDRESS_LINE2 | VARCHAR2 | (35) | Supplier Bank Branch Address Line 2 | |
| SBK_ADDRESS_LINE3 | VARCHAR2 | (35) | Supplier Bank Branch Address Line 3 | |
| SBK_CITY | VARCHAR2 | (25) | Supplier Bank Branch City | |
| SBK_STATE | VARCHAR2 | (25) | Supplier Bank Branch State | |
| SBK_ZIP | VARCHAR2 | (20) | Supplier Bank Branch Zip | |
| SBK_PROVINCE | VARCHAR2 | (25) | Supplier Bank Branch Province | |
| SBK_COUNTRY | VARCHAR2 | (25) | Supplier Bank Branch Country | |
| SBK_EFT_SWIFT_CODE | VARCHAR2 | (12) | Supplier Bank Branch Swift Code | |
| ABA_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Bank Account Global Attribute Category | |
| ABA_GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Bank Account Global Attribute 1 | |
| ABA_GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Bank Account Global Attribute 2 | |
| ABA_GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Bank Account Global Attribute 3 | |
| ABA_GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Bank Account Global Attribute 4 | |
| ABA_GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Bank Account Global Attribute 5 | |
| ABA_GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Bank Account Global Attribute 6 | |
| ABA_GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Bank Account Global Attribute 7 | |
| ABA_GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Bank Account Global Attribute 8 | |
| ABA_GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Bank Account Global Attribute 9 | |
| ABA_GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Bank Account Global Attribute 11 | |
| ABA_GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Bank Account Global Attribute 11 | |
| ABA_GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Bank Account Global Attribute 12 | |
| ABA_GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Bank Account Global Attribute 13 | |
| ABA_GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Bank Account Global Attribute 14 | |
| ABA_GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Bank Account Global Attribute 15 | |
| ABA_GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Bank Account Global Attribute 16 | |
| ABA_GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Bank Account Global Attribute 17 | |
| ABA_GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Bank Account Global Attribute 18 | |
| ABA_GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Bank Account Global Attribute 19 | |
| ABA_GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Bank Account Global Attribute 20 | |
| ABAS_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Supplier Bank Account Global Attribute Category | |
| ABAS_GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 1 | |
| ABAS_GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 2 | |
| ABAS_GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 3 | |
| ABAS_GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 4 | |
| ABAS_GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 5 | |
| ABAS_GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 6 | |
| ABAS_GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 7 | |
| ABAS_GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 8 | |
| ABAS_GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 9 | |
| ABAS_GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 10 | |
| ABAS_GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 11 | |
| ABAS_GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 12 | |
| ABAS_GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 13 | |
| ABAS_GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 14 | |
| ABAS_GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 15 | |
| ABAS_GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 16 | |
| ABAS_GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 17 | |
| ABAS_GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 18 | |
| ABAS_GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 19 | |
| ABAS_GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Supplier Bank Account Global Attribute 20 | |
| PVS_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Vendor Site Global Attribute Category | |
| PVS_GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Vendor Site Global Attribute 1 | |
| PVS_GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Vendor Site Global Attribute 2 | |
| PVS_GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Vendor Site Global Attribute 3 | |
| PVS_GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Vendor Site Global Attribute 4 | |
| PVS_GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Vendor Site Global Attribute 5 | |
| PVS_GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Vendor Site Global Attribute 6 | |
| PVS_GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Vendor Site Global Attribute 7 | |
| PVS_GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Vendor Site Global Attribute 8 | |
| PVS_GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Vendor Site Global Attribute 9 | |
| PVS_GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Vendor Site Global Attribute 10 | |
| PVS_GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Vendor Site Global Attribute 11 | |
| PVS_GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Vendor Site Global Attribute 12 | |
| PVS_GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Vendor Site Global Attribute 13 | |
| PVS_GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Vendor Site Global Attribute 14 | |
| PVS_GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Vendor Site Global Attribute 15 | |
| PVS_GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Vendor Site Global Attribute 16 | |
| PVS_GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Vendor Site Global Attribute 17 | |
| PVS_GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Vendor Site Global Attribute 18 | |
| PVS_GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Vendor Site Global Attribute 19 | |
| PVS_GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Vendor Site Global Attribute 20 | |
| BILL_TO_INT_LOCATION_NAME | VARCHAR2 | (60) | Bill To Internal Location Name | |
| BILL_TO_INT_ADDRESS1 | VARCHAR2 | (240) | Bill To Internal Address 1 | |
| BILL_TO_INT_ADDRESS2 | VARCHAR2 | (240) | Bill To Internal Address 2 | |
| BILL_TO_INT_ADDRESS3 | VARCHAR2 | (240) | Bill To Internal Address 3 | |
| BILL_TO_INT_CITY | VARCHAR2 | (30) | Bill To Internal City | |
| BILL_TO_INT_POSTAL_CODE | VARCHAR2 | (30) | Bill To Internal Postal Code | |
| BILL_TO_INT_COUNTRY | VARCHAR2 | (30) | Bill To Internal Country | |
| BILL_TO_INT_COUNTRY_EXT1 | VARCHAR2 | (30) | Bill To Internal Country (Ext) | |
| FI_VAT_REGISTRATION_NUM | VARCHAR2 | (20) | VAT Registration Number | |
| BILL_TO_INT_REGION1 | VARCHAR2 | (120) | Bill To Internal Region 1 | |
| BILL_TO_INT_REGION1_EXT1 | VARCHAR2 | (20) | Bill To Internal Region 1 (Ext) | |
| BILL_TO_INT_REGION2 | VARCHAR2 | (120) | Bill To Internal Region 2 | |
| BILL_TO_INT_REGION2_EXT1 | VARCHAR2 | (20) | Bill To Internal Region 2 (Ext) | |
| BILL_TO_INT_REGION3 | VARCHAR2 | (120) | Bill To Internal Region 3 | |
| BILL_TO_INT_REGION3_EXT1 | VARCHAR2 | (20) | Bill To Internal Region 3 (Ext) | |
| BILL_TO_INT_LOCATION_ID | NUMBER | (20) | Bill To Internal Location ID | |
| BILL_TO_INT_EDI_LOCATION_CODE | VARCHAR2 | (35) | Bill To Internal EDI Location Code | |
| MAP_ID | NUMBER | Map ID | ||
| FUTURE_PAY_DUE_DATE | DATE | Future Payment Due Date | ||
| VENDOR_ALTERNATE_NAME | VARCHAR2 | (320) | Alternate supplier name for kana value | |
| VENDOR_ALTERNATE_SITE_CODE | VARCHAR2 | (320) | Alternate supplier site code | |
| SUPPLIER_CHECK_DIGITS | VARCHAR2 | (30) | supplier check digits | |
| SBK_BANK_NAME | VARCHAR2 | (60) | SBK Bank Name | |
| IBAN_NUMBER | VARCHAR2 | (40) | IBAN_NUMBER | |
| VENDOR_IBAN_NUMBER | VARCHAR2 | (40) | VENDOR_IBAN_NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT COMMUNICATION_METHOD
, BK_TP_TEST_FLAG
, DOCUMENT_ID
, DOCUMENT_TYPE
, DOCUMENT_PURPOSE_CODE
, DOCUMENT_CODE
, BK_TP_TRANSLATOR_CODE
, BK_TP_LOCATION_CODE_EXT
, BK_TP_DESCRIPTION
, BK_TP_REFERENCE_EXT1
, BK_TP_REFERENCE_EXT2
, TRANSACTION_DATE
, RUN_ID
, TPH_ATTRIBUTE_CATEGORY
, TPH_ATTRIBUTE1
, TPH_ATTRIBUTE2
, TPH_ATTRIBUTE3
, TPH_ATTRIBUTE4
, TPH_ATTRIBUTE5
, TPH_ATTRIBUTE6
, TPH_ATTRIBUTE7
, TPH_ATTRIBUTE8
, TPH_ATTRIBUTE9
, TPH_ATTRIBUTE10
, TPH_ATTRIBUTE11
, TPH_ATTRIBUTE12
, TPH_ATTRIBUTE13
, TPH_ATTRIBUTE14
, TPH_ATTRIBUTE15
, TPD_ATTRIBUTE_CATEGORY
, TPD_ATTRIBUTE1
, TPD_ATTRIBUTE2
, TPD_ATTRIBUTE3
, TPD_ATTRIBUTE4
, TPD_ATTRIBUTE5
, TRANSACTION_HANDLING_CODE
, TRANSACTION_HANDLING_CODE_EXT1
, CHECK_AMOUNT
, CURRENCY_CODE
, CURRENCY_CODE_EXT1
, EDI_PAYMENT_METHOD
, EDI_PAYMENT_METHOD_EXT1
, EDI_PAYMENT_FORMAT
, EDI_PAYMENT_FORMAT_EXT1
, BANK_BRANCH_TYPE
, BANK_BRANCH_TYPE_EXT1
, BANK_ACCOUNT_TYPE
, BANK_ACCOUNT_TYPE_EXT1
, BANK_ACCOUNT_NUM
, BANK_EDI_ID_NUMBER
, VENDOR_BANK_BRANCH_TYPE
, VENDOR_BANK_BRANCH_TYPE_EXT1
, VENDOR_BANK_ACCOUNT_TYPE
, VENDOR_BANK_ACCOUNT_TYPE_EXT1
, VENDOR_BANK_ACCOUNT_NUM
, PAYMENT_DATE
, BANK_NUM
, VENDOR_BANK_NUM
, EDI_REMITTANCE_METHOD
, EDI_REMITTANCE_INSTRUCTION
, CHECKRUN_NAME
, CHECK_VOUCHER_NUM
, SELECTED_CHECK_ID
, CHECK_NUMBER
, CUSTOMER_NUM
, VOID_FLAG
, VOID_DATE
, SEGMENT1
, VENDOR_NUMBER_EXT1
, VENDOR_EDI_ID_NUMBER
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, BANK_ENTITY_SITE_CODE
, BANK_ENTITY_SITE_CODE_EXT1
, BANK_NAME
, BK_ADDRESS_LINE1
, BK_ADDRESS_LINE2
, BK_ADDRESS_LINE3
, BK_ADDRESS_LINE4
, BK_CITY
, BK_ZIP
, BK_COUNTRY
, BK_COUNTRY_EXT1
, BK_STATE
, BK_STATE_EXT1
, BK_PROVINCE
, BK_PROVINCE_EXT1
, BK_CONTACT_FIRST_NAME
, BK_CONTACT_MIDDLE_NAME
, BK_CONTACT_LAST_NAME
, BK_CONTACT_TITLE
, BK_CONTACT_PREFIX
, BK_CONTACT_AREA_CODE
, BK_CONTACT_PHONE
, VENDOR_SITE_CODE
, VENDOR_SITE_CODE_EXT1
, VENDOR_NAME
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, ADDRESS_LINE4
, CITY
, ZIP
, COUNTRY
, COUNTRY_EXT1
, STATE
, STATE_EXT1
, PROVINCE
, PROVINCE_EXT1
, TRANSACTION_RECORD_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DOCUMENT_STANDARD
, BK_EFT_SWIFT_CODE
, SBK_BANK_BRANCH_NUMBER
, SBK_BANK_BRANCH_NAME
, SBK_ADDRESS_LINE1
, SBK_ADDRESS_LINE2
, SBK_ADDRESS_LINE3
, SBK_CITY
, SBK_STATE
, SBK_ZIP
, SBK_PROVINCE
, SBK_COUNTRY
, SBK_EFT_SWIFT_CODE
, ABA_GLOBAL_ATTRIBUTE_CATEGORY
, ABA_GLOBAL_ATTRIBUTE1
, ABA_GLOBAL_ATTRIBUTE2
, ABA_GLOBAL_ATTRIBUTE3
, ABA_GLOBAL_ATTRIBUTE4
, ABA_GLOBAL_ATTRIBUTE5
, ABA_GLOBAL_ATTRIBUTE6
, ABA_GLOBAL_ATTRIBUTE7
, ABA_GLOBAL_ATTRIBUTE8
, ABA_GLOBAL_ATTRIBUTE9
, ABA_GLOBAL_ATTRIBUTE10
, ABA_GLOBAL_ATTRIBUTE11
, ABA_GLOBAL_ATTRIBUTE12
, ABA_GLOBAL_ATTRIBUTE13
, ABA_GLOBAL_ATTRIBUTE14
, ABA_GLOBAL_ATTRIBUTE15
, ABA_GLOBAL_ATTRIBUTE16
, ABA_GLOBAL_ATTRIBUTE17
, ABA_GLOBAL_ATTRIBUTE18
, ABA_GLOBAL_ATTRIBUTE19
, ABA_GLOBAL_ATTRIBUTE20
, ABAS_GLOBAL_ATTRIBUTE_CATEGORY
, ABAS_GLOBAL_ATTRIBUTE1
, ABAS_GLOBAL_ATTRIBUTE2
, ABAS_GLOBAL_ATTRIBUTE3
, ABAS_GLOBAL_ATTRIBUTE4
, ABAS_GLOBAL_ATTRIBUTE5
, ABAS_GLOBAL_ATTRIBUTE6
, ABAS_GLOBAL_ATTRIBUTE7
, ABAS_GLOBAL_ATTRIBUTE8
, ABAS_GLOBAL_ATTRIBUTE9
, ABAS_GLOBAL_ATTRIBUTE10
, ABAS_GLOBAL_ATTRIBUTE11
, ABAS_GLOBAL_ATTRIBUTE12
, ABAS_GLOBAL_ATTRIBUTE13
, ABAS_GLOBAL_ATTRIBUTE14
, ABAS_GLOBAL_ATTRIBUTE15
, ABAS_GLOBAL_ATTRIBUTE16
, ABAS_GLOBAL_ATTRIBUTE17
, ABAS_GLOBAL_ATTRIBUTE18
, ABAS_GLOBAL_ATTRIBUTE19
, ABAS_GLOBAL_ATTRIBUTE20
, PVS_GLOBAL_ATTRIBUTE_CATEGORY
, PVS_GLOBAL_ATTRIBUTE1
, PVS_GLOBAL_ATTRIBUTE2
, PVS_GLOBAL_ATTRIBUTE3
, PVS_GLOBAL_ATTRIBUTE4
, PVS_GLOBAL_ATTRIBUTE5
, PVS_GLOBAL_ATTRIBUTE6
, PVS_GLOBAL_ATTRIBUTE7
, PVS_GLOBAL_ATTRIBUTE8
, PVS_GLOBAL_ATTRIBUTE9
, PVS_GLOBAL_ATTRIBUTE10
, PVS_GLOBAL_ATTRIBUTE11
, PVS_GLOBAL_ATTRIBUTE12
, PVS_GLOBAL_ATTRIBUTE13
, PVS_GLOBAL_ATTRIBUTE14
, PVS_GLOBAL_ATTRIBUTE15
, PVS_GLOBAL_ATTRIBUTE16
, PVS_GLOBAL_ATTRIBUTE17
, PVS_GLOBAL_ATTRIBUTE18
, PVS_GLOBAL_ATTRIBUTE19
, PVS_GLOBAL_ATTRIBUTE20
, BILL_TO_INT_LOCATION_NAME
, BILL_TO_INT_ADDRESS1
, BILL_TO_INT_ADDRESS2
, BILL_TO_INT_ADDRESS3
, BILL_TO_INT_CITY
, BILL_TO_INT_POSTAL_CODE
, BILL_TO_INT_COUNTRY
, BILL_TO_INT_COUNTRY_EXT1
, FI_VAT_REGISTRATION_NUM
, BILL_TO_INT_REGION1
, BILL_TO_INT_REGION1_EXT1
, BILL_TO_INT_REGION2
, BILL_TO_INT_REGION2_EXT1
, BILL_TO_INT_REGION3
, BILL_TO_INT_REGION3_EXT1
, BILL_TO_INT_LOCATION_ID
, BILL_TO_INT_EDI_LOCATION_CODE
, MAP_ID
, FUTURE_PAY_DUE_DATE
, VENDOR_ALTERNATE_NAME
, VENDOR_ALTERNATE_SITE_CODE
, SUPPLIER_CHECK_DIGITS
, SBK_BANK_NAME
, IBAN_NUMBER
, VENDOR_IBAN_NUMBER
FROM EC.ECE_AP_CHECKS_INTERFACE;
EC.ECE_AP_CHECKS_INTERFACE does not reference any database object
EC.ECE_AP_CHECKS_INTERFACE is referenced by following:
APPS
ECE_AP_CHECKS_INTERFACE
|
|
|
|