AR Table Interface - ARSPTI
The AR Table Interface utility fetches data within the ar_int-dtl table and places it in either AR or CR sets. Data within the ar_int-dtl table tells ARSPTI how to organize and interface the data.
Common Codes
Common Codes (NUUPCD) that customize ARSPTI features:
ARDS/AR240C - Run process in Test or Debug mode, be sensitive to the batch status, to distribute created batches automatically and to specify certain printers. Enable ability to append records to the ar_int_dtl table rather than overwriting.
GLEM/REDIRECT- Notify specific users when account numbers have been redirected to suspense accounts as defined on the GLJE/REDIRECT common code. Up to five users may be notified.
ARSPTI Table Format
Column Heading | Column Format | AR Set | CR Set |
|---|---|---|---|
ARID_BATCH_ID | CHAR(16) | Set ID | Set ID |
ARID_PE_ID | CHAR(12) | Account ID | Account ID |
ARID_TERM | CHAR(8) | Term | Term |
ARID_DIV | CHAR(4) | Division Code | Division Code |
ARID_FIN_CD | CHAR(8) | ||
ARID_DESC | CHAR(30) | Description per user | Description per user |
ARID_REF | CHAR(16) | Invoice | Ref |
ARID_REF2 | CHAR(16) | Receipt | |
ARID_DIST_AMT | NUMBER(20,2) | Set tab user total | Set tab user total |
ARID_REF_AMT | NUMBER(20,2) | User Invoice total | User Receipt total |
ARID_UNITS | NUMBER(20,5) | Quantity | Quantity |
ARID_GL_GR | CHAR(2) | Ledger | Ledger |
ARID_GL_KEY | CHAR(10) | Org key (key format) | Org key (key format) |
ARID_GL_OBJ | CHAR(8) | Object | Object |
ARID_JL_GR | CHAR(2) | ||
ARID_JL_KEY | CHAR(10) | ||
ARID_JL_OBJ | CHAR(8) | ||
ARID_REF_DT | DATE | ||
ARID_DUE_DT | DATE | ||
ARID_PRODUCT_ID | CHAR(16) | ||
ARID_ORIG_AMT | NUMBER(20,3) | Extended Amount | Extended Amount |
ARID_PREP_ID | CHAR(8) | ||
ARID_MISC | CHAR(4) | ||
ARID_CURR_CD | CHAR(4) | ||
ARID_BANK_ID | CHAR(2) | ** do not use ** | Bank ID |
ARID_PEDB_CODE | CHAR(2) | P or E | P or E |
ARID_PAY_TYPE | CHAR(2) | ** do not use ** | Payment Type |
ARID_TRNS_FORMAT | CHAR(2) | Trans format | Trans format |
ARID_TRNS_STATUS | CHAR(2) | ||
ARID_TRNS_TYPE | CHAR(2) | AR | CR |
ARID_HIT_AR | CHAR(1) | Y | N |