|
|
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
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)
Element: Name Displays the company description.
SAC-CURR-YEAR Numeric 4
Element: Year Current Sales Analysis year.
SAC-NBR-PERIODS Numeric 2
Element: Nbr Periods Number of periods in the Sales Analysis
year.
12
13
52
53
SAC-CURR-PERIOD Numeric 2
Element: Curr Period Current period in Sales Analysis year.
SAC-DISC-INCLD-FL Alpha 1
Element: All Flag 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
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
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
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
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
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
|
