EM_BUY_REG_CFS

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: FS_CF_TMPLT_VW

3 EM_CF_ACCESS Character(1) VARCHAR2(1) NOT NULL Allows buyer to specify what type of access a supplier will have to chartfields on the self-service invoice. The choices are: No Access, View Access or Edittable Access.
E=Editable
N=No Access
V=Display Only
Default Value: N

4 CF_ORDER Number(2,0) SMALLINT NOT NULL ChartField Sequence Order

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: FS_CF_TMPLT_VW
3	EM_CF_ACCESS	Character(1)	VARCHAR2(1) NOT NULL	Allows buyer to specify what type of access a supplier will have to chartfields on the self-service invoice. The choices are: No Access, View Access or Edittable Access. E=Editable N=No Access V=Display Only Default Value: N
4	CF_ORDER	Number(2,0)	SMALLINT NOT NULL	ChartField Sequence Order