...
Field | Description | Length | Condition |
|---|
---------------- --------------------------------------- ------ -----------
Customer Customer Code 25
...
Customer | Customer Code | 25 | |
Account | Charge Account Code | 25 | |
Transaction Date | Transaction |
...
Date | 8 | MM/DD/YY |
Receipt |
...
Number | Transaction |
...
Number | 10 |
Cashier Cashier Login Id 10
...
Cashier | Cashier Login Id | 10 | |
Merchandise | Merchandise Total | 8 | No Decimal |
Non |
...
Merchandise | Non Merchandise |
...
Total | 8 | No Decimal |
Item |
...
Discounts | Total Item |
...
Discounts | 8 | No Decimal |
Transaction |
...
Disc | Total Transaction |
...
Discount | 8 | No Decimal |
Total |
...
Taxes | Total Taxes |
...
Paid | 8 | No Decimal |
Transaction Tot | Transaction Total (All Items Less Tax) |
...
8 | No Decimal | |
Tender |
...
Total | Total Amount |
...
Tendered | 8 | No Decimal |
Change |
...
Total | Total |
...
Change | 8 | No Decimal |
Transaction |
...
Time | Transaction Time (HHMM military format) |
...
4 | (HHMM) | |
Total |
...
Lines | Total Transaction |
...
Lines | 4 | |
Exchanged |
...
Amount | Merchandise Exchanged |
...
Amount | 8 | No Decimal |
Tax Exempt |
...
Total | Tax Exempt |
...
Total | 8 | No Decimal |
Trans Dsc |
...
Per | Transaction Discount |
...
percent | 4 | No Decimal |
Item |
...
Discount | Item Discount |
...
amount | 8 | No Decimal |
Payin |
...
Amount | Payin/Payout |
...
Amount | 8 | No Decimal |
Charged |
...
Amount | Amount Charged to this |
...
Account | 8 | No Decimal |
Tender Code |
...
#1 | POS Tender Code |
...
#1 | 2 | |
Tender Code |
...
#2 | POS Tender Code |
...
#2 | 2 | |
Tender Code |
...
#3 | POS Tender Code |
...
#3 | 2 | |
Tender Code |
...
#4 | POS Tender Code |
...
#4 | 2 | |
Tender Code |
...
#5 | POS Tender Code |
...
#5 | 2 | |
Tender Amt |
...
#1 | Tender Amount |
...
#1 | 8 | No Decimal |
Tender Amt |
...
#2 | Tender Amount |
...
#2 | 8 | No Decimal |
Tender Amt |
...
#3 | Tender Amount |
...
#3 | 8 | No Decimal |
Tender Amt |
...
#4 | Tender Amount |
...
#4 | 8 | No Decimal |
Tender Amt |
...
#5 | Tender Amount |
...
#5 | 8 | No Decimal |
Change |
...
Due | Amount of Change |
...
Due | 8 | No Decimal |
Store |
...
POS Store |
...
Number | 3 | |
Register |
...
POS Register |
...
Number | 3 | |
Trans Disc |
...
Code | POS Transaction Discount |
...
Code | 3 | |
Payin |
...
Code | POS Payin |
...
Code | 3 | |
Manual |
...
Tax | Manual Tax (1=yes,0=No) |
...
1 | (0 or 1) | |
Tax Exempt |
...
# | Tax Exempt |
...
Number | 10 | |
Type |
...
Filler | 1 | |
Transaction Code | Type of |
...
Transaction | 2 |
...
(SA = sale, RT = Return, PV = Post Void, |
...
PI = Payin, PO = Payout) |
Apply |
...
Number | POS entered apply number for |
...
payment | 20 | |
Create |
...
Date | Date Transaction was |
...
created | 8 | MM/DD/YY |
...
Items | Total Items on |
...
Transaction | 4 |
...
Status | Status | 1 |
...
(S = Sales, R = Returns, V = Post Void, |
...
I = Payin, O = Payout) |
...
...
311 Bytes |
AR Receipt Detail Export
Exports all mail order and POS receipt details that have an A/R invoice.
PrismCore Export_AR_Customer_Receipt_Detail Table Names
(Use this for interfaces that bypass WPConsole and go directly to prism_trn)
Column |
|---|
...
Data |
|---|
...
------------------- ---------- ------ ------ ------ -----------------------------------
receipt_dtl_id int 4 10 0 Index Key
receipt_id int 4 10 0 Null
...
Type | Length | Prec | Scale | Description | |
|---|---|---|---|---|---|
receipt_dtl_id | int | 4 | 10 | 0 | Index Key |
receipt_id | int | 4 | 10 | 0 | Null |
invoice_detail_id | int | 4 | 10 | 0 | Link to Invoice Detail |
store_ |
...
id | int | 4 | 10 | 0 | POSID of Store |
customer_ |
...
acct | char | 25 | 25 | CustomerID | |
agency_ |
...
number | char | 25 | 25 | Account Code | |
receipt_ |
...
number | char | 25 | 25 | Receipt Number | |
receipt_ |
...
date | datetime | 8 | 23 | 3 | Date of Receipt |
cat_ |
...
isbn | char | 20 | 20 | ISBN of Book | |
dcc_ |
...
code | char | 10 | 10 | 6 digit DCC code for item |
...
description | char | 128 | 128 | Description of item |
...
sku | int | 4 | 10 | 0 | SKU of item |
...
quantity | int | 4 | 10 | 0 | Quantity of item |
...
price money 8 19 4 Price per unit of item
...
price | money | 8 | 19 | 4 | Price per unit of item |
discount | money | 8 | 19 | 4 | Amount of discount for item |
...
tax | money | 8 | 19 | 4 | Tax on item |
tm_ |
...
stamp | timestamp | 8 | 8 | SQL timestamp |
...
ASCII Delimited Format
customer_ |
...
acct | char | 25 | CustomerID |
agency_ |
...
number | char | 25 | Account Code |
receipt_ |
...
number | char | 25 | Receipt Number |
receipt_ |
...
date | datetime | Date of Receipt | |
cat_ |
...
isbn | char | 20 | ISBN of |
...
Book |
dcc_ |
...
code | char | 10 | 6 digit DCC code for |
...
description char 28 Description of item
...
item | |||
description | char | 28 | Description of item |
sku | int | SKU of item |
...
quantity | int | Quantity of item |
...
price | money | Price per unit of item |
...
discount | money | Amount of discount for item |
...
tax | money | Tax on item | |
store_ |
...
id | int | POSID of Store |
XML Definition
The XML definition uses the same fields as the ASCII Formats. Note: some fields will be omitted if there is no corresponding data. All attributes are CDATA #IMPLIED.
...
</trn_ar_rcpt_dtl_exports>
PRISM Format for AR Receipt Detail Export
Filename = Ixxxxxxx.yyy xxxxxxx = unique number, yyy=store number
Note: Although the receipt_number field is defined as having a maximum length of 25 characters in the ASCII formats listed above, the PRISM format for Transaction (Transaction Number) is only 10 characters max. The same applies for AR Receipt Export, i.e., Receipt Number (Transaction Number).
Field | Description |
|---|
...
Length |
|---|
...
---------------- --------------------------------------- ------ -----------
Transaction Transaction Number 10
Line Number Transaction Line 10
Catalog/ISBN Catalog ISBN Number 15
...
Condition | |||
|---|---|---|---|
Transaction | Transaction Number | 10 | |
Line Number | Transaction Line | 10 | |
Catalog/ISBN | Catalog ISBN Number | 15 | |
DCC Code | Item Department/Class/ |
...
Category | 6 |
...
Description | Item Description | 25 | |
Item |
...
SKU | Item SKU |
...
number | 8 |
...
Quantity | Quantity |
...
Sold | 6 | |
Item |
...
Price | Item |
...
Price | 8 | |
Extended |
...
Price | Extended Price (Quantity * Item Price) |
...
8 | ||
Item |
...
Discount | Item Discount |
...
Amount | 8 | |
Non Merch |
...
Amount | Non Merchandise |
...
Amount | 8 | |
Non Merch |
...
Code | POS Non Merchandise |
...
Code | 3 | |
Item Disc |
...
Code | POS Item Discount |
...
Code | 3 | |
Item Disc |
...
Rate | POS Item Discount |
...
Rate | 8 | No Decimal |
Store |
...
POS Store |
...
Number | 3 | |
Transaction |
...
Disc | Transaction Discount for this |
...
item | 8 | No Decimal |
Customer |
...
Customer |
...
Code | 25 |
...
Account | Charge Account |
...
Code | 25 | |
Tax |
...
Amount | Tax Amount for this |
...
item | 8 | No |
...
Decimal |
...
195 |
...
Bytes |