VCHR_BLD_RQST(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). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once Default Value: N |
6 | VCHR_BLD_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Build Option
A=Process all business units B=Process entered business units Default Value: A |
7 | VCHR_BLD_ADJ_IND | Character(1) | VARCHAR2(1) NOT NULL |
Process adjustments
Y/N Table Edit Default Value: N |
8 | VCHR_BLD_ALL_IND | Character(1) | VARCHAR2(1) NOT NULL |
Process all for Voucher Build
Y/N Table Edit Default Value: N |
9 | VCHR_BLD_CNT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Process contracts
Y/N Table Edit Default Value: N |
10 | VCHR_BLD_EDI_IND | Character(1) | VARCHAR2(1) NOT NULL |
Process EDI records
Y/N Table Edit Default Value: N |
11 | VCHR_BLD_ERS_IND | Character(1) | VARCHAR2(1) NOT NULL |
Process ERS
Y/N Table Edit Default Value: N |
12 | VCHR_BLD_HRP_IND | Character(1) | VARCHAR2(1) NOT NULL |
Process Payroll
Y/N Table Edit Default Value: N |
13 | VCHR_BLD_INV_IND | Character(1) | VARCHAR2(1) NOT NULL |
Process consignment(inventory)
Y/N Table Edit Default Value: N |
14 | VCHR_BLD_QVP_IND | Character(1) | VARCHAR2(1) NOT NULL |
Process quick invoice
Y/N Table Edit Default Value: N |
15 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
16 | VCHR_BLD_CNT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Contract Voucher Action
B=Build Voucher T=Stage Voucher Default Value: T |
17 | VCHR_BLD_TD_IND | Character(1) | VARCHAR2(1) NOT NULL |
Promotions Management
Y/N Table Edit Default Value: N |