| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
CALENDAR_ID_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Calendar ID
A=Annually
M=Monthly
Q=Quarterly
Default Value: M
|
| 3 |
YEAR_FROM |
Character(4) |
VARCHAR2(4) NOT NULL |
From Year
1=NONE
|
| 4 |
PERIOD_FROM_AP |
Character(2) |
VARCHAR2(2) NOT NULL |
From Period
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
Q1=1st Quarter
Q2=2nd Quarter
Q3=3rd Quarter
Q4=4th Quarter
Default Value: 01
|
| 5 |
YEAR_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
To Year
1=NONE
|
| 6 |
PERIOD_TO_AP |
Character(2) |
VARCHAR2(2) NOT NULL |
To Period
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
Q1=1st Quarter
Q2=2nd Quarter
Q3=3rd Quarter
Q4=4th Quarter
Default Value: 01
|
| 7 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Display Currency
Prompt Table:
CURR_TXN_VW
|
| 8 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_AP_NONVW
|