CALCRATE (Version 3



CALCPAK 6.0.38 Shipment Interfaces

FOR UPS - (UPS supplied program iSeries “Host Access” or AR Traffic Electronic Manifesting Tool required)

FOR FEDEX - (Fed Ex supplied iSeries “FXRS Ship Manager” or AR Traffic web services required)

➢ Load the PAKAUTOP file. This data resides in the system until cleared, via a user created program.

Note: The ASSYS field identifies which shipping system/carrier for which the record is intended. UPS, FED, DHL, USP.

Note: If a tracking # is passed and the carrier and service level does not change, then CalcPak will not create one.

➢ The user accesses records in the PAKAUTOP when the order is scanned into a CalcPak (station controlled/automatic) shipping function. Alternatively, for “unattended” shipping, each carrier specific function (UPS-PAK37R, FEDEX-PAK97R, USPS-PAK137R) is called with the following parameters: warehouse (PWHSE, 6 A), order # (PORDR, 20 A), and error code (PERRR, 7 A). If the shipment is unable to be manifested, the PERRR parameter will return a value of CALCXXX. The meaning of this value can be located in the message file CALCMSGF. The PERRR parameter will be blank if successful.

FOR UPS

➢ The output of manifested records can be found in the UPSDLYP file.

➢ The user calls option 7 (From the UPS Processing Menu) to transmit the daily data. If the transaction is successful, it is moved to the history file. Once the daily manifest is physically “closed”, historical information may be found in both CalcPak’s UPSHSTP file and CalcRate’s BLRATEP file.

➢ In addition, closed manifest records will be written to Auxiliary Shipment History Files (see below): both order header (ORDHEDP) and detail (ORDDETP). If these files are not used, we recommend that they be cleared periodically.

FOR FEDEX

➢ CalcPak automatically accesses the Federal Express server to determine the appropriate rate and label information.

➢ The output of manifested records can be found in the FDXDLYP file.

➢ The user calls menu option 7 (From the Fed Ex Processing Menu) to “closeout” the daily shipments. If successful, these records are moved to the history file. Once the daily manifest is physically “closed”, historical information may be found in both CalcPak’s FDXHSTP file and CalcRate’s BLRATEP file.

Note: The Fed Ex “PowerShip” takes care of the transmission to Fed Ex.

➢ In addition, closed manifest records will be written to Auxiliary Shipment History Files (see below): both order header (ORDHEDP) and detail (ORDDETP). If these files are not used, we recommend that they be cleared periodically.

FOR USPS

➢ The output of manifested records can be found in the USPDLYP file.

➢ The user calls menu option 7 (From the USPS Processing Menu) to physically move the records to history. Once the daily manifest if physically “closed”, historical information may be found in both CalcPak’s USPHSTP file and CalcRate’s BLRATEP file.

➢ In addition, closed manifest records will be written to Auxiliary Shipment History Files (see below): both order header (ORDHEDP) and detail (ORDDETP). If these files are not used, we recommend that they be cleared periodically.

Auxiliary Shipment History Files – Optional:

These files are created daily for ARTC clients wishing to invoice their customers during the shipping day, prior to closing the current manifest. The Auxiliary Shipment History consists of two files: a header file (ORDHEDP) and corresponding detail file (ORDDETP).

➢ The user may add records to these files during automatic shipment entry by accessing an order summary window (F8=View Order Summary). In this window, there exists a one position ‘Close Order’ flag. When this flag is manually set to “Y,” a single summary

record is written to the header file (ORDHEDP) and each individual parcel record corresponding to an order # is written to the detail file (ORDDETP).

➢ The header file (ORDHEDP) contains a one position invoice flag (OIFLG, 1A). When this flag is set to “Y” for a specific order, via a user created program, additional detail records for that order will not be added (i.e. a new header record and its associated detail will be created).

➢ When closing the current manifest for a given type of processing (Option 7 of the UPS, , FedEx, or USPS Processing Menu), all records not previously written to the Auxiliary Files via the above mentioned window, will be added to these files. If a header record exists for an order number, that has not yet been invoiced (OIFLG not yet changed to “Y”), then the record will be added to the detail file for this order number. Else if the flag is “Y,” another header record, along with its associated detail, will be created for this order.

Note: The Auxiliary Detail File shows cost per parcel excluding multiweight rates.

➢ The Auxiliary file data resides in the system until cleared, via a user created program.

If you want to extract data from CalcPak (i.e. shipping charges, tracking #’s, etc) and the users were not closing out order’s as described above in the Auxiliary file, than you could search CalcRate’s BLRATEP file, though records get written to this file only when each carrier’s daily manifest is closed. Therefore, it may be necessary to search each individual parcel carrier’s daily and/or history file.

Package Contents File – Optional:

This file (PAKCTNP) is available for the user to load the expected contents to be contained in the parcel.

➢ The user may display and edit the quantity shipped (updates PAKCTNP) in the specified parcel.

Tracking # Assignment for “Unattended” Shipping - Optional:

Note: CalcPak normally assigns the tracking # during the label print process while the parcel is on the scale. This program (PAK69R) is used to create tracking #’s, which are placed on pre-generated shipping labels produced by the user (required in an unattended shipping environment).

➢ Call PAK69R with the following parameters: Carrier code (4 A) and warehouse code (6 A). If shipping UPS the following Y/N flags must also be passed: Saturday Delivery (1 A), Confirmed Delivery with Signature (1 A), Confirmed Delivery without Signature (1 A), and Call Tag (1 A). No special parameters are needed for Fed Ex shipping.

➢ If successful, CalcPak will return tracking # (18 A), else an error message (CALCMSGF, 7 A) will return.

➢ This tracking # should then be written to the corresponding UPS or FDX AUTOP file.

➢ Call CALC37R (or 97R or 137R as described above) to move the parcels directly to the DAILYP file without user intervention at a scale station. Note: Orders loaded to the AUTOP file without a tracking # will be assigned one at this time.

Shipment Confirmation Interface – Optional:

In order to access the applicable (UPS, FedEx, or USPS) CalcPak shipping screen directly from your internal primary business system.

➢ Load PAKAUTOP file.

➢ Call PAK98R with parameters warehouse (PWHSE, 6 A), order # (PORDR, 20 A), (PERRR, 7 A), and (PRATE, 15,5 N).

➢ The applicable shipping screen will display for the user. Upon CalcPak ship confirmation (Option 7 of the UPS, FedEx, or USPS processing menus), the program will return either the rated amount (PRATE, 15,5 N) or the CalcPak error code (PERRR, 7 A).

Note: The rated amount represents the cost of shipping an individual parcel. Upon “close-out” on the days manifest, all shipments moving to similar destinations, with similar service levels, are re-rated for potential “hundred weight” cost savings. If applicable, the HSTP files will display both the individual carton cost (URATE) and the allocated hundred weight cost (UHND#).

Automatic Data Population:

CalcPak has its own Customer Masterfile. If an order is dropped into an AUTOP file without shipment information, CalcPak will auto-populate information stored in its Customer Masterfile for the user when metering.

ASHPN, USHPN, FSHPN are the fields in the AUTOP files that correspond to the CCODE (Customer Code) that is stored in the Customer Masterfile.

User Exit Program:

CalcPak calls ART490C which calls a user-created program called ART490. If ART490 does not exist, this call is ignored.

ART490C is called twice:

➢ when the user enters an order # into the entry screen

➢ typically to validate the order#

➢ when the package has been metered

➢ typically to retrieve freight charges.

CalcPak 6.0

Summary of Required Fields:

|All alphanumeric fields should have data left justified unless noted. |

|All numeric fields are zoned unless noted. |

| | | | |

|Opt/Req: O = optional, O* = optional, required in certain circumstances, R = required |

| | | | |

| | |Opt/ | |

|Field |Size |Req |Description |

| | | | |

|AWHSE |6A |R |CALCPAK "ship from" warehouse code, 1st field of file key. |

|AAKEY |20A |R |Automatic/Unattended mode shipment/parcel identifier, 2nd field of file key. Would be loaded with a |

| | | |unique key for each parcel (UCC#) if possible, else pick sheet #/order #/etc. |

|AORDR |20A |O |Order number from PBS (Primary Business System); Used as shipment reference in UPS PLD file. If not |

| | | |initialized, replaced with AAKEY value within programs that process PAKAUTOP records. Currently only |

| | | |field along with AINV# passed to current and historical manifest files (***DLYP/***HSTP). For |

| | | |interfacing freight charge information back to primary business system, this field should contain a |

| | | |value that maps back to a specific pick slip/parcel ID. |

|APCL# |20A |O |Parcel number/UCC# from PBS/Warehouse management system |

|APCK# |12A |O |Pick Sheet number from PBS |

|AINV# |12A |O |Invoice number field from PBS, can be used as reference info on UPS label. |

|ACUS# |12A |O |Customer number from PBS |

|ASHP# |12A |O |Ship To Location number from PBS |

|ASPO# |22A |O |Ship To PO Number from PBS |

|ACPY |35A |O |Consignee Company Name |

|ANAME |35A |O* |Consignee Attention Name; Required for some service levels, such as Early AM, First Overnight; |

|AADD1 |35A |R |Consignee Address Line 1 |

|AADD2 |35A |O |Consignee Address Line 2 |

|AADD3 |35A |O |Consignee Address Line 3 |

|ACITY |30A |R |Consignee City |

|ASTAT |2A |O* |Consignee State/Province; Required for shipments to US, Canada & Puerto Rico; |

|AZIP6 |6A |O* |Consignee Postal Code; Required for shipments to US, Canada & Puerto Rico. Code needs to be right |

| | | |justified.; |

|ACTRY |2A |O* |Consignee ISO Country Code; Required for shipments outside US, Canada or Puerto Rico; |

|AIDZP |9A |O* |Consignee International Postal Code; Postal code for non US, Canada & Puerto Rico destinations, |

| | | |required based on specifec country; |

|APHON |15A |O* |Consignee Phone Number; Number should be left justified, for US, Canada & PR do not include the '1' |

| | | |before the area code; Required for some service levels; |

|ASHPN |10A |R |Ship To Number/ID; Used in key to determine shipments to same destination/consignee; |

|AACCT |12A |O* |Consignee Account #; Required for collect billing ABILL='COL'; |

|A3PAC |12A |O* |3rd Party Account #; Required for 3rd party billing ABILL='TPB'; |

|A3PCP |35A |O* |3rd Party Company Name; Required for UPS 3rd party billing; |

|A3PAT |35A |O* |3rd Party Attention Name; Required for UPS 3rd party billing; |

|A3PA1 |35A |O* |3rd Party Address 1; Required for UPS 3rd party billing; |

|A3PA2 |35A |O |3rd Party Address 2 |

|A3PA3 |35A |O |3rd Party Address 3 |

|A3PCT |30A |O* |3rd Party City; Required for UPS 3rd party billing; |

|A3PST |2A |O* |3rd Party State; Required for UPS 3rd party billing; |

|A3PZ6 |6A |O* |3rd Party Zip; Required for UPS 3rd party billing; Right justify; |

|A3PPH |15A |O* |3rd Party Phone; Required for UPS 3rd party billing; |

|A3PF# |15A |O |3rd Party Fax # |

|AWGHT |4,1 |O* |Predetermined weight of parcel; Required for unattended processing; |

|ABILL |3A |R |Billing Charge Type; (PRE,COL,CBS,TPB) |

|ACARR |4A |R |Carrier Code |

|ABTYP |2A |O |Box type code, any entry must exist in BOXCDEP file; Cannot use both this field and the ADIM* fields; |

|APTYP |2A |O |Package type code |

|ATRCK |18A |O |Preassigned tracking number |

|ADIML |3,0 |O |Parcel length |

|ADIMW |3,0 |O |Parcel width |

|ADIMH |3,0 |O |Parcel height |

|ADESC |35A |O* |Parcel contents description; Required for international/transborder parcels; |

|AEXVA |7,2 |O* |Export value; Required for UPS international/transborder parcels. |

|AGLDG |15A |O |General Ledger Account |

|ASCDT |8,0 |O |Future pick-up date |

|ADCLF |1A |O |Declared value flag (Y/N/blank); Used to signify if declared/excess value charge is to be applied. |

|ADCLA |7,2 |O* |Declared value amount, required if ADCLF='Y' |

|ACODF |1A |O |COD flag (Y/N/blank) |

|ACODA |6,2 |O* |COD merchandise amount, shipping charge & COD fee will be added in processing routines; Required if |

| | | |ACODF='Y' |

|AHAZF |1A |O |Hazardous material flag (Y/N/blank) |

|AOVSF |1A |O |Oversize package flag (Y/N/blank); Must be set to 'Y' if ADIM* fields are to used for parcel |

| | | |dimensions; |

|ASATD |1A |O |Saturday delivery flag (Y/N/blank) |

|ASATP |1A |O |Saturday pickup flag (Y/N/blank); FedEx only; |

|ASUND |1A |O |Sunday delivery flag (Y/N/blank); FedEx only; |

|AINSD |1A |O |Inside delivery flag (Y/N/blank) - not currently used; |

|AINSP |1A |O |Inside pickup flag (Y/N/blank) - not currently used; |

|ACNF1 |1A |O |Confirm delivery w/ signature (Y/N/blank) |

|ACNF2 |1A |O |Confirm delivery w/o signature (Y/N/blank) |

|ACALF |1A |O |Call tag/return services (Y/N/blank) - UPS only |

|AHNDF |1A |O |Additional handling fee flag (Y/N/blank) - UPS only |

|ARESF |1A |O |Residential Delivery Flag (Y/N/blank) |

|AEMA1 |50A |O |Notification Email Address 1 |

|AEMA2 |50A |O |Notification Email Address 2 |

|AREAD |50A |O |Reply-To Email Address |

|AFEAD |50A |O |Failure Email Address |

|ASSYS |3A |R |Shipping system ID - UPS, FED, DHL, etc; This field identifies which data structure has been utilized |

| | | |to fill field ADATA; PAK98R will use this field value to determine which CALCPAK shipping module to |

| | | |call for the record. |

|ADATA |2000A |O* |Shipping system specific additional information; ASSYS field identifies which system specific data |

| | | |structure (***AUTODS) was used to initialize this field. |

| | | |See Data Structures Below. |

SOURCE FILE . . . . . . . CALCPAK/QDDSSRC

MEMBER . . . . . . . . . UPSAUTODS

100 *

200 * EXTERNAL DATA STRUCTURE FOR ADATA FIELD IN PAKAUTOP

300 * USED FOR RECORDS WITH 'UPS' IN FIELD ASSYS

400 *

500 A R UPSAUTODSF

600 *

700 A UCODN 11A TEXT('UPS COD Control #')

800 A UCODI 1A TEXT('UPS Funds Indicator')

900 A UTAGN 12A TEXT('UPS Call Tag #')

1000 A UCAL# 1A TEXT('UPS Call Tag Type')

1100 * Hazardous Material fields

1300 A U21RS 5A TEXT('UPS HAZ Regulation Set')

1400 A U21RQ 2A TEXT('UPS HAZ Reportable Qty')

1500 A U21SN 150A TEXT('UPS HAZ Shipping Name')

1600 A U21TD 200A TEXT('UPS HAZ Technical Desc')

1700 A U21HC 7A TEXT('UPS Hazardous Material Class')

1800 A U21SC 7A TEXT('UPS HAZ Subrisk Class')

1900 A U21ID 6A TEXT('UPS HazMat ID Number')

2000 A U21IN 10A TEXT('UPS HAZ Item Number')

2100 A U21GL 1A TEXT('UPS HAZ Packing Group Letter')

2200 A U22GN 5A TEXT('UPS HAZ Packing Group Type')

2300 A U22AD 255A TEXT('UPS HAZ Additional Desc')

2400 A U22QT 5A TEXT('UPS HAZ Qty-Mass/Capacity')

2500 A U22UN 10A TEXT('UPS HAZ Units of Measure')

2600 A U22PT 255A TEXT('UPS HAZ Package Type')

2700 A U22PI 4A TEXT('UPS HAZ Package Information')

2800 A U22PH 25A TEXT('UPS HAZ Emergency Phone #')

2900 * Notification option fields

3000 A UMTPC 2A TEXT('UPS Media Type Code')

3500 A UFAXI 1A TEXT('UPS Fax Indicator')

3600 A UFAX# 15A TEXT('UPS Fax Number')

3700 A UCOMP 35A TEXT('UPS Company Name')

3800 A UATNM 35A TEXT('UPS Attention Name')

3900 A UNPHN 15A TEXT('UPS Attention Phone')

SOURCE FILE . . . . . . . CALCPAK/QDDSSRC

MEMBER . . . . . . . . . FDXAUTODS

100 * 200 * EXTERNAL DATA STRUCTURE FOR ADATA FIELD IN PAKAUTOP

300 * USED FOR RECORDS WITH 'FED' IN FIELD ASSYS 400 *

500 A R FDXAUTODSF

600 *

700 A FGHSC 3S 0 TEXT('FedEx Grnd/Home Srvc Class')

800 A FREF1 20A TEXT('FedEx Package Reference 1')

900 A FREF2 20A TEXT('FedEx Package Reference 1')

1000 A FCODC 1A TEXT('FedEx COD Cash Only Flag')

1100 A FHCLA 4A TEXT('FedEx Hazardous Material Cls')

1200 A FHOL 1A TEXT('FedEx Hold at Location Flag')

1300 A FHLAD 35A TEXT('FedEx Hold at Loc Address')

1400 A FHLCT 24A TEXT('FedEx Hold at Loc City')

1500 A FHLST 2A TEXT('FedEx Hold at Loc State')

1600 A FHLZP 10A TEXT('FedEx Hold at Loc Zip') 1700 A FIBSF 1A TEXT('FedEx Int Broker Select Flag')

1800 A FIBNM 30A TEXT('FedEx Int Broker Name')

1900 A FIBCT 20A TEXT('FedEx Int Broker City')

2000 A FIBST 15A TEXT('FedEx Int Broker St/Prov')

2100 A FIBZP 10A TEXT('FedEx Int Broker Zip')

2200 A FIBCN 2A TEXT('FedEx Int Broker Country')

2300 A FIBPH 15A TEXT('FedEx Int Broker Phone#')

2400 A FPRAF 1A TEXT('FedEx Priority Alert Flag')

2500 A FSHAF 1A TEXT('FedEx Ship Alert Flag')

2700 A FRTCP 25A TEXT('FedEx COD Return Company')

2800 A FRTDP 12A TEXT('FedEx COD Return Department')

2900 A FRTA1 25A TEXT('FedEx COD Return Address 1')

3000 A FRTA2 25A TEXT('FedEx COD Return Address 2')

3100 A FRTCT 24A TEXT('FedEx COD Return City')

3200 A FRTST 2A TEXT('FedEx COD Return State')

3300 A FRTZP 6A TEXT('FedEx COD Return Zip')

3400 A FRTPH 10A TEXT('FedEx COD Return Phone')

3500 * Export Information

3600 A FDUTY 1A TEXT('FedEx Duty/Tax Pay Code')

3700 A FDUTA 9A TEXT('FedEx Duty/Tax Account')

3800 A FMARK 15A TEXT('FedEx Marks/Nos')

3900 A FEL# 7A TEXT('FedEx Export License #')

4000 A FLEDT# 8S 0 TEXT('FedEx Export Lic Exp Date')

4100 A FIRS 15A TEXT('FedEx Sender IRS/EIN #')

4200 A FHARM 10A TEXT('FedEx Harmonized Code')

4300 A FTSR 19A TEXT('FedEx FTSR Exemption #')

4400 A F1DES 30A TEXT('FedEx Commodity Desc 1')

4500 A F1WHT 8S 0 TEXT('FedEx Commodity Wgt 1')

4600 A F1VAL 15S 6 TEXT('FedEx Commodity Unit Value 1')

4700 A F1QTY 7S 0 TEXT('FedEx Commodity Qty 1')

4800 A FCI1C 15A TEXT('FedEx CI Comment 1')

4900 A F2DES 30A TEXT('FedEx Commodity Desc 2')

5000 A F2WHT 8S 0 TEXT('FedEx Commodity Wgt 2')

5100 A F2VAL 15S 6 TEXT('FedEx Commodity Unit Value 2')

5200 A F2QTY 7S 0 TEXT('FedEx Commodity Qty 2')

5300 A FCI2C 15A TEXT('FedEx CI Comment 2')

5400 A F3DES 30A TEXT('FedEx Commodity Desc 3')

5500 A F3WHT 8S 0 TEXT('FedEx Commodity Wgt 3') 5600 A F3VAL 15S 6 TEXT('FedEx Commodity Unit Value 3')

5700 A F3QTY 7S 0 TEXT('FedEx Commodity Qty 3')

5800 A FCI3C 15A TEXT('FedEx CI Comment 3')

SOURCE FILE . . . . . . . CALCPAK/QDDSSRC

MEMBER . . . . . . . . . USPAUTODS

100 *

200 * EXTERNAL DATA STRUCTURE FOR ADATA FIELD IN PAKAUTOP

300 * USED FOR RECORDS WITH 'USP' IN FIELD ASSYS

400 *

500 A R USPAUTODSF

600 *

700 A SCODN 11A TEXT('USP COD Control #')

800 A STAGN 12A TEXT('USP Call Tag #')

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download