Bucketizer
This table lists the time buckets that are available in bucketizer:
Note: The X icon indicates Yes. In Mode columns, X indicates that the fields are optional in the specified operation. Where noted as mandatory, the field is required in the specified action.
| Type | Length | PK | FK | Mode | Mandatory | Remarks | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Table | Field | Read | Write | Delete | Create | Update | |||||
| bucket begin | DATE | 3 | X | ||||||||
| bucket end | DATE | X | |||||||||
| bucket identifier (inactive) | DATE | X | |||||||||
| description | STRING | 80 | X | ||||||||
| end item | STRING | 80 | 2 | product | code | X | |||||
| filler1 | STRING | 1 | X | ||||||||
| filler2 | STRING | 1 | X | ||||||||
| filler3 | STRING | 1 | X | ||||||||
| filler4 | STRING | 1 | X | ||||||||
| filler5 | STRING | 1 | X | ||||||||
| filler6 | STRING | 1 | X | ||||||||
| identifier | DATE | X | |||||||||
| model name | STRING | 80 | X | X | |||||||
| quantity | REAL | X | |||||||||
| resource group | STRING | 80 | 1 | resource group | code | X | |||||
| site identifier | STRING | 80 | X | ||||||||
| unique key | STRING | 248 | X | [resource group]code (padded with spaces to 80 characters) + end item product (padded with spaces to 80 characters) + bucket begin (internal time format, 8 characters) + version (padded with spaces to 80 characters) | |||||||
| unit | STRING | 20 | X | ||||||||
| version | NUM | 4 | process step | version | X | ||||||