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 TypeSQL DB LengthKeyable Length
1CMRECNUM SearchRecord NumberDLR_Document_NumberCurrency1019
2SEQUENCE1 SearchSequenceDLR19_$S2Currency1019
3CustomerVendor_ID SearchCustomer/Vendor IDSTR15String1615
4CustomerVendor_Name SearchCustomer/Vendor NameSTR64String6664
5AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency1017
6AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency1017
7AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency1017
8AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency1017
9AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency1017
10AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency1017
11AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency1017
12CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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_IDString1615
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 *