Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM10301
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: RM Sales Work File Group Display Name: Receivables Open Transaction Files
Physical Name: RM10301
Technical Name: RM_Sales_WORK
Group Technical Name: RM_Open_Transaction_Logical_File
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | DOCTYPE ![]() | Document Type | DDL_Document_Type | Integer | 0 | |
2 | RMDTYPAL ![]() | RM Document Type-All | INT2 | Integer | 2 | |
Document Type records the type of document.
Click to show/hide the Document Types
0 Balance Carried Forward
1 Sales / Invoice
2 Scheduled Payments
3 Debit Memo
4 Finance Charge
5 Service Repairs
6 Warranties
7 Credit Memo
8 Returns
9 Payments | ||||||
3 | RMDNUMWK ![]() | RM Document Number-WORK | STR17_LBAU | String | 17 | |
4 | DOCNUMBR ![]() | Document Number | STR20_Document_Number | String | 20 | |
5 | DOCPRFIX ![]() | Document Prefix | STR3 | String | 3 | |
6 | DOCDESCR ![]() | Document Description | STR30 | String | 30 | |
7 | DOCDATE ![]() | Document Date | DT | Date | 8 | |
8 | BACHNUMB ![]() | Batch Number | STR15_LBAU | String | 15 | |
Partial key to the PA Report Posting Definitions Master (SY00500).
Click to show/hideSELECT
['RM Sales Work File'].BACHNUMB AS 'RM Sales Work File-Batch Number'
,['PA Report Posting Definitions Master'].BACHNUMB AS 'PA Report Posting Definitions Master-Batch Number'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
SY00500 AS ['PA Report Posting Definitions Master']
ON
['RM Sales Work File'].BACHNUMB = ['PA Report Posting Definitions Master'].BACHNUMB
AND
['RM Sales Work File'].BCHSOURC = ['PA Report Posting Definitions Master'].BCHSOURC | ||||||
9 | BCHSOURC ![]() | Batch Source | STR15 | String | 15 | |
10 | NOTEINDX ![]() | Note Index | DLR14 | Currency | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['RM Sales Work File'].NOTEINDX AS 'RM Sales Work File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['RM Sales Work File'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
11 | CUSTNMBR ![]() | Customer Number | STR15_RM_Customer_Number | String | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['RM Sales Work File'].CUSTNMBR AS 'RM Sales Work File-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['RM Sales Work File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
12 | CUSTNAME ![]() | Customer Name | STR64_Customer_Name | String | 64 | |
13 | ADRSCODE ![]() | Address Code | STR15_Address_Code | String | 15 | |
14 | SLPRSNID ![]() | Salesperson ID | STR15_Salesperson_ID | String | 15 | |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['RM Sales Work File'].SLPRSNID AS 'RM Sales Work File-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['RM Sales Work File'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID | ||||||
15 | SALSTERR ![]() | Sales Territory | STR15_Sales_Territory | String | 15 | |
Key to the Sales Territory Master File (RM00303).
Click to show/hideSELECT
['RM Sales Work File'].SALSTERR AS 'RM Sales Work File-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['RM Sales Work File'].SALSTERR = ['Sales Territory Master File'].SALSTERR | ||||||
16 | COMAPPTO ![]() | Commission Applied To | GB | Integer | 0 | |
17 | COMDLRAM ![]() | Commission Dollar Amount | DLR17_RBSO_STR$ | Currency | 17 | |
18 | NCOMAMNT ![]() | Non-Commissioned Amount | DLR19_RBS0_STR$ | Currency | 19 | |
19 | SHIPMTHD ![]() | Shipping Method | STR15_Shipping_Method | String | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['RM Sales Work File'].SHIPMTHD AS 'RM Sales Work File-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['RM Sales Work File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
20 | CSTPONBR ![]() | Customer PO Number | STR20_Document_Number | String | 20 | |
21 | TAXSCHID ![]() | Tax Schedule ID | STR15_Tax_Schedule_ID | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['RM Sales Work File'].TAXSCHID AS 'RM Sales Work File-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Sales Work File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
22 | SLSCHDID ![]() | Sales Schedule ID | STR15_LBU | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['RM Sales Work File'].SLSCHDID AS 'RM Sales Work File-Sales Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Sales Work File'].SLSCHDID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
23 | FRTSCHID ![]() | Freight Schedule ID | STR15_LBAU | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['RM Sales Work File'].FRTSCHID AS 'RM Sales Work File-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Sales Work File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
24 | MSCSCHID ![]() | Misc Schedule ID | STR15_LBAU | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['RM Sales Work File'].MSCSCHID AS 'RM Sales Work File-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Sales Work File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
25 | COSTAMNT ![]() | Cost Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
26 | SLSAMNT ![]() | Sales Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
27 | TRDISAMT ![]() | Trade Discount Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
28 | TRDDISCT ![]() | Trade Discount | INT4_%2 | Integer | 4 | |
29 | FRTAMNT ![]() | Freight Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
30 | MISCAMNT ![]() | Misc Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
31 | TAXAMNT ![]() | Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
32 | BKTSLSAM ![]() | Backout Sales Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
33 | BKTFRTAM ![]() | Backout Freight Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
34 | BKTMSCAM ![]() | Backout Misc Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
35 | TXENGCLD ![]() | Tax Engine Called | YN | Boolean | 0 | |
36 | DOCAMNT ![]() | Document Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
37 | APPLDAMT ![]() | Applied Amount | DLR17_RBS0_STR$ | Currency | 17 | |
38 | CASHAMNT ![]() | Cash Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
39 | CBKIDCSH ![]() | Checkbook ID Cash | STR15_Checkbook_ID | String | 15 | |
40 | CASHDATE ![]() | Cash Date | DATE | Date | 6 | |
41 | DCNUMCSH ![]() | Document Number Cash | STR20_Document_Number | String | 20 | |
42 | CHEKAMNT ![]() | Check Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
43 | CBKIDCHK ![]() | Checkbook ID Check | STR15_Checkbook_ID | String | 15 | |
44 | CBKIDCRD ![]() | Checkbook ID Credit Card | STR15_Checkbook_ID | String | 15 | |
45 | CHEKNMBR ![]() | Check Number | STR20_Document_Number | String | 20 | |
46 | CHEKDATE ![]() | Check Date | DATE | Date | 6 | |
47 | DCNUMCHK ![]() | Document Number Check | STR20_Document_Number | String | 20 | |
48 | CRCRDAMT ![]() | Credit Card Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
49 | CRCRDNAM ![]() | Credit Card Name | STR15 | String | 15 | |
50 | RCTNCCRD ![]() | Receipt Number Credit Card | STR20_Document_Number | String | 20 | |
51 | CRCARDDT ![]() | Credit Card Date | DATE | Date | 6 | |
52 | DCNUMCRD ![]() | Document Number Credit Card | STR20_Document_Number | String | 20 | |
53 | DISCRTND ![]() | Discount Returned | DLR17_RBS0_STR$ | Currency | 17 | |
54 | DISTKNAM ![]() | Discount Taken Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
55 | DISAVTKN ![]() | Discount Available Taken | DLR17_RBS0_UTR$ | Currency | 17 | |
56 | WROFAMNT ![]() | Write Off Amount | DLR17_RBS0_STR$ | Currency | 17 | |
57 | PPSAMDED ![]() | PPS Amount Deducted | DLR17_RBS0_UTR$ | Currency | 17 | |
58 | GSTDSAMT ![]() | GST Discount Amount | DLR17_RBS0_STR$ | Currency | 17 | |
59 | ACCTAMNT ![]() | Account Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
60 | PYMTRMID ![]() | Payment Terms ID | STR20_Payment_Terms_ID | String | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['RM Sales Work File'].PYMTRMID AS 'RM Sales Work File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['RM Sales Work File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID | ||||||
61 | DISAVAMT ![]() | Discount Available Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
62 | DISCDATE ![]() | Discount Date | DT | Date | 8 | |
63 | DUEDATE ![]() | Due Date | DT | Date | 8 | |
64 | DSCDLRAM ![]() | Discount Dollar Amount | DLR11_RBS0_UTR$ | Currency | 11 | |
65 | DSCPCTAM ![]() | Discount Percent Amount | INT5_%2 | Integer | 5 | |
66 | CURNCYID ![]() | Currency ID | STR15_Currency_ID | String | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['RM Sales Work File'].CURNCYID AS 'RM Sales Work File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RM Sales Work File'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
67 | POSTED ![]() | Posted | True/False | Boolean | 0 | |
68 | LSTEDTDT ![]() | Last Edit Date | DT_Date | Date | 6 | |
69 | LSTUSRED ![]() | Last User to Edit | STR15 | String | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['RM Sales Work File'].LSTUSRED AS 'RM Sales Work File-Last User to Edit'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['RM Sales Work File'].LSTUSRED = ['Users Master'].USERID | ||||||
70 | RMTREMSG ![]() | RM TRX Posting Error Messages | RM_TRX_Posting_Error_Messages | Long Integer | 0 | |
71 | RMDPEMSG ![]() | RM Dist Posting Error Messages | RM_Dist_Posting_Error_Messages | Long Integer | 0 | |
72 | GLPOSTDT ![]() | GL Posting Date | DT | Date | 8 | |
73 | POSTEDDT ![]() | Posted Date | DATE | Date | 6 | |
74 | PTDUSRID ![]() | Posted User ID | STR15 | String | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['RM Sales Work File'].PTDUSRID AS 'RM Sales Work File-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
RM10301 AS ['RM Sales Work File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['RM Sales Work File'].PTDUSRID = ['Users Master'].USERID | ||||||
75 | Tax_Date ![]() | Tax Date | DT | Date | 8 | |
76 | APLYWITH ![]() | Apply Withholding | Boolean | Boolean | 0 | |
77 | SALEDATE ![]() | Sale Date | DT | Date | 8 | |
78 | CORRCTN ![]() | Correction | CB_Correction | Boolean | 0 | |
79 | SIMPLIFD ![]() | Simplified | CB_Simplified | Boolean | 0 | |
80 | CORRNXST ![]() | Correction to Nonexisting Transaction | Boolean | Boolean | 0 | |
81 | DOCNCORR ![]() | Document Number Corrected | Document_Number | String | 20 | |
82 | RMTREMSG2 ![]() | RM TRX Posting Error Messages 2 | RM_TRX_Posting_Error_Messages_2 | Long Integer | 0 | |
83 | DocPrinted ![]() | DocPrinted | CB_DocPrinted | Boolean | 0 | |
Click to show/hide Document Printed flag
0 Record has not been printed.
1 Record has been printed. | ||||||
84 | DISGRPER ![]() | Discount Grace Period | INT2_U0 | Integer | 2 | |
85 | DUEGRPER ![]() | Due Date Grace Period | INT2_U0 | Integer | 2 | |
86 | Electronic ![]() | Electronic | CB_Electronic | Boolean | 0 | |
87 | ECTRX ![]() | EC Transaction | CB_EC_Transaction | Boolean | 0 | |
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.
Click to show/hide Document Printed flag
0 Not an EU Transaction.
1 EU Transaction. | ||||||
88 | PSTGSTUS ![]() | Posting Status | INT | Integer | 0 | |
89 | BackoutTradeDisc ![]() | Backout Trade Discount Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
90 | DIRECTDEBIT ![]() | Direct Debit | CB_DirectDebit | Boolean | 0 | |
91 | EFTFLAG ![]() | EFT Flag | CB_EFT | Boolean | 0 | |
92 | DEX_ROW_TS ![]() | datetime | datetime | 3 | ||
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised. | ||||||
93 | DEX_ROW_ID ![]() | int | int | 10 | ||
DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column. |