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

COMPANY..PK010033 Table Definition

(COMPANY..Picklist File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
MANUFACTUREORDER_I char(31)
''

SEQ_I int
0

MANUFACTUREORDERST_I smallint
0
div style=...(more) Join Now WO010032.MANUFACTUREORDERST_I
PPN_I char(31)
''
Parent Par...(more) Join Now
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
POSITION_NUMBER smallint
0
Position N...(more) Join Now
ROUTINGNAME_I char(31)
''

RTSEQNUM_I char(11)
''

MRPAMOUNT_I numeric(19,5)
0.00

MRPAMOUNT2_I numeric(19,5)
0.00

SUGGESTEDQTY_I numeric(19,5)
0.00

MRPISSUEDATE_I datetime
'1/1/1900'

MRPISSUETIME_I datetime
'1/1/1900'

ALLOCATEDATEI datetime
'1/1/1900'

ALLOCATETIMEI datetime
'1/1/1900'

WCID_I char(11)
''

BACKFLUSHITEM_I tinyint
0

ICBACKORDER_I tinyint
0

ALTERNATE_I tinyint
0

ALTERNATEPARTFOR_I char(31)
''

ALT_FOR_SEQ_I int
0

SUBASSEMBLY_I tinyint
0

SUBASSEMBLYOF_I char(31)
''

SUBASSEMBLY_OF_SEQ int
0

BOMENGAPPROVAL_I tinyint
0

BOMSINGLELOT_I tinyint
0

LOCNCODE char(11)
''
Location C...(more) Join Now POP10110.LOCNCODE
join ... more text available
ALLOCATED_I tinyint
0

ISSUED_I tinyint
0

FLOORSTOCK_I tinyint
0

CALCMRP_I tinyint
0

PHANTOM_I tinyint
0

CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
ALLOCATEUID_I char(15)
''

ISSUEDUID_I char(15)
''

RELIEFCOST_I numeric(19,5)
0.00

RETURNTOSTOCK_I numeric(19,5)
0.00

NUMBERSCRAPPED_I numeric(19,5)
0.00

ACTUAL_CONSUMED_I numeric(19,5)
0.00

PORDNMBR char(21)
''
Purchase O...(more) Join Now JC00701.PORDNMBR
POLINE_I smallint
0

QTY_ALLOWED_I numeric(19,5)
0.00

CURRENT_CONSUMED_I numeric(19,5)
0.00

CURRENT_RTS_I numeric(19,5)
0.00

CURRENT_SCRAPPED_I numeric(19,5)
0.00

OPTIONED_ITEM_I tinyint
0

MRKDNAMT numeric(19,5)
0.00
Markdown A...(more) Join Now
BOMCAT_I smallint
0

BOMNAME_I char(15)
''
Bill of Ma...(more) Join Now
PROMOTION_ID_I char(31)
''

ACTUAL_CONSUMED_CHECK_I tinyint
0

REQDATE datetime
'1/1/1900'
Required D...(more) Join Now POP10110.REQDATE
UOFM char(9)
''
U of M The...(more) Join Now POP10110.UOFM
See I... more text available
ATYALLOC numeric(19,5)
0.00
QTY Alloca...(more) Join Now IV00112.ATYALLOC
UNITCOST numeric(19,5)
0.00
Field Type...(more) Join Now
NON_INV_CRED_ACCT_IDX_I int
0

QTYBSUOM numeric(19,5)
0.00
QTY In Bas...(more) Join Now
QTY_ISSUED_I numeric(19,5)
0.00

QTY_BACKFLUSHED_I numeric(19,5)
0.00

NON_INV_ITEM_DESC_I char(51)
''

LINK_TO_SEQUENCE_I int
0

FIXED_QTY_I numeric(19,5)
0.00

LEADTIMEOFFSET_I numeric(19,5)
0.00

OFFSET_FROM_I smallint
0

BOMUSERDEF1_I char(31)
''

BOMUSERDEF2_I char(31)
''

EXPLODE_QTY_I numeric(19,5)
0.00

MFGNOTEINDEX_I numeric(19,5)
0.00

BOMSEQ_I int
0
Bill of Ma...(more) Join Now
POSITION_NUMBER2 smallint
0

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