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


VIEW: EC.ECE_AP_CHECKS_INTERFACE#

Object Details
Object Name: ECE_AP_CHECKS_INTERFACE#
Object Type: VIEW
Owner: EC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMMUNICATION_METHOD VARCHAR2 (30)
BK_TP_TEST_FLAG VARCHAR2 (1)
DOCUMENT_ID VARCHAR2 (6)
DOCUMENT_TYPE VARCHAR2 (30)
DOCUMENT_PURPOSE_CODE VARCHAR2 (2)
DOCUMENT_CODE VARCHAR2 (35)
BK_TP_TRANSLATOR_CODE VARCHAR2 (30)
BK_TP_LOCATION_CODE_EXT VARCHAR2 (35)
BK_TP_DESCRIPTION VARCHAR2 (240)
BK_TP_REFERENCE_EXT1 VARCHAR2 (240)
BK_TP_REFERENCE_EXT2 VARCHAR2 (240)
TRANSACTION_DATE DATE

RUN_ID NUMBER
Yes
TPH_ATTRIBUTE_CATEGORY VARCHAR2 (150)
TPH_ATTRIBUTE1 VARCHAR2 (150)
TPH_ATTRIBUTE2 VARCHAR2 (150)
TPH_ATTRIBUTE3 VARCHAR2 (150)
TPH_ATTRIBUTE4 VARCHAR2 (150)
TPH_ATTRIBUTE5 VARCHAR2 (150)
TPH_ATTRIBUTE6 VARCHAR2 (150)
TPH_ATTRIBUTE7 VARCHAR2 (150)
TPH_ATTRIBUTE8 VARCHAR2 (150)
TPH_ATTRIBUTE9 VARCHAR2 (150)
TPH_ATTRIBUTE10 VARCHAR2 (150)
TPH_ATTRIBUTE11 VARCHAR2 (150)
TPH_ATTRIBUTE12 VARCHAR2 (150)
TPH_ATTRIBUTE13 VARCHAR2 (150)
TPH_ATTRIBUTE14 VARCHAR2 (150)
TPH_ATTRIBUTE15 VARCHAR2 (150)
TPD_ATTRIBUTE_CATEGORY VARCHAR2 (150)
TPD_ATTRIBUTE1 VARCHAR2 (150)
TPD_ATTRIBUTE2 VARCHAR2 (150)
TPD_ATTRIBUTE3 VARCHAR2 (150)
TPD_ATTRIBUTE4 VARCHAR2 (150)
TPD_ATTRIBUTE5 VARCHAR2 (150)
TRANSACTION_HANDLING_CODE VARCHAR2 (25)
TRANSACTION_HANDLING_CODE_EXT1 VARCHAR2 (80)
CHECK_AMOUNT NUMBER
Yes
CURRENCY_CODE VARCHAR2 (15) Yes
CURRENCY_CODE_EXT1 VARCHAR2 (80)
EDI_PAYMENT_METHOD VARCHAR2 (25)
EDI_PAYMENT_METHOD_EXT1 VARCHAR2 (80)
EDI_PAYMENT_FORMAT VARCHAR2 (25)
EDI_PAYMENT_FORMAT_EXT1 VARCHAR2 (80)
BANK_BRANCH_TYPE VARCHAR2 (25)
BANK_BRANCH_TYPE_EXT1 VARCHAR2 (80)
BANK_ACCOUNT_TYPE VARCHAR2 (25)
BANK_ACCOUNT_TYPE_EXT1 VARCHAR2 (80)
BANK_ACCOUNT_NUM VARCHAR2 (30)
BANK_EDI_ID_NUMBER VARCHAR2 (30)
VENDOR_BANK_BRANCH_TYPE VARCHAR2 (25)
VENDOR_BANK_BRANCH_TYPE_EXT1 VARCHAR2 (80)
VENDOR_BANK_ACCOUNT_TYPE VARCHAR2 (25)
VENDOR_BANK_ACCOUNT_TYPE_EXT1 VARCHAR2 (80)
VENDOR_BANK_ACCOUNT_NUM VARCHAR2 (30)
PAYMENT_DATE DATE

BANK_NUM VARCHAR2 (25)
VENDOR_BANK_NUM VARCHAR2 (30)
EDI_REMITTANCE_METHOD VARCHAR2 (25)
EDI_REMITTANCE_INSTRUCTION VARCHAR2 (256)
CHECKRUN_NAME VARCHAR2 (50) Yes
CHECK_VOUCHER_NUM NUMBER

SELECTED_CHECK_ID NUMBER

CHECK_NUMBER NUMBER
Yes
CUSTOMER_NUM VARCHAR2 (25)
VOID_FLAG VARCHAR2 (1)
VOID_DATE DATE

