;*********************************************************************************************
; Dateiname 	: 	SD_Externe_Atribute_Tabellen.lsp
; Autor         : 	Stephan Wörz
; Erstellt      :	22.04.2005
; geändert    	:
;*********************************************************************************************
; Beschreibung:		- 	Generiert die logischen Tabellen für "Externe_Attribute.lsp"
;*********************************************************************************************
; Änderungen
;
;*********************************************************************************************

(in-package :teo)
(use-package :oli)

;*********************************************************************************************

(sd-create-logical-table 	"LESA_WERKSTOFF"
  :columns        '(:WERKSTOFF)
  :columnNames    '("WERKSTOFF" )
  :types          '(:string )
  :units          '(nil)
  :contents       '( 
	("AL" )                 
	("St37-2" )
	("St50-2" )
 ))
  
(sd-create-display-table   	"DT_Lesa_BOM_Werkstoff"
   :tableTitle             	"WERKSTOFF"
   :logicalTable           	"LESA_WERKSTOFF"
   :columns                	'(:WERKSTOFF)
   :filterStatusLine       	nil
   :applyColumns          	'( :WERKSTOFF)
   :selectionMode          	:single-row 
   :applyAction            	:default-tokens
   :afterApplyBehavior		:close-if-not-pinned
)
;*********************************************************************************************


(sd-create-logical-table 	"LESA_NORM"
  :columns        '(:NORM)
  :columnNames    '("NORM" )
  :types          '(:string )
  :units          '(nil)
  :contents       '( 
	("DIN 123" )                 
	("DIN 456" )
	("DIN 789" )
 ))
  
(sd-create-display-table   	"DT_LESA_BOM_NORM"
   :tableTitle             	"NORM"
   :logicalTable           	"LESA_NORM"
   :columns                	'(:NORM)
   :filterStatusLine       	nil
   :applyColumns          	'( :NORM)
   :selectionMode          	:single-row 
   :applyAction            	:default-tokens
   :afterApplyBehavior		:close-if-not-pinned
)
;*********************************************************************************************


(sd-create-logical-table 	"HERSTELLER"
  :columns        '(:HERSTELLER)
  :columnNames    '("HERSTELLER" )
  :types          '(:string )
  :units          '(nil)
  :contents       '( 
	("Bosch Rexroth" )                 
	("Bilz" )
	("sonstwer" )
 ))
  
(sd-create-display-table   	"DT_LESA_BOM_HERSTELLER"
   :tableTitle             	"HERSTELLER"
   :logicalTable           	"HERSTELLER"
   :columns                	'(:HERSTELLER)
   :filterStatusLine       	nil
   :applyColumns          	'( :HERSTELLER)
   :selectionMode          	:single-row 
   :applyAction            	:default-tokens
   :afterApplyBehavior		:close-if-not-pinned
)

;*********************************************************************************************

(sd-create-logical-table 	"OBERFLAECHE"
  :columns        '(:OBERFLAECHE)
  :columnNames    '("OBERFLAECHE" )
  :types          '(:string )
  :units          '(nil)
  :contents       '( 
	("natur eloxiert" )                 
	("galv. Verzinkt" )
	("brüniert" )
 ))
  
(sd-create-display-table   	"DT_LESA_BOM_OBERFLAECHE"
   :tableTitle             	"OBERFLAECHE"
   :logicalTable           	"OBERFLAECHE"
   :columns                	'(:OBERFLAECHE)
   :filterStatusLine       	nil
   :applyColumns          	'( :OBERFLAECHE)
   :selectionMode          	:single-row 
   :applyAction            	:default-tokens
   :afterApplyBehavior		:close-if-not-pinned
)
;*********************************************************************************************

(sd-create-logical-table 	"WAERMEBEH"
  :columns        '(:WAERMEBEH)
  :columnNames    '("WAERMEBEH" )
  :types          '(:string )
  :units          '(nil)
  :contents       '( 
	("gehärtet" )                 
	("weichgeglüht" )
	("gehärtet und angelassen" )
 ))
  
(sd-create-display-table   	"DT_LESA_BOM_WAERMEBEH"
   :tableTitle             	"WAERMEBEH"
   :logicalTable           	"WAERMEBEH"
   :columns                	'(:WAERMEBEH)
   :filterStatusLine       	nil
   :applyColumns          	'( :WAERMEBEH)
   :selectionMode          	:single-row 
   :applyAction            	:default-tokens
   :afterApplyBehavior		:close-if-not-pinned
)
;*********************************************************************************************

(sd-create-logical-table 	"TYP"
  :columns        '(:TYP)
  :columnNames    '("TYP" )
  :types          '(:string )
  :units          '(nil)
  :contents       '( 
	("20x20" )                 
	("40x20" )
	("40x40" )
	("80x40" )
 ))
  
(sd-create-display-table   	"DT_Lesa_BOM_HLZ_Typ"
   :tableTitle             	"TYP"
   :logicalTable           	"TYP"
   :columns                	'(:TYP)
   :filterStatusLine       	nil
   :applyColumns          	'( :TYP)
   :selectionMode          	:single-row 
   :applyAction            	:default-tokens
   :afterApplyBehavior		:close-if-not-pinned
)

;*********************************************************************************************

(sd-create-logical-table 	"SCHLUESSEL"
  :columns        '(:SCHLUESSEL)
  :columnNames    '("SCHLUESSEL" )
  :types          '(:string )
  :units          '(nil)
  :contents       '( 
	("Zeichnungsteil" )                 
	("Baugruppe/Modul" )
	("Katalogteil" )
	("Normteil" )
 ))
  
(sd-create-display-table   	"DT_LESA_SCHLUESSEL"
   :tableTitle             	"SCHLUESSEL"
   :logicalTable           	"SCHLUESSEL"
   :columns                	'(:SCHLUESSEL)
   :filterStatusLine       	nil
   :applyColumns          	'( :SCHLUESSEL)
   :selectionMode          	:single-row 
   :applyAction            	:default-tokens
   :afterApplyBehavior		:close-if-not-pinned
)