Data Dictionary - Technical Document Interface |
|||||
|
|
|||||
|
Table Name Tdi_DtdD_Doc_Typ_Def_Det |
|
||||
|
|
|||||
|
Table Comment This table holds the Document type Information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
DtdD_OuInstance |
numeric(10,0) |
NOT NULL |
Ouinstance |
Yes |
No |
|
DtdD_MfgrNo |
varchar(45) |
NOT NULL |
Manufacturer No |
Yes |
No |
|
DtdD_ModRefDocs |
varchar(15) |
NOT NULL |
Reference Documents |
Yes |
No |
|
DtdD_MfgrCrOuInstance |
numeric(10,0) |
NOT NULL |
Manufacturer OUinstance |
No |
No |
|
DtdD_DocTypDef |
varchar(150) |
NULL |
Document Type Definition |
No |
No |
|
DtdD_Addln_Info1 |
varchar(2000) |
NULL |
Additional information 1 |
No |
No |
|
DtdD_Addln_Info2 |
varchar(2000) |
NULL |
Additional information 2 |
No |
No |
|
DtdD_Addln_Info3 |
varchar(2000) |
NULL |
Additional Information 3 |
No |
No |
|
DtdD_Created_by |
varchar(30) |
NULL |
Created By |
No |
No |
|
DtdD_Createddate |
varchar(30) |
NULL |
Created Date |
No |
No |
|
DtdD_Modified_by |
varchar(30) |
NULL |
Modified by |
No |
No |
|
DtdD_Modifieddate |
char(18) |
NULL |
Modified Date |
No |
No |
|
DtdD_Timestamp |
numeric(10,0) |
NULL |
Timestamp |
No |
No |
|
DtdD_Serial_NO |
int |
NULL |
Serial No Information |
No |
No |
|
|
|||||
|
Table Name Tdi_Parameter_Details |
|
||||
|
|
|||||
|
Table Comment This table holds the Parameter detail information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
ComponentName |
varchar(80) |
NOT NULL |
Component Name |
No |
No |
|
ParamCategory |
varchar(10) |
NOT NULL |
Param Category |
No |
No |
|
ParamType |
varchar(25) |
NOT NULL |
Param Type |
No |
No |
|
ParamCode |
varchar(5) |
NOT NULL |
parameter Code |
No |
No |
|
ParamDesc |
varchar(80) |
NOT NULL |
Parameter Description |
No |
No |
|
Langid |
int |
NOT NULL |
Language ID |
No |
No |
|
CreationDate |
varchar(30) |
NULL |
Creation Date |
No |
No |
|
SortBy |
varchar(25) |
NULL |
Sort by |
No |
No |
|
|
|||||
|
Table Name Tdi_TdsD_Tech_Doc_Sys_Det |
|
||||
|
|
|||||
|
Table Comment This table holds the Technical Document Information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
TdsD_OuInstance |
varchar(20) |
NOT NULL |
Ounistance |
Yes |
No |
|
TdsD_Tds_MfgrNo |
varchar(45) |
NOT NULL |
Manufacturer No |
Yes |
No |
|
TdsD_Tds_Code |
varchar(30) |
NOT NULL |
Tds Code |
No |
No |
|
TdsD_MfgrCrOuInstance |
numeric(10,0) |
NULL |
Manufacturer Ouinstance |
No |
No |
|
TdsD_Created_by |
varchar(30) |
NULL |
Created by |
No |
No |
|
TdsD_Createddate |
varchar(30) |
NULL |
Created Date |
No |
No |
|
TdsD_Modified_by |
varchar(30) |
NULL |
Modified by |
No |
No |
|
TdsD_Modifieddate |
varchar(30) |
NULL |
Modified Date |
No |
No |
|
TdsD_Timestamp |
numeric(10,0) |
NULL |
Time Stamp |
No |
No |
|
TdsD_Serial_NO |
int |
NULL |
Serial No |
No |
No |
|
|
|||||
|
Table Name Tdi_TdsH_Tech_Doc_Sys_Hdr |
|
||||
|
|
|||||
|
Table Comment This is the document header Information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
TdsH_OuInstance |
numeric(10,0) |
NOT NULL |
Ouinstance |
Yes |
No |
|
TdsH_Tds_Code |
varchar(30) |
NOT NULL |
TDS Code |
Yes |
No |
|
TdsH_IntgType |
varchar(5) |
NOT NULL |
Integration Type |
Yes |
No |
|
TdsH_UniqueId |
varchar(40) |
NOT NULL |
Unique Identification ID |
Yes |
No |
|
TdsH_Tds_Conn_Info1 |
varchar(50) |
NULL |
Connection information 1 |
No |
No |
|
TdsH_Tds_Conn_Info2 |
varchar(25) |
NULL |
Connection information 2 |
No |
No |
|
TdsH_Tds_Conn_Info3 |
varchar(30) |
NULL |
Connection information 3 |
No |
No |
|
TdsH_Created_By |
varchar(30) |
NULL |
Created by |
No |
No |
|
TdsH_CreatedDate |
varchar(30) |
NULL |
Created Date |
No |
No |
|
TdsH_Modified_By |
varchar(30) |
NULL |
Modified by |
No |
No |
|
TdsH_ModifiedDate |
varchar(30) |
NULL |
Modified Date |
No |
No |
|
TdsH_Timestamp |
numeric(10,0) |
NOT NULL |
Timestamp |
No |
No |
|
TdsD_MfgrCrOu |
numeric(10,0) |
NOT NULL |
Manufacturer OUInstance |
No |
No |
|
TdsH_MfgrNo |
varchar(45) |
NULL |
manufacturer no |
No |
No |
|
TdsH_CustOu |
numeric(10,0) |
NOT NULL |
Customer Ou |
No |
No |
|
TdsH_CustName |
varchar(40) |
NULL |
Customer Name |
No |
No |
|
TdsH_RefDocType |
varchar(5) |
NOT NULL |
Reference Document Type |
No |
No |
|
|
|||||
|
Table Name Tdi_TdsI_Tech_Doc_Sys_Info |
|
||||
|
|
|||||
|
Table Comment Tech Document System Information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
TdsI_Tds_Code |
varchar(30) |
NOT NULL |
Tds Code |
Yes |
No |
|
TdsI_Param |
varchar(40) |
NOT NULL |
Param code |
Yes |
No |
|
TdsI_IntgType |
varchar(5) |
NOT NULL |
Integration Type |
Yes |
No |
|
TdsI_ParamDesc |
varchar(150) |
NOT NULL |
Param Description |
No |
No |
|
TdsI_PermitedValues |
varchar(255) |
NULL |
Permitted values |
No |
No |
|
TdsI_DefaultValue |
varchar(2000) |
NULL |
Default values |
No |
No |
|
TdsI_Remarks |
varchar(150) |
NULL |
Remarks |
No |
No |
|
TdsI_DisplaySeq |
tinyint |
NULL |
Display Sequence Number |
No |
No |
|
TdsI_Is_Tds_Param |
varchar(1) |
NULL |
param flag |
No |
No |
|
TdsI_ParamSeq |
tinyint |
NULL |
param Sequence number |
No |
No |
|
TdsI_Is_Tds_Val_Reqd |
varchar(1) |
NULL |
Required Flag |
No |
No |
|
|
|||||
|
Table Name Tdi_TdsP_Tech_Doc_Sys_Params |
|
||||
|
|
|||||
|
Table Comment Technical Document systems parameter |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
TdsP_UniqueId |
varchar(40) |
NOT NULL |
Unique ID |
Yes |
No |
|
TdsP_Tds_Code |
varchar(30) |
NOT NULL |
Document Code |
Yes |
No |
|
TdsP_Param |
varchar(40) |
NOT NULL |
Param Code |
Yes |
No |
|
TdsP_IntgType |
varchar(5) |
NOT NULL |
Technical Doc type |
Yes |
No |
|
TdsP_PermitedValues |
varchar(255) |
NULL |
Permitted Values |
No |
No |
|
TdsP_DefaultValue |
varchar(2000) |
NULL |
Default Value |
No |
No |
|
TdsP_Remarks |
varchar(150) |
NULL |
Remarks |
No |
No |
|
TdsP_DisplaySeq |
tinyint |
NOT NULL |
Display sequence number for uniqueness |
No |
No |
|
TdsP_Is_Tds_Param |
varchar(1) |
NULL |
Param Flag |
No |
No |
|
TdsP_ParamSeq |
tinyint |
NULL |
Param sequence number for uniqueness |
No |
No |
|
TdsP_Is_Tds_Val_Reqd |
varchar(1) |
NULL |
Required flag |
No |
No |
|
|
|
|
|
|
|