Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Journal Template Name (Journal Template Name) | Code10 |
|
NotBlank: Yes |
| 2 | Line No. (Line No.) | Integer | NotBlank: Yes Editable: No |
|
| 3 | Item No. (Item No.) | Code20 |
|
|
| 5 | Entry Type (Entry Type) | Option | [Purchase,Sale,Positive Adjmt.,Negative Adjmt.,Transfer,Consumption,Output, ,Assembly Consumption,Assembly Output] | |
| 8 | Description (Description) | Text50 | ||
| 9 | Location Code (Location Code) | Code10 |
|
|
| 10 | Inventory Posting Group (Inventory Posting Group) | Code20 |
|
Editable: No |
| 13 | Quantity (Quantity) | Decimal (0:5) | ||
| 16 | Unit Amount (Unit Amount) | Decimal | AutoFormatType: 2 | |
| 17 | Unit Cost (Unit Cost) | Decimal | AutoFormatType: 2 | |
| 18 | Amount (Amount) | Decimal | AutoFormatType: 1 | |
| 23 | Salespers./Purch. Code (Salespers./Purch. Code) | Code20 |
|
|
| 26 | Source Code (Source Code) | Code10 |
|
Editable: No |
| 34 | Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
| 35 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
| 37 | Indirect Cost % (Indirect Cost %) | Decimal (0:5) | ||
| 41 | Standard Journal Code (Standard Journal Code) | Code10 |
|
|
| 42 | Reason Code (Reason Code) | Code10 |
|
|
| 47 | Transaction Type (Transaction Type) | Code10 |
|
|
| 48 | Transport Method (Transport Method) | Code10 |
|
|
| 49 | Country/Region Code (Country/Region Code) | Code10 |
|
|
| 53 | Qty. (Calculated) (Qty. (Calculated)) | Decimal (0:5) | Editable: No | |
| 54 | Qty. (Phys. Inventory) (Qty. (Phys. Inventory)) | Decimal (0:5) | ||
| 56 | Phys. Inventory (Phys. Inventory) | Boolean | Editable: No | |
| 57 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code20 |
|
|
| 58 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code20 |
|
|
| 59 | Entry/Exit Point (Entry/Exit Point) | Code10 |
|
|
| 63 | Area (Area) | Code10 |
|
|
| 64 | Transaction Specification (Transaction Specification) | Code10 |
|
|
| 65 | Posting No. Series (Posting No. Series) | Code20 |
|
|
| 480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
| 5402 | Variant Code (Variant Code) | Code10 |
|
|
| 5403 | Bin Code (Bin Code) | Code20 |
|
|
| 5404 | Qty. per Unit of Measure (Qty. per Unit of Measure) | Decimal (0:5) | InitValue: 1 | Editable: No |
| 5407 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
| 5413 | Quantity (Base) (Quantity (Base)) | Decimal (0:5) | ||
| 5701 | Originally Ordered No. (Originally Ordered No.) | Code20 |
|
|
| 5702 | Originally Ordered Var. Code (Originally Ordered Var. Code) | Code10 |
|
|
| 5704 | Item Category Code (Item Category Code) | Code20 |
|
|
| 5705 | Nonstock (Nonstock) | Boolean | ||
| 5706 | Purchasing Code (Purchasing Code) | Code10 |
|
|
| 5707 | Product Group Code (Product Group Code) | Code10 |
|
|
| 5800 | Value Entry Type (Value Entry Type) | Option | [Direct Cost,Revaluation,Rounding,Indirect Cost,Variance] | |
| 5801 | Item Charge No. (Item Charge No.) | Code20 |
|
|
| 5817 | Correction (Correction) | Boolean | ||
| 5839 | Work Center No. (Work Center No.) | Code20 |
|
Editable: No |
| 6600 | Return Reason Code (Return Reason Code) | Code10 |
|
|
| 99000755 | Overhead Rate (Overhead Rate) | Decimal (0:5) |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Journal Template Name,Standard Journal Code,Line No. (Journal Template Name,Standard Journal Code,Line No.) | Clustered: Yes |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Area (Area) | Area | Code (Code) |
|
1..n |
| Bin Code (Bin Code) | Bin | Code (Code) |
|
1..n |
| Bin Code (Bin Code) | Bin Content | Bin Code (Bin Code) |
|
1..n |
| Country/Region Code (Country/Region Code) | Country/Region | Code (Code) |
|
1..n |
| Dimension Set ID (Dimension Set ID) | Dimension Set Entry | () |
|
1..n |
| Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
| Entry/Exit Point (Entry/Exit Point) | Entry/Exit Point | Code (Code) |
|
1..n |
| Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Gen. Business Posting Group | Code (Code) |
|
1..n |
| Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Gen. Product Posting Group | Code (Code) |
|
1..n |
| Inventory Posting Group (Inventory Posting Group) | Inventory Posting Group | Code (Code) |
|
1..n |
| Originally Ordered No. (Originally Ordered No.) | Item | No. (No.) |
|
1..n |
| Item Category Code (Item Category Code) | Item Category | Code (Code) |
|
1..n |
| Item Charge No. (Item Charge No.) | Item Charge | No. (No.) |
|
1..n |
| Journal Template Name (Journal Template Name) | Item Journal Template | Name (Name) |
|
1..n |
| Unit of Measure Code (Unit of Measure Code) | Item Unit of Measure | Code (Code) |
|
1..n |
| Originally Ordered Var. Code (Originally Ordered Var. Code) | Item Variant | Code (Code) |
|
1..n |
| Location Code (Location Code) | Location | Code (Code) |
|
1..n |
| Posting No. Series (Posting No. Series) | No. Series | Code (Code) |
|
1..n |
| Purchasing Code (Purchasing Code) | Purchasing | Code (Code) |
|
1..n |
| Reason Code (Reason Code) | Reason Code | Code (Code) |
|
1..n |
| Return Reason Code (Return Reason Code) | Return Reason | Code (Code) |
|
1..n |
| Salespers./Purch. Code (Salespers./Purch. Code) | Salesperson/Purchaser | Code (Code) |
|
1..n |
| Source Code (Source Code) | Source Code | Code (Code) |
|
1..n |
| Standard Journal Code (Standard Journal Code) | Standard Item Journal | Code (Code) |
|
1..n |
| Transaction Specification (Transaction Specification) | Transaction Specification | Code (Code) |
|
1..n |
| Transaction Type (Transaction Type) | Transaction Type | Code (Code) |
|
1..n |
| Transport Method (Transport Method) | Transport Method | Code (Code) |
|
1..n |
| Work Center No. (Work Center No.) | Work Center | No. (No.) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field |
|---|