Oracle Fusion · Data dictionary
POZ_SUPPLIERS
ProcurementUsed in 75 subject areas145 reporting columns
Procurement (POZ) — the supplier master.
Primary key: VENDOR_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALLOW_AWT_FLAG | ● | Indicator (Y/N) for the allow awt. | |
| 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_TAX_CALC_OVERRIDE | ● | Auto tax calc override. | |
| BC_NOT_APPLICABLE_FLAG | ● | Indicator (Y/N) for the bc not applicable. | |
| BUSINESS_RELATIONSHIP | ● | Business relationship. | |
| CORPORATE_WEBSITE | ● | Corporate website. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CREATION_SOURCE | ● | Creation source. | |
| CUSTOMER_NUM | ● | Customer number. | |
| DATAFOX_COMPANY_ID | ● | Identifier for the datafox company. | |
| DENIED_PARTY_FLAG | ● | Indicator (Y/N) for the denied party. | |
| DF_COMPANY_NAME | ● | Name of the df company. | |
| DF_CORPORATE_WEBSITE | ● | Df corporate website. | |
| DF_INDUSTRY_CATEGORY_CODE | ● | Code identifying the df industry category. | |
| DF_INDUSTRY_SUB_CATEGORY_CODE | ● | Code identifying the df industry sub category. | |
| DF_LAST_SYNC_DATE | ● | Df last sync date. | |
| DF_LEGAL_NAME | ● | Name of the df legal. | |
| DF_NAICS_CODE | ● | Code identifying the df naics. | |
| DF_SCORE | ● | Df score. | |
| DF_TAXPAYER_COUNTRY | ● | Df taxpayer country. | |
| END_DATE_ACTIVE | ● | End date active. | |
| FEDERAL_REPORTABLE_FLAG | ● | Indicator (Y/N) for the federal reportable. | |
| 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. | |
| INCOME_TAX_ID_FLAG | ● | Indicator (Y/N) for the income tax id. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| NAME_CONTROL | ● | Name control. | |
| NI_NUMBER_FLAG | ● | Indicator (Y/N) for the ni number. | |
| OBN_MATCHED_STATUS | ● | Status of the obn matched. | |
| ONE_TIME_FLAG | ● | Indicator (Y/N) for the one time. | |
| ORGANIZATION_TYPE_LOOKUP_CODE | ● | Lookup code for the organization type. | |
| REVIEW_TYPE | ● | Type of review. | |
| SEGMENT1 | ● | Segment1. | |
| SPEND_AUTH_REVIEW_STATUS | ● | Status of the spend auth review. | |
| STANDARD_INDUSTRY_CLASS | ● | Standard industry class. | |
| START_DATE_ACTIVE | ● | Start date active. | |
| STATE_REPORTABLE_FLAG | ● | Indicator (Y/N) for the state reportable. | |
| TAXPAYER_COUNTRY | ● | Taxpayer country. | |
| TAX_REPORTING_NAME | ● | Name of the tax reporting. | |
| TAX_VERIFICATION_DATE | ● | Tax verification date. | |
| TYPE_1099 | ● | Type 1099. | |
| VAT_CODE | ● | Code identifying the vat. | |
| VENDOR_ID | PK | ● | Identifier for the vendor. |
| VENDOR_TYPE_LOOKUP_CODE | ● | Lookup code for the vendor type. |
28 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_SUPPLIERS.
- Oracle Fusion AP Aging Report
- Spain SII Report
- AP Invoice Detail Report with Tax Details
- AP Disbursements Report
- AP Invoice Detail Report
- Supplier Balance by Account Report
- Withholding Tax by Supplier Report
- Payables Invoice Aging Report
- Payables Invoice Register
- Payables Invoice Audit Listing
- Payables Credit Memo Matching Report
- Payables Key Indicators Report
- Payables Negative Supplier Balance Report
- Supplier Balance Aging Report
- Payables Payment Register
- Escheated Payments Listing Report
- Payables Trial Balance Report
- Prepayment Remittance Notice
- Payables Withholding Tax Report
- Payables Withholding Tax Letter
- US 1099 Report
- US 1099 Payments Report
- US 1099 Invoice Exceptions Report
- US 1099 Supplier Exceptions Report
- US 1096 Report
- US 1099 Electronic Media Report
- Netting Settlement Letter
- Netting Reversal Letter
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.
- Costing - Cost Accounting Real Time
- Costing - Landed Costs Real Time
- Costing - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
- Costing - Standard Cost Real Time
- Costing - Transfer Order Receipt Landed Cost Charges Real Time
- Enterprise Quality Actions Real Time
- Enterprise Quality Issues Real Time
- Fiscal Document Capture Transactions Real Time
- Fiscal Document Holds Real Time
- Fiscal Document Item Deliveries Real Time
- Interfaced Fiscal Document Real Time
- Inventory - Inventory Balance Real Time
- Inventory - Inventory Supply Real Time
- Inventory - Kanban Activity Real Time
- Payables Invoices - Holds Real Time
- Payables Invoices - Installments Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Payables Invoices - Trial Balance Real Time
Need the extract + dbt staging for POZ_SUPPLIERS?
We ship parameterized SQL, BICC config, and dbt models you own.