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_VSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BCHSOURC 
Batch Source STR15 String 15 2 BACHNUMB Batch Number STR15_LBAU String 15 3 PMNTNMBR Payment Number STR20_LBAU String 20 4 APPLDAMT Applied Amount DLR17_RBS0_STR$ Currency 17 5 CHEKTOTL Check Total DLR19_RBS0_UTR$ Currency 19 6 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 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'].CHEKBKID7 COMMENT1 Comment1 STR30 String 30 8 CNTRLTYP Control Type INT1 Integer 1 9 CURNCYID Currency ID STR15_Currency_ID String 15 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'].CURNCYID10 CURTRXAM Current Trx Amount DLR17_RBS0_UTR$ Currency 17 11 DISAMTAV Discount Amount Available DLR17_RBS0_UTR$ Currency 17 12 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 13 DOCDATE Document Date DT Date 8 14 DOCNUMBR Document Number STR20_Document_Number String 20 15 DOCTYPE Document Type DDL_Document_Type Integer 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo16 Electronic Electronic CB_Electronic Boolean 0 17 KEYFIELD Key Field STR20 String 20 18 Net_Paid_Amount Net Paid Amount DLR19_RBS0_UTR$ Currency 19 19 Outstanding_Amount Outstanding Amount DLR19_RBS0_UTR$ Currency 19 20 PMDSTMSG PM Distribution Messages ML_PM_Distribution_Messages Long Integer 0 21 PMWRKMSG PM WORK Messages ML_PM_WORK_Messages Long Integer 0 22 PMWRKMS2 PM WORK Messages 2 ML_PM_WORK_Messages_2 Long Integer 0 23 POSTEDDT Posted Date DATE Date 6 24 PSTGDATE Posting Date DT Date 8 25 TotAmtPaid Total Amount Paid DLR19_RBS0_UTR$ Currency 19 26 TotCrdAmt Total Credit Amount DLR19_RBS0_UTR$ Currency 19 27 TotCrdDocAmt Total Credit Document Amount DLR19_RBS0_UTR$ Currency 19 28 TotDiscTknAmt Total Discount Taken Amount DLR19_RBS0_UTR$ Currency 19 29 TotDiscTknTot Total Discount Taken Total DLR19_RBS0_UTR$ Currency 19 30 TotDocAmt Total Document Amount DLR19_RBS0_STR$ Currency 19 31 TotalPaidTot Total Paid Total DLR19_RBS0_UTR$ Currency 19 32 TotTotDocAmt Total Total Document Amount DLR19_RBS0_UTR$ Currency 19 33 TotWOAmt Total Write Off Amount DLR19_RBS0_UTR$ Currency 19 34 TotWOTot Total Write Off Total DLR19_RBS0_UTR$ Currency 19 35 VNDCHKNM Vendor Check Name STR64_Vendor_Name String 64 36 VENDORID Vendor ID STR_15_Vendor_ID String 15 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'].VENDORID37 VENDNAME Vendor Name STR64_Vendor_Name String 64 38 VOIDED Voided CB Boolean 0 39 VCHRNMBR Voucher Number STR20_LBAU String 20 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'].DOCTYPE40 WROFAMNT Write Off Amount DLR17_RBS0_STR$ Currency 17 41 CISDEDUCT CIS Deducted DLR17_RBS0_STR$ Currency 17 42 DEDUCTERR CIS Deduction Error STR255 String 255 43 CISNONTAX CIS Non-taxable Amount DLR17_RBS0_UTR$ Currency 17 44 CISTAXABLE CIS Taxable Amount DLR17_RBSO_STR$ Currency 17 45 CISVCHRNUM CIS Voucher Number STR20_LBAU String 20 46 CISDOC CIS Document Type DDL_CIS_Verification Status Integer 0