Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB100000
Product: Cashbook (1058)
Series: Financial
Display Name: CB_Distribution
Physical Name: CB100000
Technical Name: CB_DistributionSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Trans_Type 
CB_Trans_Type STR1 String 1 2 ORDOCNUM Originating Document Number STR20 String 20 3 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 4 CB_Type CB_Type CB_DDL_Type2 Integer 0 5 SERIES Series DDL_Series Integer 0 6 DOCTYPE Document Type DDL_Document_Type Integer 0 7 DOCNUMBR Document Number STR20_Document_Number String 20 8 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['CB_Distribution'].ACTINDX AS 'CB_Distribution-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CB100000 AS ['CB_Distribution']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['CB_Distribution'].ACTINDX = ['Account Index Master'].ACTINDX9 DISTTYPE Distribution Type DDL Integer 0 10 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['CB_Distribution'].VENDORID AS 'CB_Distribution-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
CB100000 AS ['CB_Distribution']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['CB_Distribution'].VENDORID = ['PM Vendor Master File'].VENDORID11 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['CB_Distribution'].CUSTNMBR AS 'CB_Distribution-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
CB100000 AS ['CB_Distribution']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['CB_Distribution'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR12 DEBITAMT Debit Amount DLR19_$S2 Currency 19 13 CRDTAMNT Credit Amount DLR19_$S2 Currency 19 14 ORDBTAMT Originating Debit Amount DLR19_$S2 Currency 19 15 ORCRDAMT Originating Credit Amount DLR19_$S2 Currency 19 16 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['CB_Distribution'].CHEKBKID AS 'CB_Distribution-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB100000 AS ['CB_Distribution']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CB_Distribution'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID17 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['CB_Distribution'].CURNCYID AS 'CB_Distribution-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB100000 AS ['CB_Distribution']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['CB_Distribution'].CURNCYID = ['Currency Setup'].CURNCYID18 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['CB_Distribution'].CURRNIDX AS 'CB_Distribution-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CB100000 AS ['CB_Distribution']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['CB_Distribution'].CURRNIDX = ['Currency Setup'].CURRNIDX19 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['CB_Distribution'].RATETPID AS 'CB_Distribution-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
CB100000 AS ['CB_Distribution']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['CB_Distribution'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID20 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['CB_Distribution'].EXGTBLID AS 'CB_Distribution-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
CB100000 AS ['CB_Distribution']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['CB_Distribution'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID21 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 22 EXCHDATE Exchange Date DT_Date Date 6 23 TIME1 Time TM6 Time 6 24 RTCLCMTD Rate Calculation Method GB Integer 0 25 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 26 MCTRXSTT MC Transaction State INT1 Integer 1 27 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 28 ORDOCAMT Originating Document Amount DLR17_RBS0_STR$ Currency 17 29 RCDOCNUM Recurring Document Number STR20_Document_Number String 20