ERP-L2J-01

Tables (10)

Copy Of I/G (CopyOfI/G)

  • IG_ID — int — Primary key — NOT NULL
  • IG_Name (Field) — text
  • IG_Company (Field2) — text
  • FabricComp_Per (Field4) — text
  • FabricComposition (Field3) — text
  • Classify_of_Fabric (Field9) — text
  • YarnFull_Name (Field10) — text
  • WP1_YarnThickness (Field11) — int
  • WP1_YarnUnit (Field12) — text
  • WP1_YarnBrightness (Field13) — text
  • Field14

FabricComposition (Untitled3)

  • FabricComp_ID (Key) — int — Primary key — NOT NULL
  • Item_Name (Field7) — varchar — NOT NULL
  • FabricComp_Per_01 (Field2) — int
  • FabricComp_01 (Field) — varchar
  • FabricComp_Per_02 (Field3) — int
  • FabricComp_02 (Field4) — varchar
  • FabricComp_Per_03 (Field5) — int
  • FabricComp_03 (Field6) — varchar
  • Field8

I/G_ITEM (I/G)

  • IG_ID — int — Primary key — NOT NULL
  • IG_Name (Field) — varchar
  • IG_Company (Field2) — varchar
  • FabricComp_Per_01 (Field4) — varchar
  • FabricComp_01 (Field3) — varchar
  • FabricComp_Per_02 (Field5) — varchar
  • FabricComp_02 (Field6) — varchar
  • FabricComp_Per_03 (Field7) — varchar
  • FabricComp_03 (Field8) — varchar
  • Classify_of_Fabric (Field9) — varchar
  • IG_Width (Field45) — int
  • WP1_YarnComp (Field10) — varchar
  • WP1_YarnThickness (Field11) — int
  • WP1_YarnUnit (Field12) — varchar
  • WP1_YarnBrightness (Field13) — varchar
  • WP1_YarnProcessing (Field14) — varchar
  • WP1_YarnDensity (Field15) — int
  • WP1_YarnWeight (Field16) — int
  • WP2_YarnComp (Field17) — varchar
  • WP2_YarnThickness (Field18) — int
  • WP2_YarnUnit (Field19) — varchar
  • WP2_YarnBrightness (Field20) — varchar
  • WP2_YarnProcessing (Field21) — varchar
  • WP2_YarnDensity (Field22) — int
  • WP2_YarnWeight (Field23) — int
  • WT1_YarnComp (Field24) — text
  • WT1_YarnThickness (Field25) — varchar
  • WT1_YarnUnit (Field26) — varchar
  • WT1_YarnBrightness (Field27) — varchar
  • WT1_YarnProcessing (Field28) — varchar
  • WT1_YarnDensity (Field29) — int
  • WT1_YarnWeight (Field30) — int
  • WT2_YarnComp (Field31) — varchar
  • WT2_YarnThickness (Field32) — int
  • WT2_YarnUnit (Field33) — varchar
  • WT2_YarnBrightness (Field34) — varchar
  • WT2_YarnProcessing (Field35) — varchar
  • WT2_YarnDensity (Field36) — int
  • WT2_YarnWeight (Field37) — int
  • WT3_YarnComp (Field38) — varchar
  • WT3_YarnThickness (Field39) — int
  • WT3_YarnUnit (Field40) — varchar
  • WT3_YarnBrightness (Field41) — varchar
  • WT3_YarnProcessing (Field42) — varchar
  • WT3_YarnDensity (Field43) — int
  • WT3_YarnWeight (Field44) — int
  • Field46

ITEMS

  • Item_Name (Key2) — varchar — Primary key — NOT NULL
  • Item_Finish (Field4) — varchar
  • Item_ProductionMethod (Field5) — varchar — IG,반제,완제
  • Supplier_Name (Field2) — varchar
  • Item_RegistDate (Field3) — datetime
  • CommercialName_01 (Field6) — varchar
  • CommercialName_02 (Field7) — varchar
  • CommercailName_02 (Field8) — varchar
  • Field9

ITEMS-Relation (Untitled2)

  • ItemRe_ID (Key) — int — Primary key — NOT NULL
  • Item_Name (Field) — varchar — NOT NULL
  • ItemPrevious_Name (Field2) — varchar
  • Relation_RegistDate (Field3) — datetime
  • Field4

