|
|
POIAPRDDIM FILE
REFERENCED BY
POA1.1 POA10 POA3.1 POA5.3 SADM.1 SALD.1
UPDATED BY
POA2.3 POAP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PI2-PROD-DIMENSION Alpha 50 (Lower Case) POA2.3
Element: Prod Dimension
PI2-MEMBER-PREFIX Alpha 5 (Lower Case) POA2.3
Element: Member Prefix 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.
PI2-ITEM-ALIAS Alpha 1 POA2.3
Element: Item Alias I = Item Name
N = Item Number
PI2-ALL-ITEMS Alpha 1 POA2.3
Element: All Items Y = Yes
N = No
PI2-ITEM-GROUP Alpha 5 POA2.3
Element: Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
PI2-CLASS-TYPE Alpha 1 POA2.3
Element: Class Type This field contains the class type,
which identifies the group of classes.
" " = No Class Type Specified
I = Inventory Class
P = Purchasing Class
S = Sales Class
PI2-MAJOR-CLASS Alpha 4 POA2.3
Element: Major Class
PI2-MINOR-CLASS Alpha 4 POA2.3
Element: Minor Class
PI2-END-MAJOR-CLS Alpha 4 POA2.3 SALD.1
Element: End Major Cls
PI2-END-MINOR-CLS Alpha 4 POA2.3 SALD.1
Element: End Minor Cls
PI2-MANUF-CODE Alpha 4 POA2.3
Element: Manufacturer'sThis field contains a user defined code
that indicates the manufacturer of an
item.
PI2-MANUF-DIVISION Alpha 4 POA2.3
Manufacturer's This is a user defined code that
Division indicates which division of a
manufacturer is tied to an item.
PI2-END-MANUF-CODE Alpha 4 POA2.3
Element: End Manuf Code
PI2-END-MANUF-DIV Alpha 4 POA2.3
Element: End Manuf Div
PI2-INCL-SPECIAL Alpha 1 POA2.3
Element: Incl Special Y = Yes
N = No
PI2-INCL-INVOICE Alpha 1 POA2.3
Element: Incl Invoice
PI2-NBR-OF-ITEMS Numeric 7
Element: Nbr Of Items
PI2-ITEMS-LOADED Numeric 7
Element: Items Loaded
PI2-MATRIX-VIEW Alpha 12 POA2.3
Element: Attribute ViewThe 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.
PI2-OUTLINE-FILE Alpha 100 (Lower Case) POAP.1
Element: Outline File
PI2-LAST-MAINT-DT Numeric 8 (yyyymmdd) POA2.3
Last Maintenance This is the last date the Member was
Date imported to the budget.
PI2-LAST-IAMNT-TM Numeric 8 POA2.3
Element: Last Iamnt Tm
PI2-LAST-LOAD-DT Numeric 8 (yyyymmdd) POAP.1
Element: Last Load Dt
PI2-LAST-IALOAD-TM Numeric 8 POAP.1
Element: Last Iaload Tm
POIAPRDDIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PI2SET1 PROD-DIMENSION POA1.1 POA10
POA2.3 POA3.1
POA5.3 POAP.1
SADM.1 SALD.1
|
