POIAPRDDIM – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PI2
Primary key
PROD-DIMENSION
Fields
24
Updated by
2 programs
Referenced by
4 programs

POIAPRDDIM is a Lawson Purchase Order table (prefix PI2); no description in the lawson data dictionary. It is indexed by PROD-DIMENSION (PI2SET1). It is updated by POA2.3 and POAP.1 and referenced by POA1.1, POA10, POA3.1 and POA5.3. The table has 24 fields, 1 index and 0 documented relations.

About POIAPRDDIM

No description in the Lawson data dictionary.

Fields (24)

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

Field / columnTypeDescription & valuesUpdated by
PI2-PROD-DIMENSION PK
PROD_DIMENSION		Alpha 50 (Lower Case)—POA2.3
PI2-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.3
PI2-ITEM-ALIAS
ITEM_ALIAS		Alpha 1—
  • I Item Name
  • N Item Number
POA2.3
PI2-ALL-ITEMS
ALL_ITEMS		Alpha 1—
  • Y Yes
  • N No
POA2.3
PI2-ITEM-GROUP
ITEM_GROUP		Alpha 5This field contains the identifier for a group of items that can be shared by one or more companies.POA2.3
PI2-CLASS-TYPE
CLASS_TYPE		Alpha 1This field contains the class type, which identifies the group of classes. " " = No Class Type Specified
  • I Inventory Class
  • P Purchasing Class
  • S Sales Class
POA2.3
PI2-MAJOR-CLASS
MAJOR_CLASS		Alpha 4—POA2.3
PI2-MINOR-CLASS
MINOR_CLASS		Alpha 4—POA2.3
PI2-END-MAJOR-CLS
END_MAJOR_CLS		Alpha 4—POA2.3, POAP.1
PI2-END-MINOR-CLS
END_MINOR_CLS		Alpha 4—POA2.3, POAP.1
PI2-MANUF-CODE
MANUF_CODE		Alpha 4This field contains a user defined code that indicates the manufacturer of an item.POA2.3
PI2-MANUF-DIVISION
MANUF_DIVISION		Alpha 4This is a user defined code that indicates which division of a manufacturer is tied to an item.POA2.3
PI2-END-MANUF-CODE
END_MANUF_CODE		Alpha 4—POA2.3
PI2-END-MANUF-DIV
END_MANUF_DIV		Alpha 4—POA2.3
PI2-INCL-SPECIAL
INCL_SPECIAL		Alpha 1—
  • Y Yes
  • N No
POA2.3
PI2-INCL-INVOICE
INCL_INVOICE		Alpha 1—POA2.3
PI2-NBR-OF-ITEMS
NBR_OF_ITEMS		Numeric 7——
PI2-ITEMS-LOADED
ITEMS_LOADED		Numeric 7——
PI2-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.3
PI2-OUTLINE-FILE
OUTLINE_FILE		Alpha 100 (Lower Case)—POAP.1
PI2-LAST-MAINT-DT
LAST_MAINT_DT		Numeric 8 (yyyymmdd)This is the last date the Member was imported to the budget.POA2.3
PI2-LAST-IAMNT-TM
LAST_IAMNT_TM		Numeric 8—POA2.3
PI2-LAST-LOAD-DT
LAST_LOAD_DT		Numeric 8 (yyyymmdd)—POAP.1
PI2-LAST-IALOAD-TM
LAST_IALOAD_TM		Numeric 8—POAP.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
PI2SET1PROD-DIMENSIONPrimaryPOA1.1, POA10, POA2.3, POA3.1, POA5.3, POAP.1

Programs

Updated by (2)

Referenced by (4)