IN_ITM_SCH_HDR(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | TEMPLATE_LIST_ID |
Character(20) | VARCHAR2(20) NOT NULL | Item Template List ID |
| 3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | ITM_SELECTION | Character(4) | VARCHAR2(4) NOT NULL |
10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template.Contains translate value for Item Selection for Search Criteria Page in Item Template.
A=All Items R=Range of Items S=Specific Item Default Value: A |
| 5 | FROM_ITEMID | Character(18) | VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
Prompt Table: MASTER_ITEM_VW |
| 6 | TO_ITEMID | Character(18) | VARCHAR2(18) NOT NULL |
To Item ID
Prompt Table: MASTER_ITEM_VW |
| 7 | 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 |
| 8 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 9 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL |
Item Group
Prompt Table: INV_ITEM_GROUP |
| 10 | INV_PROD_FAM_CD | Character(10) | VARCHAR2(10) NOT NULL |
Family
Prompt Table: INV_ITEM_FAM |
| 11 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL |
Category Code
Prompt Table: ITM_CAT_VW |
| 12 | ALLOW_MODIFY | Character(1) | VARCHAR2(1) NOT NULL |
Allow Modify Comments
Y/N Table Edit Default Value: N |