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

COMPANY..ASI12315 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CMPANYID smallint
0
Company ID...(more) Join Now WPPU0114.CMPANYID
join ... more text available
USERID char
''
The user t...(more) Join Now
join ... more text available
DOCPRINTSEQ int
0

SOPNUMBE char
''

SOPTYPE smallint
0

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

InfoString1 char
''

ISDEFAULTBIN tinyint
0

SEQNUMBR int
0
Sequence N...(more) Join Now HR2EMP02.SEQNUMBR
BIN char
''
Bin The de...(more) Join Now IV00112.BIN
ComponentBin char
''

PickTickBinBreak char
''

ITEMNMBR char
''
span style...(more) Join Now JC00701.ITEMNMBR
join ... more text available
ITEMDESC char
''
Item Descr...(more) Join Now WO010116.ITEMDESC
BRKFLD2 smallint


CMPTITNM char
''
Component ...(more) Join Now IV00104.CMPTITNM
LNITMSEQ int
0
Line Item ...(more) Join Now PA11801.LNITMSEQ
CMPNTSEQ int
0

INDPICKTICKETLINETYPE smallint
0

QUANTITY numeric
0.00
QTY: The n...(more) Join Now SCSU0030.QUANTITY
UOFM char
''
U of M The...(more) Join Now gpItmCus.UOFM
See I... more text available
SERLTNUM char
''
Serial/Lot...(more) Join Now RVPS0132.SERLTNUM
COMMENT_1 char
''
Comment [1...(more) Join Now B3920601.COMMENT_1
COMMENT_2 char
''
Comment [1...(more) Join Now B3920601.COMMENT_2
COMMENT_3 char
''
Comment [1...(more) Join Now B3920601.COMMENT_3
COMMENT_4 char
''
Comment [1...(more) Join Now B3920601.COMMENT_4
PickInstructions_1 char
''

PickInstructions_2 char
''

PickInstructions_3 char
''

PickInstructions_4 char
''

BULKPICKPRNT tinyint
0

INDPICKPRNT tinyint
0

BRKFLD1 smallint
0
Break Fiel...(more) Join Now gpUPRCPR.BRKFLD1
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
InfoString2 char
''

Reprint tinyint
0

BINBREAK smallint
0

ITMTRKOP smallint
0
Item Track...(more) Join Now WO010400.ITMTRKOP
ITEMTYPE smallint
0

QTYFULFI numeric
0.00
QTY Fulfil...(more) Join Now FI010110.QTYFULFI
DOCUMENTCOMMENTS_1 char
''

DOCUMENTCOMMENTS_2 char
''

DOCUMENTCOMMENTS_3 char
''

DOCUMENTCOMMENTS_4 char
''

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
DOCID char


join ... more text available
CUSTNMBR char

Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
IsBackOrderedQty tinyint


ORD int


ASI_PrintShipToWithLines tinyint


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