| PSTSEQ |
BCD*5.0 |
Posting Sequence |
|
| BANK |
String*8 |
Bank Code |
Mask: %-8N |
| SERIAL |
Long |
Transaction Header Serial |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| TRANSNUM |
BCD*5.0 |
Transaction Number |
|
| SRCEAPP |
String*2 |
Source Application |
Mask: %-2N |
| TRANSTYPE |
Integer |
Transaction Type |
List: 2 entries
|
| OLDSERIAL |
Long |
Old Serial Number |
|
| ENTRYTYPE |
Integer |
Entry Type |
List: 7 entries
| 1 | = | Bank Entered | | 2 | = | Miscellaneous | | 3 | = | Subledger | | 4 | = | Transfer | | 5 | = | Returned Customer Check | | 6 | = | Alignment | | 7 | = | Non Negotiable |
|
| REFERENCE |
String*60 |
Transaction Reference |
|
| DESC |
String*60 |
Transaction Description |
|
| TRANSDATE |
Date |
Transaction Date |
|
| FSCYEAR |
String*4 |
Fiscal Year |
Mask: %04D |
| FSCPERIOD |
Integer |
Fiscal Period |
|
| PRINTED |
Integer |
Transaction Slip Printed |
List: 2 entries
|
| TOTAMOUNT |
BCD*10.3 |
Transaction Total |
|
| TOTBALAMT |
BCD*10.3 |
Transaction Remaining Balance Amount |
|
| TOTCLEARED |
BCD*10.3 |
Fiscal Transaction Total |
|
| NXTLINE |
Long |
Next Transaction Detail Line |
|
| LINES |
Long |
Lines |
|
| LINESPOST |
Long |
Lines In Transit |
|
| LINESREC |
Long |
Lines Reconciled |
|
| STATUS |
Integer |
Transaction Status |
List: 8 entries
| 1 | = | Not posted | | 2 | = | Partially Outstanding | | 3 | = | Outstanding | | 4 | = | Partially reconciled | | 5 | = | Reconciled | | 6 | = | Pending Journal | | 7 | = | Posted | | 8 | = | Purged |
|
| 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 |
|
| RECAMOUNT |
BCD*10.3 |
Reconciliation Deposit Amount |
|
| RECOUTSTND |
BCD*10.3 |
Reconciliation In Transit Amt |
|
| SUMMARY |
Integer |
Transaction Recorded in Summary |
List: 4 entries
| 0 | = | Detail | | 1 | = | Summary | | 2 | = | Transfer | | 3 | = | Bank Error |
|
| RECCCC |
BCD*10.3 |
Reconciliation Credit Card Charge |
|
| RECCLEARED |
BCD*10.3 |
Amount Cleared |
|
| RECFUNCAMT |
BCD*10.3 |
Functional Transaction Amount |
|
| TOTFUNCAMT |
BCD*10.3 |
Functional Transaction Total |
|
| TOCLEAR |
BCD*10.3 |
Reconciliation Cleared Amount |
|
| TOWRITEOFF |
BCD*10.3 |
Write-Off Amount |
|
| TOREMAIN |
BCD*10.3 |
In Transit Amount |
|
| VARIANCE |
Integer |
Variance Type |
List: 6 entries
| 0 | = | None | | 1 | = | Outstanding amount | | 2 | = | Amount to write off | | 3 | = | Bank error | | 4 | = | Exchange rate difference | | 5 | = | Credit card charge |
|
| LINESREVIN |
Long |
Lines Can Reverse Invoice |
|
| POSTDATE |
Date |
Default Posting Date |
|
| RECSTATUS |
Integer |
Default Reconciliation Status |
List: 13 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 | | 13 | = | Deleted |
|
| RECCOMMENT |
String*60 |
Default Reconciliation Desc. |
|
| LINESJOUR |
Long |
Lines Journalled |
|
| LINESPUR |
Long |
Lines Purged |
|
| TOCLEARF |
BCD*10.3 |
Clear To Future Period |
|
| RECFCLR |
BCD*10.3 |
Fiscal Cleared To Future |
|
| RECRCLR |
BCD*10.3 |
Fiscal Cleared To Current |
|
| COMPLETED |
Integer |
Reconciled and Journaled Transaction |
List: 2 entries
| 0 | = | Not Completed | | 10 | = | Completed |
|
| RECWOSUMR |
BCD*10.3 |
Current Period's Write-Off |
|
| TOCLEARR |
BCD*10.3 |
Clear To Reconciliation Period |
|
| RECRWOSUM |
BCD*10.3 |
Fiscal Write-Off To This Period |
|
| RECPREM |
BCD*10.3 |
Fiscal Remaining Outstanding |
|
| RECTWO |
BCD*10.3 |
Total Delta Write Offs |
|
| RECTERR |
BCD*10.3 |
Total Delta Bank Errors |
|
| RECTGAIN |
BCD*10.3 |
Total Delta Exchange Gain |
|
| RECTLOSS |
BCD*10.3 |
Total Delta Exchange Loss |
|
| RECTCCC |
BCD*10.3 |
Total Delta Credit Card Charge |
|
| RECTCLR |
BCD*10.3 |
Total Delta Cleared |
|
| RECTFUNAM |
BCD*10.3 |
Total Delta Functional Amount |
|
| CURFUNC |
String*3 |
Functional Currency |
|
| CURSTMT |
String*3 |
Statement Currency |
|
| RECWOSUM |
BCD*10.3 |
Reconciliation Write Off Sum |
|
| POSTYEAR |
String*4 |
Reconciliation posting Year |
Mask: %04D |
| POSTPERIOD |
Integer |
Reconciliation posting Period |
|
| RECDELTA |
BCD*10.3 |
Reconciliation Delta |
|
| RECFCMISC |
BCD*10.3 |
Fiscal Miscellaneous Entry |
|
| RECFCWMISC |
BCD*10.3 |
Withdrawal Misc. Entries To Fiscal Period |
|
| RECFCDMISC |
BCD*10.3 |
Deposit Misc. Entries To Fiscal Period |
|
| RECFWMISC |
BCD*10.3 |
Withdrawal Misc. Entries To Future Period |
|
| RECFDMISC |
BCD*10.3 |
Deposit Misc. Entries To Future Period |
|
| PAYORNAME |
String*60 |
Payment Payee Name |
|
| VENDORNAME |
String*60 |
Payment Vendor Name |
|
| ENTRYNBR |
String*22 |
Bank Entry/Transfer Number |
|
| LINESPROC |
Long |
Lines Processed |
|
| REVINVC |
Integer |
Reverse Invoice |
List: 2 entries
|
| GLACCOUNT |
String*45 |
G/L Account of Discrepancy |
|
|