VCHR_BATCH_SRC(SQL Table) |
Index Back |
---|---|
AP Voucher Post Run Control |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: VCHR_BATCH_RUN.OPRID |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: VCHR_BATCH_RUN.RUN_CNTL_ID |
3 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL |
Request ID
Default Value: VCHR_BATCH_RUN.REQUEST_ID |
4 | VCHR_BATCH_INTFC | Character(4) | VARCHAR2(4) NOT NULL |
Voucher Build Interfaces
ALL=All Interfaces AMLS=Asset Lease Payments ARCR=Receivables Customer Refunds BILL=Billing Vouchers CNTR=Contracts CONS=Consignment Inventory CUST=Custom Interfaces DCM=Document Management Interface EDI=EDI ERS=Evaluated Receipts (ERS) EXL=Excel Upload (eSettlements) FRE=Real Estate Lease payments GINV=G-Invoicing MTCH=Debit Memo from Matching PAYR=Payroll Interface PBIL=Pay/Bill Management PROC=Procurement Card PRQ=Payment Request QUCK=Quick Invoice RBCR=Vendor Rebates/Claimbacks RETL=Retail Interface Vouchers RTV=Return To Vendor (Supplier) SAD=Student Administration SPRO=Services Procurement SSI=Self Service Invoices TRPM=Promotions Management XLS=Excel Upload (Payables) XML=XML Invoice |
5 | VCHR_BLD_CNT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Contract Voucher Action
B=Build Voucher T=Stage Voucher Default Value: B |
6 | PUB_VCHR_MSG | Character(1) | VARCHAR2(1) NOT NULL |
This field will enable the voucher build process to publish voucher messages to the outside world.
Y/N Table Edit Default Value: N |