INSTALLATION_EX(SQL Table) |
Index Back |
|---|---|
Installation Options - ExpenseInstallation Options - Expense |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSDBFIELD |
| 2 | DISTANCE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Distance Type
3=Metres K=Kilometers M=Miles Default Value: M |
| 3 | COMBO_EDIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Edit Combinations
Y/N Table Edit Default Value: Y |
| 4 | TA_ID_LAST_USED | Number(10,0) | DECIMAL(10) NOT NULL | Last Travel Auth ID Assigned. |
| 5 | SHEET_ID_LAST_USED | Number(10,0) | DECIMAL(10) NOT NULL | Last Report ID Used |
| 6 | ADV_ID_LAST_USED | Number(10,0) | DECIMAL(10) NOT NULL | Last Advance ID |
| 7 | TMSHT_ID_LAST_USED | Number(10,0) | DECIMAL(10) NOT NULL | Last Time Sheet ID Assigned |
| 8 | LAST_WALLET_DOC_ID | Number(10,0) | DECIMAL(10) NOT NULL | Last My Wallet Doc Id |
| 9 | ENABLE_WORKFLW_FLG | Character(1) | VARCHAR2(1) NOT NULL |
WorkFlow Enabled
Y/N Table Edit Default Value: N |
| 10 | ALLOW_OVERAGE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Per Diem Overage
Y/N Table Edit Default Value: N |
| 11 | BANK_ID_QUAL | Character(3) | VARCHAR2(3) NOT NULL |
"A bank/counterparty attribute that determines
Default Value: 001 Prompt Table: BNK_ID_QUAL_TBL |
| 12 | PYMNT_METHOD_EX | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House CHK=System Check EFT=Electronic Funds Transfer GE=Giro - EFT Default Value: CHK |
| 13 | EX_RCPT_BARCD_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
This field is used on the Expenses Installation Options Panel to indicate which Barcode scanning option the customer desires to use.
N=Preprinted Envelopes not used P=Preprinted Envelopes used X=Scanning not enabled Default Value: X |
| 14 | EX_PYMNT_DEST | Character(1) | VARCHAR2(1) NOT NULL |
Determines whether employee expenses reimbursement will be processed by Payroll or Accounts Payables.
A=Accounts Payable P=Payroll Default Value: A |
| 15 | APPROVAL_OPTN_PROJ | Character(1) | VARCHAR2(1) NOT NULL |
Option to allow the user to select how they would like to route their expense transactions for projects approval - defaulting to the HR manager or to the Project basing the approver on the amount rules.
P=Project Manager S=HR Manager - Supervisor Default Value: P |
| 16 | RCPT_IMG_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Imaging or Attachments
A=Attachments Only B=Both Imaging and Attachments N=No Imaging/Attachments R=Receipt Imaging Only Default Value: A |
| 17 | EX_BARCODE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Barcode Method
F=Font Installed on Desktop N=No Barcoding Default Value: N |
| 18 | EX_TRAN_CD | Character(8) | VARCHAR2(8) NOT NULL |
Expense Transaction Code
Prompt Table: IU_SYS_TR_EX_VW |
| 19 | ADV_TRAN_CD | Character(8) | VARCHAR2(8) NOT NULL |
Advance Transaction Code
Prompt Table: IU_SYS_TR_EX_VW |
| 20 | DCAA_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
DCAA Enabled
Y/N Table Edit Default Value: N |
| 21 | APPROVAL_HR | Character(1) | VARCHAR2(1) NOT NULL |
Route to HR Manager.
Default Value: N |
| 22 | APPROVAL_LIST | Character(1) | VARCHAR2(1) NOT NULL |
Route to an approver list
Default Value: N |
| 23 | APPROVAL_PROJ_LIST | Character(1) | VARCHAR2(1) NOT NULL |
Route to project approval list.
Default Value: N |
| 24 | ONE_STEP_STAGE | Character(1) | VARCHAR2(1) NOT NULL |
One Step Project Staging
Y/N Table Edit Default Value: N |
| 25 | TV | Character(1) | VARCHAR2(1) NOT NULL |
Use Travel Services
Y/N Table Edit Default Value: N |
| 26 | ENABLE_EMAIL_APPR | Character(1) | VARCHAR2(1) NOT NULL |
Enable Email Approvals
Y/N Table Edit Default Value: N |
| 27 | URG_ER_LOW_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency ER Low From
Default Value: 0 |
| 28 | URG_ER_LOW_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency ER Low To
Default Value: 0 |
| 29 | URG_ER_MED_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency ER Med From
Default Value: 0 |
| 30 | URG_ER_MED_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency ER Med To
Default Value: 0 |
| 31 | URG_ER_HI_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency ER High From
Default Value: 0 |
| 32 | URG_ER_HI_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency ER High To
Default Value: 0 |
| 33 | URG_TA_LOW_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency TA Low From
Default Value: 0 |
| 34 | URG_TA_LOW_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency TA Low To
Default Value: 0 |
| 35 | URG_TA_MED_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency TA Med From
Default Value: 0 |
| 36 | URG_TA_MED_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency TA Med To
Default Value: 0 |
| 37 | URG_TA_HI_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency TA High From
Default Value: 0 |
| 38 | URG_TA_HI_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency TA High To
Default Value: 0 |
| 39 | URG_CA_LOW_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency CA Low From
Default Value: 0 |
| 40 | URG_CA_LOW_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency CA Low To
Default Value: 0 |
| 41 | URG_CA_MED_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency CA Med From
Default Value: 0 |
| 42 | URG_CA_MED_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency CA Med To
Default Value: 0 |
| 43 | URG_CA_HI_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency CA High From
Default Value: 0 |
| 44 | URG_CA_HI_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency CA High To
Default Value: 0 |
| 45 | URG_TR_LOW_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency TR Low From
Default Value: 0 |
| 46 | URG_TR_LOW_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency TR Low To
Default Value: 0 |
| 47 | URG_TR_MED_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency TR Med From
Default Value: 0 |
| 48 | URG_TR_MED_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency TR Med To
Default Value: 0 |
| 49 | URG_TR_HI_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency TR High From
Default Value: 0 |
| 50 | URG_TR_HI_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency TR High To
Default Value: 0 |
| 51 | URG_TJ_LOW_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency TJ Low From
Default Value: 0 |
| 52 | URG_TJ_LOW_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency TJ Low To
Default Value: 0 |
| 53 | URG_TJ_MED_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency TJ Med From
Default Value: 0 |
| 54 | URG_TJ_MED_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency TJ Med To
Default Value: 0 |
| 55 | URG_TJ_HI_FROM | Number(3,0) | SMALLINT NOT NULL |
Urgency TJ High From
Default Value: 0 |
| 56 | URG_TJ_HI_TO | Number(3,0) | SMALLINT NOT NULL |
Urgency TJ High To
Default Value: 0 |
| 57 | ADVANCE_PURCHASE | Number(3,0) | SMALLINT NOT NULL |
Advance Purchase
Default Value: 0 |
| 58 | INCLUDE_CC_MAINT | Character(1) | VARCHAR2(1) NOT NULL |
Include Account Maintenance
Y/N Table Edit Default Value: N |
| 59 | UPD_CC_PROF | Character(1) | VARCHAR2(1) NOT NULL |
Update Profile for New Account
Y/N Table Edit Default Value: N |
| 60 | ATTACH_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Attachment Location
B=Header and Line H=Header Level L=Line Level N=No Attachments Allowed Default Value: N |
| 61 | EX_TYPE_CAT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Expense Type Category
0=Inactive Expense Type Category 1=Active Expense Type Category Default Value: 0 |
| 62 | EX_XPRESS_ER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Sets Expenses Installation Options to 'Yes' when Express Expense Report feature is installed.
Y/N Table Edit Default Value: N |
| 63 | EX_CBT_CARD_LIMIT | Number(3,0) | SMALLINT NOT NULL |
Chatbot Card Display Limit
Default Value: 10 |
| 64 | MULTI_VENDOR_CC | Character(1) | VARCHAR2(1) NOT NULL |
Credit Card Multiple Vendor
Y/N Table Edit Default Value: Y |
| 65 | EX_REVIEWED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Reviewed
Y/N Table Edit Default Value: N |
| 66 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 67 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 68 | EX_PROMPT_DOC | Character(1) | VARCHAR2(1) NOT NULL |
Prompt When Creating Document
Y/N Table Edit Default Value: N |
| 69 | EX_NOTIFY_DOC | Character(1) | VARCHAR2(1) NOT NULL |
Notify When Creating Document
Y/N Table Edit Default Value: N |