도매출하

테이블 (4)

agent_fee

  • id (PK) — int — 기본 키 — NOT NULL
  • producer_code (생산자코드) — int
  • from (지원시작일) — datetime
  • to (지원종료일(exclusive)) — datetime
  • rate (지원비율) — int
  • agent_name (집하대행자) — varchar(50)
  • gl_crop_id (작물코드) — int
  • bank_name (은행명) — varchar(50)
  • bank_account (계좌번호) — varchar(50)
  • account_name (예금주명) — varchar(50)
  • created_at (Field) — datetime
  • updated_at (Field2) — datetime

box_cost_support

  • id (PK) — int — 기본 키 — NOT NULL
  • producer_code (생산자코드) — int
  • from (지원시작일) — datetime
  • to (지원종료일(exclusive)) — datetime
  • type (종류) — varchar(50)
  • weight (중량) — int
  • unit (단위) — enum
  • price (단가) — int
  • rate (지원비율) — int
  • created_at (Field) — datetime
  • updated_at (Field2) — datetime

transport_cost_support

  • id (PK) — int — 기본 키 — NOT NULL
  • producer_code (생산자코드) — int
  • from (지원시작일) — datetime
  • to (지원종료일(exclusive)) — datetime
  • rate (지원비율) — int
  • created_at (Field) — datetime
  • updated_at (Field2) — datetime

wholesale_market_orders

  • id (PK) — int — 기본 키 — NOT NULL
  • uid (UID) — int
  • slip_no (도매출하전표번호) — varchar(100)
  • wholesaler_id (도매법인_id) — int
  • producer_code (생산자코드) — varchar(50)
  • settlement_date (정산일자) — datetime
  • product_id (상품번호) — int
  • sku (SKU) — varchar(100)
  • gl_crop_id (작물코드) — varchar(190)
  • quantity (수량) — int
  • price (단가) — int
  • Field4 (도매시장이 받는 상장 수수료) — int
  • transport_cost (운송비) — int
  • ? (하차비) — int
  • ? (차인지급액) — int
  • ? (출고장려금) — int
  • box_cost_support (박스비지원) — int
  • transport_cost_support (운송비지원) — int
  • agent_fee_support (집하대행수수료지원) — int
  • created_at (Field)
  • updated_at (Field2)