Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Document Type (Document Type) | Option | [Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order] | |
2 | Sell-to Customer No. (Sell-to Customer No.) | Code20 |
|
Editable: No |
3 | Document No. (Document No.) | Code20 |
|
|
4 | Line No. (Line No.) | Integer | ||
5 | Type (Type) | Option | [ ,G/L Account,Item,Resource,Fixed Asset,Charge (Item)] | |
6 | No. (No.) | Code20 | CaptionClass: GetCaptionClass(FIELDNO("No."))
|
|
7 | Location Code (Location Code) | Code10 |
|
|
8 | Posting Group (Posting Group) | Code20 |
|
Editable: No |
10 | Shipment Date (Shipment Date) | Date | AccessByPermission: TableData 110=R | |
11 | Description (Description) | Text50 |
|
|
12 | Description 2 (Description 2) | Text50 | ||
13 | Unit of Measure (Unit of Measure) | Text10 |
|
|
15 | Quantity (Quantity) | Decimal (0:5) | ||
16 | Outstanding Quantity (Outstanding Quantity) | Decimal (0:5) | Editable: No | |
17 | Qty. to Invoice (Qty. to Invoice) | Decimal (0:5) | ||
18 | Qty. to Ship (Qty. to Ship) | Decimal (0:5) | AccessByPermission: TableData 110=R | |
22 | Unit Price (Unit Price) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Unit Price")) AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
|
23 | Unit Cost (LCY) (Unit Cost (LCY)) | Decimal | AutoFormatType: 2 | |
25 | VAT % (VAT %) | Decimal (0:5) | Editable: No | |
27 | Line Discount % (Line Discount %) | Decimal (0:5) | MaxValue: 100 | |
28 | Line Discount Amount (Line Discount Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
29 | Amount (Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
30 | Amount Including VAT (Amount Including VAT) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
32 | Allow Invoice Disc. (Allow Invoice Disc.) | Boolean | InitValue: Yes | |
34 | Gross Weight (Gross Weight) | Decimal (0:5) | ||
35 | Net Weight (Net Weight) | Decimal (0:5) | ||
36 | Units per Parcel (Units per Parcel) | Decimal (0:5) | ||
37 | Unit Volume (Unit Volume) | Decimal (0:5) | ||
38 | Appl.-to Item Entry (Appl.-to Item Entry) | Integer | AccessByPermission: TableData 27=R | |
40 | Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
41 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
42 | Customer Price Group (Customer Price Group) | Code10 |
|
Editable: No |
45 | Job No. (Job No.) | Code20 |
|
Editable: No |
52 | Work Type Code (Work Type Code) | Code10 |
|
|
56 | Recalculate Invoice Disc. (Recalculate Invoice Disc.) | Boolean | Editable: No | |
57 | Outstanding Amount (Outstanding Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
58 | Qty. Shipped Not Invoiced (Qty. Shipped Not Invoiced) | Decimal (0:5) | Editable: No | |
59 | Shipped Not Invoiced (Shipped Not Invoiced) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
60 | Quantity Shipped (Quantity Shipped) | Decimal (0:5) | AccessByPermission: TableData 110=R | Editable: No |
61 | Quantity Invoiced (Quantity Invoiced) | Decimal (0:5) | Editable: No | |
63 | Shipment No. (Shipment No.) | Code20 | Editable: No | |
64 | Shipment Line No. (Shipment Line No.) | Integer | Editable: No | |
67 | Profit % (Profit %) | Decimal (0:5) | Editable: No | |
68 | Bill-to Customer No. (Bill-to Customer No.) | Code20 |
|
Editable: No |
69 | Inv. Discount Amount (Inv. Discount Amount) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Inv. Discount Amount")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
71 | Purchase Order No. (Purchase Order No.) | Code20 | AccessByPermission: TableData 110=R
|
Editable: No |
72 | Purch. Order Line No. (Purch. Order Line No.) | Integer | AccessByPermission: TableData 110=R
|
Editable: No |
73 | Drop Shipment (Drop Shipment) | Boolean | AccessByPermission: TableData 223=R | Editable: Yes |
74 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code20 |
|
|
75 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code20 |
|
|
77 | VAT Calculation Type (VAT Calculation Type) | Option | [Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax] | Editable: No |
78 | Transaction Type (Transaction Type) | Code10 |
|
|
79 | Transport Method (Transport Method) | Code10 |
|
|
80 | Attached to Line No. (Attached to Line No.) | Integer |
|
Editable: No |
81 | Exit Point (Exit Point) | Code10 |
|
|
82 | Area (Area) | Code10 |
|
|
83 | Transaction Specification (Transaction Specification) | Code10 |
|
|
84 | Tax Category (Tax Category) | Code10 | ||
85 | Tax Area Code (Tax Area Code) | Code20 |
|
|
86 | Tax Liable (Tax Liable) | Boolean | ||
87 | Tax Group Code (Tax Group Code) | Code20 |
|
|
88 | VAT Clause Code (VAT Clause Code) | Code20 |
|
|
89 | VAT Bus. Posting Group (VAT Bus. Posting Group) | Code20 |
|
|
90 | VAT Prod. Posting Group (VAT Prod. Posting Group) | Code20 |
|
|
91 | Currency Code (Currency Code) | Code10 |
|
Editable: No |
92 | Outstanding Amount (LCY) (Outstanding Amount (LCY)) | Decimal | AutoFormatType: 1 | Editable: No |
93 | Shipped Not Invoiced (LCY) (Shipped Not Invoiced (LCY)) | Decimal | AutoFormatType: 1 | Editable: No |
94 | Shipped Not Inv. (LCY) No VAT (Shipped Not Inv. (LCY) No VAT) | Decimal | Editable: No Normal |
|
95 | Reserved Quantity (Reserved Quantity) | Decimal (0:5) | AccessByPermission: TableData 110=R
|
Editable: No FlowField |
96 | Reserve (Reserve) | Option | [Never,Optional,Always] AccessByPermission: TableData 27=R |
|
97 | Blanket Order No. (Blanket Order No.) | Code20 | AccessByPermission: TableData 110=R
|
|
98 | Blanket Order Line No. (Blanket Order Line No.) | Integer | AccessByPermission: TableData 110=R
|
|
99 | VAT Base Amount (VAT Base Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
100 | Unit Cost (Unit Cost) | Decimal | AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
Editable: No |
101 | System-Created Entry (System-Created Entry) | Boolean | Editable: No | |
103 | Line Amount (Line Amount) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Line Amount")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
104 | VAT Difference (VAT Difference) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
105 | Inv. Disc. Amount to Invoice (Inv. Disc. Amount to Invoice) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
106 | VAT Identifier (VAT Identifier) | Code20 | Editable: No | |
107 | IC Partner Ref. Type (IC Partner Ref. Type) | Option | [ ,G/L Account,Item,,,Charge (Item),Cross Reference,Common Item No.] AccessByPermission: TableData 410=R |
|
108 | IC Partner Reference (IC Partner Reference) | Code20 | AccessByPermission: TableData 410=R | |
109 | Prepayment % (Prepayment %) | Decimal (0:5) | MaxValue: 100 | |
110 | Prepmt. Line Amount (Prepmt. Line Amount) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Prepmt. Line Amount")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
111 | Prepmt. Amt. Inv. (Prepmt. Amt. Inv.) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Prepmt. Amt. Inv.")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
112 | Prepmt. Amt. Incl. VAT (Prepmt. Amt. Incl. VAT) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
113 | Prepayment Amount (Prepayment Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
114 | Prepmt. VAT Base Amt. (Prepmt. VAT Base Amt.) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
115 | Prepayment VAT % (Prepayment VAT %) | Decimal (0:5) | Editable: No | |
116 | Prepmt. VAT Calc. Type (Prepmt. VAT Calc. Type) | Option | [Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax] | Editable: No |
117 | Prepayment VAT Identifier (Prepayment VAT Identifier) | Code20 | Editable: No | |
118 | Prepayment Tax Area Code (Prepayment Tax Area Code) | Code20 |
|
|
119 | Prepayment Tax Liable (Prepayment Tax Liable) | Boolean | ||
120 | Prepayment Tax Group Code (Prepayment Tax Group Code) | Code20 |
|
|
121 | Prepmt Amt to Deduct (Prepmt Amt to Deduct) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Prepmt Amt to Deduct")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
122 | Prepmt Amt Deducted (Prepmt Amt Deducted) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Prepmt Amt Deducted")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
123 | Prepayment Line (Prepayment Line) | Boolean | Editable: No | |
124 | Prepmt. Amount Inv. Incl. VAT (Prepmt. Amount Inv. Incl. VAT) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
129 | Prepmt. Amount Inv. (LCY) (Prepmt. Amount Inv. (LCY)) | Decimal | AutoFormatType: 1 | Editable: No |
130 | IC Partner Code (IC Partner Code) | Code20 |
|
|
132 | Prepmt. VAT Amount Inv. (LCY) (Prepmt. VAT Amount Inv. (LCY)) | Decimal | Editable: No | |
135 | Prepayment VAT Difference (Prepayment VAT Difference) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
136 | Prepmt VAT Diff. to Deduct (Prepmt VAT Diff. to Deduct) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
137 | Prepmt VAT Diff. Deducted (Prepmt VAT Diff. Deducted) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
180 | Line Discount Calculation (Line Discount Calculation) | Option | [None,%,Amount] | |
480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
900 | Qty. to Assemble to Order (Qty. to Assemble to Order) | Decimal (0:5) | AccessByPermission: TableData 90=R | |
901 | Qty. to Asm. to Order (Base) (Qty. to Asm. to Order (Base)) | Decimal (0:5) | ||
902 | ATO Whse. Outstanding Qty. (ATO Whse. Outstanding Qty.) | Decimal (0:5) | AccessByPermission: TableData 90=R
|
BlankZero: Yes Editable: No FlowField |
903 | ATO Whse. Outstd. Qty. (Base) (ATO Whse. Outstd. Qty. (Base)) | Decimal (0:5) | AccessByPermission: TableData 90=R
|
BlankZero: Yes Editable: No FlowField |
1001 | Job Task No. (Job Task No.) | Code20 |
|
Editable: No |
1002 | Job Contract Entry No. (Job Contract Entry No.) | Integer | AccessByPermission: TableData 167=R | Editable: No |
1300 | Posting Date (Posting Date) | Date |
|
FlowField |
1700 | Deferral Code (Deferral Code) | Code10 |
|
|
1702 | Returns Deferral Start Date (Returns Deferral Start Date) | Date | ||
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 |
5405 | Planned (Planned) | Boolean | Editable: No | |
5407 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
5415 | Quantity (Base) (Quantity (Base)) | Decimal (0:5) | ||
5416 | Outstanding Qty. (Base) (Outstanding Qty. (Base)) | Decimal (0:5) | Editable: No | |
5417 | Qty. to Invoice (Base) (Qty. to Invoice (Base)) | Decimal (0:5) | ||
5418 | Qty. to Ship (Base) (Qty. to Ship (Base)) | Decimal (0:5) | ||
5458 | Qty. Shipped Not Invd. (Base) (Qty. Shipped Not Invd. (Base)) | Decimal (0:5) | Editable: No | |
5460 | Qty. Shipped (Base) (Qty. Shipped (Base)) | Decimal (0:5) | Editable: No | |
5461 | Qty. Invoiced (Base) (Qty. Invoiced (Base)) | Decimal (0:5) | Editable: No | |
5495 | Reserved Qty. (Base) (Reserved Qty. (Base)) | Decimal (0:5) | AccessByPermission: TableData 110=R
|
Editable: No FlowField |
5600 | FA Posting Date (FA Posting Date) | Date | AccessByPermission: TableData 5600=R | |
5602 | Depreciation Book Code (Depreciation Book Code) | Code10 |
|
|
5605 | Depr. until FA Posting Date (Depr. until FA Posting Date) | Boolean | AccessByPermission: TableData 5600=R | |
5612 | Duplicate in Depreciation Book (Duplicate in Depreciation Book) | Code10 |
|
|
5613 | Use Duplication List (Use Duplication List) | Boolean | AccessByPermission: TableData 5600=R | |
5700 | Responsibility Center (Responsibility Center) | Code10 |
|
Editable: No |
5701 | Out-of-Stock Substitution (Out-of-Stock Substitution) | Boolean | Editable: No | |
5702 | Substitution Available (Substitution Available) | Boolean |
|
Editable: No FlowField |
5703 | Originally Ordered No. (Originally Ordered No.) | Code20 | AccessByPermission: TableData 5715=R
|
|
5704 | Originally Ordered Var. Code (Originally Ordered Var. Code) | Code10 | AccessByPermission: TableData 5715=R
|
|
5705 | Cross-Reference No. (Cross-Reference No.) | Code20 | AccessByPermission: TableData 5717=R | |
5706 | Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) | Code10 | AccessByPermission: TableData 5717=R
|
|
5707 | Cross-Reference Type (Cross-Reference Type) | Option | [ ,Customer,Vendor,Bar Code] | |
5708 | Cross-Reference Type No. (Cross-Reference Type No.) | Code30 | ||
5709 | Item Category Code (Item Category Code) | Code20 |
|
|
5710 | Nonstock (Nonstock) | Boolean | AccessByPermission: TableData 5718=R | Editable: No |
5711 | Purchasing Code (Purchasing Code) | Code10 | AccessByPermission: TableData 223=R
|
|
5712 | Product Group Code (Product Group Code) | Code10 |
|
|
5713 | Special Order (Special Order) | Boolean | AccessByPermission: TableData 223=R | Editable: No |
5714 | Special Order Purchase No. (Special Order Purchase No.) | Code20 | AccessByPermission: TableData 223=R
|
|
5715 | Special Order Purch. Line No. (Special Order Purch. Line No.) | Integer | AccessByPermission: TableData 223=R
|
|
5749 | Whse. Outstanding Qty. (Whse. Outstanding Qty.) | Decimal (0:5) | AccessByPermission: TableData 14=R
|
BlankZero: Yes Editable: No FlowField |
5750 | Whse. Outstanding Qty. (Base) (Whse. Outstanding Qty. (Base)) | Decimal (0:5) | AccessByPermission: TableData 14=R
|
BlankZero: Yes Editable: No FlowField |
5752 | Completely Shipped (Completely Shipped) | Boolean | Editable: No | |
5790 | Requested Delivery Date (Requested Delivery Date) | Date | AccessByPermission: TableData 99000880=R | |
5791 | Promised Delivery Date (Promised Delivery Date) | Date | AccessByPermission: TableData 99000880=R | |
5792 | Shipping Time (Shipping Time) | DateFormula | AccessByPermission: TableData 99000880=R | |
5793 | Outbound Whse. Handling Time (Outbound Whse. Handling Time) | DateFormula | AccessByPermission: TableData 14=R | |
5794 | Planned Delivery Date (Planned Delivery Date) | Date | AccessByPermission: TableData 99000880=R | |
5795 | Planned Shipment Date (Planned Shipment Date) | Date | AccessByPermission: TableData 99000880=R | |
5796 | Shipping Agent Code (Shipping Agent Code) | Code10 | AccessByPermission: TableData 5790=R
|
|
5797 | Shipping Agent Service Code (Shipping Agent Service Code) | Code10 | AccessByPermission: TableData 5790=R
|
|
5800 | Allow Item Charge Assignment (Allow Item Charge Assignment) | Boolean | InitValue: Yes AccessByPermission: TableData 5800=R |
|
5801 | Qty. to Assign (Qty. to Assign) | Decimal (0:5) |
|
Editable: No FlowField |
5802 | Qty. Assigned (Qty. Assigned) | Decimal (0:5) |
|
Editable: No FlowField |
5803 | Return Qty. to Receive (Return Qty. to Receive) | Decimal (0:5) | AccessByPermission: TableData 6660=R | |
5804 | Return Qty. to Receive (Base) (Return Qty. to Receive (Base)) | Decimal (0:5) | ||
5805 | Return Qty. Rcd. Not Invd. (Return Qty. Rcd. Not Invd.) | Decimal (0:5) | Editable: No | |
5806 | Ret. Qty. Rcd. Not Invd.(Base) (Ret. Qty. Rcd. Not Invd.(Base)) | Decimal (0:5) | Editable: No | |
5807 | Return Rcd. Not Invd. (Return Rcd. Not Invd.) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
5808 | Return Rcd. Not Invd. (LCY) (Return Rcd. Not Invd. (LCY)) | Decimal | AutoFormatType: 1 | Editable: No |
5809 | Return Qty. Received (Return Qty. Received) | Decimal (0:5) | AccessByPermission: TableData 6660=R | Editable: No |
5810 | Return Qty. Received (Base) (Return Qty. Received (Base)) | Decimal (0:5) | Editable: No | |
5811 | Appl.-from Item Entry (Appl.-from Item Entry) | Integer | AccessByPermission: TableData 27=R | |
5909 | BOM Item No. (BOM Item No.) | Code20 |
|
|
6600 | Return Receipt No. (Return Receipt No.) | Code20 | Editable: No | |
6601 | Return Receipt Line No. (Return Receipt Line No.) | Integer | Editable: No | |
6608 | Return Reason Code (Return Reason Code) | Code10 |
|
|
7001 | Allow Line Disc. (Allow Line Disc.) | Boolean | InitValue: Yes | |
7002 | Customer Disc. Group (Customer Disc. Group) | Code20 |
|
|
7003 | Subtype (Subtype) | Option | [ ,Item - Inventory,Item - Service,Comment] | |
7004 | Price description (Price description) | Text80 |
Keys
# | Fields | ||
---|---|---|---|
0 | Document Type,Document No.,Line No. (Document Type,Document No.,Line No.) | SumIndexFields: Amount,Amount Including VAT,Outstanding Amount,Shipped Not Invoiced,Outstanding Amount (LCY),Shipped Not Invoiced (LCY) | Clustered: Yes |
1 | Document No.,Line No.,Document Type (Document No.,Line No.,Document Type) | ||
2 | Document Type,Type,No.,Variant Code,Drop Shipment,Location Code,Shipment Date (Document Type,Type,No.,Variant Code,Drop Shipment,Location Code,Shipment Date) | SumIndexFields: Outstanding Qty. (Base) | |
3 | Document Type,Bill-to Customer No.,Currency Code (Document Type,Bill-to Customer No.,Currency Code) | SumIndexFields: Outstanding Amount,Shipped Not Invoiced,Outstanding Amount (LCY),Shipped Not Invoiced (LCY),Return Rcd. Not Invd. (LCY) | |
4 | Document Type,Type,No.,Variant Code,Drop Shipment,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Location Code,Shipment Date (Document Type,Type,No.,Variant Code,Drop Shipment,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Location Code,Shipment Date) | SumIndexFields: Outstanding Qty. (Base) | |
5 | Document Type,Bill-to Customer No.,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Currency Code (Document Type,Bill-to Customer No.,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Currency Code) | SumIndexFields: Outstanding Amount,Shipped Not Invoiced,Outstanding Amount (LCY),Shipped Not Invoiced (LCY) | |
6 | Document Type,Blanket Order No.,Blanket Order Line No. (Document Type,Blanket Order No.,Blanket Order Line No.) | ||
7 | Document Type,Document No.,Location Code (Document Type,Document No.,Location Code) | ||
8 | Document Type,Shipment No.,Shipment Line No. (Document Type,Shipment No.,Shipment Line No.) | ||
9 | Type,No.,Variant Code,Drop Shipment,Location Code,Document Type,Shipment Date (Type,No.,Variant Code,Drop Shipment,Location Code,Document Type,Shipment Date) | MaintainSQLIndex: No | |
10 | Document Type,Sell-to Customer No.,Shipment No. (Document Type,Sell-to Customer No.,Shipment No.) | SumIndexFields: Outstanding Amount (LCY) | |
11 | Job Contract Entry No. (Job Contract Entry No.) | ||
12 | Document Type,Document No.,Qty. Shipped Not Invoiced (Document Type,Document No.,Qty. Shipped Not Invoiced) | ||
13 | Document Type,Document No.,Type,No. (Document Type,Document No.,Type,No.) |
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 |
Currency Code (Currency Code) | Currency | Code (Code) |
|
1..n |
Bill-to Customer No. (Bill-to Customer No.) | Customer | No. (No.) |
|
1..n |
Customer Disc. Group (Customer Disc. Group) | Customer Discount Group | Code (Code) |
|
1..n |
Customer Price Group (Customer Price Group) | Customer Price Group | Code (Code) |
|
1..n |
Deferral Code (Deferral Code) | Deferral Template | Deferral Code (Deferral Code) |
|
1..n |
Duplicate in Depreciation Book (Duplicate in Depreciation Book) | Depreciation Book | 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 |
Exit Point (Exit Point) | Entry/Exit Point | Code (Code) |
|
1..n |
Posting Group (Posting Group) | FA Posting Group | 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 |
IC Partner Code (IC Partner Code) | IC Partner | Code (Code) |
|
1..n |
Posting Group (Posting Group) | Inventory Posting Group | Code (Code) |
|
1..n |
BOM Item No. (BOM Item No.) | Item | No. (No.) |
|
1..n |
Item Category Code (Item Category Code) | Item Category | Code (Code) |
|
1..n |
Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) | Item Unit of Measure | Code (Code) |
|
1..n |
Originally Ordered Var. Code (Originally Ordered Var. Code) | Item Variant | Code (Code) |
|
1..n |
Job No. (Job No.) | Job | No. (No.) |
|
1..n |
Job Task No. (Job Task No.) | Job Task | Job Task No. (Job Task No.) |
|
1..n |
Location Code (Location Code) | Location | () |
|
1..n |
Special Order Purchase No. (Special Order Purchase No.) | Purchase Header | No. (No.) |
|
1..n |
Special Order Purch. Line No. (Special Order Purch. Line No.) | Purchase Line | Line No. (Line No.) |
|
1..n |
Purchasing Code (Purchasing Code) | Purchasing | Code (Code) |
|
1..n |
Unit of Measure Code (Unit of Measure Code) | Resource Unit of Measure | Code (Code) |
|
1..n |
Responsibility Center (Responsibility Center) | Responsibility Center | Code (Code) |
|
1..n |
Return Reason Code (Return Reason Code) | Return Reason | Code (Code) |
|
1..n |
Blanket Order No. (Blanket Order No.) | Sales Header | No. (No.) |
|
1..n |
Blanket Order Line No. (Blanket Order Line No.) | Sales Line | Line No. (Line No.) |
|
1..n |
Shipping Agent Code (Shipping Agent Code) | Shipping Agent | Code (Code) |
|
1..n |
Shipping Agent Service Code (Shipping Agent Service Code) | Shipping Agent Services | Code (Code) |
|
1..n |
Prepayment Tax Area Code (Prepayment Tax Area Code) | Tax Area | Code (Code) |
|
1..n |
Prepayment Tax Group Code (Prepayment Tax Group Code) | Tax Group | 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 |
Unit of Measure Code (Unit of Measure Code) | Unit of Measure | Code (Code) |
|
1..n |
VAT Bus. Posting Group (VAT Bus. Posting Group) | VAT Business Posting Group | Code (Code) |
|
1..n |
VAT Clause Code (VAT Clause Code) | VAT Clause | Code (Code) |
|
1..n |
VAT Prod. Posting Group (VAT Prod. Posting Group) | VAT Product Posting Group | Code (Code) |
|
1..n |
Work Type Code (Work Type Code) | Work Type | Code (Code) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Assemble-to-Order Link | Document No. (Document No.) |
|
1..n |
Item Charge Assignment (Sales) | Applies-to Doc. Line No. (Applies-to Doc. Line No.) |
|
1..n |
Purchase Line | Special Order Sales Line No. (Special Order Sales Line No.) |
|
1..n |
Purchase Line Archive | Special Order Sales Line No. (Special Order Sales Line No.) |
|
1..n |
Return Receipt Line | Blanket Order Line No. (Blanket Order Line No.) |
|
1..n |
Return Shipment Line | Blanket Order Line No. (Blanket Order Line No.) |
|
1..n |
Sales Cr.Memo Line | Blanket Order Line No. (Blanket Order Line No.) |
|
1..n |
Sales Invoice Line | Blanket Order Line No. (Blanket Order Line No.) |
|
1..n |
Sales Line | Blanket Order Line No. (Blanket Order Line No.) |
|
1..n |
Sales Line Archive | Blanket Order Line No. (Blanket Order Line No.) |
|
1..n |
Sales Planning Line | Sales Order Line No. (Sales Order Line No.) |
|
1..n |
Sales Shipment Line | Blanket Order Line No. (Blanket Order Line No.) |
|
1..n |