Variable

Description

Location in pixi*

Number of Characters

Data Type

Example

A1Code

24

String

AccName

Bank account owner

Customer Service --> Orders (Details General)

27

String

John Doe

Account

Bank account number

Customer Service --> Orders (Details General)

10

String

54678978

ACode

28

String

Address

Billing details (Street/Nr.)

Customer Service --> Orders (Details General)

110

String

Große Fleischergasse 11

Address_Remarks

Address remark

Customer Service --> Orders (Details General)

255

String

Hinterhaus 2

AddrNoChargeVAT

Boolean

AddrNr

13

String

AddrRef

Line number in the corresponding table of the database

Database

Integer

2514

Salutation

Salutation

Customer Service --> Orders (Details General)

60

String

Mr.

ASort

2

String

AuszugNr

10

String

BackOrderItemsCount

Number or back ordered items (number of orderlines)

Customer Service --> Orders (Details General)

Integer

1

BankFeeAmmount

Double

BankName

Bank name

Customer Service --> Orders (Details General)

20

String

Hypo bank

BaseCurrency

Shop currency code

3

String

CHF

Barcode

14

String

BIC

BIC

Customer Service --> Orders (Details General)

11

String

DGTBHNEZK

BiCity_Zip

Billing details (City/ZIP)

Customer Service --> Orders (Details General)

11

String

Leipzig 04109

BillCntName

Billing details (Country name)

Customer Service --> Orders (Details General)

61

String

Deutschland

BillingCountryIsInEurope

Billing country belongs to EU

-

-

Boolean

TRUE

BiZip_City

Billing details (ZIP/City)

Customer Service --> Orders (Details General)

60

String

04109 Leipzig

Bi_Salutation_Name

Billing details (Salutation/ First Name/ Last Name)

Customer Service --> Orders (Details General)

61

String

Mr. John Doe

BLZ

Bank Code

Customer Service --> Orders (Details General)

8

String

10010010

BoxDescription

Box information (Description)

ControlCenter --> Tables (Boxes)

50

String

1-1-1-1

BoxNr

Box Nr., to which the order is scanned in

Customer Service --> Orders (Details Item)

Integer

200

BuchuText

30

String

CardCheck

20

String

CardDate

DateTime

CardExp

Credit card valid until

Customer Service --> Orders (Details General)

4

String

2051

CardName

Credit card holder(First name/Last name)

Customer Service --> Orders (Details General)

60

String

John VISA Doe

CardNr

Credit card number

Customer Service --> Orders (Details General)

25

String

111111

CardType

Credit card type

Customer Service --> Orders (Details General)

2

String

VI

Careof

Billing details (Company)

Customer Service --> Orders (Details General)

60

String

Descartes Systems (Germany) GmbH

cBoxNr

Box Nr., to which the order is scanned in

Customer Service --> Orders (Details General)

20

String

200

CCAddFee

Credit card fee

Double

CCFeeCurrency

Credit card fee currency

3

String

EUR

CCFeeProvision

Commission for credit card fee

Double

CCPAuthCode

CCP authentication code

1

String

CCPChargedSoFar

Double

CCPNumOfTries

Integer

ccpPayID

CCP PayID

Customer Service --> Orders (Details General) -->payID

50

String

1-12345678

CCPPaymentDone

CCP Payment successful

1

String

N

CCPReCharge

CCP Charge successful

1

String

N

ccpSetFailLastTime

DateTime

30.09.2014 14:04:43

ccpSetFailTries

Integer

CCPShipCost ChargedYN

1

String

ccpTransID

CCP Transaction ID

Customer Service --> Invoices

50

String

2013-08-20_ 11:33:46.067

Cell

2

String

ChargeVAT

1

String

ChargeVAT_1

Charge VAT

1

String

Y

CheckDigitACode

1

String

CheckDigitSCode

1

String

City

Biling details (City)

Customer Service --> Orders (Details General)

50

String

Leipzig

ConnectedInvoicesCount

shows how many invoices belong to the customer order

Integer

1

CostChargeCurrency

Currency of costs for debiting

3

String

EUR

CostChargeShop

Double

0

Country

Billing details (Country)

Customer Service --> Orders (Details General)

3

String

D

CreateDate

Invoice creation date

Customer Service --> Invoices

DateTime

20.08.2013 11:18:29

