SACOMPANY FILE
Sales Analysis Company
The Sales Analysis Company file includes parameters for sales analysis at the
company level.
REFERENCED BY
BL320
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAC-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
SAC-NAME Alpha 30 (Lower Case)
Name Displays the company description.
SAC-CURR-YEAR Numeric 4
Current Year Current Sales Analysis year.
SAC-NBR-PERIODS Numeric 2
Number of Periods Number of periods in the Sales Analysis
year.
12
13
52
53
SAC-CURR-PERIOD Numeric 2
Current Period Current period in Sales Analysis year.
SAC-DISC-INCLD-FL Alpha 1
Disc Incld Fl Discount include flag. Setting this
flag to Yes instructs Sales Analysis
inquiries and reports to display and/or
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
Comp Fl 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
Performance Fl 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
Reason Code Fl 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
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
Last Year Last year. Derived field.
SAC-LAST-PER Derived
Last Per Last period, if period is not the first
in the year. Derived field.
SAC-LAST-PERIOD Derived
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
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
|