SSF_RUN_GP_NLD(SQL Table) | 
Index Back | 
|---|---|
Run control Verwinfo NLDRun control record for load of Verwinfo payments file NLD | 
| # | 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | 
Business Unit
 Prompt Table: SP_BU_SF_NONVW  | 
| 4 | GROUP_TYPE | Character(1) | VARCHAR2(1) NOT NULL | 
Group Type
 Prompt Table:
GROUP_TYPE_TBL
  | 
| 5 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name | 
| 6 | SSF_FILEDIRF_NLD | Character(254) | VARCHAR2(254) NOT NULL | File Directory | 
| 7 | BALANCE_GRP | Character(1) | VARCHAR2(1) NOT NULL | 
Balance the Group
 Y/N Table Edit  | 
| 8 | RECON_LAYOUT_ID | Character(8) | VARCHAR2(8) NOT NULL | 
Input File Layout ID
 Prompt Table:
SSF_BNK_IN_B_VW
  | 
| 9 | RPT_ONLY | Character(1) | VARCHAR2(1) NOT NULL | 
Report Only
 N=No Y=Yes  | 
| 10 | SSF_RESTRICT_INV | Character(1) | VARCHAR2(1) NOT NULL | 
This field indicates that the payment will be held until an invoice is provided.
 Y/N Table Edit  |