|
SACOMPANY FILE
Sales Analysis Company
The Sales Analysis Company file includes parameters for sales analysis at the
company level.
REFERENCED BY
BL320 OE310 OE330 SA01.1 SA02.1 SA02.2
SA03.1 SA03.2 SA04.1 SA04.2 SA101 SA200
SA201 SA202 SA203 SA204 SA250 SA251
SA252 SA253 SA254 SA255 SA256 SA257
SA258 SA260 SA261 SA262 SA270 SA271
SA272 SA280 SA281 SA282 SA290 SA291
SA292 SA300 SA310 SA80.1 SA80.2 SA80.3
SA90.1 SA90.2 SA90.3 SADM.2 SADM.5 SADM.6
SADM.7 SALD.1 SALO.1 SAOR.1
UPDATED BY
SA00.1 SA100 SA110
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAC-COMPANY Numeric 4 SA00.1
Element: Company Identifies 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.
SAC-NAME Alpha 30 (Lower Case) SA00.1
Element: Name Displays the company description.
SAC-CURR-YEAR Numeric 4 SA00.1 SA100
Element: Last Closed YeCurrent Sales Analysis year.
SAC-NBR-PERIODS Numeric 2 SA00.1
Element: Number of PeriNumber of periods in the Sales Analysis
year.
12
13
52
53
SAC-CURR-PERIOD Numeric 2 SA00.1 SA100
Element: Current PeriodCurrent period in Sales Analysis year.
SAC-DISC-INCLD-FL Alpha 1 SA00.1 SA260
Element: All Flag Discount include flag. Setting this SA270 SA280
flag to Yes instructs Sales Analysis SA290 SA80.1
inquiries and reports to display and/or SA90.1 SALD.1
print gross sales amounts. Setting it to
No instructs Sales Analysis inquiries
and reports to display and/or print net
sales amounts.
N = No
Y = Yes
SAC-COMP-FL Alpha 1 SA00.1 SA110
Element: All Flag Company factor summarization option.
Setting this to Yes will cause creation
of the company factor summary file.
Y = Yes
N = No
SAC-PERFORMANCE-FL Alpha 1 SA00.1 SA110
Element: All Flag Performance file creation option.
Setting this to Yes will cause creation
of the performance file used for
performance trend reporting.
Y = Yes
N = NO
SAC-REASON-CODE-FL Alpha 1 SA00.1 SA110
Element: All Flag Reason code option. Setting this flag
to Yes causes creation of the reason
code trend file used for reason code
trend reporting.
Y = Yes
N = No
SAC-OVR-ADDR-FL Alpha 1 SA00.1
Element: Ovr Addr Fl Override address option. Setting this
flag to Yes will cause storing an
override address for orders in the Sales
Analysis system.
Y = Yes
N = No
SAC-LAST-YEAR Derived
Element: Last Year Last year. Derived field.
SAC-LAST-PER Derived
Element: Last Per Last period, if period is not the first
in the year. Derived field.
SAC-LAST-PERIOD Derived
Element: Last Period Last period. Derived field. Either
one less than current period or last
period of last year.
SACOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SACSET1 COMPANY BL320 OE310
OE330 SA00.1
SA00.2 SA01.1
SA02.1 SA02.2
SA03.1 SA03.2
SA04.1 SA04.2
SA100 SA101
SA110 SA200
SA201 SA202
SA203 SA204
SA250 SA251
SA252 SA253
SA254 SA255
SA256 SA257
SA258 SA260
...
SACOMPANY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
SAC-COMPANY -> ICC-COMPANY
Oecompany OECOMPANY Required
SAC-COMPANY -> OEC-COMPANY
SACOMPANY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Saformat SAFORMAT Delete Restricted
SAC-COMPANY -> SAF-COMPANY
SAF-FORMAT-NAME
Sayear SAYEAR Delete Restricted
SAC-COMPANY -> SAY-COMPANY
SAY-YEAR
|