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