Previous Topic: Global_Location TableNext Topic: Global_Product Table


Global_Organization Table

Contains all Organizations names for all regions.

Field

Data Type

Reference

Remarks

del

INTEGER NOT_NULL

Active_Boolean_ Table::enum

Deleted flag

0—Active

1—Inactive/marked as deleted

id

INTEGER UNIQUE NOT_NULL KEY

 

Unique (to the table) Numeric ID

last_mod_dt

LOCAL_TIME

 

Indicates the timestamp of when this record was last modified.

org_name

STRING 100

 

Organization Name

remote_id

UUID NOT_NULL S_KEY

 

Regional organization id

remote_sys_id

INTEGER NOT_NULL S_KEY

Global_Servers:: remote_sys_id

Regional system id