Claims Information For Tran Details
In ScopeTechnical: TRANS_CLAIMS | ID: OR-FND-TRANS_CLAIMS-TRANSACTION_CLAIMS
This table is used to store claims information for Tran details. A single claim may span multiple cartons.
See how this object fits into Foundation Data
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
- TRANS_CLAIMS
Field Definitions(5)
Rules & Considerations(28)
validation
constraint
Sample Load Data(4)
| _scenario | CLAIM_IDRPK | TO_CARTONRPK | CLAIM_DATER | FROM_CARTONRPK | TRANSPORTATION_IDRPK | COMMENTS | ITEM_QTY | DAMAGE_CODE | CLAIM_AMOUNT | ITEM_QTY_UOM | CLAIM_AGAINST_ID | DISCREPANCY_TYPE | CLAIM_AGAINST_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 1 | SAMPLE | 1.0000 | SAMPLE | 1.0000 | SAMP | SAMPLE | SAMPLE | SAMPLE |
| default | ALT-TRANS_CLAI-002 | Trans Cl | 2026-01-03 | Trans Cl | 1000000003 | Trans Claims-002-ALT | 12.5000 | C | 12.5000 | Tran | ALT-TRANS_ | S | Trans |
| default | EDGE-TRANS_CLAI-003 | Trans Cl | 2026-01-05 | Trans Cl | 1000000005 | Trans Claims-003-EDGE | 14.0000 | S | 14.0000 | Tran | EDGE-TRANS | O | Trans |
Example values from field definitions
- CLAIM_IDRPK
- SAMPLE
- TO_CARTONRPK
- SAMPLE
- CLAIM_DATER
- 2026-01-01
- FROM_CARTONRPK
- SAMPLE
- TRANSPORTATION_IDRPK
- 1
- COMMENTS
- SAMPLE
- ITEM_QTY
- 1.0000
- DAMAGE_CODE
- SAMPLE
- CLAIM_AMOUNT
- 1.0000
- ITEM_QTY_UOM
- SAMP
- CLAIM_AGAINST_ID
- SAMPLE
- DISCREPANCY_TYPE
- SAMPLE
- CLAIM_AGAINST_TYPE
- SAMPLE
default
- CLAIM_IDRPK
- ALT-TRANS_CLAI-002
- TO_CARTONRPK
- Trans Cl
- CLAIM_DATER
- 2026-01-03
- FROM_CARTONRPK
- Trans Cl
- TRANSPORTATION_IDRPK
- 1000000003
- COMMENTS
- Trans Claims-002-ALT
- ITEM_QTY
- 12.5000
- DAMAGE_CODE
- C
- CLAIM_AMOUNT
- 12.5000
- ITEM_QTY_UOM
- Tran
- CLAIM_AGAINST_ID
- ALT-TRANS_
- DISCREPANCY_TYPE
- S
- CLAIM_AGAINST_TYPE
- Trans
default
- CLAIM_IDRPK
- EDGE-TRANS_CLAI-003
- TO_CARTONRPK
- Trans Cl
- CLAIM_DATER
- 2026-01-05
- FROM_CARTONRPK
- Trans Cl
- TRANSPORTATION_IDRPK
- 1000000005
- COMMENTS
- Trans Claims-003-EDGE
- ITEM_QTY
- 14.0000
- DAMAGE_CODE
- S
- CLAIM_AMOUNT
- 14.0000
- ITEM_QTY_UOM
- Tran
- CLAIM_AGAINST_ID
- EDGE-TRANS
- DISCREPANCY_TYPE
- O
- CLAIM_AGAINST_TYPE
- Trans
Rule Validation Summary
- Source Rule Count
- 35
- Governed Rule Count
- 28