Sales Campaigns Parameters

P1

Gross Line Total

P82

Line Amount (VAT Included)

P2

Remaining Total (Excl. Surcharges)

P3

Net Line Amount

P4

Line Quantity (Unit used)

P5

Line Quantity (Main Unit)

P6

Line Additional Tax Amount

P7

Remaining Amount (Distributed Discount and Promotions)

P8

Total Quantity of Goods Received from AR/AP (Main Unit)

P11

Total Quantity of Goods Issued to AR/AP (Main Unit)

P14

Total Net Amount of Goods Received from AR/AP

P15

Total Net Amount of Goods Issued to AR/AP

P49

Line Width (Unit Used)

P50

Line Width (Main Unit)

P51

Line Length (Unit Used)

P52

Line Length (Main Unit)

P53

Line Height (Unit Used)

P54

Line Height (Main Unit)

P55

Line Area (Unit Used)

P56

Line Area (Main Unit)

P57

Line Volume (Unit Used)

P58

Line Volume (Main Unit)

P59

Line Weight (Unit Used)

P60

Line Weight (Main Unit)

P75

Unit Price (Unit in Line)

P76

Unit Price (Main Unit)

P101

Material Code

P114

Material Aux. Code

P118

Material Aux. Code2

P119

Material Aux. Code3

P120

Material Aux. Code4

P121

Material Aux. Code5

P115

Material Auth. Code

P77

Material Purchase VAT Rate (%)

P78

Material Sales VAT Rate (%)

P79

Material Return VAT Rate (%)

P80

Material Retail Sales VAT Rate (%)

P81

Material Retail Sales Return VAT Rate (%)

P102

Transaction Aux. Code

P103

Delivery Code

P104

Line Payment Plan Code

P20

Gross Total

P83

Gross Total (VAT Included)

P21

Line Amount Excluding Surcharges

P22

Discounted Lines Total

P23

Line Discounts Total

P24

Line Surcharges Total

P25

Quantity Total (Unit Used)

P26

Quantity Total (Main Unit)

P29

Line Additional Tax Amounts Total (Excl. Prom.)

P30

Line Additional Tax Amounts Total (Incl. Prom.)

P40

Quantity Total (Excl. Promotion, Unit Used)

P41

Quantity Total (Excl. Promotion, Main Unit)

P42

AR/AP Debit

P43

AR/AP Credit

P44

AR/AP Debit Balance

P45

AR/AP Credit Balance

P46

AR/AP Balance

P47

AR/AP Purchase Invoices Total Amount

P48

AR/AP Sales Invoices Total Amount

P61

Total Width of Lines (Main Unit)

P62

Total Length of Lines (Main Unit)

P63

Total Height of Lines (Main Unit)

P64

Total Area of Lines (Main Unit)

P65

Total Volume of Lines (Main Unit)

P66

Total Weight of Lines (Main Unit)

P105

AR/AP Code

P122

AR/AP Aux. Code

P123

AR/AP Aux. Code2

P124

AR/AP Aux. Code3

P125

AR/AP Aux. Code4

P126

AR/AP Aux. Code5

P130

AR/AP Auth. Code

P106

Trading Group

P107

Payment Plan

P108

Payment Plan Group Code

P109

City

P110

Town

P111

District

P112

Slip Aux. Code

P113

Slip Auth. Code

P116

Delivery Account Code

P117

Delivery Address Code

P127

Division

P128

Department

P129

Warehouse

P131

Unit Set

P132

Main Unit

MIN(,)

(Takes the minimum parameter/constant into the parenthesis)

MAX(,)

(Takes the maximum parameter/constant into the parenthesis)

MOD(,)

(Divides the higher valued parameter/constant into the lower valued one and takes the remainder)

DIV(,)

(Divides the first parameter/constant to the second and writes the result)

ABS()

(Takes the absolute value of the parameter/constant)

VAL( )

(Converts the string within the parenthesis into a numeric value)

DATE(,,)

(Converts date format according to day, month and year info)

AFTER(,)

