미수금
테이블 (6)
crm (product_price)
- Key (seq_product_price) — int — 기본 키 — NOT NULL
- Field (price) — int
- Field (begin_dt) — datetime
- Field (end_dt) — datetime
- Field (created_dt) — datetime
- seq_product (seq_product2) — int — 외래 키 → crm.seq_product — NOT NULL
crm (partner)
- Key (seq_partner) — int — 기본 키 — NOT NULL
- seq_product — int — 외래 키 → crm.seq_product — NOT NULL
- Field (total_receivable) — int
- Field (receivable_dt) — datetime
- Field (contract_dt) — datetime
- Field (payment_status) — varchar
- Field (use_yn) — varchar(1)
crm (product)
- seq_product — int — 기본 키 — NOT NULL
- Field (payment_type) — int
- Field (agreement_type) — varchar
- Field (created_dt) — datetime
- Field (updated_dt) — datetime
crm (partner_invoice)
- Key (seq_partner_invoice) — int — 기본 키 — NOT NULL
- Field (price) — int
- Field (pay_amount) — int
- Field (status) — varchar
- Field (issue_dt) — datetime
- Field (payment_dt) — datetime
- Field (invoice_title) — varchar(500)
- Key (seq_product_price) — int — 외래 키 → crm.Key — NOT NULL
- Key (seq_partner2) — int — 외래 키 → crm.Key — NOT NULL
crm (adjustment_record)
- Key (seq_adjustment_record) — int — 기본 키 — NOT NULL
- Field (register_id) — int
- Field (amount) — int
- Field (status) — varchar
- Field (payment_dt) — datetime
- Field (created_dt) — datetime
- Key (seq_partner) — int — 외래 키 → crm.Key — NOT NULL
crm (adjustment_file)
- Key (seq_adjustment_file) — int — 기본 키 — NOT NULL
- Field (path) — varchar
- Field (created_dt) — datetime