External stored procedures: Accounting

TMTEXT_ACCOUNTS_CREATE

Creates new Accounts that show up in the Chart of Accounts.

Input Parameters

Parameter Name

Parameter Information

Parameter Description

@ACCOUNTID

VARCHAR, (24), Required

User defined account number

@PARENTACCT

VARCHAR, (24), Required

Whether account is Asset, Liability, Revenue or Expense

@GLTYPE

CHAR, (1), Required

A=Asset, E=Expense, L=Liability R=Revenue

@ACCTTYPE

VARCHAR, (12), Required

Up to a 12 character alphanumeric name for the account.

@DESCRIP

VARCHAR, (60), Required

A description of the Account type

@REFTYPE

CHAR, (2), Optional

Not currently being used

@REFID

VARCHAR, (12), Optional

Not currently being used

@BALTYPE

CHAR, (2), Required

Debit or Credit

@BALANCE

NUMERIC, (15,6), Required

Not currently being used

@OLD_ACCOUNTID

VARCHAR, (24), Optional

What is the old account ID

@OLD_ACCTTYPE

VARCHAR(12) Optional

What is the old account type

TMTEXT_ACCOUNTS_CREATE Example:
DECLARE @ACCOUNTID VARCHAR (24), @PARENTACCT VARCHAR (24), @GLTYPE CHAR (1), @ACCTTYPE VARCHAR (12), @DESCRIP VARCHAR (60), @REFTYPE CHAR (2), @REFID VARCHAR (12), @BALTYPE CHAR (2), @BALANCE NUMERIC (15,6), @OLD_ACCOUNTID VARCHAR (24), @OLD_ACCTTYPE VARCHAR (12)

— Set parameter values
SET @ACCTTYPE = '123456789012'
SET @ACCOUNTID = '123456789012'
SET @PARENTACCT = '1000'
SET @GLTYPE = 'E'
SET @DESCRIP = 'Expense Account'
SET @BALTYPE = 'DR'

EXEC [dbo].[TMTEXT_ACCOUNTS_CREATE] @ACCOUNTID, @PARENTACCT, @GLTYPE, @ACCTTYPE, @DESCRIP, @REFTYPE, @REFID, @BALTYPE, @BALANCE, @OLD_ACCOUNTID, @OLD_ACCTTYPE

TMTEXT_EXPORT_TRANSACTIONS

This stored procedure is used for exporting accounting transactions (accounts receivable, accounts payable, and general ledger).

Input Parameters

Parameter Name

Parameter Information

Parameter Description

@ACCT_TYPE

VARCHAR, (2), Required

Accounting export type
“GL” General Ledger
“AP” Accounts Payable
“AR” Accounts Receivable

@EXPORTED

VARCHAR, (3), Required

Export Type
“NON” non-exported transactions
“EXP” exported transactions
“ALL” both non-exported and exported transactions
Normally “NON” is specified

@START_DATE

SMALLDATETIME, Required

Date

@END_DATE

SMALLDATETIME, Required

Date

TMTEXT_EXPORT_TRANSACTIONS Output Parameters:
@ERROR_CODE — INTEGER
@LOG_ID — INTEGER

TMTEXT_EXPORT_TRANSACTIONS Example:
DECLARE @ACCT_TYPE VARCHAR(2), @EXPORTED VARCHAR(3), @START_DATE datetime, @END_DATE datetime, @ERROR_CODE int, @LOG_ID int

— Set parameter values
SET @ACCT_TYPE = 'GL'

EXEC [dbo].[TMTEXT_EXPORT_TRANSACTIONS] @ACCT_TYPE, @EXPORTED, @START_DATE, @END_DATE, @ERROR_CODE OUTPUT, @LOG_ID OUTPUT

SELECT @ERROR_CODE, @LOG_ID