CreateEmp

Created by

Customer Service --> Invoices

20

String

master

CustKey

Internal customer number

Database

Longint

706

customernrexternal

Customer number

Customer Service --> Customer details

60

String

999999

CustomerOf

Shop ID

ControlCenter --> Tables (Shops)

3

String

LEO

CustRef

Line number in the corresponding table of the database

Database

Integer

706

DatevAccNr

DATEV Account Number

Customer Service --> Customer details

LargeInt

102621

Depot

2

String

Discount

Double

DiscountTotal

Discount total of the invoice

Customer Service --> Invoices

Double

21,618

Discount_OrderCurr

Discount total of the invoice in order currency

Customer Service --> Invoices

Double

DPDZIP

20

String

DueDate

Invoice due date

Customer Service --> Invoices

DateTime

03.09.2013 11:18:29

email

Billing info (E-mail)

Customer Service --> Orders (Details General)

60

String

pixisupport@ support.eu

email2

E-mail 2

ControlCenter --> Tables (Shops)

100

String

mail2@pixi.eu

ESort

2

String

ExchRate_BaseToOrder

Exchange rate from shop currency to order currency for the invoice

ExtrasID

Extras

Customer Service --> Orders (Details General)

100

String

7210

ExtrasNotice

Shipping date

Customer Service --> Orders (Details General)

100

String

E 06/12/2014 V

ExtrasNoticeRight

Shipping date

Customer Service --> Orders (Details General)

100

String

06/12/2014 V

ExtrasText

100

String

Zeit der Zustellung - vor 12 Uhr

FirstName

20

String

Fulfillment

Boolean

GCHInvoice8Nr

10

String

GCHLongChecksum

1

String

GCHOrder12NR

12

String

GCHShippingType

Product

Customer Service --> Orders (Details General)

50

String

7202

GCHTotal10Nr

10

String

GiftMessage

Gift message

Customer Service --> Orders (Details General)

1000

String

Happy birthday :-)

GNMcharge

1

String

HermesCODAmount

20

String

HermesOrdererID

Double

Hermes_DepotName

4

String

IBAN

IBAN

Customer Service --> Orders (Details General)

20

String

DE1234654378946

InvDate

Invoice creation date

Customer Service --> Invoices

DateTime

20.08.2013 11:18:29

InvLineCount

Number or invoice lines in the invoice

Customer Service --> Invoices

Integer

8

InvLocationID

Location ID

HKEY_LOCAL_MACHINE SOFTWARE Wow6432Node MadgeniusesPixi (64Bit)

3

String

1

InvoiceDueDate

Invoice Due Date

Customer Service --> Customer Account --> Reminder options

Integer

7

InvoiceKey

Line number in the table of the corresponding database

Database

Longint

212

InvoiceKey_1

Line number in the table of the corresponding database

Database

Longint

212

InvoiceMailSent

Boolean

InvoiceNr

Invoice number

Customer Service --> Invoices

20

String

ELI0000020

InvoiceType

Integer

InvShipLock

1

String

InvShopID

Shop ID

ControlCenter --> Tables (Shops)

3

String

LEO

InvTrackNumber

30

String

IsPackageLost

1

String

IssueNr

2

String

LabelType

10

String

CountryKenn

2

String

LastName

30

String

LocAddress

Location Address

ControlCenter --> Tables (Locations)

200

String

Am Bahnsteig 9

LocationName

Location Name

ControlCenter --> Tables (Locations)

50

String

GeniusNet

LocCity

Location City

ControlCenter --> Tables (Locations)

50

String

Taufkirchen

LocCntName

Location Country

ControlCenter --> Tables (Locations)

100

String

Slovenia

LocCompany

Location Company

ControlCenter --> Tables (Locations)

50

String

GeniusNet

LocCountry

Location Country

ControlCenter --> Tables (Locations)

3

String

D

LocState

20

String

LocZip

Location ZIP

ControlCenter --> Tables (Locations)

20

String

82024

LSDate

DateTime

LSNr

Integer

Minute

Minute of invoice creation

Customer Service --> Invoices

Integer

18

name

Billing details (First name/Last name)

Customer Service --> Orders (Details General)

60

String

John Doe

121 (from pixi 19.11 on)

Name2

60

String

NODRef

Integer

NotAvailableItems Count

Number of not available items (Number of order lines)

