Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CIS40000
Product: MIS-AMS Extensions (3459)
Series: Purchasing
Display Name: CIS Setup
Physical Name: CIS40000
Technical Name: CIS_SETPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 UNIQKEY 
Key STR1 String 1 2 CISTDIVPOST CIS True Divisional Posting CB_CIS_True_Divisional_Posting Boolean 0 3 DIVACTSG Divisional Account Segment DDL_Divisional_Account_Segment Integer 0 4 CIS4PINDX CIS 4(P) Account Index LI_14 Long Integer 14 5 CIS4TINDX CIS 4(T) Account Index LI_14 Long Integer 14 6 CIS5INDX CIS 5 Account Index LI_14 Long Integer 14 7 CIS6INDX CIS 6 Account Index LI_14 Long Integer 14 8 CISEXPCHK CIS Cert Expiry Days Check INT4_Days_To_Expire Integer 4 9 PCHSCHID Purchase Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['CIS Setup'].PCHSCHID AS 'CIS Setup-Purchase Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
CIS40000 AS ['CIS Setup']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['CIS Setup'].PCHSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID10 NXTCIS23 Next CIS23 Voucher STR12_Next_CIS23_Voucher String 12 11 NXTCIS25 Next CIS25 Voucher STR15_Next_CIS25_Voucher String 15 12 CIS_Account_Index CIS Account Index LI_14 Long Integer 14