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.
Problems that run through this table