CS_PUR_HDR_VW (SQL View)	Index Back
Purch View for SCMT bind maps Date Initials Issue Description ========================================== 05/2007 CEL F-AHAYT-748L7 View for header binds in bind mapping for purchase orders

CS_PUR_HDR_VW

(SQL View)

Purch View for SCMT bind maps

Date Initials Issue Description ========================================== 05/2007 CEL F-AHAYT-748L7 View for header binds in bind mapping for purchase orders

SELECT A.BUSINESS_UNIT , A.PO_ID , 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 , V.NAME1 , V.NAME2 , V.VENDOR_NAME_SHORT , V1.ADDRESS1 , V1.ADDRESS2 , V1.ADDRESS3 , V1.ADDRESS4 , V1.CITY , V1.STATE , V1.COUNTY , V1.COUNTRY , V1.POSTAL , V1.GEO_CODE FROM PS_PO_HDR A , PS_VENDOR V , PS_VENDOR_ADDR V1 WHERE V.SETID = A.VENDOR_SETID AND V.VENDOR_ID = A.VENDOR_ID AND V1.SETID = V.SETID AND V1.VENDOR_ID = V.VENDOR_ID AND V1.ADDRESS_SEQ_NUM = V.ADDR_SEQ_NUM_ORDR AND V1.EFF_STATUS = 'A' AND V1.EFFDT = ( SELECT MAX(V2.EFFDT) FROM PS_VENDOR_ADDR V2 WHERE V2.SETID = V1.SETID AND V2.VENDOR_ID = V1.VENDOR_ID AND V2.ADDRESS_SEQ_NUM = V1.ADDRESS_SEQ_NUM AND V2.EFFDT <= %CurrentDateIn)

# 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
Prompt Table: SP_BU_PM_NONVW

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

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

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

5 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

6 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
Y/N Table Edit
Default Value: N

7 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

8 DISP_ACTION Character(1) VARCHAR2(1) NOT NULL Allow Dispatch When Appr
Y/N Table Edit
Default Value: Y

9 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

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
Prompt Table: VENDOR_PO_VW

15 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
Prompt Table: VNDR_LOC_ORD_VW

16 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID

17 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID

18 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from 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.
Prompt Table: PYMT_TR_EFF_VW

20 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
Prompt Table: %EDIT_BUYER

21 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
Prompt Table: ORIGIN_PO

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

23 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
Default Value: VENDOR.ADDR_SEQ_NUM_ORDR
Prompt Table: VENDOR_ADDR_VW

24 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
Prompt Table: VENDOR_CNTCT_VW

25 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson
Prompt Table: VENDOR_CNTCT_VW

26 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION
Prompt Table: LOCATION_TBL

27 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
Y/N Table Edit
Default Value: BUS_UNIT_TBL_PM.TAX_EXEMPT

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

29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

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

31 MATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Match Action
N=No Match
Y=Standard
Default Value: N

32 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
Prompt Table: %EDITTABLE2

33 MATCH_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Match Status
M=Matched
N=Not Required
P=Partially Matched
T=To Match
Default Value: N

34 MATCH_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Match In Process
I=In Process
N=No
Default Value: N

35 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

36 APPL_JRNL_ID_ENC Character(10) VARCHAR2(10) NOT NULL Encumbrance

37 POST_DOC Character(1) VARCHAR2(1) NOT NULL Post Document
Y/N Table Edit
Default Value: N

38 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
Default Value: BUS_UNIT_OPT_PM.DST_CNTRL_ID
Prompt Table: DST_CNTRL_VW

39 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

40 ENTERED_DT Date(10) DATE Entered on

41 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By

42 APPROVAL_DT Date(10) DATE Date of Approval

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

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

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

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

47 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
Y/N Table Edit
Default Value: N

48 ACTIVITY_DATE Date(10) DATE Last Activity

49 PO_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Post Status
D=Distributed
N=None
Default Value: N

50 NEXT_MOD_SEQ_NBR Number(3,0) SMALLINT NOT NULL Next Modification Number

51 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
N=No
Y=Yes
Default Value: N

