Module List > Module JC tables JCRFP100
You are currently viewing the COMPANY database.
Change

COMPANY..JCRFP100 Table Definition

(COMPANY..JC_RFP_Transaction_WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BACHNUMB char(15)

Batch Numb...(more) Join Now
join ... more text available
BCHSOURC char(15)

Batch Sour...(more) Join Now
VCHNUMWK char(17)

Voucher Nu...(more) Join Now PM10000.VCHNUMWK
VENDORID char(15)

Vendor ID:...(more) Join Now PM10000.VENDORID
join ... more text available
DOCNUMBR char(21)

Document N...(more) Join Now PM10000.DOCNUMBR
DOCTYPE smallint

Document T...(more) Join Now PM10000.DOCTYPE
SOURCDOC char(11)

Field values: 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo PP000001.SOURCDOC
DOCAMNT numeric(19,5)

Source Doc...(more) Join Now PM10000.DOCAMNT
DOCDATE datetime

Document D...(more) Join Now PM10000.DOCDATE
PSTGDATE datetime

Posting Da...(more) Join Now PM10000.PSTGDATE
VADDCDPR char(15)

Vendor Add...(more) Join Now PM10000.VADDCDPR
PYMTRMID char(21)

Payment Te...(more) Join Now PM10000.PYMTRMID
SY033... more text available
TAXSCHID char(15)

Tax Schedu...(more) Join Now PM10000.TAXSCHID
join ... more text available
DUEDATE datetime

Due Date: ...(more) Join Now PM10000.DUEDATE
DSCDLRAM numeric(19,5)

Discount D...(more) Join Now PM10000.DSCDLRAM
DISCDATE datetime

Discount D...(more) Join Now PM10000.DISCDATE
PRCHAMNT numeric(19,5)

Purchases ...(more) Join Now PM10000.PRCHAMNT
CHRGAMNT numeric(19,5)

Charge Amo...(more) Join Now PM10000.CHRGAMNT
CASHAMNT numeric(19,5)

Cash Amoun...(more) Join Now PM10000.CASHAMNT
CAMCBKID char(15)

Cash Amoun...(more) Join Now PM10000.CAMCBKID
CDOCNMBR char(21)

Cash Docum...(more) Join Now PM10000.CDOCNMBR
CAMTDATE datetime

Cash Amoun...(more) Join Now PM10000.CAMTDATE
CAMPMTNM char(21)

Cash Amoun...(more) Join Now PM10000.CAMPMTNM
CHEKAMNT numeric(19,5)

Check Amou...(more) Join Now PM10000.CHEKAMNT
CHAMCBID char(15)

Check Amou...(more) Join Now PM10000.CHAMCBID
CHEKDATE datetime

Check Date...(more) Join Now PM10000.CHEKDATE
CAMPYNBR char(21)

Check Amou...(more) Join Now PM10000.CAMPYNBR
CRCRDAMT numeric(19,5)

Credit Car...(more) Join Now PM10000.CRCRDAMT
CCAMPYNM char(21)

Credit Car...(more) Join Now PM10000.CCAMPYNM
CHEKNMBR char(21)

Check Numb...(more) Join Now PM10000.CHEKNMBR
CARDNAME char(15)

Card Name:...(more) Join Now PM10000.CARDNAME
CCRCTNUM char(21)

Credit Car...(more) Join Now PM10000.CCRCTNUM
CRCARDDT datetime

Credit Car...(more) Join Now PM10000.CRCARDDT
CURNCYID char(15)

Currency I...(more) Join Now CM20000
join ... more text available
CHEKBKID char(15)

Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
TRXDSCRN char(31)

Transactio...(more) Join Now PM10000.TRXDSCRN
UN1099AM numeric(19,5)

Unapplied ...(more) Join Now PM10000.UN1099AM
TRDISAMT numeric(19,5)

Trade Disc...(more) Join Now RM20101.TRDISAMT
TAXAMNT numeric(19,5)

Tax Amount...(more) Join Now RM20101.TAXAMNT
FRTAMNT numeric(19,5)

Freight Am...(more) Join Now PM10000.FRTAMNT
TEN99AMNT numeric(19,5)

1099 Amoun...(more) Join Now PM10000.TEN99AMNT
MSCCHAMT numeric(19,5)

Misc Charg...(more) Join Now PM10000.MSCCHAMT
PORDNMBR char(21)

Purchase O...(more) Join Now
SHIPMTHD char(15)

Shipping M...(more) Join Now RM20101.SHIPMTHD
join ... more text available
DISAMTAV numeric(19,5)

Discount A...(more) Join Now PM10000.DISAMTAV
DISTKNAM numeric(19,5)

Discount T...(more) Join Now RM20101.DISTKNAM
APDSTKAM numeric(19,5)

Applied Di...(more) Join Now PM10000.APDSTKAM
WROFAMNT numeric(19,5)

Write Off ...(more) Join Now RM20101.WROFAMNT
CURTRXAM numeric(19,5)

Current Tr...(more) Join Now RM50104.CURTRXAM
TXENGCLD tinyint

Tax Engine...(more) Join Now RM10301.TXENGCLD
PMWRKMSG binary(4)

PM WORK Me...(more) Join Now PM10000.PMWRKMSG
PMDSTMSG binary(4)

PM Distrib...(more) Join Now PM10000.PMDSTMSG
GSTDSAMT numeric(19,5)

GST Discou...(more) Join Now RM20101.GSTDSAMT
PGRAMSBJ smallint

Percent Of...(more) Join Now PM10000.PGRAMSBJ
PPSAMDED numeric(19,5)

PPS Amount...(more) Join Now RM20101.PPSAMDED
PPSTAXRT smallint

PPS Tax Ra...(more) Join Now POP10300.PPSTAXRT
PSTGSTUS smallint

Posting St...(more) Join Now RM10301.PSTGSTUS
POSTED tinyint

Posted: S...(more) Join Now RM10301.POSTED
APPLDAMT numeric(19,5)

Applied Am...(more) Join Now RM10301.APPLDAMT
VCHRNMBR char(21)

Voucher Nu...(more) Join Now POP10300.VCHRNMBR
CNTRLTYP smallint

Control Ty...(more) Join Now PM00400.CNTRLTYP
MODIFDT datetime

Date the r...(more) Join Now
MDFUSRID char(15)

User that ...(more) Join Now
join ... more text available
POSTEDDT datetime

Posted Dat...(more) Join Now RM10301.POSTEDDT
PTDUSRID char(15)

Posted Use...(more) Join Now RM10301.PTDUSRID
NOTEINDX numeric(19,5)

Note Index...(more) Join Now
join ... more text available
BKTFRTAM numeric(19,5)

Backout Fr...(more) Join Now RM20101.BKTFRTAM
BKTMSCAM numeric(19,5)

Backout Mi...(more) Join Now RM20101.BKTMSCAM
BKTPURAM numeric(19,5)

Backout Pu...(more) Join Now PM10000.BKTPURAM
PCHSCHID char(15)

Purchase S...(more) Join Now PM10000.PCHSCHID
FRTSCHID char(15)

Freight Sc...(more) Join Now RM20101.FRTSCHID
join ... more text available
MSCSCHID char(15)

Misc Sched...(more) Join Now RM20101.MSCSCHID
join ... more text available
PRINTED tinyint

Printed: ...(more) Join Now PM10000.PRINTED
PRCTDISC smallint

Percent Di...(more) Join Now PM10000.PRCTDISC
RETNAGAM numeric(19,5)

Retainage ...(more) Join Now PM10000.RETNAGAM
ICTRX tinyint

IC TRX: T...(more) Join Now GL20000.ICTRX
ICDISTS tinyint

ICDists: I...(more) Join Now PM10000.ICDISTS
PMICMSGS binary(4)

ICMessages...(more) Join Now PM10000.PMICMSGS
Tax_Date datetime

Tax Date: ...(more) Join Now RM20101.Tax_Date
PRCHDATE datetime

Purchase D...(more) Join Now PM10000.PRCHDATE
CORRCTN tinyint

Correction...(more) Join Now RM20101.CORRCTN
SIMPLIFD tinyint

Simplified...(more) Join Now RM20101.SIMPLIFD
CORRNXST tinyint

Correction...(more) Join Now RM10301.CORRNXST
VCHRNCOR char(21)

Voucher Nu...(more) Join Now PM10000.VCHRNCOR
PMWRKMS2 binary(4)

PM Work Me...(more) Join Now PM10000.PMWRKMS2
BNKRCAMT numeric(19,5)

Bank Recei...(more) Join Now POP10300.BNKRCAMT
APLYWITH tinyint

Apply With...(more) Join Now RM20101.APLYWITH
Electronic tinyint

Electronic...(more) Join Now RM20101.Electronic
ECTRX tinyint

EC Transac...(more) Join Now RM20101.ECTRX
DocPrinted tinyint

DocPrinted...(more) Join Now RM10301.DocPrinted
TaxInvReqd tinyint

Tax Invoic...(more) Join Now POP30300.TaxInvReqd
BackoutTradeDisc numeric(19,5)

Backout Tr...(more) Join Now RM20101.BackoutTradeDisc
CIS_Amount numeric(19,5)


CITB_Amount numeric(19,5)


Originating_CIS_Amount numeric(19,5)


Originating_CITB_Amount numeric(19,5)


Retention_Amount numeric(19,5)


Originating_Retention_Am numeric(19,5)


HOLD tinyint

Hold: 1 i...(more) Join Now RM00101.HOLD
RetainageDocument tinyint


ORIG_VOUCHER_NUM char(21)


Posted_To_WIP tinyint


CIS_Certificate_Type smallint


JCCIS_Payment_Status smallint


Subcontractor_Type smallint


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