Sales Tax Codes

In Scope

Technical: TaxTable | ID: D365FO-FIN-TAXTABLE-SALES_TAX_CODES

See how this object fits into Finance

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Low
Sequencing: Stage 1 - Master Data
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: TaxTable

Field Definitions(5)

Sample Load Data(4)

_scenario	TaxCodeRPK	ToDate	TaxRate	TaxType	FromDate	TaxBasis	PrintCode	DataAreaId	TaxPurpose	Description	RoundingForm	RoundingRule	LedgerAccount	SettlementPeriod	RoundingPrecision	TaxCalculationMethod	ApplySalesTaxOnPayment	TaxOnTax	ExemptCode
Example values from field definitions	VAT20	2154-12-31	20.0	SalesTax	2023-01-01	NetAmount	VAT20	USMF	SalesTax	Standard VAT 20%	Normal	Nearest	220100	MONTHLY	0.01	Normal	OnInvoice	—	—
Cascading Tax (Tax-on-Tax)	PST07	2154-12-31	7	SalesTax	2023-01-01	GrossAmount	PST	USMF	SalesTax	Provincial Sales Tax 7% (on GST)	Normal	Nearest	220101	MONTHLY	0.01	Normal	OnInvoice	GST05	—
Tax Exempt Code (0% rate)	EXEMPT	2154-12-31	0	SalesTax	2023-01-01	NetAmount	EXEMPT	USMF	SalesTax	Tax Exempt 0%	Normal	Nearest	220100	QUARTERLY	0.01	Normal	OnInvoice	—	GOVT_EXEMPT

Example values from field definitions

TaxCodeRPK: VAT20
ToDate: 2154-12-31
TaxRate: 20.0
TaxType: SalesTax
FromDate: 2023-01-01
TaxBasis: NetAmount
PrintCode: VAT20
DataAreaId: USMF
TaxPurpose: SalesTax
Description: Standard VAT 20%
RoundingForm: Normal
RoundingRule: Nearest
LedgerAccount: 220100
SettlementPeriod: MONTHLY
RoundingPrecision: 0.01
TaxCalculationMethod: Normal
ApplySalesTaxOnPayment: OnInvoice
TaxOnTax: —
ExemptCode: —

Cascading Tax (Tax-on-Tax)

TaxCodeRPK: PST07
ToDate: 2154-12-31
TaxRate: 7
TaxType: SalesTax
FromDate: 2023-01-01
TaxBasis: GrossAmount
PrintCode: PST
DataAreaId: USMF
TaxPurpose: SalesTax
Description: Provincial Sales Tax 7% (on GST)
RoundingForm: Normal
RoundingRule: Nearest
LedgerAccount: 220101
SettlementPeriod: MONTHLY
RoundingPrecision: 0.01
TaxCalculationMethod: Normal
ApplySalesTaxOnPayment: OnInvoice
TaxOnTax: GST05
ExemptCode: —

Tax Exempt Code (0% rate)

TaxCodeRPK: EXEMPT
ToDate: 2154-12-31
TaxRate: 0
TaxType: SalesTax
FromDate: 2023-01-01
TaxBasis: NetAmount
PrintCode: EXEMPT
DataAreaId: USMF
TaxPurpose: SalesTax
Description: Tax Exempt 0%
RoundingForm: Normal
RoundingRule: Nearest
LedgerAccount: 220100
SettlementPeriod: QUARTERLY
RoundingPrecision: 0.01
TaxCalculationMethod: Normal
ApplySalesTaxOnPayment: OnInvoice
TaxOnTax: —
ExemptCode: GOVT_EXEMPT

Rule Validation Summary

Source Rule Count: 23
Governed Rule Count: 23