PO_SPNDBODTL_VW (SQL View)	Index Back
po spend back order

PO_SPNDBODTL_VW

(SQL View)

po spend back order

SELECT REPORT_ENTITY , BUYER_ID , VENDOR_SETID , VENDOR_ID , VNDR_LOC , BUSINESS_UNIT , PO_ID , LINE_NBR , SCHED_NBR , FISCAL_YEAR , ACCOUNTING_PERIOD , CURRENCY_CD , MERCHANDISE_AMT , DUE_DT , PO_DT , BACKORDER_AMT , HOLD_STATUS , BUDGET_HDR_STS_NP , PO_REF , 'N' 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 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

7 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

8 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

9 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

10 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

11 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.

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

13 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

14 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.

15 PO_DT Date(10) DATE Date

16 BACKORDER_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amount

17 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
Y/N Table Edit
Default Value: N

18 BUDGET_HDR_STS_NP Character(1) VARCHAR2(1) NOT NULL Budget Ch'k Hdr Sts NonProrate
E=Error in Budget Check
N=Not Budget Checked
P=Provisionally Valid
V=Valid Budget Check
Default Value: V

19 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.

20 PO_SEL_OPTION Character(1) VARCHAR2(1) NOT NULL Purchasing Select Options
A=Requisitions / Purchase Orders
P=Purchase Orders
R=Requisitions

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REPORT_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Reporting Entity ID
2	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
3	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
8	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
9	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
10	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
11	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.
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
14	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.
15	PO_DT	Date(10)	DATE	Date
16	BACKORDER_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amount
17	HOLD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Hold From Further Processing Y/N Table Edit Default Value: N
18	BUDGET_HDR_STS_NP	Character(1)	VARCHAR2(1) NOT NULL	Budget Ch'k Hdr Sts NonProrate E=Error in Budget Check N=Not Budget Checked P=Provisionally Valid V=Valid Budget Check Default Value: V
19	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
20	PO_SEL_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Purchasing Select Options A=Requisitions / Purchase Orders P=Purchase Orders R=Requisitions