BAX_HDR_TR_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BAX_HEADER_TR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: BANK_CD_BU_VW |
| 3 | BAX_TRANSFER_ID | Character(12) | VARCHAR2(12) NOT NULL | An unique key identifier that represents a bank transfer transaction. |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 7 | TRANSFER_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Transfer Type
00=Internal Transfer 01=External Transfer |
| 8 | TRANSACTION_DT | Date(10) | DATE NOT NULL |
Transaction date (often used as trade date)
Default Value: %DATE |
| 9 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 10 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_ACTIVE |
| 11 | 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
Prompt Table: %EDITTABLE |
| 12 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 13 | BANK_CD_CUST | Character(5) | VARCHAR2(5) NOT NULL |
Represents the customer bank or counterparty in a relationship that pairs differing sets of b
Prompt Table: BAX_ACCT_VW1 |
| 14 | SETTLEMENT_ID | Character(5) | VARCHAR2(5) NOT NULL | A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc |
| 15 | TEMPLATE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to indicate whether a given bank transfer transaction should be designated as a
Y/N Table Edit Default Value: N |
| 16 | BAX_SWEEP_SW | Character(1) | VARCHAR2(1) NOT NULL |
Bank Transfer Sweep
Y/N Table Edit Default Value: N |
| 17 | MASS_BAX_SW | Character(1) | VARCHAR2(1) NOT NULL |
Mass Bank Transfer Switch
Y/N Table Edit |
| 18 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 19 | DTTM_ENTERED | DateTime(26) | TIMESTAMP | Date Time Stamp for Entry |
| 20 | 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 Prompt Table: STL_PYMT_MTHD_V |
| 21 | FORMAT_ID | Character(10) | VARCHAR2(10) NOT NULL | Format ID |
| 22 | TR_WR_TEMPLATE_ID | Character(12) | VARCHAR2(12) NOT NULL |
Treasury Wires / Treasury Wire Templates
This uniquely identifies templates within a Business Unit.
Prompt Table: TR_WR_TMPL_VW2 |
| 23 | REPETITVE_TRNFR_CD | Character(15) | VARCHAR2(15) NOT NULL | Repetitive Transfer Code assigned by customers Bank |
| 24 | DRAWDOWN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Drawdown Transfer Flag, either yes or no.
N=No Y=Yes Y/N Table Edit Default Value: N |
| 25 | TMPL_EXPIRATION_DT | Date(10) | DATE | Transfer Template Expiration Date |
| 26 | DOC_TYPE_BAX_FROM | Character(8) | VARCHAR2(8) NOT NULL | From Document Type |
| 27 | DOC_TYPE_BAX_TO | Character(8) | VARCHAR2(8) NOT NULL | To Document Type |
| 28 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |