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