BUSINESS_UNITINVOICELINE_SEQ_NUMCDT_BI_LINE_VW(SQL View) |
Index Back |
|---|---|
CSR Desktop Bill Line Summary |
| SELECT BUSINESS_UNIT , INVOICE , LINE_SEQ_NUM , INVOICE_LINE , BI_CURRENCY_CD , NET_EXTENDED_AMT + TAX_AMT + VAT_AMT , DESCR , BUSINESS_UNIT_OM , ORDER_NO , BUSINESS_UNIT_RMA , RMA_ID , BUSINESS_UNIT_CA , CONTRACT_NUM , PO_REF FROM PS_BI_LINE |
| # | 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 | INVOICE_LINE | Number(5,0) | INTEGER NOT NULL | Invoice Line |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | LINE_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Plus Tax |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 9 | ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 10 | BUSINESS_UNIT_RMA | Character(5) | VARCHAR2(5) NOT NULL | RMA Business Unit |
| 11 | RMA_ID | Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
| 12 | BUSINESS_UNIT_CA | Character(5) | VARCHAR2(5) NOT NULL | Contracts Business Unit |
| 13 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 14 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |