Stage (product group)
| Type | Length | PK | FK | Mode | Mandatory | Remarks | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Table | Field | Read | Write | Delete | Create | Update | |||||
| external product group code | STRING | 80 | X | X | X | ||||||
| external stage code | STRING | 80 | X | X | X | ||||||
| last modified | DATE | X | X | ||||||||
| model name | STRING | 80 | X | product group | model name | X | |||||
| product group code | STRING | 80 | X | product group | code | X | X | X | X | X | |
| stage code | STRING | 80 | X | stage | code | X | X | X | X | X | |
| type | NUM | X | X | X | 1 = main product; 2 = inflow product; 3 = by-product | ||||||
| unique key | STRING | 255 | X | X | X | X | [stage]code (padded with spaces to 80 characters) + [product group]code (padded with spaces to 80 characters) | ||||