재고업로드현황

테이블 (27)

ALLCost (CopyOfUntitled7)

  • Key (ALLCostCode) — 기본 키 — NOT NULL
  • Field (Date)
  • Field2 (Amount)
  • Key (ALLCTCode) — 외래 키 → ALLCostType.Key — NOT NULL

ALLCostType (Untitled6)

  • Key (ALLCTCode) — 기본 키 — NOT NULL
  • Field (CostType)

ALLIncome (CopyOfUntitled72)

  • Key (ALLIncomeCode) — 기본 키 — NOT NULL
  • Field (Date)
  • Field2 (Amount)
  • Key (ALLITCode) — 외래 키 → ALLIncomeType.Key — NOT NULL

ALLIncomeType (CopyOfUntitled6)

  • Key (ALLITCode) — 기본 키 — NOT NULL
  • Field (IncomeType)

BrandCode (Untitled2)

  • Key (BrandCode) — 기본 키 — NOT NULL
  • Field (BrandName)
  • Field (BrandType)

Client (CopyOfUntitled2)

  • Key (ClientCode) — 기본 키 — NOT NULL
  • Field (ClientName)
  • Field (BanckName)
  • Field (AccountNumber)
  • Field (DeliveryFee)
  • Field (CNote)

ClientCommissionReturn (Untitled22)

  • Key (ClientCommissionReturnCode) — 기본 키 — NOT NULL
  • Field (ClientReturnPrice)
  • Field2 (ClientReturnDeliveryFee)
  • Field3 (ClientReturnPlusFee)
  • Field4 (SUMClientReturnPrice)
  • Field5 (CCRNote)
  • Key (CommissionRetrnCode) — 외래 키 → CommissionReturn.Key — NOT NULL

Commission (Untitled13)

  • Key (CommissionCode) — 기본 키 — NOT NULL
  • Key (ClientCode) — 외래 키 → Client.Key — NOT NULL
  • Key (InfoProductCode) — 외래 키 → InfoProduct.Key — NOT NULL

CommissionOrder (Untitled14)

  • Key (CommissionOrderCode) — 기본 키 — NOT NULL
  • Field (OrderDate)
  • Field2 (CWholeSale)
  • Field3 (DeliveryFee)
  • Field (Fee)
  • Field (CONote)
  • Key (CommissionSellCode) — 외래 키 → CommissionSell.Key — NOT NULL

CommissionReturn (Untitled21)

  • Key (CommissionRetrnCode) — 기본 키 — NOT NULL
  • Field (ReturnDate)
  • Field2 (ReturnFee)
  • Field3 (ReturnDeliveryFee)
  • Field4 (PlusReturnFee)
  • Field5 (SUMReturnFee)
  • Field6 (CCRNote)
  • Key (CommissionSellCode) — 외래 키 → CommissionSell.Key — NOT NULL

CommissionReturnProfit (Untitled3)

  • Key (CommissionReturnProfitCode) — 기본 키 — NOT NULL
  • Field (Date)
  • Field2 (SUMCommissionReturn)
  • Field (SUMClientCommissionReturn)
  • Field3 (Profit)
  • Key (CommissionRetrnCode) — 외래 키 → CommissionReturn.Key — NOT NULL
  • Key (ClientCommissionReturnCode) — 외래 키 → ClientCommissionReturn.Key — NOT NULL

CommissionSell (Untitled17)

  • Key (CommissionSellCode) — 기본 키 — NOT NULL
  • Field (DealDate)
  • Field2 (SellQuantity)
  • Field3 (Customer)
  • Field (SalesPrice)
  • Field (DeliveryPrice)
  • Field5 (DeliveryFee)
  • Field6 (Fee)
  • Field7 (CSNote)
  • Key (CommissionCode) — 외래 키 → Commission.Key — NOT NULL
  • Key (PlatformCode) — 외래 키 → Platform.Key — NOT NULL

CommissionSellProfit (Untitled18)

  • Key (CommissionSellProfitCode) — 기본 키 — NOT NULL
  • Field (Date)
  • Field2 (SUMCommissionOrder)
  • Field4 (SUMCommissionSell)
  • Field7 (Profit)
  • Key (CommissionOrderCode) — 외래 키 → CommissionOrder.Key — NOT NULL

