| # |
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
Prompt Table:
RB_RECDEFN_VW
|
| 4 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
PSRECFIELDALL
|
| 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_GROUP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
should these fields be grouped by?
Y/N Table Edit
Default Value: N
|
| 7 |
LI_IGNORE_FORMAT |
Character(1) |
VARCHAR2(1) NOT NULL |
should the format of the end-field be ignored and incoming values assumed to be valid for the field?
Y/N Table Edit
Default Value: N
|
| 8 |
VALUE_DISPLAY |
Character(254) |
VARCHAR2(254) NOT NULL |
Value
|
| 9 |
LI_TGT_RECORDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
what record will insertions write to?
|
| 10 |
KEYNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Key Name
|
| 11 |
SEARCH_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Search Field
|