PeopleSoft 9
Account Payables

Table Name SDN_INQ_FLDS

Table Description
SDN_INQ_FLDS
Columns
Name Datatype Is PK Is FK
OPRID VARCHAR(30) Yes Yes
SRCH_CONFIG_ID VARCHAR(20) Yes Yes
SRCH_CRITERIA VARCHAR(30) Yes Yes
SEQ_NUM SMALLINT Yes No
ACTIVE_FLAG VARCHAR(1) No No
FIELDNAME VARCHAR(18) No No
SRCH_OPERATOR VARCHAR(4) No No
FROM_MIXED_NP VARCHAR(50) No No
FROM_MIXED_P VARCHAR(50) No No
FROM_UPPER_NP VARCHAR(50) No No
FROM_UPPER_P VARCHAR(50) No No
DATE_FROM datetime No No
DATE_TO datetime No No
FROM_AMOUNT DECIMAL(26,3) No No
TO_AMOUNT DECIMAL(26,3) No No
VALUE_XLAT VARCHAR(4) No No
IN_LIST_STRING VARCHAR(254) No No
TO_MIXED_NP VARCHAR(50) No No
TO_MIXED_P VARCHAR(50) No No
TO_UPPER_NP VARCHAR(50) No No
TO_UPPER_P VARCHAR(50) No No
TO_NUMBER_P DECIMAL(15) No No
TO_NUMBER_NP DECIMAL(15) No No
FROM_NUMBER_P DECIMAL(15) No No
FROM_NUMBER_NP DECIMAL(15) No No
Index
Name Type Unique Member
PS_SDN_INQ_FLDS PK Yes
Member(s) of "PS_SDN_INQ_FLDS" Index
OPRID
SRCH_CONFIG_ID
SRCH_CRITERIA
SEQ_NUM

Published June 06, 2007