Show TOC

Transportation Allocation Locate this document in the navigation structure

DataStore object DataStore object: 0TMS_DS31

 

This DataStore object saves the transportation allocation data.

Structure

Delta Update

The following delta update is supported for this DataStore object:

  • Delta update: AIMD After-Images with Deletion Indicator by Delta Queue.

  • DataSource: 0SCM_TM_TAL

Data Modeling

Key Fields

Object Type

Name

Technical Name

Characteristic

Bucket DB Key

0TM_BUCKDBK

Characteristic

Reference Object DB Key

0TM_REFOBJK

Characteristic

TAL DB Key

0TM_TALDBK

Data Fields

Object Type

Name

Technical Name

Data packet characteristic

BW Delta Process: Update Mode

0RECORDMODE

Characteristic

Creation Date

0TMS_CRDATE

Unit of measurement

Gross Weight Unit

0TMS_UNIGW

Unit of measurement

Net Weight Unit

0TMS_UNINW

Characteristic

Bucket From Date

0TM_BFRDATE

Unit of measurement

Transportation Allocation Booked Number of TEU UoM

0TM_BKDCNTU

Unit of measurement

Transportation Allocation Booked Gross Weight UoM

0TM_BKDGWU

Unit of measurement

Transportation Allocation Booked Net Weight Unit of Measure

0TM_BKDNWU

Unit of measurement

Transportation Allocation Booked Tare Weight Unit of Measure

0TM_BKDPKGU

Unit of measurement

Transportation Allocation Booked Base Quantity UoM

0TM_BKDQUNI

Unit of measurement

Transportation Allocation Booked Gross Volume UoM

0TM_BKDVOL

Characteristic

Bucket To Date

0TM_BTODATE

Characteristic

Bucket From

0TM_BUCKFRM

Characteristic

Bucket To

0TM_BUCKTO

Characteristic

Bucket Type

0TM_BUCKTYP

Unit of measurement

Base UoM Unit

0TM_BUOMUNI

Characteristic

Changed By

0TM_CHANGBY

Characteristic

Change Timestamp

0TM_CHTSTMP

Unit of measurement

Container Count Unit of Measure

0TM_CNCNT_U

Key figure

Transportation Allocation Maximum TEU Count

0TM_CNTMAX

Key figure

Transportation Allocation Minimum TEU Count

0TM_CNTMIN

Characteristic

Contract Basis

0TM_CONTRBS

Characteristic

Created By

0TM_CREATBY

Characteristic

Creation Timestamp

0TM_CRTSTMP

Characteristic

Airline Code and Flight Number

0TM_FLGHTCD

Characteristic

Flight Number (Numerical)

0TM_FLHTNO

Characteristic

From Location

0TM_GEFRLOC

Characteristic

From Transportation Zone

0TM_GEFRZON

Characteristic

Geography From

0TM_GEOFTYP

Characteristic

Geography To

0TM_GEOTTYP

Characteristic

Destination Location

0TM_GETOLOC

Characteristic

Destination Transportation Zone

0TM_GETOZON

Key figure

Transportation Allocation Maximum Gross Volume Value

0TM_GVOLMAX

Key figure

Transportation Allocation Minimum Gross Volume Value

0TM_GVOLMIN

Key figure

Transportation Allocation Maximum Gross Weight Value

0TM_GWEIMAX

Key figure

Transportation Allocation Minimum Gross Weight Value

0TM_GWEIMIN

Unit of measurement

Transportation Allocation Base Unit Maximum

0TM_MAXBU

Unit of measurement

Transportation Allocation Container Count Unit Maximum

0TM_MAXCNTU

Unit of measurement

Transportation Allocation Gross Volume Unit Maximum

0TM_MAXGVU

Unit of measurement

Transportation Allocation Gross Weight Unit Maximum

0TM_MAXGWU

Unit of measurement

Transportation Allocation Net Weight Unit Maximum

0TM_MAXNWU

Unit of measurement

Transportation Allocation Tare Weight Unit Maximum

0TM_MAXTWU

Unit of measurement

Transportation Allocation Base Unit Minimum

0TM_MINBU

Unit of measurement

Transportation Allocation Container Count Unit Minimum

