BUSINESS_UNITSO_IDRF_INT_OD_TXNVW(SQL View) |
Index Back |
|---|---|
View for One Time TransactionsMapping Information for One time Transactions of Service Orders |
| SELECT A.BUSINESS_UNIT , A.SO_ID , B.BUSINESS_UNIT_CA , %Substring(B.EXTERNAL_KEY_2,1,25) , %Sql(CON_NUM_BIND_TO_CAST,%Substring(%NumToChar(B.EXTERNAL_KEY_3),1,3)) FROM PS_RF_SO_HDR A , PS_RF_INT_OD_TXN B WHERE A.BO_ID_CUST = B.BO_ID_CUST AND A.AGREEMENT_CODE = ' ' AND A.AGREEMENT_LINE = ' ' AND A.BILLING_STATUS <> '001' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Service Order ID |
| 3 | BUSINESS_UNIT_CA | Character(5) | VARCHAR2(5) NOT NULL | This field stores the values for Contracts Business Unit. |
| 4 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | This field is used to represent the contract number |
| 5 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |