BUSINESS_UNITDefault Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW
SSF_REL_INVOICE_IDSSF_BILL_ADJ_VW(SQL View) |
Index Back |
|---|---|
Billing Line |
| SELECT B.BUSINESS_UNIT , B.SSF_REL_INVOICE_ID , SUM(B.SSF_RELINV_AMT) FROM PS_BI_BILL_HEADER A , PS_SSF_BILL_LNCR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INVOICE_ID = B.INVOICE_ID AND A.SF_BILL_STATUS = 'I' GROUP BY B.BUSINESS_UNIT, B.SSF_REL_INVOICE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | SSF_REL_INVOICE_ID |
Character(22) | VARCHAR2(22) NOT NULL | Related Invoice ID |
| 3 | SSF_RELINV_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Related Invoice Amount |