PW_APPLIST_FLDS (SQL Table)	Index Back
Application Price List Fields This table will store the priority number for the price list key fieldnames. It will be used by the pricing engine for price list lookup priority.

PW_APPLIST_FLDS

(SQL Table)

Application Price List Fields

This table will store the priority number for the price list key fieldnames. It will be used by the pricing engine for price list lookup priority.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PW_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

2 PW_KEY_FLD_CD Character(3) VARCHAR2(3) NOT NULL Key field code

3 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PW_APP_CD	Character(4)	VARCHAR2(4) NOT NULL	Transaction Code
2	PW_KEY_FLD_CD	Character(3)	VARCHAR2(3) NOT NULL	Key field code
3	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority