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 TypeSQL DB LengthKeyable Length
1JC_CIS_23_Voucher SearchJC CIS 23 VoucherSTR30String3230
2VCHNUMWK SearchVoucher Number - WORKSTR17_LBAUString1817
3VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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 SearchPrintedCBBoolean20

Click to show/hide Printed flag


0	Record has not been printed.
1	Record has been printed.
5Printed_Date SearchPrinted DateDATEDate46
6DOCDATE SearchDocument DateDTDate48
7STSDESCR SearchStatus DescriptionSTR30String3230
8PAYDATE SearchPay DateDT6Date46
9USERDEF1 SearchUser Defined 1STR20String2220
10USERDEF2 SearchUser Defined 2STR20String2220
11USRDEF03 SearchUser Defined 3STR20String2220
12USRDEF04 SearchUser Defined 4STR20String2220
13USRDEF05 SearchUser Defined 5STR20String2220
14User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
15User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
16User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
17User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
18USRDAT01 SearchUser Defined Date 1DTDate48
19USRDAT02 SearchUser Defined Date 2DTDate48
20User_Defined_Date_3 SearchWS User Defined Date 3DATEDate46
21User_Defined_Date_4 SearchWS User Defined Date 4DATEDate46
22User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
23User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
24User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
25User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
26User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
27User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
28User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
29User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
30WSReserved_CB1 SearchWSReserved CB1CBBoolean20
31WSReserved_CB2 SearchWSReserved CB2CBBoolean20
32WSReserved_CB3 SearchWSReserved CB3CBBoolean20
33WSReserved_CB4 SearchWSReserved CB4CBBoolean20
34WSReserved_CB5 SearchWSReserved CB5CBBoolean20
35WSReserved_CB6 SearchWSReserved CB6CBBoolean20
36WSReserved_CB7 SearchWSReserved CB7CBBoolean20
37WSReserved_CB8 SearchWSReserved CB8CBBoolean20
38WSReserved_CB9 SearchWSReserved CB9CBBoolean20
39WSReserved_CB10 SearchWSReserved CB10CBBoolean20
40WSReserved_Integer1 SearchWSReserved Integer1INT4Integer24
41WSReserved_Integer2 SearchWSReserved Integer2INT4Integer24
42WSReserved_Integer3 SearchWSReserved Integer3INT4Integer24
43WSReserved_Integer4 SearchWSReserved Integer4INT4Integer24
44WSReserved_Integer5 SearchWSReserved Integer5INT4Integer24
45WSReserved_STR1 SearchWSReserved STR1STR10String1210
46WSReserved_STR2 SearchWSReserved STR2STR10String1210

Leave a Reply

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