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 |