Module List > Module PA tables PA70101
You are currently viewing the COMPANY database.
Change

COMPANY..PA70101 Table Definition

(COMPANY..PA Project Series Report Options)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
RPTGRIND smallint
0

RTPACHIN smallint
0

RTGRSBIN numeric(19,5)
0.00

REPORTID smallint
0

RPTGRNMS char(21)
''

ASKECHTM tinyint
0

PRTOSCRN tinyint
0

PRTOPRTR tinyint
0

PRNTOFIL tinyint
0

EXPTTYPE smallint
0

FILEXPNM char(255)
''

IFFILXST smallint
0

PRNTTYPE smallint
0

SORTBY smallint
0

RANGEBY smallint
0

YEAR1 smallint
0
Year...(more) Join Now SY40101.YEAR1
PERIODID smallint
0

PATU smallint
0
PA Transac...(more) Join Now
PAReport_Include smallint
0

PARange_By_Array_1 tinyint
0

PARange_By_Array_2 tinyint
0

PARange_By_Array_3 tinyint
0

PARange_By_Array_4 tinyint
0

PARange_By_Array_5 tinyint
0

PARange_By_Array_6 tinyint
0

PARange_By_Array_7 tinyint
0

PARange_By_Array_8 tinyint
0

PARange_By_Array_9 tinyint
0

PARange_By_Array_10 tinyint
0

PAExclude_Array_1 tinyint
0

PAExclude_Array_2 tinyint
0

PAExclude_Array_3 tinyint
0

PAExclude_Array_4 tinyint
0

PAExclude_Array_5 tinyint
0

PAExclude_Array_6 tinyint
0

PAExclude_Array_7 tinyint
0

PAExclude_Array_8 tinyint
0

PAExclude_Array_9 tinyint
0

PAExclude_Array_10 tinyint
0

PA_Net_Write_Down_In_Exc numeric(19,5)
0.00

DETLDRPT tinyint
0

MTHSLCTD smallint
0

SUMDTTKN smallint
0

SMRYDATE datetime
'1/1/1900'

PACashBudgetSalesLevel smallint
0

PACashBudgetPctgLevels_1 smallint
0

PACashBudgetPctgLevels_2 smallint
0

PACashBudgetPctgLevels_3 smallint
0

PACashBudgetStartingCash numeric(19,5)
0.00

PACashBudgetCashNeedsLev numeric(19,5)
0.00

PRPSTJCB tinyint
0

PRTDBRCD tinyint
0

PRSBDRCB tinyint
0

STRTYEAR smallint
0

ENDYEAR smallint
0

STBCHNUM char(15)
''

ENDBNMBR char(15)
''

STDOCN int
0

ENDOCN int
0

STTPRJCLID char(15)
''

ENDPRJCLID char(15)
''

PASTPROJN char(15)
''

PAENPROJN char(15)
''

STTPROJID char(15)
''

ENDPROJID char(15)
''

StartProjectMgrID char(15)
''

EndProjectMgrID char(15)
''

StartBusinessMgrID char(15)
''

EndBusinessMgrID char(15)
''

STRTDEPT char(7)
''

ENDDEPT char(7)
''

STTCNTRCLID char(15)
''

ENDCNTRCLID char(15)
''

Start_Contract_Number char(11)
''

End_Contract_Number char(11)
''

STTCONTRID char(15)
''

ENDCONTRID char(15)
''

STSPRSID char(15)
''

ENSPSNID char(15)
''

STDATEIN datetime
'1/1/1900'

ENDATEIN datetime
'1/1/1900'

STREFDOC int
0

ENREFDOC int
0

STDISTT smallint
0

ENDISTT smallint
0

STACCNDX int
0

EDACCNDX int
0

STRTNGDT datetime
'1/1/1900'

ENDINGDT datetime
'1/1/1900'

STTUDEF1 char(21)
''

ENUSRDF1 char(21)
''

STTDOCDT datetime
'1/1/1900'
Field Type...(more) Join Now SVC00670.STTDOCDT
ENDDOCDT datetime
'1/1/1900'
Field Type...(more) Join Now SVC00670.ENDDOCDT
STTPSTDT datetime
'1/1/1900'

ENDPSTDT datetime
'1/1/1900'

STRXSRC char(13)
''

ENTRXSRC char(13)
''

STCUSTID char(15)
''

ENCUSTID char(15)
''

STCUSTNM char(65)
''

