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)