Module List >
Module Manufacturing tables
PK010033
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PK010033 Table Definition
(COMPANY..Picklist File)
Field Definitions:
What is the 'source' column?
| 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
|
|
|
|
|