I_TranspOrdForBusDshbrd

TOR Root Analytics for SAC Dashboard | view: ITORROOTSACANA | ATTR | Extraction: Not supported | Component: Analytics
Column Name Description
TransportationOrderUUID Transportation Order UUID
Column Name Description
Column Name Description
📏 Gross Weight Unit of Measure (TranspOrdGrossWeightUnit):
TranspOrdGrossWeight Transportation Order Gross Weight
📏 Gross Volume Unit of Measure (TranspOrdGrossVolumeUnit):
TranspOrdGrossVolume Transportation Order Gross Volume
📏 Quantity Unit of Measure (TranspOrdQuantityUnit):
TranspOrdQuantity Transportation Order Quantity
📏 Number of TEU Unit of Measure (TranspOrdNumberOfCtnsUnit):
TranspOrdNumberOfCtns Transportation Order Number Of Containers
📏 Transportation Order Distance Unit (TranspOrdDistanceUnit):
TranspOrdDistance Transportation Order Distance
📏 Transportation Order Net Duration Unit of Measure (TranspOrdNetDurationUnit):
TranspOrdNetDurnInHours Transportation Order Net Duration in Hours
Column Name Description
TranspOrdCreationDate Transportation Order Creation Date
Column Name Description
TransportationOrderCategory Transportation Order Category Show values
TranspOrdLifeCycleStatus Transportation Order Life Cycle Status Show values
TranspOrdPlanningStatus Transportation Order Planning Status Show values
TransportationOrderExecSts Transportation Order Execution Status Show values
TransportationModeCategory Transportation Mode Category Show values
TranspOrdIsDelayed Transportation Order is Delayed Show values
Column Name Description Domain name
TransportationOrder Transportation Order /SCMTMS/TOR_ID
NumberOfTransportationOrders Number of Transportation Orders /SCMTMS/VDM_NUMBER_OF
CreatedByUser Created By XUBNAME
TranspOrdCreationDateTime Transportation Order Creation Date Time TZNTSTMPS
TranspOrdCreationYearWeek Transportation Order Creation Year Week NUM6
TranspOrdCreationYearMonth Transportation Order Creation Year Month NUM6
TranspOrdCreationYearQuarter Transportation Order Creation Year Quarter NUM5
TranspOrdCreationYear Transportation Order Creation Year NUM4
Carrier Carrier /SCMTMS/BU_PARTNER
CarrierUUID Carrier UUID /SCMTMS/VDM_DB_KEY
TranspOrdResponsiblePerson Transportation Order Responsible Person UNAME
PlngAndExecOrgExternalID Transportation Execution Organization /SCMB/ORG_EXT_ID
PlngAndExecGroupExternalID Transportation Execution Group /SCMB/ORG_EXT_ID
PurchasingOrgExternalID Transportation Purchasing Organization /SCMB/ORG_EXT_ID
PurchasingGroupExternalID Transportation Purchasing Group /SCMB/ORG_EXT_ID
TransportationMode Transportation Mode VKTRA
TranspOrdSrceLocation Transportation Order Source Location /SAPAPO/LOCNO
TranspOrdDestLocation Transportation Order Destination Location /SAPAPO/LOCNO
TranspOrdMaxUtilznMassRatio Transportation Order Maximum Utilization Mass Ratio /SCMTMS/VDM_UTILIZATION
TranspOrdMaxUtilznVolumeRatio Transportation Order Max Utilization Volume Ratio /SCMTMS/VDM_UTILIZATION
TranspOrdMaxUtilznLengthRatio Transportation Order Maximum Utilization Length Ratio /SCMTMS/VDM_UTILIZATION
Master Data Relations Join Conditions
Transportation Order Type
  • Client
  • Transportation Order Type