EFT_LAYOUT_CDSETIDPrompt Table: SP_SETID_NONVW
B=Bureau
U=User
Y/N Table Edit
Default Value: N
Y/N Table Edit
1=3.5" Diskette
2=Telecomm
Default Value: 1
BACS_LOGON_UK(SQL Table) |
Index Back |
|---|---|
BACS Logon Information |
| # | 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 | BACS_SUBMSN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
BACS Submission Type
B=Bureau U=User |
| 4 | BACS_USER_NBR | Character(6) | VARCHAR2(6) NOT NULL | BACS User/Bureau Number |
| 5 | BACS_SERIAL_NBR | Character(6) | VARCHAR2(6) NOT NULL | BACS Submission Serial Number |
| 6 | BACS_AUDIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
BACS Audit Print Required
Y/N Table Edit Default Value: N |
| 7 | BACS_AUDIT_RCRD | Number(4,0) | SMALLINT NOT NULL | BACS Audit Print Record |
| 8 | BACS_EXPIRY_DAYS | Number(2,0) | SMALLINT NOT NULL | BACS Expiration Days |
| 9 | BACS_CRLF | Character(1) | VARCHAR2(1) NOT NULL |
Carriage Return/ Line Feed
Y/N Table Edit |
| 10 | BACS_MEDIA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
BACS Media Type
1=3.5" Diskette 2=Telecomm Default Value: 1 |