Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.
Select SQL
Insert SQL
Update SQL
Create SQL
176 COLUMNS | TOP
920 | 41 | F4102 Item Branch File
13 INDICIES | TOP
920 | 41 | F4102 Item Branch File
1: Branch Item (Primary/Unique)
| Element | Alias | Description | Sequence |
|---|
| 2 |
ITM |
Item Number - Short |
Ascending |
| 1 |
MCU |
Business Unit |
Ascending |
2: Item Branch
| Element | Alias | Description | Sequence |
|---|
| 2 |
MCU |
Business Unit |
Ascending |
| 1 |
ITM |
Item Number - Short |
Ascending |
3: Vend Item
| Element | Alias | Description | Sequence |
|---|
| 2 |
ITM |
Item Number - Short |
Ascending |
| 1 |
VEND |
Primary / Last Supplier Number |
Ascending |
4: Purch Category Code 5 Item
| Element | Alias | Description | Sequence |
|---|
| 2 |
ITM |
Item Number - Short |
Ascending |
| 1 |
PRP5 |
Purchasing Category Code 5 |
Ascending |
5: Planning Family Branch +
| Element | Alias | Description | Sequence |
|---|
| 3 |
MPST |
Planning Code |
Ascending |
| 2 |
MCU |
Business Unit |
Ascending |
| 1 |
PRP4 |
Master Planning Family |
Ascending |
6: Planner Branch +
| Element | Alias | Description | Sequence |
|---|
| 4 |
MPST |
Planning Code |
Ascending |
| 3 |
PRP4 |
Master Planning Family |
Ascending |
| 2 |
MCU |
Business Unit |
Ascending |
| 1 |
ANPL |
Planner Number |
Ascending |
7: Buyer Branch +
| Element | Alias | Description | Sequence |
|---|
| 4 |
MPST |
Planning Code |
Ascending |
| 3 |
PRP4 |
Master Planning Family |
Ascending |
| 2 |
MCU |
Business Unit |
Ascending |
| 1 |
BUYR |
Buyer Number |
Ascending |
8: Pool Item +
| Element | Alias | Description | Sequence |
|---|
| 3 |
MCU |
Business Unit |
Ascending |
| 2 |
ITM |
Item Number - Short |
Ascending |
| 1 |
PRP0 |
Item Pool |
Ascending |
10: Branch Purch Cat Code 7 +
| Element | Alias | Description | Sequence |
|---|
| 4 |
PRP9 |
Group - Warehouse Process 3 |
Ascending |
| 3 |
PRP8 |
Group - Warehouse Process 2 |
Ascending |
| 2 |
PRP7 |
Group - Warehouse Process 1 |
Ascending |
| 1 |
MCU |
Business Unit |
Ascending |
11: Low Level Item +
| Element | Alias | Description | Sequence |
|---|
| 3 |
MCU |
Business Unit |
Ascending |
| 2 |
ITM |
Item Number - Short |
Ascending |
| 1 |
LLX |
Low Level Code |
Ascending |
12: ATP Rule Name
| Element | Alias | Description | Sequence |
|---|
| 1 |
ATPRN |
ATP Rule Name |
Ascending |
13: Item Group Category Codes
| Element | Alias | Description | Sequence |
|---|
| 16 |
PRP7 |
Group - Warehouse Process 1 |
Ascending |
| 15 |
PRP6 |
Group - Item Dimension |
Ascending |
| 14 |
CYCL |
Cycle Count Category |
Ascending |
| 13 |
SHCM |
Shipping Commodity Class |
Ascending |
| 12 |
SHCN |
Shipping Conditions Code |
Ascending |
| 11 |
PRP5 |
Purchasing Category Code 5 |
Ascending |
| 10 |
PRP4 |
Master Planning Family |
Ascending |
| 9 |
PRP3 |
Supplier Rebate Code |
Ascending |
| 8 |
PRP2 |
Commodity Sub Class |
Ascending |
| 7 |
PRP1 |
Commodity Class |
Ascending |
| 6 |
SRP5 |
Sales Category Code 5 |
Ascending |
| 5 |
SRP4 |
Sales Category Code 4 |
Ascending |
| 4 |
SRP3 |
Sales Category Code 3 |
Ascending |
| 3 |
SRP2 |
Sub Section |
Ascending |
| 2 |
SRP1 |
Sales Catalog Section |
Ascending |
| 1 |
PRGR |
Item Price Group |
Ascending |
14: Stocking Type
| Element | Alias | Description | Sequence |
|---|
| 1 |
STKT |
Stocking Type |
Ascending |
ERPRef.com