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.
|
||||||||||||||||||||
| 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
|
||||||||||||||||||||
| 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
|