DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
Module List > Module PM tables > PM70500

DynDeveloper Table Reference is now in Wiki format! Registered users have the ability to improve the table reference, add comments, and make the world a better place
You are currently viewing the COMPANY database.
Change

COMPANY..PM70500 Table Definition

(COMPANY..Purchasing Report Options)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
RPTGRINDsmallint B3970500.RPTGRIND
GP 9
RTPACHINsmallint B3970500.RTPACHIN
GP 9
RTGRSBINnumeric(19,5) UPR70501.RTGRSBIN
GP 9
ASKECHTMtinyint
GP 9
EXPTTYPEsmallint PAM70103.EXPTTYPE
GP 9
FILEXPNMchar(255) XXUF0100.FILEXPNM
GP 9
IFFILXSTsmallint B3900297.IFFILXST
GP 9
FINRPTNMchar(31) PP000060.FINRPTNM
GP 9
PRNTOFILtinyint
GP 9
PRTOPRTRtinyint SY01400.PRTOPRTR
GP 9
PRTOSCRNtinyint SY01400.PRTOSCRN
GP 9
SORTBYsmallint PAM00100.SORTBY
GP 9
SORTBY2smallint
GP 9
HISTTYPEsmallint History Ty...(more) Join Now PM00202.HISTTYPE
GP 9
PYMNTDATdatetime
GP 9
VOIDONLYtinyint
GP 9
EXCLVOIDtinyint
GP 9
Include_Canceledtinyint
GP 9
DATEOVERDUEdatetime
GP 9
Days_Overduetinyint
GP 9
POP_Date_Selectionsmallint
GP 9
Include_Closedtinyint
GP 9
Include_Releasedtinyint
GP 9
AGEBYsmallint
GP 9
COMPTYPEsmallint
GP 9
STVNDRIDchar(15) WOUF0132.STVNDRID
GP 9
STVNDNAMchar(65)
GP 9
STVNDCLSchar(11)
GP 9
STTSTATEchar(29)
GP 9
STRTZPCDchar(11)
GP 9
STRTPHONchar(21)
GP 9
STRTUDEFchar(21) CN00600.STRTUDEF
GP 9
STTCNTCTchar(61)
GP 9
Start_PO_Datedatetime
GP 9
STTSHNAMchar(15)
GP 9
STTLOCIDchar(15) PC70100.STTLOCID
GP 9
Start_Promised_Datedatetime
GP 9
Start_Required_Datedatetime
GP 9
STVNSTUSsmallint
GP 9
STT1099Tsmallint
GP 9
STPERIODsmallint
GP 9
STRTYEARsmallint
GP 9
STTABYTDnumeric(19,5)
GP 9
STRTPRTYchar(3)
GP 9
STTDUEDTdatetime
GP 9
STDISCDTdatetime
GP 9
ALORANGEsmallint
GP 9
STTACNCDchar(13)
GP 9
STDOCNUMchar(21) RVPS0132.STDOCNUM
GP 9
STTDOCDTdatetime Field Type...(more) Join Now SVC00670.STTDOCDT
GP 9
STDOCTYPsmallint
GP 9
STVCHNUMchar(21)
GP 9
STTITNUMchar(31) WRUF0130.STTITNUM
GP 9
STCHKNUMchar(21)
GP 9
STTCHKDTdatetime
GP 9
STCHBKIDchar(15)
GP 9
STBCHSRCchar(15)
GP 9
STBCHNUMchar(15)
GP 9
STPSTDDTdatetime
GP 9
STCLSDSCchar(31)
GP 9
ENDVNDIDchar(15) WOUF0132.ENDVNDID
GP 9
ENDVNDNMchar(65)
GP 9
ENDVNCLSchar(11)
GP 9
ENDSTATEchar(29)
GP 9
ENDZIPCDchar(11)
GP 9
ENPHONBRchar(21)
GP 9
End_PO_Datedatetime
GP 9
ENUSRDEFchar(21) CN00600.ENUSRDEF
GP 9
ENDLOCIDchar(15) PC70100.ENDLOCID
GP 9
ENITMNBRchar(31) WRUF0130.ENITMNBR
GP 9
End_Required_Datedatetime
GP 9
End_Promised_Datedatetime
GP 9
ENDVNDCTchar(61)
GP 9
ENDSHNAMchar(15)
GP 9
ENVNSTTSsmallint
GP 9
E1099TYPsmallint
GP 9
ENDPERODsmallint
GP 9
ENDYEARsmallint
GP 9
ENAMBYTDnumeric(19,5)
GP 9
ENPRYRTYchar(3)
GP 9
ENDDUEDTdatetime
GP 9
ENDISCDTdatetime
GP 9
ALORNGE2smallint
GP 9
ENAUCNCDchar(13) APR_APR70500.ENAUCNCD
GP 9
ENDOCNUMchar(21) RVPS0132.ENDOCNUM
GP 9
ENDDOCDTdatetime Field Type...(more) Join Now SVC00670.ENDDOCDT
GP 9
ENDOCTYPsmallint
GP 9
ENVCHNUMchar(21)
GP 9
ENCHKNUMchar(21)
GP 9
ENDCHKDTdatetime
GP 9
ENCHBKIDchar(15)
GP 9
ENBCHSRCchar(15)
GP 9
ENDBNMBRchar(15)
GP 9
ENPSTDDTdatetime
GP 9
ENCLDSCRchar(31)
GP 9
AGNGDATEdatetime
GP 9
PBSDCDTKsmallint
GP 9
PBSDUDTKsmallint
GP 9
PBSDSDTKsmallint
GP 9
PBSCHDTKsmallint
GP 9
PBSPTDTKsmallint
GP 9
PBEDCDTKsmallint
GP 9
PBEDUDTKsmallint
GP 9
PBEDSDTKsmallint
GP 9
PBECHDTKsmallint
GP 9
PBEPDTKNsmallint
GP 9
PBCDTTKNsmallint
GP 9
DETLDRPTtinyint
GP 9
SINGACTtinyint
GP 9
STTACNUM_1char(5) DTA00700.STTACNUM_1
GP 9
STTACNUM_2char(5) UPR70500.STTACNUM_2
GP 9
STTACNUM_3char(5) DTA00700.STTACNUM_3
GP 9
STTACNUM_4char(5) UPR70500.STTACNUM_4
GP 9
STTACNUM_5char(5) DTA00700.STTACNUM_5
GP 9
STTACNUM_6char
GP 2010
EACCNBR_1char(5) UPR70500.EACCNBR_1
GP 9
EACCNBR_2char(5) DTA00700.EACCNBR_2
GP 9
STTACNUM_7char
GP 2010
STTACNUM_8char
GP 2010
EACCNBR_3char(5) UPR70500.EACCNBR_3
GP 9
EACCNBR_4char(5) DTA00700.EACCNBR_4
GP 9
STTACNUM_9char
GP 2010
STTACNUM_10char
GP 2010
EACCNBR_5char(5) UPR70500.EACCNBR_5
GP 9
STRPONUMchar(17) QADUF132.STRPONUM
GP 9
ENDPONUMchar(17) QADUF132.ENDPONUM
GP 9
EndPOPRcptNumchar(17) QADUF132.EndPOPRcptNum
GP 9
StartPOPRcptNumchar(17) QADUF132.StartPOPRcptNum
GP 9
STRCREATchar(15)
GP 9
STRCTDTdatetime
GP 9
EACCNBR_6char
GP 2010
EACCNBR_7char
GP 2010
ENRCTDTdatetime
GP 9
EACCNBR_8char
GP 2010
STRCTNUMchar(21)
GP 9
EACCNBR_9char
GP 2010
ENRCTNBRchar(21)
GP 9
ENDCREATEchar(15)
GP 9
EACCNBR_10char
GP 2010
STRPOSTAsmallint
GP 9
ENDPOSTAsmallint
GP 9
INCRCPTStinyint
GP 9
DISSRLOTtinyint
GP 9
STRXSRCchar(13)
GP 9
ENTRXSRCchar(13)
GP 9
CRBLNCCBtinyint
GP 9
FLLYPDCBtinyint
GP 9
ZROBALCBtinyint
GP 9
EXCLZBALtinyint
GP 9
NOACTVCBtinyint
GP 9
Unposted_Applied_CR_Docstinyint
GP 9
Multicurrency_Informationtinyint
GP 9
Include_Distribution_Typbinary(4)
GP 9
RPTXRATEnumeric(19,7) Reporting ...(more) Join Now MC40000.RPTXRATE
GP 9
RPRTCLMDsmallint Reporting ...(more) Join Now MC40000.RPRTCLMD
GP 9
PRTCURINsmallint
GP 9
INCLFUNCtinyint
GP 9
STARTLINEORIGINsmallint
GP 9
ENDLINEORIGINsmallint
GP 9
STARTBUYERIDchar(15) MRP6060.STARTBUYERID
GP 9
ENDBUYERIDchar(15) MRP6060.ENDBUYERID
GP 9
INCLUDEHOLDPOtinyint
GP 9
INCLUDEHOLDPOONLYtinyint
GP 9
STARTRELEASEBYDATEdatetime
GP 9
ENDRELEASEBYDATEdatetime
GP 9
Include_Newtinyint
GP 9
Include_Change_Ordertinyint
GP 9
Include_Receivedtinyint
GP 9
SummaryYearsmallint
GP 9
DateSensitivitySumSelectsmallint
GP 9
StartProjNumchar(15)
GP 9
EndProjNumchar(15)
GP 9
StartCostCatIDchar(15)
GP 9
EndCostCatIDchar(15)
GP 9
IncludeApprovedPOsOnlytinyint
GP 10
MISCtinyint
GP 10
INTERESTtinyint
GP 10
DIVIDENDtinyint
GP 10
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9