POIACAL FILE
REFERENCED BY
POA1.1 POA10 POA3.1
UPDATED BY
POA4.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIC-APPLIC-TYPE Alpha 3 POA4.1
Element: Application TyThe 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
Element: Data Mart Name
PIC-YEAR Numeric 4 POA4.1
Element: Last Closed YeContains the fiscal year for the data
stored on this record.
PIC-BEG-DATE Numeric 8 (yyyymmdd) POA4.1
Element: Date
PIC-END-DATE Numeric 8 (yyyymmdd) POA4.1
Element: Date The ending date in a range of dates.
PIC-NBR-OF-PERIODS Numeric 3 POA4.1
Element: Nbr Of Periods
PIC-PERIOD Numeric 2 Occurs 53 Times
Element: Current PeriodThis 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
Element: Date
POIACAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PICSET1 APPLIC-TYPE POA1.1 POA10
DATA-MART-NAME POA3.1 POA4.1
YEAR
|
