SAC_SS_ERP_HD_V

(SQL View)
 Index Back

Hdr View


SELECT A.BUSINESS_UNIT ,A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION ,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.BIDNUM ,A.BIDDER_TYPE , A.AUC_AWARD_NBR ,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.PHONE ,A.FAX ,A.NAME1 ,A.ADDRESS1 ,A.ADDRESS2 ,A.CITY ,A.STATE ,A.POSTAL ,A.COUNTRY ,A.EMAILID ,B.DESCR ,B.COUNTRY ,B.ADDRESS1 ,B.ADDRESS2 ,B.ADDRESS3 ,B.ADDRESS4 ,B.CITY ,B.STATE ,B.POSTAL ,B.COUNTRY_CODE ,B.PHONE ,B.EXTENSION ,B.FAX ,C.DESCR ,C.COUNTRY ,C.ADDRESS1 ,C.ADDRESS2 ,C.ADDRESS3 ,C.ADDRESS4 ,C.CITY ,C.STATE ,C.POSTAL ,C.COUNTRY_CODE ,C.PHONE ,C.EXTENSION ,C.FAX FROM PS_SAC_SS_HDR_VW A , PS_SAC_SS_BILTO_VW B , PS_SAC_SS_BUDAT_VW C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.AUC_ID = C.AUC_ID AND A.AUC_ROUND = C.AUC_ROUND AND A.AUC_VERSION = C.AUC_VERSION

# 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 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
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 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
14 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
15 AUC_AWARD_NBR Number(3,0) SMALLINT NOT NULL Award Number
16 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
17 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
18 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
19 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.
20 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
21 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
22 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location

Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION

23 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Default Value: BUS_UNIT_TBL_PM.TAX_EXEMPT

24 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD

26 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
27 ENTERED_DT Date(10) DATE Entered on
28 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.
29 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.
30 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
31 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL

32 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.
33 BACKORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Back Order Status
1=Not Backordered
2=Backordered
3=Backordered Received

Default Value: 1

34 VENDOR_PHONE Character(24) VARCHAR2(24) NOT NULL Buyer Phone
35 VENDOR_FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
36 NAME1_VNDR Character(40) VARCHAR2(40) NOT NULL Vendor Name
37 ADDRESS1_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 1
38 ADDRESS2_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 2
39 CITY_VNDR Character(30) VARCHAR2(30) NOT NULL Vendor City
40 STATE_VNDR Character(6) VARCHAR2(6) NOT NULL Vendor State
41 POSTAL_VNDR Character(12) VARCHAR2(12) NOT NULL Vendor Postal Code
42 COUNTRY_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Country
43 EMAILID_VNDR Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
44 BU_DESCR Character(30) VARCHAR2(30) NOT NULL Business unit description.
45 COUNTRY_BU Character(3) VARCHAR2(3) NOT NULL Business Unit Country
46 ADDRESS1_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 1
47 ADDRESS2_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 2
48 ADDRESS3_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 3
49 ADDRESS4_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 4
50 CITY_BU Character(30) VARCHAR2(30) NOT NULL Business Unit City
51 STATE_BU Character(6) VARCHAR2(6) NOT NULL Business Unit State
52 POSTAL_BU Character(12) VARCHAR2(12) NOT NULL Business Unit Postal Code
53 BU_COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
54 BU_PHONE Character(24) VARCHAR2(24) NOT NULL Buyer Phone
55 BU_EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
56 BU_FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
57 BILLTO_DESCR Character(30) VARCHAR2(30) NOT NULL Bill to descr
58 COUNTRY_BILLTO Character(3) VARCHAR2(3) NOT NULL Bill To Country
59 ADDRESS1_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 1
60 ADDRESS2_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 2
61 ADDRESS3_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 3
62 ADDRESS4_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 4
63 CITY_BILLTO Character(30) VARCHAR2(30) NOT NULL Bill To City
64 STATE_BILLTO Character(6) VARCHAR2(6) NOT NULL Bill To State
65 POSTAL_BILLTO Character(12) VARCHAR2(12) NOT NULL Bill To Postal
66 BILL_COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
67 BILLTO_PHONE Character(24) VARCHAR2(24) NOT NULL Buyer Phone
68 BILLTO_EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
69 BILLTO_FAX Character(24) VARCHAR2(24) NOT NULL Fax Number