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