The parameters and variables available for use in the Condition and Formula fields of the campaign lines:
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 |
P87 | Line Discount Amount |
P88 | Line Expense 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) |
P84 | Line Gross Weight (Line Unit) |
P85 | Line Gross 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) |
P86 | Total Gross 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 |
P133 | Salesperson Code |
P134 | Salesperson Code (Line) |
Functions
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 (92) ) |
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) |
CRESSTR(,) | |
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) |
WIN2DOS(,) | |
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) |
FUINFOCLC(,,) | |
_SQLINFO(,,) | (Used to define condition by SQLINFO) |