Module List > Module DTA tables DTA00700
You are currently viewing the COMPANY database.
Change

COMPANY..DTA00700 Table Definition

(COMPANY..Transaction Analysis Report Options)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
RPTGRIND smallint
0

RTGRSBIN numeric(19,5)
0.00

RTPACHIN smallint
0

STTACNUM_1 char(5)
''

STTACNUM_2 char(5)
''

STTACNUM_3 char(5)
''

STTACNUM_4 char(5)
''

STTACNUM_5 char(5)
''

STTACNUM_6 char
''

EACCNBR_1 char(5)
''

EACCNBR_2 char(5)
''

STTACNUM_7 char
''

STTACNUM_8 char
''

EACCNBR_3 char(5)
''

EACCNBR_4 char(5)
''

STTACNUM_9 char
''

STTACNUM_10 char
''

EACCNBR_5 char(5)
''

STRTDATE datetime
'1/1/1900'
Start Date...(more) Join Now UPR00100.STRTDATE
ENDDATE datetime
'1/1/1900'
End Date: ...(more) Join Now SOP00300.ENDDATE
STARTGRP char(15)
''

ENDGROUP char(15)
''

STRTCODE char(15)
''

ENDCODE char(15)
''

EACCNBR_6 char
''

EACCNBR_7 char
''

PRNTDTLD tinyint
0

UNPSTTRX tinyint
0

EACCNBR_8 char
''

EACCNBR_9 char
''

OPEN1 tinyint
0

EACCNBR_10 char
''

HISTORY tinyint
0
Field Type...(more) Join Now SVC00670.HISTORY
STTPSTDT datetime
'1/1/1900'

ENDPSTDT datetime
'1/1/1900'

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3