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