Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Document Type | Option | [Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order] | |
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 | CaptionClass: GetCaptionClass(FIELDNO("No."))
|
|
7 | Location Code | Code10 |
|
|
8 | Posting Group | Code10 |
|
Editable: No |
10 | Expected Receipt Date | Date | AccessByPermission: TableData 120=R | |
11 | Description | Text50 |
|
|
12 | Description 2 | Text50 | ||
13 | Unit of Measure | Text10 | ||
15 | Quantity | Decimal (0:5) | ||
16 | Outstanding Quantity | Decimal (0:5) | Editable: No | |
17 | Qty. to Invoice | Decimal (0:5) | ||
18 | Qty. to Receive | Decimal (0:5) | AccessByPermission: TableData 120=R | |
22 | Direct Unit Cost | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Direct Unit Cost")) AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
|
23 | Unit Cost (LCY) | Decimal | AutoFormatType: 2 | |
25 | VAT % | Decimal (0:5) | Editable: No | |
27 | Line Discount % | Decimal (0:5) | MaxValue: 100 | |
28 | Line Discount Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
29 | Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
30 | Amount Including VAT | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
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 | |
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) | ||
56 | Recalculate Invoice Disc. | Boolean | Editable: No | |
57 | Outstanding Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
58 | Qty. Rcd. Not Invoiced | Decimal (0:5) | Editable: No | |
59 | Amt. Rcd. Not Invoiced | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
60 | Quantity Received | Decimal (0:5) | AccessByPermission: TableData 120=R | Editable: No |
61 | Quantity Invoiced | Decimal (0:5) | Editable: No | |
63 | Receipt No. | Code20 | Editable: No | |
64 | Receipt Line No. | Integer | Editable: No | |
67 | Profit % | Decimal (0:5) | Editable: No | |
68 | Pay-to Vendor No. | Code20 |
|
Editable: No |
69 | Inv. Discount Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
70 | Vendor Item No. | Text20 | ||
71 | Sales Order No. | Code20 |
|
Editable: No |
72 | Sales Order Line No. | Integer |
|
Editable: No |
73 | Drop Shipment | Boolean | AccessByPermission: TableData 223=R | Editable: No |
74 | Gen. Bus. Posting Group | Code10 |
|
|
75 | Gen. Prod. Posting Group | Code10 |
|
|
77 | VAT Calculation Type | Option | [Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax] | Editable: No |
78 | Transaction Type | Code10 |
|
|
79 | Transport Method | Code10 |
|
|
80 | Attached to Line No. | Integer |
|
Editable: No |
81 | Entry Point | Code10 |
|
|
82 | Area | Code10 |
|
|
83 | Transaction Specification | Code10 |
|
|
85 | Tax Area Code | Code20 |
|
|
86 | Tax Liable | Boolean | ||
87 | Tax Group Code | Code10 |
|
|
88 | Use Tax | Boolean | ||
89 | VAT Bus. Posting Group | Code10 |
|
|
90 | VAT Prod. Posting Group | Code10 |
|
|
91 | Currency Code | Code10 |
|
Editable: No |
92 | Outstanding Amount (LCY) | Decimal | AutoFormatType: 1 | Editable: No |
93 | Amt. Rcd. Not Invoiced (LCY) | Decimal | AutoFormatType: 1 AccessByPermission: TableData 120=R |
Editable: No |
95 | Reserved Quantity | Decimal (0:5) | AccessByPermission: TableData 120=R
|
Editable: No FlowField |
97 | Blanket Order No. | Code20 | AccessByPermission: TableData 120=R
|
|
98 | Blanket Order Line No. | Integer | AccessByPermission: TableData 120=R
|
|
99 | VAT Base Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
100 | Unit Cost | Decimal | AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
Editable: No |
101 | System-Created Entry | Boolean | Editable: No | |
103 | Line Amount | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Line Amount")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
104 | VAT Difference | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
105 | Inv. Disc. Amount to Invoice | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
106 | VAT Identifier | Code10 | Editable: No | |
107 | IC Partner Ref. Type | Option | [ ,G/L Account,Item,,,Charge (Item),Cross Reference,Common Item No.,Vendor Item No.] AccessByPermission: TableData 410=R |
|
108 | IC Partner Reference | Code20 | AccessByPermission: TableData 410=R | |
109 | Prepayment % | Decimal (0:5) | MaxValue: 100 | |
110 | Prepmt. Line Amount | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Prepmt. Line Amount")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
111 | Prepmt. Amt. Inv. | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Prepmt. Amt. Inv.")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
112 | Prepmt. Amt. Incl. VAT | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
113 | Prepayment Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
114 | Prepmt. VAT Base Amt. | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
115 | Prepayment VAT % | Decimal (0:5) | Editable: No | |
116 | Prepmt. VAT Calc. Type | Option | [Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax] | Editable: No |
117 | Prepayment VAT Identifier | Code10 | Editable: No | |
118 | Prepayment Tax Area Code | Code20 |
|
|
119 | Prepayment Tax Liable | Boolean | ||
120 | Prepayment Tax Group Code | Code10 |
|
|
121 | Prepmt Amt to Deduct | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Prepmt Amt to Deduct")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
122 | Prepmt Amt Deducted | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Prepmt Amt Deducted")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
123 | Prepayment Line | Boolean | Editable: No | |
124 | Prepmt. Amount Inv. Incl. VAT | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
129 | Prepmt. Amount Inv. (LCY) | Decimal | AutoFormatType: 1 | Editable: No |
130 | IC Partner Code | Code20 |
|
|
132 | Prepmt. VAT Amount Inv. (LCY) | Decimal | Editable: No | |
135 | Prepayment VAT Difference | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
136 | Prepmt VAT Diff. to Deduct | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
137 | Prepmt VAT Diff. Deducted | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
140 | Outstanding Amt. Ex. VAT (LCY) | Decimal | ||
141 | A. Rcd. Not Inv. Ex. VAT (LCY) | Decimal | ||
480 | Dimension Set ID | Integer |
|
Editable: No |
1001 | Job Task No. | Code20 |
|
|
1002 | Job Line Type | Option | [ ,Budget,Billable,Both Budget and Billable] AccessByPermission: TableData 167=R |
|
1003 | Job Unit Price | Decimal | AccessByPermission: TableData 167=R | BlankZero: Yes |
1004 | Job Total Price | Decimal | AccessByPermission: TableData 167=R | BlankZero: Yes Editable: No |
1005 | Job Line Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Job Currency Code" AccessByPermission: TableData 167=R |
BlankZero: Yes |
1006 | Job Line Discount Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Job Currency Code" AccessByPermission: TableData 167=R |
BlankZero: Yes |
1007 | Job Line Discount % | Decimal (0:5) | MaxValue: 100 AccessByPermission: TableData 167=R |
BlankZero: Yes |
1008 | Job Unit Price (LCY) | Decimal | AccessByPermission: TableData 167=R | BlankZero: Yes Editable: No |
1009 | Job Total Price (LCY) | Decimal | AccessByPermission: TableData 167=R | BlankZero: Yes Editable: No |
1010 | Job Line Amount (LCY) | Decimal | AutoFormatType: 1 AccessByPermission: TableData 167=R |
BlankZero: Yes Editable: No |
1011 | Job Line Disc. Amount (LCY) | Decimal | AutoFormatType: 1 AccessByPermission: TableData 167=R |
BlankZero: Yes Editable: No |
1012 | Job Currency Factor | Decimal | BlankZero: Yes | |
1013 | Job Currency Code | Code20 | ||
1019 | Job Planning Line No. | Integer | AccessByPermission: TableData 167=R | BlankZero: Yes |
1030 | Job Remaining Qty. | Decimal (0:5) | AccessByPermission: TableData 167=R | |
1031 | Job Remaining Qty. (Base) | Decimal | ||
1700 | Deferral Code | Code10 |
|
|
1702 | Returns Deferral Start Date | Date | ||
5401 | Prod. Order No. | Code20 | AccessByPermission: TableData 99000758=R
|
Editable: No |
5402 | Variant Code | Code10 |
|
|
5403 | Bin Code | Code20 |
|
|
5404 | Qty. per Unit of Measure | Decimal (0:5) | InitValue: 1 | Editable: No |
5407 | Unit of Measure Code | Code10 |
|
|
5415 | Quantity (Base) | Decimal (0:5) | ||
5416 | Outstanding Qty. (Base) | Decimal (0:5) | Editable: No | |
5417 | Qty. to Invoice (Base) | Decimal (0:5) | ||
5418 | Qty. to Receive (Base) | Decimal (0:5) | ||
5458 | Qty. Rcd. Not Invoiced (Base) | Decimal (0:5) | Editable: No | |
5460 | Qty. Received (Base) | Decimal (0:5) | Editable: No | |
5461 | Qty. Invoiced (Base) | Decimal (0:5) | Editable: No | |
5495 | Reserved Qty. (Base) | Decimal (0:5) |
|
Editable: No FlowField |
5600 | FA Posting Date | Date | ||
5601 | FA Posting Type | Option | [ ,Acquisition Cost,Maintenance] AccessByPermission: TableData 5600=R |
|
5602 | Depreciation Book Code | Code10 |
|
|
5603 | Salvage Value | Decimal | AutoFormatType: 1 | |
5605 | Depr. until FA Posting Date | Boolean | AccessByPermission: TableData 5600=R | |
5606 | Depr. Acquisition Cost | Boolean | AccessByPermission: TableData 5600=R | |
5609 | Maintenance Code | Code10 |
|
|
5610 | Insurance No. | Code20 |
|
|
5611 | Budgeted FA No. | Code20 |
|
|
5612 | Duplicate in Depreciation Book | Code10 |
|
|
5613 | Use Duplication List | Boolean | AccessByPermission: TableData 5600=R | |
5700 | Responsibility Center | Code10 |
|
Editable: No |
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 | AccessByPermission: TableData 5718=R | |
5711 | Purchasing Code | Code10 |
|
Editable: No |
5712 | Product Group Code | Code10 |
|
|
5713 | Special Order | Boolean | ||
5714 | Special Order Sales No. | Code20 | AccessByPermission: TableData 223=R
|
|
5715 | Special Order Sales Line No. | Integer | AccessByPermission: TableData 223=R
|
|
5750 | Whse. Outstanding Qty. (Base) | Decimal (0:5) | AccessByPermission: TableData 14=R
|
BlankZero: Yes Editable: No FlowField |
5752 | Completely Received | Boolean | Editable: No | |
5790 | Requested Receipt Date | Date | AccessByPermission: TableData 99000880=R | |
5791 | Promised Receipt Date | Date | AccessByPermission: TableData 99000880=R | |
5792 | Lead Time Calculation | DateFormula | AccessByPermission: TableData 120=R | |
5793 | Inbound Whse. Handling Time | DateFormula | AccessByPermission: TableData 14=R | |
5794 | Planned Receipt Date | Date | AccessByPermission: TableData 99000880=R | |
5795 | Order Date | Date | AccessByPermission: TableData 120=R | |
5800 | Allow Item Charge Assignment | Boolean | InitValue: Yes AccessByPermission: TableData 5800=R |
|
5801 | Qty. to Assign | Decimal (0:5) |
|
Editable: No FlowField |
5802 | Qty. Assigned | Decimal (0:5) |
|
Editable: No FlowField |
5803 | Return Qty. to Ship | Decimal (0:5) | AccessByPermission: TableData 6650=R | |
5804 | Return Qty. to Ship (Base) | Decimal (0:5) | ||
5805 | Return Qty. Shipped Not Invd. | Decimal (0:5) | Editable: No | |
5806 | Ret. Qty. Shpd Not Invd.(Base) | Decimal (0:5) | Editable: No | |
5807 | Return Shpd. Not Invd. | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
5808 | Return Shpd. Not Invd. (LCY) | Decimal | AutoFormatType: 1 | Editable: No |
5809 | Return Qty. Shipped | Decimal (0:5) | AccessByPermission: TableData 6650=R | Editable: No |
5810 | Return Qty. Shipped (Base) | Decimal (0:5) | Editable: No | |
6600 | Return Shipment No. | Code20 | Editable: No | |
6601 | Return Shipment Line No. | Integer | Editable: No | |
6608 | Return Reason Code | Code10 |
|
|
99000750 | Routing No. | Code20 |
|
|
99000751 | Operation No. | Code10 |
|
Editable: No |
99000752 | Work Center No. | Code20 |
|
Editable: No |
99000753 | Finished | Boolean | ||
99000754 | Prod. Order Line No. | Integer |
|
Editable: No |
99000755 | Overhead Rate | Decimal (0:5) | ||
99000756 | MPS Order | Boolean | ||
99000757 | Planning Flexibility | Option | [Unlimited,None] | |
99000758 | Safety Lead Time | DateFormula | ||
99000759 | Routing Reference No. | Integer |
Keys
# | Fields | ||
---|---|---|---|
0 | Document Type,Document No.,Line No. | SumIndexFields: Amount,Amount Including VAT | Clustered: Yes MaintainSIFTIndex: No |
1 | Document No.,Line No.,Document Type | ||
2 | Document Type,Type,No.,Variant Code,Drop Shipment,Location Code,Expected Receipt Date | SumIndexFields: Outstanding Qty. (Base) | MaintainSIFTIndex: No |
3 | Document Type,Pay-to Vendor No.,Currency Code | SumIndexFields: Outstanding Amount,Amt. Rcd. Not Invoiced,Outstanding Amount (LCY),Amt. Rcd. Not Invoiced (LCY) | MaintainSIFTIndex: No |
4 | Document Type,Type,No.,Variant Code,Drop Shipment,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Location Code,Expected Receipt Date | SumIndexFields: Outstanding Qty. (Base) | MaintainSQLIndex: No MaintainSIFTIndex: No |
5 | Document Type,Pay-to Vendor No.,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Currency Code | SumIndexFields: Outstanding Amount,Amt. Rcd. Not Invoiced,Outstanding Amount (LCY),Amt. Rcd. Not Invoiced (LCY) | MaintainSQLIndex: No MaintainSIFTIndex: No |
6 | Document Type,Blanket Order No.,Blanket Order Line No. | ||
7 | Document Type,Type,Prod. Order No.,Prod. Order Line No.,Routing No.,Operation No. | ||
8 | Document Type,Document No.,Location Code | ||
9 | Document Type,Receipt No.,Receipt Line No. | ||
10 | Type,No.,Variant Code,Drop Shipment,Location Code,Document Type,Expected Receipt Date | MaintainSQLIndex: No | |
11 | Document Type,Buy-from Vendor No. | ||
12 | Document Type,Job No.,Job Task No. | SumIndexFields: Outstanding Amt. Ex. VAT (LCY),A. Rcd. Not Inv. Ex. VAT (LCY) | |
13 | Document Type,Document No.,Type,No. | ||
14 | Document Type,Type,No. | SumIndexFields: Outstanding Qty. (Base) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Area | Area | Code |
|
1..n |
Bin Code | Bin | Code |
|
1..n |
Bin Code | Bin Content | Bin Code |
|
1..n |
Currency Code | Currency | Code |
|
1..n |
Deferral Code | Deferral Template | Deferral 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 |
Gen. Bus. Posting Group | Gen. Business Posting Group | Code |
|
1..n |
Gen. Prod. Posting Group | Gen. Product Posting Group | Code |
|
1..n |
IC Partner Code | IC Partner | Code |
|
1..n |
Insurance No. | Insurance | No. |
|
1..n |
Posting Group | Inventory Posting Group | Code |
|
1..n |
Item Category Code | Item Category | Code |
|
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 |
Prod. Order Line No. | Prod. Order Line | Line No. |
|
1..n |
Operation No. | Prod. Order Routing Line | Operation No. |
|
1..n |
Blanket Order No. | Purchase Header | No. |
|
1..n |
Blanket Order Line No. | Purchase Line | Line No. |
|
1..n |
Purchasing Code | Purchasing | Code |
|
1..n |
Responsibility Center | Responsibility Center | Code |
|
1..n |
Return Reason Code | Return Reason | Code |
|
1..n |
Routing No. | Routing Header | No. |
|
1..n |
Special Order Sales No. | Sales Header | No. |
|
1..n |
Special Order Sales Line No. | Sales Line | Line No. |
|
1..n |
Prepayment Tax Area Code | Tax Area | Code |
|
1..n |
Prepayment 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 |
Work Center No. | Work Center | No. |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Item Charge Assignment (Purch) | Applies-to Doc. Line No. |
|
1..n |
Purch. Cr. Memo Line | Blanket Order Line No. |
|
1..n |
Purch. Inv. Line | Blanket Order Line No. |
|
1..n |
Purch. Rcpt. Line | Blanket Order Line No. |
|
1..n |
Purchase Line | Blanket Order Line No. |
|
1..n |
Purchase Line Archive | Blanket Order Line No. |
|
1..n |
Sales Line | Special Order Purch. Line No. |
|
1..n |
Sales Line Archive | Special Order Purch. Line No. |
|
1..n |