ITEMSPECL – No description in the Lawson data dictionary

About ITEMSPECL

No description in the Lawson data dictionary.

Fields (11) Copy as SQL

Column = COBOL field name without the ITP- 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.

Indexes (3)

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.

Programs

Updated by (1)

• PO26.8 Update Vendor Agreement Line for Special Item

Referenced by (222)

• 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
• 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
• IC11.1 Item Master
• IC11.8 Old Special Items for Item
• 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
• 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.1 Agreement Item Lookup
• 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
• PO63.1 PO Inquiry By Item
• POCP.1 POC Comments Copy
• POI3.1 Invoke for POPI70PD
• POID.1 PO Delivery Ticket Select
• POIH.1 Invokeable Unit Cost Default
• 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