ROSS: Customer Codes

Created by Kathy Kale, Modified on Wed, 19 Mar at 3:45 PM by Kathy Kale

Customers table status/termination

SCC_CUST_TERMINATION_CODE
- Values: T,""
- Purpose: reliable flag for Customer that is terminated.
  - "T" terminated customers
  - CUSTOMER_NAME starts: [TERM]
  - SCC_CUSTOMER_TERM_DATE is filled
SCC_CUSTOMER_TERM_DATE
- Purpose: reliable field with the date for the customer termination
- occasionally need to sort on this field and make sure any dates are also fully terminated
CUSTOMER_NAME
- Values: [TERM] added to the name to show it is intentionally terminated.
SALES_ORDERS_FLAG
- Values: Y/N
- Purpose: reliable flag for allowed to order
  - Terminated customers are always marked as SALES_ORDERS_FLAG = "N"
  - some non-terminated customers are also marked as SALES_ORDERS_FLAG ="N"
    - Stock transfer points - not allowed to place orders
    - RM transfer points - these are stock transfer points specific to the RM (no location)
    - Corporate accounts - also not allowed to place orders
      - they may have credits

ACTIVATION_STATUS
- Values: A,D,E,I
- Purpose: UNRELIABLE; Ross field if customer is activated
- Recommendation: force to "A" for all customers with SCC_CUST_TERMINATION_CODE <> "T" every night.
STATUS_FLAG
- Values: "*" ""
- Purpose: unknown Ross field
SCC_CUSTOMER_TERM_CODE
- Values: "",S,T
- Purpose: UNRELIABLE; corrupted field with "S" values "T" is terminated customers
  - NOT maintained when a customer is terminated in the SCC_CUSTOMER_MAINTENANCE
  - was supposed to replace SCC_CUST_TERMINATION_CODE to match naming convention with date

Customers table Codes/Groupings

SCC_CUSTOMER_APPT_DATE
- Purpose: official appointment date of new customer ( not always the creation date)

[STATEMENT_ACCOUNT]

,[SCC_CORPORATE_REPORTING_GROUP]

,[SCC_SALES_REPORT_GROUP]

,[CUSTOMER_NUMBER]

,[CUSTOMER_NAME]

,[DEFAULT_ADDR]

,[DEFAULT_DELIVERY_ADDR_CODE]

ACCEPT_ZERO_PRICE