52 ACCRUE_USE_TAX Character(1) VARCHAR2(1) NOT NULL Accrue Use Tax
Y/N Table Edit
Default Value: BUS_UNIT_TBL_PM.ACCRUE_USE_TAX

53 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
Prompt Table: CURRENCY_CD_TBL

54 RATE_DATE Date(10) DATE Exchange Rate Date

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

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

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

58 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

59 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

60 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes

61 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator

62 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime

63 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System
Prompt Table: LC_HDR_PO_VW
Set Control Field: BUSINESS_UNIT_GL

64 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

65 PREPAID_PO_FLG Character(1) VARCHAR2(1) NOT NULL Prepaid PO Flag
Y/N Table Edit
Default Value: N

66 PREPAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepaid Amount

67 PREPAID_AUTH_STAT Character(1) VARCHAR2(1) NOT NULL Prepaid Authorization Status
A=Authorized
N=Not Approved
P=Pending Authorization
Default Value: N

68 PREPAID_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Prepaid PO Status
N=Not Processed
P=Processing
V=Vouchered
Default Value: N

69 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

70 TERMS_BASIS_DT Date(10) DATE Payment Terms Basis Date

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

72 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
E=Error
N=Not Checked
R=Reset
V=Valid
Default Value: V

73 MID_ROLL_STATUS Character(1) VARCHAR2(1) NOT NULL Mid Roll Status

74 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1

75 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1

76 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2

77 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3

78 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4

79 CUSTOM_DATE_A Date(10) DATE Custom Date

80 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2

81 BUDGET_CHECK Character(1) VARCHAR2(1) NOT NULL Budget Checked
N=No
Y=Yes
Y/N Table Edit
Default Value: N

82 CC_SECURITY_ID Number(10,0) DECIMAL(10) NOT NULL Procurement Card Number

83 CC_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Use Procurement Card
Y/N Table Edit
Default Value: N

84 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
Default Value: A

85 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.

86 CONTACT_PHONE Character(24) VARCHAR2(24) NOT NULL Recepient Phone

87 TEXT254_CC2 Character(254) VARCHAR2(254) NOT NULL Payment Instructions

88 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

89 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

90 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2

91 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

92 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

93 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

94 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

95 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

96 CITY Character(30) VARCHAR2(30) NOT NULL City

97 STATE Character(6) VARCHAR2(6) NOT NULL State

98 COUNTY Character(30) VARCHAR2(30) NOT NULL County

99 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

100 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

101 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

