AUC_TSK_REQ_ATT (SQL Table)	Index Back
Task Requirement Attachments Task Requirement Attachments record

AUC_TSK_REQ_ATT

(SQL Table)

Task Requirement Attachments

Task Requirement Attachments record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: AUC_BU_ASSGN_VW

2 AUC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Sourcing Planning ID

3 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

4 AUC_TASK_NUM Number(3,0) SMALLINT NOT NULL Task number

5 AUC_TASK_REQ_NUM Number(3,0) SMALLINT NOT NULL Task Requirement Number

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 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: AUC_BU_ASSGN_VW
2	AUC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Sourcing Planning ID
3	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version
4	AUC_TASK_NUM	Number(3,0)	SMALLINT NOT NULL	Task number
5	AUC_TASK_REQ_NUM	Number(3,0)	SMALLINT NOT NULL	Task Requirement Number
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	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.