| # |
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 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 3 |
DR_DISHONOR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Worksheet ID
Default Value: NEXT
|
| 4 |
DR_DISHONOR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status
C=Worksheet Created
K=Complete
L=Cancelled
N=Not Processed
Default Value: N
|
| 5 |
DR_DISHONOR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Dishonor Type
C=Cancel Remittance
D=Dishonor
V=Void Draft
|
| 6 |
WS_DTTM |
DateTime(26) |
TIMESTAMP |
Worksheet Created Date/Time
|
| 7 |
DR_DISHONOR_CNT |
Number(5,0) |
INTEGER NOT NULL |
Dishonor Draft Count
|
| 8 |
DR_DISHONOR_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Dishonor Amount
|
| 9 |
DR_DISHONOR_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
Dishonor Currency Code
|
| 10 |
WS_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Worksheet Items
|
| 11 |
RMT_CUST_OPTNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Options
C=Customer Drafts
N=None
Default Value: N
|
| 12 |
RMT_DATE_OPTNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Remit Date Options
A=Accounting Date Range
N=None
R=Due Date Range
Default Value: N
|
| 13 |
DATE_DEPEND_ON |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Dependent On
B=Draft & Cust
C=Customer Only
D=Draft Only
N=All Drafts
Default Value: N
|
| 14 |
RMT_DRAFT_OPTNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Options
D=Draft Value
N=None
Default Value: N
|
| 15 |
DR_RMT_BANK_OPTNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Bank Options
B=Bank Account
N=None
Default Value: N
|
| 16 |
DR_BANK_DEPEND_ON |
Character(1) |
VARCHAR2(1) NOT NULL |
Bank Dependent On
A=Cust & Date
C=Customer Only
D=Date Range Only
I=Draft Only
N=All Drafts
Default Value: N
|
| 17 |
DR_STATUS_OPTNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Status Options
N=None
S=Draft Status
Default Value: N
|
| 18 |
DR_STAT_DEPEND_ON |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Dependent On
A=Cust & Date
C=Customer Only
D=Date Range Only
I=Draft Only
N=All Drafts
Default Value: N
|