POIAVNDDIM – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PI1
Primary key
VEND-DIMENSION
Fields
15
Updated by
2 programs
Referenced by
4 programs

POIAVNDDIM is a Lawson Purchase Order table (prefix PI1); no description in the lawson data dictionary. It is indexed by VEND-DIMENSION (PI1SET1). It is updated by IAVO.1 and POA2.1 and referenced by POA1.1, POA10, POA3.1 and POA5.1. The table has 15 fields, 1 index and 0 documented relations.

About POIAVNDDIM

No description in the Lawson data dictionary.

Fields (15)

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

Field / columnTypeDescription & valuesUpdated by
PI1-VEND-DIMENSION PK
VEND_DIMENSION		Alpha 50 (Lower Case)—POA2.1
PI1-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.1
PI1-ALL-VENDORS
ALL_VENDORS		Alpha 1—
  • Y Include All Vendors
  • N Do Not Include All Vendors
POA2.1
PI1-VENDOR-GROUP
VENDOR_GROUP		Alpha 4A vendor group represents a group of vendors that can be shared by one or more companies.POA2.1
PI1-VEN-CLASS
VEN_CLASS		Alpha 3 Occurs 10 Times ×10A user-defined code representing a subset of vendors within a vendor group.POA2.1
PI1-INCLUDE-ONE-TM
INCLUDE_ONE_TM		Alpha 1—
  • Y Include One Time
  • N Do Not Include One Time
—
PI1-NBR-OF-VENDORS
NBR_OF_VENDORS		Numeric 7——
PI1-NBR-VEDORS-LOD
NBR_VEDORS_LOD		Numeric 7——
PI1-USE-CONTR-SW
USE_CONTR_SW		Alpha 1—
  • Y Yes
  • N No
POA2.1
PI1-MATRIX-VIEW
MATRIX_VIEW		Alpha 12The Attribute View field contains the accounting unit view being used for alternate roll-ups. Any posting accounting units listed in a view that is used for alternate roll-ups must also be included in one of the company, accounting, or company groups.POA2.1
PI1-OUTLINE-FILE
OUTLINE_FILE		Alpha 100 (Lower Case)—IAVO.1
PI1-LAST-MAINT-DT
LAST_MAINT_DT		Numeric 8 (yyyymmdd)This is the last date the Member was imported to the budget.POA2.1
PI1-LAST-IAMNT-TM
LAST_IAMNT_TM		Numeric 8—POA2.1
PI1-LAST-LOAD-DT
LAST_LOAD_DT		Numeric 8 (yyyymmdd)—IAVO.1
PI1-LAST-IALOAD-TM
LAST_IALOAD_TM		Numeric 8—IAVO.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
PI1SET1VEND-DIMENSIONPrimaryIAVO.1, POA1.1, POA10, POA2.1, POA3.1, POA5.1

Programs

Updated by (2)

Referenced by (4)