Generating Source Codes Using the Source Upload Table (WSRW)
Purpose: You can create a Order Administration source code using information from the Source Upload Table (IXSRCE).
Transferring data into the Source Upload table:
- Use the File Storage API to upload the file, and then run the UPSRCCD Upload Source Code File (Program name PFR0134, Parameter IXSRCE) periodic function; or
- Use the Work with File Uploads (WUPL) menu option to upload records to the Source Upload table.
Note:
The database does not allow an empty (null) value in any field, so in order to populate the Source Upload 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).You can use the sample data below to create a Source Code upload file.
7|SOURCECD7|C|$O|H|D|K|SOURCECD7 SOURCE CODE DESCRIPT|500.00|.00|.00|CD|5.00|DR|N|12.00|5.00|25.00|5.00|1|10000|1150401|5000|7000|POP
UP WINDOW MESSAGE 1 |POP UP WINDOW MESSAGE 2 |POP UP WINDOW
MESSAGE 3 |POP UP WINDOW MESSAGE 4 |12345|1234567|12.00|12345|123|Y|N|Y|12.00|12.00|150.00|55.00|ALPHANUMERIC
30 POSITIONSUSER1|ALPHANUMERIC 30 POSITIONSUSER2|ALPHANUMERIC 30 POSITIONSUSER3|ALPHANUMERIC
30 POSITIONSUSER4|ALPHANUMERIC 30 POSITIONSUSER5|ALPHANUMERIC 30 POSITIONSUSER6|N|N|07|
|007|01|01|123|RCCD|LSTSOURCE|FPOCD|N|CAT|CL|1150601| |
|123.00|N|N|
Once you upload records to the Source Upload table, you can use the Work with Source Code Upload File (WSRW) menu option to change, delete, or display source upload 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 Upload table:
- If a source upload 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 upload records that are in an error status by selecting OK on the Change Source Code Upload File Screen (1 of 2).
- If a source upload 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 upload process: The following flowchart explains how the system creates a Order Administration source code using information defined in the Source Upload table.
In this topic:
- 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 Upload 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 Upload 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, 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 Promotions (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 from the Source Upload table to the Source Code table. 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, FPO payment code, and Price table fields contain valid values.
If a record passes all of the edits performed, the system:
- prints the source upload record on the Source Code Upload File Processed Listing. This report lists all source codes created through the source code upload.
- creates a Order Administration source code. You can review or maintain the source code in Working with Source Codes (WSRC).
- deletes the record from the Source Upload table.
If a record does not pass all of the edits performed, the system:
- prints the source upload record on the Source Code Upload File Exception Report. This report lists all of the source upload records that contain errors.
- retains the source upload record in the Source Upload table until the record is fixed or deleted. You can correct errors that exist on a source upload record on the Change Source Code Upload File Screen (1 of 2).
Screen Option | Procedure |
---|---|
Change a source upload record |
Select Change for a source upload record to advance to the Change Source Code Upload File Screen (1 of 2). |
Delete a source upload record |
Select Delete for a source upload record to delete it. |
Display a source upload record |
Select Display for a source upload 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 upload 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 upload 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 upload 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 upload 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 Upload Table (IXSRCE)
Purpose: You can use the Work with Source Code Upload (WSRW) menu option to create source codes in your company based on the data in this table. See Generating Source Codes Using the Source Upload Table (WSRW).
Field | Attributes | Field Description |
---|---|---|
Company |
Numeric, 3 positions; required |
Order Administration company. This is a key field. |
Source code |
Alphanumeric, 9 positions; required |
Order Administration 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, 13 positions with a 2-place decimal; required |
User defined field. |
List broker code |
Numeric, 3 positions |
User defined field. |
List cost |
Numeric, 13 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, 13 positions with a 2-place decimal |
User defined field. |
Freight minimum |
Numeric, 13 positions with a 2-place decimal |
User defined field. |
Freight maximum |
Numeric, 13 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) |
NA |
Marketing projection |
Numeric, 13 positions with a 2-place decimal |
User defined field. |
Net circulation |
Numeric, 7 positions |
NA |
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 |
NA |
Secondary freight |
Numeric, 13 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, 13 positions with a 2-place decimal |
User defined field. |
Variable ad expense |
Numeric, 13 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 Order Administration division. |
Promotion code |
Alphanumeric, 7 positions |
Must be a valid Order Administration promotion code. |
OFR number |
Alphanumeric, 3 positions; required |
Must be a valid Order Administration offer number. |
Source category |
Alphanumeric, 2 positions |
Must be a valid Order Administration source category. |
Ship via |
Numeric, 2 positions |
NA |
Freight table |
Alphanumeric, 3 positions |
Must be a valid Order Administration freight table. |
Recency code |
Alphanumeric, 4 positions |
Not currently implemented. |
LST source |
Alphanumeric, 9 positions |
Not currently implemented. |
FPO payment code |
Alphanumeric, 5 positions |
Must be a valid Order Administration 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 Order Administration catalog request type. |
Customer class |
Alphanumeric, 2 positions |
Must be a valid Order Administration 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 Order Administration 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 |