EX_TR_ROLEVT_VW(SQL View) |
Index Back |
|---|---|
VAT RoleUsed by Mobile Time & Expense 8.8 |
| SELECT B.BUSINESS_UNIT_GL , A.EX_ROLE , A.EFFDT , A.COUNTRY_OPT , A.STATE_OPT , A.VAT_RECEIPT_OPT , A.VAT_ENTRD_AMT_OPT , A.VATAUTOCALCFLG_OPT FROM PS_EX_ROLE_EXCP_VT A , PS_BUS_UNIT_TBL_EX B , PS_SET_CNTRL_REC C WHERE C.RECNAME = 'EX_ROLE_EXCP_VT' AND C.SETCNTRLVALUE = B.BUSINESS_UNIT_GL AND C.SETID = A.SETID AND A.EFF_STATUS = 'A' |
| # | 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 | EX_ROLE |
Character(5) | VARCHAR2(5) NOT NULL | Expense Processing Role |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | COUNTRY_OPT | Character(1) | VARCHAR2(1) NOT NULL |
VAT Country
D=Display Only E=Editable I=Invisible |
| 5 | STATE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
VAT State
D=Display Only E=Editable I=Invisible |
| 6 | VAT_RECEIPT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
No VAT Receipt Flag
D=Display Only E=Editable I=Invisible |
| 7 | VAT_ENTRD_AMT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
VAT Entered Amount
D=Display Only E=Editable I=Invisible |
| 8 | VATAUTOCALCFLG_OPT | Character(1) | VARCHAR2(1) NOT NULL |
VAT Auto Calc Flag
D=Display Only E=Editable I=Invisible |