QAD 2017 Enterprise Edition > User Guides > Sales > Shipment Performance > Reporting Shipment Performance Data > Exporting Historical Performance Data
  
Exporting Historical Performance Data
Use Performance Data Extract (7.9.17.22) to generate a space-delimited file containing shipment performance history (shp_hist) and shipment performance history detail (shpd_det) data. The export file lists each complete shp_hist record, followed by the related shpd_det records, which are followed by the next shp_hist record and so on.
Using data management software, such as a spreadsheet application, you can import the data file for sorting and additional calculations.
Set Report to Yes to view a summary of the records being exported. The summary report shows the transaction ID, customer, receive address, site, order, and line-item number for each exported history record.

Performance Data Extract (7.9.17.22)
Export File Format for shp_hist Records shows the format for the shp_hist record.

Export File Format for shp_hist Records
 
Order
Field Name
Data Type
Format
10
shp_nbr
character
x(8)
20
shp_line
integer
>>9
30
shp_shipfrom
character
x(8)
40
shp_part
character
x(18)
50
shp_cust_part
character
x(30)
60
shp_open_qty
decimal-10
->,>>>,>>9.9<<<<<<<
70
shp_ext_price
decimal-10
->>>>,>>>,>>9.9<<<
80
shp_due_date
date
99/99/99
90
shp_req_date
date
99/99/99
100
shp_perf_date
date
99/99/99
110
shp_ship_date
date
99/99/99
120
shp_cust
character
x(8)
130
shp_ship_qty
decimal-10
->,>>>,>>9.9<<<<<<<
140
shp_ship_price
decimal-10
->>>>,>>>,>>9.9<<<
150
shp_abs_id
character
x(20)
160
shp_include
logical
yes/no
170
shp_tran_id
integer
>>>>>>>9
180
shp_mod_date
date
99/99/99
190
shp_mod_userid
character
x(8)
200
shp_shipto
character
x(8)
210
shp_ship_time
character
99:99
220
shp_rel_id
character
x(30)
230
shp_cmtindx
integer
>>>>>>>9
240
shp_order_category
character
x(8)
250
shp_customer_source
character
x(3)
260
shp_ship_um
character
x(2)
270
shp_ship_um_conv
decimal-10
>>>>9.9999<<<<
280
shp_currency
character
x(3)
290
shp_ord_um
character
x(2)
300
shp_ord_um_conv
decimal-10
>>>>9.9999<<<<
310
shp_sched_time
character
99:99
320
shp_do_req
character
x(8)
330
shp__qadc01
character
x(8)
340
shp__qadc02
character
x(8)
350
shp_user1
character
x(8)
360
shp_user2
character
x(8)
370
shp_qty_pct
decimal-2
->>9.99
Export File Format for shpd_det Records shows the space-delimited file format for the shpd_det record.

Export File Format for shpd_det Records
 
Order
Field Name
Data Type
Format
10
shpd_tran_id
integer
>>>>>>>>
20
shpd_measurement_ type
integer
>
30
shpd_status_code
character
x(8)
40
shpd_rsn_code
character
x(8)
50
shpd_acceptable
logical
yes/no
60
shpd_rsn_type
character
x(8)
70
shpd_meas_subtype
integer
9
80
shpd__qadc01
character
x(8)
90
shpd__qadc02
character
x(8)
100
shpd_mod_userid
character
x(8)
110
shpd_mod_date
date
99/99/99
120
shpd_user1
character
x(8)
130
shpd_user2
character
x(8)
In Export File Format for shpd_det Records, note the following:
• shpd_measurement_type includes:
1–date measurement
2–quantity measurement
• shpd_meas_subtype defines the date measurement for shpd_measurment_type as:
1–due date
2–required date
3–performance date
• shpd_status_code refers to status code master (sttq_mstr)
• shpd_rsn_code refers to reason code master (rsn_ref)