Dc Vat Region

In Scope

Technical: DC_VAT_REGION | ID: OR-FND-DC_VAT_REGION-DC_VAT_REGION

This table is a staging table for data conversion and will hold one row for each VAT region and is maintained by the VAT Region Maintenance.

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: DC_VAT_REGION

Field Definitions(5)

Rules & Considerations(6)

Sample Load Data(4)

_scenario	VAT_REGION	VAT_CALC_TYPE	VAT_REGION_NAME	VAT_REGION_TYPE	ACQUISITION_VAT_IND	REVERSE_VAT_THRESHOLD
Example values from field definitions	1	SAMPLE	SAMPLE	SAMPLE	S	1.0000
default	203	Dc Vat	Dc Vat Region Secondary	Dc Vat	N	12.5000
default	205	Dc Vat	Dc Vat Region Core	Dc Vat	Y	14.0000

Example values from field definitions

VAT_REGION: 1
VAT_CALC_TYPE: SAMPLE
VAT_REGION_NAME: SAMPLE
VAT_REGION_TYPE: SAMPLE
ACQUISITION_VAT_IND: S
REVERSE_VAT_THRESHOLD: 1.0000

default

VAT_REGION: 203
VAT_CALC_TYPE: Dc Vat
VAT_REGION_NAME: Dc Vat Region Secondary
VAT_REGION_TYPE: Dc Vat
ACQUISITION_VAT_IND: N
REVERSE_VAT_THRESHOLD: 12.5000

default

VAT_REGION: 205
VAT_CALC_TYPE: Dc Vat
VAT_REGION_NAME: Dc Vat Region Core
VAT_REGION_TYPE: Dc Vat
ACQUISITION_VAT_IND: Y
REVERSE_VAT_THRESHOLD: 14.0000

Rule Validation Summary

Source Rule Count: 10
Governed Rule Count: 6