BI_SCAN_LINE_CH (SQL Table)	Index Back
Billing Scan Line Creation

BI_SCAN_LINE_CH

(SQL Table)

Billing Scan Line Creation

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BI_SCAN_LINE_DEF Character(8) VARCHAR2(8) NOT NULL Billing Scan Line Definition
Prompt Table: BI_SCAN_LINE

2 SCAN_LINE_SEQ_NBR Number(2,0) SMALLINT NOT NULL Scan Line Seq. Nbr

3 PART1_FIELD Character(2) VARCHAR2(2) NOT NULL Part1 Field
A=Amount Due
B=Business Unit
D=Invoice Due Date
E=Emplid
I=Invoice Date
N=Invoice Number
O=External Org Field
P=Postal Code

4 PART1_TYPE Character(1) VARCHAR2(1) NOT NULL Part1 Type
F=Field
S=Sequence Number
T=Text
Default Value: T

5 PART1_STATIC Character(10) VARCHAR2(10) NOT NULL Static 1

6 PART1_SEQ_LENGTH Number(2,0) SMALLINT NOT NULL Part 1 Sequence Length

7 PART1_NUMBER Number(10,0) DECIMAL(10) NOT NULL Part1 Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BI_SCAN_LINE_DEF	Character(8)	VARCHAR2(8) NOT NULL	Billing Scan Line Definition Prompt Table: BI_SCAN_LINE
2	SCAN_LINE_SEQ_NBR	Number(2,0)	SMALLINT NOT NULL	Scan Line Seq. Nbr
3	PART1_FIELD	Character(2)	VARCHAR2(2) NOT NULL	Part1 Field A=Amount Due B=Business Unit D=Invoice Due Date E=Emplid I=Invoice Date N=Invoice Number O=External Org Field P=Postal Code
4	PART1_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Part1 Type F=Field S=Sequence Number T=Text Default Value: T
5	PART1_STATIC	Character(10)	VARCHAR2(10) NOT NULL	Static 1
6	PART1_SEQ_LENGTH	Number(2,0)	SMALLINT NOT NULL	Part 1 Sequence Length
7	PART1_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	Part1 Number