The parameters and variables available for use in the Condition and Formula fields of the campaign lines are as follows:
Line 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 |
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) |
...