Svc Posupld Item Disc Gtt
Out of ScopeTechnical: SVC_POSUPLD_ITEM_DISC_GTT | ID: OR-MFCS-SVC_POSUPLD_ITEM_DISC_GTT
Stores a row for each THEAD line with lookups for data related to the input record. It also holds some aggregation values, for example totals across the TDETL lines that…
See how this object fits into Item Management
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- SVC_POSUPLD_ITEM_DISC_GTT
Field Definitions(23)
Rules & Considerations(18)
Sample Load Data(4)
| _scenario | CHUNK_IDR | SALES_TDETL_IDR | SALES_THEAD_IDR | SALES_PROCESS_IDR | POSUPLD_LINE_ITEM_IDR | POSUPLD_LINE_ITEM_DISCOUNT_IDR | IM_ITEM | PROM_NO | SALES_QTY | SALES_VALUE | DISCOUNT_VALUE | PROM_COMPONENT | PROM_TRAN_TYPE | TOTAL_DISC_QTY | DISC_AMT_WITH_VAT | DISC_AMT_WITHOUT_VAT | SALES_VALUE_WITH_VAT | EMP_DISC_AMT_WITH_VAT | PROM_CONSIGNMENT_RATE | SALES_VALUE_WITHOUT_VAT | TOTAL_DISC_AMT_WITH_VAT | EMP_DISC_AMT_WITHOUT_VAT | TOTAL_DISC_AMT_WITHOUT_VAT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1000000001 | 1000000001 | 1000000001 | 1000000001 | 1000000001 | 1000000001 | Svc Posupld Item Disc Gtt-001 | Svc Posupld Item Disc Gtt-001 | 11.0000 | 11.0000 | 11.0000 | Svc Posupld Item Disc Gtt-001 | Svc Posupld Item Disc Gtt-001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 |
default
- CHUNK_IDR
- 1000000001
- SALES_TDETL_IDR
- 1000000001
- SALES_THEAD_IDR
- 1000000001
- SALES_PROCESS_IDR
- 1000000001
- POSUPLD_LINE_ITEM_IDR
- 1000000001
- POSUPLD_LINE_ITEM_DISCOUNT_IDR
- 1000000001
- IM_ITEM
- Svc Posupld Item Disc Gtt-001
- PROM_NO
- Svc Posupld Item Disc Gtt-001
- SALES_QTY
- 11.0000
- SALES_VALUE
- 11.0000
- DISCOUNT_VALUE
- 11.0000
- PROM_COMPONENT
- Svc Posupld Item Disc Gtt-001
- PROM_TRAN_TYPE
- Svc Posupld Item Disc Gtt-001
- TOTAL_DISC_QTY
- 11.0000
- DISC_AMT_WITH_VAT
- 11.0000
- DISC_AMT_WITHOUT_VAT
- 11.0000
- SALES_VALUE_WITH_VAT
- 11.0000
- EMP_DISC_AMT_WITH_VAT
- 11.0000
- PROM_CONSIGNMENT_RATE
- 11.0000
- SALES_VALUE_WITHOUT_VAT
- 11.0000
- TOTAL_DISC_AMT_WITH_VAT
- 11.0000
- EMP_DISC_AMT_WITHOUT_VAT
- 11.0000
- TOTAL_DISC_AMT_WITHOUT_VAT
- 11.0000