ENCSTNAM char(65)
''

PAStart_ID_Array_1 char(15)
''

PAStart_ID_Array_2 char(15)
''

PAStart_ID_Array_3 char(15)
''

PAStart_ID_Array_4 char(15)
''

PAStart_ID_Array_5 char(15)
''

PAStart_ID_Array_6 char(15)
''

PAStart_ID_Array_7 char(15)
''

PAStart_ID_Array_8 char(15)
''

PAStart_ID_Array_9 char(15)
''

PAStart_ID_Array_10 char(15)
''

PAEnd_ID_Array_1 char(15)
''

PAEnd_ID_Array_2 char(15)
''

PAEnd_ID_Array_3 char(15)
''

PAEnd_ID_Array_4 char(15)
''

PAEnd_ID_Array_5 char(15)
''

PAEnd_ID_Array_6 char(15)
''

PAEnd_ID_Array_7 char(15)
''

PAEnd_ID_Array_8 char(15)
''

PAEnd_ID_Array_9 char(15)
''

PAEnd_ID_Array_10 char(15)
''

PAStart_Name_Array_1 char(31)
''

PAStart_Name_Array_2 char(31)
''

PAStart_Name_Array_3 char(31)
''

PAStart_Name_Array_4 char(31)
''

PAStart_Name_Array_5 char(31)
''

PAStart_Name_Array_6 char(31)
''

PAStart_Name_Array_7 char(31)
''

PAStart_Name_Array_8 char(31)
''

PAStart_Name_Array_9 char(31)
''

PAStart_Name_Array_10 char(31)
''

PAEnd_Name_Array_1 char(31)
''

PAEnd_Name_Array_2 char(31)
''

PAEnd_Name_Array_3 char(31)
''

PAEnd_Name_Array_4 char(31)
''

PAEnd_Name_Array_5 char(31)
''

PAEnd_Name_Array_6 char(31)
''

PAEnd_Name_Array_7 char(31)
''

PAEnd_Name_Array_8 char(31)
''

PAEnd_Name_Array_9 char(31)
''

PAEnd_Name_Array_10 char(31)
''

PASTDOCT smallint
0

PAENDOCT smallint
0

PAStart_PO_Number int
0

PAEnd_PO_Number int
0

PAStart_TRX_Type smallint
0

PAEnd_TRX_Type smallint
0

PRTCURIN smallint
0

RPTXRATE numeric(19,7)
0.00
Reporting ...(more) Join Now MC40000.RPTXRATE
RPRTCLMD smallint
0
Reporting ...(more) Join Now MC40000.RPRTCLMD
INCLUDEHOLDPO tinyint
0

INCLUDEHOLDPOONLY tinyint
0

Include_New tinyint
0

Include_Released tinyint
0

Include_Change_Order tinyint
0

Include_Received tinyint
0

Include_Closed tinyint
0

Include_Canceled tinyint
0

INCRCPTS tinyint
0

ENDVNDID char(15)
''

ENDVNDNM char(65)
''

ENDPOSTA smallint
0

EndPOPRcptNum char(17)
''

DISSRLOT tinyint
0

ENITMNBR char(31)
''

End_Promised_Date datetime
'1/1/1900'

End_Required_Date datetime
'1/1/1900'

ENDLOCID char(15)
''

ENRCTDT datetime
'1/1/1900'

ENDBUYERID char(15)
''

ENDLINEORIGIN smallint
0

ENDRELEASEBYDATE datetime
'1/1/1900'

PAENDCOSTID char(15)
''

ENAUCNCD char(13)
''

Days_Overdue tinyint
0

DATEOVERDUE datetime
'1/1/1900'

COMPTYPE smallint
0

POP_Date_Selection1 smallint
0

INCLFUNC tinyint
0

INCMCINF tinyint
0

STVNDRID char(15)
''

STVNDNAM char(65)
''

STRPOSTA smallint
0

STRPONUM char(17)
''

StartPOPRcptNum char(17)
''

ENDPONUM char(17)
''

STTITNUM char(31)
''

Start_Promised_Date datetime
'1/1/1900'

Start_Required_Date datetime
'1/1/1900'

STTLOCID char(15)
''

STRCTDT datetime
'1/1/1900'

STARTBUYERID char(15)
''

STARTLINEORIGIN smallint
0

STARTRELEASEBYDATE datetime
'1/1/1900'

PASTTCOSTID char(15)
''

STTACNCD char(13)
''

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