TSF Item Cost
In ScopeTechnical: TSF_ITEM_COST | ID: OR-INV-TSF_ITEM_COST-TSF_ITEM_COST
Stores the average transfer price, transfer quantity, and shipped quantity for items on the transfer. This table is populated for 2-legged transfers (could be either inter- or intra-company) and single-legged...
See how this object fits into Inventory Management
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- TSF_ITEM_COST
Field Definitions(5)
Rules & Considerations(24)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMR | TSF_NOR | TSF_QTYR | TSF_ITEM_COST_IDRPK | LEG_IND | ICT_LEG_IND | SHIPPED_QTY | TSF_AVG_PRICE | TSF_PARENT_NO | XFORM_TO_ITEM |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1.0000 | 1 | S | S | 1.0000 | 1.0000 | 1 | SAMPLE |
| default | TSF Item Cost-002-ALT | 4 | 12.5000 | 1000000003 | 2 | T | 12.5000 | 12.5000 | 4 | TSF Item Cost-002-ALT |
| default | TSF Item Cost-003-EDGE | 6 | 14.0000 | 1000000005 | S | T | 14.0000 | 14.0000 | 6 | TSF Item Cost-003-EDGE |
Example values from field definitions
- ITEMR
- SAMPLE
- TSF_NOR
- 1
- TSF_QTYR
- 1.0000
- TSF_ITEM_COST_IDRPK
- 1
- LEG_IND
- S
- ICT_LEG_IND
- S
- SHIPPED_QTY
- 1.0000
- TSF_AVG_PRICE
- 1.0000
- TSF_PARENT_NO
- 1
- XFORM_TO_ITEM
- SAMPLE
default
- ITEMR
- TSF Item Cost-002-ALT
- TSF_NOR
- 4
- TSF_QTYR
- 12.5000
- TSF_ITEM_COST_IDRPK
- 1000000003
- LEG_IND
- 2
- ICT_LEG_IND
- T
- SHIPPED_QTY
- 12.5000
- TSF_AVG_PRICE
- 12.5000
- TSF_PARENT_NO
- 4
- XFORM_TO_ITEM
- TSF Item Cost-002-ALT
default
- ITEMR
- TSF Item Cost-003-EDGE
- TSF_NOR
- 6
- TSF_QTYR
- 14.0000
- TSF_ITEM_COST_IDRPK
- 1000000005
- LEG_IND
- S
- ICT_LEG_IND
- T
- SHIPPED_QTY
- 14.0000
- TSF_AVG_PRICE
- 14.0000
- TSF_PARENT_NO
- 6
- XFORM_TO_ITEM
- TSF Item Cost-003-EDGE
Rule Validation Summary
- Source Rule Count
- 47
- Governed Rule Count
- 24
