SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
EXCLUSION_IDPrompt Table: NET_EXCL_PARM
NET_EXCL_PRM_VW(SQL View) |
Index Back |
|---|---|
Netting Exclusion ParametersUser defined exclusion parameters to exclude payments from Netting (AP/AR) - used as a prompt table |
| SELECT SETID , EXCLUSION_ID FROM PS_NET_EXCL_PARM |
| # | 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
Prompt Table: NET_EXCL_PARM |