Vat Item
In ScopeTechnical: VAT_ITEM | ID: OR-MFCS-VAT_ITEM
This table will hold VAT information for Items. It will not be used for SYSTEM_OPTIONS.DEFAULT_TAX_TYPE 'GTS'.
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
- VAT_ITEM
Field Definitions(12)
Rules & Considerations(38)
Sample Load Data(4)
| _scenario | ITEMRPK | VAT_CODERPK | VAT_RATER | VAT_TYPER | CREATE_IDR | VAT_REGIONRPK | ACTIVE_DATER | CREATE_DATER | LAST_UPDATE_IDR | CREATE_DATETIMER | REVERSE_VAT_INDR | LAST_UPDATE_DATETIMER |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Vat Item-001 | STD-VAT_ITEM-001 | 11.0000 | Vat Item-001 | MIG_USER | 0201 | 2026-01-01 | 2026-01-01 | MIG_USER | 2026-01-01 | N | 2026-01-01 |
default
- ITEMRPK
- Vat Item-001
- VAT_CODERPK
- STD-VAT_ITEM-001
- VAT_RATER
- 11.0000
- VAT_TYPER
- Vat Item-001
- CREATE_IDR
- MIG_USER
- VAT_REGIONRPK
- 0201
- ACTIVE_DATER
- 2026-01-01
- CREATE_DATER
- 2026-01-01
- LAST_UPDATE_IDR
- MIG_USER
- CREATE_DATETIMER
- 2026-01-01
- REVERSE_VAT_INDR
- N
- LAST_UPDATE_DATETIMER
- 2026-01-01