Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Are there lookup tables for Macola ES? 1

Status
Not open for further replies.

jdbrande

Programmer
May 7, 2013
13
US
I am playing with the bank transaction table and I am trying to find a lookup table for the type and status.. what do the letters stand for.

for type I have C S W
for status I have C J V
 
Macola ES does have a lookup table....it is called DDTests.

select *
from DDTests
where TableName = 'BankTransactions'

For Type
C=template
S=cashflow
W=term

For Status
C=entered
J=journalized
V=void

Enjoy!

Jen
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top