| 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 |