SAC_PO_HD_OUT (SQL View)	Index Back
PS Header Msg record PS Header Msg record

SAC_PO_HD_OUT

(SQL View)

PS Header Msg record

SELECT A.BUSINESS_UNIT ,A.PO_ID ,' ' ,' ' ,A.CHNG_ORD_BATCH ,A.PO_TYPE ,A.PO_STATUS ,A.HOLD_STATUS ,A.RECV_STATUS ,A.CHANGE_STATUS ,A.PO_DT ,A.PO_REF ,A.VENDOR_SETID ,A.VENDOR_ID ,A.VNDR_LOC ,A.PYMNT_TERMS_CD ,A.BUYER_ID ,A.CHNG_ORD_SEQ ,A.BILL_LOCATION ,A.TAX_EXEMPT ,A.TAX_EXEMPT_ID ,A.CURRENCY_CD ,A.OPRID_ENTERED_BY ,A.ENTERED_DT , A.OPRID_MODIFIED_BY , A.LAST_DTTM_UPDATE ,A.ACCOUNTING_DT ,A.BUSINESS_UNIT_GL ,A.VAT_ENTITY ,A.BACKORDER_STATUS ,A.VENDOR_PHONE ,A.VENDOR_FAX ,A.NAME1_VNDR ,A.ADDRESS1_VNDR ,A.ADDRESS2_VNDR ,A.CITY_VNDR ,A.STATE_VNDR ,A.POSTAL_VNDR ,A.COUNTRY_VNDR ,A.EMAILID_VNDR ,A.BU_DESCR ,A.COUNTRY_BU ,A.ADDRESS1_BU ,A.ADDRESS2_BU ,A.ADDRESS3_BU ,A.ADDRESS4_BU ,A.CITY_BU ,A.STATE_BU ,A.POSTAL_BU ,A.BU_COUNTRY_CODE ,A.BU_PHONE ,A.BU_EXTENSION ,A.BU_FAX ,A.BILLTO_DESCR ,A.COUNTRY_BILLTO ,A.ADDRESS1_BILL ,A.ADDRESS2_BILL ,A.ADDRESS3_BILL ,A.ADDRESS4_BILL ,A.CITY_BILLTO ,A.STATE_BILLTO ,A.POSTAL_BILLTO ,A.BILL_COUNTRY_CODE ,A.BILLTO_PHONE ,A.BILLTO_EXTENSION ,A.BILLTO_FAX ,A.RATE_DATE ,A.RATE_MULT ,A.RATE_DIV ,B.COMMENTS_2000 FROM PS_SAC_PO_ERP_HD_V A , PS_SAC_PO_CMNT_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND B.SOURCE_LINE_NBR = 0 AND B.COMMENT_TYPE = 'HDR'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
Default Value: NEXT

3 SAC_SYNC_STS Character(1) VARCHAR2(1) NOT NULL Sync Sts flag
C=Change
N=New
U=Update

4 EXT_POID_SOURCE Character(1) VARCHAR2(1) NOT NULL External PO ID source

5 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number

6 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban
Default Value: GEN

7 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
Default Value: I

8 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
Default Value: N

9 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
Default Value: N

10 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged
Default Value: U

11 PO_DT Date(10) DATE NOT NULL Date
Default Value: %date

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

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

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

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

16 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

17 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

18 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number

19 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION

20 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
Default Value: BUS_UNIT_TBL_PM.TAX_EXEMPT

21 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID

22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD

23 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

24 ENTERED_DT Date(10) DATE Entered on

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

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

27 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

28 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL

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

30 BACKORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Back Order Status
1=Not Backordered
2=Backordered
3=Backordered Received
Default Value: 1

31 VENDOR_PHONE Character(24) VARCHAR2(24) NOT NULL Buyer Phone

32 VENDOR_FAX Character(24) VARCHAR2(24) NOT NULL Fax Number

33 NAME1_VNDR Character(40) VARCHAR2(40) NOT NULL Vendor Name

34 ADDRESS1_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 1

35 ADDRESS2_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 2

36 CITY_VNDR Character(30) VARCHAR2(30) NOT NULL Vendor City

37 STATE_VNDR Character(6) VARCHAR2(6) NOT NULL Vendor State

38 POSTAL_VNDR Character(12) VARCHAR2(12) NOT NULL Vendor Postal Code

39 COUNTRY_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Country

40 EMAILID_VNDR Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

41 BU_DESCR Character(30) VARCHAR2(30) NOT NULL Business unit description.

42 COUNTRY_BU Character(3) VARCHAR2(3) NOT NULL Business Unit Country

43 ADDRESS1_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 1

44 ADDRESS2_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 2

45 ADDRESS3_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 3

46 ADDRESS4_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 4

47 CITY_BU Character(30) VARCHAR2(30) NOT NULL Business Unit City

48 STATE_BU Character(6) VARCHAR2(6) NOT NULL Business Unit State

49 POSTAL_BU Character(12) VARCHAR2(12) NOT NULL Business Unit Postal Code

50 BU_COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix

51 BU_PHONE Character(24) VARCHAR2(24) NOT NULL Buyer Phone

52 BU_EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension

53 BU_FAX Character(24) VARCHAR2(24) NOT NULL Fax Number

