This is the list of all variables available in auto E-mails with description and availability in specific email Typees. Variables are separated into 4 categories:
E-mail Main Page
Variable |
Description |
Available in These E-mail Types |
LastAuthCode |
Last authorization code |
FKA |
OhccpMerchantID |
CCP Merchant ID |
FKA |
Value |
CCP - Amount for charging the credit card |
FKA |
AutoReTry |
Payment will be processed again (Yes/No) |
FKA, FKB |
CCPNumOfTries |
CCP - Number of tries of credit card booking |
FKA, FKB |
CreditCardExp |
CCP - Credit card expiry date |
FKA, FKB |
CreditCardExpMonth |
CCP - Credit card expiry date (Month) |
FKA, FKB |
CreditCardExpYear |
CCP - Credit card expiry date (Year) |
FKA, FKB |
CreditCardTypee |
Credit card Typee |
FKA, FKB |
Customeraddress |
Customer - Street and house number |
FKA, FKB |
CustomerCity |
Customer - City |
FKA, FKB |
CustomerCompany |
Customer - Company |
FKA, FKB |
CustomerCountry |
Customer - Country |
FKA, FKB |
CustomerFirstName |
Customer - First name |
FKA, FKB |
CustomerHouseNr |
Customer - House number |
FKA, FKB |
CustomerLastName |
Customer - Last name |
FKA, FKB |
CustomerName |
Customer - First and last name |
FKA, FKB |
CustomerPhone |
Customer - Phone number |
FKA, FKB |
CustomerStreet |
Customer - Street |
FKA, FKB |
CustomerZIP |
Customer - ZIP |
FKA, FKB |
UrlCallTypee |
CCP - URL Call Type (e.g. iPayment_Auth_Call…) |
FKA, FKB |
AuthAmount |
Authorization amount |
FKB |
PayID |
CCP - Payment-ID |
FKB |
CNote |
Customer - Note |
All customer service E-mails |
CustomerOf |
Shop of the customer |
All customer service E-mails |
ItemNrSuppl |
Invoice lines - Supplier item number |
KSR, KSG |
ExecutionDate |
Execution date, which is exported at the SEPA file creation. Can be used to inform the Customer in advance about the direct debit date. |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU |
SEPAMandateReference |
SEPA - Client reference |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU |
ShopBIC |
Shop BIC |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU |
ShopCreditorID |
Shop Creditor ID |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU |
ShopIBAN |
Shop IBAN |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU |
I_AddrRef |
Invoice - Internal shipping address reference (internal pixi* reference) |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_BoxNr |
Invoice - Box number (Shipping) |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_CustRef |
Invoice - Internal customer reference |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_IDate |
Invoice - Date - only date |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_Invdate |
Invoice - Date |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_InvoiceNr |
Invoice - Invoice number |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_ITime |
Invoice - Date - only time |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_ODate |
Invoice - Order date |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_OrderCurrency |
Invoice - Currency |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_OrderDate |
Invoice - Order date (Date + Time) |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_OrderNrPixi |
Invoice - pixi* order number (Order number) |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_OrderNrShop |
Invoice - Order number shop (External order number) |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_OTime |
Invoice - Order time |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_PackageGrossWeight |
Invoice - Gross weight of the package |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_PackageNetWeight |
Invoice - Net weight of the package |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_PaymentText |
Invoice - Payment text |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_PaymentTypee |
Invoice - Payment type code |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_ReturnReason |
Return reason |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_ReturnCostsAmount |
Return costs |
RET |
I_ShipAdrRef |
Invoice - Internal shipping address reference (internal pixi* reference) |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_ShipDate |
Invoice - Shipping date (Scan-out date) |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_ShipmentTrackingID |
Invoice - Tracking ID |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_ShipVendorCode |
Invoice - Shipping vendor Code |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_Total |
Invoice - Total |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_Total_ShipCost |
Invoice - Shipping costs (gross) |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_TotalVAT |
Invoice - VAT total (incl. shipping costs VAT) |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_Tracking |
Invoice - Shipping vendor Tracking (Y/N) |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VATbaseHigh |
Invoice - Invoice amount taken as basis for high VAT amount |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VATbaseHigh_ShipCost |
Invoice - Amount of shipping costs for high VAT |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VATbaseLow |
Invoice - Invoice amount taken as basis for low VAT amount |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VATLow_ReturnCosts |
Invoice - VAT amount of return costs for low VAT |
KSA, KSR, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VATbaseLow_ShipCost |
Invoice - Amount of shipping costs for low VAT |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VAThigh |
Invoice - Sum of high VAT |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VAThighPerc |
Invoice - Sum of high VAT as % |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VATHigh_ReturnCosts |
Invoice - VAT amount of return costs for normal (high) VAT |
KSA, KSR, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VATHigh_ShipCost |
VAT from proportional value of ship costs for the high VAT rate |
KSA, KSR, KSB, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VATHtext |
Invoice - Sum of high VAT as Text |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VATlow |
Invoice - Sum of low VAT |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VATlowPerc |
Invoice - Sum of high VAT as % |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VATLow_ShipCost |
VAT from proportional value of ship costs for the low VAT rate |
KSA, KSR, KSB, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VATLtext |
Invoice - Sum of high VAT as Text |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VoucherAmount |
Invoice - Voucher amount |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_VoucherID |
Invoice - Voucher ID |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
InvDate |
Invoice - Invoice Date |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
InvoiceKey |
Invoice - Unique internal reference (internal pixi* reference) |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
RefToinvoiceKey |
Return - Internal reference to the original invoice (internal pixi* reference) |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
ScanoutDate |
Invoice - Shipping Date (Scan-Out) |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
TrackingID |
Shipping - Tracking ID |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET |
InvoiceNr |
Invoice - Invoice number |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB, SFU, RET, FKB |
Error |
Error |
TIB, TEB, FKA, FSV, FKB |
ErrorCount |
Number od error (Errors) |
TIB, TEB ,FSV |
AM_TemplateRef |
Unique internal template reference |
DLY, TIB, TEB |
PixiCustID |
pixi* Customer ID |
All customer service E-mails, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
ShopCustID |
Shop - Customer ID |
This variable should not be used anymore, since the content can not be set in pixi*. Please use "ShopID" variable. |
CustomerNrExternal |
Customer - Customer number from Shop |
All customer service and automatic E-mails, FKA, FKB, |
Url |
CCP - URL |
All customer service and automatic E-mails, FKA, FKB |
Zip |
Shipping address - ZIP |
All customer service and automatic E-mails, FKA, FKB |
BillAddrKey |
Billing address - Unique internal reference (internal pixi* reference) |
All E-mail types except system E-mails |
BillAddrNr |
Billing address - Number |
All E-mail types except system E-mails |
BillSalutation |
Billing address - Salutation |
All E-mail types except system E-mails |
BillCity |
Billing address - City |
All E-mail types except system E-mails |
BillCompany |
Billing address - Company |
All E-mail types except system E-mails |
BillCountryName |
Billing address - Country name |
All E-mail types except system E-mails |
BillFax |
Billing address - Fax Number |
All E-mail types except system E-mails |
BillFirstName |
Billing address - First name |
All E-mail types except system E-mails |
BillHouseNr |
Billing address - House number |
All E-mail types except system E-mails |
BillLastName |
Billing address - Last name |
All E-mail types except system E-mails |
BillName |
Billing address - First and last name |
All E-mail types except system E-mails |
BillNote |
Billing address - Note (Tab General, Billing details) |
All E-mail types except system E-mails |
BillPayId |
Billing address - payID |
HAL7, HAL14 |
BillPaymentCode |
Billing address - Payment type code |
All E-mail types except system E-mails |
BillPaymentText |
Billing address - Payment text |
All E-mail types except system E-mails |
BillPhone |
Billing address - Phone |
All E-mail types except system E-mails |
BillState |
Billing address - State |
All E-mail types except system E-mails |
BillStreet |
Billing address - Street |
All E-mail types except system E-mails |
BillZIP |
Billing address - ZIP |
All E-mail types except system E-mails |
Shipaddress |
Shipping address |
All E-mail types except system E-mails |
ShipAddrKey |
Shipping address - Internal reference (internal pixi* reference) |
All E-mail types except system E-mails |
ShipAddrNr |
Shipping address - pixi* ID (internal pixi* reference) |
All E-mail types except system E-mails |
ShipSalutation |
Shipping address - Salutation |
All E-mail types except system E-mails |
ShipCity |
Shipping address - City |
All E-mail types except system E-mails |
ShipCompany |
Shipping address - Company |
All E-mail types except system E-mails |
ShipCountryCode |
Shipping address - Code in the country table, which is in the first column |
All E-mail types except system E-mails |
ShipCountryName |
Shipping address - Country |
All E-mail types except system E-mails |
ShipFax |
Shipping address - Fax nr. |
All E-mail types except system E-mails |
ShipFirstName |
Shipping address - First name |
All E-mail types except system E-mails |
ShipHouseNr |
Shipping address - House number |
All E-mail types except system E-mails |
ShipLastName |
Shipping address - Last name |
All E-mail types except system E-mails |
ShipName |
Shipping address - First and last name |
All E-mail types except system E-mails |
ShipNote |
Shipping address - Note |
All E-mail types except system E-mails |
ShipPhone |
Shipping address - Phone number |
All E-mail types except system E-mails |
ShipState |
Shipping address - State |
All E-mail types except system E-mails |
ShipStreet |
Shipping address - Street |
All E-mail types except system E-mails |
ShipZIP |
Shipping address - ZIP |
All E-mail types except system E-mails |
Shopaddress |
Shop - Address |
All E-mail types except system E-mails |
ShopBank |
Shop - Name of the Bank |
All E-mail types except system E-mails |
ShopBIC |
Shop - BIC |
HAL7, HAL14, ZBE, STOT, STOK, REM1/2/3/4/5 |
ShopCity |
Shop - City |
All E-mail types except system E-mails |
ShopCountryCode |
Shop - Code in the country table, which is in the first column |
All E-mail types except system E-mails |
ShopCountryName |
Shop - Country |
All E-mail types except system E-mails |
ShopCustFax |
Shop - Fax |
This variable should not be used anymore, since the content can not be set in pixi*. Please use "ShopFax" variable. |
ShopCustphone |
Shop - Phone number |
This variable should not be used anymore, since the content can not be set in pixi*. Please use "ShopPhone" variable. |
ShopDtausLSBLZ |
Shop - Bank code |
All E-mail types except system E-mails |
ShopDtausLSKto |
Shop - Account number |
All E-mail types except system E-mails |
ShopDtausLSKtoName |
Shop - Account name |
All E-mail types except system E-mails |
ShopDtausLSREASON |
Shop - DTAUS/SEPA reason |
All E-mail types except system E-mails |
ShopDtausLSTOWN |
Shop - DTAUS City |
All E-mail types except system E-mails |
ShopEmail |
Shop - E-mail |
All E-mail types except system E-mails |
ShopEmail2 |
Shop - E-mail2 |
All E-mail types except system E-mails |
ShopFax |
Shop - Fax Number |
All E-mail types except system E-mails |
ShopFax2 |
Shop - Fax Number 2 |
All E-mail types except system E-mails |
ShopIBAN |
Shop - IBAN |
HAL7, HAL14, ZBE, STOT, STOK, REM1/2/3/4/5 |
ShopHeadLine |
Shop - Headline as an additional field (SI headline in the Shops table) |
All E-mail types except system E-mails |
ShopName |
Shop - Name |
All E-mail types except system E-mails |
ShopNote |
Shop - Note |
All E-mail types except system E-mails |
ShopPhone |
Shop - Phone number |
All E-mail types except system E-mails |
ShopPhone2 |
Shop - Phone number 2 |
All E-mail types except system E-mails |
ShopReplyPixiEmail |
Shop - Reply E-mail address for auto E-mails |
All E-mail types except system E-mails |
ShopSenderNamePixiEmail |
Shop - Sender name for auto E-mails |
All E-mail types except system E-mails |
ShopSenderPixiEmail |
Shop - Sender E-mail for auto E-mails |
All E-mail types except system E-mails |
ShopSIaddress |
Shop - SIAddress additional field (Shops table) |
All E-mail types except system E-mails |
ShopSIaddress1 |
Shop - SIAddress1 additional field (Shops table) |
All E-mail types except system E-mails |
ShopSIaddress2 |
Shop - SIAddress2 additional field (Shops table) |
All E-mail types except system E-mails |
ShopSIemail |
Shop - SIE-mail additional field (Shops table) |
All E-mail types except system E-mails |
ShopSIfax |
Shop - SIFax additional field (Shops table) |
All E-mail types except system E-mails |
ShopSIphone |
Shop - SIPhone additional field (Shops table) |
All E-mail types except system E-mails |
ShopSIzipcity |
Shop - SIPLZCity additional field |
All E-mail types except system E-mails |
ShopState |
Shop - State |
All E-mail types except system E-mails |
ShopURL |
Shop - URL |
All E-mail types except system E-mails |
ShopURLtoAGB |
Shop - Link to the Terms and Conditions |
All E-mail types except system E-mails |
ShopURLtoImpressum |
Shop - Link to legal notice |
All E-mail types except system E-mails |
ShopURLtoLogo |
Shop - Link to the shop logo |
All E-mail types except system E-mails |
ShopVatCountry |
Shop - Country name for VAT calculation |
All E-mail types except system E-mails |
ShopVATCountryCode |
Shop - Code in the country table, which is in the first column, for VAT calculation |
All E-mail types except system E-mails |
ShopWebSite |
Shop - Website |
All E-mail types except system E-mails |
ShopZIP |
Shop - ZIP |
All E-mail types except system E-mails |
KreditorID |
Creditor ID |
HAL7, HAL14, ZBE, STOT, STOK, REM1/2/3/4/5 |
Billaddress |
Billing address |
All E-mail types except system E-mails |
Billaddress |
Billing address - Street and house number |
All E-mail types except system E-mails |
ShopCustEmail |
Shop - E-mail |
This variable should not be used anymore, since the content can not be set in pixi*. Please use "ShopEmail" variable. |
BillCountryCode |
Billing address - Code in the country table, which is in the first column |
All E-mail types except system E-mails and REM1/2/3/4/5 |
CustRef |
Internal customer reference |
All automatic E-mails, KSR, KSB, KSG |
total |
Invoice - Total |
All automatic E-mails, KSR, KSB, KSG |
ODate |
Order date |
KSB, KSG, KSR, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET |
OTime |
Order - Order time |
KSB, KSR, KSG, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET |
OrderDate |
Order - Date |
KSB, KSG, KSR, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET, DLYext1 |
OrderNrPixi |
Order number - Shop (Order number) |
KSB, KSG, KSR, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET, DLYext1 |
OrderNrShop |
Order number - Shop (External Order number) |
KSR, KSB, KSG, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET, FKA, DLYext1 |
OrderNr |
Order number - pixi* (Order number) |
KSB, KSR, KSG, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, BSK, ZBE, SFU, RET, FKA, DLYext1 |
OrderTotalPayPal |
Order - Order total PayPal (incl. Shipping costs + Credits) |
HAL7,HAL14,DLY,DLF,NLB,NLBE,BBE,STOK,STOT,KSB,ZBE, |
OrderaddressRemark |
Order - Address note |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderAddrRef |
Order - Internal invoice address reference (internal pixi* reference) |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderCountANG |
Order - Number of order lines with status ANG |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderCountAUS |
Order - Number of order lines with status AUS |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderCountHAL |
Order - Number of order lines with status HAL |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderCountMIN |
Order - Number of order lines with status MIN |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderCountNEW |
Order - Number of order lines with status NEW |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderCountNLB |
Order - Number of order lines with status NLB |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderCountRET |
Order - Number of order lines with status RET |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderCountSTO |
Order - Number of order lines with status STO |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderCustRef |
Order - Internal customer reference (internal pixi* reference) |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderGiftMessage |
Order - Gift message |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderHeaderKey |
Order - Unique internal reference (internal pixi* reference) |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderShipCosts |
Order - Shipping costs |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderShipDate |
Order - Preferred Shipping Date (also available for Express) |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderShippingNote |
Order - Shipping Note |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderShipVendorCode |
Order - Shipping vendor Code |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderShipVendorName |
Order - Shipping vendor Text |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderShipVendorURL |
Order - Shipping vendor URL for Tracking (from the Shipping Vendors table) |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderTotal |
Order - Order total (incl. Shipping costs + Credits) |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderTotal_NoShipCost |
Order - Order total without shipping costs |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderTotal_SumOrderlines |
Order - Sum of order lines |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderVoucherAmount |
Order - Voucher amount |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderVoucherID |
Order - Voucher ID |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderShipAdrRef |
Order - Internal shipping address reference (internal pixi* reference) |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderShipAdrRef |
Order - Internal shipping address reference (internal pixi* reference) |
KSB, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderHeaderUpdateDate |
Order - Date when order header was updated (Order Header) |
HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
OrderShipCosts_net |
Order - Shipping costs net |
HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
OrderTotal_Net |
Order - Order total (net) |
HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
OrderTotal_NoVoucher |
Order - Order total without discount |
HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
OrderTotal_SumOrderlines_net |
Order - Sum of order lines (net) |
HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
OrderTypee |
Order type - B2C or B2B |
HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
AM_TypeeRef |
Unique internal E-mail event reference |
All E-mail types |
cEmail |
Customer - E-mail |
All E-mail types |
CntCode |
Customer - Country code (von Addressen genutzt) |
All E-mail types |
CustKey |
Customer - Unique internal reference |
All E-mail types |
MailID |
Mail ID |
All E-mail types |
MailRealDate |
Date of the e-mail (depending on e-mail type order or invoice date) |
All E-mail types |
ShipvendorCode |
Shipping vendor Code |
All E-mail types |
ShopID |
Shop - ID |
All E-mail types |
Payment |
Payment type |
All customer service and automatic E-mails, MEK, MEP, MSV, IFM, FBI, FAI, ADS FME, BSK, MSE, FKA, FSV,FKB |
PaymentCode |
Payment type (Code) |
All customer service and automatic E-mails, MEK, MEP, MSV, IFM, FBI, FAI, ADS FME, BSK, MSE, FKA, FSV,FKB |
ExceptionCount |
Number of exceptions (Exceptions) |
IFM |
DBName |
Database name |
IFM, TIB, TEB, FBI, FAI, BSK |
ServerName |
Server name |
IFM, TIB, TEB, FBI, FAI, BSK |
SName |
Shipping - Name |
IFM, FBI, FAI, BSK, REM1/2/3/4/5 |
HoursSinceLastEmailcreated |
Time since the last E-mail creation |
MSE |
HoursSinceLastEmailSENT |
Time since the last E-mail was sent |
MSV |
AM_mailCustEmail |
E-mail address of the customer |
MEK |
MailsInAnHour |
Number of sent E-mails in the last hour |
MEK |
MailsInOutbox |
Number of E-mails in Outbox |
MEP |
MinutesPast |
Minutes since the value in setting "System e-mails - max created e-mails in Outbox" was exceeded |
MEP |
OrderNrExternal |
Order number - Shop (External Order number) |
BSK |
Shop_Note |
Shop - Comment |
BSK |
ESRString |
ESR String |
REM1/2/3/4/5 |
InvoiceRef |
Internal invoice reference |
REM1/2/3/4/5 |
LastReminderAction |
Last reminder action (mail, print) |
REM1/2/3/4/5 |
Paymentreference |
Reminder - Payment reference |
REM1/2/3/4/5 |
RecommendationConfirmed |
Recommendation confirmed |
REM1/2/3/4/5 |
ReminderCosts |
Reminder - Reminder costs |
REM1/2/3/4/5 |
ReminderDueDate |
Reminder - Due date |
REM1/2/3/4/5 |
ReminderKey |
Reminder - Internal reminder key |
REM1/2/3/4/5 |
ReminderSentDate |
Reminder - Shipping date reminder |
REM1/2/3/4/5 |
ReminderTotal |
Reminder - Reminder total |
REM1/2/3/4/5 |
SAddress |
Shipping Address |
REM1/2/3/4/5 |
SCity |
Shipping - City |
REM1/2/3/4/5 |
SCountry |
Shipping - Country |
REM1/2/3/4/5 |
SState |
Shipping - State |
REM1/2/3/4/5 |
SZIP |
Shipping - ZIP |
REM1/2/3/4/5 |
TimesMailed |
Mail sent "x" times |
REM1/2/3/4/5 |
Log |
Log |
All customer service and automatic E-mails, FKA, FKB |
AllFailedReminderEmails |
Reminder - Total number of failed Reminders emails |
FME |
FailedReminderLevel1 |
Reminder - Number of failed reminders - level 1 |
FME |
FailedReminderLevel2 |
Reminder - Number of failed reminders - level 2 |
FME |
FailedReminderLevel3 |
Reminder - Number of failed reminders - level 3 |
FME |
FailedReminderLevel4 |
Reminder - Number of failed reminders - level 4 |
FME |
FailedReminderLevel5 |
Reminder - Number of failed reminders - level 5 |
FME |
ReminderLevel |
Reminder - Reminder level |
FME |
Real_Last_Name |
pixi* Login data - Last name |
ADS |
Real_Name |
pixi* Login data - Name |
ADS |
User_Email |
User - E-mail Address |
ADS |
User_Name |
User - Username |
ADS |
User_Pass |
User - Password |
ADS |
CustomerEmail |
Customer - E-mail |
SHC, SHI, SHCNLB, SHINLB, REM1/2/3/4/5, SFU, RET, FKA, FKB |
Status |
Reminder status (e.g. SEN) |
SHC, SHI, SHCNLB, SHINLB, REM1/2/3/4/5, SFU, RET |
AddressRemarks |
Adresszusatz |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
BillEmail |
Billing address - E-mail |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
CountLines |
Number of entries (Order lines, Invoice lines) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_InvoiceNr_Ref |
Invoice - Reference number |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_Total_Net |
Invoice - Total (net) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
I_Total_ShipCost_Net |
Invoice - Shipping costs (net) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
ShipEmail |
Shipping address - E-mail |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
StatusCountRET |
Number of order lines/invoice lines on status RET |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
BaseCurrency |
Currency code of the shop currency (e.g. EUR). |
All E-mail types except system E-mails |
ExchRate_BaseToOrder |
Exchange rate from the shop currency to the order currency. |
All E-mail types except system E-mails |
OrderCurrency |
Order currency code |
All E-mail types except system E-mails |
OrderTotal_BaseCurr |
Order total in shop currency |
HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
I_Total_BaseCurr |
Invoice total in shop currency |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
Total_BaseCurr |
Invoice total in shop currency for reminders |
REM1/2/3/4/5 |
Detail 1
Variable |
Description |
Available in These E-mail Types |
BundleOrderlineRef |
Internal reference of the bundle order line |
KSB, KSG, KSR, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET |
C_LogKey |
Internal log key |
IFM |
C_LogText |
Error message information |
IFM |
ChannelEnabled |
Channel - Status |
FSV |
ChannelKey |
Channel - Key |
FSV |
ChannelName |
Channel - Name |
FSV |
ChannelTypeeName |
Channel-Art - Name |
FSV |
CreateDate |
Created date |
IFM |
CreationBatchID |
Internal BatchID |
REM1/2/3/4/5 |
CustRef |
Internal customer reference |
KSB, KSG, KSR, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET, DLYext1 |
DetailID |
Internal DetailID |
KSB, KSR, KSG, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, RET, REM1/2/3/4/5, IFM, FBI, FAI, FSV |
EANUPC |
Barcode |
KSB, KSR, KSG, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET, DLYext1 |
Error |
Error |
FAI, FBI |
ExportAction |
Item export (0 - Export for all channels, 1 - Only for this channel |
FSV |
ExportAction |
Item export (0 - Export for all channels, 1 - Only for this channel |
FSV |
IL_AddrRef |
Invoice lines - Internal invoice address reference |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_CustRef |
Invoice lines - Internal customer reference |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_DiscountPerc |
Invoice lines - Discount % |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_DiscountValue |
Invoice lines - Discount value |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_EanUpc |
Invoice lines - Barcode |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_FullPrice |
Invoice lines - Gross price (without discount) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_FullPrice_Net |
Invoice lines - Net price (without discount) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_InvLineAmount |
Invoice lines - Gross total (Gross price * Quantity) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_InvLineAmount_Net |
Invoice lines - Net total (Net price * Quantity) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_InvoiceRef |
Invoice lines - Internal invoice reference (internal pixi* reference) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_ItemBarCode |
Invoice lines - Item Barcode |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_ItemName |
Invoice lines - Item name |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_ItemNrInt |
Invoice lines - Internal Item Number |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_ItemNrSuppl |
Invoice lines - Supplier item number |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_ItemPicLarge |
Invoice lines - URL for the big item image |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_ItemPicSmall |
Invoice lines - URL for the small item image |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_ItemPrice |
Invoice lines - Gross price (incl. Discount) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_ItemPrice_Net |
Invoice lines - Net price (incl. Discount) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_ItemRef |
Invoice lines - Unique internal item reference (internal pixi* reference) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_OrderCurrency |
Invoice lines - Currency |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_OrderlineRef |
Invoice lines - Unique internal order line reference (internal pixi* reference) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_Qty |
Invoice lines - Quantity |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_SerialNr |
Invoice lines - Item serial number |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_Value |
Invoice lines - Gross total (Gross price * Quantity) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_Value_Net |
Invoice lines - Net total (Net price * Quantity) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
IL_VATrate |
Invoice lines - VAT rate |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
InfoIcon |
Status der Channel-Verbindung |
FSV |
INV_VATRate |
Invoice lines - VAT (H/L/0) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
InvDate |
Invoice - Invoice Date |
REM1/2/3/4/5 |
InvlineKey |
Invoice lines - Unique internal reference (internal pixi* reference) |
SHC, SHI, SHCNLB, SHINLB, SFU, RET |
InvoiceKey |
Invoice - Unique internal reference (internal pixi* reference) |
REM1/2/3/4/5 |
InvoiceNr |
Invoice - Invoice number |
REM1/2/3/4/5 |
InvoiceNrs |
Invoice numbers seprataed by comma |
REM1/2/3/4/5 |
InvoiceRef |
Internal invoice reference |
SHC, SHI, SHCNLB, SHINLB, REM1/2/3/4/5, SFU, RET |
ItemName |
Item name |
KSB, KSR, KSG, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET, DLYext1 |
ItemNrInt |
Item number internal |
FAI |
ItemNrSuppl |
Invoice lines - Supplier item number |
KSB, KSG, KSR, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET, DLYext1 |
Log |
Log |
IFM |
MwStSatz |
VAT of items |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
ODate |
Order date |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
OL_AddrRef |
Order line - Internal invoice address reference (internal pixi* reference) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_BoxNrUsed |
Order line - Box number of Scan-In |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_CustRef |
Order line - Unique internal customer reference (internal pixi* reference) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_DiscountPerc |
Order line - Discount % |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_DiscountValue |
Order line - Discount value |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_EanUpc |
Order line - Barcode |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_EstimatedDelivery |
Order line - Estimated delivery |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_InvRef |
Order line - Internal invoice reference (internal pixi* reference) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_ItemAmount_Net |
Order line - Net total (Net price * Quantity) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
OL_ItemBarCode |
Order line - Item Barcode |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_ItemFullPrice |
Order line - Gross price (without discount) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_ItemFullPrice_Net |
Order line - Net price (without discount) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
OL_ItemName |
Order line - Item name |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_ItemNrInt |
Order line - Internal Item Number |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_ItemNrSuppl |
Order line - Supplier item number |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_ItemPicLarge |
Order line - Item URL for the big item image |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_ItemPicSmall |
Order line - Item URL for the small item image |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_ItemPrice |
Order line - Gross price (incl. Discount) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_ItemPrice_net |
Order line - Net price (incl. Discount) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
OL_ItemRef |
Order line - Unique internal item reference (internal pixi* reference) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_ItemValue |
Order line - Gross total (Gross price * Quantity) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_LocationID |
Order line - Location ID (normally 001) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_LocAvailStockForOrderline |
Order line - Available stock (No display of historical values) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_MeasuredWeight |
Order line - Measured item weight (in grams) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_ODate |
Order line - Order date |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
OL_oItemSpecialNote |
Order line - Item Note |
KSB, KSG, KSR, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET |
OL_OrderDate |
Order line - Order date |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_OrderNr |
Order line - pixi* Order number |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_OrderNrExternal |
Order line - Shop Order number |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_OTime |
Order line - Order time |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
OL_PickListNrUsed |
Order line - Last used picklist number |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_Qty |
Order line - Item Quantity |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_SerialNr |
Order line - Item serial number |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_ShipAdrRef |
Order line - Unique internal address reference (internal pixi* reference) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_ShipDate |
Order line - Preferred Shipping Date (also available for Express) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_StatusCode |
Order line - Status Code (HAL, ANG,...) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_StatusName |
Order line - Status text (On Hold, New Order,...) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_SumAvailStockForOrderline |
Order line - Sum of available stock |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_VATrate |
Order line - VAT rate |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_voucherID |
Order line - Voucher ID |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OL_Weight |
Order line - Item weight (not measured, from the database) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OpenAmount |
Open invoice amount |
REM1/2/3/4/5 |
OrderDate |
Order - Date |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderlineKey |
Order line - Unique internal reference (internal pixi* reference) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1 |
OrderlineRef |
Order line - Unique internal order line reference (internal pixi* reference) |
KSB, KSG, KSR, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET |
OrderNr |
Order number - pixi* (Order number) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, FBI, DLYext1, REM1/2/3/4/5 |
OrderNrExternal |
Order number - Shop (External Order number) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, DLYext1, REM1/2/3/4/5 |
OrdShopID |
Order - Shop ID |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
OTime |
Order - Order time |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE |
Payment |
Payment type |
REM1/2/3/4/5 |
ReminderCosts |
Reminder - Reminder costs |
REM1/2/3/4/5 |
ReminderLevel |
Reminder - Reminder level |
REM1/2/3/4/5 |
ReminderLineKey |
Reminder - Internal reminder line key |
REM1/2/3/4/5 |
ReminderRef |
Reminder - Internal reminder reference |
REM1/2/3/4/5 |
ShopID |
Shop - ID |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, FBI |
SName |
Shipping - Name |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, TEB, TIB, DLYext1 |
Status |
Reminder status (e.g. SEN) |
KSB, KSR, KSG, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET, TIB, TEB, DLYext1 |
StatusCount |
Number of XML files in certain status (StatusName) |
TIB, TEB |
StatusName |
Name of XML file status (used for StatusCount) |
KSB, KSR, KSG, HAL7, HAL14, DLY, DLF, NLB, NLBE, BBE, STOK, STOT, ZBE, TEB, TIB, DLYext1 |
total |
Invoice - Total |
REM1/2/3/4/5 |
Value |
CCP - Payment amount for credit card booking |
KSB, KSG, KSR, HAL7, HAL14, SHC, DLY, DLF, NLB, NLBE, BBE, SHI, SHCNLB, SHINLB, STOK, STOT, ZBE, SFU, RET, DLYext1 |
Detail 2
Variable |
Description |
Available in These E-mail Types |
BundleOrderlineRef |
Internal reference of the bundle order line |
KSR, KSG |
CustRef |
Internal customer reference |
KSR, KSG, DLYext1 |
DetailID |
Internal DetailID |
KSR, KSG, SHC, SHI, SHCNLB, SHINLB |
EANUPC |
Barcode |
KSR, KSG, DLYext1 |
ItemName |
Item name |
KSR, KSG, DLYext1 |
ItemNrSuppl |
Invoice lines - Supplier item number |
KSR, KSG, DLYext1 |
MwStSatz |
VAT rate of the item |
KSR, KSG |
ODate |
Order date |
KSR, KSG |
OL_AddrRef |
Order line - Internal invoice address reference (internal pixi* reference) |
KSR, KSG, DLYext1 |
OL_BoxNrUsed |
Order line - Box number from Scan-In |
KSR, KSG, DLYext1 |
OL_CustRef |
Order line - Unique internal customer reference (internal pixi* reference) |
KSR, KSG, DLYext1 |
OL_DiscountPerc |
Order line - Discount % |
KSR, KSG, DLYext1 |
OL_DiscountValue |
Order line - Discount value |
KSR, KSG, DLYext1 |
OL_EanUpc |
Order line - Barcode |
KSR, KSG, DLYext1 |
OL_EstimatedDelivery |
Order line - Estimated delivery |
KSR, KSG, DLYext1 |
OL_InvRef |
Order line - Internal invoice reference (internal pixi* reference) |
KSR, KSG, DLYext1 |
OL_ItemAmount_Net |
Order line - Net total (Net price * Quantity) |
KSR, KSG |
OL_ItemBarCode |
Order line - Item Barcode |
KSR, KSG, DLYext1 |
OL_ItemFullPrice |
Order line - Gross price (without discount) |
KSR, KSG |
OL_ItemFullPrice_Net |
Order line - Net price (without discount) |
KSR, KSG |
OL_ItemName |
Order line - Itemname |
KSR, KSG, DLYext1 |
OL_ItemNrInt |
Order line - Internal ItemNumber |
KSR, KSG, DLYext1 |
OL_ItemNrSuppl |
Order line - Supplier item number |
KSR, KSG, DLYext1 |
OL_ItemPicLarge |
Order line - Item URL for the big item image |
KSR, KSG, DLYext1 |
OL_ItemPicSmall |
Order line - Item URL for the small item image |
KSR, KSG, DLYext1 |
OL_ItemPrice |
Order line - Gross price (incl. Discount) |
KSR, KSG, DLYext1 |
OL_ItemPrice_net |
Order line - Net price (incl. Discount) |
KSR, KSG |
OL_ItemRef |
Order line - Unique internal item reference (internal pixi* reference) |
KSR, KSG, DLYext1 |
OL_ItemValue |
Order line - Gross total (Gross price * Quantity) |
KSR, KSG, DLYext1 |
OL_LocationID |
Order line - Location ID (normally 001) |
KSR, KSG, DLYext1 |
OL_LocAvailStockForOrderline |
Order line - Available stock (No display of historical values) |
KSR, KSG, DLYext1 |
OL_MeasuredWeight |
Order line - Measured item weight (in grams) |
KSR, KSG, DLYext1 |
OL_ODate |
Order line - Order date |
KSR, KSG |
OL_oItemSpecialNote |
Order line - ItemNote |
KSR, KSG |
OL_OrderDate |
Order line - Order date |
KSR, KSG, DLYext1 |
OL_OrderNr |
Order line - pixi Order number |
KSR, KSG, DLYext1 |
OL_OrderNrExternal |
Order line - Shop Order number |
KSR, KSG, DLYext1 |
OL_OTime |
Order line - Order time |
KSR, KSG |
OL_PickListNrUsed |
Order line - Last used pick list number |
KSR, KSG, DLYext1 |
OL_Qty |
Order line - ItemQuantity |
KSR, KSG, DLYext1 |
OL_SerialNr |
Order line - Item serial number |
KSR, KSG, DLYext1 |
OL_ShipAdrRef |
Order line - Unique internal address reference (internal pixi* reference) |
KSR, KSG, DLYext1 |
OL_ShipDate |
Order line - Preferred Shipping Date (also available for Express) |
KSR, KSG, DLYext1 |
OL_StatusCode |
Order line - Status Code (HAL, ANG,...) |
KSR, KSG, DLYext1 |
OL_StatusName |
Order line - Status text (On Hold, New Order,...) |
KSR, KSG, DLYext1 |
OL_SumAvailStockForOrderline |
Order line - Sum of available stock |
KSR, KSG, DLYext1 |
OL_VATrate |
Order line - VAT rate |
KSR, KSG, DLYext1 |
OL_voucherID |
Order line - Voucher ID |
KSR, KSG, DLYext1 |
OL_Weight |
Order line - Item weight (not measured, from the database) |
KSR, KSG, DLYext1 |
OrderDate |
Order - Date |
KSR, KSG, DLYext1 |
OrderlineKey |
Order line - Unique internal reference (internal pixi* reference) |
KSR, KSG, DLYext1 |
OrderlineRef |
Order line - Unique internal order line reference (internal pixi* reference) |
KSR, KSG |
OrderNr |
Order number - pixi* (Order number) |
KSR, KSG, DLYext1 |
OrderNrExternal |
Order number - Shop (External Order number) |
KSR, KSG, DLYext1 |
OrdShopID |
Order - Shop ID |
KSR, KSG |
OTime |
Order - Order time |
KSR, KSG |
ShopID |
Shop - ID |
KSR, KSG |
SName |
Shipping - Name |
KSR, KSG, DLYext1, TIB, TEB |
Status |
Reminder status (e.g. SEN) |
KSR, KSG, DLYext1, TIB, TEB |
StatusCount |
Number of XML files in certain status (StatusName) |
TIB, TEB |
StatusName |
Name of XML file status (used for StatusCount) |
KSR, KSG, DLYext1, TIB, TEB |
TrackingID |
Shipping - Tracking ID |
SHC, SHI, SHCNLB, SHINLB, RET |
TrackingURL |
Consists of "Tracking URL" from pixi* Control Center > Shipping Vendors table and the value from variable "TrackingID". In case the tracking ID field contains more than one ID (seperated by a semicolon), then several links are shown. |
SHC, SHCNLB, SHI, SHINLB |
Value |
CCP - Payment amount for credit card booking |
KSR, KSG, DLYext1 |
Zip |
Shipping address - ZIP |
SHC, SHI, SHCNLB, SHINLB |
Detail 3
Variable |
Description |
Available in These E-mail Types |
BundleOrderlineRef |
Internal reference of the bundle order line |
SHCNLB, SHINLB |
CustRef |
Internal customer reference |
SHCNLB, SHINLB |
DetailID |
Internal Detail ID |
SHCNLB, SHINLB |
EANUPC |
Barcode |
SHCNLB, SHINLB |
ItemName |
Itemname |
SHCNLB, SHINLB |
ItemNrSuppl |
Invoice lines - Supplier item number |
SHCNLB, SHINLB |
MwStSatz |
VAT of items |
SHCNLB, SHINLB |
ODate |
Order date |
SHCNLB, SHINLB |
OL_AddrRef |
Order line - Internal invoice address reference (internal pixi* reference) |
SHCNLB, SHINLB |
OL_BoxNrUsed |
Order line - Box number from Scan-In |
SHCNLB, SHINLB |
OL_CustRef |
Order line - Unique internal customer reference (internal pixi* reference) |
SHCNLB, SHINLB |
OL_DiscountPerc |
Order line - Discount % |
SHCNLB, SHINLB |
OL_DiscountValue |
Order line - Discount value |
SHCNLB, SHINLB |
OL_EanUpc |
Order line - Barcode |
SHCNLB, SHINLB |
OL_EstimatedDelivery |
Order line - Estimated delivery |
SHCNLB, SHINLB |
OL_InvRef |
Order line - Internal invoice reference (internal pixi* reference) |
SHCNLB, SHINLB |
OL_ItemAmount_Net |
Order line - Net total (Net price * Quantity) |
SHCNLB, SHINLB |
OL_ItemBarCode |
Order line - Item Barcode |
SHCNLB, SHINLB |
OL_ItemFullPrice |
Order line - Gross price (without discount) |
SHCNLB, SHINLB |
OL_ItemFullPrice_Net |
Order line - Net price (without discount) |
SHCNLB, SHINLB |
OL_ItemName |
Order line - Item name |
SHCNLB, SHINLB |
OL_ItemNrInt |
Order line - Internal Item Number |
SHCNLB, SHINLB |
OL_ItemNrSuppl |
Order line - Supplier item number |
SHCNLB, SHINLB |
OL_ItemPicLarge |
Order line - Item URL for the big item image |
SHCNLB, SHINLB |
OL_ItemPicSmall |
Order line - Item URL for the small item image |
SHCNLB, SHINLB |
OL_ItemPrice |
Order line - Gross price (incl. Discount) |
SHCNLB, SHINLB |
OL_ItemPrice_net |
Order line - Net price (incl. Discount) |
SHCNLB, SHINLB |
OL_ItemRef |
Order line - Unique internal item reference (internal pixi* reference) |
SHCNLB, SHINLB |
OL_ItemValue |
Order line - Gross total (Gross price * Quantity) |
SHCNLB, SHINLB |
OL_LocationID |
Order line - Location ID (normally 001) |
SHCNLB, SHINLB |
OL_LocAvailStockForOrderline |
Order line - Available stock (No display of historical values) |
SHCNLB, SHINLB |
OL_MeasuredWeight |
Order line - Measured item weight (in grams) |
SHCNLB, SHINLB |
OL_ODate |
Order line - Order date |
SHCNLB, SHINLB |
OL_oItemSpecialNote |
Order line - ItemNote |
SHCNLB, SHINLB |
OL_OrderDate |
Order line - Order date |
SHCNLB, SHINLB |
OL_OrderNr |
Order line - pixi Order number |
SHCNLB, SHINLB |
OL_OrderNrExternal |
Order line - Shop Order number |
SHCNLB, SHINLB |
OL_OTime |
Order line - Order time |
SHCNLB, SHINLB |
OL_PickListNrUsed |
Order line - Last used pick list number |
SHCNLB, SHINLB |
OL_Qty |
Order line - ItemQuantity |
SHCNLB, SHINLB |
OL_SerialNr |
Order line - Item serial number |
SHCNLB, SHINLB |
OL_ShipAdrRef |
Order line - Unique internal address reference (internal pixi* reference) |
SHCNLB, SHINLB |
OL_ShipDate |
Order line - Preferred Shipping Date (also available for Express) |
SHCNLB, SHINLB |
OL_StatusCode |
Order line - Status Code (HAL, ANG,...) |
SHCNLB, SHINLB |
OL_StatusName |
Order line - Status text (On Hold, New Order,...) |
SHCNLB, SHINLB |
OL_SumAvailStockForOrderline |
Order line - Sum of available stock |
SHCNLB, SHINLB |
OL_VATrate |
Order line - VAT rate |
SHCNLB, SHINLB |
OL_voucherID |
Order line - Voucher ID |
SHCNLB, SHINLB |
OL_Weight |
Order line - Item weight (not measured, from the database) |
SHCNLB, SHINLB |
OrderDate |
Order - Date |
SHCNLB, SHINLB |
OrderlineKey |
Order line - Unique internal reference (internal pixi* reference) |
SHCNLB, SHINLB |
OrderlineRef |
Order line - Unique internal order line reference (internal pixi* reference) |
SHCNLB, SHINLB |
OrderNr |
Order number - pixi* (Order number) |
SHCNLB, SHINLB |
OrderNrExternal |
Order number - Shop (External Order number) |
SHCNLB, SHINLB |
OrdShopID |
Order - Shop ID |
SHCNLB, SHINLB |
OTime |
Order - Order time |
SHCNLB, SHINLB |
ShopID |
Shop - ID |
SHCNLB, SHINLB |
SName |
Shipping - Name |
SHCNLB, SHINLB |
Status |
Reminder status (e.g. SEN) |
SHCNLB, SHINLB |
Value |
CCP - Payment amount for credit card booking |
SHCNLB, SHINLB |
Abbrevations
Customer service E-mails:
KSA - API_Invoice_eMail - API e-mails for invoices
KSK - CSD_CustomeMail - E-mails for customers
KSR - CSD_Invoices - E-mails for invoices
KSB - CSD_Orders - E-mails for orders
KSG- CSD_Returns - E-mails for credits
Automatic E-mails:
BBE - OrderConCompanytion - Order confirmation
HAL7 - 1. Payment reminder
HAL14 - 2. Payment reminder
ZBE - PaymentReceived - Payment confirmation
NLB - NLB - Not available
NLBE - NLBsingle - NLB (single order line)
STOT - STOPartial - STO Partial cancellation
STOK - STOComplete - STO Complete cancellation
DLY - First delivery delay
DLF - Second delivery delay
DLYext1 - Repeated delivery delay
SHC - Shipping confirmation complete delivery
SHCNLB - Shipping confirmation complete delivery (incl. NLB Item)
SHI - Shipping confirmation partial delivery
SHINLB - Shipping confirmation partial delivery (incl. NLB Item)
SFU - Customer satisfaction
RET - Return received
REM1/2/3/4/5 - 1./2./3./4./5. Reminder
System E-mails:
FAI - Item_import_error - Error in item import
MSE - MaxHoursLastCreated - Exceeded maximum hours since the last e-mail creation
FBI - Order_import_error - Error in order import
ADS - SendLoginData - Send login data
UAG - Update_completed - Update completed
UAE - UpdateApp EQ Errors - UpdateApp EQ Errors
BSK - Order With Shop Note
RFM - ReleaseDiscrepancies - Release Discrepancies
FME - RemindersFailedEMail - Failed reminders
FKB - CC_Capture_Declined - Credit card capture error
MSV - MaxHoursLastSent - Exceeded maximum hours since the last e-mail was sent
MEK - MaxMailsForRecipient - Exceeded maximum number of e-mails sent to customer
MEP - MaxmailsInoutBox - Exceeded maximum number of e-mails in Outbox
FKA - CC_Auth_Declined - Credit card authorization declined
FSV - ChannelsError - Shop connection error
TEB - Daily Export Report
TIB - Daily Import Report
IFM - Imp_Exception - Import Error