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 |