FSD - Consolidated Root and Items

Show TOC

FSD - Consolidated Root and Items

DataStore object: 0TMS_DS24

This DataStore object saves the consolidated root and item data of the freight settlement document.

Structure

Delta Update

The following delta update is supported for this DataStore object:

Delta update: ODS Extraction
DataSource: 0TMS_DS17; 0TMS_DS18

Data Modeling

Key Fields
Object Type	Name	Technical Name
Characteristic	Item Node ID	0TM_ITEMDBK
Characteristic	FSD Node ID	0TM_SFIRDBK

Data Fields
Object Type	Name	Technical Name
Data packet characteristic	BW Delta Process: Update Mode	0RECORDMODE
Characteristic	Invoicing Party	0TMS_BILLFR
Characteristic	Creation Date	0TMS_CRDATE
Key figure	Gross Weight	0TMS_GW
Key figure	Net Weight	0TMS_NW
Characteristic	Shipper	0TMS_SENDFR
Characteristic	Consignee	0TMS_SENDTO
Unit of measurement	Gross Weight Unit	0TMS_UNIGW
Unit of measurement	Net Weight Unit	0TMS_UNINW
Unit of measurement	Base UoM Unit	0TM_BUOMUNI
Key figure	Base UoM Value	0TM_BUOMVAL
Unit of measurement	Confirmed Container Count Unit of Measure	0TM_CCCNT_U
Key figure	Confirmend Container Count	0TM_CCNTCNT
Characteristic	Changed By	0TM_CHANGBY
Characteristic	Change Date	0TM_CHDATE
Characteristic	Change Timestamp	0TM_CHTSTMP
Unit of measurement	Container Count Unit of Measure	0TM_CNCNT_U
Key figure	Confirmed Gross Weight Value	0TM_CNFGRWT
Key figure	Confirmed Gross Volume Value	0TM_CNFGVL
Unit of measurement	Confirmed Gross Volume Unit	0TM_CNFGV_U
Unit of measurement	Confirmed Gross Weight Unit	0TM_CNFGW_U
Key figure	Confirmed Quantity	0TM_CNFPVL
Unit of measurement	Confirmed Quantity Unit of Measure	0TM_CNFPV_U
Key figure	Container Count	0TM_CONTCNT
Characteristic	Created By	0TM_CREATBY
Characteristic	Creation Timestamp	0TM_CRTSTMP
Key figure	Goods Value	0TM_GOODSVL
Key figure	Gross Volume	0TM_GROVOL
Unit of measurement	Goods Value Currency	0TM_GVCURR
Unit of measurement	Goods Value for Customs Currency	0TM_GVFCCUR
Key figure	Goods Value for Customs	0TM_GVFCVAL
Characteristic	High Value Cargo	0TM_HVCARGI
Key figure	Insurable Value	0TM_INSURVL
Characteristic	Invoice Date	0TM_INVDATE
Characteristic	Item ID	0TM_ITEMID
Characteristic	Item Parent Key	0TM_ITEMPTK
Unit of measurement	Insurable Value Currency	0TM_IVCURR
Unit of measurement	Net Invoice Currency	0TM_NICNVUR
Key figure	Net Invoice Amount	0TM_NINVAMT
Key figure	Weight of Packaging or Unladen Container	0TM_PACKWGT
Unit of measurement	Weight of Package Unit of Measure	0TM_PAKWT_U
Characteristic	Payee	0TM_PAYEE
Unit of measurement	Alternative Quantity Unit of Measure	0TM_PC2VL_U
Key figure	Alternative Quantity	0TM_PCS2VAL
Key figure	Quantity	0TM_PCSVAL
Unit of measurement	Quantity Unit of Measure	0TM_PCVLUNI
Characteristic	Purchasing Group ID	0TM_PGRPID
Characteristic	Purchasing Organization ID	0TM_PORGID
Characteristic	FSD Category	0TM_SFIRCAT
Characteristic	FSD Creation Type	0TM_SFIRCRT
Characteristic	FSD Confirmation Status	0TM_SFIRCST
Characteristic	FSD ID	0TM_SFIRID
Characteristic	FSD Life Cycle Status	0TM_SFIRLCS
Characteristic	FSD Transfer Status	0TM_SFIRTST
Characteristic	FSD Type	0TM_SFIRTYP
Characteristic	TO Item Key	0TM_TORIKEY
Characteristic	TO Item Transient Key	0TM_TORITRK
Characteristic	TO Root Key	0TM_TORRKEY
Unit of measurement	Gross Volume Unit	0TM_UNIGV