Module List > Module PM tables PM30300
You are currently viewing the COMPANY database.
Change

COMPANY..PM30300 Table Definition

(COMPANY..PM Apply To History File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
VENDORID char(15)
''
Vendor ID ...(more) Join Now
join ... more text available
DOCDATE datetime
'1/1/1900'
Document D...(more) Join Now
DATE1 datetime
'1/1/1900'
The date o...(more) Join Now
GLPOSTDT datetime
'1/1/1900'
Date that ...(more) Join Now
TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now
VCHRNMBR char(21)
''
Voucher Nu...(more) Join Now
DOCTYPE smallint
0
Document T...(more) Join Now
APFRDCNM char(21)
''
Apply From...(more) Join Now
ApplyFromGLPostDate datetime
'1/1/1900'
Apply From...(more) Join Now
FROMCURR char(15)
''
Currency I...(more) Join Now
APFRMAPLYAMT numeric(19,5)
0.00
Functional...(more) Join Now
APFRMDISCTAKEN numeric(19,5)
0.00
Functional...(more) Join Now
APFRMDISCAVAIL numeric(19,5)
0.00
Functional...(more) Join Now
APFRMWROFAMT numeric(19,5)
0.00
Functional...(more) Join Now
ActualApplyToAmount numeric(19,5)
0.00
Actual App...(more) Join Now
ActualDiscTakenAmount numeric(19,5)
0.00
Actual Dis...(more) Join Now
ActualDiscAvailTaken numeric(19,5)
0.00
Actual Dis...(more) Join Now
ActualWriteOffAmount numeric(19,5)
0.00
Actual Wri...(more) Join Now
APFRMEXRATE numeric(19,7)
0.00
Apply From...(more) Join Now
APFRMDENRATE numeric(19,7)
0.00
Denominati...(more) Join Now
APFRMRTCLCMETH smallint
0
Apply From...(more) Join Now
APFRMMCTRXSTT smallint
0
Apply From...(more) Join Now
APTVCHNM char(21)
''
Apply To V...(more) Join Now
APTODCTY smallint
0
Apply To D...(more) Join Now
APTODCNM char(21)
''
Apply To D...(more) Join Now
APTODCDT datetime
'1/1/1900'
Apply To D...(more) Join Now
ApplyToGLPostDate datetime
'1/1/1900'
Apply To G...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
APPLDAMT numeric(19,5)
0.00
Applied Am...(more) Join Now
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now
DISAVTKN numeric(19,5)
0.00
Discount A...(more) Join Now
WROFAMNT numeric(19,5)
0.00
Write Off ...(more) Join Now
ORAPPAMT numeric(19,5)
0.00
Originatin...(more) Join Now
ORDISTKN numeric(19,5)
0.00
Orig Disco...(more) Join Now
ORDATKN numeric(19,5)
0.00
Orig Disco...(more) Join Now
ORWROFAM numeric(19,5)
0.00
Originatin...(more) Join Now
APTOEXRATE numeric(19,7)
0.00
Exchange R...(more) Join Now
APTODENRATE numeric(19,7)
0.00
Denominati...(more) Join Now
APTORTCLCMETH smallint
0
Rate Calcu...(more) Join Now
APTOMCTRXSTT smallint
0
Transactio...(more) Join Now
PPSAMDED numeric(19,5)
0.00
PPS Amount...(more) Join Now
GSTDSAMT numeric(19,5)
0.00
GST Discou...(more) Join Now
TAXDTLID char(15)
''
Tax Detail...(more) Join Now
POSTED tinyint
0
Posted: A...(more) Join Now
TEN99AMNT numeric(19,5)
0.00
1099 Amoun...(more) Join Now
RLGANLOS numeric(19,5)
0.00
Realized G...(more) Join Now
APYFRMRNDAMT numeric(19,5)
0.00
Round Amou...(more) Join Now
APYTORNDAMT numeric(19,5)
0.00
Round Amou...(more) Join Now
APYTORNDDISC numeric(19,5)
0.00
Round Disc...(more) Join Now
OAPYFRMRNDAMT numeric(19,5)
0.00
Originatin...(more) Join Now
OAPYTORNDAMT numeric(19,5)
0.00
Originatin...(more) Join Now
OAPYTORNDDISC numeric(19,5)
0.00
Originatin...(more) Join Now
Settled_Gain_CreditCurrT numeric(19,5)
0.00
Settled Ga...(more) Join Now
Settled_Loss_CreditCurrT numeric(19,5)
0.00
Settled Lo...(more) Join Now
Settled_Gain_DebitCurrTr numeric(19,5)
0.00
Settled Ga...(more) Join Now
Settled_Loss_DebitCurrTr numeric(19,5)
0.00
Settled Lo...(more) Join Now
Settled_Gain_DebitDiscAv numeric(19,5)
0.00
Settled Ga...(more) Join Now
Settled_Loss_DebitDiscAv numeric(19,5)
0.00
Settled Lo...(more) Join Now
Revaluation_Status smallint
0
Revaluatio...(more) Join Now
Credit1099Amount numeric(19,5)
0.00
1099 Amoun...(more) Join Now
DEFTEN99TYPE smallint
0
Default 10...(more) Join Now
DEFTEN99BOXNUMBER smallint
0
Default 10...(more) Join Now
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