sure,
No Triggers,
No functions,
3 indexes Custno, Invno, IDTrans (all unique numbers)
1 rule: Ardetail.INVNO IS NOT NULL AND NOT Ardetail.INVNO IN (
SELECT INVNO FROM Ardetail #T1 WHERE #T1.INVNO = Ardetail.INVNO )
Table: Ardetail No Lock(s)
No. Column Name Attributes
--- ------------------ ------------------------------------------------------
1 CUSTNO Type : TEXT 6
Index : SINGLE-COLUMN
2 INVNO Type : TEXT 12
Index : SINGLE-COLUMN
3 SDATE Type : DATE
4 IDTRANS Type : TEXT 20
Index : SINGLE-COLUMN
5 INVAMT Type : CURRENCY
Default: 0
6 INVCUR Type : CURRENCY
Default: 0
7 PAYCUR Type : CURRENCY
Default: 0
8 PAYAMT Type : CURRENCY
Default: 0
9 CHKNO Type : TEXT 20
10 CHKDATE Type : DATE
11 CREDIT Type : CURRENCY
Default: 0
12 SVCHARGE Type : CURRENCY
Default: 0
13 CURBAL Type : CURRENCY
Default: 0
14 AFTER30 Type : CURRENCY
Default: 0
15 AFTER60 Type : CURRENCY
Default: 0
16 AFTER90 Type : CURRENCY
Default: 0
17 OVER120 Type : CURRENCY
Default: 0
18 SCDROPPED Type : CURRENCY
Default: 0
19 TOTSVCH Type : CURRENCY
Default: 0
20 INVBAL Type : CURRENCY
Default: 0
21 MONTHNO Type : INTEGER
22 SC_OK Type : TEXT 1
Default: Y
23 Posted Type : TEXT 1
24 SYEAR Type : INTEGER
25 SPERIOD Type : INTEGER
26 batchno Type : INTEGER
Current number of rows: 100476
At 09:07 AM 2/11/2010, you wrote:
Please post the structure of your table, including a list of
indexes, rules, triggers, and constraints that apply.
--
Larry
