DBD: Warehouse Release Report-Create Text File Option

The Create Text File feature allows you to export your report data directly into a structured, comma-delimited text file. This is particularly useful for administrators who need to extract raw data for external analysis or downstream system integrations.

💡 Important Export Behavior: The generated text file includes standardized column headers to help you map the fields, but it does not contain any visual sub-totals or report totals.

How to Enable the Text File Export

Open the Warehouse Release Report (3.8 - FMGCKS ) selection screen.
Define your desired filtering criteria (such as Customer Code, Location, or Activity Dates).
In the options panel at the bottom right, locate the Create Text File? checkbox.
Check the box to enable the export functionality when the program executes.

File Naming Convention & Storage

When the report runs with this option enabled, the system automatically generates and saves the file to the server environment using a strict structural logic.

Storage Directory

The file is saved directly to the server environment at:

/usr/lib/pvx/export

🔒 Administrative Access: If the export directory does not exist, the system will automatically create it upon running the program. An administrator can access these files securely via a terminal application like PuTTY.

File Name Format

Files are named sequentially to ensure nothing is accidentally overwritten:

RELRPTYYMMDD.SEQ

YYMMDD : The current year, month, and day of generation (e.g., 260519 for May 19, 2026).
SEQ : A three-digit sequence number (e.g., 001 ). This sequence increments automatically each time a new file is created on the same day.

Data Structure & Column Logic

The generated comma-delimited file maps data elements sequentially using the following behavioral rules:

Customer & Location Keys: The first two columns of every row in the file will always contain the Customer Number and the Ship-To Code Number.
RC Number Mapping: The program dynamically checks for an RC number associated with the specific Order and Line Number being printed. If an RC number is detected, it will append it cleanly as the final column on that specific row.