FUSPSJRNLTR_AET

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
7 FUS_LEDGER_NAME Character(30) VARCHAR2(30) NOT NULL Fusion Ledger Name
8 COA_MAPPING_NAME Character(33) VARCHAR2(33) NOT NULL Fusion COA Mapping Name
9 TRANSFER_ID Number(18,0) DECIMAL(18) NOT NULL Transfer ID
10 REPRCS_RETRNSFER Character(1) VARCHAR2(1) NOT NULL Reprocess / ReTransfer Process
N=No
Y=Yes
11 FUS_STATUS_CODE Character(30) VARCHAR2(30) NOT NULL Status Code
12 CUT_OFF_DATE Date(10) DATE Cut Off Date
13 LOAD_INITIAL_BAL Character(1) VARCHAR2(1) NOT NULL Load Initial Balances
N=No
Y=Yes
14 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
15 ACCOUNTING_DATE Date(10) DATE ACCOUNTING_DATE
16 TRANSFER_ID1 Number(18,0) DECIMAL(18) NOT NULL Transfer ID
17 SEGMENT1 Character(25) VARCHAR2(25) NOT NULL SEGMENT1
18 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
19 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
20 SEQ_NO Number(15,0) DECIMAL(15) NOT NULL Sequence Number
21 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
22 SYSTEM_ID Number(18,0) DECIMAL(18) NOT NULL Peoplesoft System ID
23 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
24 EXISTS_FLAG Character(1) VARCHAR2(1) NOT NULL Exists Flag - Indicates presence in Asset Repository
D=Duplicate
Y=Exists in ARM
25 SQL_SET_003 Long Character(2000) VARCHAR2(2000) SQL_SET_003