REMIT_BUREMIT_IDID_SEQ_NUMDefault Value: 1
Prompt Table: DR_FLD_REF_VW
Prompt Table: %EDITTABLE
Prompt Table: %EDITTABLE2
DR_REMIT_REF(SQL Table) |
Index Back |
|---|---|
Draft Remittance Ref Details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REMIT_BU |
Character(5) | VARCHAR2(5) NOT NULL | Remittance Business Unit |
| 2 | REMIT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Remittance ID |
| 3 | ID_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL |
Identification Sequence number
Default Value: 1 |
| 4 | REF_QUALIFIER_CODE | Character(2) | VARCHAR2(2) NOT NULL |
Reference Qualifier Code
Prompt Table: DR_FLD_REF_VW |
| 5 | REF_VALUE | Character(30) | VARCHAR2(30) NOT NULL |
Reference
Prompt Table: %EDITTABLE |
| 6 | REF_VALUE_TO | Character(30) | VARCHAR2(30) NOT NULL |
Range for Reference Value
Prompt Table: %EDITTABLE2 |