[Home] [Help]
View: PSPBV_CLEARING_ACCOUNTS
| Product: | PSP - Labor Distribution |
|---|
| Description: | PSPBV_CLEARING_ACCOUNTS displays information about the General Ledger clearing account used to charge the payroll costs. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT '_KF:SQLGL:GL#:GCC:_CO'
, PCA.COMMENTS
, PCA.BUSINESS_GROUP_ID
, PCA.SET_OF_BOOKS_ID
, PCA.LAST_UPDATE_DATE
, PCA.LAST_UPDATED_BY
, PCA.CREATED_BY
, PCA.CREATION_DATE
FROM PSP_CLEARING_ACCOUNT PCA
, GL_CODE_COMBINATIONS GCC
WHERE PCA.REVERSING_GL_CCID = GCC.CODE_COMBINATION_ID WITH READ ONLY
Columns
| Name |
| "_KF:GL_ACCOUNT" |
| COMMENTS |
| BUSINESS_GROUP_ID |
| SET_OF_BOOKS_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATED_BY |
| CREATION_DATE |