EM_APPR_HOPT (SQL Table)	Index Back
Invoice Header AF Option Invoice Header AF Customer Option

EM_APPR_HOPT

(SQL Table)

Invoice Header AF Option

Invoice Header AF Customer Option

# 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 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

3 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_SUPPLIER_EC
06=ITM_SUPP_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
13=EN_REVISION_EC
14=ITEM_MFG_GPO_EC
15=ITEM_MFG_EC
16=ITEM_CAT_EC

4 RECORDNAME2 Character(15) VARCHAR2(15) NOT NULL Record Name 2

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

6 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
N=Inactive
Y=Active
Y/N Table Edit

#	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	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
3	RECORDNAME	Character(15)	VARCHAR2(15) NOT NULL	Record Name 01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_SUPPLIER_EC 06=ITM_SUPP_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 13=EN_REVISION_EC 14=ITEM_MFG_GPO_EC 15=ITEM_MFG_EC 16=ITEM_CAT_EC
4	RECORDNAME2	Character(15)	VARCHAR2(15) NOT NULL	Record Name 2
5	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
6	ACTIVE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Event Status N=Inactive Y=Active Y/N Table Edit