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 |