rist - 2025-04-08 02:07:53

Tables (7)

ASSET_EQUIPMENT (Untitled)

  • ASSET_ID (Key) — NUMBER — Primary key — NOT NULL
  • ASSET_NUMBER (Field) — VARCHAR2
  • CATEGORY_1 (Field2) — VARCHAR2
  • CATEGORY_2 (Field3) — VARCHAR2
  • CATEGORY_3 (Field4) — VARCHAR2
  • CATEGORY_4 (Field5) — VARCHAR2
  • CATEGORY_DESC (Field6) — VARCHAR2
  • CREATE_DATE (Field7) — DATE
  • CREATER_NO (Field8) — NUMBER(5)
  • DEPT_CODE (Field9) — VARCHAR2
  • DEPT_NAME (Field10) — VARCHAR2
  • DISPOSAL_DATE (Field11) — DATE
  • EMPLOYEE_NO (Field12) — VARCHAR2
  • EQUIP_NAME (Field13) — VARCHAR2
  • EQUIP_NO (Field14) — NUMBER(9)
  • EQUIP_SPEC (Field15) — VARCHAR2
  • MANUFACTURER_NAME (Field16) — VARCHAR2
  • MODEL_NAME (Field17) — VARCHAR2
  • OLD_ASSET_NUM (Field18) — VARCHAR2
  • ORIGINAL_COST (Field19) — NUMBER
  • RET_TYPE_CODE (Field20) — VARCHAR2
  • SERVICE_DATE (Field21) — DATE
  • SYNC_DATE (Field22) — DATE
  • USER_NAME (Field23) — VARCHAR2

SP_LIMSIF_GET_ASSET_BOOK_V (ASSET_EQUIPMENT)

    TEST_ASSIGN_EQUIP (Untitled2)

    • ASSIGN_ASSIGN_EQUIP_NO (Key) — NUMBER(9) — Primary key — NOT NULL
    • TEST_MTD_EQUIP_NO (Key3) — NUMBER — Foreign key → TEST_MTD_ASSET_EQUIP.TEST_MTD_EQUIP_NO — NOT NULL
    • TEST_MTD_NO (Key23) — NUMBER(5) — Foreign key — NOT NULL
    • TEST_ASSIGN_NO (Field) — NUMBER(9)
    • TEST_COUNT (Field2) — NUMBER(9)
    • TEST_MTD_RESULT_NO (Field4) — NUMBER(9)
    • TEST_OPER_TIME (Field5) — NUMBER

    TEST_MTD (Untitled4)

    • TEST_MTD_NO (Key) — NUMBER(5) — Primary key — NOT NULL
    • Field

    TEST_MTD_ASSET_EQUIP (Untitled3)

    • TEST_MTD_EQUIP_NO (Key) — NUMBER — Primary key — NOT NULL
    • TEST_MTD_NO (Key4) — NUMBER(5) — Foreign key → TEST_MTD.TEST_MTD_NO — NOT NULL
    • OPER_TIME (Field2) — NUMBER
    • USE_FLAG (Field3) — CHAR(1)
    • UPDATER_NO (Field4) — NUMBER(5)
    • UPDATE_DATE (Field5) — DATE
    • UI_INDEX (Field6) — NUMBER
    • SORT_ORDER (Field7) — NUMBER
    • MEMO (Field8) — VARCHAR2(500)
    • EQUIP_NO (Field9) — NUMBER(9)
    • CREATEER_NO (Field10) — NUMBER(5)
    • CREATE_DATE (Field11) — DATE

    TEST_MTD_RESULT (CopyOfUntitled4)

    • TEST_MTD_RESULT_NO (Key) — NUMBER(5) — Primary key — NOT NULL

    V_ASSET_TEST_MTD_RESULT (TEST_MTD_RESULT)