DD_WORKSHEET_IDDD_RQST_SEQUENCEDD_BUDD_IDSCM_ATTACH_IDATT_VERSIONDD_WS_ATT_VW(SQL View) |
Index Back |
|---|---|
View for dd attachmentsView for direct debit attachments |
| SELECT DD.DD_WORKSHEET_ID , DD.DD_RQST_SEQUENCE , DD.DD_BU , DD.DD_ID , ATT.SCM_ATTACH_ID , ATT.ATT_VERSION , ATT.FMS_DTTM_STAMP , ATT.FMS_OPRID , ATT.FMS_LASTUPDDTTM , ATT.FMS_LASTUPDOPRID FROM PS_DD_CONTROL DD , PS_DD_WS_ATT ATT WHERE DD.DD_BU = ATT.BUSINESS_UNIT AND DD.DD_WORKSHEET_ID = ATT.DD_WORKSHEET_ID AND DD.DD_RQST_SEQUENCE = ATT.DD_RQST_SEQUENCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DD_WORKSHEET_ID |
Number(10,0) | DECIMAL(10) NOT NULL | DD Worksheet Id |
| 2 | DD_RQST_SEQUENCE |
Number(5,0) | INTEGER NOT NULL | Request Sequence Number |
| 3 | DD_BU |
Character(5) | VARCHAR2(5) NOT NULL | Specifies the business unit to which a direct debit is posted. This field is maintained by the Direct debit generation process. |
| 4 | DD_ID |
Character(15) | VARCHAR2(15) NOT NULL | Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process. |
| 5 | 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. |
| 6 | 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. |
| 7 | FMS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the original entry. |
| 8 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
| 9 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 10 | FMS_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |