PAYLOAD_REQUEST(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 3 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 4 | LOAD_820 | Character(1) | VARCHAR2(1) NOT NULL |
Load 820
Y/N Table Edit Default Value: N |
| 5 | LOAD_CRX | Character(1) | VARCHAR2(1) NOT NULL |
Load EDIFACT CREEXT
Y/N Table Edit Default Value: N |
| 6 | LOAD_LB | Character(1) | VARCHAR2(1) NOT NULL |
Load Lockbox
Y/N Table Edit Default Value: Y |
| 7 | LOAD_BNK_STMT | Character(1) | VARCHAR2(1) NOT NULL |
Load bank statement
Y/N Table Edit Default Value: N |
| 8 | LOAD_CDR | Character(1) | VARCHAR2(1) NOT NULL |
Cash Drawer Receipts
N=No Y=Yes Y/N Table Edit Default Value: N |
| 9 | LOAD_APP | Character(1) | VARCHAR2(1) NOT NULL |
Accounts Payable Payments
N=No Y=Yes Y/N Table Edit Default Value: N |
| 10 | LOAD_EXCEL_PYMT | Character(1) | VARCHAR2(1) NOT NULL |
Upload from Excel
Y/N Table Edit Default Value: N |
| 11 | DO_MATCH | Character(1) | VARCHAR2(1) NOT NULL |
Match Split Stream Data
Y/N Table Edit Default Value: N |
| 12 | MATCH_TRN | Character(1) | VARCHAR2(1) NOT NULL |
EDI Trace Number
Y/N Table Edit |
| 13 | MATCH_AP | Character(1) | VARCHAR2(1) NOT NULL |
Payment Amount and Payment ID
Y/N Table Edit Default Value: N |
| 14 | MATCH_DAP | Character(1) | VARCHAR2(1) NOT NULL |
Date, Amount and Payment ID
Y/N Table Edit Default Value: N |
| 15 | MATCH_CP | Character(1) | VARCHAR2(1) NOT NULL |
Customer ID and Payment ID
Y/N Table Edit Default Value: N |
| 16 | MATCH_LABEL | Character(1) | VARCHAR2(1) NOT NULL | Match Criteria |
| 17 | MATCH_PAY | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether to match payments already loaded into the system previousely.
N=No Y=Yes Default Value: N |
| 18 | ADD_DT | Date(10) | DATE |
Customer Added On
Default Value: %DATE |