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

COMPANY..ASI10532 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ASI_User_ID char


SEQNUMBR int

Sequence N...(more) Join Now HR2EMP02.SEQNUMBR
SCAR_Number char


nsrnum char


DATEENTERED_I datetime


ITEMNMBR char

span style...(more) Join Now JC00701.ITEMNMBR
join ... more text available
VENDORID char

Vendor ID:...(more) Join Now PM00200.VENDORID
join ... more text available
ORIGINATOR char


POPRCTNM char

POP Receip...(more) Join Now QAD30000.POPRCTNM
RCPTLNNM int

Receipt Li...(more) Join Now QAD10532.RCPTLNNM
PONUMBER char

PO Number ...(more) Join Now SEE30303.PONUMBER
POLNENUM int

PO Line Nu...(more) Join Now QAD10532.POLNENUM
LOCNCODE char

Location C...(more) Join Now PA11801.LOCNCODE
join ... more text available
VENDNAME char

Vendor Nam...(more) Join Now RVLPD026.VENDNAME
ADDRESS1 char


ADDRESS2 char


CITY char


STATE char


ZIPCODE char


PHNUMBR1 char


PHNUMBR2 char


FAXNUMBR char


ITEMDESC char

Item Descr...(more) Join Now WO010116.ITEMDESC
VNDITNUM char

Vendor Ite...(more) Join Now QAD10532.VNDITNUM
QTYRECEIVED2_I numeric


BASEUOFM char


See I... more text available
DATEDUE_I datetime


DATEIN_I datetime


VNDCNTCT char


PHONNAME char


USERID char

The user t...(more) Join Now
join ... more text available
CHANGEDATE_I datetime

*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
MFGNOTEINDEX_I numeric


MFGNOTEINDEX2_I numeric


MFGNOTEINDEX3_I numeric


MFGNOTEINDEX4I numeric


MFGNOTEINDEX5I numeric


MFGNOTEINDEX6I numeric


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