Transformation Guide

Back Next

Defining the Source File

The transaction file is a flat file source that contains the prices to update in the database. Each row has a code that defines whether the prices are wholesale, retail, or manufacturer prices. The source file name is PPrices.dat.

You can create a PPrices.dat file in Srcfiles that contains the following rows:

100,M,100,110
100,W,120,200
100,R,130,300
200,M,210,400
200,W,220,500
200,R,230,600
300,M,310,666
300,W,320,680
300,R,330,700

You can import the PPrices.dat file to create the PPrices source definition in the repository.

The PPrices file contains the following columns:

Column	Datatype	Precision	Description
ProductID	String	10	A unique number that identifies the product to update.
PriceCode	String	2	M, W, or R. Defines whether the prices are Manufactured, Wholesale, or Retail prices.
UnitPrice	Number	10	The price for each unit of the product.
PkgPrice	Number	10	The price for a package of the product.

Rename Saved Search

Table of Contents

Transformation Guide

Transformation Guide

Defining the Source File

Defining the Source File