BUSINESS_UNITLEDGER_GROUPSETIDPROCESS_GROUPN=Mark Invalid
Y=Mark Valid
D=Combo Data Table
R=Master Selector Tables
I=Invalid Combinations
V=Valid Combinations
A=All Transaction Sources
V=Specific Transaction Source
BU_LED_COMB_VWG(SQL View) |
Index Back |
|---|---|
CF Combos for Ledger VWGBusiness Unit/Ledger Group for CF Combo. |
| SELECT a.business_unit ,a.ledger_group ,b.setid ,b.process_group ,b.anchor_only ,b.user_defined ,b.combo_edit_option ,b.combo_direction ,a.combo_tran_src_opt FROM ps_bu_led_comb_tbl a , PS_COMBO_GROUP_TBL b , PS_SET_CNTRL_REC x WHERE a.process_group = b.process_group AND b.setid = x.setid AND x.recname = 'COMBO_RULE_TBL' AND x.setcntrlvalue = a.business_unit |
| # | 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 | ANCHOR_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Anchor Values Not In Rules
N=Mark Invalid Y=Mark Valid |
| 6 | USER_DEFINED | Character(1) | VARCHAR2(1) NOT NULL | User Defined Combination Data |
| 7 | COMBO_EDIT_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Combo Editing Option
D=Combo Data Table R=Master Selector Tables |
| 8 | COMBO_DIRECTION | Character(1) | VARCHAR2(1) NOT NULL |
Combination Group Defines
I=Invalid Combinations V=Valid Combinations |
| 9 | COMBO_TRAN_SRC_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Combo Edit Transaction Source Option
A=All Transaction Sources V=Specific Transaction Source |