Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Code (Code) | Code10 | NotBlank: Yes | |
2 | Name (Name) | Text50 | ||
130 | Default Bin Code (Default Bin Code) | Code20 |
|
|
5700 | Name 2 (Name 2) | Text50 | ||
5701 | Address (Address) | Text50 | ||
5702 | Address 2 (Address 2) | Text50 | ||
5703 | City (City) | Text30 |
|
|
5704 | Phone No. (Phone No.) | Text30 [Phone No.] | ||
5705 | Phone No. 2 (Phone No. 2) | Text30 [Phone No.] | ||
5706 | Telex No. (Telex No.) | Text30 | ||
5707 | Fax No. (Fax No.) | Text30 | ||
5713 | Contact (Contact) | Text50 | ||
5714 | Post Code (Post Code) | Code20 |
|
|
5715 | County (County) | Text30 | ||
5718 | E-Mail (E-Mail) | Text80 [E-Mail] | ||
5719 | Home Page (Home Page) | Text90 [URL] | ||
5720 | Country/Region Code (Country/Region Code) | Code10 |
|
|
5724 | Use As In-Transit (Use As In-Transit) | Boolean | AccessByPermission: TableData 5740=R | |
5726 | Require Put-away (Require Put-away) | Boolean | AccessByPermission: TableData 5771=R | |
5727 | Require Pick (Require Pick) | Boolean | AccessByPermission: TableData 5771=R | |
5728 | Cross-Dock Due Date Calc. (Cross-Dock Due Date Calc.) | DateFormula | AccessByPermission: TableData 5771=R | |
5729 | Use Cross-Docking (Use Cross-Docking) | Boolean | AccessByPermission: TableData 5771=R | |
5730 | Require Receive (Require Receive) | Boolean | AccessByPermission: TableData 7316=R | |
5731 | Require Shipment (Require Shipment) | Boolean | AccessByPermission: TableData 7320=R | |
5732 | Bin Mandatory (Bin Mandatory) | Boolean | AccessByPermission: TableData 5771=R | |
5733 | Directed Put-away and Pick (Directed Put-away and Pick) | Boolean | AccessByPermission: TableData 5771=R | |
5734 | Default Bin Selection (Default Bin Selection) | Option | [ ,Fixed Bin,Last-Used Bin] AccessByPermission: TableData 5771=R |
|
5790 | Outbound Whse. Handling Time (Outbound Whse. Handling Time) | DateFormula | AccessByPermission: TableData 14=R | |
5791 | Inbound Whse. Handling Time (Inbound Whse. Handling Time) | DateFormula | AccessByPermission: TableData 14=R | |
7305 | Put-away Template Code (Put-away Template Code) | Code10 |
|
|
7306 | Use Put-away Worksheet (Use Put-away Worksheet) | Boolean | AccessByPermission: TableData 5771=R | |
7307 | Pick According to FEFO (Pick According to FEFO) | Boolean | AccessByPermission: TableData 5771=R | |
7308 | Allow Breakbulk (Allow Breakbulk) | Boolean | AccessByPermission: TableData 5771=R | |
7309 | Bin Capacity Policy (Bin Capacity Policy) | Option | [Never Check Capacity,Allow More Than Max. Capacity,Prohibit More Than Max. Cap.] AccessByPermission: TableData 5771=R |
|
7313 | Open Shop Floor Bin Code (Open Shop Floor Bin Code) | Code20 |
|
|
7314 | To-Production Bin Code (To-Production Bin Code) | Code20 |
|
|
7315 | From-Production Bin Code (From-Production Bin Code) | Code20 |
|
|
7317 | Adjustment Bin Code (Adjustment Bin Code) | Code20 |
|
|
7319 | Always Create Put-away Line (Always Create Put-away Line) | Boolean | AccessByPermission: TableData 5771=R | |
7320 | Always Create Pick Line (Always Create Pick Line) | Boolean | AccessByPermission: TableData 5771=R | |
7321 | Special Equipment (Special Equipment) | Option | [ ,According to Bin,According to SKU/Item] AccessByPermission: TableData 5771=R |
|
7323 | Receipt Bin Code (Receipt Bin Code) | Code20 |
|
|
7325 | Shipment Bin Code (Shipment Bin Code) | Code20 |
|
|
7326 | Cross-Dock Bin Code (Cross-Dock Bin Code) | Code20 |
|
|
7330 | To-Assembly Bin Code (To-Assembly Bin Code) | Code20 |
|
|
7331 | From-Assembly Bin Code (From-Assembly Bin Code) | Code20 |
|
|
7332 | Asm.-to-Order Shpt. Bin Code (Asm.-to-Order Shpt. Bin Code) | Code20 |
|
|
7600 | Base Calendar Code (Base Calendar Code) | Code10 |
|
|
7700 | Use ADCS (Use ADCS) | Boolean | AccessByPermission: TableData 7700=R |
Keys
# | Fields | ||
---|---|---|---|
0 | Code (Code) | Clustered: Yes | |
1 | Name (Name) | ||
2 | Use As In-Transit,Bin Mandatory (Use As In-Transit,Bin Mandatory) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Base Calendar Code (Base Calendar Code) | Base Calendar | Code (Code) |
|
1..n |
Asm.-to-Order Shpt. Bin Code (Asm.-to-Order Shpt. Bin Code) | Bin | Code (Code) |
|
1..n |
Country/Region Code (Country/Region Code) | Country/Region | Code (Code) |
|
1..n |
Put-away Template Code (Put-away Template Code) | Put-away Template Header | Code (Code) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Action Message Entry | Location Code (Location Code) |
|
1..n |
Analysis Dim. Selection Buffer | New Dimension Value Code (New Dimension Value Code) |
|
1..n |
Analysis Line | Location Filter (Location Filter) |
|
1..n |
Assembly Header | Location Code (Location Code) |
|
1..n |
Assembly Line | Location Code (Location Code) |
|
1..n |
Assembly Setup | Default Location for Orders (Default Location for Orders) |
|
1..n |
Availability Calc. Overview | Location Code (Location Code) |
|
1..n |
Average Cost Calc. Overview | Location Code (Location Code) |
|
1..n |
Avg. Cost Adjmt. Entry Point | Location Code (Location Code) |
|
1..n |
BOM Buffer | Location Code (Location Code) |
|
1..n |
Bin | Location Code (Location Code) |
|
1..n |
Bin Content | Location Code (Location Code) |
|
1..n |
Bin Content Buffer | Location Code (Location Code) |
|
1..n |
Bin Creation Wksh. Name | Location Code (Location Code) |
|
1..n |
Bin Creation Worksheet Line | Location Code (Location Code) |
|
1..n |
Bin Template | Location Code (Location Code) |
|
1..n |
Company Information | Location Code (Location Code) |
|
1..n |
Customer | Location Code (Location Code) |
|
1..n |
FA Ledger Entry | Location Code (Location Code) |
|
1..n |
Fixed Asset | Location Code (Location Code) |
|
1..n |
Ins. Coverage Ledger Entry | Location Code (Location Code) |
|
1..n |
Insurance | Location Code (Location Code) |
|
1..n |
Internal Movement Header | Location Code (Location Code) |
|
1..n |
Internal Movement Line | Location Code (Location Code) |
|
1..n |
Inventory Adjustment Buffer | Location Code (Location Code) |
|
1..n |
Inventory Buffer | Location Code (Location Code) |
|
1..n |
Inventory Event Buffer | Location Code (Location Code) |
|
1..n |
Inventory Page Data | Location Code (Location Code) |
|
1..n |
Inventory Posting Setup | Location Code (Location Code) |
|
1..n |
Inventory Profile | Location Code (Location Code) |
|
1..n |
Invt. Post to G/L Test Buffer | Location Code (Location Code) |
|
1..n |
Item | Location Filter (Location Filter) |
|
1..n |
Item Analysis View Budg. Entry | Location Code (Location Code) |
|
1..n |
Item Analysis View Entry | Location Code (Location Code) |
|
1..n |
Item Budget Buffer | Location Code (Location Code) |
|
1..n |
Item Budget Entry | Location Code (Location Code) |
|
1..n |
Item Journal Buffer | Location Code (Location Code) |
|
1..n |
Item Journal Line | New Location Code (New Location Code) |
|
1..n |
Item Ledger Entry | Location Code (Location Code) |
|
1..n |
Item Statistics Buffer | Location Filter (Location Filter) |
|
1..n |
Item Substitution | Location Filter (Location Filter) |
|
1..n |
Item Tracing Buffer | Location Code (Location Code) |
|
1..n |
Job Journal Line | Location Code (Location Code) |
|
1..n |
Job Ledger Entry | Location Code (Location Code) |
|
1..n |
Job Planning Line | Location Code (Location Code) |
|
1..n |
Lot No. Information | Location Filter (Location Filter) |
|
1..n |
Machine Center | Location Code (Location Code) |
|
1..n |
Maintenance Ledger Entry | Location Code (Location Code) |
|
1..n |
Manufacturing Setup | Components at Location (Components at Location) |
|
1..n |
Order Promising Line | Location Code (Location Code) |
|
1..n |
Phys. Inventory Ledger Entry | Location Code (Location Code) |
|
1..n |
Phys. Invt. Item Selection | Location Code (Location Code) |
|
1..n |
Planning Assignment | Location Code (Location Code) |
|
1..n |
Planning Component | Location Code (Location Code) |
|
1..n |
Posted Assembly Header | Location Code (Location Code) |
|
1..n |
Posted Assembly Line | Location Code (Location Code) |
|
1..n |
Posted Invt. Pick Header | Destination No. (Destination No.) |
|
1..n |
Posted Invt. Pick Line | Destination No. (Destination No.) |
|
1..n |
Posted Invt. Put-away Header | Destination No. (Destination No.) |
|
1..n |
Posted Invt. Put-away Line | Destination No. (Destination No.) |
|
1..n |
Posted Whse. Receipt Header | Location Code (Location Code) |
|
1..n |
Posted Whse. Receipt Line | Location Code (Location Code) |
|
1..n |
Posted Whse. Shipment Header | Location Code (Location Code) |
|
1..n |
Posted Whse. Shipment Line | Destination No. (Destination No.) |
|
1..n |
Prod. Order Component | Location Code (Location Code) |
|
1..n |
Prod. Order Line | Location Code (Location Code) |
|
1..n |
Production Forecast Entry | Location Code (Location Code) |
|
1..n |
Production Order | Location Code (Location Code) |
|
1..n |
Purch. Cr. Memo Hdr. | Location Code (Location Code) |
|
1..n |
Purch. Cr. Memo Line | Location Code (Location Code) |
|
1..n |
Purch. Inv. Header | Location Code (Location Code) |
|
1..n |
Purch. Inv. Line | Location Code (Location Code) |
|
1..n |
Purch. Rcpt. Header | Location Code (Location Code) |
|
1..n |
Purch. Rcpt. Line | Location Code (Location Code) |
|
1..n |
Purchase Header | Location Filter (Location Filter) |
|
1..n |
Purchase Header Archive | Location Filter (Location Filter) |
|
1..n |
Purchase Line | Location Code (Location Code) |
|
1..n |
Purchase Line Archive | Location Code (Location Code) |
|
1..n |
Registered Invt. Movement Hdr. | Destination No. (Destination No.) |
|
1..n |
Registered Invt. Movement Line | Destination No. (Destination No.) |
|
1..n |
Registered Whse. Activity Hdr. | Location Code (Location Code) |
|
1..n |
Registered Whse. Activity Line | Destination No. (Destination No.) |
|
1..n |
Requisition Line | Transfer-from Code (Transfer-from Code) |
|
1..n |
Reservation Entry | Location Code (Location Code) |
|
1..n |
Resource Location | Location Code (Location Code) |
|
1..n |
Responsibility Center | Location Code (Location Code) |
|
1..n |
Return Reason | Default Location Code (Default Location Code) |
|
1..n |
Return Receipt Header | Location Code (Location Code) |
|
1..n |
Return Receipt Line | Location Code (Location Code) |
|
1..n |
Return Shipment Header | Location Code (Location Code) |
|
1..n |
Return Shipment Line | Location Code (Location Code) |
|
1..n |
Sales Cr.Memo Header | Location Code (Location Code) |
|
1..n |
Sales Cr.Memo Line | Location Code (Location Code) |
|
1..n |
Sales Header | Location Filter (Location Filter) |
|
1..n |
Sales Header Archive | Location Filter (Location Filter) |
|
1..n |
Sales Invoice Header | Location Code (Location Code) |
|
1..n |
Sales Invoice Line | Location Code (Location Code) |
|
1..n |
Sales Line | Location Code (Location Code) |
|
1..n |
Sales Line Archive | Location Code (Location Code) |
|
1..n |
Sales Shipment Header | Location Code (Location Code) |
|
1..n |
Sales Shipment Line | Location Code (Location Code) |
|
1..n |
Serial No. Information | Location Filter (Location Filter) |
|
1..n |
Service Cr.Memo Header | Location Code (Location Code) |
|
1..n |
Service Cr.Memo Line | Location Code (Location Code) |
|
1..n |
Service Header | Location Filter (Location Filter) |
|
1..n |
Service Invoice Header | Location Code (Location Code) |
|
1..n |
Service Invoice Line | Location Code (Location Code) |
|
1..n |
Service Ledger Entry | Location Code (Location Code) |
|
1..n |
Service Line | Location Code (Location Code) |
|
1..n |
Service Shipment Header | Location Code (Location Code) |
|
1..n |
Service Shipment Line | Location Code (Location Code) |
|
1..n |
Ship-to Address | Location Code (Location Code) |
|
1..n |
Standard Item Journal Line | Location Code (Location Code) |
|
1..n |
Stockkeeping Unit | Transfer-from Code (Transfer-from Code) |
|
1..n |
Stockkeeping Unit Comment Line | Location Code (Location Code) |
|
1..n |
Tracking Specification | Location Code (Location Code) |
|
1..n |
Transfer Header | Location Filter (Location Filter) |
|
1..n |
Transfer Line | Transfer-to Code (Transfer-to Code) |
|
1..n |
Transfer Receipt Header | In-Transit Code (In-Transit Code) |
|
1..n |
Transfer Receipt Line | Transfer-to Code (Transfer-to Code) |
|
1..n |
Transfer Route | In-Transit Code (In-Transit Code) |
|
1..n |
Transfer Shipment Header | In-Transit Code (In-Transit Code) |
|
1..n |
Transfer Shipment Line | Transfer-to Code (Transfer-to Code) |
|
1..n |
Untracked Planning Element | Location Code (Location Code) |
|
1..n |
Value Entry | Location Code (Location Code) |
|
1..n |
Vendor | Location Code (Location Code) |
|
1..n |
Warehouse Activity Header | Destination No. (Destination No.) |
|
1..n |
Warehouse Activity Line | Destination No. (Destination No.) |
|
1..n |
Warehouse Employee | Location Code (Location Code) |
|
1..n |
Warehouse Entry | Location Code (Location Code) |
|
1..n |
Warehouse Journal Batch | Location Code (Location Code) |
|
1..n |
Warehouse Journal Line | Location Code (Location Code) |
|
1..n |
Warehouse Receipt Header | Location Code (Location Code) |
|
1..n |
Warehouse Receipt Line | Location Code (Location Code) |
|
1..n |
Warehouse Request | Destination No. (Destination No.) |
|
1..n |
Warehouse Shipment Header | Location Code (Location Code) |
|
1..n |
Warehouse Shipment Line | Destination No. (Destination No.) |
|
1..n |
Whse. Cross-Dock Opportunity | Location Code (Location Code) |
|
1..n |
Whse. Internal Pick Header | Location Code (Location Code) |
|
1..n |
Whse. Internal Pick Line | Location Code (Location Code) |
|
1..n |
Whse. Internal Put-away Header | Location Code (Location Code) |
|
1..n |
Whse. Internal Put-away Line | Location Code (Location Code) |
|
1..n |
Whse. Item Tracking Line | Location Code (Location Code) |
|
1..n |
Whse. Pick Request | Location Code (Location Code) |
|
1..n |
Whse. Put-away Request | Location Code (Location Code) |
|
1..n |
Whse. Worksheet Line | Destination No. (Destination No.) |
|
1..n |
Whse. Worksheet Name | Location Code (Location Code) |
|
1..n |
Work Center | Location Code (Location Code) |
|
1..n |
Zone | Location Code (Location Code) |
|
1..n |