Module List > Module ASI tables ASI12306
You are currently viewing the COMPANY database.
Change

COMPANY..ASI12306 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
USERID char
''
The user t...(more) Join Now
join ... more text available
PONUMBER char
''
PO Number ...(more) Join Now SEE30303.PONUMBER
DOCPRINTSEQ int


ORD int
0

BRKFLD1 smallint
0
Break Fiel...(more) Join Now gpUPRCPR.BRKFLD1
BRKFLD2 smallint
0

BRKFLD3 smallint
0

ITEMNMBR char
''
span style...(more) Join Now JC00701.ITEMNMBR
join ... more text available
ITEMDESC char
''
Item Descr...(more) Join Now WO010116.ITEMDESC
VNDITNUM char
''
Vendor Ite...(more) Join Now QAD10532.VNDITNUM
VNDITDSC char
''

REQDATE datetime
'1/1/1900'
Required D...(more) Join Now OSRC1100.REQDATE
UOFM char
''
U of M The...(more) Join Now gpItmCus.UOFM
See I... more text available
QTYORDER numeric
0.00

QTYCANCE numeric
0.00
QTY Cancel...(more) Join Now ENC10111.QTYCANCE
UNITCOST numeric
0.00
Unit Cost:...(more) Join Now SEE30303.UNITCOST
ORUNTCST numeric
0.00
Unit Price...(more) Join Now PA11801.ORUNTCST
EXTDCOST numeric
0.00
Extended C...(more) Join Now SEE30303.EXTDCOST
OREXTCST numeric
0.00
Originatin...(more) Join Now PTE30501.OREXTCST
COMMNTID char
''

join ... more text available
DECPLCUR smallint
0
Number of ...(more) Join Now
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
ODECPLCU smallint
0

DOCTYPE smallint
0
Document T...(more) Join Now PM30300.DOCTYPE
POLNESTA smallint
0
PO Line St...(more) Join Now POP30110.POLNESTA
Change_Order_Flag smallint
0

TAXDTLID char
''
Tax Detail...(more) Join Now PM30300.TAXDTLID
RELEASEBYDATE datetime
'1/1/1900'
Release By...(more) Join Now OSRC1110.RELEASEBYDATE
Released_Date datetime
'1/1/1900'

FREEONBOARD smallint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
LineNumber smallint


ADDRSEQ int


SHIPMTHD char


join ... more text available
ADDRPROMPT char


CMPNYNAM char

Company Na...(more) Join Now ACTIVITY.CMPNYNAM
CONTACT char


ADDRESS1 char


ADDRESS2 char


ADDRESS3 char


CITY char


STATE char


ZIPCODE char


COUNTRY char


ProjNum char


CostCatID char


PHONNAME char


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