SCHED_IDPrompt Table: BN_M_MERCH_SRCH
Y/N Table Edit
Default Value: N
BN_M_SCHED_TBL(SQL Table) |
Index Back |
|---|---|
Schedule ID tableThis record is used to hold Schedule information for Supplier-Carrier Interface file extracts. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCHED_ID |
Character(6) | VARCHAR2(6) NOT NULL | Schedule ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | COMPANY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Company Descr |
| 4 | MERCHANTID | Character(30) | VARCHAR2(30) NOT NULL |
Merchant ID
Prompt Table: BN_M_MERCH_SRCH |
| 5 | FILE_DIRECTORY | Character(80) | VARCHAR2(80) NOT NULL | File Directory |
| 6 | AUTO_GENERATE | Character(1) | VARCHAR2(1) NOT NULL |
Auto Generate File Name
Y/N Table Edit Default Value: N |
| 7 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |