Workbench Export

The Workbench Export is an export-only format. All columns below will be present in the export, although additional columns may be added or the order changed in future versions of Intuiflow.

Column Name

Type

Max Length

Values

Priority

integer

lower numbers mean higher priority

% of Buffer

decimal

18.5

Part Number

text

50

Location

text

32

Rev

text

10

Description

text

2GB

1 billion characters

Spike

boolean

Is Order Spike

R+ Alert

decimal

18.5

Reorder Qty

decimal

18.5

Reorder Qty (From)

decimal

18.5

On Hand

decimal

18.5

Supply Orders

decimal

18.5

Supply Order Follow Up By

date

Supply Order Note

text

255

Demand Allocations

decimal

18.5

Net Flow

decimal

18.5

Targeted Inventory

decimal

18.5

RPlus Lead Time

integer

InventoryPlanning

text

10

  • (valid buffer profile name for location)

  • RO = Replenishment Override

  • MM = Min/Max

  • NB = Non-Buffered

  • LTM = Lead Time Managed

Fixed Lead Time

integer

Effective Lead Time

integer

Goods Receipt Time

integer

ToG

decimal

18.5

Top Of Red

ToY

decimal

18.5

Top Of Yellow

ToR

decimal

18.5

Top Of Red

Issued Qty

decimal

18.5

Planner

text

25

Vendor

text

100

Part Type

integer

  • Buy

  • Make

  • Distributed

Material Type

text

50

Unit Of Measure

text

20

Unit Of Measure (From)

text

20

Unit Of Measure (From) Quantity

decimal

18.5

Unit Of Measure (To)

text

20

Unit Of Measure (To) Quantity

decimal

18.5

Unit Of Measure (To) Rounding Digits

integer

Average Daily Use

decimal

18.5

Adjustment Factor Value

decimal

18.5

Planned Adjustment Factor

User Defined 1

text

400

User Defined 2

text

400

User Defined 3

text

400

User Defined 4

text

400

User Defined 5

text

400

User Defined 6

text

400

User Defined 7

text

400

User Defined 8

text

400

User Defined 9

text

400

User Defined 10

text

400

User Defined 11

text

400

User Defined 12

text

400

User Defined 13

text

400

User Defined 14

text

400

User Defined 15

text

400

User Defined 16

text

400

Schedule Order Date

date

Request Date

date

Order Receipt Date

date

Vendor ID

text

100

Vendor Identifier

Forecasted Daily Usage

decimal

18.5

Effective Daily Usage

decimal

18.5

Alert Type

text

100

  • CurrentInventoryAlert

  • ProjectedStockOutAlert

  • MaterialSynchronizationAlert

  • LeadTimeManagedSummary

Alert Status

text

100

  • STOCK OUT

  • STOCK OUT WITH DEMAND

  • (date of alert)

Availability Shortage

boolean

Material Availability Shortage

Raw Materials Cost

decimal

18.5

Order Notes

text

  • Inactive

  • OToG = Over Top Of Green

Auto Approve Recommended Orders

boolean

Source ERP

text

Days Until Yellow

integer

Net Flow - ToG

decimal

18.5

On Hand - Demand Allocations

decimal

18.5

Last updated