Payments Correction Import table (CB911116)

azurecurveProductsCashbook (1058)FinancialPayments Correction Import table (CB911116)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB911116

Product: Cashbook (1058)
Series: Financial

Display Name: Payments Correction Import table
Physical Name: CB911116
Technical Name: CB_PM_Import_Correction

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CB_Line_No SearchCB_Line_NoSTR10String1210
2CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
3BACHNUMB SearchBatch NumberSTR15_LBAUString1615
4CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Payments Correction Import table'].CHEKBKID AS 'Payments Correction Import table-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB911116 AS ['Payments Correction Import table']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Payments Correction Import table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
5CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Payments Correction Import table'].CURNCYID AS 'Payments Correction Import table-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CB911116 AS ['Payments Correction Import table']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Payments Correction Import table'].CURNCYID = ['Currency Setup'].CURNCYID
6CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Payments Correction Import table'].CURRNIDX AS 'Payments Correction Import table-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       CB911116 AS ['Payments Correction Import table']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Payments Correction Import table'].CURRNIDX = ['Currency Setup'].CURRNIDX
7payment_method Searchpayment methodpayment mothodInteger20
8CB_Deposit_Date SearchCB_Deposit_DateDTDate48
9CB_Type SearchCB_TypeCB_DDL_Type2Integer20
10CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
11VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Payments Correction Import table'].VENDORID AS 'Payments Correction Import table-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       CB911116 AS ['Payments Correction Import table']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Payments Correction Import table'].VENDORID = ['PM Vendor Master File'].VENDORID
12ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Payments Correction Import table'].ACTINDX AS 'Payments Correction Import table-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       CB911116 AS ['Payments Correction Import table']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Payments Correction Import table'].ACTINDX = ['Account Index Master'].ACTINDX
13CB_Type_Description SearchCB_Type_DescriptionSTR30String3230
14TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Payments Correction Import table'].TAXSCHID AS 'Payments Correction Import table-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       CB911116 AS ['Payments Correction Import table']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Payments Correction Import table'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
15DSCRIPTN SearchDescriptionSTR30String3230
16MESSAGE SearchMessageSTR50String5250
17CB_Status SearchCB_StatusINTInteger20
18EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['Payments Correction Import table'].EXGTBLID AS 'Payments Correction Import table-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       CB911116 AS ['Payments Correction Import table']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Payments Correction Import table'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
19CB_Check_Amount SearchCB_Check_AmountDLR19_RBS0_UTR$Currency1019
20CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency1019
21Vat_Amount SearchVat_AmountDLR19_RBS0_UTR$Currency1019
22CB_Payee SearchCB_PayeeSTR40String4240
23CB_Exc_Inc SearchCB_Exc_IncDDLInteger20
24CB_Exchange_Rate SearchCB_Exchange_RateDLR14_Exchange_RateCurrency (Variable)1014
25CB_Rate_Calc_Method SearchCB_Rate_Calc_MethodINTInteger20
26EXCHDATE SearchExchange DateDT_DateDate46
27XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
28TIME1 SearchTimeTM6Time46
29EXPNDATE SearchExpiration DateDT_DateDate46
30RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Payments Correction Import table'].RATETPID AS 'Payments Correction Import table-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       CB911116 AS ['Payments Correction Import table']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Payments Correction Import table'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
31RATECALC SearchRate Calc MethodINTInteger20
32SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
33INTERID SearchIntercompany IDSTR5_IC_IDString65
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Payments Correction Import table'].INTERID AS 'Payments Correction Import table-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       CB911116 AS ['Payments Correction Import table']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Payments Correction Import table'].INTERID = ['Company Master'].INTERID
34CB_Line_Number SearchCB_Line_NumberCB_LongLong Integer410
azurecurveProductsCashbook (1058)FinancialPayments Correction Import table (CB911116)

Leave a Reply

Your email address will not be published. Required fields are marked *