SETIDPrompt Table: SP_SETID_NONVW
RECON_LAYOUT_IDPrompt Table: BNK_RCN_INP_LAY
BANK_TRANS_CODEDefault Value: BNK_RCN_INP_TRN.DESCR
P=Payment
Default Value: P
BNK_RCN_INP_TRN(SQL Table) |
Index Back |
|---|---|
Bank Transaction Code |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | RECON_LAYOUT_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Input File Layout ID
Prompt Table: BNK_RCN_INP_LAY |
| 3 | BANK_TRANS_CODE |
Character(20) | VARCHAR2(20) NOT NULL | Bank Transaction Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: BNK_RCN_INP_TRN.DESCR |
| 6 | RECON_TRANS_CODE | Character(1) | VARCHAR2(1) NOT NULL |
PeopleSoft Transaction
P=Payment Default Value: P |