| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 2 |
TW_ACCOUNT_ID |
Character(35) |
VARCHAR2(35) NOT NULL |
Twilio Account ID
|
| 3 |
AUTHTOKEN |
Character(100) |
VARCHAR2(100) NOT NULL |
Authentication Domain
|
| 4 |
EX_TW_AUTH_TOKEN |
Character(254) |
VARCHAR2(254) NOT NULL |
Authorization Token
|
| 5 |
TW_ACCOUNT_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Twilio Account Name
|
| 6 |
DATE_FORMAT1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Date Format
D1=MMDDYYYY
D2=DDMMYYYY
D3=YYYYMMDD
Default Value: D1
|
| 7 |
DELIMITER |
Character(5) |
VARCHAR2(5) NOT NULL |
AUDIT LOG DELIMITER
|
| 8 |
ALLOW_ADV |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Advance
Y/N Table Edit
Default Value: Y
|
| 9 |
ALO_TXT_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Text Message
Y/N Table Edit
Default Value: N
|
| 10 |
BU_ADV_MAX_AMT |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Max Advance Amount for BU
|
| 11 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
Prompt Table:
DST_CNTL_HDR_VW
|
| 12 |
MIN_RCPT_AMT |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Minimum Receipt Amount
|
| 13 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 14 |
DB_NUMBER |
Character(9) |
VARCHAR2(9) NOT NULL |
DUNS Number
|
| 15 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 16 |
APPL_JRNL_ID_ACCR |
Character(10) |
VARCHAR2(10) NOT NULL |
Accruals
Prompt Table:
JRNLGEN_APPL_ID
|
| 17 |
APPL_JRNL_ID_PEACR |
Character(10) |
VARCHAR2(10) NOT NULL |
Period End Accruals
Prompt Table:
JRNLGEN_APPL_ID
|
| 18 |
APPL_JRNL_ID_CASH |
Character(10) |
VARCHAR2(10) NOT NULL |
Payments
Prompt Table:
JRNLGEN_APPL_ID
|
| 19 |
APPL_JRNL_ID_CLOSE |
Character(10) |
VARCHAR2(10) NOT NULL |
Closes
Prompt Table:
JRNLGEN_APPL_ID
|
| 20 |
APPL_JRNL_ID_VOID |
Character(10) |
VARCHAR2(10) NOT NULL |
Cancels
Prompt Table:
JRNLGEN_APPL_ID
|
| 21 |
VAT_NRCVR_PRO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Non-Recoverable VAT
Y/N Table Edit
Default Value: Y
|
| 22 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 23 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 24 |
DFLT_ADV_DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Default Doc Type
Prompt Table:
DOC_TYPE_A_VW
|
| 25 |
DFLT_SHT_DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Default Doc Type
Prompt Table:
DOC_TYPE_A_VW
|
| 26 |
DFLT_ADV_CLSDOCTYP |
Character(8) |
VARCHAR2(8) NOT NULL |
Default DOC Type
Prompt Table:
DOC_TYPE_A_VW
|
| 27 |
DFLT_SHT_CLSDOCTYP |
Character(8) |
VARCHAR2(8) NOT NULL |
Default Doc Type
Prompt Table:
DOC_TYPE_A_VW
|
| 28 |
DFLT_UNPOST_DOCTYP |
Character(8) |
VARCHAR2(8) NOT NULL |
Default DOC Type
Prompt Table:
DOC_TYPE_A_VW
|
| 29 |
GROSS_UP_EST_PCT |
Number(7,4) |
DECIMAL(6,4) NOT NULL |
Gross Up Percent
|
| 30 |
TIME_RPT_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Report Period
B=Biweekly
D=Daily
S=Semi-Monthly
W=Weekly
|
| 31 |
END_DAY_OF_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Ending Day of Period
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
Default Value: 6
|
| 32 |
HOURS_PER_DAY |
Number(3,0) |
SMALLINT NOT NULL |
Hours Per Day
Default Value: 8
|
| 33 |
AIR_TKT_GRACE_PRD |
Number(3,0) |
SMALLINT NOT NULL |
Airline Ticket Grace Period
Default Value: 90
|
| 34 |
ADVANCE_OVERDUE |
Number(3,0) |
SMALLINT NOT NULL |
Advance Overdue in days
Default Value: 90
|
| 35 |
CC_DATA_OVERDUE |
Number(3,0) |
SMALLINT NOT NULL |
Limit in days before an employee is notified
that they have overdue corporate card
transactions.
Default Value: 30
|
| 36 |
UPPER_LIMIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Upper Limit Threshold Action
R=Error
W=Warning
Default Value: W
|
| 37 |
LOWER_LIMIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Lower Limit Threshold Action
R=Error
W=Warning
Default Value: W
|
| 38 |
MAX_HRS_PER_PERIOD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Maximum Hours Per Period
|
| 39 |
MIN_HRS_PER_PERIOD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Minimum Hours Per Period
|
| 40 |
SHOW_DESCR_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Descriptions Option
D=Default :
N=Codes
Y=Descriptions
Default Value: N
|
| 41 |
TIME_RPT_LIMIT |
Number(3,0) |
SMALLINT NOT NULL |
Time Submission Grace Days
|
| 42 |
EXP_RPT_LIMIT |
Number(3,0) |
SMALLINT NOT NULL |
Expense Submission Grace Days
|
| 43 |
PER_DIEM_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Per Diem
Y/N Table Edit
Default Value: Y
|
| 44 |
AUTH_AMT_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Authorized Amounts
Y/N Table Edit
Default Value: N
|
| 45 |
VAT_RCRD_FRGN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Foreign VAT
Y/N Table Edit
|
| 46 |
VAT_NRCVR_ALL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Non-Recoverable VAT
Y/N Table Edit
Default Value: N
|
| 47 |
BU_EXP_MAX_AMT_PRE |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Prepayment Amount
|
| 48 |
BU_EXP_MAX_AMT_PST |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Post-Payment Amount
|
| 49 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
Default Value: G
|
| 50 |
OVERRIDE_DCAA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable DCAA
Y/N Table Edit
Default Value: N
|
| 51 |
FUTURE_ENTRY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable Future Entry
Y/N Table Edit
Default Value: Y
|
| 52 |
CUTOFF_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Cutoff Days
|
| 53 |
CUTOFF_TIME |
Time(15) |
TIMESTAMP |
The settlement cutoff time for a given bank/counterparty.
|
| 54 |
TIMEZONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
Prompt Table:
PSTIMEZONE
|
| 55 |
COMMENT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Comment Flag
1=Multiple GeoCodes
2=Invalid Postal Code
Y/N Table Edit
Default Value: Y
|
| 56 |
AMOUNT_THRESHOLD |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Monetary amount threshold.
|
| 57 |
TAUTH_VAR_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Percent variance from travel authorization.
|
| 58 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
CAL_DETL_VW
Set Control Field: BUSINESS_UNIT_GL
|
| 59 |
ETC_ENTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Entry of ETC
Y/N Table Edit
Default Value: N
|
| 60 |
TIME_GRID_DISPLAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to set with grid(s) display for time reports
B=Both Time Grids
C=Policy Time Grid Only
P=Project Time Grid Only
Default Value: B
|
| 61 |
EX_ACCRL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Unprocessed Expenses
Y/N Table Edit
Default Value: N
|
| 62 |
EX_WALLET_ACRL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Wallet Entries
Y/N Table Edit
Default Value: N
|
| 63 |
EX_KK_ACCRL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control for Accrual
Y/N Table Edit
Default Value: N
|
| 64 |
EX_ACCRL_BILL_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue for Billable Expenses
Y/N Table Edit
Default Value: N
|
| 65 |
AUTO_APPR_RISK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Approve Only if No Risk
Y/N Table Edit
Default Value: N
|
| 66 |
EX_TIME_TO_PC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Time to Projects When
H=Entire Timesheet is Approved
L=Timesheet Line is Approved
Default Value: H
|
| 67 |
P6_TIME_SEND_TO |
Character(2) |
VARCHAR2(2) NOT NULL |
Indicator that determines where timesheet data from Primavera will be sent to (either Expenses or Project Costing).
EX=Expenses
PC=Project Costing
Default Value: PC
|
| 68 |
OLDER_TRANS_RB |
Character(1) |
VARCHAR2(1) NOT NULL |
Older Transaction Radio Button
D=Disallow
E=Exception
Default Value: E
|
| 69 |
TXN_DAYS_RQD_COMMT |
Number(3,0) |
SMALLINT NOT NULL |
Days
Default Value: 0
|
| 70 |
EXCLUDE_CC_TXN |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipts Not Required
Y/N Table Edit
Default Value: N
|
| 71 |
EX_RCPT_REQ_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies whether an expense line requires a receipt or not for a particular combination of expense type and payment type.
C=No Except CC Feed
E=Yes Except CC Feed
N=Never
Y=Always
Default Value: Y
|
| 72 |
COMMENT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Comments Required
Y/N Table Edit
|
| 73 |
EE_NORCPT_COMMENT |
Character(60) |
VARCHAR2(60) NOT NULL |
No Receipt Comment
|
| 74 |
GRP_AMT_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Authorized Amounts for Expense Type Group
Y/N Table Edit
Default Value: N
|
| 75 |
GST_APPLICABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
GST Applicable
N=No
Y=Yes
|
| 76 |
ALLOW_CHN_EX_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow changes to expense type
Y/N Table Edit
Default Value: N
|
| 77 |
REQUIRED_REASON_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Require a reason code
Y/N Table Edit
Default Value: N
|
| 78 |
EX_GPS_CALCULATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Distance Calculator
Y/N Table Edit
Default Value: N
|
| 79 |
EX_REQ_GPS_CMNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Require Comments to Override
Y/N Table Edit
Default Value: N
|
| 80 |
EX_ROAD_PREF |
Character(1) |
VARCHAR2(1) NOT NULL |
Road preference
H=Highway
L=Local
Default Value: H
|
| 81 |
EX_ROUTE_PREF |
Character(1) |
VARCHAR2(1) NOT NULL |
Route preference
F=Fastest
S=Shortest
Default Value: F
|
| 82 |
EX_ENFORCE_RCPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enforce Receipt
Y/N Table Edit
Default Value: N
|
| 83 |
EX_NO_RCPT_REASON |
Character(10) |
VARCHAR2(10) NOT NULL |
No Receipt Reason
Prompt Table:
REASON_RCPT_VW
Set Control Field: BUSINESS_UNIT_GL
|
| 84 |
EX_MST_HDR_RCPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Header Receipt for All Lines
Y/N Table Edit
Default Value: N
|
| 85 |
EX_PYMNT_DEST2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether employee expenses reimbursement will be processed by Payroll or Accounts Payables.
A=Accounts Payable
B=Default from Business Unit
D=Default from Installation
P=Payroll
Default Value: D
|