ieBegBalCustomerVendorImport (IEBEGBAL)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialieBegBalCustomerVendorImport (IEBEGBAL)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: ieBegBalCustomerVendorImport
Physical Name: IEBEGBAL
Technical Name: ieBegBalCustomerVendorImport

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CMRECNUM SearchRecord NumberCurrencyDLR_Document_Number19
2SEQUENCE1 SearchSequenceCurrencyDLR19_$S219
3CustomerVendor_ID SearchCustomer/Vendor IDStringSTR1515
4CustomerVendor_Name SearchCustomer/Vendor NameStringSTR6464
5AGPERAMT_1 SearchAging Period Amounts[1]CurrencyDLR17_RBSO_STR$17
6AGPERAMT_2 SearchAging Period Amounts[2]CurrencyDLR17_RBSO_STR$17
7AGPERAMT_3 SearchAging Period Amounts[3]CurrencyDLR17_RBSO_STR$17
8AGPERAMT_4 SearchAging Period Amounts[4]CurrencyDLR17_RBSO_STR$17
9AGPERAMT_5 SearchAging Period Amounts[5]CurrencyDLR17_RBSO_STR$17
10AGPERAMT_6 SearchAging Period Amounts[6]CurrencyDLR17_RBSO_STR$17
11AGPERAMT_7 SearchAging Period Amounts[7]CurrencyDLR17_RBSO_STR$17
12CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['ieBegBalCustomerVendorImport'].CUSTNMBR AS 'ieBegBalCustomerVendorImport-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       IEBEGBAL AS ['ieBegBalCustomerVendorImport']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['ieBegBalCustomerVendorImport'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
13VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['ieBegBalCustomerVendorImport'].VENDORID AS 'ieBegBalCustomerVendorImport-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       IEBEGBAL AS ['ieBegBalCustomerVendorImport']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['ieBegBalCustomerVendorImport'].VENDORID = ['PM Vendor Master File'].VENDORID
azurecurveProductsMicrosoft Dynamics GP (0)FinancialieBegBalCustomerVendorImport (IEBEGBAL)

Leave a Reply

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