Diagrams

Table

Item Charge

DynamicsDocs.comItem Charge«Table 5800»Item ChargeNo. [PK,NN]DescriptionGen. Prod. Posting GroupTax Group CodeVAT Prod. Posting GroupSearch DescriptionGlobal Dimension 1 CodeGlobal Dimension 2 Code«Table 5805»Item Charge Assignment (Purch)Document Type; [Quote,Order,Invoice,Cr...Document No. [PK]Document Line No. [PK]Line No. [PK]Item Charge No. [NN]Item No.DescriptionQty. to AssignQty. AssignedUnit CostAmount to AssignApplies-to Doc. Type; [Quote,Order,Inv...Applies-to Doc. No.Applies-to Doc. Line No.Applies-to Doc. Line Amount«Table 5809»Item Charge Assignment (Sales)Document Type; [Quote,Order,Invoice,Cr...Document No. [PK]Document Line No. [PK]Line No. [PK]Item Charge No. [NN]Item No.DescriptionQty. to AssignQty. AssignedUnit CostAmount to AssignApplies-to Doc. Type; [Quote,Order,Inv...Applies-to Doc. No.Applies-to Doc. Line No.Applies-to Doc. Line Amount«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 321»Tax GroupCode [PK,NN]Description«Table 324»VAT Product Posting GroupCode [PK,NN]Description<Gen. Prod. Posting Group><Tax Group Code><VAT Prod. Posting Group><Item Charge No.><Item Charge No.><Def. VAT Prod. Posting Group>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 No. (No.) Code20 NotBlank: Yes
2 Description (Description) Text50
3 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
4 Tax Group Code (Tax Group Code) Code10
5 VAT Prod. Posting Group (VAT Prod. Posting Group) Code10
6 Search Description (Search Description) Code50
7 Global Dimension 1 Code (Global Dimension 1 Code) Code20
8 Global Dimension 2 Code (Global Dimension 2 Code) Code20

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Search Description (Search Description)
2 Gen. Prod. Posting Group (Gen. Prod. Posting Group)
3 Description (Description)

Table Relations To Other Tables

Field Related Table Related Field
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 1..n
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
Tax Group Code (Tax Group Code) Tax Group Code (Code) 1..n
VAT Prod. Posting Group (VAT Prod. Posting Group) VAT Product Posting Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Default Dimension No. (No.) 1..n
Handled IC Inbox Purch. Line IC Partner Reference (IC Partner Reference) 1..n
Handled IC Inbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
Handled IC Outbox Purch. Line IC Partner Reference (IC Partner Reference) 1..n
Handled IC Outbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
IC Inbox Purchase Line IC Partner Reference (IC Partner Reference) 1..n
IC Inbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
IC Outbox Purchase Line IC Partner Reference (IC Partner Reference) 1..n
IC Outbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
Item Charge Assignment (Purch) Item Charge No. (Item Charge No.) 1..n
Item Charge Assignment (Sales) Item Charge No. (Item Charge No.) 1..n
Item Journal Line Item Charge No. (Item Charge No.) 1..n
Item Statistics Buffer Item Charge No. Filter (Item Charge No. Filter) 1..n
Purch. Cr. Memo Line No. (No.) 1..n
Purch. Inv. Line No. (No.) 1..n
Purch. Rcpt. Line No. (No.) 1..n
Purchase Line Archive No. (No.) 1..n
Return Receipt Line No. (No.) 1..n
Return Shipment Line No. (No.) 1..n
Sales Cr.Memo Line No. (No.) 1..n
Sales Invoice Line No. (No.) 1..n
Sales Line Archive No. (No.) 1..n
Sales Shipment Buffer No. (No.) 1..n
Sales Shipment Line No. (No.) 1..n
Service Shipment Buffer No. (No.) 1..n
Standard Item Journal Line Item Charge No. (Item Charge No.) 1..n
Standard Purchase Line No. (No.) 1..n
Standard Sales Line No. (No.) 1..n
Value Entry Item Charge No. (Item Charge No.) 1..n