Module List > Module Manufacturing tables QADUF132
You are currently viewing the COMPANY database.
Change

COMPANY..QADUF132 Table Definition

(COMPANY..Report_Options)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
REPORTOPTION_I char(21)
''

REPORTINDEX_I numeric(19,5)
0.00

ASKECHTM tinyint
0

SORTBY_I char(31)
''

TEXTREPTS_I tinyint
0

LEVEL_I int
0

INCLGNDS tinyint
0

PRNTOFIL tinyint
0

PRTOPRTR tinyint
0

PRTOSCRN tinyint
0

IFFILXST smallint
0

FILEXPNM char(255)
''

EXPTTYPE smallint
0

STRTDATE datetime
'1/1/1900'
Start Date...(more) Join Now PA02101.STRTDATE
ENDDATE datetime
'1/1/1900'
End Date ...(more) Join Now PA02101.ENDDATE
STARTDATEINSPECT datetime
'1/1/1900'

ENDDATEINSPECT datetime
'1/1/1900'

STARTDEFCOD char(11)
''

ENDDEFCODE char(11)
''

STARTDISPCOD char(11)
''

ENDDISPCODE char(11)
''

STARTINSPECT char(11)
''

ENDINSPECT char(11)
''

STTITNUM char(31)
''

ENITMNBR char(31)
''

STRPONUM char(17)
''

ENDPONUM char(17)
''

StartPOPRcptNum char(17)
''

EndPOPRcptNum char(17)
''

STVNDRID char(15)
''

ENDVNDID char(15)
''

Destroyed_in_Testing tinyint
0

FLAGDESTRYTEST tinyint
0

Passed_Inspection tinyint
0

FLAGPASSEDINSP tinyint
0

QACOMPLETED tinyint
0

FLAGQACOMPLETE tinyint
0

AQL_Table_Name char(21)
''

STTDOCDT datetime
'1/1/1900'

ENDDOCDT datetime
'1/1/1900'

STRTORGNTOR char(31)
''

ENDORGNTOR char(31)
''

STARTEFFECTIVEDATE_I datetime
'1/1/1900'

ENDEFFECTIVEDATE_I datetime
'1/1/1900'

STTDUEDT datetime
'1/1/1900'

ENDDUEDT datetime
'1/1/1900'

STTPSTDT datetime
'1/1/1900'

ENDPSTDT datetime
'1/1/1900'

STTLOCCD char(11)
''

ENLOCNCD char(11)
''

STARTNSRNUMI char(21)
''

ENDNSRNUMI char(21)
''

STARTSCARNUMI char(21)
''

ENDSCARNUMI char(21)
''

RSRCID char(31)
''

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