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 IVC tables IVC30101
You are currently viewing the COMPANY database.
Change

COMPANY..IVC30101 Table Definition

(COMPANY..Invoicing Transaction History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
DOCTYPE smallint
0
Document T...(more) Join Now PM10000.DOCTYPE
INVCNMBR char(21)
''

BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
PCKSLPNO char(21)
''
Packing Sl...(more) Join Now SOP10100.PCKSLPNO
CUSTNMBR char(15)
''
Customer N...(more) Join Now RM20101.CUSTNMBR
join ... more text available
CUSTNAME char(65)
''
Customer N...(more) Join Now RM10301.CUSTNAME
CSTPONBR char(21)
''
Tax Schedu...(more) Join Now RM10301.CSTPONBR
POSTDATE datetime
'1/1/1900'
Post Dateb...(more) Join Now RM20101.POSTDATE
GLPOSTDT datetime
'1/1/1900'
GL Posting...(more) Join Now
DOCDATE datetime
'1/1/1900'
Document D...(more) Join Now
QUOTEDAT datetime
'1/1/1900'

ORDRDATE datetime
'1/1/1900'

DISCDATE datetime
'1/1/1900'
Discount D...(more) Join Now PM10000.DISCDATE
DUEDATE datetime
'1/1/1900'
Due Date: ...(more) Join Now PM10000.DUEDATE
HOLDNT tinyint
0

SHIPMTHD char(15)
''
Shipping M...(more) Join Now RM20101.SHIPMTHD
join ... more text available
TAXEXMT1 char(25)
''
Tax Exempt...(more) Join Now RM00101.TAXEXMT1
TAXEXMT2 char(25)
''
Tax Exempt...(more) Join Now RM00101.TAXEXMT2
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now PM10000.TAXSCHID
join ... more text available
FRTSCHID char(15)
''
Freight Sc...(more) Join Now RM20101.FRTSCHID
join ... more text available
FRGTTXBL smallint
0
Freight Ta...(more) Join Now SOP10100.FRGTTXBL
FRTTXAMT numeric(19,5)
0.00
Freight Ta...(more) Join Now POP10300.FRTTXAMT
MSCSCHID char(15)
''
Misc Sched...(more) Join Now RM20101.MSCSCHID
join ... more text available
MISCTXBL smallint
0
Misc Taxab...(more) Join Now SOP10100.MISCTXBL
MSCTXAMT numeric(19,5)
0.00
Misc Tax A...(more) Join Now POP10300.MSCTXAMT
MRKDNAMT numeric(19,5)
0.00
Markdown A...(more) Join Now SOP10100.MRKDNAMT
SLPRSNID char(15)
''
Salesperso...(more) Join Now RM20101.SLPRSNID
join ... more text available
SALSTERR char(15)
''
Sales Terr...(more) Join Now RM10301.SALSTERR
join ... more text available
TXRGNNUM char(25)
''
Tax Regist...(more) Join Now RM00101.TXRGNNUM
PYMTRMID char(21)
''
Payment Te...(more) Join Now PM10000.PYMTRMID
SY033... more text available
PRCLEVEL char(11)
''
Price Leve...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
CURNCYID char(15)
''
Currency I...(more) Join Now CM20000
join ... more text available
COMMNTID char(15)
''
Comment ID...(more) Join Now SOP10100.COMMNTID
join ... more text available
DOCAMNT numeric(19,5)
0.00
Source Doc...(more) Join Now PM10000.DOCAMNT
SUBTOTAL numeric(19,5)
0.00
Subtotal: ...(more) Join Now POP30300.SUBTOTAL
FRTAMNT numeric(19,5)
0.00
Freight Am...(more) Join Now PM10000.FRTAMNT
MISCAMNT numeric(19,5)
0.00
Misc Amoun...(more) Join Now RM20101.MISCAMNT
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now RM20101.TAXAMNT
TXBTXAMT numeric(19,5)
0.00
Taxable Ta...(more) Join Now SOP10100.TXBTXAMT
TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now RM20101.TRDISAMT
ACCTAMNT numeric(19,5)
0.00
Account Am...(more) Join Now
PYMTRCVD numeric(19,5)
0.00
Payment Re...(more) Join Now SOP10100.PYMTRCVD
CODAMNT numeric(19,5)
0.00
COD Amount...(more) Join Now SOP10100.CODAMNT
EXTDCOST numeric(19,5)
0.00
Extended C...(more) Join Now
DISAVTKN numeric(19,5)
0.00
Discount A...(more) Join Now RM20101.DISAVTKN
DISCRTND numeric(19,5)
0.00
Discount R...(more) Join Now RM20101.DISCRTND
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now RM20101.DISTKNAM
DISAVAMT numeric(19,5)
0.00
Discount A...(more) Join Now RM20101.DISAVAMT
DSCDLRAM numeric(19,5)
0.00
Discount D...(more) Join Now PM10000.DSCDLRAM
DSCPCTAM smallint
0
Discount P...(more) Join Now RM20101.DSCPCTAM
PRBTADCD char(15)
''
Primary Bi...(more) Join Now RM00101.PRBTADCD
join ... more text available
PRSTADCD char(15)
''
Primary Sh...(more) Join Now RM00101.PRSTADCD
join ... more text available
CNTCPRSN char(61)
''
Contact Pe...(more) Join Now RM00101.CNTCPRSN
ADDRESS1 char(61)
''
Address 1:...(more) Join Now RM00101.ADDRESS1
ADDRESS2 char(61)
''
Address 2:...(more) Join Now RM00101.ADDRESS2
ADDRESS3 char(61)
''
Address 3:...(more) Join Now RM00101.ADDRESS3
CITY char(35)
''
City: City...(more) Join Now RM00101.CITY
STATE char(29)
''
State: Up...(more) Join Now RM00101.STATE
ZIPCODE char(11)
''
Zip Code: ...(more) Join Now SOP10100.ZIPCODE
CCode char(7)
''
Country Co...(more) Join Now RM00101.CCode
COUNTRY char(61)
''
Country: C...(more) Join Now RM00101.COUNTRY
PHNUMBR1 char(21)
''
Phone Numb...(more) Join Now SOP10100.PHNUMBR1
PHNUMBR2 char(21)
''
Phone Numb...(more) Join Now SOP10100.PHNUMBR2
PHONE3 char(21)
''
Phone 3: ...(more) Join Now RM00101.PHONE3
FAXNUMBR char(21)
''
Fax Number...(more) Join Now SOP10100.FAXNUMBR
COMAPPTO smallint
0
Commission...(more) Join Now RM10301.COMAPPTO
COMDLRAM numeric(19,5)
0.00
Commission...(more) Join Now RM20101.COMDLRAM
NCOMAMNT numeric(19,5)
0.00
Non-Commis...(more) Join Now RM10301.NCOMAMNT
UPSZONE char(3)
''
UPS Zone: ...(more) Join Now RM00101.UPSZONE
LSTUSRED char(15)
''
Last User ...(more) Join Now RM20101.LSTUSRED
LSTEDTDT datetime
'1/1/1900'
Last Edit ...(more) Join Now RM20101.LSTEDTDT
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now
USER2ENT char(15)
''
User To En...(more) Join Now POP10300.USER2ENT
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
TIMESPRT smallint
0
Times Prin...(more) Join Now SOP10100.TIMESPRT
NOCARTNS smallint
0

USERDEF1 char(21)
''
UserDefine...(more) Join Now CM20200.USERDEF1
USERDEF2 char(21)
''
UserDefine...(more) Join Now CM20200.USERDEF2
VOIDSTTS smallint
0
Void Statu...(more) Join Now POP30300.VOIDSTTS
TRXSORCE char(13)
''
Transactio...(more) Join Now
LNITMSEQ int
0
Line Item ...(more) Join Now PA01301.LNITMSEQ
COMMENT_1 char(51)
''
Comment [1...(more) Join Now POP10150.COMMENT_1
COMMENT_2 char(51)
''
Comment [1...(more) Join Now POP10150.COMMENT_2
COMMENT_3 char(51)
''
Comment [1...(more) Join Now POP10150.COMMENT_3
COMMENT_4 char(51)
''
Comment [1...(more) Join Now POP10150.COMMENT_4
ECTRX tinyint
0
EC Transac...(more) Join Now RM20101.ECTRX
ShipToName char(65)
''
ShipToName...(more) Join Now SOP10100.ShipToName
Tax_Date datetime
'1/1/1900'
Tax Date: ...(more) Join Now RM20101.Tax_Date
APLYWITH tinyint
0
Apply With...(more) Join Now RM20101.APLYWITH
WITHHAMT numeric(19,5)
0.00
Withholdin...(more) Join Now POP30300.WITHHAMT
DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
CMMTTEXT text

 Comment Te...(more) Join Now POP10150.CMMTTEXT
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