CSH_FCST_INTG(SQL Table) |
Index Back |
|---|---|
Cash Forecast Integration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FCST_DATA_SOURCE |
Character(3) | VARCHAR2(3) NOT NULL | Identifies the origin of loaded forecast data. The forecast data source provides a means of selectively tracking, reporting, and inquiring on these entries. |
| 2 | VALUE_DT |
Date(10) | DATE | Equivalent to a deal transaction's settlement date. |
| 3 | REFERENCE |
Character(30) | VARCHAR2(30) NOT NULL | Field to show when a variable is a reference variable. |
| 4 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | BUSINESS_UNIT_BANK | Character(5) | VARCHAR2(5) NOT NULL | The general ledger business unit associated with a given bank/counterparty. |
| 8 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 9 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 10 | 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 |
| 11 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 12 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 13 | 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 |
| 14 | PYMNT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer |
| 15 | SOURCE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
AutoSource Status
A=Available C=Sourcing Complete E=Non-Price Error I=Sourcing In Process N=Non-Price Error P=Pricing Error |
| 16 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 17 | LOAD_DTTM | DateTime(26) | TIMESTAMP | Load Date and Time |
| 18 | GRP_BY_FIELD_1 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 19 | GRP_BY_FIELD_2 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 20 | GRP_BY_FIELD_3 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 21 | GRP_BY_FIELD_4 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 22 | GRP_BY_FIELD_5 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 23 | GRP_BY_FIELD_6 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 24 | GRP_BY_FIELD_7 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 25 | KEY_CHAR_40_01 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/01 |
| 26 | KEY_CHAR_40_02 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/02 |
| 27 | KEY_CHAR_40_03 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/03 |
| 28 | KEY_CHAR_40_04 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/04 |
| 29 | KEY_CHAR_40_05 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/05 |
| 30 | KEY_CHAR_40_06 | Character(40) | VARCHAR2(40) NOT NULL | Key_Char 40/06 |
| 31 | KEY_CHAR_40_07 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/07 |
| 32 | KEY_CHAR_40_08 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/08 |
| 33 | KEY_CHAR_40_09 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/09 |
| 34 | KEY_CHAR_40_10 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/10 |
| 35 | KEY_DATE_01 | Date(10) | DATE | Key Date 01 |
| 36 | KEY_DATE_02 | Date(10) | DATE | Key Date 02 |
| 37 | KEY_DATE_03 | Date(10) | DATE | Key Date 03 |
| 38 | KEY_DTTM_01 | DateTime(26) | TIMESTAMP | Key Date Time 01 |
| 39 | KEY_DTTM_02 | DateTime(26) | TIMESTAMP | Key Date Time 02 |
| 40 | KEY_NBR_01 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 41 | KEY_NBR_02 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 42 | KEY_NBR_03 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 43 | KEY_NBR_04 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 44 | KEY_NBR_05 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |