| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BO_REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Financial Structure Request ID
|
| 2 |
BO_REQ_DTL_NO |
Number(3,0) |
SMALLINT NOT NULL |
Financial Structure Request Detail ID
|
| 3 |
IMPACT_ANL_SRCE |
Character(4) |
VARCHAR2(4) NOT NULL |
Impact Analysis Source Identifier
0001=AltAcct Mapping
0002=Account Mapping
0003=SpeedType
0004=SpeedChart
0005=Accounting Tag
0006=AP Accounting Template
0007=TR Accounting Template
0008=TR Substitution Rule
0009=InterUnit Template
0010=IntraUnit Template
0011=InterUnit Pair
0012=ChartField Value Set
0013=Combination Rule
0014=MultiCurrency Step
0015=Translation Rule
0016=Allocation Step
0017=Equitization Rule
0018=Elimination Set
0019=Closing Rule
0020=ChartField Security Rule
0021=Distribution Code
0022=External Bank Account
0023=Expense Amortization
0024=Tree Flattener
|
| 4 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 5 |
IMPACT_ANL_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Impact Analysis Type Identifier describes how the source is impacted by the Financial Structure Request
01=Mapped ChartField
02=Wildcard
03=ChartField in Range
04=Tree
05=Stale Tree Flatten Data
|
| 6 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 7 |
FLDVALUE1 |
Character(30) |
VARCHAR2(30) NOT NULL |
FldVal
|
| 8 |
FLDVALUE2 |
Character(30) |
VARCHAR2(30) NOT NULL |
FldVal
|
| 9 |
FLDVALUE3 |
Character(30) |
VARCHAR2(30) NOT NULL |
FldVal
|
| 10 |
FLDVALUE4 |
Character(30) |
VARCHAR2(30) NOT NULL |
FldVal
|
| 11 |
FLDVALUE5 |
Character(30) |
VARCHAR2(30) NOT NULL |
FldVal
|
| 12 |
FLDNUMVAL1 |
Number(20,0) |
DECIMAL(20) NOT NULL |
Fld Num1
|
| 13 |
DATEVAL1 |
Date(10) |
DATE |
DateVal1
|
| 14 |
CF_TAB_SRCE |
Character(2) |
VARCHAR2(2) NOT NULL |
ChartField Tab Source Identifier. For example. Chartfields are defined on various tabs on the MultiCurrency Step component - Source, Target and Gain/Loss.
B=Basis
E=Set
EC=Elimination Set-Credit
ED=Elimination Set-Debit
EL=Elimination Lines
G=Gain
L=Loss
ME=Minority Int-Expense
ML=Minority Int-Liability
N=Line
O=Offset
OC=Offset ChartFields
P=Pool
RE=Retained Earnings
S=Source
SO=Subsid Offset-Offset
SS=Subsid Offset-Summary
T=Target
TI=Target-Investment
TO=Target-Offset
|
| 15 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 16 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 17 |
DTTM_STAMP_SEC |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|