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 |