FS_COMBO_AET(SQL Table) |
Index Back |
---|---|
Combo Edit State RecordCombo 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 |