BUSINESS_UNITLEDGER_GROUPSETIDPROCESS_GROUPPrompt Table: COMBO_GROUP_TBL
COMBINATIONA=All Transaction Sources
V=Specific Transaction Source
BU_LED_CMBUD_VW(SQL View) |
Index Back |
|---|---|
BU Ledger & COMBO View |
| SELECT A.BUSINESS_UNIT , A.LEDGER_GROUP , B.SETID , B.PROCESS_GROUP , B.PROCESS_GROUP ,A.COMBO_TRAN_SRC_OPT FROM PS_BU_LED_COMB_TBL A , PS_COMBO_GROUP_TBL B , PS_SET_CNTRL_REC C WHERE A.PROCESS_GROUP = B.PROCESS_GROUP AND B.SETID = C.SETID AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'COMBO_GROUP_TBL' AND B.USER_DEFINED = 'Y' |
| # | 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
Prompt Table: COMBO_GROUP_TBL |
| 5 | COMBINATION |
Character(10) | VARCHAR2(10) NOT NULL | Combination Rule |
| 6 | COMBO_TRAN_SRC_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Combo Edit Transaction Source Option
A=All Transaction Sources V=Specific Transaction Source |