Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB770002
Product: Cashbook (1058)
Series: Financial
Display Name: Check Header Group Display Name: Bank Management
Physical Name: CB770002
Technical Name: CB_Check_HDR
Group Technical Name: Bank Management
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | EXPNDATE | Expiration Date | DT_Date | Date | 6 | |
2 | CB_Exchange_Rate | CB_Exchange_Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
3 | CB_Rate_Calc_Method | CB_Rate_Calc_Method | INT | Integer | 0 | |
4 | CB_Cancelled_Check | CB_Cancelled_Check | CB_Canceled_Check | Boolean | 0 | |
5 | CHEKBKID | Checkbook ID | STR15_Checkbook_ID | String | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['Check Header'].CHEKBKID AS 'Check Header-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB770002 AS ['Check Header']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Check Header'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID | ||||||
6 | CURRNIDX | Currency Index | INT3 | Integer | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['Check Header'].CURRNIDX AS 'Check Header-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CB770002 AS ['Check Header']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Check Header'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
7 | CURNCYID | Currency ID | STR15_Currency_ID | String | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['Check Header'].CURNCYID AS 'Check Header-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB770002 AS ['Check Header']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Check Header'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
8 | EXCHDATE | Exchange Date | DT_Date | Date | 6 | |
9 | XCHGRATE | Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
10 | RATECALC | Rate Calc Method | INT | Integer | 0 | |
11 | RATETPID | Rate Type ID | STR15_Rate_Type_ID | String | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['Check Header'].RATETPID AS 'Check Header-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
CB770002 AS ['Check Header']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['Check Header'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
12 | TIME1 | Time | TM6 | Time | 6 | |
13 | CB_Line_No | CB_Line_No | STR10 | String | 10 | |
14 | BACHNUMB | Batch Number | STR15_LBAU | String | 15 | |
15 | CB_Trans_Option | CB_Trans_Option | CB_DDL_Option | Integer | 0 | |
16 | payment_method | payment method | payment mothod | Integer | 0 | |
17 | DOCNUMBR | Document Number | STR20_Document_Number | String | 20 | |
18 | CHEKNMBR | Check Number | STR20_Document_Number | String | 20 | |
19 | CB_Deposit_Date | CB_Deposit_Date | DT | Date | 8 | |
20 | CB_Type | CB_Type | CB_DDL_Type2 | Integer | 0 | |
21 | CB_Payee | CB_Payee | STR40 | String | 40 | |
22 | VENDORID | Vendor ID | STR_15_Vendor_ID | String | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['Check Header'].VENDORID AS 'Check Header-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
CB770002 AS ['Check Header']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Check Header'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
23 | CUSTNAME | Customer Name | STR64_Customer_Name | String | 64 | |
24 | DSCRIPTN | Description | STR30 | String | 30 | |
25 | EXGTBLID | Exchange Table ID | STR15_Exchange_Table_ID | String | 15 | |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['Check Header'].EXGTBLID AS 'Check Header-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
CB770002 AS ['Check Header']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['Check Header'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID | ||||||
26 | CB_Check_Amount | CB_Check_Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
27 | CB_Check_Total | CB_Check_Total | DLR19_RBS0_UTR$ | Currency | 19 |