Topics: |
Important: This data model is used as the base for Supplier reporting built into WebFOCUS. Any modifications made to this model will impact any related reporting. Only additions should be made to this data model. Labels can be created in WebFOCUS to change any attribute name.
The Omni-Gen™ for Supplier data model includes the following subjects:
The SUPPLIER subject identifies basic master data about suppliers such as name, trade prohibition indicator, ownership type, and social security number/tax identification number.
SUPPLIER subject attributes include:
Name |
Description |
---|---|
first_name |
The first name for a supplier party. |
middle_name |
The middle name for a supplier party. |
last_name |
The last name for a supplier party. |
full_name |
The full name for a vendor party, such as when a person is providing services as a supplier. |
company_name |
The legally identified name for a supplier organization. |
dba_name |
The doing business as name for a supplier organization. |
trade_prohibi_ind |
A Y/N indicator that identifies a trade prohibition for a given supplier such as statutory or administrative debarment. |
primary_geographic_area |
The primary geographic area (e.g., region, branch, store, sales region) assigned to the supplier. |
credit_rating |
The classification of a vendor into a range of credit ratings (for example, High Risk, Moderate Risk, or Low Risk). |
vendor_pay_priority |
The priority ranking for a given vendor in relation to their invoice payment. For example, High, Standard, or Low. |
ownership_type |
The classification of a vendor into an ownership type, such as women owned, minority owned, or Indian owned. |
legal_class_type |
The type of business, such as nonprofit, limited partnership, trust, or sole proprietor. |
prim_sales_org |
The primary sales organization assigned to a supplier. |
The SUPPLIER ALTERNATE ID subject identifies any alternate identifiers for the supplier.
SUPPLIER ALTERNATE ID subject attributes include:
Name |
Description |
---|---|
supplier_iden_type |
The type of alternate identifier assigned to the entire supplier, such as Commercial and Government Entity (CAGE), NATO Supply Code For Manufacturers (NSCM), or Data Universal Number System (DUNS). For an individual supplier, this could be their passport number or driver's license. |
alt_identifier_id |
The alternate identifier for the supplier. |
issuing_country |
The country issuing the alternate identifier. |
supplier_iden_active |
A Y/N indicator identifying whether the alternate identifier is active. |
The SUPPLIER ITEM subject maps the item identifier of the enterprise to the item identifier and item name of the supplier.
SUPPLIER ITEM subject attributes include:
Name |
Description |
---|---|
item_id |
The item identifier of the enterprise. |
sup_item_id |
The item identifier of the supplier for the item of the enterprise. |
sup_item_name |
The name for the item of the supplier. |
supp_item_start_dt |
The start date for the item of the supplier. |
supp_item_end_dt |
The end date for the item of the supplier. |
The ADDRESS subject identifies address data including address type, time zone, and geographic area. The geographic area can represent a division, branch, department, or other geographical grouping of a company used for reporting purposes.
ADDRESS subject attributes include:
Name |
Description |
---|---|
address_type |
The type of address, such as corporate, sold to, ship to, or bill to. |
primary_ind |
A Y/N indicator identifying the primary address for a supplier. |
address_status |
The current status for an address. |
attn_to_contact |
The name of the attention to contact portion of the address. |
street_address1 |
The first line of the street address portion of the address associated to a supplier party. |
street_address2 |
The second line of the street address portion of the address associated to a supplier party. |
city |
The city portion of the address associated to a supplier party. |
state_territory |
The state or territory portion of the address associated to a supplier party. |
county |
The county portion of the address associated to a supplier party. |
country |
The country portion of the address associated to a supplier party. |
postal_code |
The zip or postal code portion of the address associated to a supplier party. |
time_zone |
The time zone associated with the address. |
address_geo_area |
The geographic area associated with the address. For example, the address may be located in a specific sales region. |
latitude |
The geospatial latitude for an address. |
longitude |
The geospatial longitude for an address. |
CAGE_cd |
Commercial and Governmental Entity code assigned to the location or address of the supplier. |
The ADDRESS_DUNS subject identifies the DUNS numbers associated with an address. Note that the DUNS number can be assigned to the supplier, address, or address DUNS levels of the model.
ADDRESS_DUNS subject attributes include:
Name |
Description |
---|---|
CAGE_cd |
Commercial and Governmental Entity code assigned to the DUNS number of the supplier. |
DUNS_Number |
The Dun and Bradstreet Data Universal numbering system number assigned to a supplier. |
The VENDOR PURCHASE ORDER subject identifies general master data about the vendor purchase order such as bill to customer, sales order date, and order priority. Several attributes are available for comparison such as requested ship to address, ship date, order quantity, and committed/actuals. Metrics are available for the order fill rate and return rate.
VENDOR PURCHASE ORDER subject attributes include:
Name |
Description |
---|---|
fulfill_supp_id |
The unique identifier for the fulfilling supplier. |
vendor_po_type |
The type of purchase order such as standard, blanket, or standing. |
vendor_po_date |
The date the purchase order was placed. |
req _st_street |
The purchase orders requested ship to street address. |
req_sh_city |
The purchase orders requested ship to city. |
req_sh_state |
The purchase orders requested ship to state/territory. |
req_sh_zip |
The purchase orders requested ship to zip/postal code. |
req_sh_country |
The purchase orders requested ship to country. |
rec_st_street |
The actual ship to street address used for shipment of a purchase order's goods. |
rec_st_city |
The actual ship to city used for shipment of a purchase order's goods. |
rec_st_state |
The actual ship to state/territory used for shipment of a purchase order's goods. |
rec_st_zip |
The actual ship to zip/postal code used for shipment of a purchase order's goods. |
rec_st_country |
The actual ship to country used for shipment of a purchase order's goods. |
req_ship_dt |
The requested ship date of the purchase order. |
cmt_ship_dt |
The ship date committed to by the purchase order's vendor. |
act_ship_dt |
The actual date that goods shipped for the purchase order. |
order_priority |
The order priority assigned to a purchase order. |
order_status |
The status assigned to a purchase order. |
sold_sales_org |
The sales organization that will be responsible for this purchase. |
related_contract |
The contract that covers all purchases made under a vendor purchase order. |
The VENDOR PURCHASE ORDER LINE identifies the line items of the purchase order. This details the item ordered, quantity, delivery date requested, and expected unit price. There are several attributes provided for reporting, such as being able to compare requested, committed, and actual delivery dates, delivered versus returned item quantities, and expected, invoiced, and paid amounts.
VENDOR PURCHASE ORDER LINE subject attributes include:
Name |
Description |
---|---|
requested_item_id |
The item requested on a purchase order line. |
requested_item_qty |
The requested quantity of an item. |
committed_item_id |
The item committed to be provided on a purchase order. This can differ from the requested product. |
committed_item_qty |
The committed quantity of an item. |
requested_delivery_dt |
The date requested for delivery. |
committed_delivery_dt |
The committed date for delivery of the enterprise. |
actual_delivery_dt |
The actual date of the delivery. |
delivered_item_id |
The item actually delivered on a purchase order line. This can differ from the committed item. |
delivered_item_qty |
The delivered quantity of an item. |
returned_item_id |
The returned item applied against this purchase order line. Depending on the return policy of the enterprise, this item can differ from the delivered item. |
returned_item_qty |
The returned quantity of an item. |
po_ln_uom |
The unit of measure for quantities on the purchase order line. |
unit_pri_amt |
The unit price expected for the requested item. |
invoiced_unit_pri_amt |
The invoiced unit price amount. |
paid_unit_amt |
The amount actually paid per unit for an item. |
r_sales_org_id |
The sales organization responsible for the purchase order line. |
vendor_po_ln_dt |
The creation date for the purchase order line. |
po_ln_status |
The status of the purchase order line. |
po_ln_contract |
The contract that covers the item on the purchase order line. |
The ITEM table identifies the products and/or services that can be provided by a supplier.
ITEM subject attributes include:
Name |
Description |
---|---|
item_name |
The type of phone number, such as home, office, FAX, or mobile. |
item_short_desc |
The short description for an item. |
item_long_desc |
The long description for an item. |
key_item_ind |
A Yes/No flag identifying whether an item is included in the major products tracked by the company. |
item_base_uom |
The standard/base unit of measure for an item. For a service, this will identify the billing unit of measure such as hour, day, or per job. |
item_base_cost |
The base cost amount for an item. |
item_base_price |
The base price for a base unit of measure of an item |
item_sku |
The stock keeping unit for an item. |
item_barcode |
The barcode for an item. |
item_gtin |
The global trade item number for an item. |
item_start_dt |
The date that an item became effective. |
item_end_dt |
The end date for an item. |
item_eol_dt |
The end of life date for an item. |
item_type |
The type of item such as Product or Service. Groupings or hierarchy levels below this are maintained in Omni Grouping. |
The ITEM ALTERNATE ID table identifies any alternate identifiers for the item.
ITEM ALTERNATE ID subject attributes include:
Name |
Description |
---|---|
item_alt_id_type |
The type of identifier such a global product identifier, CAS number, or EINECS number. |
item_alt_id_value |
The alternate identifier value of the item. |
item_alt_id_active_ind |
A Y/N indicator identifying whether the alternate ID of the item is active |
The SALES ORG table identifies any level sales organization of the enterprise such as a division, branch, or region.
SALES ORG subject attributes include:
Name |
Description |
---|---|
sales_org_name |
The name for the sales organization. |
sales_org_desc |
The description of the sales organization. |
sales_org_start_dt |
The start date for a sales organization. |
sales_org_end_dt |
The end date for a sales organization. |
primary_geo_area |
The primary geographical area assigned to a sales organization. |
The CONTRACT table identifies any contract or agreement that is related to purchasing of items and/or services.
CONTRACT subject attributes include:
Name |
Description |
---|---|
contract_signed_dt |
The date on which a contract was signed. |
contract_st_dt |
The start date for a contract. |
contract_end_dt |
The actual end date for a contract. |
contract_renew_dt |
The next renewal date for a contract. |
expected_expire_dt |
The estimated expiration date for a contract. |
prim_supplier |
The primary supplier providing products or services through the contract. |
contract_status |
The current status of a contract. |
contract_type |
The type of contract such as cooperative merchandising agreement, subscription, warranty, service contract, or purchasing agreement. |
The CONTRACT LINE table identifies each of the line items on a contract. The line item level identifies the items or services covered by the contract and any associated minimum, maximum, or mandatory quantities to be purchased.
CONTRACT LINE attributes include:
Name |
Description |
---|---|
contract_ln_st_dt |
The start date for a contract line. |
contract_ln_end_dt |
The end date for a contract line. |
contract_item_id |
The identifier of an enterprise for the item covered on a contract line. |
contract_item_price |
The expected price for a single unit of measure of the ordered item. |
contract_item_uom |
The unit of measure for the quantities of the item. For a Service, this could be the per hour, day, or job unit of measure for example. |
min_purchase_qty |
The minimum purchase quantity for a contract line item. |
max_purchase_qty |
The maximum purchase quantity for a contract line item. |
item_list_price |
The list price for an item at the time of the contract line creation. |
list_price_discount_percent |
The discount percentage associated with a contract line. |
term_text |
The textual description of the terms of the contract line such as Net 30, 2/10 Net 30, EOM, or 15 MFI. |
contract_sla_text |
The textual description of the service level agreement for the contract such as meantime to recover, turnaround time or first call resolution time. |
contract_ln_status |
The current status of the contract line. |
mandatory_purchase_qty |
The mandatory amount of an item that is required to be purchased during the effective period of the contract line. |
The INVOICE table identifies any invoice received from a supplier. Any overall charges, such as shipping and handling charges, can be tracked at this header level of the invoice along with any overall discount that is applied to the entire invoice.
INVOICE attributes include:
Name |
Description |
---|---|
invoice_dt |
The date on which an invoice was issued. |
invoice_contract_id |
The contract that covers the items on an invoice. |
invoice_status |
The current status of an invoice. |
invoice_supplier |
The supplier submitting the invoice. |
invoice_type |
The type of invoice such as Draft, Prepayment, or Standard. |
invoice_shipment_amt |
The amount charged for shipment costs related to the invoice. |
invoice_handling_amt |
The amount charged for handling costs related to the invoice. |
invoice_discount_amt |
The discount amount allowed for an entire invoice. |
invoice_level_payment_amt |
Any payment amount that was posted to the entire invoice. Payments can also be posted at the line item level. |
invoice_related po |
The vendor purchase order related to an invoice. |
The INVOICE LINE table identifies each of the line items on an invoice. The line item level identifies the items or services covered by the invoice and the associated quantities and prices. It can also be used to track and compare the billed, adjustments, discounts, and actual payment amounts.
INVOICE LINE attributes include:
Name |
Description |
---|---|
invoice_item_id |
The item that is billed for on the invoice line. |
invoice_item _qty |
The quantity of an item that is covered by an invoice line. |
invoice_item_uom |
The unit of measure to be used for the invoice line quantity. |
invoice_item_price |
The price per unit to be used for the invoice line quantity. |
item_list_price |
The list price effective for an item on an invoice line. |
invoice_item_adjust_amt |
The amount of adjustments taken against an invoice line. |
invoice_item_discount_amt |
The amount of discounts taken against an invoice line. |
invoice_item_paid_amt |
The amount paid against an invoice line. |
invoice_adjust_reason |
The reason that an adjustment was taken against the invoice line. |
invoice_discount_reason |
The reason that a discount was taken against an invoice line. |
invoice_ln_status |
The status of the invoice line. |
invoice_ln_related_po |
The vendor purchase order related directly to an invoice line. |
invoice_ln_contract |
The contract whose terms and conditions cover the invoice line item. |
The ACCOUNT table identifies any financial accounts associated with the supplier. This part of the model can be used to track dates, credit limits, and credit ratings associated with each account.
ACCOUNT attributes include:
Name |
Description |
---|---|
account_type |
The item that is billed for on the invoice line. |
account_name |
The quantity of an item that is covered by an invoice line. |
account_open_dt |
The unit of measure to be used for the invoice line quantity. |
account_renew_dt |
The price per unit to be used for the invoice line quantity. |
account_close_dt |
The list price effective for an item on an invoice line. |
credit_limitt |
The amount of adjustments taken against an invoice line. |
credit_rating |
The amount of discounts taken against an invoice line. |
credit_terms |
The amount paid against an invoice line. |
The ACCOUNT TEAM table identifies any members of the enterprise which are assigned to the supplier.
ACCOUNT TEAM attributes include:
Name |
Description |
---|---|
current_ind |
A Y/N indicator identifying whether this team is the most current one assigned. |
credit_rep |
The person assigned as credit representative for the supplier. |
direct_sales_rep |
The person assigned as the direct sales representative for the supplier. |
account_exec |
The person assigned as the account executive for the supplier. |
account_team_start_dt |
The start date for the account team assignment. |
account_team_end_dt |
The end date for the account team assignment. |
The CONTACT table identifies any significant contacts associated with the supplier. The person name and primary contact type can be tracked.
CONTACT attributes include:
Name |
Description |
---|---|
primary_ind |
A Y/N indicator identifying whether this is the primary contact for the supplier. |
contact_type |
The primary type associated to the contact such as buyer, accounts receivable, or delivery receipt. |
title |
The title for the contact such as Mr., Dr., Mrs., or Ms. |
first_name |
The first name of the contact |
middle_name |
The middle name of the contact. |
last_name |
The last name of the contact. |
full_name |
The full name of the contact. This is usually a combination of the first name, middle name and last name. |
The PHONE subject identifies the phone number for the supplier such as home, office, FAX, or mobile.
PHONE subject attributes include:
Name |
Description |
---|---|
primary_ind |
A Y/N indicator identifying the primary phone number for a supplier. |
active_ind |
A Y/N indicator identifying the phone number is currently active. |
phone_type |
The type of phone number, such as home, office, FAX, or mobile. |
phone_number |
The actual digits of the phone number. |
extension |
The extension portion of the phone number. |
comm_status |
The current status of the phone number such as unconfirmed, opt-in, or opt-out. |
The EMAIL subject identifies the email address for the supplier, such as personal or business.
EMAIL subject attributes include:
Name |
Description |
---|---|
primary_ind |
A Y/N indicator identifying whether this is the primary email for a supplier. |
email_type |
The actual value of the email address. |
comm_status |
The type of email address, such as personal or business. |
email_address |
The status of an email address such as unconfirmed, opt-in, or opt-out. |
Omni-Gen™ for Supplier also includes the following reference tables.
These reference tables contain the acceptable list of values for the codes that appear on the main tables in the data model. Each reference table has sample values included.