BI_IVC_NUM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IVC_NUM_ID	Character(8)	VARCHAR2(8) NOT NULL	Invoice ID Number
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator 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 1
8	PART2_STATIC	Character(10)	VARCHAR2(10) NOT NULL	Static 2
9	PART3_STATIC	Character(10)	VARCHAR2(10) NOT NULL	Static 3
10	PART1_NEXT_SEQ	Character(10)	VARCHAR2(10) NOT NULL	Part 1 Next Sequence Number
11	PART2_NEXT_SEQ	Character(10)	VARCHAR2(10) NOT NULL	Part 2 Next Sequence number
12	PART3_NEXT_SEQ	Character(10)	VARCHAR2(10) NOT NULL	Part 3 Next Sequence Number
13	PART1_SEQ_LENGTH	Number(2,0)	SMALLINT NOT NULL	Part 1 Sequence Length Default Value: 10
14	PART2_SEQ_LENGTH	Number(2,0)	SMALLINT NOT NULL	Part 2 Sequence Length Default Value: 10
15	PART3_SEQ_LENGTH	Number(2,0)	SMALLINT NOT NULL	Part 3 Sequence Length Default Value: 10
16	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
17	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.
18	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID