BUSINESS_UNITLEDGER_GROUPSETIDPROCESS_GROUPA=All Transaction Sources
V=Specific Transaction Source
COMBO_SEL_GRPVW(SQL View) |
Index Back |
|---|---|
Combo Selector Table Groups |
| SELECT A.BUSINESS_UNIT ,A.LEDGER_GROUP , B.SETID , B.PROCESS_GROUP , B.DATE_FROM ,B.DATE_TO ,A.COMBO_TRAN_SRC_OPT FROM PS_BU_LED_COMB_TBL A , PS_COMBO_SEL_GROUP B , PS_SET_CNTRL_REC X WHERE B.SETID = X.SETID AND X.SETCNTRLVALUE = A.BUSINESS_UNIT AND X.RECNAME = 'COMBO_GROUP_TBL' AND B.PROCESS_GROUP = A.PROCESS_GROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | PROCESS_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Process Group |
| 5 | DATE_FROM | Date(10) | DATE | Date From |
| 6 | DATE_TO | Date(10) | DATE | Date To |
| 7 | COMBO_TRAN_SRC_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Combo Edit Transaction Source Option
A=All Transaction Sources V=Specific Transaction Source |