Customer Service --> Orders (Details Item)

Integer

2

Note

255

String

note1

255

String

OrderCurrency

Order currency code

Customer Service --> Orders (Details General --> Currency)

3

String

EUR

OrderDate

Integer

20.08.2013 10:51:31

OrderNr

Order number pixi*

Customer Service --> Orders

50

String

138864

OrderNrExternal

Order number Shop

Customer Service --> Orders

Double

P138864

OrderTagList

OrderType

Order type

Customer Service --> Orders

3

String

B2C

PackageGrossWeight

Package Gross Weight

Shipping (SHIP OUT)

Double

11,68

PackageNetWeight

Integer

Packages

Double

PackageTypes

Package Type name(s) that are associated with the invoice; multiple names are separated with a semi-colon

Control Center > Package Types table > Name

1000

String

UPS Box 10kg

PaidAtCreation

Double

PaidByCustomer

DateTime

PayDay

Date of payments

Customer Service --> Invoices

DateTime

20.08.2013 11:18:29

Payed

Double

PayedSum

Paid Sum

Customer Service --> Invoices

1

String

0

Payment

Payment Type

ControlCenter --> Tables (Locations)

50

String

R

PaymentText

Payment Type

Customer Service --> Orders (Details General)

60

String

Offene Rechnung

Phone

Shipping details (Phone number.)

Customer Service --> Orders (Details General)

60

String

089/987654

Phone2

Integer

PLHref

1

String

Print2Copies

DateTime

PrintDate

1

String

Printed

50

String

QR code

For additional information see below ...

-

-

JPEG

Swiss QR Invoice

Referrer

Referrer

Customer Service --> Orders

String

Google AdWords

RefToInvoiceKey

20

String

RefToInvoiceNr

DateTime

Reminder1Date

Not used anymore

DateTime

Reminder2Date

Not used anymore

DateTime

Reminder3Date

Not used anymore

Double

ReminderCosts

Integer

ReminderLevel

1

String

ReminderProcessed

Not used anymore

3

String

ReminderReason

Not used anymore

50

String

retTrackID

Return Tracking ID

Customer Service --> Invoices

512

String

3547

retTrackIDhist

Return Tracking ID

Customer Service --> Invoices

1

String

0003547;

ReturnClosed

100

String

ReturnCostNoVAT

Return costs without VAT

Customer Service > Return

Double

ReturnCostsAmount

Return costs

Customer Service > Return

Double

ReturnCostsAmount_OrderCurr

Return costs in Order currency

Customer Service > Return

Double

ReturnReason

4

String

ReturnSupplier

10

String

RFileVersion

Double

RLSCost

DateTime

RLSDate

3

String

Route

200

String

SAddress

Shipping details Street/Nr.

Customer Service --> Orders (Details General)

20

String

Georgring 4

SSalutation

Shipping details Salutation

Customer Service --> Orders (Details General)

DateTime

Mrs.

ScanOutDate

Date of scan out

Customer Service --> Orders (Details General)

100

String

20.08.2013

SCareOf

Shipping details Company

Customer Service --> Orders (Details General)

100

String

Software GmbH

SCity

Shipping details City

Customer Service --> Orders (Details General)

3

String

München

SCountry

Shipping details Country

Customer Service --> Orders (Details General)

71

String

D

SeCity_Zip

Location Address City/ZIP

ControlCenter --> Tables (Locations)

71

String

Taufkirchen 82024

SeZip_City

Location Address ZIP/City

ControlCenter --> Tables (Locations)

121

String

82024 Taufkirchen

ShCity_Zip

Shipping details City/ZIP

Customer Service --> Orders (Details General)

121

String

München 89056

ShipAdrRef

Line number in the corresponding table of the database

Database

Integer

2515

ShipC1DPD

3

String

ShipC2DPD

8

String

ShipCntName

Shipping details Country

Customer Service --> Orders (Details General)

100

String

DeutschCountry

ShipCode

60

String

ShipCode1

60

String

ShipCostEUR

Shipping costs (Gross)

Customer Service --> Orders (Details General)

Double

3,9

ShipCostNoVAT

Shipping costs (Net)

Double

3,3626

ShipCostNoVAT_ OrderCurr

Shipping costs Foreign currency (Net)

Double

###########

ShipCostUSD

Shipping costs Foreign currency (Gross)

