POBUILD_APPR (SQL Table)	Index Back
Approval Options for PO Build

POBUILD_APPR

(SQL Table)

Approval Options for PO Build

# 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_PROCESS_ID Character(3) VARCHAR2(3) NOT NULL Shows the process that created the row on the stage table
CON=Contract Releases
CRT=PAR Location Replenishment
OLS=Manual / Expedite Requisitions
OMR=Order Management Referenced
PLL=Planning System
RFQ=Request for Quotation
SFL=Production/Shop Floor
SPO=Services Work Order
SRC=AutoSelect / Quick Source
WKM=Work Order Management

3 PO_AMT_APPR_NEEDED Character(1) VARCHAR2(1) NOT NULL PO Amount Approval Needed
Y/N Table Edit
Default Value: N

4 PO_CF_APPR_NEEDED Character(1) VARCHAR2(1) NOT NULL PO ChartField Approval Needed
Y/N Table Edit
Default Value: N

#	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_PROCESS_ID	Character(3)	VARCHAR2(3) NOT NULL	Shows the process that created the row on the stage table CON=Contract Releases CRT=PAR Location Replenishment OLS=Manual / Expedite Requisitions OMR=Order Management Referenced PLL=Planning System RFQ=Request for Quotation SFL=Production/Shop Floor SPO=Services Work Order SRC=AutoSelect / Quick Source WKM=Work Order Management
3	PO_AMT_APPR_NEEDED	Character(1)	VARCHAR2(1) NOT NULL	PO Amount Approval Needed Y/N Table Edit Default Value: N
4	PO_CF_APPR_NEEDED	Character(1)	VARCHAR2(1) NOT NULL	PO ChartField Approval Needed Y/N Table Edit Default Value: N