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 |