SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
EXCLUSION_IDAPPLICATION_IDAP=Accounts Payable
AR=Accounts Receivable
EX=Expenses
EFFDTDefault Value: %date
CHARTFIELDNET_EXCL_CF_VW(SQL View) |
Index Back |
|---|---|
Netting exclusion viewThis view is used to determine if Chartfield netting exclusion parameters have been defined. At voucher save, this code will check the cf values on the DISTRIB_LINE if the voucher is to be netted. If there are netting exclusion parameters (chartfields), this view is used to check DISTRIB_LINE for values that may constiture the voucher to not be netted. |
| SELECT A.SETID , A.EXCLUSION_ID , A.APPLICATION_ID , A.EFFDT , A.CHARTFIELD , A.CHARTFIELD_VALUE FROM PS_NET_EXCL_PRM_CF A , PS_NET_EXCL_PARM B WHERE A.APPLICATION_ID = 'AP' AND A.EXCLUSION_ID = B.EXCLUSION_ID AND A.APPLICATION_ID = B.APPLICATION_ID AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_NET_EXCL_PRM_CF C WHERE A.SETID = C.SETID AND A.EXCLUSION_ID = C.EXCLUSION_ID AND A.APPLICATION_ID = C.APPLICATION_ID AND C.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | EXCLUSION_ID |
Character(12) | VARCHAR2(12) NOT NULL | Exclusion ID |
| 3 | APPLICATION_ID |
Character(2) | VARCHAR2(2) NOT NULL |
Application ID
AP=Accounts Payable AR=Accounts Receivable EX=Expenses |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | CHARTFIELD |
Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 6 | CHARTFIELD_VALUE | Character(30) | VARCHAR2(30) NOT NULL | ChartField Value |