JFC Kintone

Tables (10)

BRAND (CopyOfCopyOfCopyOfUntitled3)

  • BRAND (Field) — Primary key
  • PORT (Field22) — Foreign key → ORIGIN.PORT
  • ORIGIN (Field4) — Foreign key → ORIGIN.ORIGIN

Charge (Untitled3)

  • Charge (Key) — Primary key — NOT NULL
  • Name (Field)
  • Team (Field2)

Customer (Untitled2)

  • Customer (Key) — Primary key — NOT NULL
  • name (Field)

ITEM (CopyOfUntitled3)

  • ITEM (Field) — Primary key

Item

  • Record Number (Key2) — Primary key — NOT NULL
  • JK No (Key) — Primary key — NOT NULL
  • ITEM (Field) — Foreign key → ITEM.ITEM
  • BRAND (Field4) — Foreign key → BRAND.BRAND
  • BEEF/PORK (Field13)
  • BRAND (Field14)
  • B/O (Field18)
  • grade (Field19)
  • spec (Field20)
  • CONT SHIP (Field21)
  • DEST (Field23)
  • Cont case (Field24)
  • Cont m/t (Field25)
  • Unit price (Field26)
  • Cont amount (Field27)
  • Commission (Field28)
  • Cont comm (Field29)
  • f (Field30)
  • remark (Field32)
  • cancel date (Field33)
  • Total Cont Case (Field2)
  • Total Cont Amount (Field3)
  • Total Cont M/T (Field5)
  • Total Cont commission (Field6)
  • Contract Date (Field31)
  • SHIP DATE (Field7)
  • ITEM (Field12)
  • F/C (Field17)

ORIGIN (CopyOfCopyOfCopyOfCopyOfUntitled3)

  • PORT (Field2) — Primary key
  • ORIGIN (Field) — Primary key

S/A (Untitled)

  • SUP NO (Field2) — Primary key
  • Record Number (Key) — Primary key — NOT NULL
  • Record Number (Key2) — Foreign key → Item.Record Number — NOT NULL
  • JK No (Key3) — Foreign key → Item.JK No — NOT NULL
  • ITEM (Field25) — Foreign key → Item.ITEM
  • BRAND (Field42) — Foreign key → Item.BRAND
  • Check Box (Field)
  • SUP NO SUB (Field3)
  • CHILE INVOICE NO (Field4)
  • Output check (Field5)
  • L/C Open Check (Field24)
  • Description (Field6)
  • VESSEL (Field7)
  • ETD (Field8)
  • ETA (Field9)
  • POL (Field10)
  • S/CO (Field11)
  • L/C Open Check (Field12)
  • L/C No (Field13)
  • L/C Open Date (Field14)
  • Open Bank (Field15)
  • T/T Date (Field16)
  • B/L NO (Field17)
  • Arrival (Field18)
  • Delivery (Field19)
  • Close Contract (Field20)
  • Office NO (Field21)
  • Bank NO (Field22)
  • Cancel Date (Field23)

Sales (Untitled4)

  • Sales Ex Rate (Field)
  • Remark (Field2)

Supplier (CopyOfUntitled2)

  • Supplier (Key) — Primary key — NOT NULL
  • name (Field)

main (Main)

  • SUP NO (Field8) — Primary key
  • JK NO (Key) — Primary key — NOT NULL
  • CONT NO (Field9) — Primary key
  • SUP NO (Field23) — Foreign key → S/A.SUP NO
  • ITEM (Field13) — Foreign key → Item.ITEM
  • Charge (Key3) — Foreign key → Charge.Charge — NOT NULL
  • ORIGIN (Field24) — Foreign key
  • Customer (Key2) — Foreign key → Customer.Customer — NOT NULL
  • Supplier (Key4) — Foreign key → Supplier.Supplier — NOT NULL
  • Key2 (Key22) — Foreign key → Item.Record Number — NOT NULL
  • Key (Key5) — Foreign key → S/A.Record Number — NOT NULL
  • JK No (Key6) — Foreign key → Item.JK No — NOT NULL
  • Record Number (Key23) — Foreign key → S/A.Record Number — NOT NULL
  • JK No (Key32) — Foreign key → S/A.JK No — NOT NULL
  • ITEM (Field25) — Foreign key → S/A.ITEM
  • BRAND (Field42) — Foreign key → S/A.BRAND
  • Commission (Field4)
  • Payment (Field5)
  • Unit (Field6)
  • Currency (Field7)
  • Comm Type (Field14)
  • Contract Type (Field15)