| BANK |
String*8 |
Bank Code |
Mask: %-8N |
| SERIAL |
Long |
Transaction Header Serial |
|
| LINE |
Long |
Transaction Detail Line |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| SRCEAPP |
String*2 |
Source Application |
Mask: %-2N |
| STATUS |
Integer |
Transaction Detail Status |
List: 8 entries
| 1 | = | Not Posted | | 2 | = | Void | | 3 | = | Outstanding | | 6 | = | Cleared with bank error | | 4 | = | Reversed | | 7 | = | Non-negotiable | | 8 | = | Continuation | | 9 | = | Printed |
|
| TRANSTYPE |
Integer |
Transaction Type |
List: 2 entries
|
| TYPE |
Integer |
Detail Transaction Type |
List: 7 entries
| 1 | = | Check | | 2 | = | EFT | | 3 | = | Transfer | | 4 | = | Service Charge | | 5 | = | Credit Card | | 6 | = | Cash | | 7 | = | Other |
|
| IDREMIT |
String*24 |
Remittance ID |
|
| DATEREMIT |
Date |
Transaction Date |
|
| BTCHNBR |
BCD*5.0 |
Batch Number |
|
| ENTRYNBR |
BCD*4.0 |
Entry Number |
|
| POSTSEQ |
BCD*5.0 |
Posting Sequence Number |
|
| REFERENCE |
String*60 |
Transaction Reference |
|
| COMMENT |
String*60 |
Transaction Description |
|
| PAYORID |
String*12 |
Payer Code |
Mask: %-12C |
| PAYORNAME |
String*60 |
Payee Name |
|
| VENDORNAME |
String*60 |
Vendor Name |
|
| SRCEAMOUNT |
BCD*10.3 |
Source Transaction Amount |
|
| FUNCAMOUNT |
BCD*10.3 |
Functional Transaction Amount |
|
| RATETYPE |
String*2 |
Exchange Rate Type |
Mask: %-2N |
| SRCECURN |
String*3 |
Receipt Currency |
Mask: %-3N |
| RATEDATE |
Date |
Exchange Rate Date |
|
| RATE |
BCD*8.7 |
Exchange Rate |
|
| RATESPREAD |
BCD*8.7 |
Rate Spread |
|
| RATEOP |
Integer |
Rate Operation |
List: 3 entries
| 1 | = | Multiply | | 2 | = | Divide | | 0 | = | Not Specified |
|
| DISTCODE |
String*6 |
Distribution Code |
Mask: %-6N |
| GLACCOUNT |
String*45 |
G/L Account |
Mask: %-45C |
| CCTYPE |
String*12 |
Credit Card Type |
Mask: %-12N |
| CCNUMBER |
Binary*32 |
Credit Card Number |
|
| CCNAME |
String*60 |
Cardholder Name |
|
| CCAUTHCODE |
String*20 |
Authorization Code |
|
| CCEXP |
Date |
Expiry Date |
|
| DDTYPE |
Integer |
Drilldown Type |
|
| DDLINK |
BCD*10.0 |
Drilldown Link |
|
| RECSTATUS |
Integer |
Reconciliation Status |
List: 3 entries
| 1 | = | Not Posted | | 2 | = | Void | | 3 | = | Outstanding |
|
| RECSTATCHG |
Date |
Status Change Date |
|
| RECCOMMENT |
String*60 |
Reconciliation Description |
|
| RECCLEARED |
BCD*10.3 |
Cleared Amount |
|
| POSTDATE |
Date |
Reconciliation Posting Date |
|
| POSTYEAR |
String*4 |
Reconciliation Posting Year |
Mask: %04D |
| POSTPERIOD |
Integer |
Reconciliation Posting Period |
List: 1 entries
|
| RECONCILED |
Boolean |
Reconciled |
|
| RECPENDING |
BCD*10.3 |
Remaining In Transit Amount |
|
| PAYMCODE |
String*12 |
Payment Code |
|
| CHKFORM |
String*6 |
Check Stock Code |
Mask: %-6N |
| OFXTID |
String*50 |
OFX Transaction ID |
|
| FSCYEAR |
String*4 |
Fiscal Year |
Mask: %04D |
| FSCPERIOD |
Integer |
Fiscal Period |
List: 13 entries
| 1 | = | 1 | | 2 | = | 2 | | 3 | = | 3 | | 4 | = | 4 | | 5 | = | 5 | | 6 | = | 6 | | 7 | = | 7 | | 8 | = | 8 | | 9 | = | 9 | | 10 | = | 10 | | 11 | = | 11 | | 12 | = | 12 | | 13 | = | 13 |
|
| REVDATE |
Date |
Reversal/Return Date |
|
| SRCEDOCNUM |
String*22 |
Source Document Number |
|
| CANREVINVC |
Integer |
Can Reverse Invoice |
List: 2 entries
|
| REVINVC |
Integer |
Reverse Invoice |
List: 2 entries
|
| COMPLETED |
Integer |
Reconciled and Journaled Transaction |
List: 2 entries
| 0 | = | Not Completed | | 10 | = | Completed |
|
| PSTSEQ |
BCD*5.0 |
Posting Sequence |
|
| ENTRYTYPE |
Integer |
Entry Type |
|
| POSTED |
Date |
Document Posted Date |
|
| LSTRECSTAT |
Integer |
Last Reconciliation Status |
|
|