MC10101 - MC RM Distribution Temp File
Dynamics GP table MC10101 (MC RM Distribution Temp File) contains 33 columns including USERID, PSTGSTUS, RMDTYPAL....
SQL Query Builder
33 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| USERID | User ID | String | 16 | ||
| PSTGSTUS | Posting Status1 = Work2 = Open3 = History4 = Originating | Integer | 2 | ||
Posting Status values (11) 0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch | |||||
| RMDTYPAL | RM Document Type-All0 = Reserved for balance carried forward records1 = Sales / Invoice2 = Reserved for schedule payments3 = Debit Memos4 = Finance Charges5 = Service Repairs6= Warranties7 = Credit Memos8 = Returns9 = Payments | Integer | 2 | ||
| DOCNUMBR | Document Number | String | 22 | ||
| APTODCTY | Apply To Document Type | Integer | 2 | ||
| APTODCNM | Apply To Document Number | String | 22 | ||
| SEQNUMBR | Sequence Number | Long Integer | 4 | ||
| DISTTYPE | Distribution Type1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase8 = Misc. Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Disc | Integer | 2 | ||
Distribution Type (Payables) values (19) 1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase7 = Trade Discount8 = Miscellaneous Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Discount14 = PPS Amount16 = Rounding17 = Realized Gain18 = Realized Loss19 = Due To20 = Due From | |||||
| DSTINDX | Distribution Account Index | Long Integer | 4 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| POSTED | Posted | Boolean | 2 | ||
| POSTEDDT | Posted Date | Date | 4 | ||
| CHANGED | Changed | Boolean | 2 | ||
| CUSTNMBR | Customer Number | String | 16 | ||
| DEBITAMT | Debit Amount | Currency | 10 | ||
| CRDTAMNT | Credit Amount | Currency | 10 | ||
| ORCRDAMT | Originating Credit Amount | Currency | 10 | ||
| ORDBTAMT | Originating Debit Amount | Currency | 10 | ||
| MCSTRUCT_1 | MC Def Structure:Currency ID | String | 16 | ||
| MCSTRUCT_2 | MC Def Structure:Currency Index | Integer | 2 | ||
| MCSTRUCT_3 | MC Def Structure:Rate Type ID | String | 16 | ||
| MCSTRUCT_4 | MC Def Structure:Exchange Table ID | String | 16 | ||
| MCSTRUCT_5 | MC Def Structure:Exchange Rate | Currency (Variable) | 10 | ||
| MCSTRUCT_6 | MC Def Structure:Exchange Date | Date | 4 | ||
| MCSTRUCT_7 | MC Def Structure:Decimal Places | Integer | 2 | ||
| MCSTRUCT_8 | MC Def Structure:Time | Time | 4 | ||
| MCSTRUCT_9 | MC Def Structure:Rate Calc Method | Integer | 2 | ||
| MCSTRUCT_10 | MC Def Structure:View Mode | Integer | 2 | ||
| MCSTRUCT_11 | MC Def Structure:IS MC Trx | Integer | 2 | ||
| MCSTRUCT_12 | MC Def Structure:Expiration Date | Date | 4 | ||
| MCSTRUCT_13 | MC Def Structure:Denomination Exchange Rate | Currency (Variable) | 10 | ||
| MCSTRUCT_14 | MC Def Structure:MC Transaction State | Integer | 2 | ||
| SPCLDIST | Specialized Distribution | Integer | 2 | ||
Related Tables
Tables that share columns with MC10101. Click "Join" to add to your query.