ap supplier int comparision
TRANSCRIPT
Changes in R12 for Supplier Inteface
Objects Added in 12.1.3col-BANK_INSTRUCTION1_CODEcol-BANK_INSTRUCTION2_CODEcol-BANK_INSTRUCTION_DETAILScol-CEO_NAMEcol-CEO_TITLEcol-DELIVERY_CHANNEL_CODEcol-ECE_TP_LOCATION_CODEcol-EMAIL_ADDRESScol-IBY_BANK_CHARGE_BEARERcol-PARTY_IDcol-PARTY_ORIG_SYSTEMcol-PARTY_ORIG_SYSTEM_REFERENCEcol-PAYMENT_FORMAT_CODEcol-PAYMENT_METHOD_CODEcol-PAYMENT_REASON_CODEcol-PAYMENT_REASON_COMMENTScol-PAYMENT_TEXT_MESSAGE1col-PAYMENT_TEXT_MESSAGE2col-PAYMENT_TEXT_MESSAGE3col-PAY_AWT_GROUP_IDcol-PAY_AWT_GROUP_NAMEcol-REMITTANCE_EMAILcol-REMIT_ADVICE_FAXcol-SDH_BATCH_IDcol-SETTLEMENT_PRIORITYcol-SUPPLIER_NOTIF_METHODcol-URL
Attribute Changes between 11.5.10.2 and 12.1.3 col-PAYMENT_METHOD_LOOKUP_CODE:char_length:25 => 30col-VAT_CODE:char_length:15 => 30
R12.1 TABLE: AP.AP_SUPPLIERS_INT
Object Details
Object Name: AP_SUPPLIERS_INTObject Type: TABLEOwner: APFND 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_INTERFACEPCT Free: 10PCT 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 NUMBE Distribution set identifier. Validated against
R 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 SupplierEND_DATE_ACTIVE DATE End date of the SupplierMINORITY_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 RECEIVEDINSPECTION_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 VARCHA
R2(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 VARCHA (150) Reserved for country-specific functionality
R2GLOBAL_ATTRIBUTE17 VARCHA
R2(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_BEARERBANK_INSTRUCTION1_CODE VARCHA
R2(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_NAMEFROM AP.AP_SUPPLIERS_INT;
11i:TABLE: AP.AP_SUPPLIERS_INT
Object Details
Object Name: AP_SUPPLIERS_INTObject Type: TABLEOwner: APFND Design Data: SQLAP.AP_SUPPLIERS_INT Subobject Name: Status: VALID
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 PO_VENDORS 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 identified by a unique identifier, the VENDOR_INTERFACE_ID.This is the open interface table for AP Suppliers. Scope: public Table Description Product: AP Lifecycle: active Display Name: AP Suppliers Interface Category: BUSINESS_ENTITY AP_SUPPLIER
Storage Details
Tablespace: APPS_TS_INTERFACEPCT Free: 10PCT Used:
Columns
Name Datatype Length Mandatory Comments
VENDOR_INTERFACE_ID NUMBER (15) Yes Supplier interface record unique identifier
LAST_UPDATE_DATE DATE Standard Who columnLAST_UPDATED_BY NUMBER (15) Standard Who columnVENDOR_NAME VARCHAR
2(240) Yes Supplier name
VENDOR_NAME_ALT VARCHAR2
(320) Alternate Supplier name for kana value
SEGMENT1 VARCHAR2
(30) Supplier Number
SUMMARY_FLAG VARCHAR2
(1) Key flexfield summary flag
ENABLED_FLAG VARCHAR2
(1) Key flexfield summary flag
LAST_UPDATE_LOGIN NUMBER (15) Standard who columnCREATION_DATE DATE Standard who columnCREATED_BY NUMBER (15) Standard who columnEMPLOYEE_ID NUMBER Employee unique identifier if
supplier is an employeeVENDOR_TYPE_LOOKUP_CODE VARCHAR
2(30) Supplier 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
SHIP_TO_LOCATION_CODE VARCHAR2
(60) Defalut ship-to-location name
BILL_TO_LOCATION_ID NUMBER Default bill-to-location unique identifier
BILL_TO_LOCATION_CODE VARCHAR2
(60) Default bill-to-location name
SHIP_VIA_LOOKUP_CODE VARCHAR2
(25) Default carrier type
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2
(25) Default freight terms type
FOB_LOOKUP_CODE VARCHAR2
(25) Default free-on-board type
TERMS_ID NUMBER Payment terms unique identifier
TERMS_NAME VARCHAR2
(50) Payment terms name
SET_OF_BOOKS_ID NUMBER Set of books unique identifier
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) Payment group type
PAYMENT_PRIORITY NUMBER Payment priorityINVOICE_CURRENCY_CODE VARCHAR
2(15) Default currency unique
identifierPAYMENT_CURRENCY_CODE VARCHAR
2(15) Default payment currenct
unique identifier
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 unique identifier
DISTRIBUTION_SET_NAME VARCHAR2
(50) Distribution set name
ACCTS_PAY_CODE_COMBINATION_ID NUMBER Unique identifier for the supplier liability account
PREPAY_CODE_COMBINATION_ID NUMBER Unique identifier account used for prepayment
NUM_1099 VARCHAR2
(30) Tax identification number (1099)
TYPE_1099 VARCHAR2
(10) Type of 1099
ORGANIZATION_TYPE_LOOKUP_CODE VARCHAR2
(25) IRS Organization type
VAT_CODE VARCHAR2
(15) Default invoice tax code
START_DATE_ACTIVE DATE Key flexfield start dateEND_DATE_ACTIVE DATE Key flexfield end dateMINORITY_GROUP_LOOKUP_CODE VARCHAR
2(25) Type of minority_owned
businessPAYMENT_METHOD_LOOKUP_CODE VARCHAR
2(25) Default payment method
typeWOMEN_OWNED_FLAG VARCHAR
2(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 VARCHAR (25) Date from which Payables
2 calculates a scheduled payment
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 Quantity received tolerance percentage
QTY_RCV_EXCEPTION_CODE VARCHAR2
(25) Enforces, warns or ignores quantity receiving tolerance
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2
(25) Action to be taken when the receiving location differs from the ship to location
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
RECEIVING_ROUTING_ID NUMBER Receipt routing unique identifier
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
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) Determines the rounding rule for tax values
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) Do amounts include tax from this supplier?
TAX_VERIFICATION_DATE DATE Tax verification date(1099)NAME_CONTROL VARCHAR
2(4) Name control(1099)
STATE_REPORTABLE_FLAG VARCHAR (1) State reportable flag(1099)
2FEDERAL_REPORTABLE_FLAG VARCHAR
2(1) Federal reportable
flag(1099)ATTRIBUTE_CATEGORY VARCHAR
2(30) Descriptive Flexfield
structure defining columnATTRIBUTE1 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE2 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE3 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE4 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE5 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE6 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE7 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE8 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE9 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE10 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE11 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE12 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE13 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE14 VARCHAR
2(150) Descriptive Flexfield
SegmentATTRIBUTE15 VARCHAR
2(150) Descriptive Flexfield
SegmentREQUEST_ID NUMBER Enhanced Who columnPROGRAM_APPLICATION_ID NUMBER Enhanced Who columnPROGRAM_ID NUMBER Enhanced Who columnPROGRAM_UPDATE_DATE DATE Enhanced Who columnVAT_REGISTRATION_NUM VARCHAR
2(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
enabledAWT_GROUP_ID NUMBER (15) Unique identifier for the
withholding tax groupAWT_GROUP_NAME VARCHAR
2(25) Withholding tax group 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 VARCHAR (25) How payment is to be made
2 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 will be sent to the supplier
EDI_REMITTANCE_INSTRUCTION VARCHAR2
(256) Who will send the remittance advice. Valid values are Bank or the payables system
BANK_CHARGE_BEARER VARCHAR2
(1) Indicates who will pay charges assessed on payments to this supplier
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 Who columnSTATUS VARCHAR
2(30) Status of the data in or after
the importREJECT_CODE VARCHAR
2(2000) Supplier rejection reason
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_CODEFROM AP.AP_SUPPLIERS_INT;