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.

Field / columnTypeDescription & valuesUpdated by
POU-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.PO00.1, PO01.1
POU-PROCURE-GROUP PK
PROCURE_GROUP
Alpha 4This 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 PK
USER_FLD_TYPE
Alpha 1
  • I POITEMVEN
  • V POVENDOR
  • H REQHEADER
  • Q REQLINE
  • P PURCHORDER
  • L POLINE
PO00.1, PO01.1
POU-DATA-TYPE-01
DATA_TYPE_01
Alpha 1PO00.1, PO01.1
POU-DATA-TYPE-02
DATA_TYPE_02
Alpha 1PO00.1, PO01.1
POU-DATA-TYPE-03
DATA_TYPE_03
Alpha 1PO00.1, PO01.1
POU-DATA-TYPE-04
DATA_TYPE_04
Alpha 1PO00.1, PO01.1
POU-DATA-TYPE-05
DATA_TYPE_05
Alpha 1PO00.1, PO01.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
POUSET1USER-FLD-TYPE, COMPANY, PROCURE-GROUPPrimaryPO00.1, PO01.1
POUSET2COMPANY, USER-FLD-TYPE, PROCURE-GROUPDR100, IC11.1, IC12.1, IC13.1, IC141, IC142, IC20.1, IC20.2 +22 more (list truncated in source)
POUSET3PROCURE-GROUP, USER-FLD-TYPE, COMPANY

Programs

Updated by (2)

Referenced by (39)