CSH_FCST_AET

(SQL Table)
Index Back

Cash Forecast Import

# 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).

Default Value: OPRID_VW.OPRID

Prompt Table: OPRID_VW

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 IMPORT_OBJECT Character(2) VARCHAR2(2) NOT NULL Import Object
10=Bank Statement
20=Payment Acknowledgement
30=Payment Import
40=Investment Pools Import
50=Stock Quote Import
60=Security Market Value Import
70=Security Definition Import
80=Sanctions List Import
90=Cash Forecast Import
6 FILE_LOCATION Character(254) VARCHAR2(254) NOT NULL File Location
7 FILE_PATH_NAME Character(254) VARCHAR2(254) NOT NULL File Path
8 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name

Prompt Table: BSP_IMPORT

9 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID
10 GROUP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
11 FCST_RELOAD Character(1) VARCHAR2(1) NOT NULL Determines whether to override existing data while importing Cash Forecast Data
12 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13 EVENT_TRACKING_ID Number(10,0) DECIMAL(10) NOT NULL The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
14 LOAD_SW Character(1) VARCHAR2(1) NOT NULL Load Switch
15 AE_APPSTATUS Number(1,0) SMALLINT NOT NULL AE Application Warning Status
16 IMPORT_RQST_TYPE Character(2) VARCHAR2(2) NOT NULL Type of import used to obtain the file. (i.e. File, FTP or HTTP)
01=File
02=FTP
03=HTTP
17 BANKNODE Character(30) VARCHAR2(30) NOT NULL Bank Node
18 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
19 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
20 IBAN_ID Character(34) VARCHAR2(34) NOT NULL IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders
21 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
22 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
23 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank