Loading Data Map Templates for JD-NET

A JD-NET data map template represents the mapping of the fields contained within the sales data files and the fields contained within the Fixed Reports repository. Because of the nature of JD-NET sales data, a separate Fixed Reports repository is used, employing a narrow table structure. See the Veeva CRM Data Model Guide for information on the Sales_Incremental_Transaction_vod object mirroring the Fixed Reports repository for JD-NET.

Data is not loaded into the Sales_Incremental_Transaction_vod object as this object exists for reference purposes only.

Like other Data_Map_Template_vod records, a JD-NET Data_Map_Template_vod record can be manually created from the Data Map Templates tab. Fewer fields are required for JD-NET specific sales data files as the control (CTL) files used to process the sales data files are used to drive many of the processing options. 

Field

Description

Data Map Template Name

The Name of the Data Map Template. If the Data_Map_Template_vod record is active, then this name must be unique.

Column Labels Included

Not used for JD-NET specific sales data files.

Column Label

Not used for JD-NET specific sales data files.

Second Column Label

Not used for JD-NET specific sales data files.

Formulary for Rep Label

Not used for JD-NET specific sales data files.

Buckets

Not used for JD-NET specific sales data files.

Scale

This is a required field in the user interface, but is not used for JD-NET specific sales data files. Select Weekly to proceed.

Active

Determines if the Data_Map_Template_vod is available for selection in the Analytics Admin page.

Column Labels Included?

Not used for JD-NET specific sales data files.

Payer/Plan Mapped?

Not used for JD-NET specific sales data files.

Markets Mapped?

Not used for JD-NET specific sales data files.

Territory Names Included?

Not used for JD-NET specific sales data files.

Override_Account_Threshold

Not used for JD-NET specific sales data files.

Decimal Places

Not used for JD-NET specific sales data files.

Contains Goals

Not used for JD-NET specific sales data files.

Incremental

Defines the file as a JD-NET sales data file.