DRAFT_ATTACH_VW (SQL View)	Index Back
View for item attachments View for draft worksheet item attachments

DRAFT_ATTACH_VW

(SQL View)

View for item attachments

View for draft worksheet item attachments

SELECT DISTINCT A.GROUP_BU , A.GROUP_ID , A.BUSINESS_UNIT , A.CUST_ID , A.ITEM , A.ITEM_LINE , A.GROUP_SEQ_NUM , A.SCM_ATTACH_ID , A.ATT_VERSION , A.FMS_DTTM_STAMP , A.FMS_OPRID , A.FMS_LASTUPDDTTM , A.FMS_LASTUPDOPRID FROM PS_PENDING_ITM_ATT A , PS_DRAFT_ITEM B WHERE A.BUSINESS_UNIT = B. BUSINESS_UNIT AND A.CUST_ID = B.CUST_ID AND A.ITEM = B.ITEM AND A.ITEM_LINE = B.ITEM_LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GROUP_BU Character(5) VARCHAR2(5) NOT NULL Represents the high level grouping of multiple general ledger business units.

2 GROUP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.

6 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line

7 GROUP_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.

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

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

10 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.

11 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.

12 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.

13 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GROUP_BU	Character(5)	VARCHAR2(5) NOT NULL	Represents the high level grouping of multiple general ledger business units.
2	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
6	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
7	GROUP_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
8	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.
9	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.
10	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
11	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
12	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
13	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.