SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
0=No history will be maintained
1=History for all Transactions
2=History only for Errors
Default Value: 0
2=Complete
6=Confirmed
Default Value: 2
BCT_SETUP_FS(SQL Table) |
Index Back |
|---|---|
Bar Code Trans Proc. Setup Tbl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | TRANSACTION_NBR | Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
| 3 | BCT_HISTORY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
History Options
0=No history will be maintained 1=History for all Transactions 2=History only for Errors Default Value: 0 |
| 4 | BCT_PURGE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Setup field to indicate what status of BCT records (BCT_STATUS) the purge process will work with.
2=Complete 6=Confirmed Default Value: 2 |
| 5 | FILE_SUFFIX | Character(4) | VARCHAR2(4) NOT NULL | File Suffix |