Cost (Untitled10)

  • Key (CostCode) — 기본 키 — NOT NULL
  • Field (CostType)

Deposit (Untitled12)

  • Key (DepositCode) — 기본 키 — NOT NULL
  • Field (Date)
  • Field2 (Amount)
  • Field4 (PersonDeposit)
  • Field5 (Reason)
  • Field3 (DNote)

Evidence (Untitled8)

  • Key (EvidenceCode) — 기본 키 — NOT NULL
  • Field (EvidenceType)

InfoProduct (Untitled11)

  • Key (InfoProductCode) — 기본 키 — NOT NULL
  • Field (Color)
  • Field2 (Size)
  • Key (ProductCode) — 외래 키 → ProductList.Key — NOT NULL

Platform (Untitled5)

  • Key (PlatformCode) — 기본 키 — NOT NULL
  • Field (PlatformName)

ProductList (Untitled)

  • Key (ProductCode) — 기본 키 — NOT NULL
  • Field4 (ProductName)
  • Field9 (PNote)
  • Key (BrandCode) — 외래 키 → BrandCode.Key — NOT NULL
  • Key (ProductTypeCode) — 외래 키 → ProductType.Key — NOT NULL

ProductType (Untitled9)

  • Key (ProductTypeCode) — 기본 키 — NOT NULL
  • Field (ProductType)

Spending (Untitled7)

  • Key (SpendingCode) — 기본 키 — NOT NULL
  • Field (SpendingDate)
  • Field2 (Amount)
  • Field3 (PlacePayment)
  • Field4 (Reason)
  • Field5 (SpNote)
  • Key (EvidenceCode) — 외래 키 → Evidence.Key — NOT NULL
  • Key (CostCode) — 외래 키 → Cost.Key — NOT NULL

Stock (Untitled4)

  • PK (StockCode) — 기본 키 — NOT NULL
  • Field (Quantity)
  • Field2 (AVGPrice)
  • Key (ProductCode) — 외래 키 → ProductList.Key — NOT NULL
  • Key (StockOrderCode) — 외래 키 → StockOrder.Key — NOT NULL

StockOrder (Untitled16)

  • Key (StockOrderCode) — 기본 키 — NOT NULL
  • Field (Date)
  • Field (Quantity)
  • Field2 (SWholeSale)
  • Field (DeliveryFee)
  • Field2 (Fee)
  • Field (SONote)
  • Key (ClientCode) — 외래 키 → Client.Key — NOT NULL
  • Key (InfoProductCode) — 외래 키 → InfoProduct.Key — NOT NULL

StockReturn (Untitled23)

  • Key (StockReturnCode) — 기본 키 — NOT NULL
  • Field (ReturnDate)
  • Field2 (ReturnFee)
  • Field3 (ReturnDeliveryFee)
  • Field (PlusReturnFee)
  • Field4 (SUMPeturnFee)
  • Field5 (SRNote)
  • Key (StockSellCode) — 외래 키 → StockSell.Key — NOT NULL

StockReturnProfit (CopyOfUntitled3)

  • Key (StockReturnProfitCode) — 기본 키 — NOT NULL
  • Field (Date)
  • Field2 (SUMStockReturn)
  • Field3 (Profit)
  • Key (StockReturnCode) — 외래 키 → StockReturn.Key — NOT NULL

StockSell (Untitled19)

  • Key (StockSellCode) — 기본 키 — NOT NULL
  • Field (DealDate)
  • Field2 (SellQuantity)
  • Field3 (Customer)
  • Field4 (SalesPrice)
  • Field (DeliveryPrice)
  • Field6 (DeliveryFee)
  • Field5 (Fee)
  • Field7 (SSNote)
  • Key (PlatformCode) — 외래 키 → Platform.Key — NOT NULL
  • PK (StockCode) — 외래 키 → Stock.PK — NOT NULL

StockSellProfit (Untitled20)

  • Key (StockSellProfitCode) — 기본 키 — NOT NULL
  • Field (Date)
  • Field (SUMStock)
  • Field2 (SUMStockSell)
  • Field6 (Profit)
  • Key (StockSellCode) — 외래 키 → StockSell.Key — NOT NULL