| Data Dictionary -- Track and Trace | ||||||||
| Srl. No. | Table Name | Comment |
| 1 | M_ROUTE_RTP_ROUTPARTS_LOG | For Route anywhere mobile application details |
| Table Name : | |
| Comment : | For Route anywhere mobile application details |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| RTP_ROUTE_ID | udd_seqno | int(4) | No | ROUTE ID | No |
| RTP_REFDOCOU | udd_ctxt_ouinstance | int(4) | No | DOCUMENT OU | No |
| RTP_REFDOCNO | udd_documentno | varchar(40) | No | DOCUMENT NO | No |
| RTP_REFDOCTYPE | udd_flag | varchar(25) | No | DOCUMENT TYPE | No |
| RTP_REFDOCPRIORITY | udd_txt5 | varchar(5) | No | DOCUMENT PRIORITY | No |
| RTP_TOTALPARTCOUNT | udd_quantity | numeric(13) | No | TOTAL PART COUNT | No |
| RTP_TOTALMAINCORECOUNT | udd_quantity | numeric(13) | No | TOTAL MAINCORE COUNT | No |
| RTP_TOTALSPARESCOUNT | udd_quantity | numeric(13) | No | TOTAL SPARES COUNT | No |
| RTP_FROMLOCATION | udd_txt80 | varchar(80) | No | FROM LOCATION | No |
| RTP_FROMLOCATION_TYPE | udd_flag | varchar(25) | No | FROM LOCATION TYPE | No |
| RTP_FROMAREA | udd_txt80 | varchar(80) | No | FROM AREA | No |
| RTP_TOLOCATION | udd_txt80 | varchar(80) | No | TO LOCATION | No |
| RTP_TOLOCATION_TYPE | udd_flag | varchar(25) | No | TO LOCATION TYPE | No |
| RTP_TOAREA | udd_txt80 | varchar(80) | No | TO AREA | No |
| RTP_ROUTE_REMARKS | udd_txt2000 | varchar(2000) | No | ROUTE REMARKS | No |
| RTP_ROUTE_INITIATEDBY | udd_ctxt_user | varchar(30) | No | ROUTE INITIATED BY | No |
| RTP_ROUTE_INITIATEDON | udd_time | datetime(8) | No | ROUTE INITIATED ON | No |
| RTP_Event | udd_desc40 | varchar(40) | No | EVENT | No |
| RTP_PICKEDBY | udd_ctxt_user | varchar(30) | No | PICKED BY | No |
| RTP_PICKEDDATE | udd_time | datetime(8) | No | PICKED DATE | No |
| RTP_DELIVEREDBY | udd_ctxt_user | varchar(30) | No | DELIVERED BY | No |
| RTP_DELIVEREDDATE | udd_time | datetime(8) | No | DELIVERED DATE | No |
| RTP_ROUTE_STATUS | udd_flag | varchar(25) | No | ROUTE STATUS | No |