PO_HDR_KK2_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.PO_ID , 0 , A.CHNG_ORD_BATCH , A.PO_TYPE , A.PO_STATUS , A.HOLD_STATUS , A.RECV_STATUS , A.DISP_ACTION , A.DISP_METHOD , A.CHANGE_STATUS , A. PO_DT , A.PO_REF , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.PRICE_SETID , A.PRICE_VENDOR , A.PRICE_LOC , A.PYMNT_TERMS_CD , A.BUYER_ID , A.ORIGIN , A.CHNG_ORD_SEQ , A.ADDRESS_SEQ_NUM , A.CNTCT_SEQ_NUM , A.SALES_CNTCT_SEQ_N , A.BILL_LOCATION , A.TAX_EXEMPT , A.TAX_EXEMPT_ID , A.CURRENCY_CD , A.RT_TYPE , A.MATCH_ACTION , A.MATCH_CNTRL_ID , A.MATCH_STATUS_PO , A.MATCH_PROCESS_FLG , A.PROCESS_INSTANCE , A.APPL_JRNL_ID_ENC , A.POST_DOC , A.DST_CNTRL_ID , A.OPRID_ENTERED_BY , A.ENTERED_DT , A.OPRID_APPROVED_BY , A.APPROVAL_DT , %subrec(LAST_UPDATE_SBR,A) , A.ACCOUNTING_DT , A.BUSINESS_UNIT_GL , A.IN_PROCESS_FLG , A.ACTIVITY_DATE , A.PO_POST_STATUS , A.NEXT_MOD_SEQ_NBR , A.ERS_ACTION , A.ACCRUE_USE_TAX , A.CURRENCY_CD_BASE , A.RATE_DATE , A.RATE_MULT , A.RATE_DIV , A.VAT_ENTITY , %subrec(KK_TRAN_SBR,A) , A.LC_ID , A.BUDGET_HDR_STS_NP , A.PREPAID_PO_FLG , A.PREPAID_AMT , A.PREPAID_AUTH_STAT , A.PREPAID_STATUS_PO , A.PAY_TRM_BSE_DT_OPT , A.TERMS_BASIS_DT , A.BACKORDER_STATUS , A.DOC_TOL_HDR_STATUS , A.MID_ROLL_STATUS , %subrec(PUR_USR_HDR_SBR, A) , A.BUDGET_CHECK , A.CC_SECURITY_ID , A.CC_USE_FLAG , A.CC_DISP_OPTION , A.CONTACT_NAME , A.CONTACT_PHONE , A.TEXT254_CC2 , A.POA_STATUS , A.POA_REQS , A.TMPLDEFN_ID FROM PS_PO_HDR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 KK_ROLLED_SEQ Number(3,0) SMALLINT NOT NULL PO Rolled Sequence
4 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
5 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban
6 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
7 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
8 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled
9 DISP_ACTION Character(1) VARCHAR2(1) NOT NULL Allow Dispatch When Appr
10 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
11 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged
12 PO_DT Date(10) DATE Date
13 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
14 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
15 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
16 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
17 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID
18 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID
19 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location
20 PYMT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Payment Terms Code
30=Due in 30 days after invoice
45=Due in 45 days after invoice
IMM=Due Immediately
21 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
22 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
23 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
24 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
25 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
26 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson
27 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
28 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
29 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
30 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
31 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
32 MATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Match Action
N=No Match
Y=Standard
33 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
34 MATCH_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Match Status
M=Matched
N=Not Required
P=Partially Matched
T=To Match
35 MATCH_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Match In Process
I=In Process
N=No
36 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
37 APPL_JRNL_ID_ENC Character(10) VARCHAR2(10) NOT NULL Encumbrance
38 POST_DOC Character(1) VARCHAR2(1) NOT NULL Post Document
39 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
40 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
41 ENTERED_DT Date(10) DATE Entered on
42 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By
43 APPROVAL_DT Date(10) DATE Date of Approval
44 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
45 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
46 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
47 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
48 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
49 ACTIVITY_DATE Date(10) DATE Last Activity
50 PO_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Post Status
D=Distributed
N=None
51 NEXT_MOD_SEQ_NBR Number(3,0) SMALLINT NOT NULL Next Modification Number
52 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
N=No
Y=Yes
53 ACCRUE_USE_TAX Character(1) VARCHAR2(1) NOT NULL Accrue Use Tax
54 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
55 RATE_DATE Date(10) DATE Exchange Rate Date
56 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
57 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
58 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
59 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid

Default Value: V

60 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
61 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
62 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
63 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
64 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System
65 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
66 PREPAID_PO_FLG Character(1) VARCHAR2(1) NOT NULL Prepaid PO Flag
67 PREPAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepaid Amount
68 PREPAID_AUTH_STAT Character(1) VARCHAR2(1) NOT NULL Prepaid Authorization Status
A=Authorized
N=Not Approved
P=Pending Authorization
69 PREPAID_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Prepaid PO Status
N=Not Processed
P=Processing
V=Vouchered
70 PAY_TRM_BSE_DT_OPT Character(1) VARCHAR2(1) NOT NULL Payment Terms Basis Date Type
A=Acct Date
C=Doc Date
I=Inv Date
R=Recpt Date
S=Ship Date
U=User Date
71 TERMS_BASIS_DT Date(10) DATE Payment Terms Basis Date
72 BACKORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Back Order Status
1=Not Backordered
2=Backordered
3=Backordered Received
73 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
E=Error
N=Not Checked
R=Reset
V=Valid
74 MID_ROLL_STATUS Character(1) VARCHAR2(1) NOT NULL Mid Roll Status
75 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
76 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
77 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
78 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
79 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
80 CUSTOM_DATE_A Date(10) DATE Custom Date
81 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2
82 BUDGET_CHECK Character(1) VARCHAR2(1) NOT NULL Budget Checked
N=No
Y=Yes
83 CC_SECURITY_ID Number(10,0) DECIMAL(10) NOT NULL Procurement Card Number
84 CC_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Use Procurement Card
85 CC_DISP_OPTION Character(1) VARCHAR2(1) NOT NULL ProCard Dispatch Option
A=Default
B=Include Masked Card Info
C=Contact Buyer
D=Contact Cardholder
E=Charge to Card on File
F=No Reference
86 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
87 CONTACT_PHONE Character(24) VARCHAR2(24) NOT NULL Recepient Phone
88 TEXT254_CC2 Character(254) VARCHAR2(254) NOT NULL Payment Instructions
89 POA_STATUS Character(2) VARCHAR2(2) NOT NULL po ack status field that will be on po_hdr.
AC=Acknowledged with changes
AK=Acknowledged
BA=Approved, Changes Pending
IN=Initial Dispatch Acknowledged
NR=Not Required
SR=Responded, Awaits Review
WD=Awaiting PO Dispatch
WR=Awaiting Acknowledgement
90 POA_REQS Character(1) VARCHAR2(1) NOT NULL CEL. New field to store POA requirements on the PO Hdr
A=All dispatches
I=Initial dispatch only
N=Not required
91 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).