BUSINESS_UNIT_GLPrompt Table: SP_BU_GL_NONVW
COUNTRYSHEET_IDEX_SHHDRFRGN_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT a.BUSINESS_UNIT_GL , b.COUNTRY , a.SHEET_ID , a.EMPLID , b.CURRENCY_CD , a.SHEET_NAME FROM PS_EX_SHEET_HDR a , PS_EX_SHEET_LINE b WHERE a.SHEET_ID=b.SHEET_ID AND b.VAT_TREATMENT IN ('FGE','FSE') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | SHEET_NAME | Character(30) | VARCHAR2(30) NOT NULL | Report Description |