| PSTSEQ |
BCD*5.0 |
Posting Sequence |
|
| BANK |
String*8 |
Bank Code |
Mask: %-8N |
| SERIAL |
Long |
Deposit Header Serial |
|
| LINE |
Long |
Deposit Detail Line |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| SRCEAPP |
String*2 |
Source Application |
Mask: %-2N |
| STATUS |
Integer |
Deposit Status |
List: 5 entries
| 1 | = | Not posted | | 2 | = | Void | | 3 | = | In transit | | 5 | = | Cleared with bank error | | 7 | = | Returned |
|
| DEPTYPE |
Integer |
Deposit Type |
List: 6 entries
| 1 | = | Deposit (Other) | | 2 | = | EFT | | 3 | = | Transfer | | 4 | = | Customer Check | | 5 | = | Credit Card | | 6 | = | Cash |
|
| IDREMIT |
String*24 |
Remittance ID |
|
| DATEREMIT |
Date |
Remit Date |
|
| BTCHNBR |
BCD*5.0 |
Batch Number |
|
| ENTRYNBR |
BCD*4.0 |
Entry Number |
|
| POSTSEQ |
BCD*5.0 |
Posting Sequence Number |
|
| POSTDATE |
Date |
Date Posted |
|
| REFERENCE |
String*60 |
Deposit Reference |
|
| COMMENT |
String*60 |
Deposit Description |
|
| PAYORID |
String*12 |
Payor ID |
|
| PAYORNAME |
String*60 |
Payor Name |
|
| DEPAMT |
BCD*10.3 |
Functional Deposit Amount |
|
| SDEPAMT |
BCD*10.3 |
Deposit Amount |
|
| RATETYPE |
String*2 |
Exchange Rate Type |
Mask: %-2N |
| SRCECURN |
String*3 |
Payment 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 |
|
| TTYPE |
String*6 |
Transaction Type |
Mask: %-6N |
| IDACCT |
String*45 |
G/L Account |
Mask: %-45C |
| IDACCTOVR |
Boolean |
Account Number Override |
|
| CCTYPE |
String*12 |
Credit Card Type |
Mask: %-12N |
| CCNAME |
String*60 |
Cardholder Name |
|
| DDTYPE |
Integer |
Drilldown Type |
|
| DDLINK |
BCD*10.0 |
Drilldown Link |
|
| RECSTATUS |
Integer |
Reconciliation Status |
List: 9 entries
| 1 | = | Not posted | | 2 | = | Void | | 3 | = | In transit | | 4 | = | Cleared | | 5 | = | Cleared with bank error | | 6 | = | Cleared with write-off | | 7 | = | Returned | | 8 | = | Cleared with exchange rate difference | | 9 | = | Cleared with credit card charge |
|
| RECSTATCHG |
Date |
Status Change Date |
|
| RECCOMMENT |
String*60 |
Reconciliation Description |
|
| RECCLEARED |
BCD*10.3 |
Reconciliation Amount Cleared |
|
| RECDATE |
Date |
Reconciliation Date |
|
| RECYEAR |
String*4 |
Reconciliation Fiscal Year |
Mask: %04D |
| RECPERIOD |
Integer |
Reconciliation Fiscal Period |
List: 14 entries
| 0 | = | | | 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 |
|
| RECONCILED |
Boolean |
Reconciled |
|
| 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 |
|
| RECDEPOSIT |
BCD*10.3 |
Reconciliation Deposit Amount |
|
| RECTRANSIT |
BCD*10.3 |
Reconciliation In Transit Amt |
|
| RECTARGET |
Integer |
Reconciliation Target |
|
| RECDELTA |
BCD*10.3 |
Reconciliation Amount Delta |
|
| RECCCC |
BCD*10.3 |
Reconciliation Credit Card Charge |
|
| RECPENDING |
BCD*10.3 |
Bank Error In Transit |
|
| RECWOSUM |
BCD*10.3 |
Reconciliation Write Off Sum |
|
| CURFUNC |
String*3 |
Functional Currency |
|
| CURSTMT |
String*3 |
Statement Currency |
|
| PAYMCODE |
String*12 |
Payment Code |
|
| RECDELTAF |
BCD*10.3 |
Functional Discrepancy |
|
| CCEXP |
Date |
Expiry Date |
|
| FSCYEAR |
String*4 |
Fiscal Year |
|
| FSCPERIOD |
Integer |
Fiscal Period |
List: 14 entries
| 0 | = | | | 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 |
|
| SRCEDOCNUM |
String*22 |
Source Document Number |
|
| CANREVINVC |
Integer |
Can Reverse Invoice |
List: 2 entries
|
| REVINVC |
Integer |
Reverse Invoice |
List: 2 entries
|
| RECRCLR |
BCD*10.3 |
Fiscal Cleared To Current |
|
| RETDATE |
Date |
Return Date |
|
|