[+]
[-]
 [+]
 [+]
 [-]
   
   
   
   
   
   
   
   
   
Updated on 9/27/2019
Commissions Data Loader Publication
CDL Templates
Direct link to topic in this publication:

PREVIOUS  |  NEXT

CDL Templates


Various templates are provided to upload data to Commissions and T&Q. Each template is specific to an inbound file type and relates to a Commissions or T&Q business object.

The columns in the Excel template match the columns available in the Commissions/T&Q workspace. All the templates are available in .xls format and are downloadable from this page. Click on the template name to download the template. Ensure that the templates are filled out according to the specified guidelines. 

The following table lists and describes all the available templates.

Template NameFile Type CodeDescription
Commissions

CDL_CLCA_Template

CLCA
This template captures information about Category.
Use this to load category hierarchy.
CDL_CLCC_Template
CLCC
This template captures information about Category Classifier.
Use this to load classifiers under a category.
CDL_TXCR_Template
TXCR
This template captures information about Credit.
Use this to load manual credits.
CDL_CLCU_Template
CLCU
This template captures information about Customer.
Use this to load customer reference data.
CDL_TXDE_Template
TXDE
This template captures information about Deposit.
Use this to load manual deposits.
CDL_PLFV_Template
PLFV
This template captures information about Fixed Value.
Use this to load fixed values.
CDL_OGPO_Template
OGPO
This template captures information about Position.
Use this to load positions.
CDL_OGPOX_Template
OGPOX, OGGO
This template captures information about GA Position.
Use this to load positions with extended attributes.
CDL_OGPT_Template
OGPT
This template captures information about Participant.
Use this to load participants.
CDL_OGPTX_Template
OGPTX, OGGP
This template captures information about GA Participant.
Use this to load participants with extended attributes.
CDL_CLGC_Template
CLGC
This template captures information about Generic Classifier.
Use this to load generic classifiers.
CDL_TXOH_Template
TXOH
This template captures information about Order.
Use this to load sales order.
CDL_OGPR_Template
OGPR
This template captures information about Position Relation.
Use this to load position relation.
CDL_CLPC_Template
CLPC
This template captures information about Postal Code.
Use this to load postal code.
CDL_CLPR_Template
CLPR
This template captures information about Product.
Use this to load product.
CDL_OGTI _Template
OGTI
This template captures information about Title.
Use this to load plan titles.
CDL_TXST_Template
TXST
This template captures information about Transaction.
Use this to load transaction without any assignments.
CDL_TXSTAG_Template
TXSTAG, TXTA , TXTG
This template captures information about Transaction.
Use this to load transactions with assignments and extended attributes.

CDL_TXSTAGR_Template
TXSTAGR, TXTA ,TXTG, TXTR
This template captures information about Transaction.
Use this to load transactions with assignments, extended attributes, and reporting attributes.
CDL_TXSTAR_Template
TXSTAR, TXTA, TXTR
This template captures information about Transaction.
Use this to load transactions with assignments and reporting attributes.
CDL_TXSTG_Template
TXSTG
This template captures information about Transaction.
Use this to load transaction with extended attributes.
CDL_TXSTA_Template
TXSTA, TXTA
This template captures information about Transaction. Use this when to load transactions with assignments.
CDL_TXSTR_Template
TXSTR, TXTG, TXTR
This template captures information about Transaction.
Use this to load transactions with extended attributes and reporting attributes.
CDL_TXSTGR_Template
TXSTR
This template captures information about Transaction.
Use this to load transactions with reporting attributes.
CDL_PLVA_Template
PLVA
This template captures information about Variable Assignment. Use this to load variable assignments.
CDL_PIPELINE_Template
PIPELINE
This template captures information about Calculation Runs.
Use this to run pipeline and calculations.
CDL_PLQU_Template
PLQU
This template captures plan quota information. Use this to load plan quotas, which can be utilized in Commissons rules.
CDL_PLMC _Template
PLMC
This template captures cell values for the multidimensional lookup table. Use this to load lookup data.
CDL_FVVAMON_Template
FVVAMON
This template captures information about fixed values and variables. Use this to load fixed values variables assignments (monthly basis).
CDL_FVVAQTR_Template
FVVAQTR
This template captures information about fixed values and variables. Use this to load fixed values variables assignments (quarterly basis).
CDL_BOTRIG_Template
BOTRIG
Drop the empty file to sync data. User groups from CS_PARTICIPANT table are synced with SAP BO system. Groups are defined in one of the genericAttribute fields.
CDL_BOUPDATE_Template
BOUPDATE
This template contains add/delete operations, userid, and groupname. Use this to sync user groups with SAP BO system.
CDL_ BOEXTRACTTRIG_Template
BOEXTRACTTRIG
Drop the empty file to extract data. Data from the SAP BO system (i.e. all users associated with groups) is extracted and written to the file with the specified delimiter. 
Territory and Quota
CDL_TQAC_Template
TQAC
This template captures information about Accounts. Use this to load accounts.
CDL_TQACX_Template
TQACX, TQGAC
This template captures information about Accounts with generic attributes. Use this to load accounts with generic attributes.
CDL_TQGEO_Template
TQGEO
This template captures information about Geographies. Use this to load Geographies.
CDL_TQGEOX_Template
TQGEOX, TQGGEO
This template captures information about Geographies with generic attributes. Use this to load Geographies with generic attributes.
CDL_TQTAC_Template
TQTAC
This template captures information about TerritoryAccounts. Use this to load accounts for territory.
CDL_TQTACX_Template
TQTACX, TQGTAC
This template captures information about TerritoryAccounts with generic attributes. Use this to load accounts for territory with generic attributes.
CDL_TQTPR_Template
TQTPR
This template captures information about TerritoryProducts. Use this to load products for territory.
CDL_TQTPRX_Template 
TQTPRX, TQGTPR
This template captures information about TerritoryProducts with generic attributes. Use this to load products for territory with generic attributes.
CDL_TQTGEO_Template
TQTGEO
This template captures information about TerritoryGeographies. Use this to load geographies for territory.
CDL_TQTGEOX_Template
TQTGEOX, TQGTGEO
This template captures information about TerritoryGeographies with generic attributes. Use this to load geographies for territory with generic attributes.