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
|