STMT_ATTACH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CRSPD_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CRSPD_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Correspondence Customer
3	ST_ID_NUM	Number(8,0)	INTEGER NOT NULL	Statement Number
4	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.
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	SCM_ATTACH_ID	Character(64)	VARCHAR2(64) NOT NULL	The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
7	ST_DT	Date(10)	DATE	Specifies the date a statement (Receivables) is generated. This date is maintained by the Statements SQR.
8	ST_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Statement Type B=Bal Fwd O=Open Item Default Value: O
9	ST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Statement Status A=BF Statement Active I=BF Statement Inactivated Default Value: A
10	INTERNAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Internal Only Flag N=No Y=Yes Y/N Table Edit Default Value: Y
11	ATT_VERSION	Number(3,0)	SMALLINT NOT NULL	The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
12	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
13	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
14	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
15	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.