INSTDETAIL FILE
Intrastat Detail
This file maintains Intrastat distribution line information.
REFERENCED BY
IN120 PO31.1
UPDATED BY
AP20.1 AP20.2 AP20.5 AP20.7 AP23.1 AP30.2
AP30.4 AP520 AR42.2 AR560 BL92.1 IC22.1
IC22.2 IN20.1 MA40.1 MA40.2 MA41.1 MA41.2
MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3
MA43.4 MA52.1 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE510 OE810 OE920 PO20.1 PO22.2
PO22.3 RQ20.4 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IND-COMPANY Numeric 4 AP20.1 AP20.2
Company The company number represents an AP20.5 AP20.7
established company and is entered on AP23.1 AP30.2
all function codes. AP520 AR42.2
AR560 BL92.1
IC22.2 IN20.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO20.1 WH20.7
IND-FISCAL-YEAR Numeric 4 AP20.1 AP20.2
Fiscal year This is the current fiscal year. This AP20.5 AP20.7
field is updated by GL199 (Period AP23.1 AP30.2
Closing). AP520 AR42.2
AR560 BL92.1
IC22.2 IN20.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO20.1 WH20.7
IND-INTRASTAT-NBR Numeric 10 AP20.1 AP20.2
Intrastat Number The number assigned by the Intrastat AP20.5 AP20.7
system to a transaction that involves AP23.1 AP30.2
Intrastat reporting after it has been AP520 AR42.2
added. AR560 BL92.1
IC22.2 IN20.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO20.1 WH20.7
IND-MNT-LINE-NBR Numeric 4 AP20.1 AP20.2
Amount Line Number Line number for the distribution line. AP20.5 AP20.7
AP23.1 AP30.2
AP520 AR42.2
AR560 BL92.1
IC22.2 IN20.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO20.1 PO22.2
PO22.3 WH20.7
IND-BASE-AMT Signed 15.2 AP20.1 AP20.2
Base Amount The transaction's base amount. AP20.5 AP20.7
AP23.1 AP30.2
AP520 AR42.2
BL92.1 IC22.2
IN20.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 PO20.1
WH20.7
IND-COMMODITY Alpha 8 AP20.1 AP20.2
Commodity The Intrastat commodity code. AP20.5 AP20.7
Represents a category of goods. Must be AP23.1 AP30.2
defined in IN03.1 (Commodity AP520 AR42.2
Maintenance). AR560 BL92.1
IC22.2 IN20.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO20.1 WH20.7
IND-WEIGHT Signed 9.3 AP20.1 AP20.2
Weight This field contains the unit weight of AP20.5 AP20.7
the item based on the stocking UOM. AP23.1 AP30.2
AP520 AR42.2
AR560 BL92.1
IC22.2 IN20.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO20.1 WH20.7
IND-SECONDARY-QTY Signed 13.4 AP20.1 AP20.2
Secondary Quantity This field contains the secondary AP20.5 AP20.7
quantity, which is tracked if the item AP23.1 AP30.2
is a catch weight item. This quantity AP520 AR42.2
is a memo quantity only. It is not used AR560 BL92.1
for valuation. IC22.2 IN20.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO20.1 WH20.7
IND-SEC-UOM Alpha 4 AP20.1 AP20.2
Secondary Unit of This field contains the secondary AP20.5 AP20.7
Measure quantity unit of measure. AP23.1 AP30.2
AP520 AR42.2
AR560 BL92.1
IC22.2 IN20.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO20.1 WH20.7
INSTDETAIL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
INDSET1 COMPANY Accesses Intrastat detail information AP20.1 AP20.2
FISCAL-YEAR by line number. AP20.5 AP20.7
INTRASTAT-NBR AP23.1 AP30.2
MNT-LINE-NBR AP30.4 AR42.2
BL92.1 IC22.1
IC22.2 IN120
IN20.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
...
|