[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_SUPPLIERS |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_SUPPLIERS
|
| Subobject Name: | |
| Status: | VALID |
AP_SUPPLIERS stores information about supplier level attributes. This table contain supplier records entered manually, generated automatically (for ex, during expense reports export) and imported using open interface tables. Each row includes the purchasing, receiving, invoice, tax, classification, and general information. Suppliers created in any module in EBS for example Payables, Purchasing, iSP etc., will get stored in this table along with TCA table - HZ_PARTIES.
This table replaces the old PO_VENDORS table. A new view PO_VENDORS is created on this table.
The supplier name, legal identifiers of the supplier will be stored in TCA and a reference to the party created in TCA will be stored in AP_SUPPLIERS.PARTY_ID, to link the party record in TCA table HZ_PARTIES.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_SUPPLIERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 VENDOR_ID
|
| AP_SUPPLIERS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
SEGMENT1
|
| AP_SUPPLIERS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
EMPLOYEE_ID
|
| AP_SUPPLIERS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NUM_1099
|
| AP_SUPPLIERS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARENT_VENDOR_ID
|
| AP_SUPPLIERS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARTY_ID
|
| AP_SUPPLIERS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARENT_PARTY_ID
|
| AP_SUPPLIERS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VENDOR_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| VENDOR_ID | NUMBER | Yes | Unique internal Identifier for this record. Generated using a database sequence. | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Yes | 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) | Supplier name | |
| VENDOR_NAME_ALT | VARCHAR2 | (320) | Alternate supplier name for kana value by which the supplier can be identified. | |
| SEGMENT1 | VARCHAR2 | (30) | Yes | Supplier number |
| SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Key flexfield summary flag |
| ENABLED_FLAG | VARCHAR2 | (1) | Yes | Key flexfield summary flag |
| SEGMENT2 | VARCHAR2 | (30) | Key flexfield summary flag | |
| SEGMENT3 | VARCHAR2 | (30) | Key flexfield summary flag | |
| SEGMENT4 | VARCHAR2 | (30) | Key flexfield summary flag | |
| SEGMENT5 | VARCHAR2 | (30) | Key flexfield summary flag | |
| LAST_UPDATE_LOGIN | NUMBER | 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 | Yes | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | Yes | 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 the supplier is an employee | ||
| VENDOR_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Indicates Supplier Type of the Supplier. Possible values from 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 | |
| PARENT_VENDOR_ID | NUMBER | Unique identifier of the parent supplier | ||
| MIN_ORDER_AMOUNT | NUMBER | Minimum purchase order amount | ||
| SHIP_TO_LOCATION_ID | NUMBER | Default ship-to location unique identifier | ||
| BILL_TO_LOCATION_ID | NUMBER | Default bill-to location unique identifier | ||
| 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 | ||
| SET_OF_BOOKS_ID | NUMBER | Set of Books unique identifier | ||
| CREDIT_STATUS_LOOKUP_CODE | VARCHAR2 | (25) | No longer used | |
| CREDIT_LIMIT | NUMBER | Not used | ||
| ALWAYS_TAKE_DISC_FLAG | VARCHAR2 | (1) | Indicator of whether Oracle Payables should always take a discount for the supplier | |
| PAY_DATE_BASIS_LOOKUP_CODE | VARCHAR2 | (25) | Indicates the Pay Date Basis determines the pay date for the supplier invoices: Discount or Due. | |
| PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | Indicates pay group for the supplier. It can be used in payment batch processing for grouping categories of suppliers. Possible values for this column are derived from FND_LOOKUP_VALUES for lookup_type 'PAY GROUP'. | |
| PAYMENT_PRIORITY | NUMBER | Indicates payment priority for the supplier. | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Indicates the default currency for Purchasing documents and Payables transactions from the supplier. | |
| PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | Indicates the default currency for Payments to this supplier. | |
| INVOICE_AMOUNT_LIMIT | NUMBER | Maximum amount per invoice | ||
| EXCHANGE_DATE_LOOKUP_CODE | VARCHAR2 | (25) | No longer used | |
| HOLD_ALL_PAYMENTS_FLAG | VARCHAR2 | (1) | Indicates whether Oracle Payables should place all payments for this supplier on hold or not | |
| HOLD_FUTURE_PAYMENTS_FLAG | VARCHAR2 | (1) | Indicates whether Oracle Payables should place upapproved payments for this supplier on hold or not | |
| HOLD_REASON | VARCHAR2 | (240) | Reason for placing the supplier on payment hold | |
| DISTRIBUTION_SET_ID | NUMBER | Indicates unique identifier for the distribution set that is applied to invoices from the supplier. | ||
| ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | Indicates unique identifier for the supplier liability account. | ||
| DISC_LOST_CODE_COMBINATION_ID | NUMBER | No longer used | ||
| DISC_TAKEN_CODE_COMBINATION_ID | NUMBER | No longer used | ||
| EXPENSE_CODE_COMBINATION_ID | NUMBER | Not used | ||
| PREPAY_CODE_COMBINATION_ID | NUMBER | Indicates unique identifier for the general ledger account for prepayment. | ||
| NUM_1099 | VARCHAR2 | (30) | Supplier Tax Identification Number. | |
| TYPE_1099 | VARCHAR2 | (10) | Indicates income tax type for a United States 1099 reportable supplier. | |
| WITHHOLDING_STATUS_LOOKUP_CODE | VARCHAR2 | (25) | Withholding status type | |
| WITHHOLDING_START_DATE | DATE | Withholding start date | ||
| ORGANIZATION_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Indicates IRS organization type of the supplier. | |
| VAT_CODE | VARCHAR2 | (30) | Indicates VAT code for invoices entered for the supplier. | |
| START_DATE_ACTIVE | DATE | Supplier record active date. | ||
| END_DATE_ACTIVE | DATE | Supplier record inactive date. | ||
| MINORITY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | Indicates the type of minority-owned business. | |
| PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | (25) | Indicates the default payment method for the supplier. | |
| BANK_ACCOUNT_NAME | VARCHAR2 | (80) | No longer used | |
| BANK_ACCOUNT_NUM | VARCHAR2 | (30) | No longer used | |
| BANK_NUM | VARCHAR2 | (25) | No longer used | |
| BANK_ACCOUNT_TYPE | VARCHAR2 | (25) | No longer used | |
| WOMEN_OWNED_FLAG | VARCHAR2 | (1) | Indicates whether the supplier is a woman-owned business | |
| SMALL_BUSINESS_FLAG | VARCHAR2 | (1) | Indicates that the supplier is a small business | |
| STANDARD_INDUSTRY_CLASS | VARCHAR2 | (25) | Standard industry classification number | |
| HOLD_FLAG | VARCHAR2 | (1) | Indicator of whether 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 employee who placed the supplier on hold | |
| HOLD_DATE | DATE | Date the supplier was placed on purchasing hold | ||
| TERMS_DATE_BASIS | VARCHAR2 | (25) | The date from which Payables calculates a scheduled payment. The valid values are CURRENT, GOODS, RECEIVED, INVOICE, INVOICE RECEIVED. | |
| PRICE_TOLERANCE | NUMBER | Not used | ||
| INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether inspection is required or not | |
| RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether 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. The valid values are NONE, REJECT, WARNING. | |
| ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | (25) | Indicates the action to be taken when the receiving location differs from the ship-to location. The valid values are NONE, REJECT, WARNING. | |
| DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | Indicates the maximum acceptable number of days items can be received early. | ||
| DAYS_LATE_RECEIPT_ALLOWED | NUMBER | Indicates the maximum acceptable number of days items can be received late. | ||
| RECEIPT_DAYS_EXCEPTION_CODE | VARCHAR2 | (25) | Indicates the action to be taken when items are received earlier or later than the allowed number of days specified. | |
| RECEIVING_ROUTING_ID | NUMBER | Indicates the receipt routing unique identifier. | ||
| ALLOW_SUBSTITUTE_RECEIPTS_FLAG | VARCHAR2 | (1) | Indicates whether substitute items can be received in place of the ordered items | |
| ALLOW_UNORDERED_RECEIPTS_FLAG | VARCHAR2 | (1) | Indicates whether unordered receipts are allowed | |
| HOLD_UNMATCHED_INVOICES_FLAG | VARCHAR2 | (1) | Indicates whether unmatched invoices should be put on hold | |
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | (1) | Indicates whether or not separate payments should be created for each invoice for the supplier. | |
| AP_TAX_ROUNDING_RULE | VARCHAR2 | (1) | No Longer Used | |
| AUTO_TAX_CALC_FLAG | VARCHAR2 | (1) | Indicates the level for automatic tax calculation for the supplier. | |
| AUTO_TAX_CALC_OVERRIDE | VARCHAR2 | (1) | Indicates if override of tax calculation is allowed at supplier site level. | |
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | Indicates if amounts on invoices from the supplier include tax. | |
| TAX_VERIFICATION_DATE | DATE | Indicates the tax verification date. | ||
| NAME_CONTROL | VARCHAR2 | (4) | Indicates the first four characters of the last name of a 1099 reportable supplier. | |
| STATE_REPORTABLE_FLAG | VARCHAR2 | (1) | Indicates that the supplier is reportable to a state taxing authority. | |
| FEDERAL_REPORTABLE_FLAG | VARCHAR2 | (1) | Indicates that the supplier is reportable to the United States Internal Revenue Service for 1099 purposes. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Indicates the descriptive flexfield category for the descriptive flexfield information for the supplier. | |
| 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 | 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 | 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 | Concurrent Program who column - date when a program last updated this row. | ||
| OFFSET_VAT_CODE | VARCHAR2 | (20) | No longer used | |
| VAT_REGISTRATION_NUM | VARCHAR2 | (20) | VAT registration number | |
| AUTO_CALCULATE_INTEREST_FLAG | VARCHAR2 | (1) | Indicates whether interest is to be automatically calculated | |
| VALIDATION_NUMBER | NUMBER | Validation number | ||
| EXCLUDE_FREIGHT_FROM_DISCOUNT | VARCHAR2 | (1) | Indicates if the freight amount is to be excluded from the discount on invoices from the supplier. | |
| TAX_REPORTING_NAME | VARCHAR2 | (80) | Tax reporting name for the supplier. | |
| CHECK_DIGITS | VARCHAR2 | (30) | Check number used by Payables | |
| BANK_NUMBER | VARCHAR2 | (30) | No longer used | |
| ALLOW_AWT_FLAG | VARCHAR2 | (1) | Indicates whether or not automatic withholding is allowed for the supplier. | |
| AWT_GROUP_ID | NUMBER | (15) | Indicates the unique identifier for the withholding tax group. | |
| 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) | No longer used | |
| EDI_PAYMENT_METHOD | VARCHAR2 | (25) | No longer used | |
| EDI_PAYMENT_FORMAT | VARCHAR2 | (25) | No longer used | |
| EDI_REMITTANCE_METHOD | VARCHAR2 | (25) | No Longer Used. | |
| EDI_REMITTANCE_INSTRUCTION | VARCHAR2 | (256) | No longer used | |
| BANK_CHARGE_BEARER | VARCHAR2 | (1) | Indicates who pays the bank charges assessed on payments to this supplier. | |
| BANK_BRANCH_TYPE | VARCHAR2 | (25) | No longer used | |
| MATCH_OPTION | VARCHAR2 | (25) | Indicator of whether to match invoices to the purchase order or the receipt for this supplier. | |
| FUTURE_DATED_PAYMENT_CCID | NUMBER | (15) | Accounting Flexfield identifier for the future dated payment account | |
| CREATE_DEBIT_MEMO_FLAG | VARCHAR2 | (25) | Indicates whether a debit memo should be automatically created when goods are returned to the supplier. | |
| OFFSET_TAX_FLAG | VARCHAR2 | (1) | Indicates whether or not the supplier uses offset taxes. | |
| PARTY_ID | NUMBER | Party Identifier | ||
| PARENT_PARTY_ID | NUMBER | Parent Party Identifier | ||
| NI_NUMBER | VARCHAR2 | (30) | National Insurance Number | |
| TCA_SYNC_NUM_1099 | VARCHAR2 | (30) | For internal use only | |
| TCA_SYNC_VENDOR_NAME | VARCHAR2 | (360) | For internal use only | |
| TCA_SYNC_VAT_REG_NUM | VARCHAR2 | (50) | For internal use only | |
| INDIVIDUAL_1099 | VARCHAR2 | (30) | Income tax type, for 1099 reporting purposes. | |
| UNIQUE_TAX_REFERENCE_NUM | NUMBER | (15) | Unique tax reference number. | |
| PARTNERSHIP_UTR | NUMBER | (15) | ||
| PARTNERSHIP_NAME | VARCHAR2 | (240) | ||
| CIS_ENABLED_FLAG | VARCHAR2 | (1) | ||
| FIRST_NAME | VARCHAR2 | (240) | First name of the supplier. | |
| SECOND_NAME | VARCHAR2 | (240) | Second name of the supplier. | |
| LAST_NAME | VARCHAR2 | (240) | Last name of the supplier. | |
| SALUTATION | VARCHAR2 | (30) | Salutation of the supplier. | |
| TRADING_NAME | VARCHAR2 | (240) | Trading name of the supplier. | |
| WORK_REFERENCE | VARCHAR2 | (30) | ||
| COMPANY_REGISTRATION_NUMBER | VARCHAR2 | (30) | Company registration number of the supplier. | |
| NATIONAL_INSURANCE_NUMBER | VARCHAR2 | (30) | National Insurance number of the Supplier. | |
| VERIFICATION_NUMBER | VARCHAR2 | (30) | ||
| VERIFICATION_REQUEST_ID | NUMBER | (15) | ||
| MATCH_STATUS_FLAG | VARCHAR2 | (1) | ||
| CIS_VERIFICATION_DATE | DATE | |||
| PAY_AWT_GROUP_ID | NUMBER | (15) | Withholding tax group identifier at Payment time. Validated against AP_AWT_GROUPS.AWT_GROUP_ID. | |
| CIS_PARENT_VENDOR_ID | NUMBER | CIS Parent Vendor ID | ||
| BUS_CLASS_LAST_CERTIFIED_DATE | DATE | Last certified date of the Supplier's Business classification. | ||
| BUS_CLASS_LAST_CERTIFIED_BY | NUMBER | Last certified person of the Supplier's Business classification. |
Cut, paste (and edit) the following text to query this object:
SELECT VENDOR_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, VENDOR_NAME
, VENDOR_NAME_ALT
, SEGMENT1
, SUMMARY_FLAG
, ENABLED_FLAG
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, EMPLOYEE_ID
, VENDOR_TYPE_LOOKUP_CODE
, CUSTOMER_NUM
, ONE_TIME_FLAG
, PARENT_VENDOR_ID
, MIN_ORDER_AMOUNT
, SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_ID
, SHIP_VIA_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE
, FOB_LOOKUP_CODE
, TERMS_ID
, SET_OF_BOOKS_ID
, CREDIT_STATUS_LOOKUP_CODE
, CREDIT_LIMIT
, ALWAYS_TAKE_DISC_FLAG
, PAY_DATE_BASIS_LOOKUP_CODE
, PAY_GROUP_LOOKUP_CODE
, PAYMENT_PRIORITY
, INVOICE_CURRENCY_CODE
, PAYMENT_CURRENCY_CODE
, INVOICE_AMOUNT_LIMIT
, EXCHANGE_DATE_LOOKUP_CODE
, HOLD_ALL_PAYMENTS_FLAG
, HOLD_FUTURE_PAYMENTS_FLAG
, HOLD_REASON
, DISTRIBUTION_SET_ID
, ACCTS_PAY_CODE_COMBINATION_ID
, DISC_LOST_CODE_COMBINATION_ID
, DISC_TAKEN_CODE_COMBINATION_ID
, EXPENSE_CODE_COMBINATION_ID
, PREPAY_CODE_COMBINATION_ID
, NUM_1099
, TYPE_1099
, WITHHOLDING_STATUS_LOOKUP_CODE
, WITHHOLDING_START_DATE
, ORGANIZATION_TYPE_LOOKUP_CODE
, VAT_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, MINORITY_GROUP_LOOKUP_CODE
, PAYMENT_METHOD_LOOKUP_CODE
, BANK_ACCOUNT_NAME
, BANK_ACCOUNT_NUM
, BANK_NUM
, BANK_ACCOUNT_TYPE
, WOMEN_OWNED_FLAG
, SMALL_BUSINESS_FLAG
, STANDARD_INDUSTRY_CLASS
, HOLD_FLAG
, PURCHASING_HOLD_REASON
, HOLD_BY
, HOLD_DATE
, TERMS_DATE_BASIS
, PRICE_TOLERANCE
, 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
, OFFSET_VAT_CODE
, VAT_REGISTRATION_NUM
, AUTO_CALCULATE_INTEREST_FLAG
, VALIDATION_NUMBER
, EXCLUDE_FREIGHT_FROM_DISCOUNT
, TAX_REPORTING_NAME
, CHECK_DIGITS
, BANK_NUMBER
, ALLOW_AWT_FLAG
, AWT_GROUP_ID
, 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
, BANK_BRANCH_TYPE
, MATCH_OPTION
, FUTURE_DATED_PAYMENT_CCID
, CREATE_DEBIT_MEMO_FLAG
, OFFSET_TAX_FLAG
, PARTY_ID
, PARENT_PARTY_ID
, NI_NUMBER
, TCA_SYNC_NUM_1099
, TCA_SYNC_VENDOR_NAME
, TCA_SYNC_VAT_REG_NUM
, INDIVIDUAL_1099
, UNIQUE_TAX_REFERENCE_NUM
, PARTNERSHIP_UTR
, PARTNERSHIP_NAME
, CIS_ENABLED_FLAG
, FIRST_NAME
, SECOND_NAME
, LAST_NAME
, SALUTATION
, TRADING_NAME
, WORK_REFERENCE
, COMPANY_REGISTRATION_NUMBER
, NATIONAL_INSURANCE_NUMBER
, VERIFICATION_NUMBER
, VERIFICATION_REQUEST_ID
, MATCH_STATUS_FLAG
, CIS_VERIFICATION_DATE
, PAY_AWT_GROUP_ID
, CIS_PARENT_VENDOR_ID
, BUS_CLASS_LAST_CERTIFIED_DATE
, BUS_CLASS_LAST_CERTIFIED_BY
FROM AP.AP_SUPPLIERS;
AP.AP_SUPPLIERS does not reference any database object
AP.AP_SUPPLIERS is referenced by following:
APPS
AP_SUPPLIERS
JAI_PO_V_ARIUD_T1
POA_IDL_BS_J_MV
POA_ITEMS_MV
POA_MID_BS_J_MV
|
|
|
|