JC CIS23 Voucher (JCCIS201)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JCCIS201

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: JC CIS23 Voucher
Physical Name: JCCIS201
Technical Name: JC_CIS23_Voucher

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1JC_CIS_23_Voucher SearchJC CIS 23 VoucherSTR30String30
2VCHNUMWK SearchVoucher Number - WORKSTR17_LBAUString17
3VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['JC CIS23 Voucher'].VENDORID AS 'JC CIS23 Voucher-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       JCCIS201 AS ['JC CIS23 Voucher']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['JC CIS23 Voucher'].VENDORID = ['PM Vendor Master File'].VENDORID
4PRINTED SearchPrintedCBBoolean0

Click to show/hide Printed flag


0	Record has not been printed.
1	Record has been printed.
5Printed_Date SearchPrinted DateDATEDate6
6DOCDATE SearchDocument DateDTDate8
7STSDESCR SearchStatus DescriptionSTR30String30
8PAYDATE SearchPay DateDT6Date6
9USERDEF1 SearchUser Defined 1STR20String20
10USERDEF2 SearchUser Defined 2STR20String20
11USRDEF03 SearchUser Defined 3STR20String20
12USRDEF04 SearchUser Defined 4STR20String20
13USRDEF05 SearchUser Defined 5STR20String20
14User_Defined_CB_1 SearchUser Defined CB 1CBBoolean0
15User_Defined_CB_2 SearchUser Defined CB 2CBBoolean0
16User_Defined_CB_3 SearchUser Defined CB 3CBBoolean0
17User_Defined_CB_4 SearchUser Defined CB 4CBBoolean0
18USRDAT01 SearchUser Defined Date 1DTDate8
19USRDAT02 SearchUser Defined Date 2DTDate8
20User_Defined_Date_3 SearchWS User Defined Date 3DATEDate6
21User_Defined_Date_4 SearchWS User Defined Date 4DATEDate6
22User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency14
23User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency14
24User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency14
25User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency14
26User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer6
27User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer6
28User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer6
29User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer6
30WSReserved_CB1 SearchWSReserved CB1CBBoolean0
31WSReserved_CB2 SearchWSReserved CB2CBBoolean0
32WSReserved_CB3 SearchWSReserved CB3CBBoolean0
33WSReserved_CB4 SearchWSReserved CB4CBBoolean0
34WSReserved_CB5 SearchWSReserved CB5CBBoolean0
35WSReserved_CB6 SearchWSReserved CB6CBBoolean0
36WSReserved_CB7 SearchWSReserved CB7CBBoolean0
37WSReserved_CB8 SearchWSReserved CB8CBBoolean0
38WSReserved_CB9 SearchWSReserved CB9CBBoolean0
39WSReserved_CB10 SearchWSReserved CB10CBBoolean0
40WSReserved_Integer1 SearchWSReserved Integer1INT4Integer4
41WSReserved_Integer2 SearchWSReserved Integer2INT4Integer4
42WSReserved_Integer3 SearchWSReserved Integer3INT4Integer4
43WSReserved_Integer4 SearchWSReserved Integer4INT4Integer4
44WSReserved_Integer5 SearchWSReserved Integer5INT4Integer4
45WSReserved_STR1 SearchWSReserved STR1STR10String10
46WSReserved_STR2 SearchWSReserved STR2STR10String10

Leave a Reply

Your email address will not be published. Required fields are marked *