cubicERP

Tables (9)

ACCIDENT (Untitled3)

  • SEQ (Key) — Primary key — NOT NULL
  • MEMBERS_SEQ (Field)
  • CONTENT (Field2)
  • PM (Field3)
  • REG_DATE (Field6)

APPROVAL (Untitled5)

  • SEQ (Key) — Primary key — NOT NULL
  • COMPANY_SEQ (Field)
  • MEMBER_SEQ (Field2)
  • TYPE (Field3)
  • STATE (Field4)
  • COM_DATE (Field5)
  • REG_DATE (Field6)

EXPENSE (지출결의서)

  • SEQ (Key) — Primary key — NOT NULL
  • MEMBER_SEQ (Field)
  • APPROVAL_SEQ (Field2)
  • PM (Field3)
  • BUSINESS_CODE (Field4)
  • BUSINESS_NAME (Field5)
  • PRICE (Field6)
  • REG_DATE (Field7)

EXPENSE_DETAIL (지출결의서_상세)

  • SEQ (Key) — Primary key — NOT NULL
  • EXPENSE_SEQ (Field)
  • CONTENT (Field2)
  • PRICE (Field3)
  • TYPE (Field4)
  • EXPENSE_DATE (Field6)
  • REG_DATE (Field5)

MEMBERS (Untitled)

  • SEQ (Key) — Primary key — NOT NULL
  • ID (Field)
  • PW (Field2)
  • NAME (Field3)
  • TEAM (Field4)
  • POSITION (Field5)
  • USE_YN (Field6)
  • MOBILE (Field7)
  • BIRTH (Field8)
  • GENDER (Field9)
  • MARRY (Field10)
  • Field11
  • Field12
  • Field13
  • Field14
  • Field15
  • Field16
  • Field17
  • Field18
  • Field19
  • Field20
  • Field21

REQUEST (품의서)

  • SEQ (Key) — Primary key — NOT NULL
  • REG_DATE (Field)
  • MEMBER_SEQ (Field2)
  • BUSINESS_CODE (Field3)
  • BUSINESS_NAME (Field4)
  • PM (Field10)
  • TITLE (Field5)
  • 결재방법 (Field6)
  • 은행 (Field7)
  • 계좌번호 (Field8)
  • 예금주 (Field9)
  • 입금기한 (Field11)

REQUEST_DETAIL (Untitled4)

  • SEQ (Key) — Primary key — NOT NULL
  • REQUEST_SEQ (Field)
  • 구매처 (Field3)
  • 수량 (Field5)
  • 품목 (Field4)
  • PRICE (Field2)

RESIGNATION (사직서)

  • SEQ (Key) — Primary key — NOT NULL
  • MEMBER_SEQ (Field)
  • REG_DATE (Field2)
  • MEMBER_SEQ (Field3)
  • CONTENT (Field4)
  • RESIG_DATE (Field5)

VACATION (Untitled2)

  • SEQ (Key) — Primary key — NOT NULL
  • MEMBER_SEQ (Field)
  • APPROVAL_SEQ (Field2)
  • VACATION_TYPE (Field3)
  • START_DATE (Field4)
  • END_DATE (Field5)
  • CONTENT (Field6)
  • REG_DATE (Field7)