test

Tables (17)

ACCOUNT_DETERMINATION

  • MOVEMENT_TYPE — VARCHAR(3) — Primary key — NOT NULL
  • VALUATION_CLASS — VARCHAR(4) — Primary key — NOT NULL
  • TRANSACTION_KEY — VARCHAR(3) — Primary key — NOT NULL
  • GL_ACCOUNT_ID — VARCHAR(10) — Foreign key → GL_ACCOUNT.GL_ACCOUNT_ID — NOT NULL

ACCOUNT_DOC_H

  • ACCOUNT_DOCUMENT_ID — VARCHAR(10) — Primary key — NOT NULL
  • FISCAL_YEAR — SMALLINT — Primary key — NOT NULL
  • REFERENCE_MATERIAL_DOC_ID — VARCHAR(10) — Foreign key → GOODS_ISSUE_H.MATERIAL_DOCUMENT_ID — NOT NULL
  • REFERENCE_FISCAL_YEAR — SMALLINT — Foreign key → GOODS_ISSUE_H.FISCAL_YEAR — NOT NULL

ACCOUNT_DOC_I

  • LINE_NO — INT — Primary key — NOT NULL
  • ACCOUNT_DOCUMENT_ID — VARCHAR(10) — Foreign key → ACCOUNT_DOC_H.ACCOUNT_DOCUMENT_ID — NOT NULL
  • FISCAL_YEAR — SMALLINT — Foreign key → ACCOUNT_DOC_H.FISCAL_YEAR — NOT NULL
  • GL_ACCOUNT_ID — VARCHAR(10) — Foreign key → GL_ACCOUNT.GL_ACCOUNT_ID — NOT NULL
  • MATERIAL_ID — VARCHAR(18) — Foreign key → MATERIAL.MATERIAL_ID

CUSTOMER

  • CUSTOMER_ID — VARCHAR(10) — Primary key — NOT NULL
  • RECONCILIATION_ACCOUNT — VARCHAR(10) — Foreign key → GL_ACCOUNT.GL_ACCOUNT_ID — NOT NULL

DELIVERY_H

  • DELIVERY_ID — VARCHAR(10) — Primary key — NOT NULL
  • CUSTOMER_ID — VARCHAR(10) — Foreign key → CUSTOMER.CUSTOMER_ID — NOT NULL

DELIVERY_I

  • ITEM_NO — INT — Primary key — NOT NULL
  • DELIVERY_ID — VARCHAR(10) — Foreign key → DELIVERY_H.DELIVERY_ID — NOT NULL
  • SOURCE_SO_ID — VARCHAR(10) — Foreign key → SALES_ORDER_I.SALES_ORDER_ID — NOT NULL
  • SOURCE_SO_ITEM_NO — INT — Foreign key → SALES_ORDER_I.ITEM_NO — NOT NULL
  • MATERIAL_ID — VARCHAR(18) — Foreign key → MATERIAL_PLANT.MATERIAL_ID — NOT NULL
  • PLANT_ID — VARCHAR(4) — Foreign key → STORAGE_LOCATION.PLANT_ID — NOT NULL
  • STORAGE_LOCATION_ID — VARCHAR(4) — Foreign key → STORAGE_LOCATION.STORAGE_LOCATION_ID — NOT NULL

GL_ACCOUNT

  • GL_ACCOUNT_ID — VARCHAR(10) — Primary key — NOT NULL

GOODS_ISSUE_H

  • MATERIAL_DOCUMENT_ID — VARCHAR(10) — Primary key — NOT NULL
  • FISCAL_YEAR — SMALLINT — Primary key — NOT NULL
  • DELIVERY_ID — VARCHAR(10) — Foreign key → DELIVERY_H.DELIVERY_ID — NOT NULL
  • REVERSAL_DOCUMENT_ID — VARCHAR(10) — Foreign key → GOODS_ISSUE_H.MATERIAL_DOCUMENT_ID
  • REVERSAL_FISCAL_YEAR — SMALLINT — Foreign key → GOODS_ISSUE_H.FISCAL_YEAR

