Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
DCSTATUS | Document Status 1 = Work |
Integer | 2 | View | |
RMDTYPAL | RM Document Type-All 0 = Reserved for balance carried forward records |
Integer | 2 | View | |
DOCNUMBR | Document Number |
String | 22 | View | |
DOCDATE | Document Date |
Date | 4 | View | |
CUSTNMBR | Customer Number |
String | 16 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
TRXSORCE | TRX Source |
String | 14 | View | |
CURRNIDX | Currency Index |
Integer | 2 | View | |
RATETPID | Rate Type ID |
String | 16 | View | |
EXGTBLID | Exchange Table ID |
String | 16 | View | |
XCHGRATE | Exchange Rate |
Currency (Variable) | 10 | View | |
EXCHDATE | Exchange Date |
Date | 4 | View | |
TIME1 | Time |
Time | 4 | View | |
RTCLCMTD | Rate Calculation Method |
Integer | 2 | View | |
ORCTRXAM | Originating Current Trx Amount |
Currency | 10 | View | |
ORSLSAMT | Originating Sales Amount |
Currency | 10 | View | |
ORCSTAMT | Originating Cost Amount |
Currency | 10 | View | |
ORFRTAMT | Originating Freight Amount |
Currency | 10 | View | |
ORMISCAMT | Originating Misc Amount |
Currency | 10 | View | |
ORTAXAMT | Originating Tax Amount |
Currency | 10 | View | |
ORCASAMT | Originating Cash Amount |
Currency | 10 | View | |
ORCHKAMT | Originating Check Amount |
Currency | 10 | View | |
ORCCDAMT | Originating Credit Card Amount |
Currency | 10 | View | |
ORAPPAMT | Originating Applied Amount |
Currency | 10 | View | |
ORDISTKN | Originating Discount Taken Amount |
Currency | 10 | View | |
ORDAVAMT | Originating Discount Available Amount |
Currency | 10 | View | |
ORDATKN | Originating Discount Available Taken |
Currency | 10 | View | |
ORDISRTD | Originating Discount Returned |
Currency | 10 | View | |
ORDDLRAT | Originating Discount Dollar Amount |
Currency | 10 | View | |
ORTDISAM | Originating Trade Discount Amount |
Currency | 10 | View | |
ORORGTRX | Originating Original Trx Amount |
Currency | 10 | View | |
ORWROFAM | Originating Write Off Amount |
Currency | 10 | View | |
ORCOMAMT | Originating Commission Dollar Amount |
Currency | 10 | View | |
ORBKTSLS | Originating Backout Sales Amount |
Currency | 10 | View | |
ORBKTFRT | Originating Backout Freight Amount |
Currency | 10 | View | |
ORBKTMSC | Originating Backout Misc Amount |
Currency | 10 | View | |
UNGANLOS | Unrealized Gain-Loss Amount |
Currency | 10 | View | |
RMMCERRS | RM MC Posting Error Messages |
Long Integer | 4 | View | |
DENXRATE | Denomination Exchange Rate |
Currency (Variable) | 10 | View | |
MCTRXSTT | MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. |
Integer | 2 | View | |
OrigBackoutTradeDisc | Originating Backout Trade Discount Amount |
Currency | 10 | View |