Diagrams

Table

ATO Sales Buffer

DynamicsDocs.comATO Sales Buffer«Table 915»ATO Sales BufferType; [,Sale,Total Sale,Assembly,Total...Order No. [PK]Item No. [PK]Parent Item No. [PK]QuantitySales CostSales AmountProfit %Parent Description

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

Fields

# Name Type
1 Type (Type) Option
2 Order No. (Order No.) Code20
3 Item No. (Item No.) Code20
4 Parent Item No. (Parent Item No.) Code20
5 Quantity (Quantity) Decimal
6 Sales Cost (Sales Cost) Decimal
7 Sales Amount (Sales Amount) Decimal
8 Profit % (Profit %) Decimal
9 Parent Description (Parent Description) Text50

Keys

# Fields
0 Type,Order No.,Item No.,Parent Item No. (Type,Order No.,Item No.,Parent Item No.) Clustered: Yes
1 Item No.,Type,Parent Item No. (Item No.,Type,Parent Item No.)

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field