AP_SEARCH_LIST(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSDBFIELD |
| 2 | LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL |
LABEL_ID identifies uniquness of DB Field Labels.
This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
Prompt Table: AP_FLD_LABEL_VW |
| 3 | AP_FROM_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
From Field
Prompt Table: PSDBFIELD |
| 4 | AP_TO_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
To Field
Prompt Table: PSDBFIELD |
| 5 | AP_VOUCHER_INQUIRY | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Inquiry
Y/N Table Edit Default Value: N |
| 6 | AP_VCHR_ACCTG_INQ | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Accounting Inquiry
Y/N Table Edit Default Value: N |
| 7 | AP_VENDOR_AGING | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Aging Inquiry
Y/N Table Edit Default Value: N |
| 8 | AP_VENDOR_BAL | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Balance Inquiry
Y/N Table Edit Default Value: N |
| 9 | AP_VNDR_SCHD_PYMNT | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Sched Payments Inq
Y/N Table Edit Default Value: N |
| 10 | AP_PAYMENT_INQUIRY | Character(1) | VARCHAR2(1) NOT NULL |
Payment Inquiry
Y/N Table Edit Default Value: N |
| 11 | AP_DRAFT_INQUIRY | Character(1) | VARCHAR2(1) NOT NULL |
Draft Inquiry
Y/N Table Edit Default Value: N |