RECV_RUN_CNTL(SQL Table) |
Index Back |
---|---|
Receiving AE 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 | AUTOGEN_LBL | Character(1) | VARCHAR2(1) NOT NULL |
Autogenerate Labels
Y/N Table Edit Default Value: N |
4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_RECV1_NONVW |
5 | CLOSE_DELAY_DAYS | Signed Number(6,0) | DECIMAL(5) NOT NULL | Close Processing Delay Days |
6 | FILE_DIRECTORY | Character(80) | VARCHAR2(80) NOT NULL | File Directory |
7 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
8 | LABEL_FORMAT_ID | Character(30) | VARCHAR2(30) NOT NULL |
Format ID
Prompt Table: BCT_PO_RCV_VW |
9 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
10 | NUMBER_OF_LABELS | Number(3,0) | SMALLINT NOT NULL |
Nbr of Labels
Default Value: 1 |
11 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Receiver number
Prompt Table: %EDITTABLE2 |
12 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
13 | RECV_OPT_FLG | Number(3,0) | SMALLINT NOT NULL | Receipt Process Options |
14 | DATETIME_MODIFIED | DateTime(26) | TIMESTAMP | Datetime Modified |
15 | PRINT_LABEL_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Printing Selection
1=Pick Batch ID 2=Order Number 3=Generate 4=Reprint 5=Par Location 6=Item ID 7=All Unprocessed Receipts 8=Print Specific Receipt |
16 | USG_LBL_FORMAT_ID | Character(30) | VARCHAR2(30) NOT NULL |
Item Usage Label Format
Prompt Table: BCT_USG_INV_VW |
17 | NBR_COPIES | Number(3,0) | SMALLINT NOT NULL |
Number of Copies
Default Value: 1 |
18 | USG_LBL_OVER_FILE | Character(1) | VARCHAR2(1) NOT NULL |
Override File
Y/N Table Edit Default Value: N |
19 | USG_LBL_FILE_DIR | Character(80) | VARCHAR2(80) NOT NULL | File Directory |
20 | USG_LBL_FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
21 | USG_RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Receipt ID
Prompt Table: RECV_RC_VW3 |
22 | BATCH_LOCATION | Character(1) | VARCHAR2(1) NOT NULL |
Batch Location
R=Run Control Page W=WorkBench Page |
23 | WORKBENCH_ID | Character(10) | VARCHAR2(10) NOT NULL | WorkBench ID |