(Gives the attained date after given number of days)

DAYS(,)

(Gives number of days between two dates)

DAYOF()

(Gives date of the day)

MONTHOF()

(Gives the current month)

YEAROF()

(Gives the current year)

WDAYOF()

(Gives the date that shows which day of the week is the given date)

ROUND( )

(Rounds the parameter/constant upwards if its decimal point is bigger than 0,5 and downwards if not)

TRUNC( )

(Eliminates the decimal characters if the parameter/constant within parenthesis is decimal)

ERATE(,)

((Brings the f. currency exchange rate for a specific date. ex: ERATE(DATE(05,05,2002),20)

CRATE(,,,)

(Multiplies the amount in f. currency with cross rate)

STRPOS(,)

(Returns the position of the first occurrence of a string inside another string)

FLOOR( )

(Rounds the decimal parameter/constant downwards)

CEIL( )

(Rounds the decimal parameter/constant upwards)

FRAC( )

(Takes the decimal value of the parameter/constant)

EXP()

(Returns the value of e (the base of natural logarithms) raised to the power of X The inverse of this function is LOG using a single argument only) or LN())

LN()

(It is logarithm function. According to "e" base it transforms logarithm function result to the nearest integer)

POWER(,)

(Gives specified power of a number. For example POWER(9,2)=81 (9²) )

SQR()

Gives the square of a number)

SQRT()

(Gives the square root of a number. For example; SQRT(81)=9)

COS()

(Gives the cosine of a number (given as radiant))

SIN()

(Gives sine of a number(given as radiant))

TAN()

(Gives tangent of a number (given as radiant))

STRLEN()

(Gives the total number of characters of selected text; its type is number)

WEEKNUM(,,)

(Gives the week number of the related year)

ROUNDF(,)

(Used to round the decimal amount. (number,frdijits))

STR()

(Writes field defined as numbers in text format. For Example STR(1234)=1234)

DATESTR(,)

(Transforms the given date and writes it in demanded format)

MONTHSTR(,)

(Writes the month of the given number as text)

WDAYSTR()

(Writes the day of the given number as text)

NUMSTR(,,)

(Transforms the given number to text and writes in demanded form)

TIMESTR(,)

(Transforms the given hour to text and writes in demanded form)

RESXSTR(,)

(Brings the string corresponding to the related tag and list source at the LRF extended files of resource)

RESSTR()

(Brings the texts in LRF extended files of resource folder)

SUBSTR(,,)

(Used to write the selected text in a definite length by starting from a definite character)

UPCASE()

(Writes the text with capital letters)

LOWCASE()

(Writes the text with lower cases)

TRIMSPC(,)

(Deletes the spaces at the beginning and/or at the end of the selected text)

JUSTIFY(,,,)

(Writes the selected text in demanded length. Fills the spaces with demanded characters in text)

WRNUM(,,)

(Transforms a number's integer or decimal digits to writing form in specified language)

DATEDIFF(,,)

Returns the count (signed integer) of the specified date part boundaries crossed between the specified start date and end date.

IF(,,)

(Specifies values by defining conditions. When "If (p1>1000, 10,5)" is typed, if p1 is bigger than 1000 the value is used as 10; otherwise as 5)

CPAR()

(Checkparent: Used to filter the parent material classes)

FPCLC(,)

(FicheParentCalc: Used to find out the Slip Amount and quantity according to the parent material class)

FICLC(,)

(FicheItemCalc: Used to find out the slip amount and quantity according to materials)

FISCCLC(,,)

(Used to take slip total value according to material aux. code)

EQLC(,)

(EqualCalc: Used to define the code fields as equalities)

BTWNDATE(,,)

(Used to define condition with date range)

FPDISC(,,,)

("Parent Material Class Code)", Order Type, Quantity, Return Type)

FGDISC(,,,)

("Material Group Code", Order Type, Quantity, Return Type)

FIDISC(,,,)

("Material (Class) Code", Order Type, Quantity, Return Type)

_SQLINFO(,,)

(Used to define condition by SQLINFO)