Double

3,9

ShipDate

Ship on date

Customer Service --> Orders (Details General)

DateTime

22.08.2013

ShipmentTrackingID

100

String

ShippedByVendor

Boolean

ShippingCountryIsInEurope

Shipping country belongs to the EU

-

-

Boolean

TRUE

ShippingType

Shipping type e.g. Express

1

String

E

ShipVendor

Shipping vendor

Customer Service --> Orders (Details General)

3

String

DPD

ShipVendor Increment1

Integer

ShipVendor Increment1_1

Integer

ShipVendorName

Shipping vendor

Customer Service --> Orders (Details General)

50

String

DPD

ShopBIC

BIC from Shop

Control Center > Tab Tables > Table Shops

11

String

AARBDE5W860

ShopCreditorID

Creditor ID from Shop (for SEPA)

Control Center > Tab Tables > Table Shops

20

String

DE98ZZZ09999999999

ShopIBAN

IBAN from Shop

Control Center > Tab Tables > Table Shops

20

String

DE21301204000000015228

shop_note

Comment from the Shop

Customer Service --> Orders (Details General)

8000

String

Great order!

ShZip_City

Shipping details ZIP/City

Customer Service --> Orders (Details General)

121

String

89056 München

Sh_Salutation_Name

Mrs. Maria Musterfrau

si_address

Shop information SI Address

ControlCenter --> Tables (Shops)

100

String

ELI pixi

si_address1

Shop information SI Address 1

ControlCenter --> Tables (Shops)

100

String

Fleischerstr. 15

si_address2

Shop information SI Address 2

ControlCenter --> Tables (Shops)

100

String

PassageKino

si_email

100

String

si_fax

Shop information SI Fax

ControlCenter --> Tables (Shops)

100

String

0341/13

si_fon

Shop information SI Phone

ControlCenter --> Tables (Shops)

100

String

0341/11

si_footline1

Shop information SI Footline 1

ControlCenter --> Tables (Shops)

100

String

DE123456 987/654/31

si_footline2

Shop information SI Footline 2

ControlCenter --> Tables (Shops)

100

String

DEELI46543789465 DGTBHNELI

si_footline3

Shop information SI Footline 3

ControlCenter --> Tables (Shops)

100

String

191919 50050050

si_footline4

Shop information SI Footline 4

ControlCenter --> Tables (Shops)

100

String

Spaßbank

si_headline

Shop information SI Headline

ControlCenter --> Tables (Shops)

100

String

www.ELI-pixi.eu

si_logoheight

Shop information SI Logo height

ControlCenter --> Tables (Shops)

Integer

si_logoleft

Shop information SI Logo Links

ControlCenter --> Tables (Shops)

Integer

si_logoname

Shop information SI Name des Logos

ControlCenter --> Tables (Shops)

100

String

ELI

si_logotop

Shop information SI Logo Oben

ControlCenter --> Tables (Shops)

Integer

si_logowidth

Shop information SI Logo Width

ControlCenter --> Tables (Shops)

Integer

si_webaddr

Shop information SI Web-Address

ControlCenter --> Tables (Shops)

100

String

www.ELI-pixi.eu

si_zipcity

Shop information SI ZIP

ControlCenter --> Tables (Shops)

100

String

04100 InnenCity

SkontoAbz

Double

skontoprozent

Integer

SName

Shipping details First name/Last name

Customer Service --> Orders (Details General)

100

String

Maria Musterfrau

SName2

100

String

SState

Shipping address State

Customer Service --> Orders (Details General)

20

String

State

Billing address State

Customer Service --> Orders (Details General)

3

String

StockNote

Memo

SubCell

2

String

SubShopLogo

SubShop-Logo

Customer Service --> Orders

50

String

logo-sushop.jpg

SubShopName

SubShop Name

Customer Service --> Orders

50

String

SUB-Shop

SUGKTO

6

String

SumInvLineAmountDiff

shows differences between total price of bundles and total price of single items (gross)

Double

SumInvLineAmountDiff_Net

shows differences between total price of bundles and total price of single items (net)

Double

SumItemAmount

Sum of all items in the invoice (Value of items)

106,49

SumItemAmountNoVAT

Sum of all items in the invoice (Net value of items)

91,8072

Summary

Double

0

Supporter

60

String

SupportPhone

60

String

