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

01 vAPI_add_edit_vendor

Add/edit vendor record

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 / employee_id	YES	INT	--	references: employee_master.employee_id
$arg_array / vendor_code	YES	STRING	25	references: vendor_master.vendor_code
$arg_array / billing_name	YES	STRING	32	references: vendor_master.billing_name
$arg_array / billing_address_1	YES	STRING	32	references: vendor_master.billing_address_1
$arg_array / billing_address_2	YES	STRING	32	references: vendor_master.billing_address_2
$arg_array / billing_address_3	YES	STRING	32	references: vendor_master.billing_address_3
$arg_array / billing_city	YES	STRING	32	references: vendor_master.billing_city
$arg_array / billing_locality	YES	STRING	32	references: vendor_master.billing_locality
$arg_array / billing_mailing_code	YES	STRING	16	references: vendor_master.billing_mailing_code
$arg_array / billing_country	YES	STRING	32	references: vendor_master.billing_country
$arg_array / billing_contact_name	YES	STRING	32	references: vendor_master.billing_contact_name
$arg_array / billing_phone	YES	STRING	32	references: vendor_master.billing_phone
$arg_array / billing_fax	YES	STRING	32	references: vendor_master.billing_fax
$arg_array / billing_email	YES	STRING	128	references: vendor_master.billing_email
$arg_array / billing_account_code	YES	STRING	16	references: vendor_master.billing_account_code
$arg_array / po_name	YES	STRING	32	references: vendor_master.po_name
$arg_array / po_address_1	YES	STRING	32	references: vendor_master.po_address_1
$arg_array / po_address_2	YES	STRING	32	references: vendor_master.po_address_2
$arg_array / po_address_3	YES	STRING	32	references: vendor_master.po_address_3
$arg_array / po_city	YES	STRING	32	references: vendor_master.po_city
$arg_array / po_locality	YES	STRING	32	references: vendor_master.po_locality
$arg_array / po_mailing_code	YES	STRING	16	references: vendor_master.po_mailing_code
$arg_array / po_country	YES	STRING	32	references: vendor_master.po_mailing_code
$arg_array / po_phone	YES	STRING	32	references: vendor_master.po_phone
$arg_array / po_fax	YES	STRING	32	references: vendor_master.po_fax
$arg_array / po_email	YES	STRING	128	references: vendor_master.po_email
$arg_array / po_account_code	YES	STRING	16	references: vendor_master.po_account_code
$arg_array / comments	YES	STRING	75	references: vendor_master.comments
$arg_array / extended_comments	YES	TEXT	--	references: vendor_master.extended_comments
$arg_array / active_flag	YES	BOOLEAN	--	references: vendor_master.active_flag
$arg_array / purchase_method_code	YES	ENUM	--	references: vendor_purchasing_master.purchase_method_code
				: NULL: Don't make purchasing suggestions
				: MINMAX: Make purchasing suggestions using Min/Max
$arg_array / freight_factor	NO	NUMERIC	7.5	references: vendor_master.freight_factor
$arg_array / discount_percent	YES	NUMERIC	5.2	references: vendor_master.discount_percent
$arg_array / discount_days	YES	INT	--	references: vendor_master.discount_days
$arg_array / restock_fee	YES	MONETARY	--	references: vendor_master.restock_fee
$arg_array / restock_percent	YES	NUMERIC	5.2	references: vendor_master.restock_percent
$arg_array / po_output_process	YES	ENUM	--	references: vendor_master.po_output_process
				EMAILTXT: Send P/O as plain email
				EMAILPDF: Send P/O as email PDF attachment
				FAX: Send P/O as FAX
				PRINT: Print P/O
$arg_array / minimum_order_units	YES	ENUM	--	references: vendor_master.minimum_order_units
				$: Dollars
				#: Weight
				U: Units
$arg_array / minimum_order_quantity	YES	INT	--	references: vendor_master.minimum_order_quantity
$arg_array / prepaid_order_units	YES	ENUM	--	references: vendor_master.prepaid_order_units
				$: Dollars
				#: Weight
				U: Units
$arg_array / prepaid_order_quantity	YES	INT	--	references: vendor_master.prepaid_order_quantity
$arg_array / omit_po_prices_cost	YES	BOOLEAN	--	references: vendor_master.omit_po_prices_cost
$arg_array / payment_method	YES	ENUM	--	references: vendor_master.payment_method
				CHECK: Pay vendor by check
				ACH: Pay vendor by wire
				CCARD: Pay vendor by credit card
				OCHK: Pay vendor by office check
$arg_array / bank_routing_number	YES	NUMERIC	12	references: vendor_master.bank_routing_number
$arg_array / bank_account_number	YES	NUMERIC	15	references: vendor_master.bank_account_number
$arg_array / bank_account_type	YES	ENUM	--	references: vendor_master.bank_account_type
				CHECKING: Checking account
				SAVINGS: Savings account
				CUNION: Credit union
$arg_array / ebay_qty_sched_stop	YES	INT	--	references: vendor_master.ebay_qty_sched_stop
$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
CHECKPOINT	Error when calling the checkpoint function

Called API Functions:
logAPI:vAPI_checkpoint_table_revision

Return to:
Vendor_API Reference