CORPORATE_SETIDCORPORATE_CUST_IDEFFDTA=Active
I=Inactive
CUST_CORP_CR_VW(SQL View) |
Index Back |
|---|---|
Corporate Cust Credit Vw - OM |
| SELECT A.SETID ,A.CUST_ID ,A.EFFDT ,A.EFF_STATUS ,B.NAME1 ,B.NAMESHORT ,A.CR_LIMIT_CORP ,A.CR_LIMIT_CORP_DT ,A.CORPCR_PCT_OVR ,A.CURRENCY_CD FROM PS_CUST_CREDIT A , PS_CUSTOMER B WHERE A.SETID = B.SETID AND A.CUST_ID = B.CUST_ID AND B.SETID = B.CORPORATE_SETID AND B.CUST_ID = B.CORPORATE_CUST_ID AND B.CUST_STATUS IN ('A','I') AND %EffdtCheck(cust_credit, A, %currentdatein) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CORPORATE_SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CORPORATE_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Corporate Customer |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 6 | NAMESHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Name |
| 7 | CR_LIMIT_CORP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Corporate Credit Limit |
| 8 | CR_LIMIT_CORP_DT | Date(10) | DATE | Corporate Credit Limit Date |
| 9 | CORPCR_PCT_OVR | Number(3,0) | SMALLINT NOT NULL | % Over Limit |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |