SF1219_1220_SUM (SQL Table)	Index Back
SF1219/1220 Summarize Amount Holds the summarize amount of string id 4.10. This will have the ChartField TSymbol Attribute value and will be use to get the summarized amount of each TSymbol for the creation of the Electronic Format for FMS Forms 1219/1220.

SF1219_1220_SUM

(SQL Table)

SF1219/1220 Summarize Amount

Holds the summarize amount of string id 4.10. This will have the ChartField TSymbol Attribute value and will be use to get the summarized amount of each TSymbol for the creation of the Electronic Format for FMS Forms 1219/1220.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CF_ATTRIB_VALUE Character(20) VARCHAR2(20) NOT NULL ChartField Attribute Value

2 SUM_AMOUNT1 Signed Number(16,0) DECIMAL(15) NOT NULL Signed number with no decimal.

3 SUM_AMOUNT2 Signed Number(16,0) DECIMAL(15) NOT NULL Signed number with no decimals

4 COLLECT_DISBURSE Character(1) VARCHAR2(1) NOT NULL Collection or Disbursement Indicator
C=Collection
D=Disbursement

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CF_ATTRIB_VALUE	Character(20)	VARCHAR2(20) NOT NULL	ChartField Attribute Value
2	SUM_AMOUNT1	Signed Number(16,0)	DECIMAL(15) NOT NULL	Signed number with no decimal.
3	SUM_AMOUNT2	Signed Number(16,0)	DECIMAL(15) NOT NULL	Signed number with no decimals
4	COLLECT_DISBURSE	Character(1)	VARCHAR2(1) NOT NULL	Collection or Disbursement Indicator C=Collection D=Disbursement