ACCOUNTAMR_VCHR_ACC_VW(SQL View) |
Index Back |
|---|---|
Amortization headerAmortization header Record |
| SELECT DISTINCT DL.ACCOUNT FROM PS_VOUCHER V , PS_VOUCHER_LINE VL , PS_DISTRIB_LINE DL , PS_SET_CNTRL_REC A , PS_BU_LED_GRP_TBL B WHERE V.BUSINESS_UNIT = DL.BUSINESS_UNIT AND V.VOUCHER_ID = DL.VOUCHER_ID AND VL.BUSINESS_UNIT = V.BUSINESS_UNIT AND VL.VOUCHER_ID = V.VOUCHER_ID AND DL.VOUCHER_LINE_NUM = VL.VOUCHER_LINE_NUM AND V.VOUCHER_STYLE = 'AMR' AND A.SETCNTRLVALUE = DL.BUSINESS_UNIT_GL AND A.RECNAME = 'AMORT_TYP' AND B.BUSINESS_UNIT = DL.BUSINESS_UNIT_GL AND B.LEDGER_GROUP = DL.LEDGER_GROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |