FEDREG_SETIDS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DUNS_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	DUNS Number
2	CCR_DUNS_PLUS4	Character(4)	VARCHAR2(4) NOT NULL	DUNS Suffix
3	SOURCE_SYSTEM	Character(3)	VARCHAR2(3) NOT NULL	Source System CCR=CCR EBL=eBill Contact Maintenance FED=FED PEN=Pension Customer Default Value: FED
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
5	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	DESCR2	Character(30)	VARCHAR2(30) NOT NULL	Descr2
9	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
10	MESSAGE_TEXT2	Character(100)	VARCHAR2(100) NOT NULL	Message Text
11	DFLT_BEG_SEQ	Character(1)	VARCHAR2(1) NOT NULL	Use default Start Sequence D=Do Not Use Auto Numbering N=Select Start Sequence Y=Use Default Start Sequence Default Value: D
12	BEG_SEQ	Character(3)	VARCHAR2(3) NOT NULL	Beginning Sequence Prompt Table: CUST_PREFIX_VW
13	ZERO_PAD	Character(1)	VARCHAR2(1) NOT NULL	Zero Pad Y/N Table Edit Default Value: Y
14	SUPPORT_TEAM_CD	Character(6)	VARCHAR2(6) NOT NULL	Support Team Code Prompt Table: TEAMCD_SI_EF_VW
15	CR_ANALYST	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer. Prompt Table: CRANAL_SI_EF_VW
16	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments. Prompt Table: COLL_SI_EF_VW
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
18	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Prompt Table: RT_TYPE_TBL
19	TRADING_PARTNER	Character(6)	VARCHAR2(6) NOT NULL	Trading Partner Code
20	CONTACT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Contact SetID
21	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
22	DFLT_BEG_SEQ2	Character(1)	VARCHAR2(1) NOT NULL	Use default Start Sequence D=Do Not Use Auto Numbering N=Select Start Sequence: Y=Use Default Start Sequence Default Value: D
23	BEG_SEQ2	Character(3)	VARCHAR2(3) NOT NULL	Beginning Sequence Prompt Table: CNTCT_PREFIX_VW
24	ZERO_PAD2	Character(1)	VARCHAR2(1) NOT NULL	Zero Pad Y/N Table Edit Default Value: N
25	ACTION_FLG	Character(1)	VARCHAR2(1) NOT NULL	Action Flag A=Action