Diagrams

Table

Sales Prepayment %

DynamicsDocs.comSales Prepayment %«Table 459»Sales Prepayment %Item No. [PK,NN]Sales Type; [Customer,Customer Price G...Sales Code [PK]Starting Date [PK]Ending DatePrepayment %«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.<Item No.><Sales Code><Sales Code><Alternative Item No.><Customer Price Group><Bill-to Customer No.>

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

Fields

# Name Type
1 Item No. (Item No.) Code20 NotBlank: Yes
2 Sales Type (Sales Type) Option
3 Sales Code (Sales Code) Code20
4 Starting Date (Starting Date) Date
5 Ending Date (Ending Date) Date
6 Prepayment % (Prepayment %) Decimal (0:5)

Keys

# Fields
0 Item No.,Sales Type,Sales Code,Starting Date (Item No.,Sales Type,Sales Code,Starting Date) Clustered: Yes
1 Sales Type,Sales Code (Sales Type,Sales Code)

Table Relations To Other Tables

Field Related Table Related Field
Sales Code (Sales Code) Customer No. (No.) 1..n
Sales Code (Sales Code) Customer Price Group Code (Code) 1..n
Item No. (Item No.) Item No. (No.) 1..n

Table Relations From Other Tables

From Table From Field