BI_IVC_NUM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IVC_NUM_ID	Character(8)	VARCHAR2(8) NOT NULL	Invoice Number ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	STATUS_BI	Character(1)	VARCHAR2(1) NOT NULL	Status A=Active I=Inactive Default Value: A
4	PART1_OPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Part 1 Options A=Auto Sequenced N=None S=Static Default Value: A
5	PART2_OPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Part 2 Options A=Auto Sequenced N=None S=Static Default Value: S
6	PART3_OPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Part 3 Options A=Auto Sequenced N=None S=Static Default Value: S
7	PART1_STATIC	Character(10)	VARCHAR2(10) NOT NULL	Static Prefix
8	PART2_STATIC	Character(10)	VARCHAR2(10) NOT NULL	Static Middle
9	PART3_STATIC	Character(10)	VARCHAR2(10) NOT NULL	Static Suffix
10	PART1_NEXT_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Part 1 Next Sequence
11	PART2_NEXT_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Part 2 Next Sequence
12	PART3_NEXT_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Part 3 Next Sequence
13	PART1_AUTOFILL	Character(1)	VARCHAR2(1) NOT NULL	Part 1 AutoFill Checkbox Y/N Table Edit Default Value: Y
14	PART2_AUTOFILL	Character(1)	VARCHAR2(1) NOT NULL	Part 2 Autofill Checkbox Y/N Table Edit Default Value: Y
15	PART3_AUTOFILL	Character(1)	VARCHAR2(1) NOT NULL	Part 3 Autofill Checkbox Y/N Table Edit Default Value: Y
16	PART1_SEQ_LENGTH	Number(2,0)	SMALLINT NOT NULL	Part 1 Sequence Length Default Value: 10
17	PART2_SEQ_LENGTH	Number(2,0)	SMALLINT NOT NULL	Part 2 Sequence Length Default Value: 10
18	PART3_SEQ_LENGTH	Number(2,0)	SMALLINT NOT NULL	Part 3 Sequence Length Default Value: 10
19	USER_DEF_NEW_CHKBX	Character(1)	VARCHAR2(1) NOT NULL	User definable for new bills Y/N Table Edit Default Value: N
20	USER_DEF_ADJ_CHKBX	Character(1)	VARCHAR2(1) NOT NULL	User Definable for Adjustments Y/N Table Edit Default Value: N
21	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
22	LAST_UPDATE_DTTM	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.
23	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID