|
|
SAIACUSDIM FILE
REFERENCED BY
SALD.1
UPDATED BY
SACU.1 SADM.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SA5-CUSTOMER-DIM Alpha 50 (Lower Case) SADM.7
Element: Customer Dim
SA5-MEMBER-PREFIX Alpha 5 (Lower Case) SADM.7
Element: Member Prefix The Member Prefix field contains a
unique prefix to differentiate the
dimension name from other like-named
dimensions. This user-defined name can
contain up to five characters of any
kind.
SA5-SELECT-LVL Alpha 1 SADM.7
Element: Select Lvl 1 = All Customer's within Co group
2 = Customer range within Company
3 = Customer Code range within Co.
4
5
SA5-COMPANY-GROUP Alpha 12 SADM.7
Element: Company Group You can type or select a company group.
A company group represents one or more
companies.
If you select a company group, leave
the Company field blank.
SA5-COMPANY Numeric 4 SADM.7
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.
SA5-CUST-GROUP Alpha 5
Element: Customer GroupCustomer group. Used to identify a
group of customer associated with one or
more companies.
SA5-FR-CUSTOMER Alpha 9 (Right Justified) SADM.7
Element: Fr Customer This is the Beginning Customer range
selection for your datamart.
SA5-TO-CUSTOMER Alpha 9 (Right Justified) SACU.1 SADM.7
Element: To Customer This is the ending Customer range for SALD.1
your datamart.
SA5-FR-CUST-CODE Alpha 4 SADM.7
Element: Fr Cust Code
SA5-TO-CUST-CODE Alpha 4 SACU.1 SADM.7
Element: To Cust Code SALD.1
SA5-LAST-MAINT-DT Numeric 8 (yyyymmdd) SADM.7
Last Maintenance This is the last date the Member was
Date imported to the budget.
SA5-LAST-MAINT-TM Numeric 6 (hhmmss) SADM.7
Element: Sys Time This is the last time the member was
imported to the budget.
SA5-LAST-LOAD-DT Numeric 8 (yyyymmdd) SACU.1
Element: Last Load Dt
SA5-LAST-LOAD-TM Numeric 6 (hhmmss) SACU.1
Element: Last Load Tm
SAIACUSDIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SA5SET1 CUSTOMER-DIM SACU.1 SADM.1
SADM.7 SALD.1
|
