SAP table FMFGT_IPAC_STATS (US Federal IPAC interface process status table)

SAP table FMFGT_IPAC_STATS has 5 primary key fields being CLIENT,BUKRS,DOCREF,JOBNUM,BUZEI.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 * MANDT
BUKRS Company Code CHAR 4 0 * BUKRS
DOCREF IPAC Document Reference Number CHAR 8 0 FMFGT_IPAC_FILE IPAC_DOCREF
JOBNUM US Fed. IPAC Interface Process Job Number CHAR 20 0 IPACJOB
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
TRANSID US Fed. IPAC Interface Transaction ID CHAR 3 0 IPAC_TRANSID
810 Outgoing Collection
812 IPAC Adjustment
816 IPAC Adjustment Confirm
820 Outgoing Payment
830 Outgoing Collection Confirmation
840 Outgoing Payment Confirmation
850 Incoming Collection
860 Incoming Payment
SNDR_ALC Agency Location Code CHAR 8 0 * FMFG_ALC
SNDR_DOS Payment Office CHAR 5 0 * FMFG_PMT_OFF
DATUM Date DATS 8 0 DATUM
FSNUM US Fed. Fiscal Station Number CHAR 8 0 * FMFG_FSN
USNAM User Name CHAR 12 0 * USNAM
STATUS IPAC Process Status CHAR 1 0 IPAC_STATUS
A Accepted
I In-Transit
M Manual Confirm required for rejection
R Rejected
V Void due to In-transit doc being reversed
FILEID File ID from US Fed. IPAC system CHAR 8 0 IPAC_ID
RECNBR Relative Record Number from IPACing file CHAR 4 0 IPAC_RECNBR
TREAS_TRANSID US Fed. IPAC Interface Transaction ID for reporting CHAR 3 0 IPAC_TREAS_TRANSID

FMFGT_IPAC_STATS foreign key relationships

Table Field Check Table Check Field
0 FMFGT_IPAC_STATS DOCREF FMFGT_IPAC_FILE US Federal IPAC outgoing file ID BUKRS
0 FMFGT_IPAC_STATS DOCREF FMFGT_IPAC_FILE US Federal IPAC outgoing file ID BELNR
0 FMFGT_IPAC_STATS DOCREF FMFGT_IPAC_FILE US Federal IPAC outgoing file ID GJAHR
0 FMFGT_IPAC_STATS DOCREF FMFGT_IPAC_FILE US Federal IPAC outgoing file ID BUZEI