| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 3 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 4 |
COMBO_EDIT_TMPL |
Character(10) |
VARCHAR2(10) NOT NULL |
Record Template
|
| 5 |
RECNAME_HEADER |
Character(15) |
VARCHAR2(15) NOT NULL |
Header Record
|
| 6 |
RECNAME_LINE |
Character(15) |
VARCHAR2(15) NOT NULL |
Line Record
|
| 7 |
RECNAME_LN_ERRLOG |
Character(15) |
VARCHAR2(15) NOT NULL |
Line Error Log
|
| 8 |
FIELDNAME_BU_GL |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit GL Field Name
|
| 9 |
FIELDNAME_TRN_DATE |
Character(18) |
VARCHAR2(18) NOT NULL |
Transaction Date
|
| 10 |
TSE_LOG_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
TSE Field Log Record Name
|
| 11 |
INSERT_TSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Insert TSE Flag
Default Value: N
|
| 12 |
RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Code
0=Return OK
1=Return error
|
| 13 |
EDIT_ERRORS |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Errors
|
| 14 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
|
| 15 |
RUN_ONLINE_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Process run in online mode or not
Y/N Table Edit
Default Value: N
|
| 16 |
PC_EDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Flag to indicate if Combo Edit should call PC_EDIT module
|
| 17 |
MAP_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Map Option
B=PS/BI
C=PS/PC
E=PS/EXP
G=PS/GL
H=PS/HR
I=PS/IN
M=PS/AM
N=PS/CA
P=PS/AP
R=PS/AR
T=PS/TR
U=PS/PO
X=PS/GM
|
| 18 |
COMBO_TRAN_SRC |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Sources used by GL Combo Edit processing
AMT=Asset Management Transaction
APA=Payables Accounting Line
ARI=Account Receivables Item
BDJ=Commitment Control Bud Journal
BIA=Billing Accounting Line
CAA=Contracts Accounting Line
CMA=Cost Management Accounting
CSC=Campus Solutions CR Accounting
CSF=Campus Solutions SF Accounting
EXP=Expenses
GLJ=General Ledger Journal
GMA=Grants Accounting Line
HCM=Human Capital Management
INV=Inventory
MMG=Manufacturing
PCA=Project Accounting Line
PCI=Project Resource Interface
PCP=Project Pricing
POA=Purchasing Accounting Line
POP=Purchasing ProCard Transaction
POR=Purchasing Requisition
REA=Real Estate Accounting Line
TRA=Treasury Accounting Line
WMT=Work Order Management Trans
|
| 19 |
RTBL_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
RTBL Mode
Y/N Table Edit
Default Value: N
|
| 20 |
RTBL_COMBO_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
RTBL Combination Edit Flag
Y/N Table Edit
Default Value: N
|
| 21 |
USE_GTT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Global Temp Table Flag
Y/N Table Edit
Default Value: N
|