POIAATRIB – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PIT
Primary key
DIMENSION-NAME, ATTRIBUTE-NAME
Fields
6
Updated by
8 programs
Referenced by
7 programs

POIAATRIB is a Lawson Purchase Order table (prefix PIT); no description in the lawson data dictionary. It is indexed by DIMENSION-NAME, ATTRIBUTE-NAME (PITSET1); alternate indexes: PITSET2. It is updated by POA2.1, POA2.2, POA2.3, POA2.4, POA5.1, POA5.2, POA5.3 and POA5.4 and referenced by IAVO.1, POA1.1, POA10, POA3.1, POAB.1, POAO.1 and POAP.1. The table has 6 fields, 2 indexes and 0 documented relations.

About POIAATRIB

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the PIT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PIT-DIMENSION-NAME PK
DIMENSION_NAME		Alpha 50 (Lower Case)The Dimension Name field contains the dimension name that is used by the OLAP database. Valid values are: Year Period Measures Scenario Compton Territory Customer ItemsPOA5.1, POA5.2, POA5.3, POA5.4
PIT-LAWSON-DIM-NAM
LAWSON_DIM_NAM		Alpha 20—POA5.1, POA5.2, POA5.3, POA5.4
PIT-ATTR-LAWSON-NM
ATTR_LAWSON_NM		Alpha 12—POA5.1, POA5.2, POA5.3, POA5.4
PIT-ATTR-LVL-NAME
ATTR_LVL_NAME		Alpha 12—POA5.1, POA5.2, POA5.3, POA5.4
PIT-ATTRIBUTE-NAME PK
ATTRIBUTE_NAME		Alpha 50 (Lower Case)—POA5.1, POA5.2, POA5.3, POA5.4
PIT-ATTR-PREFIX
ATTR_PREFIX		Alpha 2—POA5.1, POA5.2, POA5.3, POA5.4

Indexes (2)

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

IndexKeysFlagsConditionUsed in
PITSET1DIMENSION-NAME, ATTRIBUTE-NAMEPrimaryPOA1.1, POA10, POA3.1
PITSET2DIMENSION-NAME, ATTR-LAWSON-NMIAVO.1, POA2.1, POA2.2, POA2.3, POA2.4, POA5.1, POA5.2, POA5.3 +4 more

Programs

Updated by (8)

Referenced by (7)