Chapter 31: Loading the Item File for Emory Worldwide (LEIF) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 33: Working with Default Options (WDFT) |
Chapter 32: Uploading PO Information (POUL)
Purpose: Use this menu option to upload purchase order information to the mainframe computer from the iSeries. You can create a menu option and add this program to a periodic process that runs nightly.
In this chapter:
• Purchase Orders Interface Upload Screen
• Creating the Purchase Order File
• Purchase Order Information File
Purchase Orders Interface Upload Screen
How to display this screen: Enter POUL in the Fast path field at the top of any menu screen or select the Upload PO Information to Interface File option from the menu.
POR0426 ENTER Purchase Orders Interface Upload 8/22/95 11:49:51 Mail Order Company
Submit Batch Job to Upload Purchase Orders to Interface File.
Press Enter to Confirm.
F3=Exit F12=Cancel |
Instructions: Press Enter at this screen to create a file that contains updated purchase order information, and includes purchase orders that have been approved (authorized/released), purchase orders that have been revised (canceled, date changes, etc.), and new purchase orders.
Drop ship purchase orders are not included in this file.
Creating the Purchase Order File
Purpose: Select the Upload PO Information to Interface File option and press Enter. This option builds a file containing all approved purchase orders that have been added, revised, or canceled since the last upload.
The file POUPWK (PO Upload Workfile), which contains a list of purchase orders and the last upload date and revision number, is checked to see whether the purchase order information should be sent. If there is no entry in this file for a purchase order and it is a new approved purchase order, it will be included automatically. This information is uploaded to the mainframe computer from the iSeries.
When you select this option, the existing PO information file is cleared immediately from disk. Then, the POFIL_LOAD job is submitted and program POR0425 runs when you use this option. This program creates the file PORCVI on disk in library CWMPDTA and copies it to library NDM15LIB.
On-demand: Follow these steps to create a menu option for this program, if needed. This allows you to create the purchase order upload file on-demand.
1. Select the Work with Menu Options option (WOPT).
2. Press F6.
3. Enter POUL in the Option field, Upload PO Information to Interface File in the Description field, P (program) in the Type field, POR0426 in the Program name field, N in the Authority parameter field, Y in the Company parameter field, P/O in the Appl area field, and POL in the Appl group field.
During periodic process: Follow these steps to add this program to a periodic process that runs nightly.
1. Select Working with Periodic Functions (WPER).
2. Press F6 to create a periodic function.
3. Enter PO_UPLD (or any descriptive name) in the Function field, Upload PO Information in the Description field, Y in the Company parameter field, All in the Appl area field, and POR0426 in the Program name field.
4. Select Working with Periodic Processes (WPPR).
5. Enter 7 next to the periodic process you want to add this job to, such as a daily periodic process.
6. Enter the sequence number (which specifies when you want this job to run during the periodic process) in the Seq# field, enter the name of the periodic function (specified in Step #3) in the Function field, and enter Y in the Select field (so that the job runs each time the periodic process runs).
Purchase Order Information File
CWDirect Fieldname |
Field name in PO Information File |
Field attributes |
Valid values |
Purchase order number |
PO-ORDER-NBR |
Numeric, 7 positions |
|
|
PO-DEPT-NBR |
Numeric, 3 positions |
Hardcoded to 509 |
PO Status |
PO-ORDER-STAT-CODE |
Alphanumeric, 1 position |
Valid values include: A = Open B = Complete C = Cancel |
|
PO-TYPE-STAT-CODE |
Alphanumeric, 1 position |
Hardcoded to N |
|
PO-APPRV-CODE |
Alphanumeric, 1 position |
Hardcoded to Y |
PO approval date |
PO-APPR-GRP-DATE |
Numeric, 6 positions (YYMMDD format) |
|
|
PO-APPRV-BY-OP-ID-CODE |
Alphanumeric, 6 positions |
Hardcoded to FOLIO |
PO due date |
PO-DELIV-GRP-DATE |
Alphanumeric, 6 positions (YYMMDD format) |
Promise date on purchase order header |
PO cancel date |
PO-CNCL-GRP-DATE |
Alphanumeric, 6 positions (YYMMDD format) |
Cancel date on purchase order header |
PO cancel date |
PO-VENDOR-CNCL-GRP-DATE |
Alphanumeric, 6 positions (YYMMDD format) |
Cancel date on purchase order header |
|
PO-ORDER-BULK-FLAG |
Alphanumeric, 1 position |
Hardcoded to N |
Vendor file country code |
PO-ORDER-FORGN-CODE |
Alphanumeric, 1 position |
D = Domestic: loads a D if Cntry (Country) field in Vendor file is ' ' or equal to the value in the Default Country for Customer Address (B17) field in the System Control file. F = Foreign |
Vendor number |
PO-VENDOR-NBR |
Numeric, 6 positions |
|
|
PO-CNSGN-FLAG |
Alphanumeric, 1 position |
Hardcoded to N |
|
PO-ORDER-LOT-FLAG |
Alphanumeric, 1 position |
Hardcoded to N |
|
PO-PRI-TCKT-FLAG |
Alphanumeric, 1 position |
Hardcoded to N |
|
PO-OTB-SCHED-PCT1 |
Numeric, 3 positions |
Hardcoded to 100 |
|
PO-OTB-SCHED-DATE1 |
Numeric, 4 positions (YYMM) |
Fiscal year and month, using the accounting period associated with the promise date |
|
PO-OTB-SCHED-PCT2 |
Numeric, 2 positions |
Hardcoded to 00 |
|
PO-OTB-SCHED-DATE2 |
Numeric, 4 positions (YYMM) |
Fiscal year and month, using the accounting period associated with the promise date, increased by 1 month1 |
|
PO-OTB-SCHED-PCT3 |
Numeric, 2 positions |
Hardcoded to 00 |
|
PO-OTB-SCHED-DATE3 |
Numeric, 4 positions (YYMM) |
Fiscal year and month, using the accounting period associated with the promise date, increased by 2 months1 |
|
PO-OTB-SCHED-PCT4 |
Numeric, 2 positions |
Hardcoded to 00 |
|
PO-OTB-SCHED-DATE4 |
Numeric, 4 positions (YYMM) |
Fiscal year and month, using the accounting period associated with the promise date, increased by 3 months1 |
|
PO-OTB-SCHED-PCT5 |
Numeric, 2 positions |
Hardcoded to 00 |
|
PO-OTB-SCHED-DATE5 |
Numeric, 4 positions (YYMM) |
Fiscal year and month, using the accounting period associated with the promise date, increased by 4 months1 |
|
PO-OTB-SCHED-PCT6 |
Numeric, 2 positions |
Hardcoded to 00 |
|
PO-OTB-SCHED-DATE6 |
Numeric, 4 positions (YYMM) |
Fiscal year and month, using the accounting period associated with the promise date, increased by 5 months1 |
PO entry date |
PO-ORDER-GRP-DATE |
Numeric, 6 positions (YYMMDD) |
|
|
PO-ORDER-DESI |
Numeric, 25 positions |
Hardcoded to FOLIO ORDER |
Example: If the promise date is August 31, 1995, this translates to accounting period 9508 (YYMM); each successive field increments by 1 accounting period, so that PO-OTB-SCHED-DATE2 would be 9509, PO-OTB-SCHED-DATE3 would be 9510, etc. This date is based on whatever accounting period this date falls between, as defined in the Accounting Periods file in CWDirect. |
Chapter 31: Loading the Item File for Emory Worldwide (LEIF) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 33: Working with Default Options (WDFT) |
SO03_05 CWDirect 18.0 August 2015 OTN