Chapter 31: Using the Phone Interface | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 33: Transferring Remote Orders (TPHO) |
Chapter 32: Inputting Remote Orders (IPHO)
Purpose: Use Inputting Remote Orders to load a file of remote orders from tape or through data communications. This menu option populates the Phone Transmit file (PHXMIT).
In this chapter:
• Phone Transmit (PHXMIT) File Layout
Data source: The Phone Load Method (C97) system control value determines where
the system looks for the data used to build the Phone Transmit file. If this field is set to:
• EMERY: the system uses the data in the Emery Interface file (PHBMIT)
• TAPE: the system uses the tape drive specified in the Tape Drive system control value
• COMM: the system loads the data interactively
You can work with each of the Phone Load Method (C97) field by selecting the Phone Interface Values (F70) "umbrella" system control value.
After you input remote orders: Once you have populated the Phone Transmit file, you use the Transfer Phone Orders menu option to convert its contents to the Phone Order file (PHORDS). See Chapter 33: Transferring Remote Orders (TPHO).
How to display this screen: Enter IPHO in the Fast path field at the top of any menu screen or select the Input Phone Orders from Tape/Comm/Emery from the menu.
PHR0020 ENTER Input Phone Orders 6/25/98 16:16:52
Warning! Unloaded phone orders in ALL companies will be cleared!
Press ENTER to submit load of phone orders.
F3=Exit F12=Cancel |
This process clears any existing remote order file on disk, then writes file PHXMIT to disk. If loading the remote orders from tape, be sure to mount a tape on the appropriate tape drive before selecting this option; otherwise, a message similar to the following appears:
Device TAP01 was not ready or next volume was not loaded.
Mount the tape on the designated tape drive, then enter R (Retry) in response to this message.
The system creates the following records for each phone order in the file: Sold To, Ship To, Pay Type, Details (items ordered), Messages, Special Handling, and Catalog Request.
It is important that you follow this step immediately with the Transfer Phone Orders option (TPHO), discussed in Chapter 33: Transferring Remote Orders (TPHO). This process copies the records in the remote phone orders to another file so that the current file is not overwritten when you load a new file of remote orders.
Phone Transmit (PHXMIT) File Layout
Purpose: Below is the file layout for the Phone Transmit file (PHXMIT). If you receive remote orders in this format, you must use the Transfer Phone Orders menu option to convert the data to the Phone Orders file format (PHORDS), discussed in Transferring Remote Orders (TPHO).
The Phone Transmit file contains up to seven different record types; the fields in each type of record, including their attributes and start and end positions, are described in the table below.
Note: Each numeric field in this file is in packed, or compressed, format.
Field |
Required (Y/N) |
Attributes |
Positions |
Start |
End |
Sold to record (record type 1) |
|||||
Company |
Y |
Numeric |
3 |
1 |
2 |
Sequence # |
Y |
Numeric |
7 |
3 |
6 |
Record Type |
Y |
Alphanumeric |
1 |
7 |
7 |
Batch # |
Y |
Numeric |
7 |
8 |
11 |
User |
|
Alphanumeric |
10 |
12 |
21 |
Order Date |
Y |
Numeric |
7 |
22 |
25 |
Salesman |
|
Numeric |
3 |
26 |
27 |
Time Entered |
|
Numeric |
7 |
28 |
31 |
Freight Charge |
|
Numeric |
7, 2-place decimal |
32 |
35 |
Freight Override |
|
Alphanumeric |
1 |
36 |
36 |
Source Code Prior 3.5 |
|
Alphanumeric |
7 |
37 |
43 |
Country |
Y |
Alphanumeric |
3 |
44 |
46 |
Prefix |
|
Alphanumeric |
3 |
47 |
49 |
First Name |
Y |
Alphanumeric |
15 |
50 |
64 |
Initial |
|
Alphanumeric |
1 |
65 |
65 |
Last Name |
Y |
Alphanumeric |
25 |
66 |
90 |
Street Address |
Y |
Alphanumeric |
32 |
91 |
122 |
Apartment |
|
Alphanumeric |
10 |
123 |
132 |
Address Line 2 |
|
Alphanumeric |
32 |
133 |
164 |
City |
Y |
Alphanumeric |
25 |
165 |
189 |
State |
Y |
Alphanumeric |
2 |
190 |
191 |
Zip/Postal Code |
Y |
Alphanumeric |
10 |
192 |
201 |
Suffix |
|
Alphanumeric |
3 |
202 |
204 |
Delivery Code |
Y |
Alphanumeric |
1 |
205 |
205 |
PO Box? |
Y |
Alphanumeric |
1 |
206 |
206 |
Company Name |
|
Alphanumeric |
30 |
207 |
236 |
Address Line 3 |
|
Alphanumeric |
32 |
237 |
268 |
Phone Number - Area Code |
|
Numeric |
3 |
269 |
270 |
Phone Number - number |
|
Numeric |
7 |
271 |
274 |
Source Code |
|
Alphanumeric |
9 |
275 |
283 |
Filler |
|
Alphanumeric |
37 |
284 |
320 |
Ship To (record type 2) |
|||||
Company |
Y |
Numeric |
3 |
1 |
2 |
Seq# |
Y |
Numeric |
7 |
3 |
6 |
Record Type |
Y |
Alphanumeric |
1 |
7 |
7 |
Batch # |
Y |
Numeric |
7 |
8 |
11 |
Arrival Date |
Y |
Numeric |
7 |
12 |
15 |
Cancel BO? |
|
Alphanumeric |
1 |
16 |
16 |
Cancel Date |
|
Numeric |
7 |
17 |
20 |
Contact Name |
|
Alphanumeric |
30 |
21 |
50 |
Gift Order? |
Y |
Alphanumeric |
1 |
51 |
51 |
Resale/Exempt # |
|
Alphanumeric |
15 |
52 |
66 |
Ship Complete |
|
Alphanumeric |
1 |
67 |
67 |
Ship Via |
Y |
Numeric |
2 |
68 |
69 |
Purchase Order # |
|
Alphanumeric |
15 |
70 |
84 |
Country |
Y |
Alphanumeric |
3 |
85 |
87 |
Prefix |
|
Alphanumeric |
3 |
88 |
90 |
First Name |
Y |
Alphanumeric |
15 |
91 |
105 |
Initial |
|
Alphanumeric |
1 |
106 |
106 |
Last Name |
Y |
Alphanumeric |
25 |
107 |
131 |
Street Address |
Y |
Alphanumeric |
32 |
132 |
163 |
Apartment |
|
Alphanumeric |
10 |
164 |
173 |
Address Line 2 |
|
Alphanumeric |
32 |
174 |
205 |
City |
Y |
Alphanumeric |
25 |
206 |
230 |
State |
Y |
Alphanumeric |
2 |
231 |
232 |
Zip/Postal Code |
Y |
Alphanumeric |
10 |
233 |
242 |
Suffix |
|
Alphanumeric |
3 |
243 |
245 |
Delivery Code |
Y |
Alphanumeric |
1 |
246 |
246 |
PO Box? |
|
Alphanumeric |
1 |
247 |
247 |
Company Name |
|
Alphanumeric |
30 |
248 |
277 |
Address Line 3 |
|
Alphanumeric |
32 |
278 |
309 |
Filler |
|
Alphanumeric |
11 |
310 |
320 |
Pay Type Record (record type 3) |
|||||
Company |
Y |
Numeric |
3 |
1 |
2 |
Seq# |
Y |
Numeric |
7 |
3 |
6 |
Record Type |
Y |
Alphanumeric |
1 |
7 |
7 |
Batch # |
Y |
Numeric |
7 |
8 |
11 |
Amount to Charge |
Y for Prepaid |
Numeric |
9, 2-place decimal |
12 |
16 |
Amount Authorized |
|
Numeric |
9, 2-place decimal |
17 |
21 |
Authorization Date |
|
Numeric |
7 |
22 |
25 |
Authorization Number |
|
Alphanumeric |
7 |
26 |
32 |
Charge Sequence |
Y |
Alphanumeric |
2 |
33 |
34 |
Credit Card # |
Y for C/C only |
Alphanumeric |
16 |
35 |
50 |
Expiration Date |
Y for C/C only |
Alphanumeric |
4 |
51 |
53 |
Gift Cert/Coupon # |
|
Alphanumeric |
7 |
54 |
57 |
Pay Type |
Y |
Alphanumeric |
2 |
58 |
59 |
Pay Plan |
|
Alphanumeric |
1 |
60 |
60 |
Filler |
|
Alphanumeric |
261 |
61 |
320 |
Item Detail Record (record type 4) |
|||||
Company |
Y |
Numeric |
3 |
1 |
2 |
Seq# |
Y |
Numeric |
7 |
3 |
6 |
Record Type |
Y |
Alphanumeric |
1 |
7 |
7 |
Batch # |
Y |
Numeric |
7 |
8 |
11 |
Item Number |
Y |
Alphanumeric |
12 |
12 |
23 |
Offer Number |
Y |
Alphanumeric |
3 |
24 |
26 |
SKU Number |
Y |
Alphanumeric |
14 |
27 |
40 |
Additional Charge Code |
|
Alphanumeric |
1 |
41 |
41 |
Line Level Arrival Date |
|
Numeric |
7 |
42 |
45 |
Price |
Y |
Numeric |
7, 2-place decimal |
46 |
49 |
Qty Ordered |
Y |
Numeric |
5 |
50 |
52 |
Special Handling $$ |
|
Numeric |
7, 2-place decimal |
53 |
56 |
Gift Wrap? |
|
Alphanumeric |
1 |
57 |
57 |
Coupon? |
|
Alphanumeric |
1 |
58 |
58 |
Coupon $ Override |
|
Numeric |
7, 2-place decimal |
59 |
62 |
Page # |
|
Numeric |
5 |
63 |
65 |
Page Letter |
|
Alphanumeric |
6 |
66 |
71 |
Alias |
|
Alphanumeric |
12 |
72 |
83 |
Line Level Source Prior 3.5 |
|
Alphanumeric |
7 |
84 |
90 |
Line Level Ship Via |
|
Numeric |
2 |
91 |
92 |
Line Level Source |
|
Alphanumeric |
9 |
93 |
101 |
Filler |
|
Alphanumeric |
219 |
102 |
320 |
Order Message Record (record type 5) |
|||||
Company |
Y |
Numeric |
3 |
1 |
2 |
Seq# |
Y |
Numeric |
7 |
3 |
6 |
Record Type |
Y |
Alphanumeric |
1 |
7 |
7 |
Batch # |
|
Numeric |
7 |
8 |
11 |
Y |
Alphanumeric |
1 |
12 |
12 |
|
Message |
Y |
Alphanumeric |
60 |
13 |
72 |
Date Entered |
|
Numeric |
7 |
73 |
76 |
Time Entered |
|
Numeric |
7 |
77 |
80 |
Filler |
|
Alphanumeric |
240 |
81 |
320 |
Special Handling Record (record type 6) |
|||||
Company |
Y |
Numeric |
3 |
1 |
2 |
Seq# |
Y |
Numeric |
7 |
3 |
6 |
Record Type |
Y |
Alphanumeric |
1 |
7 |
7 |
Batch # |
Y |
Numeric |
7 |
8 |
11 |
Special Handling Info |
Y |
Alphanumeric |
30 |
12 |
41 |
Filler |
|
Alphanumeric |
279 |
42 |
320 |
Catalog Request Record (record type 7) |
|||||
Company |
Y |
Numeric |
3 |
1 |
2 |
Seq# |
Y |
Numeric |
7 |
3 |
6 |
Record Type |
Y |
Alphanumeric |
1 |
7 |
7 |
Batch # |
Y |
Numeric |
7 |
8 |
11 |
Country |
Y |
Alphanumeric |
3 |
12 |
14 |
Prefix |
|
Alphanumeric |
3 |
15 |
17 |
First Name |
Y |
Alphanumeric |
15 |
18 |
32 |
Initial |
|
Alphanumeric |
1 |
33 |
33 |
Last Name |
Y |
Alphanumeric |
25 |
34 |
58 |
Street Address |
Y |
Alphanumeric |
32 |
59 |
90 |
Apartment |
|
Alphanumeric |
10 |
91 |
100 |
Address Line 2 |
|
Alphanumeric |
32 |
101 |
132 |
City |
Y |
Alphanumeric |
25 |
133 |
157 |
State |
Y |
Alphanumeric |
2 |
158 |
159 |
Zip/Postal Code |
Y |
Alphanumeric |
10 |
160 |
169 |
Suffix |
|
Alphanumeric |
3 |
170 |
172 |
Delivery Code |
Y |
Alphanumeric |
1 |
173 |
173 |
PO Box? |
Y |
Alphanumeric |
1 |
174 |
174 |
Company Name |
|
Alphanumeric |
30 |
175 |
204 |
Address Line 3 |
|
Alphanumeric |
32 |
205 |
236 |
Filler |
|
Alphanumeric |
84 |
237 |
320 |
Chapter 31: Using the Phone Interface | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 33: Transferring Remote Orders (TPHO) |
OE03_02 CWDirect 18.0 August 2015 OTN