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

COMPANY..JCCIS150 Table Definition

(COMPANY..JC_Sub_CIS24_Reconcile)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
VENDORID char(15)

Vendor ID:...(more) Join Now PM10000.VENDORID
join ... more text available
VENDNAME char(65)

Vendor Nam...(more) Join Now POP30300.VENDNAME
PMNTNMBR char(21)

Payment Nu...(more) Join Now CM20300.PMNTNMBR
VCHNUMWK char(17)

Voucher Nu...(more) Join Now PM10000.VCHNUMWK
DOCNUMBR char(21)

Document N...(more) Join Now PM10000.DOCNUMBR
DOCDATE datetime

Document D...(more) Join Now PM10000.DOCDATE
TAXAMNT numeric(19,5)

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


CIS_Certificate_Type smallint


Subcontractor_Type smallint


RCPTNMBR char(21)

Receipt Nu...(more) Join Now CM20300.RCPTNMBR
CIS_Card_Number char(33)


DATE1 datetime

Date: Date...(more) Join Now SY03900.DATE1
AMOUNT numeric(19,5)


Outstanding_Amount numeric(19,5)


Matched tinyint


VOIDED tinyint

Voided Tru...(more) Join Now CM20200.VOIDED
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