|
|
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 SA990 SA991 SAA1.1
SAA2.1
UPDATED BY
SA00.1 SA100 SA110 SA992
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAC-COMPANY Numeric 4 SA00.1
Company The company number represents an
established company and is entered on
all function codes.
SAC-NAME Alpha 30 (Lower Case) SA00.1
Name Contains the company description.
SAC-CURR-YEAR Numeric 4 SA00.1 SA100
Current Year Current Sales Analysis year.
SAC-NBR-PERIODS Numeric 2 SA00.1
Number of Periods Number of periods in the Sales Analysis
year.
12
13
52
53
SAC-CURR-PERIOD Numeric 2 SA00.1 SA100
Current Period Current period in Sales Analysis year.
SAC-DISC-INCLD-FL Alpha 1 SA00.1 SA260
Discount Included Discount include flag. Setting this SA270 SA280
Flag flag to Yes instructs Sales Analysis SA290 SA80.1
inquiries and reports to display and/or SA90.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
Compensation Flag Company factor summarization option. SA992
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
Performance Flag Performance file creation option. SA992
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
Reason Code Flag Reason code option. Setting this flag SA992
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
Override Address Override address option. Setting this
Flag flag to Yes will cause storing an
override address for orders in the Sales
Analysis system.
Y = Yes
N = No
SAC-LAST-YEAR Derived
Last Year Last year. Derived field.
SAC-LAST-PER Derived
Last Period Last period, if period is not the first
in the year. Derived field.
SAC-LAST-PERIOD Derived
Prior 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
|