GOODS_ISSUE_I

  • ITEM_NO — INT — Primary key — NOT NULL
  • MATERIAL_DOCUMENT_ID — VARCHAR(10) — Foreign key → GOODS_ISSUE_H.MATERIAL_DOCUMENT_ID — NOT NULL
  • FISCAL_YEAR — SMALLINT — Foreign key → GOODS_ISSUE_H.FISCAL_YEAR — NOT NULL
  • DELIVERY_ID — VARCHAR(10) — Foreign key → DELIVERY_I.DELIVERY_ID — NOT NULL
  • DELIVERY_ITEM_NO — INT — Foreign key → DELIVERY_I.ITEM_NO — NOT NULL
  • MATERIAL_ID — VARCHAR(18) — Foreign key → MATERIAL_PLANT.MATERIAL_ID — NOT NULL
  • PLANT_ID — VARCHAR(4) — Foreign key → STORAGE_LOCATION.PLANT_ID — NOT NULL
  • STORAGE_LOCATION_ID — VARCHAR(4) — Foreign key → STORAGE_LOCATION.STORAGE_LOCATION_ID — NOT NULL

INVENTORY_BALANCE

  • MATERIAL_ID — VARCHAR(18) — Foreign key → MATERIAL_PLANT.MATERIAL_ID — NOT NULL
  • PLANT_ID — VARCHAR(4) — Foreign key → STORAGE_LOCATION.PLANT_ID — NOT NULL
  • STORAGE_LOCATION_ID — VARCHAR(4) — Foreign key → STORAGE_LOCATION.STORAGE_LOCATION_ID — NOT NULL

ITEM_PROPOSAL

  • PROPOSAL_ID — VARCHAR(12) — Primary key — NOT NULL
  • CUSTOMER_ID — VARCHAR(10) — Foreign key → CUSTOMER.CUSTOMER_ID — NOT NULL
  • MATERIAL_ID — VARCHAR(18) — Foreign key → MATERIAL_PLANT.MATERIAL_ID — NOT NULL
  • PLANT_ID — VARCHAR(4) — Foreign key → MATERIAL_PLANT.PLANT_ID — NOT NULL

MATERIAL

  • MATERIAL_ID — VARCHAR(18) — Primary key — NOT NULL

MATERIAL_PLANT

  • MATERIAL_ID — VARCHAR(18) — Foreign key → MATERIAL.MATERIAL_ID — NOT NULL
  • PLANT_ID — VARCHAR(4) — Foreign key → STORAGE_LOCATION.PLANT_ID — NOT NULL
  • DEFAULT_STORAGE_LOCATION_ID — VARCHAR(4) — Foreign key → STORAGE_LOCATION.STORAGE_LOCATION_ID

PLANT

  • PLANT_ID — VARCHAR(4) — Primary key — NOT NULL

SALES_ORDER_H

  • SALES_ORDER_ID — VARCHAR(10) — Primary key — NOT NULL
  • CUSTOMER_ID — VARCHAR(10) — Foreign key → CUSTOMER.CUSTOMER_ID — NOT NULL

SALES_ORDER_I

  • ITEM_NO — INT — Primary key — NOT NULL
  • SALES_ORDER_ID — VARCHAR(10) — Foreign key → SALES_ORDER_H.SALES_ORDER_ID — NOT NULL
  • MATERIAL_ID — VARCHAR(18) — Foreign key → MATERIAL_PLANT.MATERIAL_ID — NOT NULL
  • PLANT_ID — VARCHAR(4) — Foreign key → MATERIAL_PLANT.PLANT_ID — NOT NULL
  • PROPOSAL_ID — VARCHAR(12) — Foreign key → ITEM_PROPOSAL.PROPOSAL_ID

STORAGE_LOCATION

  • STORAGE_LOCATION_ID — VARCHAR(4) — Primary key — NOT NULL
  • PLANT_ID — VARCHAR(4) — Foreign key → PLANT.PLANT_ID — NOT NULL