data-dictionary
data-dictionary
Breadcrumbs

FPSBASE.GEN_CUSTOMERS

Data Dictionary

>

FPSBASE Tables

> FPSBASE.GEN_CUSTOMERS

Table FPSBASE.GEN_CUSTOMERS"

List of all customers. For startup, this table can just be populated with one generic customer for all planprds.

  • Schema: FPSBASE

  • Tablespace: FPSDATA

  • Primary key: CUSTOMER

  • Foreign keys: GEN_CUSTOMERS_FK_BG_COLOR: BG_COLOR REFERENCES FPSADMIN.GEN_COLORS (COLOR)

  • Referenced by: FPSINPUT.RTG_PLANPRDS (CUSTOMER)


Column

Type

Nullable

Comment

CUSTOMER

VARCHAR2(64)

N

Customer who will accept shipment of the lot. Currently this only used for grouping and filtering but in the future we might want to allow a customer to view a Dashboard only including their products.

BG_COLOR

VARCHAR2(24)

Background color assigned. BG_COLOR is in English like red or blue or light green and we look up the HTML color like #FF0000 in the GEN_COLORS table. BG_COLOR must be set manually but the FPSADMIN view BLD_POPULATE_COLORS will generate queries to randomly set bg_color for all values in a table.