Stored Procedure Interface

Top  Previous  Next

clip0135

Figure 18

 

 

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.

 

 

clip0136

Figure 19

 

Cynics Accounting utilize stored procedure and trigger to provide online update for transactions, this is extreme fast compare to client site calculation.