PO_HDR_OUT_EC

(SQL Table)
Index Back

Outbound PO Header staging tab

07/30/2003 mj: ICE #548812000. Added PO_AMT_TTL.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 PO_DT Date(10) DATE Date
5 DB_NUMBER_BU Character(9) VARCHAR2(9) NOT NULL Business Unit D+B Number
6 DESCR_BU Character(30) VARCHAR2(30) NOT NULL Business Unit Description
7 ADDRESS1_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 1
8 ADDRESS2_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 2
9 ADDRESS3_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 3
10 ADDRESS4_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 4
11 CITY_BU Character(30) VARCHAR2(30) NOT NULL Business Unit City
12 STATE_BU Character(6) VARCHAR2(6) NOT NULL Business Unit State
13 POSTAL_BU Character(12) VARCHAR2(12) NOT NULL Business Unit Postal Code
14 COUNTRY_BU Character(3) VARCHAR2(3) NOT NULL Business Unit Country
15 ADDRESS1_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 1
16 ADDRESS2_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 2
17 ADDRESS3_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 3
18 ADDRESS4_BILL Character(55) VARCHAR2(55) NOT NULL Bill to Address Line 4
19 CITY_BILL Character(30) VARCHAR2(30) NOT NULL Bill to City
20 STATE_BILL Character(6) VARCHAR2(6) NOT NULL Bill to State
21 POSTAL_BILL Character(12) VARCHAR2(12) NOT NULL Bill to Postal Code
22 COUNTRY_BILL Character(3) VARCHAR2(3) NOT NULL Bill to Country
23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
24 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
25 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
26 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
27 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
28 STD_ID_NUM_VNDR Character(20) VARCHAR2(20) NOT NULL Vendor ID Number
29 NAME1_VNDR Character(40) VARCHAR2(40) NOT NULL Vendor Name
30 ADDRESS1_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 1
31 ADDRESS2_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 2
32 ADDRESS3_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 3
33 ADDRESS4_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 4
34 CITY_VNDR Character(30) VARCHAR2(30) NOT NULL Vendor City
35 STATE_VNDR Character(6) VARCHAR2(6) NOT NULL Vendor State
36 POSTAL_VNDR Character(12) VARCHAR2(12) NOT NULL Vendor Postal Code
37 COUNTRY_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Country
38 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.
39 DESCR50_PAY Character(50) VARCHAR2(50) NOT NULL Payment Terms Description
40 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
41 PO_AMT_TTL Signed Number(28,3) DECIMAL(26,3) NOT NULL PO Total Amount
42 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
43 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
44 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

Default Value: N

45 TEXT254_CC1 Character(254) VARCHAR2(254) NOT NULL Payment Information
46 TEXT254_CC2 Character(254) VARCHAR2(254) NOT NULL Payment Instructions
47 VNDR_UPN_FLG Character(1) VARCHAR2(1) NOT NULL Vendor Universal Product Number Ready Flag
48 STD_ID_NUM_VNDRGLN Character(20) VARCHAR2(20) NOT NULL Global Location Number
49 STD_ID_NUM_BILLTO Character(20) VARCHAR2(20) NOT NULL Bill To GLN
50 ATTN_TO Character(30) VARCHAR2(30) NOT NULL Attention