54 BILLTO_DESCR Character(30) VARCHAR2(30) NOT NULL Bill to descr

55 COUNTRY_BILLTO Character(3) VARCHAR2(3) NOT NULL Bill To Country

56 ADDRESS1_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 1

57 ADDRESS2_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 2

58 ADDRESS3_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 3

59 ADDRESS4_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 4

60 CITY_BILLTO Character(30) VARCHAR2(30) NOT NULL Bill To City

61 STATE_BILLTO Character(6) VARCHAR2(6) NOT NULL Bill To State

62 POSTAL_BILLTO Character(12) VARCHAR2(12) NOT NULL Bill To Postal

63 BILL_COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix

64 BILLTO_PHONE Character(24) VARCHAR2(24) NOT NULL Buyer Phone

65 BILLTO_EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension

66 BILLTO_FAX Character(24) VARCHAR2(24) NOT NULL Fax Number

67 RATE_DATE Date(10) DATE Exchange Rate Date

68 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

69 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

70 COMMENTS_2000 Long Character CLOB Comment Text

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Default Value: NEXT
3	SAC_SYNC_STS	Character(1)	VARCHAR2(1) NOT NULL	Sync Sts flag C=Change N=New U=Update
4	EXT_POID_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	External PO ID source
5	CHNG_ORD_BATCH	Number(3,0)	SMALLINT NOT NULL	Change Order Number
6	PO_TYPE	Character(4)	VARCHAR2(4) NOT NULL	PO Type GEN=General KAN=Kanban Default Value: GEN
7	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 Default Value: I
8	HOLD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Hold From Further Processing Default Value: N
9	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 Default Value: N
10	CHANGE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Change Order Status C=Changed U=Unchanged Default Value: U
11	PO_DT	Date(10)	DATE NOT NULL	Date Default Value: %date
12	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
13	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
14	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
15	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
16	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
17	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
18	CHNG_ORD_SEQ	Number(3,0)	SMALLINT NOT NULL	Change Order Sequence Number
19	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION
20	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Default Value: BUS_UNIT_TBL_PM.TAX_EXEMPT
21	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD
23	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
24	ENTERED_DT	Date(10)	DATE	Entered on
25	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.
26	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.
27	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
28	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL
29	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.
30	BACKORDER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Back Order Status 1=Not Backordered 2=Backordered 3=Backordered Received Default Value: 1
31	VENDOR_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Buyer Phone
32	VENDOR_FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
33	NAME1_VNDR	Character(40)	VARCHAR2(40) NOT NULL	Vendor Name
34	ADDRESS1_VNDR	Character(55)	VARCHAR2(55) NOT NULL	Vendor Address Line 1
35	ADDRESS2_VNDR	Character(55)	VARCHAR2(55) NOT NULL	Vendor Address Line 2
36	CITY_VNDR	Character(30)	VARCHAR2(30) NOT NULL	Vendor City
37	STATE_VNDR	Character(6)	VARCHAR2(6) NOT NULL	Vendor State
38	POSTAL_VNDR	Character(12)	VARCHAR2(12) NOT NULL	Vendor Postal Code
39	COUNTRY_VNDR	Character(3)	VARCHAR2(3) NOT NULL	Vendor Country
40	EMAILID_VNDR	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
41	BU_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Business unit description.
42	COUNTRY_BU	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Country
43	ADDRESS1_BU	Character(55)	VARCHAR2(55) NOT NULL	BU Address Line 1
44	ADDRESS2_BU	Character(55)	VARCHAR2(55) NOT NULL	BU Address Line 2
45	ADDRESS3_BU	Character(55)	VARCHAR2(55) NOT NULL	BU Address Line 3
46	ADDRESS4_BU	Character(55)	VARCHAR2(55) NOT NULL	BU Address Line 4
47	CITY_BU	Character(30)	VARCHAR2(30) NOT NULL	Business Unit City
48	STATE_BU	Character(6)	VARCHAR2(6) NOT NULL	Business Unit State
49	POSTAL_BU	Character(12)	VARCHAR2(12) NOT NULL	Business Unit Postal Code
50	BU_COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
51	BU_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Buyer Phone
52	BU_EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
53	BU_FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
54	BILLTO_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Bill to descr
55	COUNTRY_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Bill To Country
56	ADDRESS1_BILL	Character(55)	VARCHAR2(55) NOT NULL	Bill to Address Line 1
57	ADDRESS2_BILL	Character(55)	VARCHAR2(55) NOT NULL	Bill to Address Line 2
58	ADDRESS3_BILL	Character(55)	VARCHAR2(55) NOT NULL	Bill to Address Line 3
59	ADDRESS4_BILL	Character(55)	VARCHAR2(55) NOT NULL	Bill to Address Line 4
60	CITY_BILLTO	Character(30)	VARCHAR2(30) NOT NULL	Bill To City
61	STATE_BILLTO	Character(6)	VARCHAR2(6) NOT NULL	Bill To State
62	POSTAL_BILLTO	Character(12)	VARCHAR2(12) NOT NULL	Bill To Postal
63	BILL_COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
64	BILLTO_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Buyer Phone
65	BILLTO_EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
66	BILLTO_FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
67	RATE_DATE	Date(10)	DATE	Exchange Rate Date
68	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
69	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
70	COMMENTS_2000	Long Character	CLOB	Comment Text