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 |
For sold items, the number of days old when sold. |
||||||||||||||||||||
SalelineAmount |
The retail amount for this saleline. |
||||||||||||||||||||
SalelineBonusPct |
The spiff assigned to this sold item. |
||||||||||||||||||||
SalelineccBatchKey |
If using integrated credit card processing, the credit card batch key for this saleline. |
||||||||||||||||||||
SalelineccReceiptData |
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 |
The cost for this saleline. |
||||||||||||||||||||
SalelineCustAccountKey |
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 |
The customer associated with this saleline. |
||||||||||||||||||||
SalelineDesc |
The description for this saleline. |
||||||||||||||||||||
SalelineEnvKey |
For layaways only, the envelope number. |
||||||||||||||||||||
SalelineEstTax |
? ? ? |
||||||||||||||||||||
SalelineInstanceOf |
References itKey for bulk master record for this sold bulk instance. |
||||||||||||||||||||
SalelineItemKey |
The item number associated with this saleline. |
||||||||||||||||||||
SalelineItemType |
The type of item.
|
||||||||||||||||||||
SalelineKey | |||||||||||||||||||||
SalelineKey2 | |||||||||||||||||||||
SalelineKey3 | |||||||||||||||||||||
SalelineLineNo |
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 |
When selling bulk items, virtual salelines are created for each quantity. This number references the originating saleline for these. |
||||||||||||||||||||
SalelineMemo | |||||||||||||||||||||
SalelineNontax |
? ? ? |
||||||||||||||||||||
SalelineOrigLineNo |
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 |
For special orders, the original price entered for the ordered item. |
||||||||||||||||||||
SalelineOrigSaleKey |
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 |
|
||||||||||||||||||||
SalelinePostedHQ |
Not used |
||||||||||||||||||||
SalelineQty |
The quantity of items sold on this saleline. |
||||||||||||||||||||
SalelineReceiptData |
? ? ? |
||||||||||||||||||||
SalelineRedeemed |
The amount redeemed from a referral card. |
||||||||||||||||||||
SalelineReferralAmt |
The referral bonus earned by the referring customer [SalelineReferrer]. |
||||||||||||||||||||
SalelineReferrer |
The customer number of the referring customer. |
||||||||||||||||||||
SalelineRefNo |
? |
||||||||||||||||||||
SalelineRewAmt |
The amount credited or debited from the rewards balance. |
||||||||||||||||||||
SalelineRewKey |
The number for the rewards card to be credited for this saleline. |
||||||||||||||||||||
SalelineRewNotes |
Rewards information for this saleline in the format [Rewards per Dollar] | [Qualifying # of Items]. |
||||||||||||||||||||
SalelineSaleKey |
The sale number that this saleline is on. |
||||||||||||||||||||
SalelineSharePct |
? ? ? |
||||||||||||||||||||
SalelineWhen |
The date/time this saleline was created. |
||||||||||||||||||||
SalelineWhen2 | Not used | ||||||||||||||||||||
SalelineWhen3 | Not used | ||||||||||||||||||||
SalelineWlkey |
? ? ? |
||||||||||||||||||||
SalelineXfer |
|