Module List > Module IVC tables IVC30102
You are currently viewing the COMPANY database.
Change

COMPANY..IVC30102 Table Definition

(COMPANY..Invoicing Transaction Amounts 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)
''

LNITMSEQ int
0
Line Item ...(more) Join Now PA01301.LNITMSEQ
CMPNTSEQ int
0
Component ...(more) Join Now SOP10200.CMPNTSEQ
NONINVEN smallint
0
Non-IV: Th...(more) Join Now SOP10200.NONINVEN
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
DECPLCUR smallint
0
Number of ...(more) Join Now
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
ITMTSHID char(15)
''
Item Tax S...(more) Join Now IV00101.ITMTSHID
IVITMTXB smallint
0
IV Item Ta...(more) Join Now SOP10200.IVITMTXB
QUANTITY numeric(19,5)
0.00
QTY This i...(more) Join Now
QTYINSVC numeric(19,5)
0.00
QTY In Ser...(more) Join Now IV00102.QTYINSVC
QTYINUSE numeric(19,5)
0.00
QTY In Use...(more) Join Now IV00102.QTYINUSE
QTYDMGED numeric(19,5)
0.00
QTY Damage...(more) Join Now IV00102.QTYDMGED
QTYRTRND numeric(19,5)
0.00
QTY Return...(more) Join Now IV00102.QTYRTRND
QTYONHND numeric(19,5)
0.00
QTY On Han...(more) Join Now IV00102.QTYONHND
EXTQTYSEL numeric(19,5)
0.00
Existing Q...(more) Join Now SOP10200.EXTQTYSEL
UOFM char(9)
''
U Of M: T...(more) Join Now
See I... more text available
QTYBSUOM numeric(19,5)
0.00
QTY In Bas...(more) Join Now
UNITCOST numeric(19,5)
0.00
Unit Cost:...(more) Join Now
EXTDCOST numeric(19,5)
0.00
Extended C...(more) Join Now
ATYALLOC numeric(19,5)
0.00
QTY Alloca...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
MRKDNTYP smallint
0
Markdown T...(more) Join Now SOP10200.MRKDNTYP
MRKDNAMT numeric(19,5)
0.00
Markdown A...(more) Join Now SOP10100.MRKDNAMT
MRKDNPCT smallint
0
Markdown P...(more) Join Now SOP10200.MRKDNPCT
PRCLEVEL char(11)
''
Price Leve...(more) Join Now
XTNDPRCE numeric(19,5)
0.00
Extended P...(more) Join Now SOP10200.XTNDPRCE
UNITPRCE numeric(19,5)
0.00
Unit Price...(more) Join Now SOP10200.UNITPRCE
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now RM20101.TAXAMNT
BKTSLSAM numeric(19,5)
0.00
Backout Sa...(more) Join Now RM20101.BKTSLSAM
TXBTXAMT numeric(19,5)
0.00
Taxable Ta...(more) Join Now SOP10100.TXBTXAMT
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
DSCRIPTN char(31)
''
Descriptio...(more) Join Now CM20300.DSCRIPTN
ITEMDESC char(101)
''
Item Descr...(more) Join Now IV00101.ITEMDESC
EXPTSHIP datetime
'1/1/1900'

ACTLSHIP datetime
'1/1/1900'
Actual Shi...(more) Join Now POP30300.ACTLSHIP
ReqShipDate datetime
'1/1/1900'
Requested ...(more) Join Now SOP10100.ReqShipDate
COMDLRAM numeric(19,5)
0.00
Commission...(more) Join Now RM20101.COMDLRAM
CMPSERNM tinyint
0

COMMNTID char(15)
''
Comment ID...(more) Join Now SOP10100.COMMNTID
join ... more text available
BRKFLD1 smallint
0
Break Fiel...(more) Join Now SOP10200.BRKFLD1
BRKFLD2 smallint
0
Break Fiel...(more) Join Now SOP10200.BRKFLD2
BRKFLD3 smallint
0
Break Fiel...(more) Join Now SOP10200.BRKFLD3
TRXSORCE char(13)
''
Transactio...(more) Join Now
PRSTADCD char(15)
''
Primary Sh...(more) Join Now RM00101.PRSTADCD
join ... more text available
SHIPMTHD char(15)
''
Shipping M...(more) Join Now RM20101.SHIPMTHD
join ... more text available
ISLINEINTRA tinyint
0
SO Fulfill...(more) Join Now SOP10200.ISLINEINTRA
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