Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
2 | Buy-from Vendor No. | Code20 |
|
Editable: No |
3 | Document No. | Code20 |
|
|
4 | Line No. | Integer | ||
5 | Type | Option | [ ,G/L Account,Item,,Fixed Asset,Charge (Item)] | |
6 | No. | Code20 |
|
|
7 | Location Code | Code10 |
|
|
8 | Posting Group | Code20 |
|
Editable: No |
11 | Description | Text50 | ||
12 | Description 2 | Text50 | ||
13 | Unit of Measure | Text10 | ||
15 | Quantity | Decimal (0:5) | ||
22 | Direct Unit Cost | Decimal | AutoFormatType: 2 AutoFormatExpr: GetCurrencyCode |
|
23 | Unit Cost (LCY) | Decimal | AutoFormatType: 2 | |
25 | VAT % | Decimal (0:5) | Editable: No | |
27 | Line Discount % | Decimal (0:5) | MaxValue: 100 | |
31 | Unit Price (LCY) | Decimal | AutoFormatType: 2 | |
32 | Allow Invoice Disc. | Boolean | InitValue: Yes | |
34 | Gross Weight | Decimal (0:5) | ||
35 | Net Weight | Decimal (0:5) | ||
36 | Units per Parcel | Decimal (0:5) | ||
37 | Unit Volume | Decimal (0:5) | ||
38 | Appl.-to Item Entry | Integer | AccessByPermission: TableData 27=R | |
39 | Item Shpt. Entry No. | Integer | ||
40 | Shortcut Dimension 1 Code | Code20 | CaptionClass: '1,2,1'
|
|
41 | Shortcut Dimension 2 Code | Code20 | CaptionClass: '1,2,2'
|
|
45 | Job No. | Code20 |
|
|
54 | Indirect Cost % | Decimal (0:5) | ||
61 | Quantity Invoiced | Decimal (0:5) | Editable: No | |
68 | Pay-to Vendor No. | Code20 |
|
Editable: No |
70 | Vendor Item No. | Text20 | ||
74 | Gen. Bus. Posting Group | Code20 |
|
|
75 | Gen. Prod. Posting Group | Code20 |
|
|
77 | VAT Calculation Type | Option | [Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax] | |
78 | Transaction Type | Code10 |
|
|
79 | Transport Method | Code10 |
|
|
80 | Attached to Line No. | Integer |
|
|
81 | Entry Point | Code10 |
|
|
82 | Area | Code10 |
|
|
83 | Transaction Specification | Code10 |
|
|
85 | Tax Area Code | Code20 |
|
|
86 | Tax Liable | Boolean | ||
87 | Tax Group Code | Code20 |
|
|
88 | Use Tax | Boolean | ||
89 | VAT Bus. Posting Group | Code20 |
|
|
90 | VAT Prod. Posting Group | Code20 |
|
|
91 | Currency Code | Code10 |
|
Editable: No FlowField |
97 | Blanket Order No. | Code20 | AccessByPermission: TableData 6650=R
|
|
98 | Blanket Order Line No. | Integer | AccessByPermission: TableData 6650=R
|
|
99 | VAT Base Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
Editable: No |
100 | Unit Cost | Decimal | AutoFormatType: 2 AutoFormatExpr: GetCurrencyCode |
Editable: No |
131 | Posting Date | Date | ||
480 | Dimension Set ID | Integer |
|
Editable: No |
1001 | Job Task No. | Code20 |
|
|
5401 | Prod. Order No. | Code20 | ||
5402 | Variant Code | Code10 |
|
|
5403 | Bin Code | Code20 |
|
|
5404 | Qty. per Unit of Measure | Decimal (0:5) | Editable: No | |
5407 | Unit of Measure Code | Code10 |
|
|
5415 | Quantity (Base) | Decimal (0:5) | ||
5461 | Qty. Invoiced (Base) | Decimal (0:5) | Editable: No | |
5600 | FA Posting Date | Date | ||
5601 | FA Posting Type | Option | [ ,Acquisition Cost,Maintenance] | |
5602 | Depreciation Book Code | Code10 |
|
|
5603 | Salvage Value | Decimal | AutoFormatType: 1 | |
5605 | Depr. until FA Posting Date | Boolean | ||
5606 | Depr. Acquisition Cost | Boolean | ||
5609 | Maintenance Code | Code10 |
|
|
5610 | Insurance No. | Code20 |
|
|
5611 | Budgeted FA No. | Code20 |
|
|
5612 | Duplicate in Depreciation Book | Code10 |
|
|
5613 | Use Duplication List | Boolean | ||
5700 | Responsibility Center | Code10 |
|
|
5705 | Cross-Reference No. | Code20 | AccessByPermission: TableData 5717=R | |
5706 | Unit of Measure (Cross Ref.) | Code10 |
|
|
5707 | Cross-Reference Type | Option | [ ,Customer,Vendor,Bar Code] | |
5708 | Cross-Reference Type No. | Code30 | ||
5709 | Item Category Code | Code20 |
|
|
5710 | Nonstock | Boolean | ||
5711 | Purchasing Code | Code10 |
|
|
5712 | Product Group Code | Code10 |
|
|
5805 | Return Qty. Shipped Not Invd. | Decimal (0:5) | Editable: No | |
5811 | Item Charge Base Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
|
5817 | Correction | Boolean | Editable: No | |
6602 | Return Order No. | Code20 | Editable: No | |
6603 | Return Order Line No. | Integer | Editable: No | |
6608 | Return Reason Code | Code10 |
|
Keys
# | Fields | ||
---|---|---|---|
0 | Document No.,Line No. | Clustered: Yes | |
1 | Return Order No.,Return Order Line No. | ||
2 | Blanket Order No.,Blanket Order Line No. | ||
3 | Pay-to Vendor No. | ||
4 | Buy-from Vendor No. |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Area | Area | Code |
|
1..n |
Bin Code | Bin | Code |
|
1..n |
Duplicate in Depreciation Book | Depreciation Book | Code |
|
1..n |
Dimension Set ID | Dimension Set Entry |
|
1..n | |
Shortcut Dimension 2 Code | Dimension Value | Code |
|
1..n |
Entry Point | Entry/Exit Point | Code |
|
1..n |
Posting Group | FA Posting Group | Code |
|
1..n |
Budgeted FA No. | Fixed Asset | No. |
|
1..n |
No. | G/L Account | No. |
|
1..n |
Gen. Bus. Posting Group | Gen. Business Posting Group | Code |
|
1..n |
Gen. Prod. Posting Group | Gen. Product Posting Group | Code |
|
1..n |
Insurance No. | Insurance | No. |
|
1..n |
Posting Group | Inventory Posting Group | Code |
|
1..n |
No. | Item | No. |
|
1..n |
Item Category Code | Item Category | Code |
|
1..n |
No. | Item Charge | No. |
|
1..n |
Unit of Measure (Cross Ref.) | Item Unit of Measure | Code |
|
1..n |
Variant Code | Item Variant | Code |
|
1..n |
Job No. | Job | No. |
|
1..n |
Job Task No. | Job Task | Job Task No. |
|
1..n |
Location Code | Location |
|
1..n | |
Maintenance Code | Maintenance | Code |
|
1..n |
Purchasing Code | Purchasing | Code |
|
1..n |
Responsibility Center | Responsibility Center | Code |
|
1..n |
Return Reason Code | Return Reason | Code |
|
1..n |
Document No. | Return Shipment Header | No. |
|
1..n |
Attached to Line No. | Return Shipment Line | Line No. |
|
1..n |
Blanket Order No. | Sales Header | No. |
|
1..n |
Blanket Order Line No. | Sales Line | Line No. |
|
1..n |
Tax Area Code | Tax Area | Code |
|
1..n |
Tax Group Code | Tax Group | Code |
|
1..n |
Transaction Specification | Transaction Specification | Code |
|
1..n |
Transaction Type | Transaction Type | Code |
|
1..n |
Transport Method | Transport Method | Code |
|
1..n |
Unit of Measure Code | Unit of Measure | Code |
|
1..n |
VAT Bus. Posting Group | VAT Business Posting Group | Code |
|
1..n |
VAT Prod. Posting Group | VAT Product Posting Group | Code |
|
1..n |
Pay-to Vendor No. | Vendor | No. |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Item Charge Assignment (Purch) | Applies-to Doc. Line No. |
|
1..n |
Return Shipment Line | Attached to Line No. |
|
1..n |