PO_SPND_PONDDTL

(SQL Table)
Index Back

Detail table for Spend AE

Detail table for Spend AE by PO Date 06/25/2008 PKL F-AHAYT-S60K7 Contract Enhancements

# 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 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
14 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
15 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
16 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
17 CONTRACT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
18 CONTRACT_FLAG Character(1) VARCHAR2(1) NOT NULL Contract Flag

Y/N Table Edit

Default Value: N

19 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.
20 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
21 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
22 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
23 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
24 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
25 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
26 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
27 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
28 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
29 PO_DT Date(10) DATE Date
30 BACKORDER_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amount
31 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
32 PEND_FR_DT Date(10) DATE Select Pend-Cmpl Prdn From Dat
33 PEND_FR_DT_LINE Date(10) DATE Pending From
34 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing

Y/N Table Edit

Default Value: N

35 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

36 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
37 LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
A=Active
C=Cancelled
I=Inactive
O=Open
P=Pending
38 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled