Analytics Catalog/Data dictionary/POZ_SUPPLIER_SITES_ALL_M
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

POZ_SUPPLIER_SITES_ALL_M

ProcurementUsed in 56 subject areas179 reporting columns

Procurement (POZ), supplier sites (the addresses a supplier transacts from).

Primary key: VENDOR_SITE_ID

Columns

ColumnKeyIn reportsDescription (inferred)
AGING_ONSET_POINT●Aging onset point.
AGING_PERIOD_DAYS●Aging period days.
ALLOW_SUBSTITUTE_RECEIPTS_FLAG●Indicator (Y/N) for the allow substitute receipts.
ALLOW_UNORDERED_RECEIPTS_FLAG●Indicator (Y/N) for the allow unordered receipts.
ALWAYS_TAKE_DISC_FLAG●Indicator (Y/N) for the always take disc.
ATTRIBUTE1●Descriptive flexfield segment.
ATTRIBUTE10●Descriptive flexfield segment.
ATTRIBUTE11●Descriptive flexfield segment.
ATTRIBUTE12●Descriptive flexfield segment.
ATTRIBUTE13●Descriptive flexfield segment.
ATTRIBUTE14●Descriptive flexfield segment.
ATTRIBUTE15●Descriptive flexfield segment.
ATTRIBUTE16●Descriptive flexfield segment.
ATTRIBUTE17●Descriptive flexfield segment.
ATTRIBUTE18●Descriptive flexfield segment.
ATTRIBUTE19●Descriptive flexfield segment.
ATTRIBUTE2●Descriptive flexfield segment.
ATTRIBUTE20●Descriptive flexfield segment.
ATTRIBUTE3●Descriptive flexfield segment.
ATTRIBUTE4●Descriptive flexfield segment.
ATTRIBUTE5●Descriptive flexfield segment.
ATTRIBUTE6●Descriptive flexfield segment.
ATTRIBUTE7●Descriptive flexfield segment.
ATTRIBUTE8●Descriptive flexfield segment.
ATTRIBUTE9●Descriptive flexfield segment.
ATTRIBUTE_CATEGORY●Descriptive flexfield context (structure definition).
ATTRIBUTE_DATE1●Descriptive flexfield segment.
ATTRIBUTE_DATE10●Descriptive flexfield segment.
ATTRIBUTE_DATE2●Descriptive flexfield segment.
ATTRIBUTE_DATE3●Descriptive flexfield segment.
ATTRIBUTE_DATE4●Descriptive flexfield segment.
ATTRIBUTE_DATE5●Descriptive flexfield segment.
ATTRIBUTE_DATE6●Descriptive flexfield segment.
ATTRIBUTE_DATE7●Descriptive flexfield segment.
ATTRIBUTE_DATE8●Descriptive flexfield segment.
ATTRIBUTE_DATE9●Descriptive flexfield segment.
ATTRIBUTE_NUMBER1●Descriptive flexfield segment.
ATTRIBUTE_NUMBER10●Descriptive flexfield segment.
ATTRIBUTE_NUMBER2●Descriptive flexfield segment.
ATTRIBUTE_NUMBER3●Descriptive flexfield segment.
ATTRIBUTE_NUMBER4●Descriptive flexfield segment.
ATTRIBUTE_NUMBER5●Descriptive flexfield segment.
ATTRIBUTE_NUMBER6●Descriptive flexfield segment.
ATTRIBUTE_NUMBER7●Descriptive flexfield segment.
ATTRIBUTE_NUMBER8●Descriptive flexfield segment.
ATTRIBUTE_NUMBER9●Descriptive flexfield segment.
ATTRIBUTE_TIMESTAMP1●Attribute timestamp1.
ATTRIBUTE_TIMESTAMP10●Attribute timestamp10.
ATTRIBUTE_TIMESTAMP2●Attribute timestamp2.
ATTRIBUTE_TIMESTAMP3●Attribute timestamp3.
ATTRIBUTE_TIMESTAMP4●Attribute timestamp4.
ATTRIBUTE_TIMESTAMP5●Attribute timestamp5.
ATTRIBUTE_TIMESTAMP6●Attribute timestamp6.
ATTRIBUTE_TIMESTAMP7●Attribute timestamp7.
ATTRIBUTE_TIMESTAMP8●Attribute timestamp8.
ATTRIBUTE_TIMESTAMP9●Attribute timestamp9.
AUTO_CALCULATE_INTEREST_FLAG●Indicator (Y/N) for the auto calculate interest.
B2B_COMM_METHOD_CODE●Code identifying the b2b comm method.
B2B_SITE_CODE●Code identifying the b2b site.
BANK_CHARGE_DEDUCTION_TYPE●Type of bank charge deduction.
BUYER_MANAGED_TRANSPORT_FLAG●Indicator (Y/N) for the buyer managed transport.
CONSUMPTION_ADVICE_FREQUENCY●Consumption advice frequency.
CONSUMPTION_ADVICE_SUMMARY●Consumption advice summary.
COUNTRY_OF_ORIGIN_CODE●Code identifying the country of origin.
CREATED_BY●User who created the row.
CREATE_DEBIT_MEMO_FLAG●Indicator (Y/N) for the create debit memo.
CREATION_DATE●Date and time the row was created.
CUSTOMER_NUM●Customer number.
DAYS_EARLY_RECEIPT_ALLOWED●Days early receipt allowed.
DAYS_LATE_RECEIPT_ALLOWED●Days late receipt allowed.
EMAIL_ADDRESS●Email address.
ENFORCE_SHIP_TO_LOCATION_CODE●Code identifying the enforce shipment to location.
EXCLUDE_FREIGHT_FROM_DISCOUNT●Exclude freight from discount.
EXCLUDE_TAX_FROM_DISCOUNT●Exclude tax from discount.
FAX●Fax.
FAX_AREA_CODE●Code identifying the fax area.
FAX_COUNTRY_CODE●Code identifying the fax country.
FOB_LOOKUP_CODE●Lookup code for the fob.
FREIGHT_TERMS_LOOKUP_CODE●Lookup code for the freight terms.
GAPLESS_INV_NUM_FLAG●Indicator (Y/N) for the gapless inventory number.
GLOBAL_ATTRIBUTE1●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE10●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE11●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE12●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE13●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE14●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE15●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE16●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE17●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE18●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE19●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE2●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE20●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE3●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE4●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE5●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE6●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE7●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE8●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE9●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_CATEGORY●Global descriptive flexfield context (structure definition).
GLOBAL_ATTRIBUTE_DATE1●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_DATE10●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_DATE2●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_DATE3●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_DATE4●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_DATE5●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_DATE6●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_DATE7●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_DATE8●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_DATE9●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER1●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER10●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER2●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER3●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER4●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER5●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER6●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER7●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER8●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_NUMBER9●Global descriptive flexfield segment.
GLOBAL_ATTRIBUTE_TIMESTAMP1●Global attribute timestamp1.
GLOBAL_ATTRIBUTE_TIMESTAMP10●Global attribute timestamp10.
GLOBAL_ATTRIBUTE_TIMESTAMP2●Global attribute timestamp2.
GLOBAL_ATTRIBUTE_TIMESTAMP3●Global attribute timestamp3.
GLOBAL_ATTRIBUTE_TIMESTAMP4●Global attribute timestamp4.
GLOBAL_ATTRIBUTE_TIMESTAMP5●Global attribute timestamp5.
GLOBAL_ATTRIBUTE_TIMESTAMP6●Global attribute timestamp6.
GLOBAL_ATTRIBUTE_TIMESTAMP7●Global attribute timestamp7.
GLOBAL_ATTRIBUTE_TIMESTAMP8●Global attribute timestamp8.
GLOBAL_ATTRIBUTE_TIMESTAMP9●Global attribute timestamp9.
HOLD_ALL_PAYMENTS_FLAG●Indicator (Y/N) for the hold all payments.
HOLD_BY●Hold by.
HOLD_DATE●Hold date.
HOLD_FLAG●Indicator (Y/N) for the hold.
HOLD_FUTURE_PAYMENTS_FLAG●Indicator (Y/N) for the hold future payments.
HOLD_REASON●Hold reason.
HOLD_UNMATCHED_INVOICES_FLAG●Indicator (Y/N) for the hold unmatched invoices.
INACTIVE_DATE●Inactive date.
INSPECTION_REQUIRED_FLAG●Indicator (Y/N) for the inspection required.
INVOICE_AMOUNT_LIMIT●Invoice amount limit.
INVOICE_CHANNEL●Invoice channel.
INVOICE_CURRENCY_CODE●Currency code for the invoice.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATE●Date and time the row was last updated (the incremental-extract key).
MATCH_OPTION●Match option.
MODE_OF_TRANSPORT●Mode of transport.
PAYMENT_CURRENCY_CODE●Currency code for the payment.
PAYMENT_PRIORITY●Payment priority.
PAY_DATE_BASIS_LOOKUP_CODE●Lookup code for the pay date basis.
PAY_GROUP_LOOKUP_CODE●Lookup code for the pay group.
PAY_ON_CODE●Code identifying the pay on.
PAY_ON_RECEIPT_SUMMARY_CODE●Code identifying the pay on receipt summary.
PAY_ON_USE_FLAG●Indicator (Y/N) for the pay on use.
PAY_SITE_FLAG●Indicator (Y/N) for the pay site.
PCARD_SITE_FLAG●Indicator (Y/N) for the pcard site.
PO_ACK_REQD_CODE●Code identifying the purchase order ack reqd.
PO_ACK_REQD_DAYS●Purchase order ack reqd days.
PRC_BU_ID●Identifier for the procurement business unit.
PRIMARY_PAY_SITE_FLAG●Indicator (Y/N) for the primary pay site.
PURCHASING_HOLD_REASON●Purchasing hold reason.
PURCHASING_SITE_FLAG●Indicator (Y/N) for the purchasing site.
QTY_RCV_EXCEPTION_CODE●Code identifying the quantity receiving exception.
QTY_RCV_TOLERANCE●Quantity receiving tolerance.
RECEIPT_DAYS_EXCEPTION_CODE●Code identifying the receipt days exception.
RECEIPT_REQUIRED_FLAG●Indicator (Y/N) for the receipt required.
RECEIVING_ROUTING_ID●Identifier for the receiving routing.
RFQ_ONLY_SITE_FLAG●Indicator (Y/N) for the rfq only site.
SELLING_COMPANY_IDENTIFIER●Selling company identifier.
SERVICE_LEVEL●Service level.
SUPPLIER_NOTIF_METHOD●Supplier notif method.
TAX_REPORTING_SITE_FLAG●Indicator (Y/N) for the tax reporting site.
TERMS_DATE_BASIS●Terms date basis.
TERMS_ID●Identifier for the terms.
VAT_CODE●Code identifying the vat.
VAT_REGISTRATION_NUM●Vat registration number.
VENDOR_SITE_CODE●Code identifying the vendor site.
VENDOR_SITE_CODE_ALT●Vendor site code alt.
VENDOR_SITE_IDPK●Identifier for the vendor site.

5 reports read from this table

Change a column here and these are the reports that move with it, the blast radius for any change to POZ_SUPPLIER_SITES_ALL_M.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.

Need the extract + dbt staging for POZ_SUPPLIER_SITES_ALL_M?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
Payables does not tie · Three-way match does not tie · The export ceiling