Posupld Item Discount (Service Layer GTT)

Out of Scope

Technical: SVC_POSUPLD_ITEM_DISC_GTT | ID: OR-ITM-SVC_POSUPLD_ITEM_DISC_GTT-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

Classification

Object Type: gtt

Target Structure

Load Approach: Table
Target Objects: SVC_POSUPLD_ITEM_DISC_GTT

Field Definitions(5)

Rules & Considerations(29)

validation

constraint

Sample Load Data(4)

_scenario	SALES_TDETL_IDR	SALES_THEAD_IDR	SALES_PROCESS_IDR	POSUPLD_LINE_ITEM_IDR	POSUPLD_LINE_ITEM_DISCOUNT_IDR	IM_ITEM	PROM_NO	CHUNK_ID	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
Example values from field definitions	1	1	1	1	1	SAMPLE	SAMPLE	1	1.0000	1.0000	1.0000	SAMPLE	SAMPLE	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000
default	1000000003	1000000003	1000000003	1000000003	1000000003	Svc Posupld Item Disc Gtt	Svc Posupl	1000000003	12.5000	12.5000	12.5000	Svc Posupl	Svc Po	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000
default	1000000005	1000000005	1000000005	1000000005	1000000005	Svc Posupld Item Disc Gtt	Svc Posupl	1000000005	14.0000	14.0000	14.0000	Svc Posupl	Svc Po	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000

Example values from field definitions

SALES_TDETL_IDR: 1
SALES_THEAD_IDR: 1
SALES_PROCESS_IDR: 1
POSUPLD_LINE_ITEM_IDR: 1
POSUPLD_LINE_ITEM_DISCOUNT_IDR: 1
IM_ITEM: SAMPLE
PROM_NO: SAMPLE
CHUNK_ID: 1
SALES_QTY: 1.0000
SALES_VALUE: 1.0000
DISCOUNT_VALUE: 1.0000
PROM_COMPONENT: SAMPLE
PROM_TRAN_TYPE: SAMPLE
TOTAL_DISC_QTY: 1.0000
DISC_AMT_WITH_VAT: 1.0000
DISC_AMT_WITHOUT_VAT: 1.0000
SALES_VALUE_WITH_VAT: 1.0000
EMP_DISC_AMT_WITH_VAT: 1.0000
PROM_CONSIGNMENT_RATE: 1.0000
SALES_VALUE_WITHOUT_VAT: 1.0000
TOTAL_DISC_AMT_WITH_VAT: 1.0000
EMP_DISC_AMT_WITHOUT_VAT: 1.0000
TOTAL_DISC_AMT_WITHOUT_VAT: 1.0000

default

SALES_TDETL_IDR: 1000000003
SALES_THEAD_IDR: 1000000003
SALES_PROCESS_IDR: 1000000003
POSUPLD_LINE_ITEM_IDR: 1000000003
POSUPLD_LINE_ITEM_DISCOUNT_IDR: 1000000003
IM_ITEM: Svc Posupld Item Disc Gtt
PROM_NO: Svc Posupl
CHUNK_ID: 1000000003
SALES_QTY: 12.5000
SALES_VALUE: 12.5000
DISCOUNT_VALUE: 12.5000
PROM_COMPONENT: Svc Posupl
PROM_TRAN_TYPE: Svc Po
TOTAL_DISC_QTY: 12.5000
DISC_AMT_WITH_VAT: 12.5000
DISC_AMT_WITHOUT_VAT: 12.5000
SALES_VALUE_WITH_VAT: 12.5000
EMP_DISC_AMT_WITH_VAT: 12.5000
PROM_CONSIGNMENT_RATE: 12.5000
SALES_VALUE_WITHOUT_VAT: 12.5000
TOTAL_DISC_AMT_WITH_VAT: 12.5000
EMP_DISC_AMT_WITHOUT_VAT: 12.5000
TOTAL_DISC_AMT_WITHOUT_VAT: 12.5000