BUSINESS_UNITLEDGER_GROUPLEDGER_TEMPLATESETIDPROCESS_GROUPA=All Transaction Sources
V=Specific Transaction Source
COMBO_BLD_GRPVW(SQL View) |
Index Back |
|---|---|
Combo Selector Table Groups |
| SELECT A.BUSINESS_UNIT ,A.LEDGER_GROUP ,B.LEDGER_TEMPLATE , B.SETID , B.PROCESS_GROUP , B.AS_OF_DATE ,A.COMBO_TRAN_SRC_OPT FROM PS_BU_LED_COMB_TBL A , PS_COMBO_BLD_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 | LEDGER_TEMPLATE |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Template |
| 4 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | PROCESS_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Process Group |
| 6 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 7 | COMBO_TRAN_SRC_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Combo Edit Transaction Source Option
A=All Transaction Sources V=Specific Transaction Source |