POIACAL FILE
REFERENCED BY
POA1.1 POA3.1
UPDATED BY
POA4.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIC-APPLIC-TYPE Alpha 3 POA4.1
Application Type The Application Type file stores the
names of the Lawson applications that
can be requested to supply information
to the OLAP database. The Lawson
applications that are currently
OLAP-ready are:
FIN = Financial Analyzer
FND = Daily Financial Analyzer
SA = Sales Analyzer
CX = Case Cart Analyzer
PO = Purchasing Analyzer
WO = Work Order Analyzer
PIC-DATA-MART-NAME Alpha 20 (Lower Case) POA4.1
Data Mart Name
PIC-YEAR Numeric 4 POA4.1
Last Closed Year Contains the fiscal year for the data
stored on this record.
PIC-BEG-DATE Numeric 8 (yyyymmdd) POA4.1
Beginning Date The beginning date in a range of dates.
PIC-END-DATE Numeric 8 (yyyymmdd) POA4.1
Ending Date The ending date in a range of dates.
PIC-NBR-OF-PERIODS Numeric 3 POA4.1
Nbr Of Periods
PIC-PERIOD Numeric 2 Occurs 53 Times
Last Closed Period This is the current accounting period.
This field is updated by Period Closing
(GL199).
PIC-PER-END-DATE Numeric 8 (yyyymmdd) Occurs 53 Times POA4.1
Period End Date The period end date of the specified
year.
POIACAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PICSET1 APPLIC-TYPE POA1.1 POA3.1
DATA-MART-NAME POA4.1
YEAR
|
