PMT_RULE_FIELD (SQL Table)	Index Back
Payment Rule Field Tie fields to rules.

PMT_RULE_FIELD

(SQL Table)

Payment Rule Field

Tie fields to rules.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PMT_RULE_FIELD_ID Character(18) VARCHAR2(18) NOT NULL Unique identifier for a field referenced in a rule.

2 PMT_SECURITY_TYPE Character(1) VARCHAR2(1) NOT NULL Xlat for security types.
S=Security
V=Validation

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_SUPPLIER_EC
06=ITM_SUPP_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
13=EN_REVISION_EC
14=ITEM_MFG_GPO_EC
15=ITEM_MFG_EC
16=ITEM_CAT_EC

4 FIELD_TYPE Character(1) VARCHAR2(1) NOT NULL Type
C=Character
D=Date
N=Numeric

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PMT_RULE_FIELD_ID	Character(18)	VARCHAR2(18) NOT NULL	Unique identifier for a field referenced in a rule.
2	PMT_SECURITY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Xlat for security types. S=Security V=Validation
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_SUPPLIER_EC 06=ITM_SUPP_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 13=EN_REVISION_EC 14=ITEM_MFG_GPO_EC 15=ITEM_MFG_EC 16=ITEM_CAT_EC
4	FIELD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type C=Character D=Date N=Numeric