BI_360_RSP

(SQL View)
 Index Back

EIP360 Response Message

Record containing the B

SELECT S.SETID , BILL_TO_CUST_ID , SOLD_TO_CUST_ID , BUSINESS_UNIT , INVOICE_DT , INVOICE , DUE_DT , INVOICE_AMOUNT , BI_CURRENCY_CD , ORDER_NO , CONTRACT_NUM , PO_REF , PROJECT_ID , 0 , LAST_UPDATE_DTTM , LAST_MAINT_OPRID , LAST_UPDATE_DTTM , LAST_MAINT_OPRID , PROCESS_INSTANCE , LAST_UPDATE_DTTM FROM PS_BI_HDR H , PS_SET_CNTRL_REC S WHERE H.BILL_STATUS = 'INV' AND CONSOL_HDR <> 'Y' AND TEMPLATE_IVC_FLG = 'N' AND S.RECNAME = 'CUSTOMER' AND S.SETCNTRLVALUE = H.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
3 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 INVOICE_DT Date(10) DATE Invoice Date
6 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
7 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
8 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
9 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
10 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
11 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
12 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
13 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
14 TOT_RESULT_BILLS Number(5,0) INTEGER NOT NULL Total bills result from search
15 ROW_ADDED_DTTM DateTime(26) TIMESTAMP Added Date/Time
16 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
17 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP Last Modified Date/Time
18 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By
19 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
20 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time