KK_ALOG_PO4_VW6(SQL View) |
Index Back |
---|---|
ProCard-Acct Period Prompt |
SELECT DISTINCT A.ACCOUNTING_PERIOD FROM PS_KK_SOURCE_HDR A , PS_KK_ACTIVITY_LOG B WHERE A.KK_TRAN_ID = B.KK_TRAN_ID AND A.KK_TRAN_DT = B.KK_TRAN_DT AND A.KK_SOURCE_TRAN IN ('PO_RAENC' ,'PO_RAEXP' ) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |