PSTSEQ |
1 |
BCD*5.0 |
Posting Sequence |
E A K R |
|
BANK |
2 |
String*8 |
Bank Code |
E A K R |
Mask: %-8N |
CHECK |
3 |
BCD*5.0 |
Check Number |
E A K R |
|
SERIAL |
4 |
Long |
Serial Number |
E A K R |
|
STATUS |
5 |
Integer |
Check Status |
E A |
List: 9 entries
1 | = | Alignment | 2 | = | Void | 3 | = | Outstanding | 4 | = | Reversed | 6 | = | Cleared with bank error | 7 | = | Non-negotiable | 8 | = | Continuation | 9 | = | Printed | 10 | = | Posting error |
|
SRCEAPP |
6 |
String*2 |
Source Application |
E A |
Mask: %-2N |
CHKTYPE |
7 |
Integer |
Check Type |
E A |
List: 7 entries
1 | = | Check | 2 | = | EFT | 3 | = | Transfer | 4 | = | Service Charge | 5 | = | Credit Card | 6 | = | Cash | 7 | = | Other |
|
CHKFORM |
8 |
String*6 |
Check Stock Code |
E A |
Mask: %-6N |
PAYEEID |
9 |
String*12 |
Payee Code |
E A |
Mask: %-12C |
PAYEENAME |
10 |
String*60 |
Payee Name |
E A |
|
VENDORNAME |
11 |
String*60 |
Vendor Name |
E A |
|
REFERENCE |
12 |
String*60 |
Check Reference |
E A |
|
COMMENT |
13 |
String*60 |
Check Description |
E A |
|
POSTED |
14 |
Date |
Date Check Printed |
E A |
|
CHKDATE |
15 |
Date |
Check Date |
E A |
|
ISSUED |
16 |
BCD*10.3 |
Functional Check Amount |
E A |
|
SISSUED |
17 |
BCD*10.3 |
Check Amount |
E A |
|
RATETYPE |
18 |
String*2 |
Exchange Rate Type |
E A |
Mask: %-2N |
SRCECURN |
19 |
String*3 |
Payment Currency |
E A |
Mask: %-3N |
RATEDATE |
20 |
Date |
Exchange Rate Date |
E A |
|
RATE |
21 |
BCD*8.7 |
Exchange Rate |
E A |
|
RATESPREAD |
22 |
BCD*8.7 |
Rate Spread |
E A |
|
RATEOP |
23 |
Integer |
Rate Operation |
E A |
List: 3 entries
1 | = | Multiply | 2 | = | Divide | 0 | = | Not Specified |
|
RECSTATUS |
24 |
Integer |
Reconciliation Status |
E A |
List: 13 entries
1 | = | Alignment | 2 | = | Void | 3 | = | Outstanding | 4 | = | Reversed | 5 | = | Cleared | 6 | = | Cleared with bank error | 7 | = | Non-negotiable | 8 | = | Continuation | 9 | = | Printed | 10 | = | Posting error | 11 | = | Cleared with write-off | 12 | = | Cleared with exchange rate difference | 13 | = | Cleared with credit card charge |
|
RECSTATCHG |
25 |
Date |
Status Change Date |
E A |
|
RECCOMMENT |
26 |
String*60 |
Reconciliation Description |
E A |
|
RECCLEARED |
27 |
BCD*10.3 |
Reconciliation Amount Cleared |
E A |
|
FSCYEAR |
28 |
String*4 |
Fiscal Year |
E A |
Mask: %04D |
FSCPERIOD |
29 |
Integer |
Fiscal Period |
E A |
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 |
|
TTYPE |
30 |
String*6 |
Transaction Type |
E A |
Mask: %-6N |
RECERR |
31 |
BCD*10.3 |
Reconciliation Error |
E A |
|
RECERRPEND |
32 |
BCD*10.3 |
Reconciliation Error Pending |
E A |
|
RECEXGAIN |
33 |
BCD*10.3 |
Reconciliation Exchange Gain |
E A |
|
RECEXLOSS |
34 |
BCD*10.3 |
Reconciliation Exchange Loss |
E A |
|
RECSUGGEST |
35 |
Integer |
Reconciliation Suggestion |
E A |
|
RECCHECK |
36 |
BCD*10.3 |
Reconciliation Check Amount |
E A |
|
RECOUTSTND |
37 |
BCD*10.3 |
Reconciliation Outstanding Amount |
E A |
|
RECTARGET |
38 |
Integer |
Reconciliation Target |
E A |
|
IDACCT |
39 |
String*45 |
G/L Account |
E A |
|
IDACCTOVR |
40 |
Boolean |
Account Number Override |
E A |
|
RECDATE |
41 |
Date |
Reconciliation Date |
E A |
|
RECYEAR |
42 |
String*4 |
Reconciliation Fiscal Year |
E A |
|
RECPERIOD |
43 |
Integer |
Reconciliation Fiscal Period |
E A |
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 |
44 |
Boolean |
Reconciled |
E A |
|
RECDELTA |
45 |
BCD*10.3 |
Reconciliation Amount Delta |
E A |
|
CCTYPE |
46 |
String*12 |
Credit Card Type |
E A |
Mask: %-12N |
CCNAME |
47 |
String*60 |
Cardholder Name |
E A |
|
DDTYPE |
48 |
Integer |
Drilldown Type |
E A |
|
DDLINK |
49 |
BCD*10.0 |
Drilldown Link |
E A |
|
RECCCC |
50 |
BCD*10.3 |
Reconciliation Credit Card Charge |
E A |
|
RECPENDING |
51 |
BCD*10.3 |
Bank Error Outstanding |
E A |
|
RECWOSUM |
52 |
BCD*10.3 |
Reconciliation Write Off Sum |
E A |
|
CURFUNC |
53 |
String*3 |
Functional Currency |
E A |
|
CURSTMT |
54 |
String*3 |
Statement Currency |
E A |
|
RECDELTAF |
55 |
BCD*10.3 |
Functional Discrepancy |
E A |
|
CCEXP |
56 |
Date |
Expiry Date |
E A |
|
PAYMCODE |
57 |
String*12 |
Payment Code |
E A |
|
SRCEDOCNUM |
58 |
String*22 |
Source Document Number |
E A |
|
CANREVINVC |
59 |
Integer |
Can Reverse Invoice |
E A |
List: 2 entries
|
REVINVC |
60 |
Integer |
Reverse Invoice |
E A |
List: 2 entries
|
RECRCLR |
61 |
BCD*10.3 |
Fiscal Cleared To Current |
E A |
|
RECFCLR |
123 |
BCD*10.3 |
Fiscal Cleared To Future |
E A |
|
RECTCHKB |
124 |
BCD*10.3 |
Total Book Amount |
E A |
|
RECTCHKREM |
125 |
BCD*10.3 |
Total Remaining Amount |
E A |
|
SUMCHECK |
126 |
BCD*10.3 |
Summated Withdrawal Amount |
E A |
|
POSTDATE |
127 |
Date |
Post Date |
E A |
|
|