POIAMEADIM – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PI5
Primary key
MEAS-DIMENSION
Fields
48
Updated by
2 programs
Referenced by
3 programs

POIAMEADIM is a Lawson Purchase Order table (prefix PI5); no description in the lawson data dictionary. It is indexed by MEAS-DIMENSION (PI5SET1). It is updated by POA2.5 and POAM.1 and referenced by POA1.1, POA10 and POA3.1. The table has 48 fields, 1 index and 0 documented relations.

About POIAMEADIM

No description in the Lawson data dictionary.

Fields (48)

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

Field / columnTypeDescription & valuesUpdated by
PI5-MEAS-DIMENSION PK
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.POA2.5
PI5-MEMBER-PREFIX
MEMBER_PREFIX
Alpha 5 (Lower Case)The Member Prefix field contains a unique prefix to differentiate the dimension name from other like-named dimensions. This user-defined name can contain up to five characters of any kind.POA2.5
PI5-PFT-MTCH-MBR
PFT_MTCH_MBR
Alpha 50 (Lower Case)POA2.5
PI5-PFT-MTCH-FL
PFT_MTCH_FL
Alpha 1" " = Do Not Select
  • X Select
POA2.5
PI5-MTCH-INVC-MBR
MTCH_INVC_MBR
Alpha 50 (Lower Case)POA2.5
PI5-MTCH-INVC-FLG
MTCH_INVC_FLG
Alpha 1POA2.5
PI5-MTCH-LNES-MBR
MTCH_LNES_MBR
Alpha 50 (Lower Case)POA2.5
PI5-MTCH-LNES-FLG
MTCH_LNES_FLG
Alpha 1" " = Do Not Select
  • X Select
POA2.5
PI5-CON-EL-LNES-MB
CON_EL_LNES_MB
Alpha 50 (Lower Case)POA2.5
PI5-CON-EL-LNES-FL
CON_EL_LNES_FL
Alpha 1" " = Do Not Select
  • X Select
POA2.5
PI5-CON-LNES-MBR
CON_LNES_MBR
Alpha 50 (Lower Case)POA2.5
PI5-CON-LNES-FLG
CON_LNES_FLG
Alpha 1" " = Do Not Select
  • X Select
POA2.5
PI5-PO-LNES-MBR
PO_LNES_MBR
Alpha 50 (Lower Case)POA2.5
PI5-PO-LNES-FLG
PO_LNES_FLG
Alpha 1" " = Do Not Select
  • X Select
POA2.5
PI5-RCVD-LINES-MBR
RCVD_LINES_MBR
Alpha 50 (Lower Case)POA2.5
PI5-RCVD-LINES-FLG
RCVD_LINES_FLG
Alpha 1POA2.5
PI5-FT-RCV-LNES-MB
FT_RCV_LNES_MB
Alpha 50 (Lower Case)POA2.5
PI5-FT-REC-LNES-FL
FT_REC_LNES_FL
Alpha 1" " = Do Not Select
  • X Select
POA2.5
PI5-MTCH-CST-LN-MB
MTCH_CST_LN_MB
Alpha 50 (Lower Case)POA2.5
PI5-MTCH-CST-LN-FL
MTCH_CST_LN_FL
Alpha 1" " = Do Not Select
  • X Select
POA2.5
PI5-OT-RCV-LNE-MBR
OT_RCV_LNE_MBR
Alpha 50 (Lower Case)POA2.5
PI5-OT-RCV-LNE-FLG
OT_RCV_LNE_FLG
Alpha 1" " = Do Not Select
  • X Select
POA2.5
PI5-EL-RCV-LNE-MBR
EL_RCV_LNE_MBR
Alpha 50 (Lower Case)POA2.5
PI5-EL-REC-LNE-FLG
EL_REC_LNE_FLG
Alpha 1POA2.5
PI5-LT-RCV-LNE-MBR
LT_RCV_LNE_MBR
Alpha 50 (Lower Case)POA2.5
PI5-LT-RCV-LNE-FLG
LT_RCV_LNE_FLG
Alpha 1POA2.5
PI5-PO-QTY-MBR
PO_QTY_MBR
Alpha 50 (Lower Case)POA2.5
PI5-PO-QTY-FLG
PO_QTY_FLG
Alpha 1" " = Do Not Select
  • X Select
POA2.5
PI5-RCVD-QTY-MBR
RCVD_QTY_MBR
Alpha 50 (Lower Case)POA2.5
PI5-RCVD-QTY-FLG
RCVD_QTY_FLG
Alpha 1" " = Do Not Select
  • X Select
POA2.5
PI5-REJ-QTY-MBR
REJ_QTY_MBR
Alpha 50 (Lower Case)POA2.5
PI5-REJ-QTY-FLG
REJ_QTY_FLG
Alpha 1" " = Do Not Select
  • X Select
POA2.5
PI5-EXTD-COST-MBR
EXTD_COST_MBR
Alpha 50 (Lower Case)POA2.5
PI5-EXTD-COST-FLG
EXTD_COST_FLG
Alpha 1" " = Do Not Select
  • X Select
POA2.5
PI5-AVG-CYC-TM-MBR
AVG_CYC_TM_MBR
Alpha 50 (Lower Case)
PI5-AVG-CYC-TM-FLG
AVG_CYC_TM_FLG
Alpha 1
PI5-TOT-CYC-TM-MBR
TOT_CYC_TM_MBR
Alpha 50 (Lower Case)POA2.5
PI5-TOT-CYC-TM-FLG
TOT_CYC_TM_FLG
Alpha 1POA2.5
PI5-EDI-PO-LNE-MBR
EDI_PO_LNE_MBR
Alpha 50 (Lower Case)POA2.5
PI5-EDI-PO-LNE-FLG
EDI_PO_LNE_FLG
Alpha 1POA2.5
PI5-EDI-INVC-MBR
EDI_INVC_MBR
Alpha 50 (Lower Case)POA2.5
PI5-EDI-INVC-FLG
EDI_INVC_FLG
Alpha 1POA2.5
PI5-TOTAL-INVC-MBR
TOTAL_INVC_MBR
Alpha 50 (Lower Case)POA2.5
PI5-TOTAL-INVC-FLG
TOTAL_INVC_FLG
Alpha 1POA2.5
PI5-LAST-MAINT-DT
LAST_MAINT_DT
Numeric 8 (yyyymmdd)This is the last date the Member was imported to the budget.POA2.5
PI5-LAST-IAMNT-TM
LAST_IAMNT_TM
Numeric 8POA2.5
PI5-LAST-LOAD-DT
LAST_LOAD_DT
Numeric 8 (yyyymmdd)POAM.1
PI5-LAST-IALOAD-TM
LAST_IALOAD_TM
Numeric 8POAM.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
PI5SET1MEAS-DIMENSIONPrimaryPOA1.1, POA10, POA2.5, POA3.1, POAM.1

Programs

Updated by (2)

Referenced by (3)