재고업로드현황
테이블 (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