ITM_TML_GRP2LVW

(SQL View)
 Index Back

MASTER_ITEM_TBL Item Template

Item Template Fields Table for Template Processing

SELECT DISTINCT SETID , TEMPLATE_CD , TEMPLATE_ID , TMPL_TABLE_NAME , LANGUAGE_CD , DESCR150_MIXED FROM PS_ITM_TML_GRPLHDR WHERE TMPL_TABLE_NAME = '6'

  • Related Language Record for ITM_TML_GRP2VW

    • # 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_CD Character(20) VARCHAR2(20) NOT NULL Template Code

    Prompt Table: %EDITTABLE3

    3 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
    4 TMPL_TABLE_NAME Character(2) VARCHAR2(2) NOT NULL Field Used to store table that item template will be updating
    1=Master Item Group
    10=Item Cost Method
    11=Product Attributes Group
    12=BU Item Substitutes
    13=Purchasing Attributes Group
    14=Inventory Management Group
    15=Inventory Fulfillment Group
    16=Picking/Putaway Zones
    17=Fixed Picking Location
    18=Default Putaway Location
    19=Item Putaway Rules
    2=Inventory Items
    20=Planning Attributes
    21=Replenishment Attributues
    22=Automatic Serial Numbering
    23=PO BU Item Attributes
    24=Item Supplier Attributes Group
    3=Inv Item UOM
    30=Manufactured Item Group
    31=UPN Attributes
    32=GPO Attributes
    36=Replenishment Location
    4=Item UOM Type
    5=Substitute Items
    6=Business Unit Item Group
    7=BU Items Config
    8=BU Items Util CD
    9=BU Items WtVol
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description