| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPVehicle Management System |
1 | VLCCUORDER | VELO : Sales Order | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |
2 | VLCDELIVERY | VELO : Delivery | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |
3 | VLCGISSUE | VELO : Material Document /Goods Issue | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |
4 | VLCGMOVEM | VELO : Material Documents (Other) | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |
5 | VLCGRECEIPT | VELO : Material Document / Goods Receipt | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |
6 | VLCHISTORY | VELO : Vehicle History | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |
7 | VLCINCINVOICE | VELO : Incoming Invoice | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |
8 | VLCINQUIRY | VELO : Request for Quotation | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |
9 | VLCINVOICE | VELO : Billing Document | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |
10 | VLCOFFER | VELO : Quotation | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |
11 | VLCPORDER | VELO : MM Purchase Order | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |
12 | VLCREVALUATION | VELO : Delivery | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |
13 | VLCSMNOTIF | VELO : Service Notification | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |
14 | VLCSMORDER | VELO : Service Order | 4 | ACTDOCTYPE | Type of Document for Action | nvarchar | 4 | 0 | | |