SL_BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
TRANSACTION_CODEEIP_CTL_ID0=New
1=Error
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Confirmed
Default Value: %Datetime
BCT_FUL_EIP_VW(SQL View) |
Index Back |
|---|---|
BCT Control Id prompt viewused to list control id's in use for a business unit |
| SELECT BUSINESS_UNIT , TRANSACTION_CODE , EIP_CTL_ID , BCT_STATUS , EIP_TRANS_SRC , EIP_TRANS_SRC_REF , DT_TIMESTAMP FROM PS_BCT_CTL WHERE BCT_STATUS IN ('0', '1', '4') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SL_BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit selection field
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 2 | TRANSACTION_CODE |
Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
| 3 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 4 | BCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transaction status in the stage table
0=New 1=Error 2=Complete 3=In Process 4=Reprocess 5=Incomplete 6=Confirmed |
| 5 | EIP_TRANS_SRC | Character(30) | VARCHAR2(30) NOT NULL | 08/02/99 NAS: Created the field for MES but it will be owned by Entreprise, they just don't know it yet :-) |
| 6 | EIP_TRANS_SRC_REF | Character(30) | VARCHAR2(30) NOT NULL | Source Reference |
| 7 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP NOT NULL |
Date Timestamp
Default Value: %Datetime |