META-INF.sql.tables.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of com.liferay.commerce.tax.engine.fixed.service

Liferay Commerce Tax Engine Fixed Service

There is a newer version: 4.0.44

Show newest version

create table CommerceTaxFixedRate (
	commerceTaxFixedRateId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPTaxCategoryId LONG,
	commerceTaxMethodId LONG,
	rate DOUBLE
);

create table CommerceTaxFixedRateAddressRel (
	CTaxFixedRateAddressRelId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	commerceTaxMethodId LONG,
	CPTaxCategoryId LONG,
	countryId LONG,
	regionId LONG,
	zip VARCHAR(75) null,
	rate DOUBLE
);