FAI_MANCHG_AET

(SQL Table)
Index Back

3rd Party Integration Edit

# 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 FAI_TRANSACTION_ID Character(10) VARCHAR2(10) NOT NULL FAI Transaction ID
3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
5 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number

Default Value: 1

6 EXIST Character(1) VARCHAR2(1) NOT NULL Exist
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

9 EXT_SYSTEM_ID Character(10) VARCHAR2(10) NOT NULL External System ID

Prompt Table: FAI_EXTSYS_TBL

10 SQL_TEXT_LONG Long Character(4000) CLOB Dynamic SQL string
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
12 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
13 ACTION_FLG Character(1) VARCHAR2(1) NOT NULL Action Flag
A=Action