BUSINESS_UNITINVOICELINE_SEQ_NUMDISC_SUR_LVLDISC_SUR_IDBI_LINE_S_SS_VW(SQL View) |
Index Back |
|---|---|
Line Surcharge - Self-Service |
| SELECT BUSINESS_UNIT , INVOICE , LINE_SEQ_NUM , DISC_SUR_LVL ,DISC_SUR_ID , DESCR , AMOUNT , BI_CURRENCY_CD , LANG_DESCR_OVR FROM PS_BI_LINE_DS_DTL WHERE DISC_SUR_INDICATOR = 'S' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | LINE_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Sequence |
| 4 | DISC_SUR_LVL |
Number(2,0) | SMALLINT NOT NULL | Discount/Surcharge Level |
| 5 | DISC_SUR_ID |
Character(15) | VARCHAR2(15) NOT NULL | Identifier |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 8 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 9 | LANG_DESCR_OVR | Character(3) | VARCHAR2(3) NOT NULL | Language of Descr Override |