0TM_MINCNTU

Unit of measurement

Transportation Allocation Gross Volume Unit Minimum

0TM_MINGVU

Unit of measurement

Transportation Allocation Gross Weight Unit Minimum

0TM_MINGWU

Unit of measurement

Transportation Allocation Net Weight Unit Minimum

0TM_MINNWU

Unit of measurement

Transportation Allocation Tare Weight Unit Minimum

0TM_MINTWU

Key figure

Transportation Allocation Maximum Net Weight Value

0TM_NWEIMAX

Key figure

Transportation Allocation Minimum Net Weight Value

0TM_NWEIMIN

Characteristic

Orientation BW

0TM_ORINTBW

Characteristic

Shipping Type

0TM_SHIPTYP

Key figure

Transportation Allocation Base Quantity

0TM_TALBSQ

Characteristic

Transportation Allocation Category

0TM_TALCAT

Key figure

Transportation Allocation Booked TEU Count

0TM_TALCNT

Key figure

Transportation Allocation Booked Quantity

0TM_TALCURQ

Characteristic

Transportation Allocation Load Type

0TM_TALDTYP

Key figure

Transportation Allocation Booked Gross Volume

0TM_TALGVOL

Key figure

Transportation Allocation Gross Weight Value

0TM_TALGW

Key figure

Transportation Allocation Booked Gross Weight

0TM_TALGWEI

Key figure

Transportation Allocation Maximum Quantity

0TM_TALMAXQ

Key figure

Transportation Allocation Minimum Quantity

0TM_TALMINQ

Characteristic

Transportation Allocation Line Type

0TM_TALNTYP

Key figure

Transportation Allocation Net Weight Value

0TM_TALNW

Key figure

Transportation Allocation Booked Net Weight

0TM_TALNWEI

Key figure

Transportation Allocation Booked Tare Weight

0TM_TALTARE

Key figure

Transportation Allocation TEU Count

0TM_TALTEU

Key figure

Transportation Allocation Tare Weight Value

0TM_TALTWT

Characteristic

Transportation Allocation Type

0TM_TALTYP

Characteristic

Transportation Allocation ID

0TM_TAL_ID

Unit of measurement

Tare Weight Unit of Measure

0TM_TARWEIU

Key figure

Transportation Allocation Maximum Tare Weight

0TM_TARWMAX

Key figure

Transportation Allocation Minimum Tare Weight

0TM_TARWMIN

Characteristic

Transportation Allocation Attribute ID

0TM_TATRID

Characteristic

Trade Lane ID

0TM_TDL_ID

Characteristic

Trade Lane UUID

0TM_TDL_UID

Key figure

Transportation Allocation Gross Volume Value

0TM_TGRVOL

Characteristic

Time Zone

0TM_TIMZONE

Characteristic

Transportation Order Node ID

0TM_TORDBK

Characteristic

TO Timestamp for TAL

0TM_TORSUTC

Characteristic

Means of Transport

0TM_TRMEANS

Characteristic

Transportation Mode Code

0TM_TRMODCO

Characteristic

Transportation Service Level

0TM_TRSLCD

Characteristic

Carrier

0TM_TSP

Characteristic

Carrier: IATA Airline Code

0TM_TSPAIRL

Unit of measurement

Gross Volume Unit

0TM_UNIGV

Characteristic

Valid From Date

0TM_VALFDAT

Characteristic

Valid To Date

0TM_VALTDAT

Characteristic

Valid From Timestamp

0TM_VFTSTMP

Characteristic

Valid To Timestamp

0TM_VTTSTMP

Characteristic

Transportation Allocation Weekday Friday

0TM_WDAYFR

Characteristic

Transportation Allocation Weekday Monday

0TM_WDAYMO

Characteristic

Transportation Allocation Weekday Saturday

0TM_WDAYSA

Characteristic

Transportation Allocation Weekday Sunday

0TM_WDAYSO

Characteristic

Transportation Allocation Weekday Thursday

0TM_WDAYTH

Characteristic

Transportation Allocation Weekday Tuesday

0TM_WDAYTU

Characteristic

Transportation Allocation Weekday Wednesday

0TM_WDAYWE