ACPRDPERF – Activity Period Performance
- System
- Activity Management (AC)
- Prefix
PFM- Primary key
ACTIVITY-GRP,ACTIVITY,SYSTEM,SEQ-NUMBER- Fields
- 11
- Updated by
- 11 programs
- Referenced by
- 239 programs
ACPRDPERF is the Activity Period Performance table in Lawson Activity Management (prefix PFM). It is indexed by ACTIVITY-GRP, ACTIVITY, SYSTEM, SEQ-NUMBER (PFMSET1); alternate indexes: PFMSET2. It is related 1:1 to ACACTGRP and ACACTIVITY. It is updated by AC00.1, AC10.1, AC10.6, AC110, AC120, AC19.1, AC200, AC210 and 3 more and referenced by AC130, AC131, AC40.1, AC41.1, AC41.4, AC46.1, AC50.2, ACAC.1 and 231 more. The table has 11 fields, 2 indexes and 6 documented relations.
About ACPRDPERF
The ACPRDPERF file will be keyed by activity group, activity and system code. It will store a record for each system and corresponding performance begin and end dates. This file will be primarily maintained by AC10.6.
Fields (11)
Column = COBOL field name without the PFM- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#PFM-ACTIVITY-GRP PKACTIVITY_GRP | Alpha 15 | The activity group is the overall project. | AC10.6, AC110, AC120, AC19.1, AC502, AC560 |
#PFM-ACTIVITY PKACTIVITY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | AC10.6, AC110, AC19.1, AC502, AC560 |
#PFM-SYSTEM PKSYSTEM | Alpha 2 | A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.) | AC10.6, AC110, AC19.1, AC502, AC560 |
#PFM-SEQ-NUMBER PKSEQ_NUMBER | Numeric 6 | A unique number assigned to each transaction to be interfaced into the Lawson system. | AC10.6, AC110, AC19.1, AC502, AC560 |
#PFM-UPDATE-DATEUPDATE_DATE | Numeric 8 (yyyymmdd) | This field contains the date the record was updated. | AC10.6 |
#PFM-BEGIN-DAYSBEGIN_DAYS | Signed 3.0 | The number of days to be subtracted from the begin date of the activity or activity group the template is applied to. This calculation will result in the POP record begin date. | AC10.6, AC110, AC19.1, AC502, AC560 |
#PFM-BEGIN-DATEBEGIN_DATE | Numeric 8 (yyyymmdd) | The begin date for this effort period. | AC10.6, AC110, AC19.1, AC502, AC560 |
#PFM-END-DAYSEND_DAYS | Signed 3.0 | The number of days to be added to the end date of the activity or activity group the template is applied to. This calculation will result in the POP records begin date. | AC10.6, AC110, AC19.1, AC502, AC560 |
#PFM-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | The end date for this effort period. | AC10.6, AC110, AC19.1, AC502, AC560 |
#PFM-OPERATOROPERATOR | Alpha 10 | This field is used to store the login id of the person who entered the record. | AC10.6, AC110, AC19.1, AC560 |
#PFM-RECORD-TYPERECORD_TYPE | Alpha 1 | This field identifies the type of record defined. Valid values are:
| AC10.6 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PFMSET1 |
| Primary | AC00.1, AC10.1, AC10.6, AC110, AC120, AC200, AC210, AC300 +1 more | |
PFMSET2 |
| AC10.6, AC110, AC130, AC131, AC40.1, AC41.1, AC41.4, AC46.1 +22 more (list truncated in source) |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Acactgrp | ACACTGRP | Required |
| ||||
| Acactgrp1 | ACACTGRP | Required | When PFM-RECORD-TYPE = Spaces |
| |||
| Acactgrp2 | ACACTGRP | Required | When PFM-RECORD-TYPE != Spaces |
| |||
| Acactivity | ACACTIVITY | Required |
| ||||
| Acactivity1 | ACACTIVITY | Required | When PFM-RECORD-TYPE = Spaces |
| |||
| Acactivity2 | ACACTIVITY | Required | When PFM-RECORD-TYPE != Spaces |
|
Programs
Updated by (11)
- AC00.1 Activity Group
- AC10.1 Activity
- AC10.6 Activity Period of Performance
- AC110 Activity Copy
- AC120 Level Reorganization
- AC19.1 Multiple Activity Speed Add
- AC200 Activity Grp Listing and Audit
- AC210 Activity Listing and Audit
- AC300 Activity Group Purge
- AC502 Performance Date Interface
- AC560 Setup Interface
Referenced by (239)
- AC130 Allocation Calculation
- AC131 Allocation Update
- AC40.1 Journal Entry (AC only)
- AC41.1 Resource Time Entry (AC only)
- AC41.4 Resource Time Entry (AC and GL)
- AC46.1 Manual Commitments Transaction Entry
- AC50.2 Performance Date Interface Adjustment
- ACAC.1 Activity Management Activity Edit
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP131 Chargeback
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP30.4 Invoice Cancel
- AP510 Vendor Conversion
- API1.1 Add Invoice
- API2.1 Add Invoice
- BR40.3 Transfer
- BR41.1 Contract Adjustment (AC only)
- BR43.1 Revenue Adjustment
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- CXCP.1 Copy preference to case
- DR100 Distribution Requirements Report
- GL70.1 Recurring Journal
- GL70.2 Define Recurring Journal
- GL70.3 Amounts Only
- GL70.6 Recurring Copy
- IC12.1 Item Location
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC145 Stock Status Report
- IC243 Killed Item Report
- IC330 Item Mass Change
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC66.1 Replenishment PO Worksheet
- IC83.1 Par Location Counts
- MA180 Open Receipt Archive
- MA278 Cost Variance Analysis
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA43.7 GL Distribution
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA53.1 Receipt Interface
- MA530 ERS Invoice Creation
- MA531 Receipt Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.5 Receipt Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA66.2 Invoice Message - Details
- MA67.2 Invoice Match from frontend
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.3 Detail Level Match - Prepaid
- MA68.5 Receipt Match Reference Adjustment
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- MAI1.1 Invoke for MAMATCH Object
- PD10.1 P-Card Card Request
- PD10.2 P-Card Cardholder
- PD130 P-Card Invoice and Release
- PD20.1 P-Card Charge Approval
- PD20.2 P-Card Charge Approval Level
- PD20.3 P-Card Charge Approval SEA
- PD570 P-Card Charge Import
- PO04.1 Buyer
- PO04.2 Buyer Purchasing Class
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO100 Purchase Order Interface from Lawson Applications
- PO101 Create Standing PO Release
- PO115 Procurement Template Mass Changes
- PO120 Mass PO Issue
- PO122 Transmitted PO Acknowledgement
- PO131 Receiving Log
- PO132 Print Vendor Return Material Authorization
- PO136 Matched, Not Received Report
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.4 Procurement Template Line Detail
- PO150 Bid Load to Contract or Catalog
- PO17.1 Purchase Order Approval Review
- PO190 Close Purchase Order Header
- PO20.1 Purchase Order Entry
- PO20.6 Substitute Vendor Items
- PO20.9 Multiple Lines
- PO204 Buyer Master Listing
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO22.1 Authorization, Release
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO230 Unreleased Receivings Listing
- PO234 PO Interface Listing Report
- PO24.1 Purchase Order Direct Approval
- PO25.1 Vendor Agreements
- PO25.5 Vendor Agreement Item Add-On Cost
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO251 PO Buyer Message Listing
- PO26.2 Vendor Agreement Line Distributions
- PO26.3 Vendor Agreement Commitments Spread
- PO26.4 Vendor Agreement Line Price Breaks
- PO26.5 Vendor Agreement Line Price Breaks
- PO26.6 Vendor Agreement Line Maximums
- PO26.7 Mass Release of Vendor Agreements
- PO26.9 Vendor Agreement Release
- PO27.2 Select Blanket Lines
- PO27.3 Create PO From Procurement Template
- PO27.4 Select and Copy Template
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO28.2 Vendor Agreement Line Detail List
- PO280 Purchases By Class
- PO29.1 Copy Purchase Order
- PO30.1 PO Receiving
- PO30.2 Substitute Item
- PO30.3 Additional Tracking Numbers
- PO30.4 PO Receiving Line Detail List
- PO300 PO and Receipt Purge
- PO31.1 Vendor Return
- PO31.2 Vendor Return Item Selection
- PO32.2 Item Detail
- PO32.4 Cancel Detail
- PO33.1 Receiving Adjustment
- PO34.1 Inspection Accept or Reject
- PO35.1 Receiving Approval and Release
- PO36.1 Identify Lawson Items by Vendor Agreement Line
- PO36.2 Vendor Agreement Import Manual Input
- PO38.1 Invoice AOC
- PO39.1 Additional Receiving Entry
- PO39.2 Additional Adjustment/Rejection Entry
- PO44.1 PO Line Source
- PO50.1 Buyer Message Entry
- PO52.1 Buyer Message - Receiving
- PO520 Purchase Order Interface from Non Lawson
- PO536 Vendor Price Agreement Load
- PO54.5 PO Line Detail List
- POCP.1 POC Comments Copy
- POI3.1 Invoke for POPI70PD
- POID.1 PO Delivery Ticket Select
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- RQ01.1 Requesting Locations
- RQ10.1 Requisition
- RQ10.2 Account Distribution
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ12.1 Approval Review
- RQ13.1 Direct Approval
- RQ13.2 Direct Line Approval
- RQ35.1 Requisition Returns
- RQ44.1 Requisition Inquiry
- RQ500 Requisition Interface
- RQ810 Request Location Load
- RQIB.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location
- WH222 Shipments In Process
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program