POUSRFLDEF – No description in the Lawson data dictionary
- System
- Purchase Order (PO)
- Prefix
POU- Primary key
USER-FLD-TYPE,COMPANY,PROCURE-GROUP- Fields
- 8
- Updated by
- 2 programs
- Referenced by
- 39 programs
POUSRFLDEF is a Lawson Purchase Order table (prefix POU); no description in the lawson data dictionary. It is indexed by USER-FLD-TYPE, COMPANY, PROCURE-GROUP (POUSET1); alternate indexes: POUSET2 and POUSET3. It is updated by PO00.1 and PO01.1 and referenced by DR100, IC11.1, IC12.1, IC13.1, IC141, IC142, IC20.1, IC20.2 and 31 more. The table has 8 fields, 3 indexes and 0 documented relations.
About POUSRFLDEF
No description in the Lawson data dictionary.
Fields (8)
Column = COBOL field name without the POU- 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 |
|---|---|---|---|
#POU-COMPANY PKCOMPANY | Numeric 4 | Identifies 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. | PO00.1, PO01.1 |
#POU-PROCURE-GROUP PKPROCURE_GROUP | Alpha 4 | This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together. | PO00.1, PO01.1 |
#POU-USER-FLD-TYPE PKUSER_FLD_TYPE | Alpha 1 | —
| PO00.1, PO01.1 |
#POU-DATA-TYPE-01DATA_TYPE_01 | Alpha 1 | — | PO00.1, PO01.1 |
#POU-DATA-TYPE-02DATA_TYPE_02 | Alpha 1 | — | PO00.1, PO01.1 |
#POU-DATA-TYPE-03DATA_TYPE_03 | Alpha 1 | — | PO00.1, PO01.1 |
#POU-DATA-TYPE-04DATA_TYPE_04 | Alpha 1 | — | PO00.1, PO01.1 |
#POU-DATA-TYPE-05DATA_TYPE_05 | Alpha 1 | — | PO00.1, PO01.1 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
POUSET1 |
| Primary | PO00.1, PO01.1 | |
POUSET2 |
| DR100, IC11.1, IC12.1, IC13.1, IC141, IC142, IC20.1, IC20.2 +22 more (list truncated in source) | ||
POUSET3 |
| — |
Programs
Updated by (2)
Referenced by (39)
- DR100 Distribution Requirements Report
- IC11.1 Item Master
- IC12.1 Item Location
- IC13.1 Associated Items
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC20.1 Receipts
- IC20.2 Detail Receipts
- IC21.1 Issues
- IC21.2 Detail Issues
- IC21.5 Issues Detail List
- IC22.1 Transfers
- IC22.2 Detail Transfer
- IC23.1 Intransit Receiving
- IC23.2 Detail Intransit Receiving
- IC24.1 Adjustments
- IC24.2 Detail Adjustments
- IC29.1 Lots
- IC83.1 Par Location Counts
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO13.1 Vendor Item
- PO13.3 Vendor Items
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- RQ10.1 Requisition
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ13.2 Direct Line Approval
- RQ35.1 Requisition Returns
- RQ500 Requisition Interface
- RQIA.1 RQREQPD Invoke Object
- RQIB.1 RQRQHUPD Invoke Object
- RQID.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy