BUSINESS_UNITSHEET_IDWORK_ORDER_IDLINE_NBRLANGUAGE_CDSPF_INV_EXP_LVW(SQL View) |
Index Back |
|---|---|
Available Expense Lang ViewThis view fetches the Expense type description for multlingual support |
| SELECT X.BUSINESS_UNIT , H.SHEET_ID , X.WORK_ORDER_ID , D.LINE_NBR , L.LANGUAGE_CD , L.EXPENSE_TYPE , L.DESCR FROM PS_SPA_SHEET_HDR H , PS_SPA_SHEET_LINE D , PS_EX_TYPES_LNG L , PS_SET_CNTRL_GROUP S , PS_SPA_EXP_XREF X WHERE D.EX_LINE_STATUS IN ('RAP', 'ADJ') AND D.SPA_BILLING_ACTION = 'B' AND D.TE_INVOICE_FLG = 'N' AND H.SHEET_ID = D.SHEET_ID AND D.SHEET_ID = X.SHEET_ID AND L.SETID = H.SETID AND L.EXPENSE_TYPE = D.EXPENSE_TYPE AND %EffdtCheck(EX_TYPES_LNG L1, L, H.CREATION_DT) AND X.BUSINESS_UNIT = S.SETCNTRLVALUE AND S.REC_GROUP_ID = 'EX_02' AND L.SETID = S.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 3 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 4 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | EXPENSE_TYPE | Character(7) | VARCHAR2(7) NOT NULL | Expense Type |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |