STD_TEXT |
Default Table Name | STD_TEXT |
Definition |
STD_TEXT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
TEXT_CD![]() |
VARCHAR2(10) | NO | ||
TEXT_DESC | VARCHAR2(30) | NO | ||
TEXT_TX | CLOB | YES | ||
S_HOW_USED_CD | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID | VARCHAR2(10) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
PRINT_BOLD_FL | VARCHAR2(1) | NO |
STD_TEXT Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0126 | PrimaryKey | TEXT_CD |
STD_TEXT Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
ITEM_TEXT | Identifying | One To Zero or More | F01670 | NO | NO | NO | |||
PO_LN_TEXT | Identifying | One To Zero or More | F03360 | NO | NO | NO | |||
TEXT_WHERE_USED | Identifying | One To Zero or More | F04730 | NO | NO | NO | |||
PROJ_TEXT | Identifying | One To Zero or More | F07067 | NO | NO | NO | |||
ITEM_PROJ_TEXT | Identifying | One To Zero or More | F08229 | NO | NO | NO | |||
RQ_HDR_TEXT | Identifying | One To Zero or More | F09457 | NO | NO | NO | |||
RQ_LN_TEXT | Identifying | One To Zero or More | F09477 | NO | NO | NO | |||
PO_SETUP_TEXT | Identifying | One To Zero or More | F09564 | NO | NO | NO | |||
RFQ_HDR_TEXT | Identifying | One To Zero or More | F09725 | NO | NO | NO | |||
RFQ_LN_TEXT | Identifying | One To Zero or More | F09745 | NO | NO | NO | |||
SO_TEXT | Identifying | One To Zero or More | F10086 | NO | NO | NO | |||
SO_LN_TEXT | Identifying | One To Zero or More | F10088 | NO | NO | NO | |||
SHIP_TRN_TEXT | Identifying | One To Zero or More | F10146 | NO | NO | NO | |||
SO_INVC_TEXT | Identifying | One To Zero or More | F10165 | NO | NO | NO | |||
SO_INVC_LN_TEXT | Identifying | One To Zero or More | F10167 | NO | NO | NO | |||
MFG_BOM_TEXT | Non-Identifying | One To Zero or More | F10182 | NO | NO | NO | |||
OPERATION_TEXT | Identifying | One To Zero or More | F20720 | NO | NO | NO | |||
ROUTING_LN_TEXT | Identifying | One To Zero or More | F20740 | NO | NO | NO | |||
MO_HDR_TEXT | Identifying | One To Zero or More | F20825 | NO | NO | NO | |||
ECN_TEXT | Identifying | One To Zero or More | F21082 | NO | NO | NO | |||
DOCUMENT_TEXT | Identifying | One To Zero or More | F21085 | NO | NO | NO | |||
PROV_PART_TEXT | Identifying | One To Zero or More | F21477 | NO | NO | NO | |||
ENG_BOM_TEXT | Non-Identifying | Zero or One to Zero or More | F21482 | NO | NO | NO |