BUSINESS_UNITPROPOSAL_IDVERSION_IDFA_RATE_TYPECUST_IDGM_BUD_F_SP2_VW(SQL View) |
Index Back |
|---|---|
F&A Sponsor Rate View |
| select C.BUSINESS_UNIT, C.PROPOSAL_ID, C.VERSION_ID, B.FA_RATE_TYPE, B.CUST_ID, B.EFFDT, B.FA_RATE_PCT from PS_GM_SP_FA_RAT_DT A, PS_GM_SP_FA_RATE B, PS_GM_PROPOSAL C where A.SETID = B.SETID and A.CUST_ID = B.CUST_ID and A.EFFDT = B.EFFDT and A.EFF_STATUS = 'A' and A.SETID = (SELECT SETID FROM PS_SET_CNTRL_REC G WHERE G.SETCNTRLVALUE = C.BUSINESS_UNIT AND G.RECNAME = 'GM_SP_FA_RATE') and A.CUST_ID = C.CUST_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 3 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 4 | FA_RATE_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | FA_RATE_TYPE |
| 5 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 6 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 7 | FA_RATE_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | FA_RATE_PCT |