POIAORGDIM – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PI3
Primary key
ORG-DIMENSION
Fields
13
Updated by
2 programs
Referenced by
5 programs

POIAORGDIM is a Lawson Purchase Order table (prefix PI3); no description in the lawson data dictionary. It is indexed by ORG-DIMENSION (PI3SET1). It is updated by POA2.4 and POAO.1 and referenced by POA1.1, POA10, POA3.1, POA5.2 and POAX.1. The table has 13 fields, 1 index and 0 documented relations.

About POIAORGDIM

No description in the Lawson data dictionary.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
PI3-ORG-DIMENSION PK
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.POA2.4
PI3-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.4
PI3-COMPANY
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.POA2.4
PI3-PROCURE-GROUP
PROCURE_GROUP		Alpha 4Type or select a procurement group. A procurement group is a group of companies that share a common procurement effort. They buy items and services together.POA2.4
PI3-ALL-LOCATIONS
ALL_LOCATIONS		Alpha 1—
  • Y Yes
  • N No
POA2.4
PI3-LOCATION
LOCATION		Alpha 5 Occurs 12 Times ×12This field contains a valid stocking location within the company inventory.POA2.4
PI3-LOC-COMPANY
LOC_COMPANY		Numeric 4 Occurs 12 Times ×12—POA2.4
PI3-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.4
PI3-OUTLINE-FILE
OUTLINE_FILE		Alpha 100 (Lower Case)—POAO.1
PI3-LAST-MAINT-DT
LAST_MAINT_DT		Numeric 8 (yyyymmdd)This is the last date the Member was imported to the budget.POA2.4
PI3-LAST-IAMNT-TM
LAST_IAMNT_TM		Numeric 8—POA2.4
PI3-LAST-LOAD-DT
LAST_LOAD_DT		Numeric 8 (yyyymmdd)—POAO.1
PI3-LAST-IALOAD-TM
LAST_IALOAD_TM		Numeric 8—POAO.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
PI3SET1ORG-DIMENSIONPrimaryPOA1.1, POA10, POA2.4, POA3.1, POA5.2, POAO.1, POAX.1

Programs

Updated by (2)

Referenced by (5)