PO_SPNDBODTA_VW

(SQL View)
 Index Back

po spend back order


SELECT REPORT_ENTITY , VENDOR_SETID , VENDOR_ID , VNDR_LOC , BUSINESS_UNIT , PO_ID , LINE_NBR , SCHED_NBR , FISCAL_YEAR , ACCOUNTING_PERIOD , DUE_DT , BACKORDER_AMT FROM PS_PO_SPND_PODTDTL WHERE BACKORDER_AMT > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID
2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
7 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
8 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
9 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
10 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
11 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.
12 BACKORDER_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amount