POIADIM – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
POI
Primary key
DATA-MART-NAME
Fields
23
Updated by
2 programs
Referenced by
2 programs

POIADIM is a Lawson Purchase Order table (prefix POI); no description in the lawson data dictionary. It is indexed by DATA-MART-NAME (POISET1). It is updated by POA1.1 and POA3.1 and referenced by POA10 and POAX.1. The table has 23 fields, 1 index and 0 documented relations.

About POIADIM

No description in the Lawson data dictionary.

Fields (23)

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

Field / columnTypeDescription & valuesUpdated by
POI-DATA-MART-NAME PK
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.POA1.1
POI-VEND-DIMENSION
VEND_DIMENSION		Alpha 50 (Lower Case)—POA1.1
POI-PROD-DIMENSION
PROD_DIMENSION		Alpha 50 (Lower Case)—POA1.1
POI-ORG-DIMENSION
ORG_DIMENSION		Alpha 50 (Lower Case)The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind.POA1.1
POI-BUYR-DIMENSION
BUYR_DIMENSION		Alpha 50 (Lower Case)—POA1.1
POI-TIME-DIMENSION
TIME_DIMENSION		Alpha 50 (Lower Case)The Time Dimension Name field contains the user-defined name of the Time dimension. This name can contain up to 30 characters of any kind.POA1.1
POI-MEAS-DIMENSION
MEAS_DIMENSION		Alpha 50 (Lower Case)The Measures Dimension Name field contains the user-defined name for the Measures dimension. This name can contain up to 30 characters of any kind.POA1.1
POI-YEAR-DIMENSION
YEAR_DIMENSION		Alpha 50 (Lower Case)—POA1.1
POI-CAL-NAME
CAL_NAME		Alpha 20—POA1.1
POI-STATUS
STATUS		Numeric 1This field displays the status of the transaction.POA1.1
POI-DATA-LOAD-OPT
DATA_LOAD_OPT		Alpha 1The Data Values Load Option field specifies how the data values are loaded into the data mart. Value values are: " " = None Specified
  • N No Load
  • I Incremental
  • C Complete; Default value.
  • P Partial
POA1.1
POI-DATALD-BEG-PER
DATALD_BEG_PER		Numeric 2—POA1.1
POI-DATALD-BEG-YR
DATALD_BEG_YR		Numeric 4—POA1.1
POI-DATALD-END-PER
DATALD_END_PER		Numeric 2—POA1.1
POI-DATALD-END-YR
DATALD_END_YR		Numeric 4—POA1.1
POI-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)The date last changed.—
POI-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)——
POI-PHASE-RECORDS
PHASE_RECORDS		Signed 13.0 Occurs 9 Times ×9—POA3.1
POI-PHASE-MINUTES
PHASE_MINUTES		Signed 11.0 Occurs 9 Times ×9——
POI-PHASE-SECONDS
PHASE_SECONDS		Signed 2.0 Occurs 9 Times ×9—POA3.1
POI-TOTAL-RECORDS
TOTAL_RECORDS		Signed 11.0—POA3.1
POI-TOTAL-MINUTES
TOTAL_MINUTES		Signed 11.0——
POI-TOTAL-SECONDS
TOTAL_SECONDS		Signed 2.0—POA3.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
POISET1DATA-MART-NAMEPrimaryPOA1.1, POA10, POA3.1, POAX.1

Programs

Updated by (2)

Referenced by (2)