Diagrams


Table

Company Information

DynamicsDocs.comCompany Information«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...«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 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT Scheme«Table 5714»Responsibility CenterCode [PK,NN]NameAddressAddress 2CityPost CodeCountry/Region CodePhone No.Fax No.Name 2ContactGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeCountyE-MailHome PageDate FilterContract Gain/Loss Amount«Table 7600»Base CalendarCode [PK,NN]NameCustomized Changes Exist<Location Code><Country/Region Code><Ship-to Country/Region Code><Responsibility Center><Base Calendar Code><Country/Region Code><Base Calendar Code><Location Code><Country/Region Code>

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

Fields

# Name Type
1 Primary Key Code10
2 Name Text50
3 Name 2 Text50
4 Address Text50
5 Address 2 Text50
6 City Text30
7 Phone No. Text30 [Phone No.]
8 Phone No. 2 Text30 [Phone No.]
9 Telex No. Text30
10 Fax No. Text30
11 Giro No. Text20
12 Bank Name Text50
13 Bank Branch No. Text20
14 Bank Account No. Text30
15 Payment Routing No. Text20
17 Customs Permit No. Text10
18 Customs Permit Date Date
19 VAT Registration No. Text20
20 Registration No. Text20
21 Telex Answer Back Text20
22 Ship-to Name Text50
23 Ship-to Name 2 Text50
24 Ship-to Address Text50
25 Ship-to Address 2 Text50
26 Ship-to City Text30
27 Ship-to Contact Text50
28 Location Code Code10
29 Picture BLOB [Bitmap]
30 Post Code Code20
31 County Text30
32 Ship-to Post Code Code20
33 Ship-to County Text30
34 E-Mail Text80 [E-Mail]
35 Home Page Text80 [URL]
36 Country/Region Code Code10
37 Ship-to Country/Region Code Code10
38 IBAN Code50
39 SWIFT Code Code20
40 Industrial Classification Text30
41 IC Partner Code Code20
42 IC Inbox Type Option
43 IC Inbox Details Text250
46 System Indicator Option
47 Custom System Indicator Text Text250
48 System Indicator Style Option
50 Allow Blank Payment Info. Boolean
90 GLN Code13 [Numeric:Yes]
5700 Responsibility Center Code10
5791 Check-Avail. Period Calc. DateFormula
5792 Check-Avail. Time Bucket Option
7600 Base Calendar Code Code10
7601 Cal. Convergence Time Frame DateFormula

Keys

# Fields
0 Primary Key Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Base Calendar Code Base Calendar Code 1..n
Ship-to Country/Region Code Country/Region Code 1..n
Location Code Location 1..n
Responsibility Center Responsibility Center Code 1..n

Table Relations From Other Tables

From Table From Field