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