[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 your supplier level attributes. Each row includes the purchasing, receiving, invoice, tax, classification, and general information. Oracle Purchasing uses this information to determine active suppliers. This table replaces the old PO_VENDORS 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.
| 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
|
| AP_SUPPLIERS_N7 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UPPER("VENDOR_NAME")
|
| AP_SUPPLIERS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INDIVIDUAL_1099
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| VENDOR_ID | NUMBER | Yes | Supplier unique identifier | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| VENDOR_NAME | VARCHAR2 | (240) | Supplier name | |
| VENDOR_NAME_ALT | VARCHAR2 | (320) | Alternate supplier name for kana value | |
| 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 | ||
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| EMPLOYEE_ID | NUMBER | Employee unique identifier if the supplier is an employee | ||
| VENDOR_TYPE_LOOKUP_CODE | VARCHAR2 | (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 | |
| 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) | Type of payment date basis | |
| PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | Payment group type | |
| PAYMENT_PRIORITY | NUMBER | Payment priority | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Default currency unique identifier | |
| PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | Default payment currency unique identifier | |
| 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 | Distribution set unique identifier | ||
| ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | 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 | Unique identifier for the general ledger account for prepayment | ||
| NUM_1099 | VARCHAR2 | (30) | Tax identification number | |
| TYPE_1099 | VARCHAR2 | (10) | Type of 1099 | |
| WITHHOLDING_STATUS_LOOKUP_CODE | VARCHAR2 | (25) | Withholding status type | |
| WITHHOLDING_START_DATE | DATE | Withholding start date | ||
| ORGANIZATION_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | IRS organization type | |
| VAT_CODE | VARCHAR2 | (30) | VAT code | |
| START_DATE_ACTIVE | DATE | Key flexfield start date | ||
| END_DATE_ACTIVE | DATE | Key flexfield end date | ||
| MINORITY_GROUP_LOOKUP_CODE | VARCHAR2 | (30) | Type of minority-owned business | |
| PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | (25) | Default payment method type | |
| 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) | Type of invoice payment schedule basis | |
| 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 | |
| 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 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 exclusive payment | |
| AP_TAX_ROUNDING_RULE | VARCHAR2 | (1) | No Longer Used | |
| AUTO_TAX_CALC_FLAG | VARCHAR2 | (1) | Supplier level where the tax calculation is done | |
| 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 | ||
| NAME_CONTROL | VARCHAR2 | (4) | Name control | |
| STATE_REPORTABLE_FLAG | VARCHAR2 | (1) | State reportable flag | |
| FEDERAL_REPORTABLE_FLAG | VARCHAR2 | (1) | Federal reportable flag | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield segment | |
| 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 | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
| 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) | Exclude supplier freight from discount amount | |
| TAX_REPORTING_NAME | VARCHAR2 | (80) | Tax reporting method name | |
| CHECK_DIGITS | VARCHAR2 | (30) | Check number used by Payables | |
| BANK_NUMBER | VARCHAR2 | (30) | No longer used | |
| ALLOW_AWT_FLAG | VARCHAR2 | (1) | Indicator of whether Allow Withholding Tax is enabled | |
| AWT_GROUP_ID | NUMBER | (15) | 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) | Indicator of whether this supplier bears bank charges | |
| 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) | Indicator of whether a debit memo should be created | |
| OFFSET_TAX_FLAG | VARCHAR2 | (1) | Indicator of whether 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) | Unique Tax Reference Number of the partnership | |
| PARTNERSHIP_NAME | VARCHAR2 | (240) | Partnership name | |
| CIS_ENABLED_FLAG | VARCHAR2 | (1) | CIS enabled flag | |
| FIRST_NAME | VARCHAR2 | (240) | First name of the Subcontractor | |
| SECOND_NAME | VARCHAR2 | (240) | Second name of the Subcontractor | |
| LAST_NAME | VARCHAR2 | (240) | Last name of the Subcontractor | |
| SALUTATION | VARCHAR2 | (30) | Salutation of the subcontractor | |
| TRADING_NAME | VARCHAR2 | (240) | Trading name of the Subcontractor | |
| WORK_REFERENCE | VARCHAR2 | (30) | Work reference of the Subcontractor | |
| COMPANY_REGISTRATION_NUMBER | VARCHAR2 | (30) | Company registration number | |
| NATIONAL_INSURANCE_NUMBER | VARCHAR2 | (30) | National Insurance number of the subcontractor | |
| VERIFICATION_NUMBER | VARCHAR2 | (30) | Verification Number returned by HMRC for the subcontractor | |
| VERIFICATION_REQUEST_ID | NUMBER | (15) | Verification concurrent request identifier | |
| MATCH_STATUS_FLAG | VARCHAR2 | (1) | Match status code returned by HMRC | |
| CIS_VERIFICATION_DATE | DATE | Date the subcontractor was verified | ||
| PAY_AWT_GROUP_ID | NUMBER | (15) | Payment Withholding Group ID | |
| CIS_PARENT_VENDOR_ID | NUMBER | CIS Parent Vendor ID | ||
| BUS_CLASS_LAST_CERTIFIED_DATE | DATE | Last Certified Date | ||
| BUS_CLASS_LAST_CERTIFIED_BY | NUMBER | Last Certified By |
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:
AP
AP_SUPPLIERS#
|
|
|
|