BUS_UNIT_OPT_EX(SQL Table) |
Index Back |
|---|---|
Expenses Business Unit Options |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |