FS_COMBO_AET

(SQL Table)
Index Back

Combo Edit State Record

Combo Edit State Record

# 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