| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| DCSTATUS | Document Status 1 = Work |
Integer | 2 | View | |
| DOCTYPE | Document Type |
Integer | 2 | View | |
| VCHRNMBR | Voucher Number |
String | 22 | View | |
| PMNTNMBR | Payment Number |
String | 22 | View | |
| DOCDATE | Document Date |
Date | 4 | View | |
| VENDORID | Vendor ID |
String | 16 | View | |
| CURNCYID | Currency ID |
String | 16 | 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 | |
| OPURAMT | Originating Purchases Amount |
Currency | 10 | View | |
| ORFRTAMT | Originating Freight Amount |
Currency | 10 | View | |
| OMISCAMT | Originating Misc Charges 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 | |
| ORCHKTTL | Originating Check Total |
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 | |
| ORDATKN | Originating Discount Available Taken |
Currency | 10 | View | |
| ORDDLRAT | Originating Discount Dollar Amount |
Currency | 10 | View | |
| ORTDISAM | Originating Trade Discount Amount |
Currency | 10 | View | |
| ORWROFAM | Originating Write Off Amount |
Currency | 10 | View | |
| OBKPURAMT | Originating Backout Purchases 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 | |
| OCHGAMT | Originating Charge Amount |
Currency | 10 | View | |
| ORDOCAMT | Originating Document Amount |
Currency | 10 | View | |
| ODISAMTAV | Originating Discount Amount Available |
Currency | 10 | View | |
| ORGAPDISCTKN | Originating Applied Discount Taken Amount |
Currency | 10 | View | |
| OTOTPAY | Originating Total Payments |
Currency | 10 | View | |
| OR1099AM | Originating 1099 Amount |
Currency | 10 | 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 |