POTRACK – Package Tracking Number

System
Purchase Order (PO)
Prefix
PTK
Primary key
COMPANY, REC-NUMBER, LINE-NBR, PKG-TRK-NBR, REQ-NUMBER
Fields
14
Updated by
221 programs
Referenced by
2 programs

POTRACK is the Package Tracking Number table in Lawson Purchase Order (prefix PTK). It is indexed by COMPANY, REC-NUMBER, LINE-NBR, PKG-TRK-NBR, REQ-NUMBER (PTKSET1); alternate indexes: PTKSET2. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 213 more and referenced by PO58.2 and POIE.1. The table has 14 fields, 2 indexes and 0 documented relations.

About POTRACK

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the PTK- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PTK-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PTK-REC-NUMBER PK
REC_NUMBER		Numeric 10The receiver number. Assigned when this receiving information was added.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PTK-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PTK-PKG-TRK-NBR PK
PKG_TRK_NBR		Alpha 40Carrier Package Tracking Number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PTK-NBR-LBLS
NBR_LBLS		Numeric 4Number of labels Arrival system will print when the POTRACK line is processed by Arrival.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PTK-PO-NUMBER
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PTK-PO-RELEASE
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PTK-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PTK-REQ-NUMBER PK
REQ_NUMBER		Numeric 7This is the assigned number to identify this requisition.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PTK-REQUESTER
REQUESTER		Alpha 10 (Lower Case)This is the person who requested this requisition.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PTK-SIGNED-BY
SIGNED_BY		Alpha 40Name of person signing for package at final destination.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PTK-SIGNED-BY-DT
SIGNED_BY_DT		Numeric 8 (yyyymmdd)Date item signed for at final delivery destination.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PTK-SIGNED-BY-TIME
SIGNED_BY_TIME		Numeric 6 (hhmmss)Time item signed for at final delivery destination.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PTK-ARRIVAL-ID
ARRIVAL_ID		Numeric 13Arrival internal peice ID. Position Description 1-2 Week number within the year 3 Day of the week (1=Sunday) 4-8 Nbr os seconds past midnight 9-10 Station ID 11-13 Sequence numberAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PTKSET1
  1. COMPANY
  2. REC-NUMBER
  3. LINE-NBR
  4. PKG-TRK-NBR
  5. REQ-NUMBER
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PTKSET2
  1. COMPANY
  2. REC-NUMBER
  3. PKG-TRK-NBR
  4. REQ-NUMBER
  5. LINE-NBR
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (221)

Referenced by (2)