PROCESS_INSTANCECONTRACT_NUMCA_COMP_NAMEAMDT=Amendment
AP=Revenue Recognition Plan
BP=Billing Plan
HDR=Contract
LINE=Contract Line
MS=Contract Milestone
CONTRACT_LINE_NUMACCT_PLAN_IDBILL_PLAN_IDCHG_IDMS_SEQNUMCA_EMAIL_BT_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT STG.PROCESS_INSTANCE , STG.CONTRACT_NUM , STG.CA_COMP_NAME , STG.CONTRACT_LINE_NUM , STG.ACCT_PLAN_ID , STG.BILL_PLAN_ID , STG.CHG_ID , STG.MS_SEQNUM , STG.MILESTONE_ID , STG.SEQUENCE_5 , STG.STATUS_NEW , STG.STATUS_OLD , EMAIL.CA_STATUS_GENERIC , HDR.BUSINESS_UNIT , HDR.SOLD_TO_CUST_ID , HDR.CONTRACT_TYPE , STG.DESCR , STG.DONE_FLAG FROM PS_CA_EMAIL_STG STG , PS_CA_EMAIL_TYPE EMAIL , PS_CA_CONTR_HDR HDR WHERE HDR.CONTRACT_NUM = STG.CONTRACT_NUM AND HDR.BUSINESS_UNIT = EMAIL.BUSINESS_UNIT AND HDR.CONTRACT_TYPE = EMAIL.CONTRACT_TYPE AND STG.CA_COMP_NAME = EMAIL.CA_COMP_NAME AND (EMAIL.CA_STATUS_GENERIC = STG.STATUS_NEW OR EMAIL.CA_STATUS_GENERIC = '%') AND STG.DONE_FLAG <> 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 3 | CA_COMP_NAME |
Character(4) | VARCHAR2(4) NOT NULL |
Component
AMDT=Amendment AP=Revenue Recognition Plan BP=Billing Plan HDR=Contract LINE=Contract Line MS=Contract Milestone |
| 4 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 5 | ACCT_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Revenue Recognition Plan |
| 6 | BILL_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Billing Plan ID |
| 7 | CHG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Change Package Identifier. This is sequenced from 1 to N for each contract. |
| 8 | MS_SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Milestone Number |
| 9 | MILESTONE_ID | Character(6) | VARCHAR2(6) NOT NULL | Milestone_ID identifies the milestones that can be referenced from multiple functional areas. |
| 10 | SEQUENCE_5 | Number(5,0) | INTEGER NOT NULL | Sequnece Number of Length 5 |
| 11 | STATUS_NEW | Character(3) | VARCHAR2(3) NOT NULL | New Status |
| 12 | STATUS_OLD | Character(3) | VARCHAR2(3) NOT NULL | Old Status |
| 13 | CA_STATUS_GENERIC | Character(24) | VARCHAR2(24) NOT NULL | Contract Status |
| 14 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 15 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 16 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Contract Type |
| 17 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 18 | DONE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Done Flag |