Diagrams

Table

Maintenance Registration

DynamicsDocs.comMaintenance Registration«Table 5616»Maintenance RegistrationFA No. [PK,NN]Line No. [PK]Service DateMaintenance Vendor No.CommentService Agent NameService Agent Phone No.Service Agent Mobile Phone«Table 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting GroupAcquiredImage...«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...<FA No.><Maintenance Vendor No.><Vendor No.><Maintenance Vendor No.><Component of Main Asset><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 FA No. (FA No.) Code20 NotBlank: Yes
2 Line No. (Line No.) Integer
3 Service Date (Service Date) Date
4 Maintenance Vendor No. (Maintenance Vendor No.) Code20
5 Comment (Comment) Text50
6 Service Agent Name (Service Agent Name) Text30
7 Service Agent Phone No. (Service Agent Phone No.) Text30 [Phone No.]
8 Service Agent Mobile Phone (Service Agent Mobile Phone) Text30 [Phone No.]

Keys

# Fields
0 FA No.,Line No. (FA No.,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
FA No. (FA No.) Fixed Asset No. (No.) 1..n
Maintenance Vendor No. (Maintenance Vendor No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field