SEGMENT1 VARCHAR2 (30)
VENDOR_NUMBER_EXT1 VARCHAR2 (80)
VENDOR_EDI_ID_NUMBER VARCHAR2 (30)
SEGMENT2 VARCHAR2 (30)
SEGMENT3 VARCHAR2 (30)
SEGMENT4 VARCHAR2 (30)
SEGMENT5 VARCHAR2 (30)
BANK_ENTITY_SITE_CODE VARCHAR2 (20)
BANK_ENTITY_SITE_CODE_EXT1 VARCHAR2 (80)
BANK_NAME VARCHAR2 (60)
BK_ADDRESS_LINE1 VARCHAR2 (35)
BK_ADDRESS_LINE2 VARCHAR2 (35)
BK_ADDRESS_LINE3 VARCHAR2 (35)
BK_ADDRESS_LINE4 VARCHAR2 (35)
BK_CITY VARCHAR2 (25)
BK_ZIP VARCHAR2 (20)
BK_COUNTRY VARCHAR2 (25)
BK_COUNTRY_EXT1 VARCHAR2 (80)
BK_STATE VARCHAR2 (25)
BK_STATE_EXT1 VARCHAR2 (80)
BK_PROVINCE VARCHAR2 (25)
BK_PROVINCE_EXT1 VARCHAR2 (80)
BK_CONTACT_FIRST_NAME VARCHAR2 (15)
BK_CONTACT_MIDDLE_NAME VARCHAR2 (15)
BK_CONTACT_LAST_NAME VARCHAR2 (20)
BK_CONTACT_TITLE VARCHAR2 (30)
BK_CONTACT_PREFIX VARCHAR2 (5)
BK_CONTACT_AREA_CODE VARCHAR2 (10)
BK_CONTACT_PHONE VARCHAR2 (15)
VENDOR_SITE_CODE VARCHAR2 (15)
VENDOR_SITE_CODE_EXT1 VARCHAR2 (80)
VENDOR_NAME VARCHAR2 (240)
ADDRESS_LINE1 VARCHAR2 (240)
ADDRESS_LINE2 VARCHAR2 (240)
ADDRESS_LINE3 VARCHAR2 (240)
ADDRESS_LINE4 VARCHAR2 (240)
CITY VARCHAR2 (25)
ZIP VARCHAR2 (20)
COUNTRY VARCHAR2 (25)
COUNTRY_EXT1 VARCHAR2 (80)
STATE VARCHAR2 (25)
STATE_EXT1 VARCHAR2 (80)
PROVINCE VARCHAR2 (25)
PROVINCE_EXT1 VARCHAR2 (80)
TRANSACTION_RECORD_ID NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

DOCUMENT_STANDARD VARCHAR2 (30)
BK_EFT_SWIFT_CODE VARCHAR2 (12)
SBK_BANK_BRANCH_NUMBER VARCHAR2 (25)
SBK_BANK_BRANCH_NAME VARCHAR2 (60)
SBK_ADDRESS_LINE1 VARCHAR2 (35)
SBK_ADDRESS_LINE2 VARCHAR2 (35)
SBK_ADDRESS_LINE3 VARCHAR2 (35)
SBK_CITY VARCHAR2 (25)
SBK_STATE VARCHAR2 (25)
SBK_ZIP VARCHAR2 (20)
SBK_PROVINCE VARCHAR2 (25)
SBK_COUNTRY VARCHAR2 (25)
SBK_EFT_SWIFT_CODE VARCHAR2 (12)
ABA_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
ABA_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
ABAS_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
PVS_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
PVS_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
BILL_TO_INT_LOCATION_NAME VARCHAR2 (60)
BILL_TO_INT_ADDRESS1 VARCHAR2 (240)
BILL_TO_INT_ADDRESS2 VARCHAR2 (240)
BILL_TO_INT_ADDRESS3 VARCHAR2 (240)
BILL_TO_INT_CITY VARCHAR2 (30)
BILL_TO_INT_POSTAL_CODE VARCHAR2 (30)
BILL_TO_INT_COUNTRY VARCHAR2 (30)
BILL_TO_INT_COUNTRY_EXT1 VARCHAR2 (30)
FI_VAT_REGISTRATION_NUM VARCHAR2 (20)
BILL_TO_INT_REGION1 VARCHAR2 (120)
BILL_TO_INT_REGION1_EXT1 VARCHAR2 (20)
BILL_TO_INT_REGION2 VARCHAR2 (120)
BILL_TO_INT_REGION2_EXT1 VARCHAR2 (20)
BILL_TO_INT_REGION3 VARCHAR2 (120)
BILL_TO_INT_REGION3_EXT1 VARCHAR2 (20)
BILL_TO_INT_LOCATION_ID NUMBER (20)
BILL_TO_INT_EDI_LOCATION_CODE VARCHAR2 (35)
MAP_ID NUMBER

FUTURE_PAY_DUE_DATE DATE

VENDOR_ALTERNATE_NAME VARCHAR2 (320)
VENDOR_ALTERNATE_SITE_CODE VARCHAR2 (320)
SUPPLIER_CHECK_DIGITS VARCHAR2 (30)
SBK_BANK_NAME VARCHAR2 (60)
IBAN_NUMBER VARCHAR2 (40)
VENDOR_IBAN_NUMBER VARCHAR2 (40)
Query Text

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#;

Dependencies

[top of page]

EC.ECE_AP_CHECKS_INTERFACE# references the following:

SchemaEC
TableECE_AP_CHECKS_INTERFACE
EC.ECE_AP_CHECKS_INTERFACE# is referenced by following:

SchemaAPPS
SynonymECE_AP_CHECKS_INTERFACE