| PSTSEQ |
BCD*5.0 |
Posting Sequence |
|
| 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: 12 entries
| 1 | = | Not Posted | | 2 | = | Void | | 3 | = | Outstanding | | 4 | = | Reversed | | 5 | = | Cleared | | 6 | = | Cleared with bank error | | 7 | = | Non-negotiable | | 8 | = | Continuation | | 9 | = | Printed | | 10 | = | Cleared with write-off | | 11 | = | Cleared with exchange rate difference | | 12 | = | Cleared with credit card charge |
|
| 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 |
| GLACCTOVR |
Boolean |
GL Account Override |
|
| 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: 12 entries
| 1 | = | Not Posted | | 2 | = | Void | | 3 | = | Outstanding | | 4 | = | Reversed | | 5 | = | Cleared | | 6 | = | Cleared with bank error | | 7 | = | Non-negotiable | | 8 | = | Continuation | | 9 | = | Printed | | 10 | = | Cleared with write-off | | 11 | = | Cleared with exchange rate difference | | 12 | = | Cleared with credit card charge |
|
| 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 |
|
| RECONCILED |
Boolean |
Reconciled |
|
| RECPENDING |
BCD*10.3 |
Remaining In Transit Amount |
|
| RECERR |
BCD*10.3 |
Reconciliation Error |
|
| RECERRPEND |
BCD*10.3 |
Reconciliation Error Pending |
|
| RECEXGAIN |
BCD*10.3 |
Reconciliation Exchange Gain |
|
| RECEXLOSS |
BCD*10.3 |
Reconciliation Exchange Loss |
|
| RECSUGGEST |
Integer |
Reconciliation Suggestion |
List: 12 entries
| 1 | = | Not Posted | | 2 | = | Void | | 3 | = | Outstanding | | 4 | = | Reversed | | 5 | = | Cleared | | 6 | = | Cleared with bank error | | 7 | = | Non-negotiable | | 8 | = | Continuation | | 9 | = | Printed | | 10 | = | Cleared with write-off | | 11 | = | Cleared with exchange rate difference | | 12 | = | Cleared with credit card charge |
|
| RECAMOUNT |
BCD*10.3 |
Transaction Amount |
|
| RECOUTSTND |
BCD*10.3 |
Outstanding Amount |
|
| RECTARGET |
Integer |
Reconciliation Target |
|
| RECCCC |
BCD*10.3 |
Reconciliation Credit Card Charge |
|
| RECWOSUM |
BCD*10.3 |
Write-Off Amount |
|
| CURFUNC |
String*3 |
Functional Currency |
|
| CURSTMT |
String*3 |
Statement Currency |
|
| SUMAMOUNT |
BCD*10.3 |
Summated Transaction Amount |
|
| RECSPREAD |
BCD*10.3 |
Reconciliation Spread |
|
| RECPAMOUNT |
BCD*10.3 |
Fiscal Transaction Remaining In Transit |
|
| RECPOUTSTD |
BCD*10.3 |
Fiscal Outstanding Amount |
|
| RECPWO |
BCD*10.3 |
Fiscal Write Offs |
|
| RECPERR |
BCD*10.3 |
Fiscal Bank Errors |
|
| RECPGAIN |
BCD*10.3 |
Fiscal Exchange Gain |
|
| RECPLOSS |
BCD*10.3 |
Fiscal Exchange Loss |
|
| RECPCCC |
BCD*10.3 |
Fiscal Credit Card Charge |
|
| RECPCLR |
BCD*10.3 |
Fiscal Cleared |
|
| RECPFUNAM |
BCD*10.3 |
Fiscal Functional Amount |
|
| RECPORIG |
BCD*10.3 |
Fiscal Original Transaction Amount |
|
| RECTBOOK |
BCD*10.3 |
Total Book Amount |
|
| RECPBOOK |
BCD*10.3 |
Fiscal Book Amount |
|
| RECTREMAIN |
BCD*10.3 |
Total Remaining Amount |
|
| RECPREMAIN |
BCD*10.3 |
Fiscal Remaining Amount |
|
| RECRWOSUM |
BCD*10.3 |
Fiscal Write-Off To This Period |
|
| RECFCLR |
BCD*10.3 |
Fiscal Cleared To Future |
|
| RECRCLR |
BCD*10.3 |
Fiscal Cleared To Current |
|
| RECWOSUMR |
BCD*10.3 |
Current Period's Write-Off |
|
| RECFCLRR |
BCD*10.3 |
Posted Fiscal Cleared To Future |
|
| PAYMCODE |
String*12 |
Payment Code |
|
| CHKFORM |
String*6 |
Check Stock Code |
Mask: %-6N |
| OFXTID |
String*50 |
OFX Transaction ID |
|
| RECDELTAF |
BCD*10.3 |
Future Reconciliation Delta |
|
| FSCYEAR |
String*4 |
Fiscal Year |
Mask: %04D |
| FSCPERIOD |
Integer |
Fiscal Period |
|
| 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 |
|
| ENTRYTYPE |
Integer |
Entry Type |
|
| RECDELTA |
BCD*10.3 |
Reconciliation Amount Delta |
|
| POSTED |
Date |
Document Posted Date |
|
|