Process batch (inflow product)
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 | |||||
claim duration | TIME | X | X | X | |||||||
code | STRING | 80 | X | process batch | code | X | X | X | X | X | |
external code | STRING | 80 | X | X | X | ||||||
external product code | STRING | 80 | X | X | X | ||||||
last modified | DATE | X | X | X | |||||||
model name | STRING | 80 | X | process batch, product | X | ||||||
product code | STRING | 80 | X | product | code | X | X | X | X | X | inflow product |
required quantity (factor) | REAL | X | X | X | |||||||
required quantity (fixed) | REAL | X | X | X | |||||||
unique key | STRING | 255 | X | X | X | X | [process batch]code (padded with spaces to 80 characters) + [product]code (padded with spaces to 80 characters) | ||||
[process batch]custom data 01 | STRING | 80 | X | ||||||||
[process batch]custom data 02 | STRING | 80 | X | ||||||||
[process batch]custom data 03 | STRING | 80 | X | ||||||||
[process batch]custom data 04 | STRING | 80 | X | ||||||||
[process batch]custom data 05 | STRING | 80 | X | ||||||||
[process batch]custom data 06 | STRING | 80 | X | ||||||||
[process batch]custom data 07 | STRING | 80 | X | ||||||||
[process batch]custom data 08 | STRING | 80 | X | ||||||||
[process batch]custom data 09 | STRING | 80 | X | ||||||||
[process batch]custom data 10 | STRING | 80 | X | ||||||||
[process batch]custom data 11 | STRING | 80 | X | ||||||||
[process batch]custom data 12 | STRING | 80 | X | ||||||||
[process batch]custom data 13 | STRING | 80 | X | ||||||||
[process batch]custom data 14 | STRING | 80 | X | ||||||||
[process batch]custom data 15 | STRING | 80 | X | ||||||||
[process batch]custom date+time 01 | DATE | X | |||||||||
[process batch]custom date+time 02 | DATE | X | |||||||||
[process batch]custom date+time 03 | DATE | X | |||||||||
[process batch]custom date+time 04 | DATE | X | |||||||||
[process batch]custom date+time 05 | DATE | X | |||||||||
[process batch]custom date+time 06 | DATE | X | |||||||||
[process batch]custom date+time 07 | DATE | X | |||||||||
[process batch]custom date+time 08 | DATE | X | |||||||||
[process batch]custom date+time 09 | DATE | X | |||||||||
[process batch]custom date+time 10 | DATE | X | |||||||||
[process batch]custom value 01 | REAL | X | |||||||||
[process batch]custom value 02 | REAL | X | |||||||||
[process batch]custom value 03 | REAL | X | |||||||||
[process batch]custom value 04 | REAL | X | |||||||||
[process batch]custom value 05 | REAL | X | |||||||||
[process batch]custom value 06 | REAL | X | |||||||||
[process batch]custom value 07 | REAL | X | |||||||||
[process batch]custom value 08 | REAL | X | |||||||||
[process batch]custom value 09 | REAL | X | |||||||||
[process batch]custom value 10 | REAL | X | |||||||||
[product]custom data 01 | STRING | 80 | X | ||||||||
[product]custom data 02 | STRING | 80 | X | ||||||||
[product]custom data 03 | STRING | 80 | X | ||||||||
[product]custom data 04 | STRING | 80 | X | ||||||||
[product]custom data 05 | STRING | 80 | X | ||||||||
[product]custom data 06 | STRING | 80 | X | ||||||||
[product]custom data 07 | STRING | 80 | X | ||||||||
[product]custom data 08 | STRING | 80 | X | ||||||||
[product]custom data 09 | STRING | 80 | X | ||||||||
[product]custom data 10 | STRING | 80 | X | ||||||||
[product]custom data 11 | STRING | 80 | X | ||||||||
[product]custom data 12 | STRING | 80 | X | ||||||||
[product]custom data 13 | STRING | 80 | X | ||||||||
[product]custom data 14 | STRING | 80 | X | ||||||||
[product]custom data 15 | STRING | 80 | X | ||||||||
[product]custom date+time 01 | DATE | X | |||||||||
[product]custom date+time 02 | DATE | X | |||||||||
[product]custom date+time 03 | DATE | X | |||||||||
[product]custom date+time 04 | DATE | X | |||||||||
[product]custom date+time 05 | DATE | X | |||||||||
[product]custom date+time 06 | DATE | X | |||||||||
[product]custom date+time 07 | DATE | X | |||||||||
[product]custom date+time 08 | DATE | X | |||||||||
[product]custom date+time 09 | DATE | X | |||||||||
[product]custom date+time 10 | DATE | X | |||||||||
[product]custom value 01 | REAL | X | |||||||||
[product]custom value 02 | REAL | X | |||||||||
[product]custom value 03 | REAL | X | |||||||||
[product]custom value 04 | REAL | X | |||||||||
[product]custom value 05 | REAL | X | |||||||||
[product]custom value 06 | REAL | X | |||||||||
[product]custom value 07 | REAL | X | |||||||||
[product]custom value 08 | REAL | X | |||||||||
[product]custom value 09 | REAL | X | |||||||||
[product]custom value 10 | REAL | X | |||||||||