CIS Payment WORK Virtual (CIS1030V)

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

Product: MIS-AMS Extensions (3459)
Series: Purchasing

Display Name: CIS Payment WORK Virtual
Physical Name: CIS1030V
Technical Name: CIS_Payment_WORK_V

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1BCHSOURC SearchBatch SourceSTR15String1615
2BACHNUMB SearchBatch NumberSTR15_LBAUString1615
3PMNTNMBR SearchPayment NumberSTR20_LBAUString2220
4APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
5CHEKTOTL SearchCheck TotalDLR19_RBS0_UTR$Currency1019
6CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['CIS Payment WORK Virtual'].CHEKBKID AS 'CIS Payment WORK Virtual-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CIS1030V AS ['CIS Payment WORK Virtual']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['CIS Payment WORK Virtual'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
7COMMENT1 SearchComment1STR30String3230
8CNTRLTYP SearchControl TypeINT1Integer21
9CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['CIS Payment WORK Virtual'].CURNCYID AS 'CIS Payment WORK Virtual-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CIS1030V AS ['CIS Payment WORK Virtual']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['CIS Payment WORK Virtual'].CURNCYID = ['Currency Setup'].CURNCYID
10CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency1017
11DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency1017
12DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
13DOCDATE SearchDocument DateDTDate48
14DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
15DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20

Click to show/hide Document Types


1	Invoice
2	Finance Charge
3	Miscellaneous Charges
4	Return
5	Credit Memo
16Electronic SearchElectronicCB_ElectronicBoolean20
17KEYFIELD SearchKey FieldSTR20String2220
18Net_Paid_Amount SearchNet Paid AmountDLR19_RBS0_UTR$Currency1019
19Outstanding_Amount SearchOutstanding AmountDLR19_RBS0_UTR$Currency1019
20PMDSTMSG SearchPM Distribution MessagesML_PM_Distribution_MessagesLong Integer40
21PMWRKMSG SearchPM WORK MessagesML_PM_WORK_MessagesLong Integer40
22PMWRKMS2 SearchPM WORK Messages 2ML_PM_WORK_Messages_2Long Integer40
23POSTEDDT SearchPosted DateDATEDate46
24PSTGDATE SearchPosting DateDTDate48
25TotAmtPaid SearchTotal Amount PaidDLR19_RBS0_UTR$Currency1019
26TotCrdAmt SearchTotal Credit AmountDLR19_RBS0_UTR$Currency1019
27TotCrdDocAmt SearchTotal Credit Document AmountDLR19_RBS0_UTR$Currency1019
28TotDiscTknAmt SearchTotal Discount Taken AmountDLR19_RBS0_UTR$Currency1019
29TotDiscTknTot SearchTotal Discount Taken TotalDLR19_RBS0_UTR$Currency1019
30TotDocAmt SearchTotal Document AmountDLR19_RBS0_STR$Currency1019
31TotalPaidTot SearchTotal Paid TotalDLR19_RBS0_UTR$Currency1019
32TotTotDocAmt SearchTotal Total Document AmountDLR19_RBS0_UTR$Currency1019
33TotWOAmt SearchTotal Write Off AmountDLR19_RBS0_UTR$Currency1019
34TotWOTot SearchTotal Write Off TotalDLR19_RBS0_UTR$Currency1019
35VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString6664
36VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['CIS Payment WORK Virtual'].VENDORID AS 'CIS Payment WORK Virtual-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       CIS1030V AS ['CIS Payment WORK Virtual']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['CIS Payment WORK Virtual'].VENDORID = ['PM Vendor Master File'].VENDORID
37VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
38VOIDED SearchVoidedCBBoolean20
39VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
Partial key to the PM Key Master File (PM00400).

Click to show/hide

SELECT
       ['CIS Payment WORK Virtual'].VCHRNMBR AS 'CIS Payment WORK Virtual-Voucher Number'
       ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
       CIS1030V AS ['CIS Payment WORK Virtual']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['CIS Payment WORK Virtual'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
              AND
                     ['CIS Payment WORK Virtual'].DOCTYPE = ['PM Key Master File'].DOCTYPE
40WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
41CISDEDUCT SearchCIS DeductedDLR17_RBS0_STR$Currency1017
42DEDUCTERR SearchCIS Deduction ErrorSTR255String256255
43CISNONTAX SearchCIS Non-taxable AmountDLR17_RBS0_UTR$Currency1017
44CISTAXABLE SearchCIS Taxable AmountDLR17_RBSO_STR$Currency1017
45CISVCHRNUM SearchCIS Voucher NumberSTR20_LBAUString2220
46CISDOC SearchCIS Document TypeDDL_CIS_Verification StatusInteger20

Leave a Reply

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