| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
Default Value: %date
|
| 3 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 4 |
ELIMS_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
For Eliminations Only
Y/N Table Edit
Default Value: N
|
| 5 |
JRNL_BALANCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Balance Option
D=Default to Higher Level Value
K=Reject Out of Balance Journals
R=Recycle Out of Bal. Journals
S=Suspend Out of Bal. Journals
W=Accept With Warning Message
Default Value: R
|
| 6 |
JRNL_EDIT_ERR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Edit Errors Option
D=Default to Higher Level Value
K=Reject Journals w/ Edit Errors
R=Recycle Jrnls With Edit Errors
S=Suspend Errors/Accept Others
Default Value: R
|
| 7 |
JRNL_AMT_ERR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
A Journal Edit option to decide if accept, error or suspense a journal line when foreign amount and monetary amount are different sign (i.e. one positive and the other negative).
A=Accept
D=Defaut to a Higher Level Value
R=Recycle
S=Suspend
Default Value: R
|
| 8 |
CONTROL_TOTAL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Control Total Option
D=Default to Higher Level Value
K=Reject Exception Journals
N=Don't Care (No Controls)
R=Recycle Exception Journals
W=Accept With Warning Message
Default Value: R
|
| 9 |
CURRENCY_BAL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Balancing Option
A=Balance by All Currencies
B=Balance by Base Currency Only
D=Default to Higher Level Value
Default Value: A
|
| 10 |
BASE_CUR_ADJ_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Base Currency Adjust Option
D=Default to Higher Level Value
N=Disallow Base Curr Adjustments
Y=Allow Base Curr Adjustments
Default Value: Y
|
| 11 |
JRNL_FOREIGN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Foreign Currencies per Journal
D=Default to Higher Level Value
M=Multiple Foreign Currencies
N=No Foreign Currencies
O=Only One Foreign Currency
Default Value: M
|
| 12 |
JRNL_APPRVL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Approval Option
D=Default to Higher Level
P=Pre-Approved
S=Specify Approval Rule
Default Value: P
|
| 13 |
STL_APPROVALS |
Character(1) |
VARCHAR2(1) NOT NULL |
Settlement Approvals
|
| 14 |
STL_APPROV_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Method
1=Manual
2=Workflow
|
| 15 |
BD_JRNL_APPR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Journal Approval Optn
D=Default to Higher Level
P=Pre-Approved
S=Specify Approval Rule
Default Value: P
|
| 16 |
BUSPROCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
|
| 17 |
APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
|
| 18 |
BUSPROCNAME_BD |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name - Budget
|
| 19 |
APPR_RULE_SET_BD |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set - Budgets
|
| 20 |
DB_APPROPRIATION |
Character(6) |
VARCHAR2(6) NOT NULL |
DB(Memo Fund Balance)
|
| 21 |
DB_ALLOTMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
DB(Allotment Account)
|
| 22 |
DB_ORG_BUDGET |
Character(6) |
VARCHAR2(6) NOT NULL |
DB(Organization Budget)
|
| 23 |
DB_PROJ_GRANT |
Character(6) |
VARCHAR2(6) NOT NULL |
DB(Project/Grant Offset)
|
| 24 |
CR_REVENUE_EST |
Character(6) |
VARCHAR2(6) NOT NULL |
CR(Revenue Estimate Offset)
|
| 25 |
FUND_TRANSFER |
Character(1) |
VARCHAR2(1) NOT NULL |
Fund Transfers Allowed
Default Value: N
|
| 26 |
BUD_YEAR_TRANSFER |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Year Transfers Allowed
Default Value: N
|
| 27 |
TR_CONFIRM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable WF Auto Confo Worklist
Default Value: N
|
| 28 |
TR_CONFO_MAIL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable WF Invalid Confo Mail
Default Value: N
|
| 29 |
TR_PREAPPR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable WF Deal Preview
Default Value: N
|
| 30 |
TR_RVL_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Market Rate Index
|
| 31 |
TR_RVL_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Exchange Rate Type
|
| 32 |
TR_SCHD_POSN_CREAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto-Schedule Position Update
Default Value: N
|
| 33 |
TR_SCHD_RUN_CTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Position Update Run Control ID
|
| 34 |
TR_SCHD_RUNLOCN |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Location
0=Both
1=Client
2=Server
|
| 35 |
TR_SCHD_SERVERNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Server Name
|
| 36 |
TR_BX_APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 37 |
TRA_REVIEW_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Require Review
Default Value: N
|
| 38 |
INT_ENTITYCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Internal Entity Code
|
| 39 |
EXT_ENTITYCD |
Character(4) |
VARCHAR2(4) NOT NULL |
External Entity Code
|
| 40 |
PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Type or Method of payment. Indicator as to how the payment should be handled
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Customer Initiated Draft
CHK=System Check
DD=Direct Debit
DFT=Vendor Initiated Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire Flat File
WIR=Wire Report
|
| 41 |
DOC_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Sequencing
Y/N Table Edit
Default Value: N
|
| 42 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Document Type
L=Letter
N=Notice
O=Other
Q=Request
R=Report
|
| 43 |
VAT_INTERUNIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Payables InterUnit VAT
Y/N Table Edit
Default Value: N
|
| 44 |
VAT_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT calculation type.
E=Exclusive
I=Inclusive
N=Not Applicable
Default Value: I
|
| 45 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Transaction Type
|
| 46 |
VAT_TOL_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
VAT Tolerance Amount
|
| 47 |
VAT_TOL_CUR_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency
|
| 48 |
VAT_TOL_PCT |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
VAT Tolerance Percentage
|
| 49 |
VAT_TOL_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Rate Type
|
| 50 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
VAT code.
|
| 51 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
|
| 52 |
VAT_OVR_RCVRY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Override Recry/Rebate %
Default Value: N
|
| 53 |
VAT_NRCVR_PRO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate non recoverable VAT.
Default Value: N
|
| 54 |
VAT_CF_ANLSYS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Chartfield Analysis
|
| 55 |
VAT_APORT_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Apportionment Control
D=Distribution GL Business Unit
Default Value: D
|
| 56 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
|
| 57 |
POST_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Process Date Option
C=Current Date
Default Value: C
|
| 58 |
PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 59 |
LED_GRP_DEFAULT |
Character(10) |
VARCHAR2(10) NOT NULL |
Default Journal Generator Ledger Group of a Business Unit
|