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 |
---|