DynDeveloper.com

DynDeveloper.com

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

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..PM20100 Table Definition

(COMPANY..PM Apply To OPEN OPEN Temporary File)
PM20100 unposted APPLY detail
4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
KEYSOURCchar(41)
GP 9
DOCDATEdatetime The date a...(more) Join Now
GP 9
TIME1datetime
GP 9
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM20100.VENDORID
POSTEDtinyint Posted: A...(more) Join Now
GP 9
BCHSOURCchar(15) Batch Sour...(more) Join Now
GP 9
USERIDchar(15) The user t...(more) Join Now
GP 9
join DYNAMICS..SY01400 on SY01400.USERID = PM20100.USERID
APTVCHNMchar(21)
GP 9
APTODCTYsmallint
GP 9
APTODCDTdatetime
GP 9
APTODCNMchar(21)
GP 9
APPLDAMTnumeric(19,5) Applied Am...(more) Join Now
GP 9
DISTKNAMnumeric(19,5) Discount T...(more) Join Now
GP 9
DISAVTKNnumeric(19,5) Discount A...(more) Join Now
GP 9
WROFAMNTnumeric(19,5) Write Off ...(more) Join Now
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM20100.CURNCYID
CURRNIDXsmallint Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURRNIDX = PM20100.CURRNIDX
ORAPPAMTnumeric(19,5)
GP 9
ORDISTKNnumeric(19,5) Orig Disco...(more) Join Now
GP 9
ORDATKNnumeric(19,5) Orig Disco...(more) Join Now
GP 9
ORWROFAMnumeric(19,5)
GP 9
Apply_To_Document_Amountnumeric(19,5)
GP 9
Apply_To_Orig_Doc_Amountnumeric(19,5)
GP 9
Apply_To_Discount_Datedatetime
GP 9
Apply_To_Due_Datedatetime
GP 9
Apply_To_Descriptionchar(31)
GP 9
Apply_To_IS_MC_Trxsmallint
GP 9
ApplyToGLPostDatedatetime
GP 9
APTOEXRATEnumeric(19,7)
GP 9
APTODENRATEnumeric(19,7)
GP 9
APTORTCLCMETHsmallint
GP 9
APTOMCTRXSTTsmallint
GP 9
ISMCTRXsmallint Field Type...(more) Join Now
GP 9
VCHRNMBRchar(21) Voucher Nu...(more) Join Now
GP 9
DOCTYPEsmallint Document T...(more) Join Now
GP 9
APFRDCNMchar(21)
GP 9
FROMCURRchar(15)
GP 9
Apply_From_Document_Amounumeric(19,5)
GP 9
Apply_From_Orig_Doc_Amounumeric(19,5)
GP 9
APFRMAPLYAMTnumeric(19,5)
GP 9
APFRMDISCTAKENnumeric(19,5)
GP 9
APFRMDISCAVAILnumeric(19,5)
GP 9
APFRMWROFAMTnumeric(19,5)
GP 9
ActualApplyToAmountnumeric(19,5)
GP 9
ActualDiscTakenAmountnumeric(19,5) Actual Dis...(more) Join Now
GP 9
ActualDiscAvailTakennumeric(19,5)
GP 9
ActualWriteOffAmountnumeric(19,5) Actual Wri...(more) Join Now
GP 9
APFRMEXRATEnumeric(19,7)
GP 9
APFRMDENRATEnumeric(19,7)
GP 9
APFRMRTCLCMETHsmallint Apply From...(more) Join Now
GP 9
APFRMMCTRXSTTsmallint Apply From...(more) Join Now
GP 9
Apply_From_Descriptionchar(31)
GP 9
Apply_From_IS_MC_Trxsmallint
GP 9
PPSAMDEDnumeric(19,5) PPS Amount...(more) Join Now
GP 9
GSTDSAMTnumeric(19,5) GST Discou...(more) Join Now
GP 9
TAXDTLIDchar(15) Tax Detail...(more) Join Now
GP 9
UPDTKNAMnumeric(19,5) Unposted D...(more) Join Now
GP 9
UPGSTDAMnumeric(19,5)  Unpo...(more) Join Now
GP 9
UNPPPSADnumeric(19,5) Join Now
GP 9
UPWROFAMnumeric(19,5) Unposted W...(more) Join Now
GP 9
PMDSTMSGbinary(4) PM Distrib...(more) Join Now
GP 9
MODIFDTdatetime Date the r...(more) Join Now
GP 9
MDFUSRIDchar(15) User that ...(more) Join Now
GP 9
join DYNAMICS..SY01400 on SY01400.USERID = PM20100.MDFUSRID
POSTEDDTdatetime Posted Dat...(more) Join Now
GP 9
PTDUSRIDchar(15) Posted Use...(more) Join Now
GP 9
TEN99AMNTnumeric(19,5) 1099 Amoun...(more) Join Now
GP 9
RLGANLOSnumeric(19,5) Realized G...(more) Join Now
GP 9
APYFRMRNDAMTnumeric(19,5)
GP 9
APYTORNDAMTnumeric(19,5)
GP 9
APYTORNDDISCnumeric(19,5)
GP 9
XCHGRATEnumeric(19,7) Exchange R...(more) Join Now
GP 9
DECPLCURsmallint Decimal Pl...(more) Join Now
GP 9
RATECALCsmallint Rate Calc ...(more) Join Now
GP 9
Payment_To_Print_On_Stubchar(21)
GP 9
OAPYFRMRNDAMTnumeric(19,5)
GP 9
OAPYTORNDAMTnumeric(19,5)
GP 9
OAPYTORNDDISCnumeric(19,5)
GP 9
Settled_Gain_CreditCurrTnumeric(19,5)
GP 9
Settled_Loss_CreditCurrTnumeric(19,5)
GP 9
Settled_Gain_DebitCurrTrnumeric(19,5)
GP 9
Settled_Loss_DebitCurrTrnumeric(19,5)
GP 9
Settled_Gain_DebitDiscAvnumeric(19,5)
GP 9
Settled_Loss_DebitDiscAvnumeric(19,5)
GP 9
VADCDTROchar(15) Vendor Add...(more) Join Now
GP 9
Credit1099Amountnumeric(19,5)
GP 10
DEFTEN99TYPEsmallint Default 10...(more) Join Now
GP 10
DEFTEN99BOXNUMBERsmallint Default 10...(more) Join Now
GP 10
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9