Module List >
Module Manufacturing tables
MRP0101
You are currently viewing the COMPANY
database.
Change
|
COMPANY..MRP0101 Table Definition
(COMPANY..mrpItemSitesList)
Field Definitions:
What is the 'source' column?
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
IV10201.ITEMNMBR
|
|
join ... more text available
|
| LOCNCODE |
char(11)
''
|
Location C...(more) Join Now
|
POP10110.LOCNCODE
|
|
join ... more text available
|
| REPLENISHMENTMETHOD |
smallint
0
|
|
|
|
|
| PRIMVNDR |
char(15)
''
|
|
|
|
|
| PRCHSNGLDTM |
numeric(19,5)
0.00
|
|
|
|
|
| MNFCTRNGFXDLDTM |
numeric(19,5)
0.00
|
|
|
|
|
| MNFCTRNGVRBLLDTM |
numeric(19,5)
0.00
|
|
|
|
|
| MNMMORDRQTY |
numeric(19,5)
0.00
|
|
|
|
|
| MXMMORDRQTY |
numeric(19,5)
0.00
|
|
|
|
|
| ORDERMULTIPLE |
numeric(19,5)
0.00
|
|
|
|
|
| FXDORDRQTY |
numeric(19,5)
0.00
|
|
|
|
|
| NMBROFDYS |
smallint
0
|
|
|
|
|
| ORDRPNTQTY |
numeric(19,5)
0.00
|
|
|
|
|
| ORDRUPTOLVL |
numeric(19,5)
0.00
|
|
|
|
|
| SFTYSTCKQTY |
numeric(19,5)
0.00
|
|
|
|
|
| ORDERPOLICY |
smallint
0
|
|
|
|
|
| SHRINKAGEFACTOR |
numeric(19,5)
0.00
|
|
|
|
|
| PLNNNGTMFNCDYS |
smallint
0
|
|
|
|
|
| PLANNERID |
char(15)
''
|
|
|
|
|
| BUYERID |
char(15)
''
|
Buyer ID ...(more) Join Now
|
|
|
|
| MOVEIN |
tinyint
0
|
|
|
|
|
| MOVEOUT |
tinyint
0
|
|
|
|
|
| CANCELED |
tinyint
0
|
|
|
|
|
| Move_Out_Fence |
smallint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|