CTF Vendors component: install and configure

Edit online

To configure vendors, install the CTF-Vendors component and upload data from your organization's vendor master data file. The CTF-Vendors component is not installed automatically with the standard Costing Standard project. The data to populate the Vendor Master Data table in the Costing Standard application typically comes from the vendor master data file in your organization's financial application such as Oracle Financials or SAP ERP Financials.

About the keys

The keys for the Vendor Master Data table are all pre-defined and should not be altered.

Key	Based on	Logic
Cost Source_Vendor Key	Vendor ID Cost Source Key Metafield	Append the text CS_Vendor with the Vendor ID field and the Cost Source Key Metafield.
Vendor_ITRT Key	Vendor CSP KeyIT Resource TowerIT Resource Subtower	IF Vendor_CSP Key = Vendor_CSP_null THEN Append the text Vendor_ITRT with IT Resource Tower and IT Resource Sub-tower ELSE Set the text to Vendor_ITRT_null
Vendor_CSP Key	Is CSP Vendor Name	IF Is CSP = yes THEN Append the text Vendor_CSP with the Vendor Name ELSE Set the text to Vendor_CSP_null

Key

Based on

Logic

Cost Source_Vendor Key

Vendor ID

Cost Source Key

Metafield

Append the text CS_Vendor with the Vendor ID field and the Cost Source Key Metafield.

Vendor_ITRT Key

Vendor CSP KeyIT Resource TowerIT Resource Subtower

Vendor_CSP Key = Vendor_CSP_null

THEN

Append the text Vendor_ITRT with IT Resource Tower and IT Resource Sub-tower

ELSE

Set the text to Vendor_ITRT_null

Vendor_CSP Key

Is CSP

Vendor Name

Is CSP = yes

THEN

Append the text Vendor_CSP with the Vendor Name

ELSE

Set the text to Vendor_CSP_null

Install the component

The CTF - Vendors component is not installed with the standard Costing Standard project.

To install the CTF - Vendors component:

Open the Costing Standard project.
Click the Project tab.
Click Components in the Ribbon.
Click the CTF - Vendors component.
Click Install.

Typical data sources

Vendor figures usually are pulled from a general ledger.

Uploads

Typically, you upload a single vendor table that is appended to the Vendor Master Data table. The data set must contain fields that can be mapped to the appropriate fields in the Vendor Master Data table.

Populate the master data set

There is one master data set associated with the CTF - Vendors component: Vendor Master Data

Required and recommended fields

The required and recommended fields needed to light up the standard Vendor reports are listed below.

Is CSP (required)
IT Resource Sub-Tower (required)
IT Resource Tower (required)
Vendor Function (required)
Vendor ID (required)
Vendor Manager (recommended)
Vendor Name (required)
Vendor Service (recommended)
Vendor Type (required)