POIAPRDDIM FILE
REFERENCED BY
POA1.1 POA3.1 POA5.1 POA5.2 POA5.3 POA5.4
UPDATED BY
POA2.3 POA2.5 POAP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PI2-PROD-DIMENSION Alpha 50 (Lower Case) POA2.3
Prod Dimension
PI2-MEMBER-PREFIX Alpha 5 (Lower Case) POA2.3
Member Prefix
PI2-ITEM-ALIAS Alpha 1 POA2.3
Item Alias I = Item Name
N = Item Number
PI2-ALL-ITEMS Alpha 1 POA2.3
All Items Y = Yes
N = No
PI2-ITEM-GROUP Alpha 5 POA2.3
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
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
Major Class
PI2-MINOR-CLASS Alpha 4 POA2.3
Minor Class
PI2-END-MAJOR-CLS Alpha 4 POA2.3
End Major Cls
PI2-END-MINOR-CLS Alpha 4 POA2.3
End Minor Cls
PI2-MANUF-CODE Alpha 4 POA2.3
Manufacturer's Code This 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
End Manuf Code
PI2-END-MANUF-DIV Alpha 4 POA2.3
End Manuf Div
PI2-INCL-SPECIAL Alpha 1 POA2.3
Incl Special Y = Yes
N = No
PI2-INCL-INVOICE Alpha 1 POA2.3 POA2.5
Incl Invoice
PI2-NBR-OF-ITEMS Numeric 7
Nbr Of Items
PI2-ITEMS-LOADED Numeric 7
Items Loaded
PI2-OUTLINE-FILE Alpha 100 (Lower Case) POAP.1
Outline File
PI2-LAST-MAINT-DT Numeric 8 (yyyymmdd) POA2.3 POA2.5
Last Maintenance This is the last date the Member was
Date imported to the budget.
PI2-LAST-IAMNT-TM Numeric 8 POA2.3 POA2.5
Last Iamnt Tm
PI2-LAST-LOAD-DT Numeric 8 (yyyymmdd) POAP.1
Last Load Dt
PI2-LAST-IALOAD-TM Numeric 8 POAP.1
Last Iaload Tm
POIAPRDDIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PI2SET1 PROD-DIMENSION POA1.1 POA2.3
POA2.5 POA3.1
POA5.1 POA5.2
POA5.3 POA5.4
POAP.1
|
