VCHR_SRCH_SVW(SQL View) |
Index Back |
|---|---|
Voucher Search ViewVoucher Search View |
| SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_DT , A.INVOICE_DT , %Substring(%Cast(A.INVOICE_DT, Date, Character), 1, 4) , %Substring(%Cast(A.INVOICE_DT, Date, Character), 9, 2) , %Substring(%Cast(A.INVOICE_DT, Date, Character), 6, 2) , %Substring(%Cast(A.INVOICE_DT, Date, Character), 6, 2) FROM PS_VOUCHER A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 4 | SES_DOCUMENT_DATE | Date(10) | DATE | Document Date |
| 5 | SES_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Document Date Hierarchy |
| 6 | SES_DAY | Character(2) | VARCHAR2(2) NOT NULL | Day |
| 7 | SES_MONTH | Character(2) | VARCHAR2(2) NOT NULL |
Month
01=01: January 02=02: February 03=03: March 04=04: April 05=05: May 06=06: June 07=07: July 08=08: August 09=09: September 10=10: October 11=11: November 12=12: December |
| 8 | SES_MONTH2 | Character(2) | VARCHAR2(2) NOT NULL |
Month
01=01: January 02=02: February 03=03: March 04=04: April 05=05: May 06=06: June 07=07: July 08=08: August 09=09: September 10=10: October 11=11: November 12=12: December |