Diagrams

Table

Base Calendar

DynamicsDocs.comBase Calendar«Table 7600»Base CalendarCode [PK,NN]NameCustomized Changes Exist«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«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 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 5790»Shipping Agent ServicesShipping Agent Code [PK,NN]Code [PK,NN]DescriptionShipping TimeBase Calendar Code«Table 5911»Service Mgt. SetupPrimary Key [PK]Fault Reporting Level; [None,Fault,Fau...Link Service to Service ItemSalesperson MandatoryWarranty Disc. % [Parts]Warranty Disc. % [Labor]Contract Rsp. Time MandatoryService Order Starting FeeRegister Contract ChangesContract Inv. Line Text CodeContract Line Inv. Text CodeContract Inv. Period Text CodeContract Credit Line Text CodeSend First Warning ToSend Second Warning ToSend Third Warning ToFirst Warning Within [Hours]Second Warning Within [Hours]Third Warning Within [Hours]Next Service Calc. Method; [Planned,Ac...Service Order Type MandatoryService Zones Option; [Code Shown,Warn...Service Order Start MandatoryService Order Finish MandatoryResource Skills Option; [Code Shown,Wa...One Service Item Line/OrderUnit of Measure MandatoryFault Reason Code MandatoryContract Serv. Ord. Max. DaysLast Contract Service DateWork Type Code Mandatory...«Table 7601»Base Calendar ChangeBase Calendar Code [PK]Recurring System; [,Annual Recurring,W...Date [PK]Day; [,Monday,Tuesday,Wednesday,Thursd...DescriptionNonworking«Table 7602»Customized Calendar ChangeSource Type; [Company,Customer,Vendor,...Source Code [PK]Additional Source Code [PK]Base Calendar Code [PK]Recurring System; [,Annual Recurring,W...Date [PK]Day; [,Monday,Tuesday,Wednesday,Thursd...DescriptionNonworkingEntry No. [PK]«Table 7603»Customized Calendar EntrySource Type; [Company,Customer,Vendor,...Source Code [PK]Additional Source Code [PK]Base Calendar Code [PK]Date [PK]DescriptionNonworking«Table 7604»Where Used Base CalendarSource Type; [Company,Customer,Vendor,...Source Code [PK]Additional Source CodeBase Calendar Code [PK]Source Name [PK]Customized Changes Exist«Table 79»Company InformationPrimary Key [PK]NameName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.Giro No.Bank NameBank Branch No.Bank Account No.Payment Routing No.Customs Permit No.Customs Permit DateVAT Registration No.Registration No.Telex Answer BackShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactLocation CodePicturePost CodeCountyShip-to Post Code...<Base Calendar Code><Base Calendar Code><Base Calendar Code><Base Calendar Code><Base Calendar Code><Base Calendar Code><Base Calendar Code><Base Calendar Code><Base Calendar Code><Base Calendar Code><Location Code><Location Code><Location Code><Bill-to Customer No.><Shipping Agent Service Code><Pay-to Vendor No.>

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

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Name (Name) Text30
3 Customized Changes Exist (Customized Changes Exist) Boolean Editable: No
FlowField

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Base Calendar Change Base Calendar Code (Base Calendar Code) 1..n
Company Information Base Calendar Code (Base Calendar Code) 1..n
Customer Base Calendar Code (Base Calendar Code) 1..n
Customized Calendar Change Base Calendar Code (Base Calendar Code) 1..n
Customized Calendar Entry Base Calendar Code (Base Calendar Code) 1..n
Location Base Calendar Code (Base Calendar Code) 1..n
Service Mgt. Setup Base Calendar Code (Base Calendar Code) 1..n
Shipping Agent Services Base Calendar Code (Base Calendar Code) 1..n
Vendor Base Calendar Code (Base Calendar Code) 1..n
Where Used Base Calendar Base Calendar Code (Base Calendar Code) 1..n