PAYLOAD_REQUEST(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | PROCESS_INSTANCE | 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 |