DR_DISHONOR_BUDefault Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table: SP_BUARDH_NONVW
DR_DISHONOR_IDDefault Value: NEXT
C=Worksheet Created
K=Complete
L=Cancelled
N=Not Processed
DR_VOID_SRCH(SQL View) |
Index Back |
|---|---|
Cancel Remittance Search |
| SELECT DR_DISHONOR_BU ,DR_DISHONOR_ID ,DR_DISHONOR_STATUS FROM PS_DR_DISH_CNTL WHERE DR_DISHONOR_TYPE = 'V' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DR_DISHONOR_BU |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDH_NONVW |
| 2 | DR_DISHONOR_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Void Worksheet ID
Default Value: NEXT |
| 3 | DR_DISHONOR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
C=Worksheet Created K=Complete L=Cancelled N=Not Processed |