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

COMPANY..ASI25820 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CMPANYID smallint

Company ID...(more) Join Now WPPU0114.CMPANYID
join ... more text available
USERID char

The user t...(more) Join Now
join ... more text available
PONUMBER char

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


VENDORID char

Vendor ID:...(more) Join Now PM00200.VENDORID
join ... more text available
PO_Status_Orig smallint


Change_Order_Flag smallint


PO_Field_Changes_Array_1 tinyint


PO_Field_Changes_Array_2 tinyint


PO_Field_Changes_Array_3 tinyint


PO_Field_Changes_Array_4 tinyint


PO_Field_Changes_Array_5 tinyint


PO_Field_Changes_Array_6 tinyint


PO_Field_Changes_Array_7 tinyint


PO_Field_Changes_Array_8 tinyint


PO_Field_Changes_Array_9 tinyint


PO_Field_Changes_Array_10 tinyint


PO_Field_Changes_Array_11 tinyint


PO_Field_Changes_Array_12 tinyint


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


PRINTINGMULTIPLEPO char


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