Setting Up the Number Assignment File (WNUM)

Setting Up the Number Assignment File (WNUM)

Purpose: Use the Number Assignment file to establish the starting and ending number assignments used throughout the system for fields that require a unique identifier, such as an order number, purchase order number and customer number.

The system will automatically and sequentially assign the next number for each record defined in this file. Typically, this file is pre-loaded by MICROS. If, however, the Number Assignment file is empty, you must define each number assignment during system set up. See Available Number Assignments for a description of each number assignment.

In this topic:

• Work with Number Assignment Screen

• Available Number Assignments

• Create Number Assignment Screen

• Copy Company Info Window (Copying a Number Assignment)

• Change Number Assignment Screen

Work with Number Assignment Screen

Purpose: Use this screen to change, copy, delete, or display a number assignment field.

How to display this screen: Enter WNUM in the Fast path field at the top of any menu or select Work with Number Assignment from a menu.

MSR0285 DISPLAY Work with Number Assignment 11/07/97 15:21:40

The KL Mail Order Company

File Reset

Opt Code Description Last # Start # End # Date

Type options, press Enter.

2=Change 3=Copy 4=Delete 5=Display

A01 Order Batch 32 1 9999999 12/31/94

A02 Cash Control # 1 1 999999999

A03 Coupon # 282 0 999999999

A04 Purchase Order Header 343 0 999999999

A05 Order Header 1625 1 999999999

A06 P/O Receipt Control 97 0 999999999

A07 Customer Sold To 12725 0 999999999

A08 Item Transaction Batch 134 0 999999999

A09 Suspense Placement Work 1 1 999999999

A10 Customer Fraud 70 0 999999999 +

F3=Exit F6=Create F12=Cancel F24=Select company

Field	Description
File code	A code to uniquely identify a number assignment. Alphanumeric, 3 positions; optional.
Last #	The number most recently assigned for the number assignment. Numeric, 9 positions; optional.
Start #	The initial number for the number assignment. Numeric, 9 positions; optional.
End #	The highest possible number that can be used for a number assignment. The value in the Last # field rolls (begins at the value in the Start # field again) when it reaches the value in the End # field. Numeric, 9 positions; optional.
Reset date	The date on which you changed the value in the Last # field manually. Numeric, 6 positions (MMDDYY format); optional.

Screen Options	Procedure
Change a number assignment	Enter 2 next to a number assignment to advance to the Change Number Assignment Screen.
Copy a number assignment	Enter 3 next to a number assignment to advance to the Copy Company Info Window (Copying a Number Assignment).
Delete a number assignment	Enter 4 next to a number assignment to delete it. An error message displays if you try to delete a system supplied number: System supplied number file codes cannot be deleted.
Display a number assignment	Enter 5 next to a number assignment to advance to the Display Number Assignment Screen.
Create a number assignment	Press F6 advance to the Create Number Assignment Screen.

Available Number Assignments

Purpose: This chart lists and describes all of the number assignment records that should be included in your system. If the number assignment file is empty when you install the system, you must define each number assignment during system installation.

Although 9 positions are available for the Start # and End # fields, actual field lengths vary. For example, the number assignment A01 (Order Batch) is a 5-digit field; therefore, the numbers in the Start # and End # fields cannot exceed 5 digits. Refer to this table for exact field lengths for each number assignment.

Code	Number Assignment	Description	Field name/Field length
A01	Order Batch	Assigns the next number when entering a new batch of mail orders during Order Entry.	OBA Batch # Numeric, 5 positions
A02	Cash Control #	Not currently used by the system.	OPM Cash Control Number Numeric, 5 positions
A03	Coupon #	Assigns the next number to a coupon which may be used as payment on a future order.	CPN Coupon # Numeric, 7 positions
A04	Purchase Order Header	Assigns the next number to a purchase order for merchandise.	POH PO # Numeric, 7 positions
A05	Order Header	Assigns the next number to uniquely identify a new customer order.	OHD Order # Numeric, 8 positions
A06	P/O Receipt Control	Assigns the next number when receiving merchandise ordered on several purchase orders to distribute costs across all goods received.	POC Control # Numeric, 7 positions
A07	Customer Sold To	Assigns the next number to uniquely identify the customer who places an order or wants a catalog.	CST Customer # Numeric, 9 positions
A08	Item Transaction Batch	Assigns the next number to a batch of inventory transactions.	ITB Number Numeric, 7 positions
A09	Suspense Placement Work	Assigns the next number to incoming inventory being held in suspense.	SPW Job # Numeric, 6 positions
A10	Customer Fraud	Assigns the next number to uniquely identify a fraudulent name and address.	CFF Seq # Numeric, 7 positions
A11	Customer Bill To	Assigns the next number to a customer who will be billed on account for purchases.	CBT Account # Numeric, 7 positions
A12	Short SKU	Assigns the next number to an item or SKU so that you can uniquely identify it when passing e-commerce information or when picking and packing it (the number is printed with a product's bar code on the pick slip).	SKU Short SKU Numeric, 7 positions
A13	PCH Billing Batch #	Assigns the next number to a batch of pick slips so that you may bill all pick slips in the batch in a single step.	PCH Billing Batch # Numeric, 7 positions
A14	Pick Slip Gen Opts #	Assigns a number to a pick slip generation procedure, such as one that generates pick slips by customer number.	PSO Seq # Numeric, 5 positions
A15	PCH Control #	Assigns the next number to uniquely identify each pick slip.	PCH Control # Numeric, 7 positions
A16	Billing Invoice #	Assigns the next number to an invoice which uniquely identifies a shipment.	IHD Invoice # Numeric, 7 positions
A17	RA Header #	Assigns the next number to a pre-authorized return.	RAH RA# Numeric, 3 positions
A18	Refund Check #	This number assignment is no longer implemented; the system uses the refund check number specified in the Bank file instead.	RRC Check # Numeric, 7 positions
A19	Cash Receipts Batch #	Assigns the next number to a new batch of payment transactions.	CRH Batch # Numeric, 7 positions
A20	Open Item #	Assigns an internal tracking number for a customer account invoice.	ARI Open Item # Numeric, 7 positions
A21	Authorization Record
A22	A/P Entry Batch #	Assigns the next number to a new batch of invoices received from outside vendors.	AIH Batch Number Numeric, 5 positions
A23	A/P Check #	Assigns the next number to an Accounts Payable (A/P) check used to pay a vendor. You can change this number when you select to run A/P checks.	APC Check # Numeric, 7 positions
A24	Gift Certificate #	Assigns the next number to a gift certificate which may be used as payment on a future order.	GCT Gift Certificate # Numeric, 7 positions
A25	Call Tag #	Assigns the next call tag number to pick up an item being returned.	CTG Call Tag # Numeric, 7 positions
A26	Cart Batch #	Assigns the next number to a cart to be used for cart/bin picking.	PDL Cart Batch # Numeric, 3 positions
A27	Order Cross Reference	Assigns the next order number equivalent to an order number from another system.	OCR Cross Reference # Numeric, 9 positions
A28	Invoice Cross Reference	Assigns the next invoice number equivalent to an invoice number from another system.	ICR Cross Reference # Numeric, 9 positions
A29	Barcode Counter	Assigns the next barcode number that will print on the shipping label. This counter is used by TanData when you ship a miscellaneous package (not a CWDirect order). This enables you to wand the barcode on the package and add it to the manifest.	(No field defined in CWDirect) Numeric, 9 positions
A30	Amex Deposit File Sequence #	Assigns the next sequence number to uniquely identify a deposit file transmitted to the American Express credit card authorization service	(No field defined in CWDirect) Numeric, 6 positions
A31	NaBanco Batch #	Assigns the next batch number to uniquely identify a deposit file transmitted to the NaBanco credit card authorization service	(No field defined in CWDirect) Numeric, 3 positions
A32	JCP Deposit File Batch #	Assigns the next batch number to uniquely identify a deposit file transmitted to the J.C. Penney credit card authorization service	(No field defined in CWDirect) Numeric, 3 positions
A33	JCP Deposit File Sequence #
A34	Item #	Assigns the next item number in item entry if Auto assign item # in the System Control file = Y.	(No field defined in CWDirect) Numeric, 9 positions maximum
A35	Vendor Charge Back #	Assigns the next number to identify a vendor charge back.	VCH Vendor Charge Back Nbr Numeric, 9 positions
A36	Item to Item Tfr ID#	Assigns the next number to identify an item to item transfer (item transaction code = G). The system uses the same ID number for both the "from" and "to" items.	ITH ID Numeric, 9 positions (the system adds an additional position to the beginning of the number containing the letter "I")
A37	A/P STS Transfer Batch #	Assigns the batch number to assign to records you add to the A/P Batch Header file when downloading A/P invoice records to the STS application.	ABH Transfer batch number Numeric, 9 positions
A38	Outlet Transfer	Assigns the next control number for items requested for replenishment by outlet warehouses.	ARD Control number Numeric, 9 positions
A39	Cash Receipts Transaction ID	Assigns the next number to a new batch of payment transactions, whether you are using the Cash Receipts or the Batch Payment function.	(no field defined in CWDirect) Numeric, 9 positions maximum
A40	Internet Order Batch	Assigns the next control number when you process a batch of orders received through the internet interface.	Numeric, 5 positions
A41	GECC Batch Sequence #	Assigns the next sequence number to identify a deposit file transmitted to the GECC credit card authorization service.	(No field defined in CWDirect) Numeric, 9 positions
A42	PkMS Pick Number	Assigns a PkMS pick control number to each pick slip generated. The PkMS pick control number remains the same for any pick slip that is reprinted.	OCR B Number Numeric, 7 positions
A43	PkMS Case Number	Assigns the next number to the Case number field in the PkMS Customer Returns file.	Case number Numeric, 10 positions
A47	Order Number Download	Used to assign a sequential file name for the warehouse interface during pick slip generation.	(No field in CWDirect)
A48	Check Interface Download ID	Assigns the next number to the Western Union download transaction number.	No field defined in CWDirect Numeric, 7 positions
A49	PkMS Case Control Number	Assigns the next number to the Batch control number field in the PkMS Case Interface file.	Batch control number Numeric, 10 positions
A50	PkMS Item Control Number	Assigns the next number to the Batch control number field in the PkMS Item Interface file.	Batch control number Numeric, 10 positions
A51	PkMS Pick Control Number	Assigns the next number to the Batch control number field in the PkMS Pick Ticket Header file.	Batch control number Numeric, 10 positions
A52	PkMS PO/ASN Control Number	Assigns the next number to the Batch control number field in the PkMS PO/ASN Header Interface file.	Batch control number Numeric, 10 positions
A53	PkMS Vendor Control Number	Assigns the next number to the Batch control number field in the PkMS Vendor Master file.	Batch control number Numeric, 10 positions
A54	Forecast21 Item Product Sequence Number	Assigns the next number to the Forecast21 Item Product Interface.	No field defined in CWDirect. Numeric, 9 positions
A55	Forecast21 Order Transaction Sequence Number	Assigns the next number to the Forecast21 Order Transaction Interface.	No field defined in CWDirect. Numeric, 9 positions
A56	Forecast21 Key Code Sequence Number	Assigns the next number to the Forecast21 Key Code Interface.	No field defined in CWDirect. Numeric, 9 positions
A57	SKU Quick Price Update Number	Assigns the next sequence number to each SKU/offer price created in Update SKU Offer Prices so that multiple users can create SKU/offer prices at one time.	Job number Numeric, 6 positions
A58	Vendor Number	Assigns the next sequence number when you create a new vendor, skipping over numbers already assigned to vendors.	Numeric, 7 positions
A60	Item File Transfer #	Assigns the next sequence number to the name of the PkMS Item file when you FTP item information to PkMS. Example: If the next number is 3434, the PkMS Item file is named I1003434.	No field defined in CWDirect Numeric, 6 positions
A61	Item Note File Transfer #	Assigns the next sequence number to the name of the PkMS Item Note file when you FTP item information to PkMS. Example: If the next number is 3434, the PkMS Item Note file is named I1003434.	No field defined in CWDirect Numeric, 6 positions
A62	PO File Transfer #	Assigns the next sequence number to the name of the PkMS PO file when you FTP purchase order information to PkMS. Example: If the next number is 3434, the PkMS PO file is named I1003434.	No field defined in CWDirect Numeric, 6 positions
A63	Vendor File Transfer #	Assigns the next sequence number to the name of the PkMS Vendor file when you FTP vendor information to PkMS. Example: If the next number is 3434, the PkMS Vendor file is named I1003434.	No field defined in CWDirect Numeric, 6 positions
A64	Returns File Transfer #	Assigns the next sequence number to the name of the PkMS Returns file when you FTP return information to PkMS. Example: If the next number is 3434, the PkMS Returns file is named I1003434.	No field defined in CWDirect Numeric, 6 positions
A65	Pick Ticket File Transfer #	Assigns the next sequence number to the name of the PkMS Pick Ticket Header file when you FTP pick slip information to PkMS. Example: If the next number is 3434, the PkMS Pick Ticket Header file is named I1003434.	No field defined in CWDirect Numeric, 6 positions
A66	Stop Ship File Transfer #	Assigns the next sequence number to the name of the PkMS Pick Ticket Header file when you FTP stop pick slip shipment requests to PkMS. Note: The system uses the Pick Ticket File Transfer # number assignment value to send stop pick slip shipment requests to PkMS. This number assignment value is not currently implemented.	No field defined in CWDirect Numeric, 6 positions
A67	Immediate Need File Transfer #	Assigns the next sequence number to the name of the PkMS Immediate Needs file when you FTP immediate needs to PkMS. Example: If the next number is 3434, the PkMS Immediate Needs file is named IA003434.	No field defined in CWDirect Numeric, 6 positions
A68	Transaction Sequence #	Assigns the next sequence number to the online authorization when you receive a response from the authorization service during online credit card authorization.	Transaction sequence # Numeric, 15 positions
A69	PkMS Immediate Need Control Number	Assigns the next sequence number to a PkMS Immediate Needs record when you create records in the PkMS Immediate Needs file by submitting the PkMS Immediate Needs batch program.	Batch control # Numeric, 10 positions
A71	Batch Auth File Trace Number	Assigns the next sequence number to the Reference ID field in the Integration Process Control file. CWDirect updates the merchantFileTrace value in the generic CWAuthorizationRequest batch message or generic CWDepositRequest batch message with this number.	Reference ID Alphanumeric, 16 positions Note: When sending authorizations and deposits to certain service bureaus, the Batch Auth File Trace Number cannot be greater than 3 positions. Enter 999 in the End number field for this number assignment value to ensure that this number does not exceed 3 positions.
A72	Tickler Number	Assigns the next sequence number to the Tickler number field for a newly created tickler.	Tickler number Numeric, 9 positions
A73	Identcode	Uses the next sequence number as the suffix to the Prefix of Identcode (I28) if this system control value is not blank.	N/A; writes an order transaction history message, and prints on the pick slip if your Pick Printing Program (C37) supports it.
A74	Alternate Customer #	Assigns the next sequence number to the Alt cust (Alternate customer number) field whenever a new customer is created if the Assign Alternate Customer # (I88) system control value is set to Y.	Alt customer # Alphanumeric, 15 positions

Create Number Assignment Screen

Purpose: Use this screen to define the number assignments required for system installation. See Available Number Assignments.

How to display this screen: Press F6 at the Work with Number Assignment Screen.

MSR0316 ENTER Create Number Assignment 11/07/97 15:57:22

The KL Mail Order Company

File code . . . .

Last # . . . . . .

Start # . . . . .

End # . . . . . .

Reset date . . . .

F3=Exit F12=Cancel

Field	Description
File code	A unique identifier assigned to each number assignment. Once a file code is assigned, it cannot be changed, only deleted. See Change Number Assignment Screen. Alphanumeric, 3 positions; display-only.
Last #	The most recent number automatically assigned by the system or set manually. The last number must be greater than or equal to the value in the Start # field. Numeric, 9 positions; required.
Start #	The initial value for a number assignment. Numeric, 9 positions; required.
End #	The highest possible number to be assigned for a number assignment. Numeric, 9 positions; required.
Although 9 positions are available for the *Start #* and *End #* fields, actual field lengths vary. For specific field lengths, refer to the table entitled Available Number Assignments.
Reset date	The date on which you changed the value in the Last # field manually. Enter a reset date each time you update the value in the Last # field. Numeric, 6 positions (MMDDYY format); required (only if last number is changed manually).

Copy Company Info Window (Copying a Number Assignment)

Purpose: Use this window to copy a number assignment to one or all of the companies set up on your system.

How to display this screen: At the Work with Number Assignment Screen, enter 3 next to the number assignment you wish to copy.

Copy Company Info

Press ENTER to copy Company 555

information into Company

Or press F12 to cancel copy procedure.

Or Press F15 to copy to All Companies.

F12=Cancel F15=All Companies

Field	Description
Company code	A code to uniquely identify a company set up on your system. A company contains a single, isolated set of files and data: it is an organization of financial information, inventory, and customers that is completely separate from another company. Numeric, 3 positions; required.

Field

Description

Company code

A code to uniquely identify a company set up on your system.

A company contains a single, isolated set of files and data: it is an organization of financial information, inventory, and customers that is completely separate from another company.

Numeric, 3 positions; required.

To copy to one company: Enter the company code to which you wish to copy a number assignment and Press Enter.

To copy to all companies: Press F15.

Change Number Assignment Screen

To change: Enter 2 next to the number assignment at the Work with Number Assignment Screen to advance to the Change Number Assignment screen. You can change all fields on this screen except the File code field.

See Create Number Assignment Screen for a description of the fields on this screen.

Display Number Assignment Screen

To display: Enter 5 next to the number assignment at the Work with Number Assignment Screen to advance to the Display Number Assignment screen. You cannot change any information on this screen.

See Create Number Assignment Screen for a description of the fields on this screen.

Setting Up Accounts Payable Values

Contents

SCVs

Search

Glossary

Reports

Solutions

XML

Index

Setting Up EDI Values

IN03_12 CWDirect 18.0.x 2018 OTN