Vat History
In ScopeTechnical: VAT_HISTORY | ID: OR-ITM-VAT_HISTORY-VAT_HISTORY
Stores VAT dollar history by item/location/day for daily sales.
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
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- VAT_HISTORY
Field Definitions(5)
Rules & Considerations(19)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | STORERPK | VAT_AMTR | VAT_RATER | TRAN_DATERPK | VAT_CODE | LAST_UPDATE_ID | CREATE_DATETIME | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1.0000 | 1.0000000000 | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 |
| default | Vat History-002-ALT | 1003 | 12.5000 | 12.5000000000 | 2026-01-03 | S | MDM_USER | 2026-01-03 | 2026-01-03 |
| default | Vat History-003-EDGE | 1005 | 14.0000 | 14.0000000000 | 2026-01-05 | S | BATCH_USER | 2026-01-05 | 2026-01-05 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- STORERPK
- 1
- VAT_AMTR
- 1.0000
- VAT_RATER
- 1.0000000000
- TRAN_DATERPK
- 2026-01-01
- VAT_CODE
- SAMPLE
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- ITEMRPK
- Vat History-002-ALT
- STORERPK
- 1003
- VAT_AMTR
- 12.5000
- VAT_RATER
- 12.5000000000
- TRAN_DATERPK
- 2026-01-03
- VAT_CODE
- S
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- ITEMRPK
- Vat History-003-EDGE
- STORERPK
- 1005
- VAT_AMTR
- 14.0000
- VAT_RATER
- 14.0000000000
- TRAN_DATERPK
- 2026-01-05
- VAT_CODE
- S
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 27
- Governed Rule Count
- 19