eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AP.AP_SUPPLIERS_INT

Object Details

Object Name:	AP_SUPPLIERS_INT
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_SUPPLIERS_INT
Subobject Name:
Status:	VALID

This is the open interface table for importing suppliers from external sources. AP_SUPPLIERS_INT holds Supplier information, which is loaded by the user for import. The columns in the table map to corresponding columns in the HZ_PARTIES and AP_SUPPLIERS table. The Oracle Payables application uses this information to create a new Supplier record when the Supplier Open Interface Import program is submitted. Each row in the table will be uniquely identified by VENDOR_INTERFACE_ID.
Please refer to the Oracle Payables Reference Guide for more detailed information on Open Interface table columns, including import validation and destination columns.
Scope: public
Table Description
Product: AP
Lifecycle: active
Display Name: AP Suppliers Interface
Category: BUSINESS_ENTITY AP_SUPPLIER

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
VENDOR_INTERFACE_ID	NUMBER	(15)	Yes	Unique identifier for this supplier within this batch. You assign the same value to the supplier sites in the AP_SUPPLIER_SITES_INT and AP_SUP_SITE_CONTACT_INT tables to identify the data as belonging to the same supplier.
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table.
VENDOR_NAME	VARCHAR2	(240)	Yes	This is the unique name used to identify the supplier.
VENDOR_NAME_ALT	VARCHAR2	(320)		Alternate Supplier name for kana value
SEGMENT1	VARCHAR2	(30)		Supplier Number. If the Supplier Number entry option in the Financials Options window is set to 'Automatic', the Suppliers Open Interface Import Program assigns the number. Please note that if a value is provided in the interface table, this value will be ignored and the next automatic number will be assigned to the supplier.If 'Manual' option is used, check is performed for duplicate against PO_VENDOR.SEGMENT1.
SUMMARY_FLAG	VARCHAR2	(1)		Key flexfield summary flag
ENABLED_FLAG	VARCHAR2	(1)		Key flexfield summary flag
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table.
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)		Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table.
EMPLOYEE_ID	NUMBER			Employee unique identifier if supplier is an employee. Validated against HR_EMPLOYEES_CURRENT_V.PERSON_ID.
VENDOR_TYPE_LOOKUP_CODE	VARCHAR2	(30)		Type of the Supplier. Validated against FND_LOOKUP_VALUES.LOOKUP_TYPE = 'VENDOR TYPE'.
CUSTOMER_NUM	VARCHAR2	(25)		Customer number with the supplier
ONE_TIME_FLAG	VARCHAR2	(1)		Indicates whether the supplier is a one-time supplier
MIN_ORDER_AMOUNT	NUMBER			Minimum purchase order amount
SHIP_TO_LOCATION_ID	NUMBER			Default ship-to-location unique identifier for the supplier. Validated against PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID.
SHIP_TO_LOCATION_CODE	VARCHAR2	(60)		Default ship-to-location name for the supplier. Validated against PO_LINE_LOCATIONS.SHIP_TO_LOCATION_CODE.
BILL_TO_LOCATION_ID	NUMBER			Default unique identifier for the location where the supplier sends invoices for goods and services. Validated against HR_LOCATIONS_ALL.LOCATION_ID where HR_LOCATIONS_ALL.BILL_TO_SITE_FLAG = 'Y'.
BILL_TO_LOCATION_CODE	VARCHAR2	(60)		Default bill to location where the supplier sends invoices for goods and services. Validated against HR_LOCATIONS_ALL.LOCATION_CODE where HR_LOCATIONS_ALL.BILL_TO_SITE_FLAG = 'Y'.
SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)		Default freight career for the supplier. Validated against ORG_FREIGHT.FREIGHT_CODE.
FREIGHT_TERMS_LOOKUP_CODE	VARCHAR2	(25)		Default freight terms for the supplier. Validated against FND_LOOKUP_VALUES.LOOKUP_TYPE = 'FREIGHT TERMS'.
FOB_LOOKUP_CODE	VARCHAR2	(25)		Default free-on-board type for the supplier. Validated against FND_LOOKUP_VALUES.LOOKUP_TYPE = 'FOB'.
TERMS_ID	NUMBER			Payment terms identifier. Validated against AP_TERMS_TL.TERM_ID
TERMS_NAME	VARCHAR2	(50)		Payment terms identifier, this column corresponds to the Validated against AP_TERMS_TL.NAME
SET_OF_BOOKS_ID	NUMBER			Ledger unique identifer.
ALWAYS_TAKE_DISC_FLAG	VARCHAR2	(1)		Indicates if Oracle Payables should always take discount from the supplier
PAY_DATE_BASIS_LOOKUP_CODE	VARCHAR2	(25)		Type of payment date basis: Discount or Due
PAY_GROUP_LOOKUP_CODE	VARCHAR2	(25)		Name of the Paygroup defined to pay a category of suppliers or invoices in the same payment batch. Validated against FND_LOOKUP_VALUES for lookup_type 'PAY GROUP'
PAYMENT_PRIORITY	NUMBER			Number representing payment priority of a scheduled payment (1 to 99)
INVOICE_CURRENCY_CODE	VARCHAR2	(15)		Currency of invoice. Validated against FND_CURRENCIES.CURRENCY_CODE
PAYMENT_CURRENCY_CODE	VARCHAR2	(15)		Currency of the payment. Validated against FND_CURRENCIES.CURRENCY_CODE
INVOICE_AMOUNT_LIMIT	NUMBER			Maximum amount per invoice
HOLD_ALL_PAYMENTS_FLAG	VARCHAR2	(1)		Indicates if Oracle Payables should put all payments for this supplier on hold
HOLD_FUTURE_PAYMENTS_FLAG	VARCHAR2	(1)		Indicates if Oracle Payables should put unvalidated invoices for this supplier on hold
HOLD_REASON	VARCHAR2	(240)		Reason for placing the supplier on payment hold
DISTRIBUTION_SET_ID	NUMBER			Distribution set identifier. Validated against AP_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_ID
DISTRIBUTION_SET_NAME	VARCHAR2	(50)		Distribution set identifier to be used. Validated against DISTRIBUTION_SET_ID of AP_DISTRIBUTION_SETS_ALL table.
ACCTS_PAY_CODE_COMBINATION_ID	NUMBER			Unique identifier for the supplier liability account. Validated against GL_CODE_COMBINATIONS.CODE_COMBINATION_ID where ACCOUNT_TYPE = 'L'.
PREPAY_CODE_COMBINATION_ID	NUMBER			Unique identifier account used for prepayment. Validated against GL_CODE_COMBINATIONS.CODE_COMBINATION_ID
NUM_1099	VARCHAR2	(30)		Tax identification number (1099)
TYPE_1099	VARCHAR2	(10)		Income tax type for a United States 1099 reportable supplier. Validated against AP_INCOME_TAX_TYPES.INCOME_TAX_TYPE. The value in this field is valid only if FEDERAL_REPORTABLE_FLAG column is 'Y'.
ORGANIZATION_TYPE_LOOKUP_CODE	VARCHAR2	(25)		Orgnization type of the Supplier. Validated against FND_LOOKUP_VALUES.LOOKUP_TYPE = 'ORGANIZATION TYPE'.
VAT_CODE	VARCHAR2	(15)		Default invoice tax code
START_DATE_ACTIVE	DATE			Start date of the Supplier
END_DATE_ACTIVE	DATE			End date of the Supplier
MINORITY_GROUP_LOOKUP_CODE	VARCHAR2	(25)		To be entered if supplier is a minorty-owned business. Validated against FND_LOOKUP_VALUES.LOOKUP_TYPE = 'MINORITY GROUP'.
PAYMENT_METHOD_LOOKUP_CODE	VARCHAR2	(30)		no longer used
WOMEN_OWNED_FLAG	VARCHAR2	(1)		Indicates whether or not the supplier is a woman-owned business
SMALL_BUSINESS_FLAG	VARCHAR2	(1)		Indicates whether or not the supplier is a small business
STANDARD_INDUSTRY_CLASS	VARCHAR2	(25)		Standard industry classification number
HOLD_FLAG	VARCHAR2	(1)		Indicates whether or not the supplier is on purchasing hold
PURCHASING_HOLD_REASON	VARCHAR2	(240)		Reason for placing the supplier on purchasing hold
HOLD_BY	NUMBER	(9)		Unique identifier for the emplloyee who placed the supplier on hold
HOLD_DATE	DATE			Date the supplier was placed on purchasing hold
TERMS_DATE_BASIS	VARCHAR2	(25)		Date from which Payables calculates a scheduled payment. The valid values are:- CURRENT- GOODS- RECEIVED- INVOICE- INVOICE RECEIVED
INSPECTION_REQUIRED_FLAG	VARCHAR2	(1)		Indicates whether inspection is required before the invoice is paid
RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)		Indicates if shipment must be received before the invoice is paid
QTY_RCV_TOLERANCE	NUMBER			Identifies the maximum acceptable quantity received in excess of the quantity ordered on a purchase order for the supplier.
QTY_RCV_EXCEPTION_CODE	VARCHAR2	(25)		Action to be taken if quantity receiving tolerance is violated for the receving transaction for this supplier. Validated against FND_LOOKUP_VALUES.LOOKUP_TYPE = 'RCV OPTION'.
ENFORCE_SHIP_TO_LOCATION_CODE	VARCHAR2	(25)		Action to be taken when the receiving location differs from the ship to location. Validated against FND_LOOKUP_VALUES.LOOKUP_TYPE = 'RCV OPTION'.
DAYS_EARLY_RECEIPT_ALLOWED	NUMBER			Maximum acceptable number of days items can be received early
DAYS_LATE_RECEIPT_ALLOWED	NUMBER			Maximum acceptable number of days items can be received late
RECEIPT_DAYS_EXCEPTION_CODE	VARCHAR2	(25)		Action to be taken when items are received earlier or later than the allowed number of days specified. Validated against FND_LOOKUP_VALUES.LOOKUP_TYPE = 'RCV OPTION'.
RECEIVING_ROUTING_ID	NUMBER			Receipt routing unique identifier. Validated against RCV_ROUTING_HEADERS.ROUTING_HEADER_ID.
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	VARCHAR2	(1)		Indicates if substitute items can be received in place of the ordered items
ALLOW_UNORDERED_RECEIPTS_FLAG	VARCHAR2	(1)		Indicates if unordered receipts are allowed for the supplier in Purchasing.
HOLD_UNMATCHED_INVOICES_FLAG	VARCHAR2	(1)		Indicates if unmatched invoices should be put on hold
EXCLUSIVE_PAYMENT_FLAG	VARCHAR2	(1)		Indicates whether or not separate payments should be created for each invoice
AP_TAX_ROUNDING_RULE	VARCHAR2	(1)		No Longer used
AUTO_TAX_CALC_FLAG	VARCHAR2	(1)		Level of automatic tax calculation for supplier
AUTO_TAX_CALC_OVERRIDE	VARCHAR2	(1)		Allows override of tax calculation at supplier site level
AMOUNT_INCLUDES_TAX_FLAG	VARCHAR2	(1)		Flag to enable Inclusive Tax for supplier
TAX_VERIFICATION_DATE	DATE			Tax verification date(1099)
NAME_CONTROL	VARCHAR2	(4)		Name control(1099)
STATE_REPORTABLE_FLAG	VARCHAR2	(1)		State reportable flag(1099)
FEDERAL_REPORTABLE_FLAG	VARCHAR2	(1)		This column indicates that the supplier is reportable to the United States Internal Revenue Service for 1099 purposes.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		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
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row. Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID.
PROGRAM_APPLICATION_ID	NUMBER			Enhanced Who column Concurrent Program who column - application id of the program that last updated this row. Foreign key to the APPLICATION_ID column of the FND_APPLICATION table.
PROGRAM_ID	NUMBER			Enhanced Who column Concurrent Program who column - program id of the program that last updated this row. Foreign key to the CONCURRENT_PROGRAM_ID column of the FND_CONCURRENT_PROGRAM table.
PROGRAM_UPDATE_DATE	DATE			Enhanced Who column Concurrent Program who column - date when a program last updated this row.
VAT_REGISTRATION_NUM	VARCHAR2	(20)		Tax registration number
AUTO_CALCULATE_INTEREST_FLAG	VARCHAR2	(1)		Indicates if interest is to be automatically calculated
EXCLUDE_FREIGHT_FROM_DISCOUNT	VARCHAR2	(1)		Indicates if the freight amount is to be excluded from discount
TAX_REPORTING_NAME	VARCHAR2	(80)		Tax reporting name for 1099
ALLOW_AWT_FLAG	VARCHAR2	(1)		Indicates whether or not Allow Withholding Tax is enabled
AWT_GROUP_ID	NUMBER	(15)		Withholding tax group identifier at Invoice Validation time. Validated against AP_AWT_GROUPS.GROUP_ID
AWT_GROUP_NAME	VARCHAR2	(25)		Withholding tax group name at Invoice Validation time. Validated against AP_AWT_GROUPS.NAME.
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for country-specific functionality
EDI_TRANSACTION_HANDLING	VARCHAR2	(25)		Defines whether this supplier is an EDI partner
EDI_PAYMENT_METHOD	VARCHAR2	(25)		How payment is to be made through EDI, Valid methods are ACH, BOP, CWT, FEW, FWT and SWT
EDI_PAYMENT_FORMAT	VARCHAR2	(25)		Type of information being transmitted with the funds if using EDI_PAYMENT_METHOD ACH. Valid values are CCD, CCP, CTP, CTX, PPD and PPP
EDI_REMITTANCE_METHOD	VARCHAR2	(25)		How remittance advice is sent to the supplier.
EDI_REMITTANCE_INSTRUCTION	VARCHAR2	(256)		Indicates the sender of the remittance advice. Valid values are Bank or the Payables system.
BANK_CHARGE_BEARER	VARCHAR2	(1)		Indicates who pays the bank charges assessed on payments to this supplier. Validated against FND_LOOKUP_VALUES where LOOKUP_TYPE = 'BANK CHARGE BEARER'. Valid values are: 'I', 'N', 'S'.
MATCH_OPTION	VARCHAR2	(25)		Indicates whether invoices are matched to a purchase order or a receipt
FUTURE_DATED_PAYMENT_CCID	NUMBER	(15)		Accounting Flexfield identifier for the future dated payment account
CREATE_DEBIT_MEMO_FLAG	VARCHAR2	(25)		Indicates if a Debit memo should be created when goods are returned to supplier
OFFSET_TAX_FLAG	VARCHAR2	(1)		Indicates whether or not the supplier uses offset taxes
IMPORT_REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row. Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID.
STATUS	VARCHAR2	(30)		Status of the data in or after the import
REJECT_CODE	VARCHAR2	(2000)		Rejection reason for the supplier record that got rejected
ECE_TP_LOCATION_CODE	VARCHAR2	(60)		Trading partner location code for e-Commerce Gateway
IBY_BANK_CHARGE_BEARER	VARCHAR2	(30)		Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER
BANK_INSTRUCTION1_CODE	VARCHAR2	(30)		Code of first bank instruction
BANK_INSTRUCTION2_CODE	VARCHAR2	(30)		Code of second bank instrcution
BANK_INSTRUCTION_DETAILS	VARCHAR2	(255)		Additional bank instrcution details
PAYMENT_REASON_CODE	VARCHAR2	(30)		Payment reason code
PAYMENT_REASON_COMMENTS	VARCHAR2	(240)		Free text field available for entering a reason
PAYMENT_TEXT_MESSAGE1	VARCHAR2	(150)		Text message for use in payment processing
PAYMENT_TEXT_MESSAGE2	VARCHAR2	(150)		Text message for use in payment processing
PAYMENT_TEXT_MESSAGE3	VARCHAR2	(150)		Text message for use in payment processing
DELIVERY_CHANNEL_CODE	VARCHAR2	(30)		Default delivery channel code
PAYMENT_FORMAT_CODE	VARCHAR2	(150)		Default payment format code
SETTLEMENT_PRIORITY	VARCHAR2	(30)		The priority with which the financial institution or payment system should settle payment for this document. Validated against FND lookup IBY_SETTLEMENT_PRIORITY
PAYMENT_METHOD_CODE	VARCHAR2	(30)		Name of the payment method used to pay the supplier site. Validated against IBY_PAYMENT_METHODS_B.
PAY_AWT_GROUP_ID	NUMBER	(15)		Withholding tax group identifier at Payment time. Validated against AP_AWT_GROUPS.AWT_GROUP_ID.
PAY_AWT_GROUP_NAME	VARCHAR2	(25)		Withholding tax group name at Payment time. Validated against AP_AWT_GROUPS.NAME.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT VENDOR_INTERFACE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      VENDOR_NAME
,      VENDOR_NAME_ALT
,      SEGMENT1
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      EMPLOYEE_ID
,      VENDOR_TYPE_LOOKUP_CODE
,      CUSTOMER_NUM
,      ONE_TIME_FLAG
,      MIN_ORDER_AMOUNT
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION_CODE
,      BILL_TO_LOCATION_ID
,      BILL_TO_LOCATION_CODE
,      SHIP_VIA_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      FOB_LOOKUP_CODE
,      TERMS_ID
,      TERMS_NAME
,      SET_OF_BOOKS_ID
,      ALWAYS_TAKE_DISC_FLAG
,      PAY_DATE_BASIS_LOOKUP_CODE
,      PAY_GROUP_LOOKUP_CODE
,      PAYMENT_PRIORITY
,      INVOICE_CURRENCY_CODE
,      PAYMENT_CURRENCY_CODE
,      INVOICE_AMOUNT_LIMIT
,      HOLD_ALL_PAYMENTS_FLAG
,      HOLD_FUTURE_PAYMENTS_FLAG
,      HOLD_REASON
,      DISTRIBUTION_SET_ID
,      DISTRIBUTION_SET_NAME
,      ACCTS_PAY_CODE_COMBINATION_ID
,      PREPAY_CODE_COMBINATION_ID
,      NUM_1099
,      TYPE_1099
,      ORGANIZATION_TYPE_LOOKUP_CODE
,      VAT_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      MINORITY_GROUP_LOOKUP_CODE
,      PAYMENT_METHOD_LOOKUP_CODE
,      WOMEN_OWNED_FLAG
,      SMALL_BUSINESS_FLAG
,      STANDARD_INDUSTRY_CLASS
,      HOLD_FLAG
,      PURCHASING_HOLD_REASON
,      HOLD_BY
,      HOLD_DATE
,      TERMS_DATE_BASIS
,      INSPECTION_REQUIRED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      QTY_RCV_TOLERANCE
,      QTY_RCV_EXCEPTION_CODE
,      ENFORCE_SHIP_TO_LOCATION_CODE
,      DAYS_EARLY_RECEIPT_ALLOWED
,      DAYS_LATE_RECEIPT_ALLOWED
,      RECEIPT_DAYS_EXCEPTION_CODE
,      RECEIVING_ROUTING_ID
,      ALLOW_SUBSTITUTE_RECEIPTS_FLAG
,      ALLOW_UNORDERED_RECEIPTS_FLAG
,      HOLD_UNMATCHED_INVOICES_FLAG
,      EXCLUSIVE_PAYMENT_FLAG
,      AP_TAX_ROUNDING_RULE
,      AUTO_TAX_CALC_FLAG
,      AUTO_TAX_CALC_OVERRIDE
,      AMOUNT_INCLUDES_TAX_FLAG
,      TAX_VERIFICATION_DATE
,      NAME_CONTROL
,      STATE_REPORTABLE_FLAG
,      FEDERAL_REPORTABLE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      VAT_REGISTRATION_NUM
,      AUTO_CALCULATE_INTEREST_FLAG
,      EXCLUDE_FREIGHT_FROM_DISCOUNT
,      TAX_REPORTING_NAME
,      ALLOW_AWT_FLAG
,      AWT_GROUP_ID
,      AWT_GROUP_NAME
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      EDI_TRANSACTION_HANDLING
,      EDI_PAYMENT_METHOD
,      EDI_PAYMENT_FORMAT
,      EDI_REMITTANCE_METHOD
,      EDI_REMITTANCE_INSTRUCTION
,      BANK_CHARGE_BEARER
,      MATCH_OPTION
,      FUTURE_DATED_PAYMENT_CCID
,      CREATE_DEBIT_MEMO_FLAG
,      OFFSET_TAX_FLAG
,      IMPORT_REQUEST_ID
,      STATUS
,      REJECT_CODE
,      ECE_TP_LOCATION_CODE
,      IBY_BANK_CHARGE_BEARER
,      BANK_INSTRUCTION1_CODE
,      BANK_INSTRUCTION2_CODE
,      BANK_INSTRUCTION_DETAILS
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_COMMENTS
,      PAYMENT_TEXT_MESSAGE1
,      PAYMENT_TEXT_MESSAGE2
,      PAYMENT_TEXT_MESSAGE3
,      DELIVERY_CHANNEL_CODE
,      PAYMENT_FORMAT_CODE
,      SETTLEMENT_PRIORITY
,      PAYMENT_METHOD_CODE
,      PAY_AWT_GROUP_ID
,      PAY_AWT_GROUP_NAME
FROM AP.AP_SUPPLIERS_INT;

Dependencies

[top of page]

AP.AP_SUPPLIERS_INT does not reference any database object

AP.AP_SUPPLIERS_INT is referenced by following:

APPS: AP_SUPPLIERS_INT