Mandatory and Optional Columns
The following table indicates which columns are mandatory or optional:
| Entity Type | Mandatory Columns | Optional Columns |
|---|---|---|
| FSI_PARTY | ID(VARCHAR2)
PARTY_TYPE(VARCHAR2) STATUS(VARCHAR2) OWNED_BY(VARCHAR2) CREATED_BY(VARCHAR2) CREATED_ON(TIMESTAMP(6)) VERSION(NUMBER), DELETED(NUMBER) (0 for not deleted, 1 for deleted) |
PARTY_REF(VARCHAR2)
NAME(VARCHAR2) SUB_TYPE(VARCHAR2) PARENT_PARTY_ID(VARCHAR2) UPDATED_BY(VARCHAR2) UPDATED_ON(TIMESTAMP(6)) |
| PARTY_CHARACTERISTIC | ID(VARCHAR2)
PARTY_ID(VARCHAR2) (the party to relate to) CHARACTERISTIC_NAME(VARCHAR2) CHARACTERISTIC_VALUE(VARCHAR2) |
N/A |
| ITEM | ID(VARCHAR2)
PRODUCT_ID(VARCHAR2) ITEM_TYPE(VARCHAR2) STATUS(VARCHAR2) PARTY_ID(VARCHAR2) START_DATE(TIMESTAMP(6)) OWNED_BY(VARCHAR2) CREATED_BY(VARCHAR2) CREATED_ON(TIMESTAMP(6)) VERSION(NUMBER) DELETED(NUMBER) (0 for not deleted, 1 for deleted) |
ITEM_REF(VARCHAR2)
PRODUCT_VERSION(VARCHAR2) NAME(VARCHAR2) SUB_TYPE(VARCHAR2) END_DATE(TIMESTAMP(6)) UPDATED_BY(VARCHAR2) UPDATED_ON(TIMESTAMP(6)) |
| ITEM_CHARACTERISTIC | ID(VARCHAR2)
ITEM_ID(VARCHAR2) (the item to relate to) CHARACTERISTIC_NAME(VARCHAR2) CHARACTERISTIC_VALUE(VARCHAR2) |
N/A |
| ITEM_RELATIONSHIP | ID(VARCHAR2)
ITEM_ID(VARCHAR2) (the item to relate to) FORWARD_TYPE(VARCHAR2) REVERSE_TYPE(VARCHAR2) CHILD_ITEM_ID(NUMBER) (the child item to relate to) |
N/A |
| ITEM_ORDER | ITEM_ID(VARCHAR2) (the item to relate to)
ID(VARCHAR2) ORDER_REF(VARCHAR2) ORDER_DATE(TIMESTAMP(6)) LINE_NUMBER(VARCHAR2) LINE_ACTION(VARCHAR2) |
LINE_ACTION_MODE(VARCHAR2)
PLAN_ITEM_ID(VARCHAR2) PLAN_ITEM_ACTION(VARCHAR2) |
| ITEM_ORDER_COMMENTS | ORDER_ID
COMMENT_DETAIL |
N/A |