BUS_UNIT_OPT_EX

(SQL Table)
Index Back

Expenses Business Unit Options

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 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

3 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
4 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

Prompt Table: EX_PYFRM_BNK_VW

5 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

Prompt Table: EX_PYFRM_ACC_VW

6 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
7 POST_APPRVL_ACTN Character(1) VARCHAR2(1) NOT NULL Post approval action (next transaction, return to list, or remain on current transaction).
C=View Current Transaction
L=Return to List
N=Proceed to Next Transaction

Default Value: N

8 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
9 ACCOUNTING_DT_IND Character(1) VARCHAR2(1) NOT NULL Accounting Date Indicator
C=Use Current Date
D=Business Unit Default
P=Use Payment Date
S=Use Specific Date

Default Value: C

10 ENFORCE_BGTCHK_EX Character(1) VARCHAR2(1) NOT NULL Require budget checking prior to approval for expense reports

Default Value: N

11 ENFORCE_BGTCHK_TA Character(1) VARCHAR2(1) NOT NULL Require budget checking prior to approval for travel authorizations.

Default Value: N