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

COMPANY..OSRC1300 Table Definition

(COMPANY..OSRC_Recorded_Shipments_MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Shipment_ID int
0

MANUFACTUREORDER_I char(31)
''

RTSEQNUM_I char(11)
''

ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
ITEMDESC char(101)
''
Item Descr...(more) Join Now POP10110.ITEMDESC
VENDORID char(15)
''
Vendor ID ...(more) Join Now POP10100.VENDORID
join ... more text available
QTYSHPPD numeric(19,5)
0.00
QTY Shippe...(more) Join Now
Ship_Date datetime
'1/1/1900'

RETUDATE datetime
'1/1/1900'

SHIPMTHD char(15)
''
Shipping M...(more) Join Now POP10100.SHIPMTHD
join ... more text available
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
USERDEF1 char(21)
''
UserDefine...(more) Join Now PM00200.USERDEF1
UOFM char(9)
''
U of M The...(more) Join Now POP10110.UOFM
See I... more text available
VOIDED tinyint
0

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
OSRC_Item_Type smallint
0

Ship_By_Date datetime
'1/1/1900'

SEQ_I int
0

VOIDEDBY char(15)
''

VOIDDATE datetime
'1/1/1900'

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