Stored Procedure Interface
|Top Previous Next|
This is the interface to be interact with by any program.
ACC_CODE - Account code to be update.
ACC_YEAR - Account Year for this transaction.
ACC_PERIOD - Account Month for this transaction.
TRAN_TYPE - Any Code to represent current transaction type, such as invoice / delivery order.
TRAN_CODE - The actual document no / transaction no for the consume program for this transaction.
TRAN_NO - The actual running no / primary key (auto increment serial no) as integer for current transaction, pass -1 to ignore it (This is the master).
TRAND_NO - The actual running no / primary key (auto increment serial no) as integer for current details (This is the detail).
TRAN_DATE - Transaction Date.
ACC_AMT - Amount value for this transaction (Detail).
TRAN_DESC - Memo description.
DELETED - 0 for Normal transaction, 1 for deleted transaction.
Returns - Not use.
Cynics Accounting utilize stored procedure and trigger to provide online update for transactions, this is extreme fast compare to client site calculation.