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 |