Work Order Ticket | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 16: Working with Price Tickets (WPTW) |
Chapter 15: Working with the Retail Point of Sale Interface
Purpose: The Retail Point of Sale Interface is used to track inventory information for a retail store. The interface allows you to transfer inventory information from CWDirect to Cam Data's retail point of sale system. This interface allows you to:
• Send item and pricing information from CWDirect to the Cam Data POS system.
• Send store restock inventory transactions from CWDirect to the Cam Data POS system. CWDirect writes a T (transfer) adjustment when inventory is transferred from CWDirect to the POS system.
• Produce price tickets in CWDirect whenever a pick ticket containing a Retail Point of Sale record is processed through Pick Generation.
• Send sales order information from POS to CWDirect.
In order to use the Retail Point of Sale Interface, you must:
• enter Y in the Allow Price Overrides (D71) system control value
• enter R in the Mail order/retail field in Work with Order Type (fast path = WOTY)
You can process retail store restock requests through CWDirect by entering an order containing a sold to customer that represents a retail store. A sold to customer can represent a retail store if you define the retail store's logical warehouse in the Warehouse code field in the sold to customer file.
Retail point of sale process:
1. You create an order representing a retail store restock request. An order represents a retail store restock request if:
• The Mailorder/retail field for the order type on the order is set to R (retail).
• The sold to customer on the order represents a retail store (the Warehouse field for the customer contains a warehouse code whose Retail outlet field is set to Y).
2. During pick slip generation, the system looks at the Generate Price Tickets During Pick Slip Generation (I77) system control value to determine when a price ticket is printed.
• If this system control value is set to H (hanging format) or F (label format), the system prints price tickets during pick slip generation.
• If this system control value is set to N or blank, the system creates records in the Price Ticket Work file during pick slip generation. You can print the price tickets at the Work with Price Tickets Screen.
3. During billing, the system populates the following POS interface files:
• Adjustments/Transfer Interface File (this file contains information on the quantity of inventory being transferred from CWDirect to the POS system)
• SKUL Interface File (this file contains information on the items being transferred from CWDirect to the POS system)
• SKUS Interface File (this file contains pricing information for the items being transferred from CWDirect to the POS system)
4. You can then use the Load Cam Data Retail Interface Orders Screen (LPOS) to download the POS interface files that were generated through the Billing ASYNC from the iSeries to the POS system. The system downloads the files to the PC folder defined in the Retail PC Stock Transfer Shared Folder (F50) system control value.
When you download POS Interface files to Cam Data, the system creates two records for each interface file, a lock file (filename.LCK) to indicate that Cam Data has not yet processed the file and the actual file (filename.TXT).
CWDirect uses the following logic to name each POS interface file:
• Adjustments/Transfer Interface File: ADJ ccss.TXT where cc represents the CWDirect company number the adjustment/transfer record was created in and ss represents the store number (the warehouse code defined for the retail sold to customer) where the retail inventory was transferred to.
• SKUL Interface File: SKUL cc.TXT where cc represents the CWDirect company the SKUL record was created in.
• SKUS Interface File: SKUS cc.TXT where cc represents the CWDirect company the SKUS record was created in.
5. Once the Cam Data POS system processes the files that were downloaded, the POS system uploads the sales information. You can use the Load Cam Data Retail Interface Orders Screen to populate the Phone Orders (PHORDS) File with the information uploaded from Cam Data's POS system. The following steps are taken to upload sales information from the POS system to CWDirect:
• The system loads the Cam Data retail orders through Load Cam Data Retail Interface Orders Screen (LPOS).
• The system copies the POS Receipt interface files from the folder defined in the Retail PC POS Sales Upload Shared Folder (F56) system control value.
• The system then maps all of the fields defined in the POS Receipt file to the CWDirect Phone Order Interface file (see the Sample Phone Order File Record).
Point of Sale process: The following flowchart explains how CWDirect information is passed to Cam Data's POS system and how the POS system sends sales information to CWDirect.
In this chapter:
• Related System Control Values
• Work with Retail Stock Adjustments Screen (MDSA)
• Downloading Retail Stock Adjustments
• Work with Documents in Folders Screen
• Adjustments/Transfer Interface File
• Load Cam Data Retail Interface Orders Screen (LPOS)
• Sample Phone Order File Record
System Control Value |
Description |
Defines the print program name the system uses to print price tickets in hanging or label format. |
|
Indicates if the system generates price tickets during pick slip generation for retail store orders. |
|
Defines the shared folder the system uses to create and copy Cam Data POS download files. |
|
Defines the shared folder where Cam Data POS upload files are copied. |
Work with Retail Stock Adjustments Screen (MDSA)
Purpose: Use this screen to download the interface files that were generated through the Billing ASYNC from the iSeries to the PC POS system using Client Access/400. The system downloads the following interface files:
• Adjustments/Transfer interface file
• SKUL interface file
• SKUS interface file
How to display this screen: Enter MDSA in the Fast path field at the top of any menu or select Download Retail Stock Adjustments from a menu.
INX1174 DISPLAY Work with Retail Stock Adjustments 6/17/98 8:55:21 The KL Mail Order Company Folder: GARNET
-- CamData -- Opt Order # Cmp From To
Type options, press Enter. 4=Delete 8=Download
2699 55 00 01 2700 55 00 01 2701 55 00 01
F3=Exit F8=Work with Document F12=Cancel |
Field |
Description |
Folder |
The folder you wish to download the interface files to. The system downloads the interface files to the folder defined in the Retail PC Stock Transfer Shared Folder (F50) system control value. Alphanumeric, 10 positions; display-only. |
Order # |
The order number of the store restock order. Numeric, 10 positions; optional. |
Cam Data cmp |
The company where the Retail Stock Adjustments files were processed. Numeric, 2 positions; display-only. |
Cam Data from |
The store the inventory is transferred from as defined in the POS system. Numeric, 2 positions; optional. |
Cam Data to |
The store the inventory is transferred to as defined in the POS system. Numeric, 2 positions; optional. |
Screen Option |
Procedure |
Delete a retail stock adjustment file |
Enter 4 next to a retail stock adjustment file to delete it. |
Download a retail stock adjustment file |
Enter 8 next to the retail stock adjustment file you wish to download. See Downloading Retail Stock Adjustments. |
Work with a downloaded retail stock adjustments file |
Press F8. See Work with Documents in Folders Screen. |
Downloading Retail Stock Adjustments
Purpose: From the Work with Retail Stock Adjustments Screen (MDSA) you can also download Retail Stock Adjustments from the iSeries to the PC POS system using Client Access/400.
The following error messages display when you advance to the Work with Retail Stock Adjustments screen if POS interface files already exist in the folder defined in the Retail PC Stock Transfer Shared Folder (F50) system control value:
ADJT file conflicts exist
SKUL file conflicts exist
SKUS file conflicts exist
Download restricted.
To download: Enter 8 next to an interface file to download it. An error message displays if POS interface files already exist in the folder specified in the Retail PC Stock Transfer Shared Folder (F50) system control value:
Document (GARNET/ADJ5501.TXT already exists.
You must delete any existing POS interface files before you can download another interface file. Press F8 to advance to the Work with Documents in Folders Screen to delete POS interface files that exist.
Work with Documents in Folders Screen
Purpose: Use this screen to work with the POS interface files that you have downloaded to the folder defined in the Retail PC Stock Transfer Shared Folder (F50) system control value.
How to display this screen: Press F8 on the Work with Retail Stock Adjustments Screen (MDSA).
Work with Documents in Folders
Folder . . . GARNET Position to . . . . . . Starting characters
Type options (and Document), press Enter. 1=Create 2=Revise 3=Copy 4=Delete 5=View 6=Print 7=Rename 8=Details 9=Print options 10=Send 11=Spell 12=File remote 13=Paginate 14=Authority 15=Fill form
Opt Document Document Description Revised Type
ADJ5501.LCK ADJ5501.LCK 06/17/98 PCFILE ADJ5501.TXT ADJ5501.TXT 06/17/98 PCFILE SKUL55.LCK SKUL55.LCK 06/17/98 PCFILE SKUL55.TXT SKUL55.TXT 06/17/98 PCFILE SKUS55.LCK SKUS55.LCK 06/17/98 PCFILE SKUS55.TXT SKUS55.TXT 06/17/98 PCFILE
More... F3=Exit F4=Prompt F5=Refresh F10=Search for document F11=Display names only F12=Cancel F13=End search F24=More keys |
At this screen, you can delete a record by entering 4 next to it.
The POS interface files that you must delete before you can download another POS interface file are:
• ADJccss.LCK (Adjustments/Transfer interface file; where cc represents the company and ss represents the retail store)
• SKULcc.LCK (SKUL interface file, where cc represents the company)
• SKUScc.LCK (SKUS interface file, where cc represents the company)
The system places a lock on any interface file in the shared folder that has not been processed by the Cam Data POS system. When you download POS interface files, the system creates two records for each interface file. For example, ADJccss.TXT represents the actual file containing the Adjustments/Transfer interface information and ADJccss.LCK identifies the Adjustments/Transfer interface file as locked.
Adjustments/Transfer Interface File
Purpose: This file contains information on the quantity of inventory being transferred from CWDirect to the Cam Data point of sale system. Each adjustment/transfer record contains three record types:
• Header record
• Line record
• Optional information record
Field |
Attributes |
Value |
Line Descriptor |
Alphanumeric, 1 position, fixed length |
Hx always displays in this field. |
Adjustment/Transfer ID |
Alphanumeric, 10 positions, fixed length |
Cam Data populates this field. |
Xref Transfer ID |
Alphanumeric, 30 positions, variable length |
CWDirect order number from a restock order. |
Adjustment/Transfer Date |
Numeric, 6 positions MMDDYY format |
CWDirect Billing ASYNC date. |
Adjustment/Transfer Code |
Numeric, 255 positions, variable length |
04 always displays in this field. |
From Store |
Numeric, 99 positions, variable length |
00 always displays in this field. |
To Store |
Numeric, 99 positions, variable length |
01 always displays in this field. |
Adjusted By |
Numeric, 255 positions, variable length |
99 always displays in this field. |
Status |
Alphanumeric, 1 position, fixed length |
N always displays in this field. |
Last change date |
Numeric, 6 positions MMDDYY format |
CWDirect Billing ASYNC date. |
Version |
Alphanumeric, 1 position, fixed length |
Cam data populates this field. |
Last change by |
Numeric, 255 positions; variable length |
This field displays blank. |
Total quantity |
Numeric, 8 positions, variable length |
0 displays in this field. |
Field |
Attributes |
Value |
Line Descriptor |
Alphanumeric, 1 position, fixed length |
Lx always displays in this field. |
UPC |
Alphanumeric, 13 positions, variable length |
CWDirect short SKU from SKU record. This field is zero filled. |
Total Quantity |
Numeric, 3 positions, variable length |
CWDirect ship confirmed quantity. |
Cost: Dollars |
Numeric, 5 positions with 2 decimal places |
CWDirect average cost. |
Field |
Attributes |
Value |
Line Descriptor |
Alphanumeric, 1 position, fixed length |
Ox always displays in this field. |
Prepack Show |
Numeric, 1 position, fixed length |
1 always displays in this field. |
Order number |
2698 |
Billing Async date |
06/15/98 |
Short SKU |
1111 |
Confirmed quantity |
1 |
Average cost |
30.00 |
Adjustments/Transfer Header Record |
|
Field |
Value |
Line Descriptor |
"Hl" |
Adjustment/Transfer ID |
, , |
Xref Transfer ID |
"2698" |
Adjustment/Transfer Date |
"06-15-98" |
Adjustment/Transfer Code |
"04" |
From Store |
"00" |
To Store |
"01" |
Adjusted By |
"99" |
Status |
"N" |
Last Change Date |
"06-15-98" |
Version |
, , |
Last Change By |
, , |
Total Quantity |
"0" |
The adjustment/transfer header record in the Adjustments/Transfer Interface file:
"Hl", , "2698", "06-15-98", "04", "00", "99", "N", "06-15-98", , , "0"
Adjustments/Transfer Line Record |
|
Field |
Value |
Line Descriptor |
"Ll" |
UPC |
"001111" |
Total Quantity |
"1" |
Cost: Dollars |
"030.00" |
The adjustment/transfer line record in the Adjustments/Transfer Interface file is:
"Ll", "001111", "1", "030.00"
Adjustments/Transfer Optional Information Record |
|
Field |
Value |
Line Descriptor |
"Ol" |
Prepack Show |
"1" |
The adjustments/transfer optional information record displays in the Adjustments/Transfer Interface file is:
"Ol", "1"
Purpose: The SKUL Interface file contains information on the items being transferred from CWDirect to the Cam Data point of sale system. Each SKUL record contains two record types:
• SKUL record
• UPC record
Field |
Attributes |
Value |
Line Descriptor |
Alphanumeric, 1 position, fixed length |
Rl always displays in this field. |
SKU Number |
Numeric, 7 positions, variable length |
CWDirect short SKU. |
Vendor Code |
Alphanumeric, 3 positions, fixed length |
GAR always displays in this field. |
Vendor Style Name |
Alphanumeric, 12 positions, variable length |
The first 4 positions of the item, SKU element 1, SKU element 2. |
Vendor IP/PID |
Alphanumeric, 30 positions; variable length |
The first 4 positions of the item, SKU element 1, SKU element 2, vendor number defined for the item, vendor description. If a vendor is not defined for the item, the positions defined for the vendor number and vendor description will display blank. |
Department |
Numeric, 2 positions, variable length |
CWDirect long SKU department. If the long SKU department is greater than 99, the number is truncated to 2 positions. For example, if the long SKU department is 555, 55 displays in this field. |
Class |
Numeric, 2 positions, variable length |
The last 2 positions of CWDirect's long SKU class. |
Subclass |
Numeric, 3 positions, variable length |
255 always displays in this field. |
Color |
Numeric, 3 positions, variable length |
255 always displays in this field. |
Material |
Numeric, 3 positions, variable length |
255 always displays in this field. |
Season |
Numeric, 3 positions, variable length |
CWDirect offer code defined on the order header. If the offer code is alphanumeric or greater than 255, then 255 displays in this field. |
Sizerun |
Numeric, 3 positions, variable length |
0 always displays in this field. |
Description |
Alphanumeric, 19 positions, variable length |
The first 19 positions of the item description. |
Last Change Date |
Numeric, 6 positions in MMDDYY format |
CWDirect Billing ASYNC date. |
Lead Time |
Numeric, 4 positions, variable length |
This field always displays blank. |
SKU Voided |
Numeric, 1 position, fixed length |
0 always displays in this field. |
Vendor NRF Color |
Numeric, 3 positions, variable length |
0 always displays in this field. |
Stock Location |
Numeric, 5 positions, variable length |
0 always displays in this field. |
User Definable Code |
Numeric, 3 positions, variable length |
255 always displays in this field. |
Field |
Attributes |
Value |
Line Descriptor |
Alphanumeric, 1 position, fixed length |
Ul always displays in this field. |
SKU Number |
Numeric, 7 positions, variable length |
CWDirect short SKU. |
UPC |
Alphanumeric, 13 positions, variable length |
CWDirect short SKU. |
Item Size |
Numeric, 4 positions, variable length |
0 always displays in this field. |
Item Width |
Alphanumeric, 3 positions, variable length |
This field always displays blank. |
Short SKU |
1111 |
Item |
CTSNBL |
SKU Element 1 |
NAVY |
SKU Element 2 |
BOYS |
Vendor Number |
101 |
Vendor Description |
Northeastern US Vendor |
Long SKU Department |
39 |
Long SKU Class |
4923 |
Offer code |
BBQ |
Item Description |
Cotton T-Shirt Short Sleeve |
Billing Async Date |
06/15/98 |
SKUL Record |
|
Field |
Value |
Line Descriptor |
"Rl" |
SKU Number |
"001111" |
Vendor Code |
"GAR" |
Vendor Style Name |
"CTSNNAVYBOYS" |
Vendor ID/PID |
"CTSNNAVYBOYS-101-NORTHEAST" |
Department |
"39" |
Class |
"23" |
Subclass |
"255" |
Color |
"255" |
Material |
"255" |
Season |
"255" |
Sizerun |
"0" |
Description |
"COTTON T-SHIRT SHOR" |
Last Change Date |
"06-15-98" |
Lead Time |
, , |
SKU Voided |
"0" |
Vendor NRF Color |
"0" |
Stock Location |
"0" |
User Definable Code |
"255" |
The SKUL record in the SKUL Interface file is:
"Rl", "001111", "GAR", "CTSNAVYBOYS", "CTSNNAVYBOYS-101-NORTHEAST", "39", "23", "255", "255", "255", "255", "0", "COTTON T-SHIRT SHOR", "06-15-98", "0", "0", "0", "255"
UPC Record |
|
Field |
Value |
Line Descriptor |
"Ul" |
SKU Number |
"001111" |
UPC |
"001111" |
Item Size |
"0" |
Item Width |
, , |
The UPC record in the SKUL Interface file is:
"Ul", "001111", "001111", "0"
Purpose: The SKUS Interface file contains pricing information on the items being transferred from CWDirect to the Cam Data point of sale system. The system writes a record for each item ordered on a restock order.
Field |
Attributes |
Value |
Line Descriptor |
Alphanumeric, 1 position, fixed length |
Sl always displays in this field. |
Store |
Numeric, 99 positions, variable length |
01 always displays in this field. The CWDirect warehouse you are transferring inventory to. This is the logical warehouse defined for the retail store customer. |
UPC |
Alphanumeric, 13 positions, variable length |
CWDirect short SKU. |
Tax Mode |
Numeric, 1 position |
1 always displays in this field. |
Last Receive Date |
Numeric, 6 positions MMDDYY format |
CWDirect Billing ASYNC date. |
Last Receive Quantity |
Numeric, 3 positions, variable length |
CWDirect confirmed quantity. |
Mark Down Dollars |
Numeric, 2 decimal places |
0 always displays in this field. |
Retail Price: Dollars |
Numeric, 2 decimal places |
CWDirect selling unit price from the order detail. This is the price you wish to sell this item for in the outlet store. |
Cost: Dollars |
Numeric, 2 decimal places |
CWDirect average cost. |
Compare Price: Dollars |
Numeric, 2 decimal places |
CWDirect offer unit price from the order detail. This is the price you sell this item for in the catalog. |
Landed Cost: Dollars |
Numeric, 2 decimal places |
CWDirect average cost. |
SKU Number |
Numeric, 7 positions, variable length |
CWDirect short SKU. |
Short SKU |
1111 |
Billing Async Date |
06/15/98 |
Confirmed Quantity |
1 |
Selling Unit Price |
45.00 |
Average Cost |
30.00 |
Offer Unit Price |
45.00 |
SKUS Record |
|
Field |
Value |
Line Descriptor |
"Sl" |
Store |
"01" |
UPC |
"001111" |
Tax Mode |
"1" |
Last Receive Date |
"06-15-98" |
Last Receive Quantity |
"1" |
Mark Down Dollars |
"0" |
Retail Price: Dollars |
"45.00" |
Cost: Dollars |
"030.00" |
Compare Price: Dollars |
"45.00" |
Landed Cost: Dollars |
"030.00" |
SKU Number |
"001111" |
The SKUS record in the SKUS Interface file is:
"Sl", "01", "001111", "1", "06-15-98", "1", "0", "45.00", "030.00", "45.00", "030.00", "001111"
Load Cam Data Retail Interface Orders Screen (LPOS)
Purpose: Use this screen to populate the Phone Orders (PHORDS) File with the information uploaded from Cam Data's POS system.
How to display this screen: Enter LPOS in the Fast path field at the top of any menu or select Load Cam Data Retail Interface Orders from a menu.
PHR0069 ENTER Load Cam Data Retail Interface Orders 6/30/98 17:30:18 The KL Mail Order Company
Store . . . . .
Press <ENTER> to process Retail Interface orders.
F3=Exit F12=Cancel |
Field |
Description |
Store |
The retail store number the system uses to load the phone interface (PHORDS) file. You must enter the store number this field. Numeric, 2 positions; required. |
When you enter the retail store number in the Store field, the system:
• checks the folder name defined in the Retail PC POS Sales Upload Shared Folder (F56) system control value to determine the folder where the files should be copied from.
• submits a batch job (CAMDTA_LD).
• maps all of the fields defined in the Point of Sale Receipt (POSSccss.TXT) file to the CWDirect Phone Order file. See Sample Phone Order File Record for more information on how the system maps the Point of Sale Receipt (POSSccss.TXT) fields to the Phone Order fields defined in the Phone Order file.
Sample Phone Order File Record
The Phone Order file contains order information for orders that were processed outside of CWDirect.
Field |
Attributes |
Description |
Positions in Row |
Company |
Numeric, 3 positions |
The company number where the load retail orders process occurred. |
1-3 |
Sequence number |
Numeric, 7 positions |
The sequence to read records |
4-10 |
Record type |
Numeric, 1 position |
1 = Sold To 2 = Ship To 3 = Pay Type 4 = Details 5 = Order Messages 6 = Special Handling 7 = Catalog requests 8 = Individuals |
11 |
Batch number |
Numeric, 7 positions |
Number assigned to each group of transactions. |
12-18 |
Order date |
Numeric, 7 positions |
The POS date from the header record in YYMMDD format |
19-25 |
Salesman |
Numeric, 7 positions |
The salesperson defined in the header record. |
26-32 |
User |
Alphanumeric, 10 positions |
RETAIL displays in this field. |
33-42 |
Time entered |
Numeric, 6 positions |
The POS time defined in the header record. |
43-48 |
Freight charge |
Numeric, 7 positions with 2-place decimal |
0 displays in this field. |
49-55 |
Freight override |
Alphanumeric, 1 position |
Y displays in this field. |
56 |
Source code |
Alphanumeric, 7 positions |
The original source code attached to the customer. |
57-63 |
Arrival date |
Numeric, 6 positions |
|
64-69 |
Cancel BO? |
Alphanumeric, 1 position |
|
70 |
Cancel date |
Numeric, 6 positions |
|
71-76 |
Contact name |
Alphanumeric, 30 positions |
|
77-106 |
Gift order? |
Alphanumeric, 1 position |
|
107 |
Resale/Exempt number |
Numeric, 15 positions |
|
108-122 |
Ship complete |
Alphanumeric, 1 position |
|
123 |
Ship via |
Numeric, 2 positions |
05 displays in this field. |
124-125 |
Purchase order number |
Numeric, 15 positions |
|
126-140 |
Item number |
Alphanumeric, 12 positions |
The first 7 positions of the short SKU. |
141-152 |
Offer number |
Numeric, 3 positions |
The offer code associated with the source code. |
153-155 |
SKU |
Alphanumeric, 14 positions |
CWDirect short SKU. |
156-169 |
Additional charge code |
Alphanumeric, 2 positions |
|
170-171 |
Line level arrival date |
Numeric, 6 positions |
|
172-177 |
Price |
Numeric, 7 positions with a 2-place decimal |
The price defined in the Ll record. The price is a negative value if the transaction was a return. |
178-184 |
Quantity ordered |
Numeric, 5 positions |
|
185-189 |
Special handling $$ |
Numeric, 7 positions with a 2-place decimal |
|
190-196 |
Gift wrap? |
Alphanumeric, 1 position |
|
197 |
Coupon? |
Alphanumeric, 1 position |
|
198 |
Coupon $ override |
Numeric, 7 positions with a 2-place decimal |
|
199-205 |
Page number |
Numeric, 5 positions |
|
206-210 |
Page letter |
Numeric, 6 positions |
|
211-216 |
Alias |
Alphanumeric, 12 positions |
|
217-228 |
Line level source |
Alphanumeric, 7 positions |
|
229-235 |
Line level ship via |
Numeric, 2 positions |
|
236-237 |
Country |
Numeric, 3 positions |
From user-supplied table |
238-240 |
Prefix |
Alphanumeric, 3 positions |
The prefix defined for the retail customer. |
241-243 |
First name |
Alphanumeric, 15 positions |
The first name defined for the retail customer. |
244-258 |
Middle initial |
Alphanumeric, 1 position |
The middle initial defined for the retail customer. |
259.000 |
Last name |
Alphanumeric, 25 positions |
The last name defined for the retail customer. |
260-284 |
Street address |
Alphanumeric, 32 positions |
The street address defined for the retail customer. |
285-316 |
Apartment |
Alphanumeric, 10 positions |
The apartment defined for the retail customer. |
317-326 |
Address line 2 |
Alphanumeric, 32 positions |
The address line 2 defined for the retail customer. |
327-358 |
City |
Alphanumeric, 25 positions |
The city defined for the retail customer. |
359-383 |
State |
Alphanumeric, 2 positions |
The state defined for the retail customer. |
384-385 |
Zip/postal code |
Alphanumeric, 10 positions |
The postal code defined for the retail customer. |
386-395 |
Suffix |
Alphanumeric, 3 positions |
The suffix defined for the retail customer. |
396-398 |
Delivery code |
Alphanumeric, 1 position |
B = business; R = residence; N = no distinction |
399 |
PO Box? |
Alphanumeric, 1 position |
Y or N |
400 |
Company name |
Alphanumeric, 30 positions |
The company name defined for the retail customer. |
401-430 |
Address line 3 |
Alphanumeric, 32 positions |
The address line 3 defined for the retail customer. |
431-462 |
Address line 4 |
Alphanumeric, 32 positions |
The address line 4 defined for the retail customer. |
463-494 |
Print? |
Alphanumeric, 1 position |
|
495 |
Message |
Alphanumeric, 60 positions |
The first 60 characters of the information line in the Ll record. |
496-555 |
Date entered |
Numeric, 6 positions |
The date defined in the POS Hl record. |
556-561 |
Time entered |
Numeric, 6 positions |
The time defined in the POS Hl record. |
562-567 |
Amount to charge |
Numeric, 9 positions with a 2-place decimal |
|
568-576 |
Amount authorized |
Numeric, 9 positions with a 2-place decimal |
|
577-585 |
Amount billed |
Numeric, 9 positions with a 2-place decimal |
|
586-594 |
Amount collected |
Numeric, 9 positions with a 2-place decimal |
|
595-603 |
Amount credited |
Numeric, 9 positions with a 2-place decimal |
|
604-612 |
Authorization date |
Numeric, 6 positions |
The POS date defined in the Hl record. |
613-618 |
Authorization number |
Numeric, 7 positions |
STORE displays in this field. |
619-625 |
Balance open |
Numeric, 9 positions with a 2-place decimal |
0 displays in this field. |
626-634 |
Cash applied date |
Numeric, 6 positions |
The payment date defined in the Pl record. |
635-640 |
Cash control number |
Numeric, 5 positions |
|
641-645 |
Charge sequence |
Numeric, 2 positions |
1 displays in this field. |
646-647 |
Credit card number |
Numeric, 16 positions |
44443333222221111 displays in this field. |
648-663 |
Expiration date |
Numeric, 4 positions |
1224 displays in this field. |
664-667 |
Gift certificate/coupon number |
Numeric, 7 positions |
This field always displays blank. |
668-674 |
Pay type |
Numeric, 2 positions |
98 displays in this field. |
675-676 |
Pay category |
Numeric, 1 position |
The pay category defined for the pay type record. |
677 |
Special handling information |
Alphanumeric, 30 positions |
|
678-707 |
Area code |
Numeric, 3 positions |
|
708-710 |
Phone number |
Numeric, 7 positions |
|
711-717 |
Customer number |
Numeric, 9 positions |
The first 9 positions of the customer number. |
718-726 |
Warehouse code |
Numeric, 3 positions |
38 always displays in this field. |
727-729 |
Location code |
Alphanumeric, 7 positions |
The auto restock location for the warehouse defined for the retail store customer. |
730-736 |
Return reason code |
Nmeric, 3 positions |
999 displays in this field. |
737-739 |
Retail transaction number |
Numeric, 9 positions |
The receipt ID from the Hl record. |
740-748 |
No charge flag |
Alphanumeric, 1 position |
|
749 |
Affect inventory |
Alphanumeric, 1 position |
Y displays in this field. |
750 |
Placer number |
Numeric, 3 positions |
|
751-753 |
Originator number |
Numeric, 3 positions |
|
754-756 |
Ship to |
Numeric, 3 positions |
|
757-759 |
Gift certificate number |
Numeric, 7 positions |
|
760-766 |
Permanent ship to flag |
Alphanumeric, 1 position |
N displays in this field. |
767 |
Originator/Placer |
Alphanumeric, 1 position |
O = originator P = placer |
768 |
Department |
Alphanumeric, 3 positions |
|
769-771 |
Position |
Alphanumeric, 3 positions |
|
772-774 |
E-mail address |
Alphanumeric, 50 positions |
|
775-824 |
Phone # 14 dy |
Numeric, 14 positions |
|
825-838 |
Phone ext day |
Numeric, 4 positions |
|
839-842 |
Phone # 14 eve |
Numeric, 14 positions |
|
843-856 |
Phone ext eve |
Numeric, 4 positions |
|
857-860 |
Phone # 14 fax |
Numeric, 14 positions |
|
861-874 |
Phone ext fax |
Numeric, 4 positions |
|
875-878 |
Associate |
Alphanumeric, 1 position |
|
879 |
Pay plan |
Alphanumeric, 1 position |
|
880 |
Work Order Ticket | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 16: Working with Price Tickets (WPTW) |
WH02_05 CWDirect 18.0 August 2015 OTN