MST_LOAD_EC_TAO(SQL Table) |
Index Back |
|---|---|
Item Loader master_items_tbl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ECQUEUEINSTANCE |
Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. |
| 3 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 4 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | ITM_STATUS_CURRENT | Character(1) | VARCHAR2(1) NOT NULL |
Item Status Current
1=Active 2=Hold 3=Discontinue 4=Inactive 5=Pending Approval 6=Denied Approval 7=Under Initialization |
| 7 | ITM_STATUS_FUTURE | Character(1) | VARCHAR2(1) NOT NULL |
Item Status Future
1=Active 2=Hold 3=Discontinue 4=Inactive |
| 8 | ITM_STAT_DT_FUTURE | Date(10) | DATE | Item Date Future |
| 9 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 12 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 13 | DEFINE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Item Definition Status
1=Under Initialization 2=Initialization Complete |
| 14 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 15 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Item Group |
| 16 | INV_PROD_FAM_CD | Character(10) | VARCHAR2(10) NOT NULL | Family |
| 17 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL | Category Code |
| 18 | DESCR_CAT | Character(60) | VARCHAR2(60) NOT NULL | Category Description |
| 19 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
| 20 | DESCR_MFG | Character(60) | VARCHAR2(60) NOT NULL | Manufacturer description |
| 21 | MFG_ITM_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer's Item ID |
| 22 | APPROVAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Item Definition Approved
A=Approved D=Denied P=Pending |
| 23 | INVENTORY_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Item
N=No Y=Yes |
| 24 | LOT_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Lot Control
N=N Y=Y |
| 25 | SERIAL_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Serial Control
N=N Y=Y |
| 26 | NON_OWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No Y=Yes |
| 27 | APPROV_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL | Approval Required for Demand |
| 28 | DIST_CFG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Distribution Configuration |
| 29 | PRDN_CFG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Production Configuration |
| 30 | CFG_CODE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Configuration Code Generation
B=Both N=No Y=Yes |
| 31 | CFG_COST_OPT | Character(1) | VARCHAR2(1) NOT NULL | Configuration Costing |
| 32 | CFG_LOT_OPT | Character(1) | VARCHAR2(1) NOT NULL | Default Configured Lot |
| 33 | CP_TEMPLATE_ID | Character(10) | VARCHAR2(10) NOT NULL | Template ID Field |
| 34 | UPDATE_ITEM | Character(1) | VARCHAR2(1) NOT NULL | Update Inventory Item |
| 35 | MATERIAL_RECON_FLG | Character(1) | VARCHAR2(1) NOT NULL | Material Reconciliation Flag |
| 36 | USG_TRCKNG_METHOD | Character(2) | VARCHAR2(2) NOT NULL |
Usage Tracking Method
01=None 02=Billing 03=Costing |
| 37 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Consigned Flag |
| 38 | ITM_STATUS_EFFDT | Date(10) | DATE |
Item Status Date
Default Value: %DATE |