ITEM_TMPL_TMP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: INBU_TML4_VW |
| 2 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL |
Category ID
Prompt Table: ITM_CAT_TBL_AD2 |
| 3 | CM_BOOK | Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 4 | CM_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements |
| 5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 6 | EFFDT | Date(10) | DATE | Effective Date |
| 7 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 8 | INV_UOM_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Inventory UOM Type
ORDR=Ordering SHIP=Shipping STCK=Stocking |
| 9 | INVENTORY_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Item
N=No Y=Yes |
| 10 | SERIAL_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Serial Control
N=N Y=Y Y/N Table Edit |
| 11 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 12 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL |
Standard Unit of Measure
Prompt Table: UNITS_TBL |
| 13 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |
| 14 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 15 | 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 |
| 16 | ITM_STATUS_FUTURE | Character(1) | VARCHAR2(1) NOT NULL |
Item Status Future
1=Active 2=Hold 3=Discontinue 4=Inactive |
| 17 | LOT_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Lot Control
N=N Y=Y |
| 18 | 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 |
| 19 | DFLT_ACTUAL_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Default Actual Cost |
| 20 | QTY_PRECISION | Character(1) | VARCHAR2(1) NOT NULL |
Quantity Precision
D=Decimal W=Whole Nbr |
| 21 | ROUND_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Rule
D=Round Down N=Natural Round U=Round Up |
| 22 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 23 | PLANNER_CD | Character(12) | VARCHAR2(12) NOT NULL | Planner Code |
| 24 | SOURCE_CODE | Character(2) | VARCHAR2(2) NOT NULL |
8/5/97 lee - inactivated source code 4 - service
1=Make 2=Buy 3=Expense 4=Service 5=Floor Stock 6=Planning |
| 25 | INSPECT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Inspection Required
N=No Y=Yes |
| 26 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 27 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Item Group |
| 28 | INV_PROD_FAM_CD | Character(10) | VARCHAR2(10) NOT NULL | Family |
| 29 | PRDN_CFG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Production Configuration |
| 30 | DIST_CFG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Distribution Configuration |
| 31 | SERIAL_IN_PRDN | Character(1) | VARCHAR2(1) NOT NULL | Serial in Production |
| 32 | TRACE_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
Trace Usage
0=None 1=Serial Trace 2=Lot Trace |
| 33 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Consigned Flag |
| 34 | CFG_CODE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Configuration Code Generation
B=Both N=No Y=Yes |
| 35 | PROMISE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Order Promise Option
2=Perform ATP Reservations |
| 36 | TEMPLATE_CD | Character(20) | VARCHAR2(20) NOT NULL | Template Code |
| 37 | TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL | Project Template |
| 38 | ITMV_PRIORITY_LOC | Character(10) | VARCHAR2(10) NOT NULL | Item Supplier Priority Loc |
| 39 | STD_LEAD | Number(3,0) | SMALLINT NOT NULL | Purchase Lead Time Days |
| 40 | STOCKLESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Stockless Item
N=No Y=Yes |
| 41 | QTY_MIN | Number(16,4) | DECIMAL(15,4) NOT NULL | Minimum Quantity |
| 42 | QTY_MAX | Number(16,4) | DECIMAL(15,4) NOT NULL | Maximum Quantity |
| 43 | ITM_STATUS_EFFDT | Date(10) | DATE |
Item Status Date
Default Value: %DATE |
| 44 | CM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements |
| 45 | MATERIAL_RECON_FLG | Character(1) | VARCHAR2(1) NOT NULL | Material Reconciliation Flag |
| 46 | USG_TRCKNG_METHOD | Character(2) | VARCHAR2(2) NOT NULL |
Usage Tracking Method
01=None 02=Billing 03=Costing |
| 47 | STAGED_DATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Staged Date Control
N=Staged Date Tracking OFF Y=Staged Date Tracking ON |
| 48 | CHARGE_MARKUP_AMT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Charge Markup Amt |
| 49 | CHARGE_MARKUP_PCNT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Charge Markup % |
| 50 | CHARGE_CODE | Character(20) | VARCHAR2(20) NOT NULL | Charge Code |
| 51 | SRC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Sourcing Method
B=Basic F=Flexible H=Cumulative Split S=Sched Split |
| 52 | USE_CAT_SRC_CNTL | Character(1) | VARCHAR2(1) NOT NULL | Use Category Sourcing Controls |