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: ieBegBalCustomerVendorImportSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMRECNUM 
Record Number Currency DLR_Document_Number 19 2 SEQUENCE1 Sequence Currency DLR19_$S2 19 3 CustomerVendor_ID Customer/Vendor ID String STR15 15 4 CustomerVendor_Name Customer/Vendor Name String STR64 64 5 AGPERAMT_1 Aging Period Amounts[1] Currency DLR17_RBSO_STR$ 17 6 AGPERAMT_2 Aging Period Amounts[2] Currency DLR17_RBSO_STR$ 17 7 AGPERAMT_3 Aging Period Amounts[3] Currency DLR17_RBSO_STR$ 17 8 AGPERAMT_4 Aging Period Amounts[4] Currency DLR17_RBSO_STR$ 17 9 AGPERAMT_5 Aging Period Amounts[5] Currency DLR17_RBSO_STR$ 17 10 AGPERAMT_6 Aging Period Amounts[6] Currency DLR17_RBSO_STR$ 17 11 AGPERAMT_7 Aging Period Amounts[7] Currency DLR17_RBSO_STR$ 17 12 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 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'].CUSTNMBR13 VENDORID Vendor ID String STR_15_Vendor_ID 15 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