BI_WKSH_LIST_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT H.BUSINESS_UNIT , H.INVOICE , R.RUN_CNTL_ID , H.BILL_TO_CUST_ID , R.THRU_BILL_TO_CUST , H.BILL_TYPE_ID , R.THRU_BILL_TYPE_ID , H.BILL_SOURCE_ID , R.THRU_BILL_SOURCE , H.CONTRACT_TYPE , R.THRU_CONTRACT_TYPE , H.CONTRACT_NUM , R.THRU_CONTRACT_NUM , H.PROJECT_ID , R.THRU_PROJECT_ID , H.BILLING_SPECIALIST , R.THRU_BI_SPECIALIST , R.START_INVOICE , R.END_INVOICE , H.LC_ID , R.THRU_LC_ID , H.LOC_DOC_ID , R.THRU_LOC_DOC_ID , H.INVOICE_AMT_PRETAX , R.THRU_INVAMT_PRETAX , R.ADDED_IN_DAYS , R.DATE_ADDED , R.THRU_DATE , H.USER1 , R.THRU_USER1 , H.ACCOUNTING_DT , R.ACCOUNTING_DT_TO , H.INVOICE_DT , R.INVOICE_DT_TO , H.BILL_STATUS , H.PROCESS_INSTANCE , H.PC_DISTRIB_STATUS , H.ADD_DTTM FROM PS_BI_HDR H , PS_RUN_BI_WKSH_UPD R WHERE H.BUSINESS_UNIT = R.BUSINESS_UNIT AND EXISTS ( SELECT 'X' FROM PS_BI_WRKSHT_STG STG WHERE H.BUSINESS_UNIT = STG.BUSINESS_UNIT AND H.INVOICE = STG.INVOICE AND STG.BI_ACTION_TMP = R.BI_ACTION_TMP) |
| # | 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 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: %EDITTABLE2 |
| 5 | THRU_BILL_TO_CUST | Character(15) | VARCHAR2(15) NOT NULL |
THRU_BILL_TO_CUST_ID
Prompt Table: %EDITTABLE2 |
| 6 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table: BI_TYPE_EF_VW |
| 7 | THRU_BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Thru Bill Type Identifier
Prompt Table: BI_TYPE_EF_VW |
| 8 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table: BI_SRC_EF_VW |
| 9 | THRU_BILL_SOURCE | Character(10) | VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table: BI_SRC_EF_VW |
| 10 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL |
Contract Type
Prompt Table: CA_TYPE_TBL |
| 11 | THRU_CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL |
Contract Type
Prompt Table: CA_TYPE_TBL |
| 12 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: %EDITTABLE3 |
| 13 | THRU_CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Thru Contract Number
Prompt Table: %EDITTABLE3 |
| 14 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: %EDITTABLE4 |
| 15 | THRU_PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Thru Project Id
Prompt Table: %EDITTABLE4 |
| 16 | BILLING_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table: BI_SPECIALST_VW |
| 17 | THRU_BI_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL |
Thru Billing Specialist
Prompt Table: BI_SPECIALST_VW |
| 18 | START_INVOICE | Character(22) | VARCHAR2(22) NOT NULL |
Starting Invoice Number
Prompt Table: %EDITTABLE |
| 19 | END_INVOICE | Character(22) | VARCHAR2(22) NOT NULL |
Ending Invoice Number
Prompt Table: %EDITTABLE |
| 20 | LC_ID | Character(12) | VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
Prompt Table: %EDITTABLE5 |
| 21 | THRU_LC_ID | Character(12) | VARCHAR2(12) NOT NULL |
Thru Treasury Letter of Credit Number Assigned by the System
Prompt Table: %EDITTABLE5 |
| 22 | LOC_DOC_ID | Character(30) | VARCHAR2(30) NOT NULL |
Letter of Credit Document ID
Prompt Table: %EDITTABLE6 |
| 23 | THRU_LOC_DOC_ID | Character(15) | VARCHAR2(15) NOT NULL |
Thru Letter of Credit Document ID
Prompt Table: %EDITTABLE6 |
| 24 | INVOICE_AMT_PRETAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pretax Invoice Amount |
| 25 | THRU_INVAMT_PRETAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Thru Pretax Invoice Amount |
| 26 | ADDED_IN_DAYS | Number(3,0) | SMALLINT NOT NULL | Added within days |
| 27 | DATE_ADDED | Date(10) | DATE | Date Added |
| 28 | THRU_DATE | Date(10) | DATE | Through Date |
| 29 | USER1 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 30 | THRU_USER1 | Character(1) | VARCHAR2(1) NOT NULL | Thru USER1 (customizable and user defined field) |
| 31 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 32 | ACCOUNTING_DT_TO | Date(10) | DATE | The range of the accounting entry construction dates |
| 33 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 34 | INVOICE_DT_TO | Date(10) | DATE | Through |
| 35 | BILL_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Bill Status
CAN=Canceled FNL=Finalized Bill HLD=Hold Bill INV=Invoiced Bill NEW=New Bill PND=Pending Approval RDY=Ready to Invoice TMP=Temporary Bill TMR=Temporary Ready Bill |
| 36 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 37 | PC_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged |
| 38 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |