BUSINESS_UNITLEDGERCNAO_BULEG_VW(SQL View) |
Index Back |
|---|---|
CNAO Data Preload Ledger View |
| SELECT G.BUSINESS_UNIT , LGL.LEDGER FROM PS_BU_LED_GRP_TBL G , PS_LED_GRP_LED_TBL LGL , PS_LED_DEFN_TBL L WHERE LGL.LEDGER_GROUP = G.LEDGER_GROUP AND LGL.LEDGER = L.LEDGER AND L.LEDGER_TYPE='D' AND LGL.SETID = ( SELECT R.SETID FROM PS_SET_CNTRL_REC R WHERE R.RECNAME = 'LED_GRP_TBL' AND R.SETCNTRLVALUE = G.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 |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |