INSTDETAIL

Intrastat Detail Transactions

REFERENCED BY
MA54.2


UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.1 AP30.2 AP30.4
AP520 API1.1 API2.1 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MAI1.1 PO136 PO190 PO300 PO520
POCP.1 POI3.1 POII.1 POIJ.1 IN20.1 IN120

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ING-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
IN20.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ING-FISCAL-YEAR
Element: Year
Numeric 4
Contains the fiscal year for the data stored on this record.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
IN20.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ING-INTRASTAT-NBR
Element: Intrastat Nbr
Numeric 12
The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
IN20.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ING-MNT-LINE-NBR
Element: Mnt Line Nbr
Numeric 4
Line number for the distribution line.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
IN20.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ING-BASE-AMT
Element: Intl Amt
Signed 18.2
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
IN20.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ING-ICN-CODE
Element: Icn Code
Alpha 8
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
IN20.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ING-WEIGHT
Element: Weight
Signed 9.3
This field contains the unit weight of the item based on the stocking UOM.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
IN20.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ING-RECEIVED-AMT
Element: Intl Amt
Signed 18.2
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
IN20.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ING-SUPLMNTARY-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
IN20.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ING-SUPLMNTARY-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
IN20.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1


INSTDETAIL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
INGSET1 COMPANY
FISCAL-YEAR
INTRASTAT-NBR
MNT-LINE-NBR
MA54.2 IN120
INGSET2 COMPANY
INTRASTAT-NBR
MNT-LINE-NBR
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6


File created: Wed Jun 08 20:51:45 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.