Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POTRACK


                              POTRACK FILE

REFERENCED BY

PO58.2

UPDATED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    IC28.1    MA180     MA530     MA531
MA60.2    MA60.3    MA60.5    MA61.1    MA66.2    MA66.3
MA67.1    MA67.2    MA70.1    MA75.1    MA80.1    MAI1.1
OE10.1    OE10.2    OE10.3    OE10.4    OE10.5    OE10.6
OE10.7    OE10.8    OE11.1    OE11.4    OE11.8    OE11.9
OE110     OE111     OE113     OE114     OE116     OE129
OE13.2    OE13.3    OE13.5    OE13.6    OE14.4    OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE510     OE530     OE81.1    OE810     OE830
OE90.1    OE90.2    PO100     PO101     PO122     PO131
PO20.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO23.1    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO33.1    PO330     PO34.1
PO35.1    PO38.1    PO39.1    PO39.2    PO44.1    PO50.1
PO52.1    PO520     POI3.1    POIE.1    POII.1    POIJ.1
RQ10.1    RQ10.2    WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PTK-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       Identifies the AP company if the          AP131   AP25.1
                       resource type = V.  Identifies the HR     AP25.2  AP26.1
                       company if the resource type = E.  It is  AP27.1  AP30.4
                       blank for type A, P or Q resources.       BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

PTK-REC-NUMBER         Numeric 10                                AP125   AP126
Element: Receiver NumbeThe receiver number.  Assigned when       AP131   AP25.1
                       this receiving information was added.     AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

PTK-LINE-NBR           Numeric 6                                 AP125   AP126
Element: Line Number   This field contains the line number.      AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

PTK-PKG-TRK-NBR        Alpha 40                                  AP125   AP126
Element: Pkg Trk Nbr   Carrier Package Tracking Number.          AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

PTK-NBR-LBLS           Numeric 4                                 AP125   AP126
Element: Nbr Lbls      Number of labels Arrival system will      AP131   AP25.1
                       print when the POTRACK line is processed  AP25.2  AP26.1
                       by Arrival.                               AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

PTK-PO-NUMBER          Alpha 14  (Right Justified)               AP125   AP126
Element: PO Number     This field contains the number            AP131   AP25.1
                       representing the purchase order.          AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

PTK-PO-RELEASE         Numeric 4                                 AP125   AP126
Element: PO Release NumUsed to identify a purchase order         AP131   AP25.1
                       release (created from a Blanket or        AP25.2  AP26.1
                       Standing order).                          AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

PTK-PO-CODE            Alpha 4                                   AP125   AP126
Element: Po Code       This is the purchase order code.          AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

PTK-REQ-NUMBER         Numeric 7                                 AP125   AP126
Element: Requisition NuThis is the assigned number to identify   AP131   AP25.1
                       this requisition.                         AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

PTK-REQUESTER          Alpha 10  (Lower Case)                    AP125   AP126
Element: Requester     This is the person who requested this     AP131   AP25.1
                       requisition.                              AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

PTK-SIGNED-BY          Alpha 40                                  AP125   AP126
Element: Signed By     Name of person signing for package at     AP131   AP25.1
                       final destination.                        AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

PTK-SIGNED-BY-DT       Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Signed By Dt  Date item signed for at final delivery    AP131   AP25.1
                       destination.                              AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

PTK-SIGNED-BY-TIME     Numeric 6  (hhmmss)                       AP125   AP126
Element: Signed By TimeTime item signed for at final delivery    AP131   AP25.1
                       destination.                              AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

PTK-ARRIVAL-ID         Numeric 13                                AP125   AP126
Element: Arrival Id    Arrival internal peice ID.                AP131   AP25.1
                       Position  Description                     AP25.2  AP26.1
                       1-2       Week number within the year     AP27.1  AP30.4
                       3         Day of the week (1=Sunday)      BL120   BL122
                       4-8       Nbr os seconds past midnight    BL130   BL20.1
                       9-10      Station ID                      BL20.3  BL21.2
                       11-13     Sequence number                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE116   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE13.6
                                                                 OE14.4  OE30.1
                                                                 ...

                         POTRACK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PTKSET1   COMPANY                                                AP125   AP126
          REC-NUMBER                                             AP131   AP25.1
          LINE-NBR                                               AP25.2  AP26.1
          PKG-TRK-NBR                                            AP27.1  AP30.4
          REQ-NUMBER                                             BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 ...

PTKSET2   COMPANY                                                AP125   AP126
          REC-NUMBER                                             AP131   AP25.1
          PKG-TRK-NBR                                            AP25.2  AP26.1
          REQ-NUMBER                                             AP27.1  AP30.4
          LINE-NBR                                               BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 ...