General Tables
==================
These tables
apply to multiple modules.
------------------------------------------------------------------------
stxparmh -
Parameter Heading Reference Table
language char(3),
This column identifies the language being
used. (Join column)
module char(8),
This is the module name for which this
entry applies. (Join
column)
heading char(76)
This is the heading that will appear at
the top of the entry
screen to describe the module.
-----------------------------------------------------------------------
stxparmd -
Parameter Detail Table
language char(3),
This column identifies the language
being used. (Join column)
module char(8),
This is the module name for which this
entry applies. (Join
column)
user_id char(8),
User id. This will be used in future releases to
designate
behaviours unique to a user (or group of
users).
access_key char(30),
This column is used to store the access
key for this parameter.
Initially this column will contain the
existing column names
of the current control tables.
line_no integer,
This column is used to sequence the
parameters on the
entry screen.
userdef char(1),
This column is used to indicate that
the parameter was
defined by an end user. If this column
contains anything, then it will not be
deleted by an
install, and it will be used in
preference to the standard
definition if one exists with the same
access_key. It works
the same way userdef in the error files
works.
sbd_flag char(1),
This column indicates that this row is
a system based
parameter definition which cannot be
modified by a user.
parm_desc char(30),
This column is the description of the
parameter.
is_rule char(1),
This column indicates whether the
parameter is a validation
rule or just a value. This column is currently always set to
'N'.
It is intended for use in conjunction with future
features.
Y - Indicates that this parameter row
is a set of rules that
can be used for validation (or
other purposes.)
N - Indicates that this parameter is
just a value. (The
parm_value is validated with the
rules during maintenance.)
is_fatal char(1),
This column indicates whether the
parm_value entered can or
cannot be accepted. Initially, this will always be set to 'Y'.
Y - Indicates that the parm_value
entered must meet the criteria
set up by the rules. The user cannot leave the field
until a valid entry is made.
N - Indicates only a warning is given
and the parm_value can be
accepted as entered.
help_num smallint,
This column contains the help number
used to access help when
setting up this parameter.
Validation rule:
val_table char(30),
This column contains the table name
used to validate the
parm_value. It can contain more than one table name,
delimited
with commas. It is passed to the validation function via
put_vararg.
val_column char(60),
This column contains the column name
(or names) used to
validate the parm_value. It is passed to the validation
function via put_vararg.
val_filter char(60),
This column contains the selection
filter for validating the
parm_value. A '?' anywhere in this column indicates that
the
entered parm_value is substituted. It is passed to the
validation function via put_vararg.
val_join char(60),
This column contains the join criteria
for validating
parm_value. This column would be required if there were
more
than one table name listed in the
val_table column. It is
passed to the validation function via
put_vararg.
val_switchbox char(8),
This column contains the name of the
switchbox item that does
the validation. If this column is null, the entered value for
parm_value is not validated. The other validation columns are
passed (via put_vararg) to the
switchbox item before it is
called.
The function represented by this column is responsible
for interpreting the rule. It returns (via put_vararg) whether
it was successful, and the value from
the column specified by
val_description.
val_description char(18),
This column contains the name of the
column in the validation
table that contains the description of
the value in parm_value.
It is passed to the functions
represented by both the
val_switchbox and zoom_switchbox items.
Zoom rule:
zoom_filter char(60),
This column contains additional filter
criteria for a zoom.
There will usually be no value in this
column. It is passed
to the function represented by the zoom
switchbox item via
put_vararg. (It is also passed for auto_zoom.) This filter
is a "hard" filter to be
maintained by the zoom for the
duration of the call.
zoom_switchbox char(8),
This column contains the name of the
switchbox item that does
the zoom (and auto_zoom) on the
validation table. If this
column is null, no zoom is done. Val_table, val_column,
zoom_filter and val_description are passed
(via put_vararg).
parm_value char(32)
This column holds the actual parameter
value. This is what
this whole thing is about.
------------------------------------------------------------------------
stxprogr -
Program Security Table
module char(8) # module id (gl, ap, ar, oe, ic,
etc)
progname char(8) # program name without the .4ge
(p_invce)
description char(30) # short program description
use_trx smallint # open
database using transactions (T/F)
userdef char(1)
stxprogr is no longer being used to control
transactions, but it is
a table that is used by the security
module. For this reason, you
still need to keep stxprogr.unl
updated. It should contain one
entry for your module and then an entry for
each program in your
module.
The following is an example of the stxprogr.unl file that
would be used by a security module dbmerge
program:
security||Security
Module|||
security|i_funcs|Function
Information|||
security|i_grpid|Group
Information|||
security|i_progs|Module
& Program Info|||
security|i_usrid|User
Information|||
Notice the top
row. This is a Module Entry. Leave program name null
and put what
module it is in place of a description.
This is what
Security uses for
module name. You must have a Module
Entry in your
unload file.
note:
if the program running can't find itself in stxprogr, then if
it's name starts with 'p_' then it assumes
a posting routine
and defaults to database transactions,
otherwise the default
is no database transactions. This table is also used to
define the existence of a certain
module. If the control
table for the module is listed in this
table (ex: strcntrc for
a/r), then that module is installed on the
machine.
index1: module, prog_name
----------------------------------------------------------------------
stxactgd -
Account Groups Detail Table
grp_key char(6),
account group code
line_no smallint,
detail line number
acct_no integer,
chart of account number
department char(3)
department code
-----------------------------------------------------------------------
stxactgr -
Accounts Group Header
grp_key char(6),
account group key
grp_desc char(30)
account group description
-----------------------------------------------------------------------
stxaddld- The
User-Defined Field Detail Table
filename char(18),
name of file
record_key char(20),
record key
line_no smallint,
line number for entry
data char(30)
data for entry
----------------------------------------------------------------------
stxaddlr - The
User-Defined Reference Table
filename char(18),
name of file
line_no smallint,
line number for entry
field_label char(20)
label given to defined field
----------------------------------------------------------------------
stxchrtd - The
Chart of Accounts History and Balance Table
acct_no integer,
not null, chart of account number
department char(3),
not null, department code
period_month char(2),
not null, accounting period
period_year char(4),
not null, accounting year
activity decimal(12),
activity amount for a given period
balance decimal(12),
YTD balance amount
will be postive if the balance
represents a credit
balance and the account is increased
with a credit;
will be positive if the balance
represents a debit
balance and the account is increased
with a debit.
you need to determine if the account is
increased
with a credit or debit & display
accordingly.
this_month decimal(12),
current period amount
budget decimal(12)
user defined budget amount for the account-dept-period
The only purpose
of this column is that it allows us to identify amounts
posted to a
period after that period is closed.
p_genled posts to
this_month. Begin a new period, adds this_month to
activity. I was
wondering why we
don't post directly into the activity column since
activity reflects
only activity for the current period.
The answer is
that when we are
in a subsequent month and post to an earlier period:
it goes to
this_month and therefore we can identify this has occurred.
The balance for
the account is always correct. If you
post to an
earlier year for
a revenue or expense account,the p_genled automatically
zeroes out an
expense or revenue type of account and puts the balancing
posting to
Retained earnings in the current year.
QUESTION
when are rows
initially entered into this table: under sample, I have
set gl setup to
complete, I have entered some transactions, & I
have posted the
general journal. At this point there is
only 1 document
in this table for
3100 (retained earnings).The activity is null &
balance is 0 and
this_month is null. It is for period 12
1990 which is
my current
period.
ANSWER
During setup:when
you enter budgets for accounts, after setting setup to
complete, I think
rows must be created for those accounts in the
stxchrtd table.
Posting general
ledger activity to the chart of accounts
(Post G/L
Activity to Ledger) creates rows
for each account
that shows some activity.
QUESTION
some rows in this
table have a negative "this_month" & "balance"
field. does this represent a credit if the account
is normally
increased with a
debit & vice versa (a debit if the account is normally
increased with a
credit)
1 row for each
account/department combination for each period:
- where the user
has created a budgeted amount
(under Update Ledger Balances you can set up
budgets for past & future
periods for a particular account/dept). When this is done, a row is
created in the stxchrtd table.
- the begin a new
period program updates "activity" & "this_month"
columns in existing rows & adds a new row
for the new period for
every account/department combination.
Programs
accessing/updating this table:
p_genled
if period being
posted to is "00"
then amount of posting is added to existing
value in "activity" column
else if
posting to some other period (not 00)
then amount of posting is added to existing
value in "this_month"
column
the balance is
recalculated
p_newpr1.4gs begin a new period
- modifies columns & adds/deletes rows
- "this_month" column is added to
"activity" column
"this_month" is zeroed out
-----------------------------------------------------------------------
stxchrtr- Chart
of Accounts Reference Table
acct_no integer,
not null, account number
acct_type char(15),
account type: ASSET, LIABILITY,
CAPITAL, INCOME, COST OF GOODS,
EXPENSE
acct_desc char(30),
account description
acct_cat char(1),
account category: A = asset account
B = liability
account
C = capital
account
D = income
account
E = cost of goods
account
F = expense
account
processing_seq char(1),
processing sequence: 1 = current
assets
2 = fixed asset
3 = current
liability
4 = long term liability
5 = capital
6 = income
7 = cost of goods
8 = expense
incr_with_crdt char(1),
increase with a credit? [Y/N]
subtotal_group char(30)
subtotal group heading
manual_journal char(1)
account to be used when entering
manual joural entries? [Y/N]
----------------------------------------------------------------------
stxckrgd - Check
Register Detail Table
orig_journal char(2),not null
Original Journal
doc_no integer, not null
Document Number
acct_no integer,
General Ledger Account Number
department char(3),
General Ledger Department Number
inv_chk_no char(10),
Check Number
amount decimal(12),
Check Amount
debit_credit char(1),
Debit or Credit Amount
reconciled char(1),
Has this check been reconciled?
chk_voided char(1)
Has this check been voided?
-----------------------------------------------------------------------
stxckrgr - Check
Register Reference Table
acct_no integer,
General Ledger Account Number
department char(3)
General Ledger Department Code
bank_code char(10),
Bank Code
bank_name char(30),
Bank Name
branch char(10),
Branch
branch_name char(30),
Branch Name
account_name char(30),
Account Name
bank_address char(60),
Bank Address
bank_account_no char(35)
Bank Account Number
next_check_no char(10)
Next Check Number
-----------------------------------------------------------------------
stxcntrc -
General Company Control Table
co_name char(30),
company name
addr1 char(30),
address #1
addr2 char(30),
address #2
city char(20),
city
state char(2),
state
zip char(10),
zip
county char(2),
county
country char(2),
country
curr_asset integer,
first current asset account
d_curr_asset char(15),
description "Current Assets"
fixed_asset integer,
first fixed asset account
d_fixed_asset char(15),
description "FIXED ASSETS"
curr_liab integer,
first current liability account
d_curr_liab char(15),
description "CURRENT
LIABILITIES"
long_term_liab integer,
first long term liability account
d_lng_trm_liab char(15),
description "LONG TERM
LIABILITIES"
capital integer,
first capital account
d_capital char(15),
description "CAPITAL"
income integer,
first income account
d_income char(15),
description "INCOME"
cost_goods integer,
first cost of goods account
d_cost_goods char(15),
description "COST OF GOODS"
expense integer,
first expense account
d_expense char(15),
description "EXPENSES"
mtax char(1),
Use Multilevel Taxes?
use_mtax_grps char(1),
Use Multilevel Tax Groups ?
html_serialno char(12),
HTML Serial No
advance_serialno char(12),
ADVANCE Serial No
server_timeout char(8),
Server Time Out
server_url char(60),
Server URL
trn_auth_api char(60),
Trans. Authorize
trn_sts_req_api char(60),
Trans. Status Request
trn_chg_req_api char(60),
Trans. Change Request
batch_upd_api char(60),
Batch Upload
batch_sts_req_api char(60),
Batch Status Request
batch_chg_req_api char(60),
Batch Change Request
ccard_on char(1),
Is SkipJack Credit card on?
r_addr1 char(30),
Remit address1
r_addr2 char(30),
Remit address2
r_city char(20),
Remit city
r_state char(2),
Remit state
r_zip char(10),
Remit zip
r_country char(2)
Remit country
web_services_on char(1)
Interface to Fedex and UPS web services
post_err_notify char(1)
To set posting error pop-up display
gwc_server char(60)
Help text for the gwc_server field
use_barcode char(1)
Turn barcode on/off based on customer
pref
apache_id char(8)
Apache ID field to capture the ID used
to run the httpd daemon
-----------------------------------------------------------------------
stxcompr -
Company and Database Definition Table
comp_id char(8),
company code
db_name char(14),
database name
logfile char(150),
logfile path
line_no smallint,
line number
consolidate smallint
-----------------------------------------------------------------------
stxcurrr - Multicurrency Reference Table
currency_code char(3),
currency code used to refer to this
currency
description char(30),
description of this currency
curr_ex_rate decimal(16),
current exchange rate
per_ex_rate decimal(16),
period exchange rate
ex_diff_acct_no integer
account number used for exchange
differences
The reason to add this table to basefiles
and not the multicurrency
module is that the ar, ar, and eventually
gl, oe, po have to
compile without the multicurrency module
installed. These modules
must include screens and code to handle the
multicurrency feature
even though multicurrency is not
installed. The plan is to use
table_exist("stmcntrc") to see if multicurrency is installed and
based on this call the appropriate
routines. To make a long
story short, rather than hard code the
references to the currency
table we would like to add the currency
table to basefiles.
example of what I mean by hard coding:
define
curr_ex_rate decimal(20)
It would be much more maintainable to use:
define
curr_ex_rate like stxcurr.currr_ex_rate
this is the reason for adding this table to
basefiles instead of
to the multicurrency module.
-----------------------------------------------------------------------
stxerord - Error
Text Detail Table
language char(3), #language
userdef char(1),
err_module char(8) # module origin
err_program char(8) # program origin
err_number smallint # error number
a_b char(1) # type of error text:
[a]-cause of
error
[b]-solutions
line_no smallint # line number (for sorting
purposes)
err_text char(60) # text
-----------------------------------------------------------------------
stxerorh - Error
Text Header Table
language char(3),
userdef char(1),
err_module char(8) # module origin
err_program char(8) # program origin
err_number smallint # error number
err_line char(40) # error description
-----------------------------------------------------------------------
stxfiltr -
Selection Criteria Filter Table
It is used for
scheduling reports which you have to code by hand. There
is an example of
how to do this in one of the Tech Ref's.
unique_id char(15) # unique id assigned to record
seq_no smallint # sequence number
sel_filter char(200) # filtered data
-----------------------------------------------------------------------
stxfiler - is
used in the function fg_file() in standard.4gs. It allows
you to run an os
command and takes the output from the command and loads
it into this
table. It then fetches the data one line
at a time from
the table.
uniq_num
integer # unique
number
line_no
serial, not null # line number
line_text char(248) # line text
------------------------------------------------------------------------
stxhelpd - Help
Text Table
language char(3), #language
userdef char(1),
hlp_module char(18), # module origin
hlp_program char(18), # program origin
hlp_number smallint, # help number
[1]-header [2]-detail
[3]-user
defined
line_no smallint, # line number
hlp_text char(60) # text
-----------------------------------------------------------------------
stxinfor -
Generic Information Table
This table is
used to store generic codes & descriptions
src_type char(1), # information type used to
date:
[S]-
general journal source
[D]- department
[W]-
warehouse(no longer used)
[P]-
product class
[L]- sales
personnel
[T]- sales tax
[C]-
commission
[R]-
debit/credit reason
[I]-
discount
[B]- buyer
[M]- method of
payment
[A]- cash
asset account
src_key char(6), # information key
src_desc char(30), # information description
src_num_desc decimal(12), # additional numeric description
src_char_desc char(6), # additional character description
src_acct_no integer, # additional account description
src_email char(50), # email account
src_phone char(20), # telephone number
src_cell char(20), # cell phone number
src_fax char(20) # FAX number
src_login char(10) # Salesperson login logic
index1: src_type, src_key (unique)
-----------------------------------------------------------------------
stxperdr -
Accounting Periods Reference Table
period char(2) # period (00 - 99)
period_year char(4) # period year (0000 - 9999)
start_date date # start date of period
end_date date # end date of period
balanced char(1) # is period under G/L control?
- this is a system-maintained field
(always)
- during setup all rows have the balanced
field set to "N".
When setup is set to complete, the
balance column in the row
corresponding to the current period is
set to "Y".
As future periods become the current
period,the balanced field in
is set to Y. Once this field is set to
"Y", it is never reset to
"N".
notes: The 00 period is the period where
income statement type
accounts post their offsetting amounts
into retained earnings.
1 to 99 accounting periods per year are
supported
dates well past the year 2000 are
supported
menu options that
access this table:
Update G/L
Defaults
Print G/L
Defaults
Begin a New
Period
-----------------------------------------------------------------------
stxpermd -
Program Permission Detail Table
user_id char(8), # User ID
progname char(8), # Program name
module char(8), # Module
permission char(1) # Permission
-----------------------------------------------------------------------
stxpermr -
Permission Reference Table
user_id char(8), # User Id
lname char(20), # User Last Name
fname char(20), # User First Name
minitial char(1), # User Middle Initial
company char(30), # Company
dept char(15), # Department
responsibility char(30), # Responsibility
phone char(15), # Telephone
pattern char(8) # Pattern
create unique
index i1xpermr on stxpermr (user_id);
-----------------------------------------------------------------------
stxtranr - Master
Transaction Identification Table
orig_journal char(2) # What journal did this trx. come from ?
doc_no integer # document number (unique identifier)
post_no integer # posting sequence number (on post
rpts)
post_date date # (system) date of posting
doc_date date # document date (entered)
ref_code char(20) # customer/vendor/(journal code for G/L)
doc_desc char(30) # verbal document description
user_id
char(8) # User ID
bank_deposit_id integer # bank deposit ID (Used in Reconciliation)
create unique
index i1xtranr on stxtranr (orig_journal,doc_no);
create index
i2xtranr on stxtranr (ref_code);
-----------------------------------------------------------------------
stxuniqc -
Temporary Document Id Table
uniq serial # temporary doc id for joins
between
header and detail screens in
data-entry tables
-----------------------------------------------------------------------
stxacknd -
Programmer Acknowledgements Table
ack_module char(8), # Acknowledgement Module
ack_program char(8), # Acknowledgement Program
line_no smallint, # Line Number
ack_text char(60) # Acknowledgement Text
-----------------------------------------------------------------------
stxcrtpr -
Multicurrency Rate Type Reference
rate_type char(6)
rate type
"DAILY" or "STAND"
rate_desc char(30)
rate description
rate_frequency char(1)
rate frequency
-----------------------------------------------------------------------
stxdcrtr -
Multicurrency Daily Currency Exchange Rate
from_currency_code char(3)
from currency code
to_currency_code char(3)
to currency code
rate_type char(6)
rate type "DAILY"
currency_date date
date of currency rate
rate decimal(16)
currency rate
create unique
index i1xdcrtr on stxdcrtr (from_currency_code,
to_currency_code,rate_type,currency_date);
----------------------------------------------------------------------
stxhotkd - Hot
Key Detail Table
hot_key smallint,
hot key unique number
act_key char(15),
action key
hot_module char(8),
module where hot key is active
hot_program char(8),
program where hot key is active
hot_user char(10)
user name
hot_visable char(1)
Show Button R=Right Frame N=Not Shown
hot_bmp (char(1)
Is there a bmp file ?
hot_bmpname char(24)
bmp file name
----------------------------------------------------------------------
stxkeysr - Hot
Key Reference Table
key_code smallint,
unique code
key_desc char(15)
description (i.e. CTRL-A, F1 or TAB,
etc)
----------------------------------------------------------------------
stxmssgr -
Message Reference Table
language char(3),
language
mssg_module char(8),
message module
mssg_program char(8),
message program
mssg_number smallint,
message number
message char(132)
message text
create unique
cluster index i1xmssgr on stxmssgr (language,mssg_module,
mssg_program,mssg_number);
-----------------------------------------------------------------------
stxmtaxd - Multilevel Tax Detail Table
doc_no integer,
document number
orig_journal char(2),
original journal
inv_doc_no integer,
invoice document number
post_no integer,
posting number
inv_no char(20),
invoice number
post_date date,
posted date
mtax_code char(6),
multilevel tax code
acct_no integer,
gl account number
dept char(3),
gl department code
goods decimal(12),
goods
mtax_amt decimal(12),
multilevel tax amount
disc_amt decimal(12),
multilevel tax discount amount
debit_credit char(2)
debit or credit
create index
i1xmtaxd on stxmtaxd (orig_journal,doc_no);
create index
i2xmtaxd on stxmtaxd (acct_no,mtax_code);
-----------------------------------------------------------------------
stxmtaxr -
multilevel tax code reference
mtax_code char(6) not null,
multilevel tax code
mtax_rate decimal(6),
multilevel tax rate
ar_acct_no integer,
accounts receivable gl account number
ar_disc_acct_no integer,
accounts receivable discount gl account
number
ap_acct_no integer,
accounts payable gl account number
ap_disc_acct_no integer,
accounts payable discount gl account
number
mtax_desc char(20),
multilevel tax code description
mtax_country char(20),
multilevel tax code country
mtax_st_prvc char(2),
multilevel tax code state or province
department char(3),
department
include_tax char(1)
include tax in asset/expense?
----------------------------------------------------------------------
stxmtxgd -
multilevel group tax codes - detail
mtaxg_code char(6),
multilevel group tax code
line_no smallint,
line number for sorting
mtax_code char(6),
multilevel tax code
cumulative char(1)
is tax cumulative?
----------------------------------------------------------------------
stxmtxgr -
multilevel tax group code - header
mtaxg_code char(6),
multilevel group tax code
mtaxg_desc char(20)
multilevel group tax description
----------------------------------------------------------------------
stxmtxpr -
multilevel tax period
period char(2),
mutilevel tax period
period_year char(4),
mutilevel tax period year
start_date date,
start date of period
end_date date
end date of period
----------------------------------------------------------------------
stxnoted - Note Table
(Sticky-Note)
filename char(18) not null,
table that note is attached to
record_key char(30),
record that note is attached to (ie,customer,vendor,etc)
line_no smallint,
line number for sorting
data char(60)
actual note
create index
i1xnoted on stxnoted (filename,record_key);
----------------------------------------------------------------------
stxnvgtd -
Navigation Event Detail Table
act_key char(15),
action code
line_no smallint,
line number
nav_module char(8),
module that navigation event is
attached to
nav_program char(8),
program that navigation event is
attached to
nav_user char(10)
user
----------------------------------------------------------------------
stxpcrtr - Period
Multi-currency Exchange Rate
from_currency_code char(3),
from currency code
to_currency_code char(3),
to currency code
rate_type char(6),
rate type "STAND"
period char(3),
period this rate is effective
period_year char(4),
period year this rate is effective
rate decimal(16)
currency exchange rate
create unique
index i1xpcrtr on stxpcrtr (from_currency_code,
to_currency_code,rate_type,period,period_year);
----------------------------------------------------------------------
stxtaxld -
Multilevel Tax
orig_journal char(2),
original journal
doc_no integer,
document number
inv_doc_no integer,
invoice document number
mtax_code char(6),
multilevel tax code
mtax_rate decimal(6),
multilevel tax code
acct_no integer,
gl account number
dept char(3),
gl department code
goods decimal(12),
goods
mtax_amt decimal(12),
multilevel tax amount
debit_credit char(2),
debit or credit
frozen char(1)
frozen
create index
i1xtaxld on stxtaxld (orig_journal,doc_no,inv_doc_no);
-----------------------------------------------------------------------
stxtodod - To-Do
Notes Detail Table
todo_user char(10), # User ID
line_no smallint, # Line number for sorting
todo_text char(60) # To-Do note text
-----------------------------------------------------------------------
stxtxtdd -
Default Notes Text Table
txt_key char(30), # Text Key
line_no smallint, # Line Number
dflt_text char(74) # Default Text
-----------------------------------------------------------------------
stxsecur -
Security - User Detail Table
user_id char(8), # User Id
lname char(20), # Last Name
fname char(20), # First Name
minitial char(1), # Middle Initial
company char(30), # Company
dept char(15), # Department
responsibility char(30), # Responsibility
phone char(15) # Telephone
email char(60) # Email address
create unique
index i1xsecur on stxsecur (user_id);
----------------------------------------------------------------------
stxsecud -
Security - User Program Detail Table
user_id char(8), # User ID
module char(8), # Module
progname char(8), # Program Name
funcname char(20), # Function Name
allow_flag char(1) # Allow Flag
create index
i1xsecud on stxsecud (user_id,module,progname,funcname);
-----------------------------------------------------------------------
stxgropr -
Security - Group Reference Table
group_id char(8), # Group ID
description char(30) # Group Description
create unique
index i1xgropr on stxgropr (group_id);
-----------------------------------------------------------------------
stxgropd -
Security - Group Detail Table
group_id char(8), # Group ID
user_id char(8) # User ID
create index
i1xgropd on stxgropd (group_id,user_id);
-----------------------------------------------------------------------
stxfuncr -
Functions Reference Table
module char(8), # Module
progname char(8), # Program Name
funcname char(20), # Function Name
description char(30), #
Description
allow_flag char(1), # Allow Flag
userdef char(1)
create index
i1xfuncr on stxfuncr (module,progname,funcname);
-----------------------------------------------------------------------
stxbtchh Batch Control Table
batch_id serial not null Batch ID
batch_type char(2) Batch Type
AR =
Receivable Document
CR = AR
Cash Receipt
AP = Payables Document
CD =
Payable Cash Disbursement
GJ =
General Journal
OE = Order
Entries Invoice
PR = Purchasing Receipt
PU =
Purchasing Invoice
batch_status char(3) Batch Stages
ACT =
Active Batch
APR =
Approved
CAN = Cancelled
Batch
PST =
Posted Batch
owner char(8) Batch Owner
created_by char(8) Who Created Batch
create_date date Date Batch was Created
create_time char(8) Time Batch was Created
approved_by char(8) Who approved Batch
approve_date date Date Batch was Approved
approve_time char(8) Time Batch was Approved
posted_by char(8) Who posted the batch
post_date date Date the batch was posted
post_time char(8) Time the batch was posted
post_seq integer Posting sequence number
total_trx integer Total transactions posted
-----------------------------------------------------------------------
stxbtchs - Batch
Table
user_id char(8) User Id
batch_type char(2) Batch Type
batch_id integer Batch ID
-----------------------------------------------------------------------
stxactnr - Hot
Key Action Reference Table
language char(3) Language
act_key char(15) Action Key
description char(30)
Description
os_command char(74) Operating System Command
press_enter char(1)
Press Enter ?
buttontext char(32) Button Text
-----------------------------------------------------------------------
stxcntrd -
Additional Company Info Detail Table
record_key
char(20) Record Key
data char(30) Data
-----------------------------------------------------------------------
stxlangr - Multi
Language Reference Table
language char(3)
tr_tab_col char(37)
tr_context char(10)
native char(50)
non_native char(50)
-----------------------------------------------------------------------
stxlookd - Look
Up Detail Table - Replenishment Only
lookup_code char(14)
Look up code
colname char(37) Column name
-----------------------------------------------------------------------
stxlookr - Look
up Reference Table - Replenishment Only
lookup_code char(14)
Look up code
description char(30)
Description
select_statement char(200
Select Statement
hard_filter char(200) Hard Filter
-----------------------------------------------------------------------
stxsviar - Ship
Via Reference Table
ship_via_cd char(3),
Ship Via Code
ship_via_desc char(15), Ship Via Description
-----------------------------------------------------------------------
stxcntry -
Country Reference Table
country_code char(2), Country Code
description char(40) Country
-----------------------------------------------------------------------
stxmssgh - Banner
Messages Header
doc_no serial, Serial Doc Number
eff_date date, Date
prog_name char(18), Program Name
prog_desc char(30) Program Description
-----------------------------------------------------------------------
stxmssgd - Banner
Messages Detail
doc_no integer, Join with stxmssgh
line_no smallint, Line number
line_text char(60) Line text
-----------------------------------------------------------------------
stxmssgp - Banner
Messages Programs
prog_name char(18), Program Name
prog_desc char(30) Program Description
-----------------------------------------------------------------------
stxckrgh -
Reconciliation Header
bank_code char(10), # Bank Code
branch char(10), # Branch
statement_date date, # Statement Date
gl_balance decimal(12,2), # Gl Balance
not_reconciled decimal(12,2), # Not Reconciled
adjustments decimal(10,2), # Adjustments
difference decimal(12,2), # Difference
statement_amount decimal(12,2), # Statement Amount
reconciled char(1) # Reconciled
-----------------------------------------------------------------------
stxckrdd -
Reconciliation Detail
bank_code char(10), # Bank Code
branch char(10), # Branch
statement_date date, # Statement Date
reconciled char(1), # Reconciled
doc_date date, # Doc Date
orig_journal char(2), # Orig Journal
doc_no integer, # Doc Number
inv_chk_no char(10), # Inv or Deposit Number
debit_credit char(1), # Debit or Credit
doc_desc char(30), # Doc Description
amount decimal(12) # Amount
-----------------------------------------------------------------------
stxcityr - City
Reference Table
country_code char(2), # Country Code
city char(40) # City
-----------------------------------------------------------------------
stxfddre -
Flexible Document Delivery Setup Header
document char(20), # Document to process (i.e. ar:o_invce)
title char(50) # Report Description
-----------------------------------------------------------------------
stxfddrd -
Flexible Document Delivery Setup Detail
contact char(20), # Customer or Vendor Code
type char(5), # C - Customer / V - Vendor
document char(20), # Document to process (i.e. ar:o_invce)
print smallint, # 1 to print or 0 no
email smallint, # 1 to email or 0 no
email_address char(50), # Email address
subject char(50), # Subject
fax smallint, # 1 to fax or 0 no
fax_number char(20), # Fax number
fax_contact char(30), # Fax Contact
fax_fail_notify char(50) # Notifiy Email address if fax fails
-----------------------------------------------------------------------
stxevtmr -
Framework for sending event-based messages Reference
event_name char(20), # Event name
recipient char(50), # Recipient email address
conditional_exp char(80) # Conditional Expression
-----------------------------------------------------------------------
stxevtms -
Framework for sending event-based messages Header
event_name char(20), # Event name
status char(1), # Y - Active / N - Incactive
description char(50), # Event description
msg_type char(10), # Message Type (i.e. EMAIL)
msg_header char(200) # Message Header
x_priority smallint # X Priority
-----------------------------------------------------------------------
stxevtmd -
Framework for sending event-based messages Detail
event_name char(20), # Event name
sequence smallint, # Sequence
msg_detail char(60) # Message Detail
-----------------------------------------------------------------------
stxmapte - Create
rebate import mapping tables
tablename char(20) # Table Name
template char(20) # Template
-----------------------------------------------------------------------
stxmaptd - Create
rebate import mapping tables
tablename char(20), # Table Name
template char(20), # Template
sheet_column char(3), # Sheet Column
column_no smallint, # Column Number
db_column char(20) # Database Column
-----------------------------------------------------------------------
stxprntd -
Printer Definition
default_printer char(40) # Default Printer
-----------------------------------------------------------------------
stxprntr - Define
default printer by program
prog_name char(18), # Program Name
prog_desc char(30), # Program Description
default_printer char(40) # Default Printer
user_id char(8) # Default user id for hand-held
programs
-----------------------------------------------------------------------
stxevtrp ---
EVenT RePort --- FR2664
event_name char(20), - Event Name
sequence smallint, - Sequence
report_module char(8), - Report Module
report_program char(8), - Report Program
report_progver char(8), - Report Pro version
report_params char(200), - Report parameters
report_filename char(60), - Report File name
attach_encrypt char(1), - Attach encrypted?
attach_passwd char(20)) ; - Attach password
-----------------------------------------------------------------------
stxevtmc --- Add
table for Cc addresses --- FR2664
event_name char(20), - Event Name
cc_recipient char(60), - CC Recipient
conditional_exp char(80) - Conditional Expresion
-----------------------------------------------------------------------
stxevtmb --- Add
table for BCc addresses --- FR2664
event_name char(20), - Event Name
bcc_recipient char(60), - BCC Recipient
conditional_exp char(80) - Conditional Exp.
-----------------------------------------------------------------------
stxevtmy --- Add
table for Reply-to addresses --- FR2664
event_name char(20), - Event Name
reply_recipient char(60), - Reply
conditional_exp char(80) - Conditional
-----------------------------------------------------------------------
stxemaph ---
Mapping table for email addresses ---
FR2664
user_id char(20), - User ID
email_address char(60) ); - Email address
-----------------------------------------------------------------------
cgsmnrol ---
Utility to generate role based menus ---
FR3079
ckey char(3), - Control Key
user_id char(20), - User ID
user_default char(1) - User role default
-----------------------------------------------------------------------
stxmngrh ---
Utility to generate role based menus ---
FR3079
group_id char(20), - Group ID
-----------------------------------------------------------------------
stxmngrd ---
Utility to generate role based menus ---
FR3079
group_id char(20), - Group ID
user_id char(20) - User ID
-----------------------------------------------------------------------
stxmnith ---
Utility to generate role based menus ---
FR3079
c_ckey char(3), - Control Key
description char(30) - Description
-----------------------------------------------------------------------
stxmnitm ---
Utility to generate role based menus ---
FR3079
c_ckey char(3), - Control Key
line_no smallint, - Line number
c_txt char(64), - Clone Text
c_mname char(32), - Clone Menu name
c_opt char(1), - Clone Menu option
c_mtype char(2), - Clone Menu Type
txt char(64), - Text
mname char(32), - Menu name
opt char(1), - Menu option
mtype char(2) - Menu Type
-----------------------------------------------------------------------
stxrmnid ---
Utility to generate role based menus ---
FR3079
c_ckey char(3), - Contorl Key
user_id char(20), - User Id
user_default char(1) - User default
-----------------------------------------------------------------------
stxrmnih ---
Utility to generate role based menus ---
FR3079
user_id char(20), - User Id
-----------------------------------------------------------------------
stxmnrtp ---
Include Real Time Processing options on user defined Roles - MR3578
mname char(32), - Menu name
opt char(1) - Option