| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
EX_ROLE |
Character(5) |
VARCHAR2(5) NOT NULL |
Expense Processing Role
Prompt Table:
EX_ROLE_TBL
Set Control Field: SETID
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
COUNTRY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Country
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 6 |
STATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT State
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 7 |
VAT_RECEIPT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
No VAT Receipt Flag
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 8 |
VAT_ENTRD_AMT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Entered Amount
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 9 |
VATNRCVRPROFLG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Non-Recoverable VAT
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 10 |
VATNRCVRALLFLG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Non-Recoverable VAT
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 11 |
TAX_CD_VAT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Value Added Tax Code
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 12 |
TAX_CD_VAT_PCT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Code Percent
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 13 |
VATTREATMENTEX_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Treatment
D=Display Only
E=Editable
I=Invisible
Default Value: D
|
| 14 |
VAT_TXNTYPE_CD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Transaction Type
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 15 |
VATRECOVERYPCT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Recovery Percent
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 16 |
VAT_REBATE_PCT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Rebate Percent
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 17 |
VAT_ROUND_RULE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Rounding Rule
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 18 |
VAT_APPLCBLTY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Applicability
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 19 |
VAT_USE_ID_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Use Type
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 20 |
VAT_RECLAIMPCT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reclaim Percent
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 21 |
VAT_NONTX_AMT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Non-Taxable Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 22 |
VATNONTXAMTBSE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Base Non-Taxable Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 23 |
VAT_AMT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Total VAT Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 24 |
VAT_AMT_BSE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Base Total VAT Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 25 |
VATAUTOCALCFLG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Auto Calc Flag
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 26 |
VAT_BASIS_AMT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Basis Amount
D=Display Only
E=Editable
I=Invisible
Default Value: D
|
| 27 |
VATBASISAMTBSE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Base VAT Basis Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 28 |
VAT_CALC_AMT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Calculated Amount
D=Display Only
E=Editable
I=Invisible
Default Value: D
|
| 29 |
VATCALCAMTBSE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Base VAT Calculated Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 30 |
VAT_RCVRY_AMT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Recovery Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 31 |
VATRCVRYAMTBSE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Base VAT Recovery Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 32 |
VAT_REBATE_AMT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Rebate Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 33 |
VATREBTEAMTBSE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Base VAT Rebate Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 34 |
VAT_TRANS_AMT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Transaction Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 35 |
VATTRANSAMTBSE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Base VAT Transaction Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 36 |
VAT_RCLMAMTBSE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Base VAT Reclaimable Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 37 |
VAT_RCLM_AMT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reclaim Amount
D=Display Only
E=Editable
I=Invisible
Default Value: I
|
| 38 |
VAT_APORTCNTRL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Apportionment Control
D=Display Only
E=Editable
I=Invisible
Default Value: E
|
| 39 |
VATRCVRYPCTSRC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Recovery Percent Source
D=Display
E=Editable
I=Invisible
Default Value: E
|
| 40 |
VAT_RBTEPCTSRC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Rebate Percent Source
D=Display
E=Editable
I=Invisible
Default Value: E
|
| 41 |
VAT_DISPLAY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Display VAT Hyperlink
Y/N Table Edit
Default Value: Y
|