Oldest known version of this page was edited on 2007-08-30 12:51:33 by LukeK []

01 vAPI_add_edit_tax_jurisdiction

Add/edit a tax jurisdiction

Inputs:

Input Name	Required	Type	Max Length	Details
$arg_array	YES	ASSOC	--	Details follow:
$arg_array / company_id	YES	INT	--	references: company_master.company_id
$arg_array / action	YES	ENUM	--	ADD: Create new tax jurisdiction record
				EDIT: Change G/L accounts for jurisdiction record
$arg_array / tax_jurisdiction_code	YES	STRING	16	references: tax_jurisdiction_master.tax_jurisdiction_code
$arg_array / state	YES	STRING	2	references: tax_jurisdiction_master.state
$arg_array / county	YES	STRING	32	references: tax_jurisdiction_master.county
$arg_array / city	YES	STRING	32	references: tax_jurisdiction_master.city
$arg_array / state_reporting_descr	YES	STRING	32	references: tax_jurisdiction_master.state_reporting_descr
$arg_array / state_tax_rate	YES	NUMERIC	6.6	references: tax_jurisdiction_master.state_tax_rate
$arg_array / county_tax_rate	YES	NUMERIC	6.6	references: tax_jurisdiction_master.county_tax_rate
$arg_array / city_tax_rate	YES	NUMERIC	6.6	references: tax_jurisdiction_master.city_tax_rate
$arg_array / opt1_tax_rate	YES	NUMERIC	6.6	references: tax_jurisdiction_master.opt1_tax_rate
$arg_array / opt1_tax_descr	YES	STRING	25	references: tax_jurisdiction_master.opt1_tax_descr
$arg_array / opt2_tax_rate	YES	NUMERIC	6.6	references: tax_jurisdiction_master.opt2_tax_rate
$arg_array / opt2_tax_descr	YES	STRING	25	references: tax_jurisdiction_master.opt2_tax_descr
$arg_array / opt3_tax_rate	YES	NUMERIC	6.6	references: tax_jurisdiction_master.opt3_tax_rate
$arg_array / opt3_tax_descr	YES	STRING	25	references: tax_jurisdiction_master.opt3_tax_rate
$arg_array / freight_taxable_flag	YES	BOOLEAN	--	references: tax_jurisdiction_master.freight_taxable_flag
$arg_array / labor_taxable_flag	YES	BOOLEAN	--	references: tax_jurisdiction_master.labor_taxable_flag
$arg_array / tax_record_type_flag	YES	ENUM	--	S: Sales tax
				U: Use tax
$arg_array / state_tax_gl_acct	YES	STRING	12	references: tax_jurisdiction_gl_accts.state_tax_gl_acct
$arg_array / county_tax_gl_acct	YES	STRING	12	references: tax_jurisdiction_gl_accts.county_tax_gl_acct
$arg_array / city_tax_gl_acct	YES	STRING	12	references: tax_jurisdiction_gl_accts.city_tax_gl_acct
$arg_array / opt1_tax_gl_acct	YES	STRING	12	references: tax_jurisdiction_gl_accts.opt1_tax_gl_acct
$arg_array / opt2_tax_gl_acct	YES	STRING	12	references: tax_jurisdiction_gl_accts.opt2_tax_gl_acct
$arg_array / opt3_tax_gl_acct	YES	STRING	12	references: tax_jurisdiction_gl_accts.opt3_tax_gl_acct
$dbconn	YES	DBHANDLE	--	Database Connection

Outputs:

Output Name	Type	Details
$record	ASSOC	Details follow:
$record / action	STRING	ADD: New record was added
		EDIT: Existing record was updated

Error Codes:

PGQUERY	Failed SQL query
INVALID_GL_ACCT	Supplied GL Account is invalid

Return to:
SalesTax_API Reference