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

COMPANY..IVC10100 Table Definition

(COMPANY..Invoicing Transaction Work)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
DOCTYPE smallint
0
Document T...(more) Join Now
INVCNMBR char(21)
''
Invoice Nu...(more) Join Now
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
CUSTNMBR char(15)
''
Customer N...(more) Join Now
join ... more text available
CUSTNAME char(65)
''
Customer N...(more) Join Now
CSTPONBR char(21)
''
Customer P...(more) Join Now
POSTDATE datetime
'1/1/1900'
Post Date:...(more) Join Now
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'
Quote Date...(more) Join Now
ORDRDATE datetime
'1/1/1900'
Order Date...(more) Join Now
DISCDATE datetime
'1/1/1900'
Discount D...(more) Join Now
DUEDATE datetime
'1/1/1900'
Due Date: ...(more) Join Now
HOLDNT tinyint
0
Hold NT: ...(more) Join Now
SHIPMTHD char(15)
''
Shipping M...(more) Join Now
join ... more text available
TAXEXMT1 char(25)
''
Tax Exempt...(more) Join Now
TAXEXMT2 char(25)
''
Tax Exempt...(more) Join Now
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now
join ... more text available
FRTSCHID char(15)
''
Freight Sc...(more) Join Now
join ... more text available
FRGTTXBL smallint
0
Freight Ta...(more) Join Now
FRTTXAMT numeric(19,5)
0.00
Freight Ta...(more) Join Now
MSCSCHID char(15)
''
Misc Sched...(more) Join Now
join ... more text available
MISCTXBL smallint
0
Misc Taxab...(more) Join Now
MSCTXAMT numeric(19,5)
0.00
Misc Tax A...(more) Join Now
SLPRSNID char(15)
''
Salesperso...(more) Join Now
join ... more text available
SALSTERR char(15)
''
Sales Terr...(more) Join Now
join ... more text available
TXRGNNUM char(25)
''
Tax Regist...(more) Join Now
PYMTRMID char(21)
''
Payment Te...(more) Join Now
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
join ... more text available
COMMNTID char(15)
''
Comment ID...(more) Join Now
join ... more text available
DOCAMNT numeric(19,5)
0.00
Document A...(more) Join Now
SUBTOTAL numeric(19,5)
0.00
Subtotal: ...(more) Join Now
FRTAMNT numeric(19,5)
0.00
Freight Am...(more) Join Now
MISCAMNT numeric(19,5)
0.00
Misc Amoun...(more) Join Now
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
TXBTXAMT numeric(19,5)
0.00
Taxable Ta...(more) Join Now
BCKTXAMT numeric(19,5)
0.00
Backout Ta...(more) Join Now
BKTSLSAM numeric(19,5)
0.00
Backout Sa...(more) Join Now
BKTFRTAM numeric(19,5)
0.00
Backout Fr...(more) Join Now
BKTMSCAM numeric(19,5)
0.00
Backout Mi...(more) Join Now
DISCFRGT numeric(19,5)
0.00
Discount A...(more) Join Now
DISCMISC numeric(19,5)
0.00
Discount A...(more) Join Now
TRDISPCT smallint
0
Trade Disc...(more) Join Now
TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now
ACCTAMNT numeric(19,5)
0.00
Account Am...(more) Join Now
PYMTRCVD numeric(19,5)
0.00
Payment Re...(more) Join Now
CODAMNT numeric(19,5)
0.00
COD Amount...(more) Join Now
EXTDCOST numeric(19,5)
0.00
Extended C...(more) Join Now
DISCRTND numeric(19,5)
0.00
Discount R...(more) Join Now
DISAVTKN numeric(19,5)
0.00
Discount A...(more) Join Now
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now
DISAVAMT numeric(19,5)
0.00
Discount A...(more) Join Now
DSCDLRAM numeric(19,5)
0.00
Discount D...(more) Join Now
DSCPCTAM smallint
0
Discount P...(more) Join Now
MRKDNAMT numeric(19,5)
0.00
Markdown A...(more) Join Now
PRBTADCD char(15)
''
Primary Bi...(more) Join Now
join ... more text available
PRSTADCD char(15)
''
Primary Sh...(more) Join Now
join ... more text available
CNTCPRSN char(61)
''
Contact Pe...(more) Join Now
ADDRESS1 char(61)
''
Address 1:...(more) Join Now
ADDRESS2 char(61)
''
Address 2:...(more) Join Now
ADDRESS3 char(61)
''
Address 3:...(more) Join Now
CITY char(35)
''
City: The...(more) Join Now
STATE char(29)
''
State: Th...(more) Join Now
ZIPCODE char(11)
''
Zip Code: ...(more) Join Now
CCode char(7)
''
Country Co...(more) Join Now
COUNTRY char(61)
''
Country: ...(more) Join Now
PHNUMBR1 char(21)
''
Phone Numb...(more) Join Now
PHNUMBR2 char(21)
''
Phone Numb...(more) Join Now
PHONE3 char(21)
''
Phone 3: T...(more) Join Now
FAXNUMBR char(21)
''
Fax Number...(more) Join Now
COMAPPTO smallint
0
Commission...(more) Join Now
COMDLRAM numeric(19,5)
0.00
Commission...(more) Join Now
NCOMAMNT numeric(19,5)
0.00
Non-Commis...(more) Join Now
UPSZONE char(3)
''
UPS Zone: ...(more) Join Now
LSTUSRED char(15)
''
Last User ...(more) Join Now
LSTEDTDT datetime
'1/1/1900'
Last Edit ...(more) Join Now
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
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
TIMESPRT smallint
0
Times Prin...(more) Join Now
NOCARTNS smallint
0
Number Of ...(more) Join Now
USERDEF1 char(21)
''
User Defin...(more) Join Now
USERDEF2 char(21)
''
User Defin...(more) Join Now
VOIDSTTS smallint
0
Void Statu...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
PSTGSTUS smallint
0
Posting St...(more) Join Now
IVCHDER1 binary(4)
0
IVC HDR Er...(more) Join Now
IVCHDER2 binary(4)
0
IVC HDR Er...(more) Join Now
IVCLINEERR binary(4)
0
IVC LINE E...(more) Join Now
LNITMSEQ int
0
Line Item ...(more) Join Now
COMMENT_1 char(51)
''
[4]Comment...(more) Join Now
COMMENT_2 char(51)
''
[4]Comment...(more) Join Now
COMMENT_3 char(51)
''
[4]Comment...(more) Join Now
COMMENT_4 char(51)
''
[4]Comment...(more) Join Now
ECTRX tinyint
0
EC Transac...(more) Join Now
ShipToName char(65)
''
ShipToName...(more) Join Now
Tax_Date datetime
'1/1/1900'
Tax Date: ...(more) Join Now
APLYWITH tinyint
0
Apply With...(more) Join Now
WITHHAMT numeric(19,5)
0.00
Withholdin...(more) Join Now
BackoutTradeDisc numeric(19,5)
0.00
Backout Tr...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
CMMTTEXT text

Comment Te...(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