01 vAPI_add_item_ledger_log

Add a log to item_ledger

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 / warehouse_code	YES	STRING	8	references: warehouse_master.warehouse_code
$arg_array / item_code	YES	STRING	32	references: item_master.item_code
$arg_array / employee_id	YES	INT	--	references: employee_master.employee_id
$arg_array / transaction_type	YES	STRING	10	references: item_ledger.transaction_type
$arg_array / transaction_number	YES	STRING	45	references: item_ledger.transaction_number
$arg_array / adjustment_type	YES	STRING	1	Adj. Type: Delta(+/-), Exact(=)
$arg_array / adjustment_value	YES	NUMERIC	15.3	references: item_ledger.adjustment_value
$arg_array / adjustment_field	YES	STRING	1	H: On Hand, A: Allocated, D: Due In, B: On Backorder
$arg_array / detail	YES	STRING	200	references: item_ledger.detail
$dbconn	YES	DBHANDLE	--	Database Connection

Outputs:
NONE

Error Codes:

PGQUERY

Failed SQL query

Return to:
Log_API Reference