GLNLOCDTL – No description in the Lawson data dictionary
- System
- Inventory Control (IC)
- Prefix
GLX- Primary key
ITEM-GROUP,GLN-NBR,GLN-TYPE,SEQUENCE- Fields
- 12
- Updated by
- 295 programs
- Referenced by
- 31 programs
GLNLOCDTL is a Lawson Inventory Control table (prefix GLX); no description in the lawson data dictionary. It is indexed by ITEM-GROUP, GLN-NBR, GLN-TYPE, SEQUENCE (GLXSET1); alternate indexes: GLXSET2, GLXSET3, GLXSET4, GLXSET5, GLXSET6 and GLXSET7. It is related 1:1 to APVENLOC, APVENMAST, BUYER, GLNLOC, GLNLOCDTL, ICBIN, ICCOMPANY, ICLOCATION and 5 more. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 287 more and referenced by AP161, IC10.2, IC11.1, IC175, IC183, IC20.1, IC20.2, IC21.1 and 23 more. The table has 12 fields, 7 indexes and 13 documented relations.
About GLNLOCDTL
No description in the Lawson data dictionary.
Fields (12)
Column = COBOL field name without the GLX- 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 |
|---|---|---|---|
#GLX-ITEM-GROUP PKITEM_GROUP | Alpha 5 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +2 more |
#GLX-GLN-NBR PKGLN_NBR | Alpha 13 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +2 more |
#GLX-GLN-TYPE PKGLN_TYPE | Numeric 2 | —
| AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +2 more |
#GLX-SEQUENCE PKSEQUENCE | Numeric 6 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +2 more |
#GLX-COMPANY SET2 SET6COMPANY | Numeric 4 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +2 more |
#GLX-LOCATION SET2LOCATION | Alpha 5 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +2 more |
#GLX-VENDOR SET4VENDOR | Alpha 9 (Right Justified) | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +2 more |
#GLX-LOCATION-CODE SET4LOCATION_CODE | Alpha 4 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +2 more |
#GLX-BUYER-CODE SET3BUYER_CODE | Alpha 3 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +2 more |
#GLX-MANUF-CODE SET5MANUF_CODE | Alpha 4 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +2 more |
#GLX-MANUF-DIVISION SET5MANUF_DIVISION | Alpha 4 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +2 more |
#GLX-BIN SET2BIN | Alpha 7 | — | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +2 more |
Indexes (7)
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 |
|---|---|---|---|---|
GLXSET1 |
| Primary | AP510, IC02.1, IC10.2, IC11.1, IC12.1, IC15.2, IC175, IC183 +22 more (list truncated in source) | |
GLXSET2 |
| Subset | Where COMPANY != Zeroes And GLN-TYPE != 1 | AP510, IC01.1, IC02.1, IC15.2, IC258, IC58.1, IC58.2, IC58.3 +14 more |
GLXSET3 |
| Subset | Where BUYER-CODE != Spaces And GLN-TYPE = 12 | AP510, IC258, IC58.1, IC58.2, IC58.3, IC64.1, IC64.2, IC64.3 +7 more |
GLXSET4 |
| Subset | Where VENDOR != Spaces | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source) |
GLXSET5 |
| Subset | Where MANUF-CODE != Spaces | AP510, IC14.1, IC258, IC58.1, IC58.2, IC58.3, IC64.1, IC64.2 +7 more |
GLXSET6 |
| Subset | Where COMPANY != Zeroes And GLN-TYPE = 1 | AP161, AP510, ZA161, IC258, IC58.1, IC58.2, IC58.3, IC64.1 +9 more |
GLXSET7 |
| MA540 |
Relations
One to one (13) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apvenloc | APVENLOC | Not Required | Valid When GLX-VENDOR != Spaces And GLX-LOCATION-CODE != Spaces And GLX-GLN-TYPE = 8 |
| |||||||||
| Apvenmast | APVENMAST | Not Required | Valid When GLX-VENDOR != Spaces And GLX-LOCATION-CODE = Spaces And GLX-GLN-TYPE = 7 |
| |||||||||
| Buyer | BUYER | Not Required | Valid When GLX-BUYER-CODE != Spaces And GLX-GLN-TYPE = 12 |
| |||||||||
| Glnloc | GLNLOC | Required |
| ||||||||||
| Glnlocdtl | GLNLOCDTL | Not Required | Valid When GLX-COMPANY != Zeroes And GLX-GLN-TYPE = 1 |
| |||||||||
| Icbin | ICBIN | Not Required | Valid When GLX-COMPANY != Zeroes And GLX-LOCATION != Spaces And GLX-GLN-TYPE = 11 |
| |||||||||
| Iccompany | ICCOMPANY | Not Required | Valid When GLX-COMPANY != Zeroes And GLX-GLN-TYPE = 2 |
| |||||||||
| Iclocation | ICLOCATION | Not Required | Valid When GLX-COMPANY != Zeroes And GLX-LOCATION != Spaces And GLX-GLN-TYPE = 3 |
| |||||||||
| Icmanfcode | ICMANFCODE | Not Required | Valid When GLX-MANUF-CODE != Spaces |
| |||||||||
| Povendloc | POVENDLOC | Not Required | Valid When GLX-VENDOR != Spaces And GLX-LOCATION-CODE != Spaces And GLX-GLN-TYPE = 10 |
| |||||||||
| Povendor | POVENDOR | Not Required | Valid When GLX-VENDOR != Spaces And GLX-LOCATION-CODE = Spaces And GLX-GLN-TYPE = 9 |
| |||||||||
| Procuregrp | PROCUREGRP | Not Required |
| ||||||||||
| Rqloc | RQLOC | Not Required | Valid When GLX-COMPANY != Zeroes And GLX-LOCATION != Spaces And GLX-GLN-TYPE = 4 |
|
Programs
Updated by (295)
- AC160 Asset Management Interface
- AM115 Mass Additions
- AM117 Mass Distribution Split
- AM15.1 Single Invoice Interface
- AM15.2 Combine Invoice Interface
- AM15.3 Single Activity Interface
- AM15.4 Combine Activity Interface
- AM19.1 PO Line Asset Detail
- AM19.2 Create Detail
- AM20.1 Quick Addition
- AM20.3 Items
- AM21.1 Leased Asset Quick Addition
- AM21.3 Items
- AM22.1 Items
- AM500 Asset Management Interface
- AM51.1 Item Update Adjust Interface Maint
- AM551 Item Update Adjustment Interface
- AM97.1 Item Interface Adjustment
- AP03.3 Query List Members
- AP110 Mass Vendor Update
- AP115 Vendor Merge
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP131 Chargeback
- AP150 Cash Requirements
- 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
- AP210 Vendor Listing
- AP220 Invoice Edit Report
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP271 Vendor Spend Report
- AP30.2 Distribution Adjustments
- AP30.4 Invoice Cancel
- AP300 Invoice and Vendor History Purge
- AP305 Accounts Payable Company Purge
- AP510 Vendor Conversion
- AP90.1 Invoice Search by Vendor, Invoice
- AP91.1 Vendor Activity
- API1.1 Add Invoice
- API2.1 Add Invoice
- API3.1 Vendor Location Invoke
- API4.1 Vendor Master Invoke
- 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
- IC01.1 Company
- IC02.1 Location
- IC12.1 Item Location
- IC14.1 Manufacturer Code
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC145 Stock Status Report
- IC15.2 Bins
- 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
- IC802 Locations to LRO via BCI
- IC81.1 Cart, Par Location
- IC83.1 Par Location Counts
- IC840 Cart Par Location Conversion
- MA126 Auto Matching
- MA180 Open Receipt Archive
- MA278 Cost Variance Analysis
- MA279 Invoice AOC Detail Report
- 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.1 Memo Line Detail - Purchase Order
- MA42.2 Memo Line AOC Detail
- MA43.1 Invoice Line Detail - Purchase Order
- MA43.2 Purchase Order Lookup
- MA43.3 Invoice Line Detail - Receipt
- MA43.4 Invoice Line Detail - Service
- MA43.6 Service Agreement Detail
- 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
- MA540 Invoice Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.5 Receipt Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA63.1 Invoice Line Match
- MA65.1 Invoice Line Adjustment
- 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
- MA69.1 AOC Level Detail Match
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- MAI1.1 Invoke for MAMATCH Object
- MX123 List Member Build
- MX500 Attribute Value Population
- 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
- PD235 P-Card Merchant Report
- 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
- PO192 PO Vendor Item Audit Report
- PO195 PO Vendor Agreement Audit Report
- 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.2 Mass Cancel or Delete Purchase Orders
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO22.5 Purchase Order Line Inquiry
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO223 Buyer Expediting Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO230 Unreleased Receivings Listing
- PO233 PO Received Quantity Exceptions
- 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
- PO253 Item Receipt Volume Report
- PO254 PO Inquiry Report
- PO26.3 Vendor Agreement Commitments Spread
- 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
- PO278 RNI Aging Report
- 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
- PO529 PO Receiving File Create
- PO536 Vendor Price Agreement Load
- PO54.1 Purchase Order Inquiry
- PO54.2 Purchase Order Inquiry
- PO54.3 Purchase Order Inquiry
- PO54.4 Purchase Order Inquiry
- 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
- PR05.1 Deduction
- PR05.3 Additional Vendors
- PR226 United States Employee Garnishment Listing
- PR247 Canada Employee Garnishment Listing
- PR26.1 United States Employee Garnishment
- PR47.1 Canada Employee Garnishment
- PR514 Employee Deduction Master Load
- 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
- RQ260 Requisitioned Items Report
- 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
Referenced by (31)
- AP161 Electronic Payment File Creation
- IC10.2 Item Master and Location
- IC11.1 Item Master
- IC175 Update Variances
- IC183 Par Level Load
- IC20.1 Receipts
- IC20.2 Detail Receipts
- IC21.1 Issues
- IC21.2 Detail Issues
- IC22.1 Transfers
- IC22.2 Detail Transfer
- IC223 Availability Report
- IC23.1 Intransit Receiving
- IC24.1 Adjustments
- IC24.2 Detail Adjustments
- IC25.1 Document Release
- IC258 Global Location Number Listing
- IC320 Mass Item Location Copy
- IC331 Par Cart Mass Changes
- IC500 Transaction Interface
- IC503 IC Valid UOM CSV Create
- IC524 CSV Item Master
- IC58.1 Global Location Numbers
- IC58.2 Global Location Numbers Inquiry
- IC58.3 Global Location Numbers Inquiry Details
- IC62.1 Finished Goods
- IC811 Item Master Load
- IC812 Item Location Load
- IC82.1 Par Location Item Mass Change
- PO560 Bid Response Load
- ZA161 Electronic Payment File Creation