Module List > Module Manufacturing tables IS010201
You are currently viewing the COMPANY database.
Change

COMPANY..IS010201 Table Definition

(COMPANY..Shipping History Line Hist)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SOPNUMBE char(21)
''

SOPTYPE smallint
0

LNITMSEQ int
0
Line Item ...(more) Join Now PA11801.LNITMSEQ
CMPNTSEQ int
0

DATE1 datetime
'1/1/1900'

DTSEQNUM numeric(19,5)
0.00
Date SEQ N...(more) Join Now POP10330.DTSEQNUM
TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now POP10100.TIME1
QUANTITY numeric(19,5)
0.00
QTY: The n...(more) Join Now VAT10302.QUANTITY
SOSHIPPINGWEIGHT_I int
0

SHIPPINGUOFM_I smallint
0

See I... more text available
UPSZONE char(3)
''

SOQTYPACKAGES_I numeric(19,5)
0.00

SOBOLNUMBER_I char(25)
''

MFGNOTEINDEX_I numeric(19,5)
0.00

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
SHIPMTHD char(15)
''
Shipping M...(more) Join Now POP10100.SHIPMTHD
join ... more text available
SOPFOB_I char(15)
''

QTY_In_Variable_U_Of_M numeric(19,5)
0.00

Variable_U_Of_M char(9)
''

Backout_Extended_Price numeric(19,5)
0.00

Tracking_Number char(41)
''

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