도매출하
테이블 (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)