SZip

Shipping details ZIP

Customer Service > Orders (Details General)

20

String

89056

TaxRate

Used VAT rate of the item

Customer Service > Orders (Details Items)

Integer

7

TextIfNoInvlines

120

String

TimesPrinted

Numer of times that the invoice was printed

Integer

8

total

Invoice total Gross

Customer Service > Invoices

Double

10,39

Total_BaseCurr

Invoice total in shop currency

TotalEUR

Invoice total Gross

Customer Service > Invoices

10,39

TotalNoReturnCost

Invoice total Gross - Return costs Gross

Customer Service > Return

Double

TotalNoReturnCost_OrderCurr

Invoice total Foreign currency Gross - Return costs Foreign currency Gross

Customer Service > Return

Double

TotalNoShipCost

Invoice total Gross - Shipping costs Gross

6,49

TotalNoShipCost_ OrderCurr

Invoice total Foreign currency Gross - Shipping costs Foreign currency Gross

6,49

TotalNoVAT

Invoice total Net

Double

8,9575

TotalNoVAT_OrderCurr

Double

TotalUSD

Grand total Foreign currency

Customer Service --> Invoices

Double

10,39

Total_OrderCurr

Grand total Foreign currency

Customer Service --> Invoices

10,39

Total_ShipCost

Shipping costs

Customer Service --> Orders (Details General)

3,9

Total_ShipCost_ OrderCurr

Shipping costs Foreign currency

Customer Service --> Orders (Details General)

3,9

TrackingIDsent

DateTime

UpdateDate

Order status updated to AUS

Customer Service --> Orders (Details Item --> Order line history)

DateTime

20.08.2013 11:20:28

UpdateEmp

Updated by

Customer Service --> Orders (Details Item --> Order line history)

20

String

master

UseShipAddr

1

String

Y

UsStId

Billing details VAT-ID

Customer Service --> Orders (Details General)

20

String

123456789

VATBaseHigh

Basis for the high VAT calculation

Double

36,1341

VATBaseHigh_ OrderCurr

Basis for the high VAT calculation in order currency

Double

36,1341

VATBaseHigh_ ReturnCosts

Basis for the high VAT calculation for return costs

Customer Service > Return

Double

VATBaseHigh_ ShipCost

Basis for the high VAT calculation for shipping costs

Double

2,521

VATBaseLow

Basis for the low VAT calculation

Double

36,1341

VATBaseLow_OrderCurr

Basis for the low VAT calculation in order currency

Double

36,1341

VATBaseLow_ReturnCosts

Basis for the low VAT calculation for return costs

Customer Service > Return

Double

VATBaseLow_ ShipCost

Basis for the low VAT calculation for shipping costs

Double

2,521

VATHigh

High VAT amount

Double

6,8654

VATHighPerc

High VAT percentage

ControlCenter --> Tables (VAT Rates)

Double

19

VATHigh_OrderCurr

High VAT amount in order currency

Double

6,8654

Note: contains the VAT of Shipping costs, but not the VAT of the return costs

VATHText

High VAT as text

ControlCenter --> Tables (VAT Rates)

30

String

19.00

VATHtext1

High VAT as text in %

ControlCenter --> Tables (VAT Rates)

31

String

19.00%

VATinShipCost

VAT in Shipping costs

ControlCenter --> Tables (VAT Rates)

1

String

Y

VATLow

Low VAT amount

Double

6,8654

VATLowPerc

Low VAT amount in %

ControlCenter --> Tables (VAT Rates)

Double

7

VATLow_OrderCurr

Low VAT amount in order currency

Double

6,8654

Note: contains the VAT of Shipping costs, but not the VAT of the return costs

VATLText

Low VAT as text

ControlCenter --> Tables (VAT Rates)

30

String

7.00

VATLtext1

Low VAT as text in %

ControlCenter --> Tables (VAT Rates)

31

String

7.00%

VATNo

20

String

VATType

1

String

Verfahren

Method

Customer Service --> Orders (Details General)

50

String

72

VoucherID

Voucher ID

Customer Service --> Orders (Details General)

60

String

5424_138864

VoucherSum_ OrderCurr

Voucher amount

Customer Service --> Orders (Details General)

Double

100

Weight

7

String

Zip

Billing details (ZIP)

Customer Service --> Orders (Details General)

10

String

4109