GP Tables

RM50103 - RM Email Statements Header Temporary File

Dynamics GP table RM50103 (RM Email Statements Header Temporary File) contains 78 columns including DSCRIPTN, STMNTID, CUSTNMBR....

SQL Query Builder

78 Columns

Column Description Type Length
DSCRIPTN Description String 32
STMNTID Statement ID String 16
CUSTNMBR Customer Number String 16
STMTNAME Statement Name String 66
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
CURRNIDX Currency Index Integer 2
CNTCPRSN Contact Person String 62
ADDRESS1 Address 1 String 62
ADDRESS2 Address 2 String 62
ADDRESS3 Address 3 String 62
PHONE1 Phone 1 String 22
PHONE2 Phone 2 String 22
PHONE3 Phone 3 String 22
CITY City String 36
STATE State String 30
ZIP Zip String 12
DATE1 Date Date 4
MINPYDUE Minimum Payment Due Currency 10
CUSTMSGS_1 Customer Messages[1] String 42
CUSTMSGS_2 Customer Messages[2] String 42
CUSTMSGS_3 Customer Messages[3] String 42
AMNTDUE Amount Due Currency 10
STMTMSGS_1 Statement Messages[1] String 52
STMTMSGS_2 Statement Messages[2] String 52
STMTMSGS_3 Statement Messages[3] String 52
STMTMSGS_4 Statement Messages[4] String 52
STMTMSGS_5 Statement Messages[5] String 52
STMTMSGS_6 Statement Messages[6] String 52
STMTMSGS_7 Statement Messages[7] String 52
STMTMSGS_8 Statement Messages[8] String 52
STMTMSGS_9 Statement Messages[9] String 52
STMTMSGS_10 Statement Messages[10] String 52
STMTMSGS_11 Statement Messages[11] String 52
STMTMSGS_12 Statement Messages[12] String 52
STMTMSGS_13 Statement Messages[13] String 52
STMTMSGS_14 Statement Messages[14] String 52
STMTMSGS_15 Statement Messages[15] String 52
DOCARABR_1 Document Array Abbreviation[1] String 4
DOCARABR_2 Document Array Abbreviation[2] String 4
DOCARABR_3 Document Array Abbreviation[3] String 4
DOCARABR_4 Document Array Abbreviation[4] String 4
DOCARABR_5 Document Array Abbreviation[5] String 4
DOCARABR_6 Document Array Abbreviation[6] String 4
DOCARABR_7 Document Array Abbreviation[7] String 4
DOCARABR_8 Document Array Abbreviation[8] String 4
DOCARABR_9 Document Array Abbreviation[9] String 4
DOCARDSC_1 Document Array Description[1] String 22
DOCARDSC_2 Document Array Description[2] String 22
DOCARDSC_3 Document Array Description[3] String 22
DOCARDSC_4 Document Array Description[4] String 22
DOCARDSC_5 Document Array Description[5] String 22
DOCARDSC_6 Document Array Description[6] String 22
DOCARDSC_7 Document Array Description[7] String 22
DOCARDSC_8 Document Array Description[8] String 22
DOCARDSC_9 Document Array Description[9] String 22
AGPERAMT_1 Aging Period Amounts[1] Currency 10
AGPERAMT_2 Aging Period Amounts[2] Currency 10
AGPERAMT_3 Aging Period Amounts[3] Currency 10
AGPERAMT_4 Aging Period Amounts[4] Currency 10
AGPERAMT_5 Aging Period Amounts[5] Currency 10
AGPERAMT_6 Aging Period Amounts[6] Currency 10
AGPERAMT_7 Aging Period Amounts[7] Currency 10
AGPERDSC_1 Aging Periods Descriptions[1] String 16
AGPERDSC_2 Aging Periods Descriptions[2] String 16
AGPERDSC_3 Aging Periods Descriptions[3] String 16
AGPERDSC_4 Aging Periods Descriptions[4] String 16
AGPERDSC_5 Aging Periods Descriptions[5] String 16
AGPERDSC_6 Aging Periods Descriptions[6] String 16
AGPERDSC_7 Aging Periods Descriptions[7] String 16
CMPANYID Company ID Integer 2
LOCATNID Location ID String 16
PYMTRMID Payment Terms ID String 22
CUSTBLNC Customer Balance Currency 10
DEPRECV Deposits Received Currency 10
RNNMBR Run Number Long Integer 4
PRNTSTUS Printing Status Integer 2
USERID User ID String 16
Process_Index Process Index Long Integer 4

Related Tables

Tables that share columns with RM50103. Click "Join" to add to your query.

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

CURRNIDX

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

USERID

AAG50001 AAG60001 AAG70001 ACTIVITY AHPSLH01 ASIEXP100 ASIEXP85 CAM10200

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

PYMTRMID

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15

ADDRESS1

AHR2AP12 AHR2AP13 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08

CITY

AHR2AP12 AHR2AP13 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08

STATE

AHR2AP12 AHR2AP13 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08

ADDRESS2

AHR2AP12 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09

ADDRESS3

ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10