LEDGERSETIDGL_GET_CF_TABLE(SQL View) |
Index Back |
|---|---|
GL_GET_CF_TABLEGets the record defined in a ledger template for a given BU+LEDGER |
| SELECT A.BUSINESS_UNIT , A.LEDGER , B.SETID , C.RECNAME , C.FIELDNAME_ACCOUNT , C.RECNAME_ACCOUNT FROM PS_BU_LED_TBL A , PS_LED_GRP_TBL B , PS_LED_TMPLT_TBL C WHERE A.LEDGER_GROUP = B.LEDGER_GROUP AND B.LEDGER_TEMPLATE = C.LEDGER_TEMPLATE |
| # | 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 |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 5 | FIELDNAME_ACCOUNT | Character(18) | VARCHAR2(18) NOT NULL | Account |
| 6 | RECNAME_ACCOUNT | Character(15) | VARCHAR2(15) NOT NULL | Account ChartField |