Working with Recency Codes (WRCC) | Contents | SCVs | Search | Glossary | Reports | Database | Solutions | XML | Index | Source Code Upload File Processed Listing |
Generating Source Codes Using the Source Code Work File (WSRW)
Purpose: You can create a CWSerenade source code using information from the Source Code Work Table (IXSRCE).
Once you create a source code work record, you can use the Work with Source Code Work File option to change, delete, or display source code work records and then transfer the records to the Source Code table.
When you transfer the source code records, the system validates each record in the Source Code Work table:
• If a source code work record contains any errors, the system flags the record with a status of E and includes the record on the Source Code Upload File Exception Report. You can correct source code work records that are in an error status by selecting OK on the Change Source Code Upload File Screen (1 of 2).
• If a source code work record does not contain any errors, the system transfers the record to the Source Code table and displays the record on the Source Code Upload File Processed Listing. See Working with Source Codes (WSRC).
Source code work table process: The following flowchart explains how the system creates a CWSerenade source code using information defined in the Source Code Work table.
Transferring data into the work table: The SQL database does not allow an empty (null) value in any field, so in order to populate the Source Code Work Table (IXSRCE) without error for fields that you do not want to populate in the created source code records, enter a zero (for a numeric field) or a space (for an alphanumeric field).
In this topic:
• Work with Source Code Upload File Screen
• Work with Source Code Upload File Screen
• Change Source Code Upload File Screen (1 of 2)
• Display Source Code Upload File Screen
• Source Code Upload File Processed Listing
• Source Code Upload File Exception Report
Work with Source Code Upload File Screen
Purpose: This screen displays all of the records in the Source Code Work Table (IXSRCE). Use this screen to review, change, delete and transfer source code work records.
How to display this screen: Enter WSRW in the Fast path field at the top of any menu or select Work with Source Code Work File from a menu.
Field |
Description |
Source (Source code) |
A unique, user-defined code to identify a segment of your customer base and to analyze sales. The source code drives marketing, forecasting, pricing, freight, and service charge information on an order. See Working with Source Codes (WSRC). Alphanumeric, 9 positions; optional. |
Description |
The description of this source code. Alphanumeric, 30 positions; optional. |
Div (Division code) |
A unique code for a profit center or area of financial reporting. Alphanumeric, 2 positions; optional. |
Promo (Promotional code) |
A code to group source codes together. See Working with Promotion Values (WPRO). Alphanumeric, 7 positions; optional. |
Offer |
The code for the catalog, space, or advertisement from which you accept orders. See Working with Offers (WOFR). Alphanumeric, 3 positions; optional. |
Status (Source code work file status) |
A code used to indicate whether this source code work record contains an error. Valid values are: E = the source code work record contains an error. blank = the source code work record does not contain an error. Alphanumeric, 1 position; optional. |
Instructions:
Select Process File to submit the transfer. A message indicates that the source code transfer has been submitted.
The job validates that:
• The value defined in the Source code field is unique for the company you are working in.
• The Company, Consumer/business, Freight method, House account code, Price method, Type, Description, Breakeven amount, Restricted, Display on O/E select, Division, and Offer fields contain information.
• The Consumer/business, Freight method, House account code, Price method, Type, Exclude service charge, Promotion pricing, Display on O/E select, Exclude from flexible option, Exclude promotion, Division, Promotion code, Offer, Source category, Freight table, Recency code, List source, FPO payment code, and Price table fields contain valid values.
If a record passes all of the edits performed, the system:
• prints the source code work record on the Source Code Upload File Processed Listing. This report lists all source codes created through the source code upload.
• creates a CWSerenade source code. You can review or maintain the source code in Working with Source Codes (WSRC).
• deletes the record from the Source Code Work table.
If a record does not pass all of the edits performed, the system:
• prints the source code work record on the Source Code Upload File Exception Report. This report lists all of the source code work records that contain errors.
• retains the source code work record in the Source Code Work table until the record is fixed or deleted. You can correct errors that exist on a source code work record on the Change Source Code Upload File Screen (1 of 2).
Screen Option |
Procedure |
Change a source code work record |
Select Change for a source code work record to advance to the Change Source Code Upload File Screen (1 of 2). |
Delete a source code work record |
Select Delete for a source code work record to delete it. |
Display a source code work record |
Select Display for a source code work record to advance to the Display Source Code Upload File Screen. |
Submit the upload process |
Select Process File. See above. |
Change Source Code Upload File Screen (1 of 2)
Purpose: Use this screen to change information defined for a source code work record.
When you select OK on this screen, the system highlights any fields that are in error so that you can correct them. You cannot transfer a source code work record to the Source Code table if it contains any errors.
How to display this screen: On the Work with Source Code Upload File Screen, select Change for a source code work record.
See Create Source Code Screen (1 of 2) for a description of the fields on this screen.
Change Source Code Upload File (2 of 2)
How to display this screen: Select OK on the Change Source Code Upload File Screen (1 of 2).
See Create Source Code Screen (1 of 2) for a description of the fields on this screen.
Display Source Code Upload File Screen
How to display this screen: Select Display for a source code work record at the Work with Source Code Upload File Screen to advance to the Display Source Code Upload File screen. You cannot change any information on this screen. For field descriptions, see Create Source Code Screen (1 of 2).
Source Code Work Table (IXSRCE)
Purpose: You can use the Work with Source Code Work File menu option to create source codes in your company based on the data in this table. See Generating Source Codes Using the Source Code Work File (WSRW).
Field |
Attributes |
Field Description |
Company |
Numeric, 3 positions; required |
CWSerenade company. This is a key field. |
Source code |
Alphanumeric, 9 positions; required |
CWSerenade source code. The source code must be a unique code within the Source Code table. This is a key field. |
Consumer/business |
Alphanumeric, 1 position; required |
Valid values are: B = business C = consumer |
Freight method |
Alphanumeric, 2 positions; required |
Valid values are: $O = dollar chart/offer $S = dollar chart/source A = actual billing amount F = flat rate/ship to FI = flat rate/item FQ = flat rate/quantity FS = flat rate/item source I = by item OW = order weight PS = percentage/source PV = percentage/ship via R = recipient W = weight |
House account code |
Alphanumeric, 1 position; required |
Valid values are: H = house account blank = in-house list |
Price method |
Alphanumeric, 1 position; required |
Valid values are: C = use item cost D = regular plus reprice N = no charge O = no charge/no cost P = regular hierarchy |
Type |
Alphanumeric, 1 position; required |
Valid values are: N = do not analyze K = known U = unknown |
Description |
Alphanumeric, 30 positions; required |
The source code description. This is a user defined field. |
Breakeven amount |
Numeric, 9 positions with a 2-place decimal; required |
User defined field. |
List broker code |
Numeric, 3 positions |
User defined field. |
List cost |
Numeric, 9 positions with a 2-place decimal |
User defined field. |
Cover code |
Alphanumeric, 2 positions |
User defined field. |
Discount % |
Numeric, 5 positions with a 2-place decimal |
User defined field. |
Drop code |
Alphanumeric, 2 positions |
User defined field. |
Exclude service |
Alphanumeric, 1 position |
Valid values are: N = no Y = yes blank = no value defined |
Flat freight amount |
Numeric, 7 positions with a 2-place decimal |
User defined field. |
Freight minimum |
Numeric, 7 positions with a 2-place decimal |
User defined field. |
Freight maximum |
Numeric, 7 positions with a 2-place decimal |
User defined field. |
Freight percent |
Numeric, 5 positions with a 2-place decimal |
User defined field. |
Backorder priority |
Numeric, 1 position |
User defined field. |
Gross circulation |
Numeric, 7 positions |
Informational only. |
Mail date |
Numeric, 7 positions (CYYMDD format) |
|
Marketing projection |
Numeric, 7 positions with a 2-place decimal |
User defined field. |
Net circulation |
Numeric, 7 positions |
|
Pop up window #1 |
Alphanumeric, 30 positions |
User defined field. |
Pop up window #2 |
Alphanumeric, 30 positions |
User defined field. |
Pop up window #3 |
Alphanumeric, 30 positions |
User defined field. |
Pop up window #4 |
Alphanumeric, 30 positions |
User defined field. |
Projected names |
Numeric, 5 positions |
User defined field. |
Requests mailed |
Numeric, 7 positions |
|
Secondary freight |
Numeric, 7 positions with a 2-place decimal |
User defined field. |
Up to freight quantity |
Numeric, 5 positions |
User defined field. |
Maximum ship tos-freight |
Numeric, 3 positions |
User defined field. |
Promo pricing |
Alphanumeric, 1 position |
Valid values are: N = no Y = yes blank |
Restricted |
Alphanumeric, 1 position; required |
Valid values are: N = no Y = yes blank |
Display on O/E select |
Alphanumeric, 1 position; required |
Valid values are: N = no Y = yes blank |
% net fill |
Numeric, 5 positions with a 2-place decimal |
User defined field. |
% margin |
Numeric, 5 positions with a 2-place decimal |
User defined field. |
Cost per order |
Numeric, 9 positions with a 2-place decimal |
User defined field. |
Variable ad expense |
Numeric, 9 positions with a 2-place decimal |
User defined field. |
SRC user 1 |
Alphanumeric, 30 positions |
User defined field. |
SRC user 2 |
Alphanumeric, 30 positions |
User defined field. |
SRC user 3 |
Alphanumeric, 30 positions |
User defined field. |
SRC user 4 |
Alphanumeric, 30 positions |
User defined field. |
SRC user 5 |
Alphanumeric, 30 positions |
User defined field. |
SRC user 6 |
Alphanumeric, 30 positions |
User defined field. |
Exclude from flex opt |
Alphanumeric, 1 position |
Valid values are: N = no Y = yes blank |
Exclude promotion |
Alphanumeric, 1 position |
Valid values are: N = no Y = yes blank |
Division |
Alphanumeric, 2 positions; required |
Must be a valid CWSerenade division. |
Promotion code |
Alphanumeric, 7 positions |
Must be a valid CWSerenade promotion code. |
OFR number |
Alphanumeric, 3 positions; required |
Must be a valid CWSerenade offer number. |
Source category |
Alphanumeric, 2 positions |
Must be a valid CWSerenade source category. |
Ship via |
Numeric, 2 positions |
|
Freight table |
Alphanumeric, 3 positions |
Must be a valid CWSerenade freight table. |
Recency code |
Alphanumeric, 4 positions |
Must be a valid CWSerenade recency code. |
LST source |
Alphanumeric, 9 positions |
Must be a valid CWSerenade list source. |
FPO payment code |
Alphanumeric, 5 positions |
Must be a valid CWSerenade FPO payment code. |
Catalog request |
Alphanumeric, 1 position |
Valid values are: N = no Y = yes blank |
Catalog request type |
Alphanumeric, 3 positions |
Must be a valid CWSerenade catalog request type. |
Customer class |
Alphanumeric, 2 positions |
Must be a valid CWSerenade customer class. |
Discount expiration |
Numeric, 7 positions (CYYMMDD format) |
Must be a valid date. |
File status |
Alphanumeric, 1 position |
Valid values are: E = an error exists on this record. blank = an error does not exist on this record. |
Price table |
Alphanumeric, 5 positions |
Must be a valid CWSerenade price table. |
Commission pct |
Numeric, 5 positions with a 2-place decimal |
|
Warranty required |
Alphanumeric, 1 position |
Valid values are: N = no Y = yes blank |
Credit check? |
Alphanumeric, 1 position |
Valid values are: N = no Y = yes blank |