#	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 Prompt Table: SP_BU_PM_NONVW
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Default Value: NEXT
3	CHNG_ORD_BATCH	Number(3,0)	SMALLINT NOT NULL	Change Order Number
4	PO_TYPE	Character(4)	VARCHAR2(4) NOT NULL	PO Type GEN=General KAN=Kanban Default Value: GEN
5	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
6	HOLD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Hold From Further Processing Y/N Table Edit Default Value: N
7	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
8	DISP_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Allow Dispatch When Appr Y/N Table Edit Default Value: Y
9	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
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 Prompt Table: VENDOR_PO_VW
15	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VNDR_LOC_ORD_VW
16	PRICE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Price From Vendor SetID
17	PRICE_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Price Vendor ID
18	PRICE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Price from 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. Prompt Table: PYMT_TR_EFF_VW
20	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: %EDIT_BUYER
21	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin Prompt Table: ORIGIN_PO
22	CHNG_ORD_SEQ	Number(3,0)	SMALLINT NOT NULL	Change Order Sequence Number
23	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Default Value: VENDOR.ADDR_SEQ_NUM_ORDR Prompt Table: VENDOR_ADDR_VW
24	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Prompt Table: VENDOR_CNTCT_VW
25	SALES_CNTCT_SEQ_N	Number(3,0)	SMALLINT NOT NULL	Salesperson Prompt Table: VENDOR_CNTCT_VW
26	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION Prompt Table: LOCATION_TBL
27	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit Default Value: BUS_UNIT_TBL_PM.TAX_EXEMPT
28	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID
29	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
30	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.
31	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action N=No Match Y=Standard Default Value: N
32	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule Prompt Table: %EDITTABLE2
33	MATCH_STATUS_PO	Character(1)	VARCHAR2(1) NOT NULL	Match Status M=Matched N=Not Required P=Partially Matched T=To Match Default Value: N
34	MATCH_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Match In Process I=In Process N=No Default Value: N
35	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
36	APPL_JRNL_ID_ENC	Character(10)	VARCHAR2(10) NOT NULL	Encumbrance
37	POST_DOC	Character(1)	VARCHAR2(1) NOT NULL	Post Document Y/N Table Edit Default Value: N
38	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template Default Value: BUS_UNIT_OPT_PM.DST_CNTRL_ID Prompt Table: DST_CNTRL_VW
39	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
40	ENTERED_DT	Date(10)	DATE	Entered on
41	OPRID_APPROVED_BY	Character(30)	VARCHAR2(30) NOT NULL	Approved By
42	APPROVAL_DT	Date(10)	DATE	Date of Approval
43	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.
44	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.
45	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
46	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL
47	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Y/N Table Edit Default Value: N
48	ACTIVITY_DATE	Date(10)	DATE	Last Activity
49	PO_POST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Post Status D=Distributed N=None Default Value: N
50	NEXT_MOD_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Next Modification Number
51	ERS_ACTION	Character(1)	VARCHAR2(1) NOT NULL	ERS Action N=No Y=Yes Default Value: N
52	ACCRUE_USE_TAX	Character(1)	VARCHAR2(1) NOT NULL	Accrue Use Tax Y/N Table Edit Default Value: BUS_UNIT_TBL_PM.ACCRUE_USE_TAX
53	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency Prompt Table: CURRENCY_CD_TBL
54	RATE_DATE	Date(10)	DATE	Exchange Rate Date
55	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
56	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
57	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.
58	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
59	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
60	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control source transaction override flag N=No Y=Yes
61	KK_TRAN_OVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Commitment Control source transaction override operator
62	KK_TRAN_OVER_DTTM	DateTime(26)	TIMESTAMP	Commitment Control source transaction override datetime
63	LC_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Letter of Credit Number Assigned by the System Prompt Table: LC_HDR_PO_VW Set Control Field: BUSINESS_UNIT_GL
64	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
65	PREPAID_PO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prepaid PO Flag Y/N Table Edit Default Value: N
66	PREPAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Prepaid Amount
67	PREPAID_AUTH_STAT	Character(1)	VARCHAR2(1) NOT NULL	Prepaid Authorization Status A=Authorized N=Not Approved P=Pending Authorization Default Value: N
68	PREPAID_STATUS_PO	Character(1)	VARCHAR2(1) NOT NULL	Prepaid PO Status N=Not Processed P=Processing V=Vouchered Default Value: N
69	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
70	TERMS_BASIS_DT	Date(10)	DATE	Payment Terms Basis Date
71	BACKORDER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Back Order Status 1=Not Backordered 2=Backordered 3=Backordered Received Default Value: 1
72	DOC_TOL_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Document Heade Document Tolerance Status E=Error N=Not Checked R=Reset V=Valid Default Value: V
73	MID_ROLL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Mid Roll Status
74	USER_HDR_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
75	CUSTOM_C100_A1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
76	CUSTOM_C100_A2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
77	CUSTOM_C100_A3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
78	CUSTOM_C100_A4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
79	CUSTOM_DATE_A	Date(10)	DATE	Custom Date
80	CUSTOM_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
81	BUDGET_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Budget Checked N=No Y=Yes Y/N Table Edit Default Value: N
82	CC_SECURITY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Procurement Card Number
83	CC_USE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Use Procurement Card Y/N Table Edit Default Value: N
84	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 Default Value: A
85	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
86	CONTACT_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Recepient Phone
87	TEXT254_CC2	Character(254)	VARCHAR2(254) NOT NULL	Payment Instructions
88	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
89	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
90	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
91	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
92	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
93	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
94	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
95	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
96	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
97	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
98	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
99	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
100	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
101	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code