TR_FCST_DUP_AET(SQL Table) |
Index Back |
|---|---|
Cash Forecast Duplicate AETCash Forecast Duplicate AET state record to sequence duplicate detail records. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | WORKSHEET_ID | Character(20) | VARCHAR2(20) NOT NULL | Cash Flows Worksheet ID |
| 4 | LINE_ITEM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Line Item Type categorizes worksheet line items into cash flow items, non-cash flow items and totals.
1=Cash 2=Non-Cash |
| 5 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 6 | WRKSHEET_LINE_ITEM | Character(30) | VARCHAR2(30) NOT NULL | Cash Forecast Worksheet Line item |
| 7 | SOURCE_SET | Character(20) | VARCHAR2(20) NOT NULL | A field name describing a group od position sources. |
| 8 | POS_SOURCE_ID | Character(18) | VARCHAR2(18) NOT NULL | "A unique key identifier that represents a position source dataset |
| 9 | VALUE_DT | Date(10) | DATE NOT NULL | Equivalent to a deal transaction's settlement date. |
| 10 | CALC_DT | Date(10) | DATE NOT NULL | The calculation date for a given data set within the Position tools. |
| 11 | REFERENCE | Character(30) | VARCHAR2(30) NOT NULL | Field to show when a variable is a reference variable. |
| 12 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 13 | CALC_TM | Time(15) | TIMESTAMP | The calculation time for a given data set within the Position tools. |
| 14 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 15 | OVERRIDE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Override amount |
| 16 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 17 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 18 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 19 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 20 | POS_IMPCT_ORIG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the calculated monetary value for a specific position tree node; the result |
| 21 | POS_IMPCT_WEIGHT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pos Impact Weight Amt Value |
| 22 | POS_IMPCT_WEIGHT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pos Impact Weight Amt Value |
| 23 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |
| 24 | WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilisation totals |
| 25 | DTL_LINE_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the origin of a cash forecast detail line. The detail line source provides a means of distinguishing between lines generated by the Cash Forecast engine and manually entered override detail lines.
O=Manual Override Detail S=Source Detail |
| 26 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 27 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 28 | 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 |
| 29 | BUSINESS_UNIT_BANK | Character(5) | VARCHAR2(5) NOT NULL | The general ledger business unit associated with a given bank/counterparty. |
| 30 | GRP_BY_FIELD_1 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 31 | GRP_BY_FIELD_2 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 32 | GRP_BY_FIELD_3 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 33 | GRP_BY_FIELD_4 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 34 | GRP_BY_FIELD_5 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 35 | GRP_BY_FIELD_6 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 36 | GRP_BY_FIELD_7 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 37 | KEY_CHAR_40_01 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/01 |
| 38 | KEY_CHAR_40_02 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/02 |
| 39 | KEY_CHAR_40_03 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/03 |
| 40 | KEY_CHAR_40_04 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/04 |
| 41 | KEY_CHAR_40_05 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/05 |
| 42 | KEY_CHAR_40_06 | Character(40) | VARCHAR2(40) NOT NULL | Key_Char 40/06 |
| 43 | KEY_CHAR_40_07 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/07 |
| 44 | KEY_CHAR_40_08 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/08 |
| 45 | KEY_CHAR_40_09 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/09 |
| 46 | KEY_CHAR_40_10 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/10 |
| 47 | KEY_DATE_01 | Date(10) | DATE | Key Date 01 |
| 48 | KEY_DATE_02 | Date(10) | DATE | Key Date 02 |
| 49 | KEY_DATE_03 | Date(10) | DATE | Key Date 03 |
| 50 | KEY_DTTM_01 | DateTime(26) | TIMESTAMP | Key Date Time 01 |
| 51 | KEY_DTTM_02 | DateTime(26) | TIMESTAMP | Key Date Time 02 |
| 52 | KEY_NBR_01 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 53 | KEY_NBR_02 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 54 | KEY_NBR_03 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 55 | KEY_NBR_04 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 56 | KEY_NBR_05 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 57 | 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 |
| 58 | TGTFLD_NUM_12_4 | Number(17,4) | DECIMAL(16,4) NOT NULL | Target Field - Number, Integer Positions 20 |
| 59 | TGTFLD_NUM_20 | Number(20,0) | DECIMAL(20) NOT NULL | Target Field - Number, Integer Positions 20 |
| 60 | TGTFLD_SIGN_12_4 | Signed Number(18,4) | DECIMAL(16,4) NOT NULL | Target Field - Signed Number, Integer Positions 23 and Decimal Positions 3 |
| 61 | TGTFLD_SIGN_20 | Signed Number(21,0) | DECIMAL(20) NOT NULL | Target Field - Signed Number, Integer Positions 20 |
| 62 | TGTFLD_SIGN_23_3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Target Field - Signed Number, Integer Positions 23 and Decimal Positions 3 |
| 63 | SEQ_NBR2 | Number(15,0) | DECIMAL(15) NOT NULL | Used as a key to SHIP_INV_TMP in addition to the DEMAND_PHYS_INV. |
| 64 | SEQ_NBR_PARENT | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number - Parent Item |
| 65 | FIRST_PASS_SW | Character(1) | VARCHAR2(1) NOT NULL | First Pass Switch |