DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3