Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CIS20100
Product: MIS-AMS Extensions (3459)
Series: Purchasing
Display Name: CIS Apply To OPEN OPEN Temporary File
Physical Name: CIS20100
Technical Name: CIS_Apply_To_OPEN_OPENSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 POPRCTNM 
POP Receipt Number STR17_POP_Number String 17 2 KEYSOURC Key Source STR40_Source String 40 3 CISSCOPE CIS In Scope CB_CIS_In_Scope Boolean 0 4 BCHSOURC Batch Source STR15 String 15 5 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['CIS Apply To OPEN OPEN Temporary File'].USERID AS 'CIS Apply To OPEN OPEN Temporary File-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CIS20100 AS ['CIS Apply To OPEN OPEN Temporary File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['CIS Apply To OPEN OPEN Temporary File'].USERID = ['Users Master'].USERID6 APTVCHNM Apply To Voucher Number STR20_LBAU String 20 7 ORIGNONTAX CIS Original Non-taxable Amount DLR17_RBS0_UTR$ Currency 17 8 CISDEDUCT CIS Deducted DLR17_RBS0_STR$ Currency 17 9 APTODCTY Apply To Document Type DDL_Document_Type Integer 0 10 VCHRNMBR Voucher Number STR20_LBAU String 20 Partial key to the PM Key Master File (PM00400).
Click to show/hide
SELECT
['CIS Apply To OPEN OPEN Temporary File'].VCHRNMBR AS 'CIS Apply To OPEN OPEN Temporary File-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
CIS20100 AS ['CIS Apply To OPEN OPEN Temporary File']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['CIS Apply To OPEN OPEN Temporary File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['CIS Apply To OPEN OPEN Temporary File'].DOCTYPE = ['PM Key Master File'].DOCTYPE11 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 Memo12 CISNONTAX CIS Non-taxable Amount DLR17_RBS0_UTR$ Currency 17