Table Name:bus_org_extern
Table Number:5703
Group:Billing Manager
Description:This table stores foreign key mapping between bus_org and external system
Flags: 
Baseline/Custom:Baseline
select * from table_bus_org_extern
Keyboard shortcuts available
Fields:

(double-click a column header to select column text)

Field Name
Common Type
Database Type
Generic Field ID
Array Size
Default
Flags
Comment
Field Used in Views
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
ext_refCHARvarchar 64 ALLOW_NULL The identifier of the customer from the external system Search (6)
ext_srcCHARvarchar 30  The name of the system that manages the customer Search (2)
last_updateCLK_TIMEdatetime   CHANGE_DATE Date time of last update  
objidLONGint3  DIRECT Internal record number Search (6)
Relations:
Relation
Type
Target Object
Inverse Relation
Comment
Flags
MTM Table
Used in Views
bus_org_extern2bus_orgMTObus_orgbus_org2bus_org_externBus_org related to the external system   Search (6)
Indexes: (Defined in Clarify Schema)
Index Name
Fields
Flags
I5703ext_ref:ext_srcUNIQUE 
Indexes (Defined in Database):
Index Name
Fields
Additional Information
boe2bo5703bus_org_extern2bus_orgnonclustered located on PRIMARY
I5703ext_ref, ext_srcnonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
My Recent Objects
bus_org_extern      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user