Transaction Data

Transaction data is exported to a JSON file named Transaction.json and contains the SaleLines object.

SaleLines

Key The key paired to this data set in the format [SalelineSaleKey] [SalelineLineNo], e.g. the first saleline on sale 001-00001 would be key 001-000011, second saleline would be 001-000012.
SalelineAge

Integer, max 4 digits, can be null

For sold items, the number of days old when sold.

SalelineAmount

Decimal, max 18 digits, cannot be null

The retail amount for this saleline.

SalelineBonusPct

Decimal, max 18 digits, can be null

The spiff assigned to this sold item.

SalelineccBatchKey

String, max 255 characters, can be null

If using integrated credit card processing, the credit card batch key for this saleline.

SalelineccReceiptData

String, max 63,999 characters, can be null

If using integrated credit card processing, the credit card receipt data.

SalelineccReversalData

String, max 63,999 characters, can be null

If using integrated credit card processing, the credit card void data.

SalelineCost

Decimal, max 18 digits, cannot be null

The cost for this saleline.

SalelineCustAccountKey

String, max 50 characters, cannot be null

For linked customer accounts (spouse/partner), the customer number of the primary account that this saleline belongs to. For non-linked accounts, this will be the same as SalelineCustKey.

SalelineCustKey

String, max 50 characters, cannot be null

The customer associated with this saleline.

SalelineDesc

String, max 63,999 characters, can be null

The description for this saleline.

SalelineEnvKey

String, max 50 characters, can be null

For layaways only, the envelope number.

SalelineEstTax

?

?

?

SalelineInstanceOf

String, max 255 characters, can be null

References itKey for bulk master record for this sold bulk instance.

SalelineItemKey

String, max 50 characters, can be null

The item number associated with this saleline.

SalelineItemType

String, max 1 character, cannot be null

The type of item.

S Stock M Memo
C Consignment O Special Order
T Trade-in V Catalog Entry
F Faux Model L Live Model
A Assembled P Takeoff
SalelineKey  
SalelineKey2  
SalelineKey3  
SalelineLineNo

Integer, max 3 digits, cannot be null

The saleline number; a sale is comprised of salelines with each line representing an item, service, payment, pickup, or tender. SalelineKey, SalelineKey2, and SalelineKey3 describe what this line contains.

SalelineLinePart

Integer, max 3 digits, can be null

When selling bulk items, virtual salelines are created for each quantity. This number references the originating saleline for these.

SalelineMemo  
SalelineNontax

?

?

?

SalelineOrigLineNo

String, max 50 characters, can be null

For subsequent transactions such as payments and pickups, references the originating SalelineLineNo. For one-time transactions, such as purchasing an item, references itself, i.e. repeats SalelineLineNo.

SalelineOrigPrice

Decimal, max 18 digits, can be null

For special orders, the original price entered for the ordered item.

SalelineOrigSaleKey

String, max 50 characters, cannot be null

For subsequent transactions such as payments and pickups, references the originating SalelineSaleKey. For one-time transactions, such as purchasing an item, references itself, i.e. repeats SalelineSaleKey.

SalelinePosted

Boolean, True/False, cannot be null

True This saleline has been posted to QuickBooks.
False This saleline has not been posted to QuickBooks.
SalelinePostedHQ

Not used

SalelineQty

Integer, max 4 digits, can be null

The quantity of items sold on this saleline.

SalelineReceiptData

?

?

?

SalelineRedeemed

Decimal, max 18 digits, can be null

The amount redeemed from a referral card.

SalelineReferralAmt

Decimal, max 18 digits, can be null

The referral bonus earned by the referring customer [SalelineReferrer].

SalelineReferrer

String, max 255 characters, can be null

The customer number of the referring customer.

SalelineRefNo

String, max 50 characters, can be null

?

SalelineRewAmt

Decimal, max 18 digits, can be null

The amount credited or debited from the rewards balance.

SalelineRewKey

String, max 255 characters, can be null

The number for the rewards card to be credited for this saleline.

SalelineRewNotes

String, max 255 characters, can be null

Rewards information for this saleline in the format [Rewards per Dollar] | [Qualifying # of Items].

SalelineSaleKey

String, max 50 characters, cannot be null

The sale number that this saleline is on.

SalelineSharePct

?

?

?

SalelineWhen

Date/Time, mm/dd/yyyy hh:mm:ss, cannot be null

The date/time this saleline was created.

SalelineWhen2 Not used
SalelineWhen3 Not used
SalelineWlkey

?

?

?

SalelineXfer

Boolean, True/False, cannot be null

True Flag saleline to be transferred in next multistore update cycle.
False Do not transfer saleline in next multistore update cycle.