Inputting Remote Orders (IPHO) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Loading Remote Orders (LPHO) |
Transferring Remote Orders (TPHO)
Purpose: Use the Transfer Remote Orders menu option to transfer remote order records into the Phone Orders file (PHORDS) from:
• the Phone Transmit file (PHXMIT), or
• the Phone Order Expanded (PHORDE) file format (If the Phone Load Method (C97) system control value is set to HERRSCHNER)
During this step, an edit check is performed against the batch number to ensure that you are receiving the correct file and you are not trying to receive a file multiple times.
Clear file after transfer? The Clear Phone Interface Files (J14) system control value controls whether the system clears each Phone Order Expanded file record for your company when you transfer records from the Phone Order Expanded file (PHORDE) to the Phone Order file (PHORDS).
Note: The system does not automatically clear the Phone Transmit file (PHXMIT), regardless of the setting of this system control value.
For more information:
• phone interface overview: Using the Phone Interface
• inputting remote orders using the Phone Transmit file: Inputting Remote Orders (IPHO)
• phone edit process and reports: Loading Remote Orders (LPHO)
• email address and opt-in/out updates: Email Address Updates through the Phone Order Load
In this topic:
• Transfer Phone Orders Screen
• Custom Special Handling Record
How to display this screen: Enter TPHO in the Fast path field at the top of any menu or select Transfer Phone Orders from a menu.
PHR0033 ENTER Transfer Phone Orders 6/26/98 16:09:14 The Mail Order Company
Press <ENTER> to process phone orders.
F3=Exit F12=Exit |
Purpose: Below is the file format for the Phone Orders file (PHORDS). You can load remote orders directly on the system in this format, or you can transfer records out of the PHXMIT or PHORDE files to this file.
Note: You can view the file format for the Phone Orders Expanded file (PHORDE) in the Field/File Listing.
Credit card encryption: If you Use Credit Card Encryption (I97), the credit card number in the Phone Orders file will not be encrypted because it comes from an external system. Once a CWDirect order is created from information in the Phone Orders file, the system encrypts the credit card number in the CWDirect database to provide additional security of credit card data. See Using Credit Card Encryption and Data Security for an overview.
The particular fields that are used in each record type are listed later in this chapter for reference.
Note: All numeric fields in this file are in packed, or compressed, format.
Field |
Attributes |
Positions |
Used in record type |
Notes |
Company |
3.0, numeric, packed |
1-2 |
all |
Validated against Company file (fast path = WCMP); see Installation Setting Up Companies (WCMP). |
Sequence number |
7.0, numeric, packed |
3-6 |
all |
The sequence in which the records are read. |
Record type |
1, alphanumeric |
7 |
all |
1 = Sold To 2 = Ship To 3 = Pay Type 4 = Details 5 = Order Messages 6 = Special Handling 7 = Catalog Requests 8 = Individuals 9 = Custom Special Handling |
Batch number |
7.0, numeric, packed |
8-11 |
all |
A unique number assigned to each group of transactions. |
Order date |
6.0, numeric, packed |
12-15 |
1, 9 |
CYYMMDD format. |
Salesman |
3.0, numeric, packed |
16-17 |
1 |
Validated against Salesman file (fast path = WSLS); see Accounts Payable Working with Sales Representatives (WSLS). |
User |
10, alphanumeric |
18-27 |
1, 5 |
|
Time entered |
7.0, numeric, packed |
28-31 |
1, 5 |
HHMMSS format |
Freight charge |
7.2, numeric, packed |
32-35 |
1 |
If blank, calculate freight. |
Freight override |
1, alphanumeric |
36 |
1 |
Y or N; set to Y if freight charge entered. |
Source before 3.5 |
7, alphanumeric |
37-43 |
1 |
|
Arrival date |
6.0, numeric, packed |
44-47 |
2 |
CYYMMDD format. |
Cancel BO? |
1, alphanumeric |
48 |
2 |
|
Cancel date |
6.0, numeric, packed |
49-52 |
2 |
CYYMMDD format. |
Contact name |
30, alphanumeric |
53-82 |
2 |
|
Gift order? |
1, alphanumeric |
83 |
2 |
|
Resale/Exempt number |
15, numeric |
84-98 |
2 |
|
Ship complete |
1, alphanumeric |
99 |
2 |
|
Ship via |
2.0, numeric, packed |
100-101 |
2 |
|
Purchase order number |
15, numeric |
102-116 |
2 |
|
Item number |
12, alphanumeric |
117-128 |
4 |
Validated against Item file (fast path = MITM); see Merchandising Performing Initial Item Entry (MITM). |
Offer number |
3, numeric |
129-131 |
4 |
Validated against Offer file (fast path = WOFR); see Marketing Working with Offers (WOFR). |
SKU |
14, alphanumeric |
132-145 |
4 |
|
Additional charge code |
1, alphanumeric |
146 |
|
This field not used. |
Line level arrival date |
6.0, numeric, packed |
147-150 |
4 |
CYYMMDD format. |
Price |
7.2, numeric, packed |
151-154 |
4 |
|
Quantity ordered |
5.0, numeric, packed |
155-157 |
4 |
|
Special handling $ |
7.2, numeric, packed |
158-161 |
4 |
|
Gift wrap? |
1, alphanumeric |
162 |
4 |
|
Coupon? |
1, alphanumeric |
163 |
4 |
|
Coupon $ override |
7.2, numeric, packed |
164-167 |
4 |
|
Page number |
3, numeric, packed |
168-170 |
4 |
|
Page letter |
5, numeric |
171-176 |
4 |
|
Alias |
12, alphanumeric |
177-188 |
4 |
|
Line level source before 3.5 |
7, alphanumeric |
189-195 |
4 |
|
Line level ship via |
2.0, numeric, packed |
196-197 |
4 |
Validated against Ship Via file (fast path = WVIA); see Fulfillment Working with Ship Via Codes (WVIA). |
Country |
3, alphanumeric |
198-200 |
1, 2, 7 |
Validated against Country file (fast path = WCTY); see Customer Service Setting Up the Country File (WCTY). |
Prefix |
3, alphanumeric |
201-203 |
1, 2, 7, 8 |
|
First name |
15, alphanumeric |
204-218 |
1, 2, 7, 8 |
|
Middle initial |
1, alphanumeric |
219 |
1, 2, 7, 8 |
|
Last name |
25, alphanumeric |
220-244 |
1, 2, 7, 8 |
|
Street address |
32, alphanumeric |
245-276 |
1, 2, 7 |
|
Apartment |
10, alphanumeric |
277-286 |
1, 2, 7 |
|
Address line 2 |
32, alphanumeric |
287-318 |
1, 2, 7 |
|
City |
25, alphanumeric |
319-343 |
1, 2, 7 |
Validated against City State Zip file. |
State |
2, alphanumeric |
344-345 |
1, 2, 7 |
Validated against State file. |
Zip/postal code |
10, alphanumeric |
346-355 |
1, 2, 7 |
Validated against City State Zip file. |
Suffix |
3, alphanumeric |
356-358 |
1, 2, 7, 8 |
|
Delivery code |
1, alphanumeric |
359 |
1, 2, 7 |
B = business; R = residence; N = no distinction |
PO Box? |
1, alphanumeric |
360 |
1, 2, 7 |
Y or N. |
Company name |
30, alphanumeric |
361-390 |
1, 2, 7 |
|
Address line 3 |
32, alphanumeric |
391-422 |
1, 2, 7 |
|
Address line 4 |
32, alphanumeric |
423-454 |
1, 2 |
|
Print? |
1, alphanumeric |
455 |
5 |
N = print nowhere; P = print on pick slips; I = print on invoices; B = print on both pick slips and invoices; G = print on gift messages. Used on the Order Message record type. |
Message |
60, alphanumeric |
456-515 |
5 |
|
Order message date |
6.0, numeric, packed |
516-519 |
|
CYYMMDD format. |
Order message time |
6.0, numeric, packed |
520-523 |
|
HHMMSS format |
Amount to charge |
9.2, numeric, packed |
524-528 |
3 |
|
Amount authorized |
9.2, numeric, packed |
529-533 |
3 |
|
Amount billed |
9.2, numeric, packed |
534-538 |
3 |
|
Amount collected |
9.2, numeric, packed |
539-543 |
3 |
|
Amount credited |
9.2, numeric, packed |
544-548 |
3 |
|
Authorization date |
6.0, numeric, packed |
549-552 |
3 |
CYYMMDD format. |
Authorization number |
7, numeric |
553-559 |
3 |
|
Balance open |
9.2, numeric, packed |
560-564 |
|
|
Cash applied date |
6.0, numeric, packed |
565-568 |
3 |
CYYMMDD format. |
Cash control number |
5.0, numeric, packed |
569-571 |
3 |
|
Charge sequence |
2.0, numeric, packed |
572-573 |
3 |
|
Credit card number - prior to version 7.5 |
16, numeric |
574-589 |
3 |
|
Expiration date |
4.0, numeric, packed |
590-592 |
3 |
YYMM format |
Gift certificate/ coupon number |
5.0, numeric, packed |
593-596 |
3 |
Used when a gift certificate is a payment method on an order |
Pay type |
2.0, numeric, packed |
597-598 |
3 |
from the Pay Type file (fast path = WPAY); see Accounts Payable Working with Pay Types (WPAY) |
Pay category |
1, numeric |
599 |
3 |
|
Special handling info |
30, alphanumeric |
600-629 |
6 |
|
Area code |
3.0, numeric, packed |
630-631 |
8 |
|
Phone number |
7.0, numeric, packed |
632-635 |
8 |
|
Customer number |
9.0, numeric, packed |
636-640 |
1, 2 |
If this is a valid customer number, system ignores other address fields and does not attempt to match with an existing customer or create a new customer. If the number is invalid, the order must be re-entered. |
Warehouse code |
3.0, numeric, packed |
641-642 |
4 |
from Warehouse file (fast path = WWHS); see Warehousing Creating and Maintaining Warehouses (WWHS) |
Location code |
7, alphanumeric |
643-649 |
4 |
from Location file (fast path = WLOC); see Warehousing Creating and Maintaining Locations (WLOC) |
Return reason code |
3.0, numeric, packed |
650-651 |
4 |
from Return Reason Code file (fast path = WRTR); see Customer Service Establishing Return Reason Codes (WRTR) |
Retail transaction number |
9.0, numeric, packed |
652-656 |
1 |
Typically, the order number assigned on the remote system. If the Allow Order Number Override in Phone Interface (G54) system control value is set to Y, the system uses this number as the order number when it creates the order (as long as the order number is not already assigned). In any other case, the system uses the next available number from the Number Assignment file, as it does in order entry. |
|
|
|
|
The system always creates a record in the Order Cross Reference file, using the retail transaction number and the order number; this allows you to cross-reference order numbers assigned on another system with the CWDirect order numbers. |
No charge flag |
1, alphanumeric |
657 |
4 |
|
Affect inventory |
1, alphanumeric |
658 |
4 |
|
Placer number |
3.0, numeric, packed |
659-660 |
1 |
Individual customer number; see Customer Service Creating and Updating Individuals |
Originator number |
3.0, numeric, packed |
661-662 |
1 |
Individual customer number |
Ship to |
3.0, numeric, packed |
663-664 |
2 |
|
Gift certificate number |
7.0, numeric, packed |
665-668 |
4 |
Used when you sell a gift certificate on an order |
Permanent ship to flag |
1, alphanumeric |
669 |
2 |
Set to C to create a permanent ship-to |
Originator/ Placer |
1, alphanumeric |
670 |
8 |
O = originator P = placer |
Department |
3, alphanumeric |
671-673 |
8 |
Validated against Individual Department file (fast path = WDPM); see Customer Service Working with Individual Departments (WDPM). |
Position |
3, alphanumeric |
674-676 |
8 |
Validated against Individual Position file (fast path = WPOS); see Customer Service Working with Individual Positions (WPOS). |
Salesman #2 |
7.0, numeric, packed |
677-680 |
|
|
Internet address |
50, alphanumeric |
681-730 |
1 |
|
Phone # day |
14, numeric |
731-744 |
1, 2 |
|
Phone ext day |
4, numeric |
745-748 |
1, 2 |
|
Phone # eve |
14, numeric |
749-762 |
1, 2 |
|
Phone ext eve |
4, numeric |
763-766 |
1, 2 |
|
Phone # fax |
14, numeric |
767-780 |
1, 2 |
|
Phone ext fax |
4, numeric |
781-784 |
1, 2 |
|
Associate customer? |
1, alphanumeric |
785 |
|
|
Pay plan |
1, alphanumeric |
786 |
3 |
|
Source |
9, alphanumeric |
787-795 |
1, 7 |
Validated against Source Code file (fast path = WSRC); see Marketing Working with Source Codes (WSRC). Used in record type 7 to create a catalog request; if this field is blank, uses the Default Source Code for Batch Catalog Requests (D37) defined in the System Control file. You can also use the Source Code Auto Retrieval Value (H82) to retrieve the correct source code based on the most recent mailing to the customer, or to default a source code if the actual code is unknown. |
Line Level Source |
9, alphanumeric |
796-804 |
4 |
Validated against Source Code file (fast path = WSRC). |
Input |
45, alphanumeric |
805-849 |
9 |
text of a custom special handling message. If the Enter Custom Special Handling in Upper and Lower Case (D65) system control value is set to N or is blank, the system will reformat upper and lower case text to all uppercase. |
Charge |
7.2, numeric, packed |
850-853 |
9 |
custom special handling charge |
SH Sequence # |
3.0, numeric, packed |
854-855 |
9 |
maps each line of a custom special handling message to the sequence number of the special format detail code (Note: This sequence number is the actual Sequence number from the Special Format Details file, not the Display Sequence number that appears on the Create, Change, or Display Special Format Detail screens in WSHF); see Customer Service Establishing Custom Special Handling Formats (WSHF) |
Additional charge code |
2, alphanumeric |
856-857 |
|
|
PHE Order Type |
1, numeric |
858 |
|
The order type passes to the Type (Order type) field in the Order Header file. |
PHE Tax Amount |
10.5, numeric, packed |
859-864 |
|
If a tax amount exists, the system does not calculate tax in order entry/maintenance, pick slip generation, or billing. The tax amount passes to the Tax field in the Order Detail file. |
PHE GST |
10.5, numeric, packed |
865-870 |
|
If a GST amount exists, the system does not calculate tax in order entry/maintenance, pick slip generation, or billing. The GST amount passes to the GST field in the Order Detail file. |
PHE PST |
10.5, numeric, packed |
871-876 |
|
If a PST amount exists, the system does not calculate tax in order entry/maintenance, pick slip generation, or billing. The PST amount passes to the PST field in the Order Detail file. |
PHE OST Freight |
7.2, numeric, packed |
877-880 |
2 |
|
PHE OST Freight override? |
1, alphanumeric |
881 |
2 |
|
Card security value |
4.0, numeric, packed |
882-884 |
3 |
Enter a card security value only if you wish to perform card security identification for the credit card pay type; see Credit Card Security Service (CID, CVV2, CVC2). Note: The system removes the card security value from an order when the order is accepted, even if an approved online authorization has not been received on the order. Card security processing is not available during batch authorization or deposit processing. |
Card security presence |
1, alphanumeric |
885 |
3 |
1 = card security value is present on the credit card. 2 = card security value is present on the credit card, but is illegible. 9 = card security value is not present on the credit card. |
Email address |
50, alphanumeric |
886-935 |
1 |
|
Opt in/opt out |
2, alphanumeric |
936-937 |
1, 8 |
O1 (Email): Email is the preferred method of correspondence. O2 (Order-only email): Use email for order-related correspondence only; generate a spool file for other correspondence. O3 (No email): Do not use email for any correspondence; generate a spool file instead. O4 (Do not ask the customer): Do not ask the customer for his/her email address; the customer has already been asked and has declined to provide it. The system does not generate any email correspondence to the customer, even if an email address is specified. |
Credit card number - version 7.5 and after |
20, alphanumeric |
938-957 |
|
|
Single-use promotion code |
10, alphanumeric |
958-967 |
2 |
The single-use promotion code to use to apply a promotion to the order. See Creating and Using Single-Use Promotion Codes for background. |
Filler |
78, alphanumeric |
967-1035 |
|
|
The fields used for the sold-to record in the Phone Order file (record type 1) are listed in the table below.
Phone Orders File (PHORDS) File Layout |
||
Sold to record (record type 1) |
||
Field |
Attributes |
Positions |
Company |
3.0, numeric, packed |
1-2 |
Sequence # |
7.0, numeric, packed |
3-6 |
Record Type |
1, alphanumeric |
7 |
Batch # |
7.0, numeric, packed |
8-11 |
Order Date |
6.0, numeric, packed |
12-15 |
Salesman |
3.0, numeric, packed |
16-17 |
User |
10, alphanumeric |
18-27 |
Time Entered |
6.0, numeric, packed |
28-31 |
Freight Charge |
7.2, numeric, packed |
32-35 |
Freight Override |
1, alphanumeric |
36 |
Source Code Prior 3.5 |
7, alphanumeric |
37-43 |
Country |
3, alphanumeric |
198-200 |
Prefix |
3, alphanumeric |
201-203 |
First Name |
15, alphanumeric |
204-218 |
Initial |
1, alphanumeric |
219 |
Last Name |
25, alphanumeric |
220-244 |
Street Address |
32, alphanumeric |
245-276 |
Apartment |
10, alphanumeric |
277-286 |
Address Line 2 |
32, alphanumeric |
287-318 |
City |
25, alphanumeric |
319-343 |
State |
2, alphanumeric |
344-345 |
Zip/Postal Code |
10, alphanumeric |
346-355 |
Suffix |
3, alphanumeric |
356-358 |
Delivery Code |
1, alphanumeric |
359 |
PO Box? |
1, alphanumeric |
360 |
Company Name |
30, alphanumeric |
361-390 |
Address line 3 |
32, alphanumeric |
391-422 |
Address line 4 |
32, alphanumeric |
423-454 |
Customer Number |
9.0, numeric, packed |
636-640 |
Retail Transaction Number |
9.0, numeric, packed |
652-656 |
Placer |
3.0, numeric, packed |
659-660 |
Originator |
3.0, numeric, packed |
661-662 |
Salesman #2 |
7.0, numeric, packed |
677-680 |
Internet address (email) |
50, alphanumeric |
681-730 |
Phone # day |
14, alphanumeric |
731-744 |
Phone ext day |
4, alphanumeric |
745-748 |
Phone # evening |
14, alphanumeric |
749-762 |
Phone ext evening |
4, alphanumeric |
763-766 |
Phone # fax |
14, alphanumeric |
767-780 |
Phone ext fax |
4, alphanumeric |
781-784 |
Source Code |
9, alphanumeric |
787-795 |
Opt in/opt out |
2, alphanumeric |
936-937 |
The fields used for the ship-to record in the Phone Order file (record type 2) are listed in the table below.
Phone Orders File (PHORDS) File Layout |
||
Ship to record (record type 2) |
||
Field |
Attributes |
Positions |
Company |
3.0, numeric, packed |
1-2 |
Sequence # |
7.0, numeric, packed |
3-6 |
Record Type |
1, alphanumeric |
7 |
Batch # |
7.0, numeric, packed |
8-11 |
Arrival Date |
6.0, numeric, packed |
44-47 |
Cancel BO? |
1, alphanumeric |
48 |
Cancel Date |
6.0, numeric, packed |
49-52 |
Contact Name |
30, alphanumeric |
53-82 |
Gift Order? |
1, alphanumeric |
83 |
Resale/Exempt Number |
15, alphanumeric |
84-98 |
Ship Complete |
1, alphanumeric |
99 |
Ship Via |
2.0, numeric, packed |
100-101 |
Purchase Order # |
15, alphanumeric |
102-116 |
Country |
3, alphanumeric |
198-200 |
Prefix |
3, alphanumeric |
201-203 |
First Name |
15, alphanumeric |
204-218 |
Initial |
1, alphanumeric |
219 |
Last Name |
25, alphanumeric |
220-244 |
Street Address |
32, alphanumeric |
245-276 |
Apartment |
10, alphanumeric |
277-286 |
Address Line 2 |
32, alphanumeric |
287-318 |
City |
25, alphanumeric |
319-343 |
State |
2, alphanumeric |
344-345 |
Zip/Postal Code |
10, alphanumeric |
346-355 |
Suffix |
3, alphanumeric |
356-358 |
Delivery Code |
1, alphanumeric |
359 |
PO Box? |
1, alphanumeric |
360 |
Company Name |
30, alphanumeric |
361-390 |
Address line 3 |
32, alphanumeric |
391-422 |
Address line 4 |
32, alphanumeric |
423-454 |
Customer Number |
9.0, numeric, packed |
636-640 |
Ship to |
3.0, numeric, packed |
663-664 |
Permanent Ship to Flag |
1, alphanumeric |
669 |
Phone # day |
14, alphanumeric |
731-744 |
Phone ext day |
4, alphanumeric |
745-748 |
Phone # evening |
14, alphanumeric |
749-762 |
Phone ext evening |
4, alphanumeric |
763-766 |
Phone # fax |
14, alphanumeric |
767-780 |
Phone ext fax |
4, alphanumeric |
781-784 |
PHE OST Freight |
7.2, numeric, packed |
877-880 |
PHE OST Freight Override? |
1, alphanumeric |
881 |
PHE Single Use Promo Code |
10, alphanumeric |
958-967 |
The fields used for the pay type record in the Phone Order file (record type 3) are listed in the table below.
Phone Orders File (PHORDS) File Layout |
||
Pay Type Record (record type 3) |
||
Field |
Attributes |
Positions |
Company |
3.0, numeric, packed |
1-2 |
Sequence # |
7.0, numeric, packed |
3-6 |
Record Type |
1, alphanumeric |
7 |
Batch # |
7.0, numeric, packed |
8-11 |
Amount to charge |
9.2, numeric, packed |
524-528 |
Amount authorized |
9.2, numeric, packed |
529-533 |
Amount billed |
9.2, numeric, packed |
534-538 |
Amount collected |
9.2, numeric, packed |
539-543 |
Amount credited |
9.2, numeric, packed |
544-548 |
Authorization Date |
6.0, numeric, packed |
549-552 |
Authorization Number |
7, alphanumeric |
553-559 |
Balance Open |
9.2, numeric, packed |
560-564 |
Cash applied date |
6.0, numeric, packed |
565-568 |
Cash control number |
5.0, numeric, packed |
569-571 |
Charge sequence |
2.0, numeric, packed |
572-573 |
Credit Card # - prior v75 |
16, numeric |
574-589 |
Expiration date |
4.0, numeric, packed |
590-592 |
Gift cert/coupon # |
7.0, numeric, packed |
593-596 |
Pay Type |
2.0, numeric, packed |
597-598 |
Pay Category |
1, alphanumeric |
599 |
Pay plan |
1, alphanumeric |
786 |
Card security value |
4.0, numeric, packed |
882-884 |
Card security presence |
1, numeric |
885 |
Credit card number - v75 and after |
20, alphanumeric |
938-957 |
The fields used for the item detail record in the Phone Order file (record type 4) are listed in the table below.
Phone Orders File (PHORDS) File Layout |
||
Item Detail Record (record type 4) |
||
Field |
Attributes |
Positions |
Company |
3.0, numeric, packed |
1-2 |
Sequence # |
7.0, numeric, packed |
3-6 |
Record Type |
1, alphanumeric |
7 |
Batch # |
7.0, numeric, packed |
8-11 |
Item Number |
12, alphanumeric |
117-128 |
Offer Number |
3, alphanumeric |
129-131 |
SKU |
14, alphanumeric |
132-145 |
Line Level Arrival Date |
6.0, numeric, packed |
147-150 |
Price |
7.2, numeric, packed |
151-154 |
Qty ordered |
5, numeric, packed |
155-157 |
Special Handling $ |
7.2, numeric, packed |
158-161 |
Gift Wrap? |
1, alphanumeric |
162 |
Coupon? |
1, alphanumeric |
163 |
Coupon $ Override |
7.2, numeric, packed |
164-167 |
Page # |
5.0, numeric, packed |
168-170 |
Page Letter |
6, alphanumeric |
171-176 |
Alias |
12, alphanumeric |
177-188 |
Line Level Source Prior 3.5 |
7, alphanumeric |
189-195 |
Line Level Ship Via |
2.0, numeric, packed |
196-197 |
Warehouse Code |
3.0, numeric, packed |
641-642 |
Location Code |
7, alphanumeric |
643-649 |
Return Reason Code |
3.0, numeric, packed |
650-651 |
No Charge Flag |
1, alphanumeric |
657 |
Affect Inventory |
1, alphanumeric |
658 |
Gift Certificate Number |
7.0, numeric, packed |
665-668 |
Line Level Source |
9, alphanumeric |
796-804 |
The fields used for the message record in the Phone Order file (record type 5) are listed in the table below.
Phone Orders File (PHORDS) File Layout |
||
Messages (record type 5) |
||
Field |
Attributes |
Positions |
Company |
3.0, numeric, packed |
1-2 |
Sequence # |
7.0, numeric, packed |
3-6 |
Record Type |
1, alphanumeric |
7 |
Batch # |
7.0, numeric, packed |
8-11 |
Order date |
6.0, numeric, packed |
12-15 |
User |
10, alphanumeric |
18-27 |
Time Entered |
7.0, numeric, packed |
28-31 |
Print? |
1, alphanumeric |
455-455 |
Message |
60, alphanumeric |
456-615 |
The fields used for the special handling record in the Phone Order file (record type 6) are listed in the table below.
Phone Orders File (PHORDS) File Layout |
||
Special Handling (record type 6) |
||
Field |
Attributes |
Positions |
Company |
3.0, numeric, packed |
1-2 |
Sequence # |
7.0, numeric, packed |
3-6 |
Record Type |
1, alphanumeric |
7 |
Batch # |
7.0, numeric, packed |
8-11 |
Special Handling info |
30, alphanumeric |
600-629 |
The fields used for the catalog request record in the Phone Order file (record type 7) are listed in the table below.
See Checks Against Catalog Request for more information on the validation CWDirect performs against catalog requests received through the phone interface.
Phone Orders File (PHORDS) File Layout |
||
Catalog Requests (record type 7) |
||
Field |
Attributes |
Positions |
Company |
3.0, numeric, packed |
1-2 |
Sequence # |
7.0, numeric, packed |
3-6 |
Record Type |
1, alphanumeric |
7 |
Batch # |
7.0, numeric, packed |
8-11 |
Country |
3, alphanumeric |
198-200 |
Prefix |
3, alphanumeric |
201-203 |
First Name |
15, alphanumeric |
204-218 |
Initial |
1, alphanumeric |
219 |
Last Name |
25, alphanumeric |
220-244 |
Street Address |
32, alphanumeric |
245-276 |
Apartment |
10, alphanumeric |
277-286 |
Address Line 2 |
32, alphanumeric |
287-318 |
City |
25, alphanumeric |
319-343 |
State |
2, alphanumeric |
344-345 |
Zip/Postal Code |
10, alphanumeric |
346-355 |
Suffix |
3, alphanumeric |
356-358 |
Delivery Code |
1, alphanumeric |
359 |
PO Box? |
1, alphanumeric |
360 |
Company Name |
30, alphanumeric |
361-390 |
Address line 3 |
32, alphanumeric |
391-422 |
Source Code |
9, alphanumeric |
787-796 |
The fields used for the individual customer record in the Phone Order file (record type 8) are listed in the table below.
Phone Orders File (PHORDS) File Layout |
||
Individuals Record (record type 8) |
||
Field |
Attributes |
Positions |
Company |
3.0, numeric, packed |
1-2 |
Sequence # |
7.0, numeric, packed |
3-6 |
Record Type |
1, alphanumeric |
7 |
Batch # |
7.0, numeric, packed |
8-11 |
Prefix |
3, alphanumeric |
201-203 |
First Name |
15, alphanumeric |
204-218 |
Initial |
1, alphanumeric |
219 |
Last Name |
25, alphanumeric |
220-244 |
Suffix |
3, alphanumeric |
356-358 |
Area code |
3, numeric, packed |
630-631 |
Phone Number |
7.0, numeric, packed |
632-635 |
Originator/Placer |
1, alphanumeric |
670 |
Department |
3, alphanumeric |
671-673 |
Position |
3, alphanumeric |
674-676 |
Internet address |
50, alphanumeric |
681-730 |
Opt in/opt out |
2, alphanumeric |
936-937 |
Custom Special Handling Record
The fields used for the custom special handling record in the Phone Order file (record type 9) are listed in the table below.
There is one custom special handling record passed for each input label for the special handling format. This record type is loaded directly after the related item (record type 4).
Phone Orders File (PHORDS) File Layout |
||
Custom Special Handling (record type 9) |
||
Field |
Attributes |
Positions |
Company |
3.0, numeric, packed |
1-2 |
Sequence # |
7.0, numeric, packed |
3-6 |
Record Type |
1, alphanumeric |
7 |
Batch # |
7.0, numeric, packed |
8-11 |
Order Date |
6.0, numeric, packed |
12-15 |
Input |
45, alphanumeric |
805-849 |
Charge |
7.2, numeric, packed |
850-853 |
SH Sequence # |
3, alphanumeric |
854-855 |
Inputting Remote Orders (IPHO) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Loading Remote Orders (LPHO) |
OE03_03 CWDirect 18.0.x 2018 OTN