FEDI_REG_TBL(SQL Table) |
Index Back |
---|---|
Singapore Giro EFT Options |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EFT_LAYOUT_CD | Character(10) | VARCHAR2(10) NOT NULL | EFT Layout Code |
2 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
3 | BNK_LIMIT_LOW_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | This field contains the lower amount when subtracted from a transaction amount that will still reconcile. |
4 | BNK_LIMIT_HIGH_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | This field contains the upper amount when added to a transaction amount that will still reconcile. |
5 | ID_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Identification Sequence number |
6 | FEDI_VIEW_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Restricted Viewing Flag
R=Restricted U=Unrestricted Default Value: U |
7 | STMTS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Statements Work Flag
Y/N Table Edit Default Value: N |