| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| CUSTNMBR | Customer Number |
String | 16 | View | |
| CPRCSTNM | Corporate Customer Number |
String | 16 | View | |
| TRXSORCE | TRX Source |
String | 14 | View | |
| DATE1 | Date |
Date | 4 | View | |
| TIME1 | Time |
Time | 4 | View | |
| GLPOSTDT | GL Posting Date |
Date | 4 | View | |
| POSTED | Posted |
Boolean | 2 | View | |
| TAXDTLID | Tax Detail ID |
String | 16 | View | |
| APTODCNM | Apply To Document Number |
String | 22 | View | |
| APTODCTY | Apply To Document Type |
Integer | 2 | View | |
| APTODCDT | Apply To Document Date |
Date | 4 | View | |
| ApplyToGLPostDate | Apply To GL Posting Date |
Date | 4 | View | |
| CURNCYID | Currency ID |
String | 16 | View | |
| CURRNIDX | Currency Index |
Integer | 2 | View | |
| APPTOAMT | Apply To Amount |
Currency | 10 | View | |
| DISTKNAM | Discount Taken Amount |
Currency | 10 | View | |
| DISAVTKN | Discount Available Taken |
Currency | 10 | View | |
| WROFAMNT | Write Off Amount |
Currency | 10 | View | |
| ORAPTOAM | Originating Apply To Amount |
Currency | 10 | View | |
| ORDISTKN | Originating Discount Taken Amount |
Currency | 10 | View | |
| ORDATKN | Originating Discount Available Taken |
Currency | 10 | View | |
| ORWROFAM | Originating Write Off Amount |
Currency | 10 | View | |
| APTOEXRATE | Apply To Exchange Rate |
Currency (Variable) | 10 | View | |
| APTODENRATE | Apply To Denomination Exchange Rate |
Currency (Variable) | 10 | View | |
| APTORTCLCMETH | Apply To Rate Calc Method |
Integer | 2 | View | |
| APTOMCTRXSTT | Apply To MC Transaction State |
Integer | 2 | View | |
| APFRDCNM | Apply From Document Number |
String | 22 | View | |
| APFRDCTY | Apply From Document Type |
Integer | 2 | View | |
| APFRDCDT | Apply From Document Date |
Date | 4 | View | |
| ApplyFromGLPostDate | Apply From GL Posting Date |
Date | 4 | View | |
| FROMCURR | Apply From Currency ID |
String | 16 | View | |
| APFRMAPLYAMT | Apply From Apply Amount |
Currency | 10 | View | |
| APFRMDISCTAKEN | Apply From Discount Taken Amount |
Currency | 10 | View | |
| APFRMDISCAVAIL | Apply From Discount Available Taken |
Currency | 10 | View | |
| APFRMWROFAMT | Apply From Write Off Amount |
Currency | 10 | View | |
| ActualApplyToAmount | Actual Apply To Amount |
Currency | 10 | View | |
| ActualDiscTakenAmount | Actual Discount Taken Amount |
Currency | 10 | View | |
| ActualDiscAvailTaken | Actual Discount Available Taken |
Currency | 10 | View | |
| ActualWriteOffAmount | Actual Write Off Amount |
Currency | 10 | View | |
| APFRMEXRATE | Apply From Exchange Rate |
Currency (Variable) | 10 | View | |
| APFRMDENRATE | Apply From Denomination Exchange Rate |
Currency (Variable) | 10 | View | |
| APFRMRTCLCMETH | Apply From Rate Calc Method |
Integer | 2 | View | |
| APFRMMCTRXSTT | Apply From MC Transaction State |
Integer | 2 | View | |
| APYFRMRNDAMT | Apply From Round Amount |
Currency | 10 | View | |
| APYTORNDAMT | Apply To Round Amount |
Currency | 10 | View | |
| APYTORNDDISC | Apply To Round Discount |
Currency | 10 | View | |
| OAPYFRMRNDAMT | Originating Apply From Round Amount |
Currency | 10 | View | |
| OAPYTORNDAMT | Originating Apply To Round Amount |
Currency | 10 | View | |
| OAPYTORNDDISC | Originating Apply To Round Discount |
Currency | 10 | View | |
| GSTDSAMT | GST Discount Amount |
Currency | 10 | View | |
| PPSAMDED | PPS Amount Deducted |
Currency | 10 | View | |
| RLGANLOS | Realized Gain-Loss Amount |
Currency | 10 | View | |
| Settled_Gain_CreditCurrT | Settled Gain CreditCurrTrx |
Currency | 10 | View | |
| Settled_Loss_CreditCurrT | Settled Loss CreditCurrTrx |
Currency | 10 | View | |
| Settled_Gain_DebitCurrTr | Settled Gain DebitCurrTrx |
Currency | 10 | View | |
| Settled_Loss_DebitCurrTr | Settled Loss DebitCurrTrx |
Currency | 10 | View | |
| Settled_Gain_DebitDiscAv | Settled Gain DebitDiscAvail |
Currency | 10 | View | |
| Settled_Loss_DebitDiscAv | Settled Loss DebitDiscAvail |
Currency | 10 | View | |
| Revaluation_Status | Revaluation Status |
Integer | 2 | View |