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 NumberDLR_Document_NumberCurrency19
2SEQUENCE1 SearchSequenceDLR19_$S2Currency19
3CustomerVendor_ID SearchCustomer/Vendor IDSTR15String15
4CustomerVendor_Name SearchCustomer/Vendor NameSTR64String64
5AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency17
6AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency17
7AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency17
8AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency17
9AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency17
10AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency17
11AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency17
12CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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 IDSTR_15_Vendor_IDString15
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 *