CREDITHISTVW8LN(SQL View) |
Index Back |
---|---|
Credit History |
SELECT A.BUSINESS_UNIT , A.EXT_ORG_ID , A.EFFDT , A.AGING_SET , A.AGE_CATEGORY ,B.LANGUAGE_CD , B.DESCR FROM PS_CREDIT_HISTORY A , PS_AGING_CAT_LANG B WHERE B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE=A.BUSINESS_UNIT AND C.REC_GROUP_ID = 'AGING' AND C.RECNAME='AGING_CAT_TBL') AND A.AGING_SET = B.AGING_SET AND A.AGE_CATEGORY = B.AGE_CATEGORY AND A.EXT_ORG_ID > ' ' AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_AGING_CAT_LANG D WHERE D.SETID = B.SETID AND D.AGING_SET = B.AGING_SET AND D.EFFDT <= %CurrentDateIn) GROUP BY A.BUSINESS_UNIT, A.EXT_ORG_ID, A.EFFDT, A.AGING_SET, A.AGE_CATEGORY,B.LANGUAGE_CD , B.DESCR |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
2 | Character(11) | VARCHAR2(11) NOT NULL | External Org ID | |
3 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
4 | Character(5) | VARCHAR2(5) NOT NULL | Aging Set | |
5 | Character(2) | VARCHAR2(2) NOT NULL | Aging Category | |
6 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |