- Home
- Resources
- SAP Tables
- FMFGT_IPAC_STATS - US Federal IPAC interface process status table
SAP Table FMFGT_IPAC_STATS
US Federal IPAC interface process status table
FMFGT_IPAC_STATS (US Federal IPAC interface process status table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link FMFGT_IPAC_STATS to other SAP tables.
Source: FMFGT_IPAC_STATS (US Federal IPAC interface process status table)
FMFGT_IPAC_STATS table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| CLIENT |
Client |
MANDT |
|
CLNT |
|
3 |
0 |
|
| BUKRS |
Company Code |
BUKRS |
|
CHAR |
|
4 |
0 |
|
| DOCREF |
IPAC Document Reference Number |
IPAC_DOCREF |
FMFGT_IPAC_FILE
|
CHAR |
|
8 |
0 |
|
| JOBNUM |
US Fed. IPAC Interface Process Job Number |
IPACJOB |
|
CHAR |
|
20 |
0 |
|
| BUZEI |
Number of Line Item Within Accounting Document |
BUZEI |
|
NUMC |
|
3 |
0 |
|
| TRANSID |
US Fed. IPAC Interface Transaction ID |
IPAC_TRANSID |
|
CHAR |
|
3 |
0 |
Possible values
| 810 |
Outgoing Collection |
| 820 |
Outgoing Payment |
| 830 |
Outgoing Collection Confirmation |
| 840 |
Outgoing Payment Confirmation |
| 850 |
Incoming Collection |
| 860 |
Incoming Payment |
| 812 |
IPAC Adjustment |
| 816 |
IPAC Adjustment Confirm |
|
| SNDR_ALC |
Agency Location Code |
FMFG_ALC |
|
CHAR |
|
8 |
0 |
|
| SNDR_DOS |
Payment Office |
FMFG_PMT_OFF |
|
CHAR |
|
5 |
0 |
|
| DATUM |
Date |
DATUM |
|
DATS |
|
8 |
0 |
|
| FSNUM |
US Fed. Fiscal Station Number |
FMFG_FSN |
|
CHAR |
|
8 |
0 |
|
| USNAM |
User name |
USNAM |
|
CHAR |
|
12 |
0 |
|
| STATUS |
IPAC Process Status |
IPAC_STATUS |
|
CHAR |
|
1 |
0 |
Possible values
| I |
In-Transit |
| A |
Accepted |
| R |
Rejected |
| M |
Manual Confirm required for rejection |
| V |
Void due to In-transit doc being reversed |
|
| FILEID |
File ID from US Fed. IPAC system |
IPAC_ID |
|
CHAR |
|
8 |
0 |
|
| RECNBR |
Relative Record Number from IPACing file |
IPAC_RECNBR |
|
CHAR |
|
4 |
0 |
|
| TREAS_TRANSID |
US Fed. IPAC Interface Transaction ID for reporting |
IPAC_TREAS_TRANSID |
|
CHAR |
|
3 |
0 |
Possible values
| 810 |
Outgoing Collection |
| 820 |
Outgoing Payment |
| 830 |
Outgoing Collection Confirmation |
| 840 |
Outgoing Payment Confirmation |
| 850 |
Incoming Collection |
| 860 |
Incoming Payment |
| 812 |
IPAC Adjustment |
| 816 |
IPAC Adjustment Confirm |
|
FMFGT_IPAC_STATS foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| FMFGT_IPAC_STATS |
DOCREF |
FMFGT_IPAC_STATS |
CLIENT |
FMFGT_IPAC_FILE |
US Federal IPAC outgoing file ID |
CLIENT |
| FMFGT_IPAC_STATS |
DOCREF |
* |
|
FMFGT_IPAC_FILE |
US Federal IPAC outgoing file ID |
FILEID |
| FMFGT_IPAC_STATS |
DOCREF |
FMFGT_IPAC_STATS |
BUKRS |
FMFGT_IPAC_FILE |
US Federal IPAC outgoing file ID |
BUKRS |
| FMFGT_IPAC_STATS |
DOCREF |
FMFGT_IPAC_STATS |
DOCREF |
FMFGT_IPAC_FILE |
US Federal IPAC outgoing file ID |
DOCREF |
| FMFGT_IPAC_STATS |
DOCREF |
* |
|
FMFGT_IPAC_FILE |
US Federal IPAC outgoing file ID |
BELNR |
| FMFGT_IPAC_STATS |
DOCREF |
* |
|
FMFGT_IPAC_FILE |
US Federal IPAC outgoing file ID |
GJAHR |
| FMFGT_IPAC_STATS |
DOCREF |
* |
|
FMFGT_IPAC_FILE |
US Federal IPAC outgoing file ID |
BUZEI |