SPEC_Elements

  • Spec_ID (key) — int — Primary key — NOT NULL
  • Item_Name (Field) — varchar — NOT NULL
  • FabricComp_ID (Field4) — int — NOT NULL
  • Fabric_Classify (Field9) — varchar — woven,knit,etc
  • Fabric_Width (Field45) — int
  • Fabric-Resin (Field46) — int
  • WP1_Yarn_ID (Field10) — int
  • WP1_YarnDensity (Field15) — int
  • WP1_YarnWeight (Field16) — int
  • WP2_Yarn_ID (Field17) — int
  • WP2_YarnDensity (Field22) — int
  • WP2_YarnWeight (Field23) — int
  • WT1_Yarn_ID (Field24) — int
  • WT1_YarnDensity (Field29) — int
  • WT1_YarnWeight (Field30) — int
  • WT2_Yarn_ID (Field31) — int
  • WT2_YarnDensity (Field36) — int
  • WT2_YarnWeight (Field37) — int
  • WT3_Yarn_ID (Field38) — int
  • WT3_YarnDensity (Field43) — int
  • WT3_YarnWeight (Field44) — int
  • Spec_Elem_RegistDate (Field2) — datetime
  • Field11

Sample_List (Untitled5)

  • SampleList_ID (Key) — int — Primary key — NOT NULL
  • Sample_Sort (Field2) — varchar — SampleBook,Yd,
  • SampleOrder_No (Field) — varchar
  • Item_name (Field3) — varchar
  • Item_Finish (Field4) — varchar
  • Color (Field5) — varchar
  • SampleRequir_Q'ty (Field6) — int — Sample Requirement
  • SampleRequir_Date (Field7) — datetime
  • Customer_Name (Field8) — varchar
  • Customer_Manager (Field9) — varchar
  • SampleShipping_Q'ty (Field10) — int
  • SampleShipping_Date (Field11) — datetime
  • Sample_Remark (Field12) — varchar
  • Field13

Temp_ITEM (Untitled)

  • Temp_ID (Key) — int — Primary key — NOT NULL
  • Temp_Name (Field) — varchar
  • Product_Sort (Field4) — varchar
  • ProductName_Company (Field3) — varchar
  • Product_Company (Field2) — varchar
  • Field5

Temp_ITEM (CopyOfI/G2)

  • Temp_ID (IG_ID) — int — Primary key — NOT NULL
  • Temp_Name (Field) — varchar
  • Product_Sort (Field46) — varchar
  • ProductName_Company (Field2) — varchar
  • Product_Company (Field47) — varchar
  • FabricComp_Per_01 (Field4) — varchar
  • FabricComp_01 (Field3) — varchar
  • FabricComp_Per_02 (Field5) — varchar
  • FabricComp_02 (Field6) — varchar
  • FabricComp_Per_03 (Field7) — varchar
  • FabricComp_03 (Field8) — varchar
  • Classify_of_Fabric (Field9) — varchar
  • Width (Field45) — int
  • WP1_YarnComp (Field10) — varchar
  • WP1_YarnThickness (Field11) — int
  • WP1_YarnUnit (Field12) — varchar
  • WP1_YarnBrightness (Field13) — varchar
  • WP1_YarnProcessing (Field14) — varchar
  • WP1_YarnDensity (Field15) — int
  • WP1_YarnWeight (Field16) — int
  • WP2_YarnComp (Field17) — varchar
  • WP2_YarnThickness (Field18) — int
  • WP2_YarnUnit (Field19) — varchar
  • WP2_YarnBrightness (Field20) — varchar
  • WP2_YarnProcessing (Field21) — varchar
  • WP2_YarnDensity (Field22) — int
  • WP2_YarnWeight (Field23) — int
  • WT1_YarnComp (Field24) — text
  • WT1_YarnThickness (Field25) — varchar
  • WT1_YarnUnit (Field26) — varchar
  • WT1_YarnBrightness (Field27) — varchar
  • WT1_YarnProcessing (Field28) — varchar
  • WT1_YarnDensity (Field29) — int
  • WT1_YarnWeight (Field30) — int
  • WT2_YarnComp (Field31) — varchar
  • WT2_YarnThickness (Field32) — int
  • WT2_YarnUnit (Field33) — varchar
  • WT2_YarnBrightness (Field34) — varchar
  • WT2_YarnProcessing (Field35) — varchar
  • WT2_YarnDensity (Field36) — int
  • WT2_YarnWeight (Field37) — int
  • WT3_YarnComp (Field38) — varchar
  • WT3_YarnThickness (Field39) — int
  • WT3_YarnUnit (Field40) — varchar
  • WT3_YarnBrightness (Field41) — varchar
  • WT3_YarnProcessing (Field42) — varchar
  • WT3_YarnDensity (Field43) — int
  • WT3_YarnWeight (Field44) — int
  • Field48

Yarn (Untitled4)

  • Yarn_ID (Key) — int — Primary key — NOT NULL
  • Yarn_comp (Field) — varchar
  • Yarn_Thickness (Field2) — int
  • Yarn_Unit (Field3) — varchar
  • Yarn_Fila (Field6) — int
  • Yarn_Brightness (Field4) — varchar
  • Yarn_Processing (Field5) — varchar
  • Field7