RB_TEMPL_KEYFLD

(SQL View)
 Index Back

template export definition

lists the fields exported from a template as well as the correct usage thereof

SELECT A.LI_TEMPLATE_ID , A.EFFDT , A.RECORDNAME , A.FIELDNAME , A.LI_TEMPLATE_RULE , B.LI_REF_TEMPL_ID , B.REF_KEYNAME , B.LI_MATCH_TGT_REC , B.LI_MATCH_TGT_FLD FROM PS_RB_TEMPL_RULE A , PS_RB_TEMPL_INTFC B WHERE A.LI_TEMPLATE_RULE IN ('01','02','03','21') AND A.LI_TEMPLATE_ID = B.LI_TEMPLATE_ID AND A.EFFDT = B.EFFDT AND A.FIELDNAME = B.FIELDNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LI_TEMPLATE_ID Character(31) VARCHAR2(31) NOT NULL template identifier
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_VENDOR_EC
06=ITM_VNDR_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
11=MANUFACTURER_EC
12=ITEM_MFG_EC
13=EN_REVISION_EC
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
5 LI_TEMPLATE_RULE Character(2) VARCHAR2(2) NOT NULL action to take for a field in a given template
01=Generate Standard Key
02=Generate Sequence Key
03=Reference Key
04=Required Input
05=Optional Input
06=Value
07=Value Reference
08=Lookup Value
09=Concatenation
10=Insert Null
11=Generate Id - Not Key
12=Generate Datetime Stamp
13=Fetch Text
14=Staged Default
15=Mandatory Value
16=First of Group
17=Write Contact Method
18=Cache Contact Method
19=Map Field Reference
20=Bas SysId
6 LI_REF_TEMPL_ID Character(31) VARCHAR2(31) NOT NULL template identifier
7 REF_KEYNAME Character(18) VARCHAR2(18) NOT NULL Reference Keyname
8 LI_MATCH_TGT_REC Character(18) VARCHAR2(18) NOT NULL record against which to match
9 LI_MATCH_TGT_FLD Character(18) VARCHAR2(18) NOT NULL field against which to apply matching rules