CSMS Message: 92-000339

Title:NEW ADCVD FILE EXTRACT AVAILABLE
Date:1992-08-17
To:abi
Links:previous, next

NEW AD/CVD DUTY REFERENCE FILE EXTRACT AVAILABLE

REFERENCE: ADMIN MESSAGE 0953, DATED 12/03/91

THE NEW EXTRACT REFERENCE FILE CAPABILITY FOR THE AD/CVD CASE REFER-
ENCE FILES HAS BEEN MOVED TO PRODUCTION AND IS AVAILABLE FOR ABI USERS.
THIS NEW EXTRACT REQUEST TRANSACTION HAS A UNIQUE INPUT RECORD. THE
APPLICATION ID'S FOR INPUT AND OUTPUT ARE: 'IP' FOR INPUT AND 'IT' FOR
OUTPUT. THIS IS AN OPTIONAL TRANSACTION AND HAS BEEN PROVIDED BASED ON
USER REQUESTS AS AN ALTERNATIVE TO THE 'CN' QUERY FOR OBTAINING AD/CVD
INFORMATION.

ADMIN MESSAGE 0953 PROVIDED THE SPECIFICATIONS FOR THIS NEW CAPABILITY.
FOR USERS WHO MAY NOT HAVE RECEIVED THOSE SPECIFICATIONS, THEY ARE
AGAIN BEING PROVIDED, AS FOLLOWS:

ALTHOUGH DETAIL OUTPUT RECORDS 'C3' THRU 'C8' ARE EXACTLY THE
SAME LAYOUTS AS THE CURRENT 'CN' QUERY, THERE IS A NEW 'C2' RECORD
RECORD TO RETURN INPUT. BECAUSE THE INPUT RECORD FOR THIS TRANSAC-
TION IS DIFFERENT THAN THE 'CN' INPUT, THE 'C2' RECORD RETURNED
FOR THIS TRANSACTION WILL DIFFER FROM THAT RETURNED FOR 'CN'. AS
WITH 'CN', A 'C2' RECORD WILL BE RETURNED FOR EACH INPUT RECORD RE-
QUEST. 'C3' THRU 'C8' RECORDS WILL BE BLOCKED UNDER THE 'C2'.
THERE MAY BE MULTIPLE 'C3' THRU 'C8' RECORDS UNDER ONE 'C2' AND
THERE MAY BE MULTIPLE 'C2' RECORDS FOR A TRANSMISSION.

THE 'C9' ERROR RECORD FOR THE NEW TRANSACTION ALSO DIFFERS
FROM THE 'C9' ERROR RECORD FOR 'CN' SINCE WE ARE RETURNING A 'C2'
AND THE INPUT PARAMETERS FOR THE TRANSACTION DIFFER FROM 'CN'. THE
NEW 'C9' WILL FOLLOW A 'C2' AND WILL GIVE THE NARRATIVE ERROR
MESSAGE AND THE ERROR CODE.

FILE EXTRACT REQUESTS MAY BE MADE AT ANY TIME, BUT ERROR-FREE REQUESTS
WILL BE STORED AND RUN DURING NORMAL END-OF-DAY PROCESSING. 'IP' JOBS
WILL BE EDITED FOR INPUT ERRORS AT THE TIME THE JOB IS SUBMIITED, AS
WITH ANY OTHER ABI TRANSACTION. HOWEVER, ANY ERROR WITHIN THE A-Z
APPLICATION WILL CAUSE THE ENTIRE A-Z BLOCK TO REJECT. THIS IS NEEDED
SO THAT ERROR-FREE BLOCKS CAN BE STORED FOR END-OF-DAY PROCESSING. JOBS
THAT ARE ERROR-FREE WILL BE RUN AT END-OF-DAY AND OUTPUT GENERATED,
MUCH LIKE STATEMENTS.

SPECIFICATIONS FOR EXTRACT/RECORD LAYOUTS
=========================================

IP. ANTIDUMPING/COUNTERVAILING DUTY CASE FILE EXTRACT
-------------------------------------------------

TASK NAME: EXTRACT AD/CVD CASE FILE INPUT
-----------------------------------------

FOLLOWING IS THE REVISED INPUT RECORD LAYOUT FOR THIS QUERY:

APPLICATION NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY CASE QUERY
----------------------------------------------------
RECORD NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY QUERY - INPUT
----------------------------------------------------
OPTIONAL
X MANDATORY
CONDITIONAL

RECORD REFERENCE NUMBER C1
---------------------------

----------------------------------------------------------------------
DATA ELEMENT NAME | LENGTH/CLASS POSITION | STATUS | REMARKS
----------------------------------------------------------------------
CONTROL IDENTIFIER | 1A 1,1 | M | MUST BE "C"
----------------------------------------------------------------------
RECORD TYPE | 1N 2,2 | M | '1' OR SPACE
----------------------------------------------------------------------
ALL COUNTRIES | 1X 3,3 | C | '1' OR SPACE
----------------------------------------------------------------------
GIVEN COUNTRY ONLY | 2A 4,5 | C | ISO CTRY CODE
----------------------------------------------------------------------
ACTIVE AND REVOKED | 1X 6,6 | C | '1' OR SPACE
----------------------------------------------------------------------
ACTIVE RECORDS ONLY| 1X 7,7 | C | '1' OR SPACE
----------------------------------------------------------------------
RET ALL INFO | 1X 8,8 | C | '1' OR SPACE
----------------------------------------------------------------------
RET CASE INFO C3,C4| 1X 9,9 | C | '1' OR SPACE
----------------------------------------------------------------------
RET RATES/BNDING C5| 1X 10,10 | C | '1' OR SPACE
----------------------------------------------------------------------
RET TARIFFS C4,C6 | 1X 11,11 | C | '1' OR SPACE
----------------------------------------------------------------------
RET NAMES C7,C8 | 1X 12,12 | C | '1' OR SPACE
----------------------------------------------------------------------
FILLER | 69X 13,80 | | SPACE FILL
----------------------------------------------------------------------

1. CONTROL IDENTIFIER WILL = 'C'. RECORD TYPE WILL = '1'. INPUT IS
MANDATORY.

2. IF USER DESIRES A RETURN FOR ALL CASES EXISTING ON FILE, USER
WILL INSERT A '1' IN POSITION 3. IF USER DOES NOT DESIRE RETURN FOR
ALL EXISTING CASES, FIELD WILL = SPACE. IF FIELD = SPACE, POSITIONS
4-5 OF INPUT RECORD MUST BE > SPACES.

3. IF USER DESIRES A RETURN ONLY FOR ALL CASES ASSOCIATED WITH A GIVEN
COUNTRY, USER WILL INPUT A VALID ISO CODE IN POSITIONS 4-5. THE CODE
WILL BE VALIDATED AND MUST BE 2 ALPHA POSITIONS. IF VALID, FILE WILL
BE ACCESSED BY COUNTRY AND A RETURN GIVEN FOR ALL RECORDS FOR THAT
COUNTRY. IF POSITIONS 4-5 > SPACES, POSITION 2 (FOR ALL CASES) MUST
= SPACE. IF POSITION 2 > SPACE, POSITIONS 4-5 MUST = SPACES.

4. THE USER WILL HAVE THE OPTION OF RECEIVING DATA BASED ON ABOVE
CHOICE FOR ALL CASES THAT ARE ON FILE FOR THE GIVEN PARAMETER, OR
ONLY FOR ALL CASES THAT ARE ACTIVE (IE - NOT REVOKED, TERMINATED OR
INVESTIGATION SUSPENDED STATUS).

IF USER DESIRES A RETURN FOR ALL CASES REGARDLESS OF STATUS, USER
WILL INPUT A '1' IN POSITION 6 OF THE INPUT RECORD. ANY OUTPUT REC-
ORDS THAT ARE ELECTED FOR RETURN (C3-C9) WILL BE GIVEN FOR ALL CASES
WITHIN THE SELECTED PARAMETER, REGARDLESS OF CASE STATUS. IF POSI-
TION 6 > SPACE, POSITION 7 OF INPUT RECORD MUST = SPACE. IF POSITION
7 > SPACE, POSITION 6 MUST = SPACE.

5. IF USER DOES NOT DESIRE A RETURN FOR ALL CASES REGARDLESS OF STATUS,
USER MAY ELECT TO RECEIVE OUTPUT ONLY FOR ACTIVE CASES (IE - NOT
REVOKED, TERMINATED OR INVESTIGATION SUSPENDED STATUS). IF THIS OP-
TION IS CHOSEN, ANY RETURN WILL ONLY BE FOR ACTIVE CASES WITHIN THE
GIVEN PARAMETER.

IF USER DESIRES RETURN ONLY FOR ACTIVE CASES, USER WILL INPUT A '1'
IN POSITION 7 OF THE INPUT RECORD. ANY OUTPUT RECORDS THAT ARE RE-
TURNED (C3-C9) WILL BE ONLY FOR ACTIVE CASES WITHIN THE GIVEN PARA-
METER. IF POSITION 7 > SPACE, POSITION 6 OF INPUT RECORD MUST =
SPACE. LIKEWISE, IF POSITION 7 = SPACE, POSITION 6 MUST BE > SPACE.

6. IF USER DESIRES TO GET A FULL CASE REFERENCE EXTRACT, INCLUDING ALL
APPLICABLE OUTPUT RECORDS FOR ALL CASES EXISTING ON FILE, USER WILL
INSERT A '1' IN POSITION 8. IF USER DOES NOT DESIRE FULL RETURN FOR
ALL CASES, THIS FIELD WILL = SPACE. IF POSITION 8 = SPACE, AT LEAST
1 OTHER POSITION (9-12) MUST BE > SPACE. IF POSITION 8 = '1', ALL
OTHER POSITIONS (9-12) MUST = SPACES. BASED ON CHOICE MADE ABOVE,
THE OUTPUT WOULD BE EITHER ALL CASES (ACTIVE AND OTHERWISE) OR
ACTIVE CASES ONLY.

7. IF USER DOES NOT DESIRE FULL RETURN (POSITION 8 OF INPUT RECORD =
SPACE), POSITION 9 MAY = '1' OR SPACE. IF POSITION 9 = SPACE, AT
LEAST ONE OTHER POSITION (10-12) MUST BE > SPACE. IF POSITION 9 =
'1', THE CASE HEADER INFORMATION IN CURRENT ABI QUERY OUTPUT RECORDS
C3 AND C4 WILL BE RETURNED FOR EITHER ALL CASES, OR ALL CASES FOR
THE GIVEN COUNTRY. THE RETURNED RECORDS WILL BE IDENTICAL IN FORMAT
AND DATA AS THE CURRENT C3 AND C4 OUTPUT FOR THE 'CN' QUERY. IF PO-
SITION 9 = '1', AT LEAST 1 OTHER POSITION (10-12) MUST = SPACE. OF
COURSE, BASED ON CHOICE ABOVE, OUTPUT WOULD BE FOR ALL ACTIVE AND
INACTIVE CASES, OR ONLY ACTIVE CASES.

8. IF USER DOES NOT DESIRE FULL RETURN (POSITION 8 OF INPUT RECORD =
SPACE), POSITION 10 MAY = '1' OR SPACE. IF POSITION 10 = SPACE, AT
LEAST ONE OTHER POSITION (9 OR 11-12) MUST BE > SPACE. IF POSITION
10 = '1', AT LEAST 1 OTHER POSITION (9 OR 11-12) MUST = SPACE. IF
POSITION 10 = 1, THE DEPOSIT RATE AND BND/CASH INFORMATION AS IN THE
CURRENT C5 OUTPUT RECORD OF THE 'CN' QUERY WILL BE RETURNED FOR
EITHER ALL CASES, OR ALL CASES FOR THE GIVEN COUNTRY. THE RETURNED
RECORDS WILL BE IDENTICAL IN FORM AND DATA TO THE CURRENT C5 OUTPUT
OF THE 'CN' QUERY. BASED ON CHOICE ABOVE, OUTPUT WOULD BE FOR ALL
ACTIVE AND INACTIVE, OR ONLY ACTIVE CASES. AS WITH THE 'CN' QUERY,
MULTIPLE C5 RECORDS MAY BE RETURNED FOR A GIVEN CASE IF NEEDED.

9. IF USER DOES NOT DESIRE FULL RETURN (POSITION 8 OF INPUT RECORD =
SPACE), POSITION 11 MAY = '1' OR SPACE. IF POSITION 11 = SPACE, AT
LEAST ONE OTHER POSITION (9-10 OR 12) MUST BE > SPACE. IF POSITION
11 = '1', AT LEAST 1 OTHER POSITION (9-10 OR 12) MUST = SPACE. IF
POSITION 11 = '1', THE TARIFF RECORDS AS IN THE CURRENT C6 RECORD
WILL BE RETURNED FOR EITHER ALL CASES, OR ALL CASES FOR THE GIVEN
COUNTRY. THE RETURNED RECORDS WILL BE IDENTICAL IN FORMAT AND DATA
AS THE CURRENT C6 OUTPUT FOR THE 'CN' QUERY. MULTIPLE C6 RECORDS MAY
BE RETURNED FOR A GIVEN CASE IF NEEDED. OF COURSE, BASED ON CHOICE
ABOVE, OUTPUT WOULD BE FOR ALL ACTIVE AND INACTIVE, OR ONLY ACTIVE
CASES. ADDITIONALLY, BECAUSE THE C6 RECORD DOES NOT CONTAIN THE CASE
NUMBER, WE WILL RETURN THE C4 RECORD. A C4 RECORD WILL ALWAYS BE RE-
TURNED BEFORE THE FIRST C6 RECORD FOR A CASE. THERE MAY BE MULTIPLE
C6 RECORDS.

10. IF USER DOES NOT DESIRE FULL RETURN (POSITION 8 OF INPUT RECORD =
SPACE), POSITION 12 MAY = '1' OR SPACE. IF POSITION 12 = SPACE, AT
LEAST ONE OTHER POSITION (9-11) MUST BE > SPACE. IF POSITION 12 =
'1', AT LEAST 1 OTHER POSITION (9-11) MUST = SPACE. IF POSITION 12
= '1', THE MANUFACTURER AND/OR SHIPPER NAMES IN THE CURRENT C7 AND
C8 OUTPUT RECORDS WILL BE RETURNED FOR EITHER ALL CASES, OR ALL
CASES FOR THE GIVEN COUNTRY. THE RETURNED RECORDS WILL BE IDENTICAL
IN FORMAT AND DATA AS THE CURRENT C7 AND C8 OUTPUT RECORDS FOR THE
'CN' QUERY. OF COURSE, BASED ON CHOICE ABOVE, OUTPUT WOULD BE ALL
ACTIVE AND INACTIVE, OR ONLY ACTIVE CASES.

=======================================================================

IT. ANTIDUMPING/COUNTERVAILING DUTY CASE FILE
-----------------------------------------------

TASK NAME: QUERY AD/CVD CASE FILE - OUTPUT
------------------------------------------

A RETURN OF A 'C2' RECORD GIVING A RETURN OF THE INPUT DATA WILL
BE MADE AS IS DONE FOR THE 'CN' ADCVD QUERY TRANSACTION.

NOTE THAT DETAIL RECORDS ARE 'C3' THRU 'C8'. THE ERROR RECORD IS
'C9'.

MULTIPLE RECORDS WILL BE RETURNED AS NEEDED.

REGARDLESS OF WHAT OUTPUT RECORDS ARE SELECTED IN THE INPUT RECORD, WE
WILL ALWAYS RETURN A 'C2' OUTPUT RECORD - ONE 'C2' FOR EACH 'C1'.
THE 'C2' WILL BE A MIRROR OF THE 'C1' INPUT. UNDER EACH 'C2', THERE
MAY BE MULTIPLE BLOCKS OF 'C3' THRU 'C8' (OR 'C9', IF ERROR) DE-
PENDING ON DATA REQUESTED AND RETURNED. IF MULTIPLE 'C1' RECORDS ARE
DONE ON A SINGLE 'IP' TRANSACTION, THERE WILL BE MULTIPLE BLOCKS OF
'C2' RECORDS FOLLOWED BY 'C3' THRU 'C8'. THIS WILL PERMIT MATCHING
OF 'C3' THRU 'C8' DATA WITH THE CORRESPONDING INPUT RECORDS.

APPLICATION NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY CASE QUERY
----------------------------------------------------
RECORD NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY QUERY - OUTPUT
----------------------------------------------------
OPTIONAL
X MANDATORY
CONDITIONAL

RECORD REFERENCE NUMBER C2
---------------------------

----------------------------------------------------------------------
DATA ELEMENT NAME | LENGTH/CLASS POSITION | STATUS | REMARKS
----------------------------------------------------------------------
CONTROL IDENTIFIER | 1A 1,1 | M | MUST BE "C"
----------------------------------------------------------------------
RECORD TYPE | 1N 2,2 | M | MUST BE "2"
----------------------------------------------------------------------
ALL COUNTRIES | 1X 3,3 | C | '1' OR SPACE
----------------------------------------------------------------------
GIVEN COUNTRY ONLY | 2A 4,5 | C | ISO CTRY CODE
----------------------------------------------------------------------
ACTIVE AND REVOKED | 1X 6,6 | C | '1' OR SPACE
----------------------------------------------------------------------
ACTIVE RECORDS ONLY| 1X 7,7 | C | '1' OR SPACE
----------------------------------------------------------------------
RET ALL INFO | 1X 8,8 | C | '1' OR SPACE
----------------------------------------------------------------------
RET CASE INFO C3,C4| 1X 9,9 | C | '1' OR SPACE
----------------------------------------------------------------------
RET RATES/BNDING C5| 1X 10,10 | C | '1' OR SPACE
----------------------------------------------------------------------
RET TARIFFS C4,C6 | 1X 11,11 | C | '1' OR SPACE
----------------------------------------------------------------------
RET NAMES C7,C8 | 1X 12,12 | C | '1' OR SPACE
----------------------------------------------------------------------
FILLER | 69X 13,80 | | SPACE FILL
----------------------------------------------------------------------

THE 'C2' IS A MIRROR OF THE 'C1' INPUT.

* A 'C2' RECORD WILL BE RETURNED FOR EACH 'C1' INPUT RECORD. THE DATA
IN POSITIONS 3,80 WILL BE EXACTLY AS GIVEN IN THE 'C1' RECORD. AC-
CORDINGLY, EACH OUTPUT SEQUENCE FOR A GIVEN INPUT RECORD WILL BEGIN
WITH A 'C2' RETURN RECORD.

EG - IF 3 INPUT QUERIES ARE GIVEN IN THE 'IP' TRANSACTION, WE WILL
RETURN RECORDS 'C2' THRU 'C8' (OR 'C9' IF ERROR) FOR INPUT
RECORD 1, THEN 'C2' THRU 'C8' FOR INPUT 2, ETC. IN THIS WAY,
USERS WILL BE ABLE TO MORE EASILY MATCH THEIR INPUT WITH THE
ASSOCIATED OUTPUT RECORDS. ACCORDINGLY, THERE WILL BE ONE
'C2' RECORD FOR EACH BLOCK (OR MULTIPLE BLOCKS, AS NEEDED) OF
'C3' THRU 'C8' RECORDS. THE PRESENCE OF A NEXT 'C2' RECORD
WILL INDICATE THE BEGINNING OF OUTPUT FOR A NEW INPUT RECORD.

=======================================================================

APPLICATION NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY CASE QUERY
----------------------------------------------------
RECORD NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY QUERY - OUTPUT
----------------------------------------------------
OPTIONAL
MANDATORY
X CONDITIONAL

RECORD REFERENCE NUMBER C3
---------------------------

----------------------------------------------------------------------
DATA ELEMENT NAME | LENGTH/CLASS POSITION | STATUS | REMARKS
----------------------------------------------------------------------
CONTROL IDENTIFIER | 1A 1,1 | M | MUST BE "C"
----------------------------------------------------------------------
RECORD TYPE | 1N 2,2 | M | MUST BE '3'
----------------------------------------------------------------------
ISO COUNTRY CODE | 2A 3,4 | M |
----------------------------------------------------------------------
CASE NUMBER | 10AN 5,14 | M |
----------------------------------------------------------------------
RELATED CASE | 10AN 15,24 | C |
----------------------------------------------------------------------
MANUFACTURER ID | 15AN 25,39 | C |
----------------------------------------------------------------------
SHIPPER ID | 15AN 40,54 | C |
----------------------------------------------------------------------
CASE STATUS | 1A 55,55 | M | * SEE BELOW
----------------------------------------------------------------------
CASE STATUS DATE | 6N 56,61 | M | MMDDYY
----------------------------------------------------------------------
BND/CASH INDICATOR | 1AN 62,62 | M | * SEE BELOW
----------------------------------------------------------------------
FILLER | 18AN 63,80 | | SPACE FILL
----------------------------------------------------------------------

* CASE STATUS - I = INITIATION * BND/CASH IND - 0 = N/A
P = PRELIMINARY B = BONDED
F = FINAL C = CASH REQ'D
O = ORDER
A = ADMIN REVIEW
S = INVEST SUSP
N = REINSTATED
R = REVOCATION
E = EXCLUDED
T = TERMINATED

NOTE: THE BOND/CASH INDICATOR GIVEN ON THE 'C3' OUTPUT RECORD WILL BE
THE LATEST INDICATOR, BY LATEST EFFECTIVE DATE, RETURNED ON THE
FIRST 'C5' RECORD.

======================================================================

APPLICATION NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY CASE QUERY
----------------------------------------------------
RECORD NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY QUERY - OUTPUT
----------------------------------------------------
OPTIONAL
MANDATORY
X CONDITIONAL

RECORD REFERENCE NUMBER C4
---------------------------

----------------------------------------------------------------------
DATA ELEMENT NAME | LENGTH/CLASS POSITION | STATUS | REMARKS
----------------------------------------------------------------------
CONTROL IDENTIFIER | 1A 1,1 | M | MUST BE 'C'
----------------------------------------------------------------------
RECORD TYPE | 1N 2,2 | M | MUST BE '4'
----------------------------------------------------------------------
CASE NUMBER | 10AN 3,12 | M |
----------------------------------------------------------------------
CONTACT | 20X 13,32 | C |
----------------------------------------------------------------------
PHONE | 10N 33,42 | C |
----------------------------------------------------------------------
LIQ SUSPENSION DATE| 6N 43,48 | C |
----------------------------------------------------------------------
SHORT DESCRIPTION | 30X 49,78 | M |
----------------------------------------------------------------------
FILLER | 2AN 79,80 | |
----------------------------------------------------------------------

* PHONE NUMBER EXPRESSED AS 10AN: POSITIONS 1-3 = AREA CODE
POSITIONS 4-6 = EXCHANGE
POSITIONS 7-10 = NUMBER

======================================================================

APPLICATION NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY CASE QUERY
----------------------------------------------------
RECORD NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY QUERY - OUTPUT
----------------------------------------------------
OPTIONAL
MANDATORY
X CONDITIONAL

RECORD REFERENCE NUMBER C5
---------------------------

----------------------------------------------------------------------
DATA ELEMENT NAME | LENGTH/CLASS POSITION | STATUS | REMARKS
----------------------------------------------------------------------
CONTROL IDENTIFIER | 1A 1,1 | M | MUST BE 'C'
----------------------------------------------------------------------
RECORD TYPE | 1N 2,2 | M | MUST BE '5'
----------------------------------------------------------------------
CASE NUMBER | 10AN 3,12 | M |
----------------------------------------------------------------------
RATE INDICATOR | 1N 13,13 | M |0=NONE 1=RATE
----------------------------------------------------------------------
DEPOSIT RATE-1 | 5N 14,18 | C | * (1)V9999
----------------------------------------------------------------------
DEPOSIT RATE-2 | 5N 19,23 | C | * (1)V9999
----------------------------------------------------------------------
DEPOSIT RATE-3 | 5N 24,28 | C | * (1)V9999
----------------------------------------------------------------------
EFF ENTRY DATE | 6N 29,34 | C | MMDDYY
----------------------------------------------------------------------
EFF EXPORT DATE | 6N 35,40 | C | MMDDYY
----------------------------------------------------------------------
BND/CASH IND-1 | 1AN 41,41 | M | * SEE BELOW
----------------------------------------------------------------------
BND/CASH-1 DATE | 6N 42,47 | M | MMDDYY
----------------------------------------------------------------------
BND/CASH IND-2 | 1AN 48,48 | C | * SEE BELOW
----------------------------------------------------------------------
BND/CASH-2 DATE | 6N 49,54 | C | MMDDYY
----------------------------------------------------------------------
BND/CASH IND-3 | 1AN 55,55 | C | * SEE BELOW
----------------------------------------------------------------------
BND/CASH-3 DATE | 6N 56,61 | C | MMDDYY
----------------------------------------------------------------------
BND/CASH IND-4 | 1AN 62,62 | C | * SEE BELOW
----------------------------------------------------------------------
BND/CASH-4 DATE | 6N 63,68 | C | MMDDYY
----------------------------------------------------------------------
BND/CASH IND-5 | 1AN 69,69 | C | * SEE BELOW
----------------------------------------------------------------------
BND/CASH-5 DATE | 6N 70,75 | C | MMDDYY
----------------------------------------------------------------------
FILLER | 5AN 76,80 | | SPACE FILL
----------------------------------------------------------------------

* DEPOSIT RATES ARE EXPRESSED AS 1 WHOLE NUMBER WITH 4 DECIMALS
- EG - 25% EXPRESSED AS 0.2500

IF RATE INDICATOR = 0, NO RATES YET EXIST FOR CASE. DEPOSIT RATE
FIELDS WILL BE RETURNED AS SPACES. LIKEWISE, IF ONLY ONE RATE EXISTS,
DEPOSIT RATES-2 AND -3 WOULD BE RETURNED AS SPACES.

ONLY APPLICABLE DATE(S) WILL BE RETURNED. IF NO DATE, WILL RETURN
SPACES IN THAT DATE FIELD.

NOTE: CUSTOMS WILL PROVIDE ALL DEPOSIT RATE INFORMATION BASED ON
THE EFF ENTRY DATE (OR EFF EXPORT DATE IF NO EFF ENTRY
DATES APPLY) FOR UP TO THE LATEST 10 RATE OCCURRENCES.
ACCORDINGLY, MULTIPLE 'C5' RECORDS MAY BE RETURNED AS NEEDED.

UP TO 5 OCCURRENCES (THE LATEST 5 OCCURRENCES BY DATE) WILL BE PROVIDED
FOR BOND/CASH INDICATOR AND EFFECTIVE DATE INFORMATION ON THE INITIAL
'C5' RECORD RETURNED. IF LESS THAN 5 OCCURRENCES ARE ON FILE, THE RE-
MAINING FIELDS WILL BE SPACE FILLED. LIKEWISE, IF ADDITIONAL 'C5'
RECORDS ARE RETURNED BECAUSE OF MULTIPLE DEPOSIT RATE/DATES, ALL BOND/
CASH FIELDS OF THESE ADDITIONAL 'C5' RECORDS WILL BE SPACE FILLED.
DATA WILL BE RETURNED EARLIEST DATE FIRST.

THE FIRST BND/CASH INDICATOR AND DATE ARE MANDATORY ON THE FIRST 'C5'
RECORD RETURNED. THESE WILL BE SPACE FILLED ON SUBSEQUENT 'C5' RECORDS.
THERE WILL ALWAYS BE AT LEAST ONE INDICATOR ON 'ADG' WITH AN
ASSOCIATED DATE. AT LEAST ONE OF THE INDICATORS GIVEN WILL = THE INDI-
CATOR RETURNED ON THE 'C3' RECORD.

NOTE: THE BOND/CASH INDICATOR GIVEN ON THE 'C3' OUTPUT RECORD WILL BE
THE LATEST INDICATOR, BY LATEST EFFECTIVE DATE, RETURNED ON THE
FIRST 'C5' RECORD.

* BND/CASH INDICATOR - 0 = N/A
B = BONDED
C = CASH REQ'D

======================================================================

APPLICATION NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY CASE QUERY
----------------------------------------------------
RECORD NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY QUERY - OUTPUT
----------------------------------------------------
OPTIONAL
MANDATORY
X CONDITIONAL

RECORD REFERENCE NUMBER C6
---------------------------

----------------------------------------------------------------------
DATA ELEMENT NAME | LENGTH/CLASS POSITION | STATUS | REMARKS
----------------------------------------------------------------------
CONTROL IDENTIFIER | 1A 1,1 | M | MUST BE 'C'
----------------------------------------------------------------------
RECORD TYPE | 1N 2,2 | M | MUST BE '6'
----------------------------------------------------------------------
TARIFF NUMBER | 10X 3,12 | M | * SEE BELOW
----------------------------------------------------------------------
TARIFF NUMBER | 10X 13,22 | C |
----------------------------------------------------------------------
TARIFF NUMBER | 10X 23,32 | C |
----------------------------------------------------------------------
TARIFF NUMBER | 10X 33,42 | C |
----------------------------------------------------------------------
TARIFF NUMBER | 10X 43,52 | C |
----------------------------------------------------------------------
TARIFF NUMBER | 10X 53,62 | C |
----------------------------------------------------------------------
TARIFF NUMBER | 10X 63,72 | C |
----------------------------------------------------------------------
FILLER | 8AN 73,80 | | SPACE FILL
----------------------------------------------------------------------

MULTIPLE 'C6' RECORDS WILL BE RETURNED AS NECESSARY TO ACCOMMODATE
UP TO A MAXIMUM OF 1000 TARIFF NUMBERS.

* TARIFF NUMBERS MAY BE RETURNED AT ONLY THE 5-DIGIT LEVEL FOR TSUSA
NUMBERS AND 8-DIGIT LEVEL FOR HARMONIZED. THIS INDICATES THAT THE CASE
APPLIES FOR ALL STATISTICAL SUFFIXES FOR THOSE NUMBERS.
======================================================================

APPLICATION NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY CASE QUERY
----------------------------------------------------
RECORD NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY QUERY - OUTPUT
----------------------------------------------------
OPTIONAL
MANDATORY
X CONDITIONAL

RECORD REFERENCE NUMBER C7
---------------------------

----------------------------------------------------------------------
DATA ELEMENT NAME | LENGTH/CLASS POSITION | STATUS | REMARKS
----------------------------------------------------------------------
CONTROL IDENTIFIER | 1A 1,1 | M | MUST BE 'C'
----------------------------------------------------------------------
RECORD TYPE | 1N 2,2 | M | MUST BE '7'
----------------------------------------------------------------------
CASE NUMBER | 10AN 3,12 | M |
----------------------------------------------------------------------
MANUFACTURER NAME | 50X 13,62 | M |
----------------------------------------------------------------------
FILLER | 18AN 63,80 | | SPACE FILL
----------------------------------------------------------------------

A 'C7' RECORD WILL BE RETURNED WHERE THE LAST THREE DIGITS (SUFFIX)
OF THE AD/CVD CASE NUMBER ARE > '000' AND A MANUFACTURER NAME IS ON
FILE.

IF BOTH A MANUFACTURER AND SHIPPER NAME ARE ON FILE, A 'C7' AND 'C8'
RECORD WILL BE RETURNED.

======================================================================

APPLICATION NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY CASE QUERY
----------------------------------------------------
RECORD NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY QUERY - OUTPUT
----------------------------------------------------
OPTIONAL
MANDATORY
X CONDITIONAL

RECORD REFERENCE NUMBER C8
---------------------------

----------------------------------------------------------------------
DATA ELEMENT NAME | LENGTH/CLASS POSITION | STATUS | REMARKS
----------------------------------------------------------------------
CONTROL IDENTIFIER | 1A 1,1 | M | MUST BE 'C'
----------------------------------------------------------------------
RECORD TYPE | 1N 2,2 | M | MUST BE '8'
----------------------------------------------------------------------
CASE NUMBER | 10AN 3,12 | M |
----------------------------------------------------------------------
SHIPPER NAME | 50X 13,62 | M |
----------------------------------------------------------------------
FILLER | 18AN 63,80 | | SPACE FILL
----------------------------------------------------------------------

A 'C8' RECORD WILL BE RETURNED WHERE THE LAST THREE DIGITS (SUFFIX)
OF THE AD/CVD CASE NUMBER ARE > '000' AND A SHIPPER NAME IS ON FILE.

IF BOTH A MANUFACTURER AND SHIPPER NAME ARE ON FILE, A 'C7' AND 'C8'
RECORD WILL BE RETURNED.
======================================================================

APPLICATION NAME: ABI ANTIDUMPING/COUNTERVAILING DUTY QUERY - OUTPUT
----------------------------------------------------
RECORD NAME: ERROR RECORD
----------------------------------------------------
OPTIONAL
MANDATORY
X CONDITIONAL

RECORD REFERENCE NUMBER C9
---------------------------

----------------------------------------------------------------------
DATA ELEMENT NAME | LENGTH/CLASS POSITION | STATUS | REMARKS
----------------------------------------------------------------------
CONTROL IDENTIFIER | 1A 1,1 | M | MUST BE 'C'
----------------------------------------------------------------------
RECORD TYPE | 1N 2,2 | M | MUST BE '9'
----------------------------------------------------------------------
NARRATIVE MESSAGE | 30X 3,32 | C |
----------------------------------------------------------------------
MESSAGE ID CODE | 3AN 33,35 | M |
----------------------------------------------------------------------
FILLER | 45AN 36,80 | | SPACE FILL
----------------------------------------------------------------------

MULTIPLE 'C9' RECORDS WILL BE RETURNED AS NECESSARY.

=======================================================================

ERRORS - RETURNED IN 'C9' OUTPUT RECORD. CHANGE IS BEING MADE TO
EXISTING 'C9' RECORD. SINCE THE 'C2' RECORD IS BEING RE-
TURNED, THE 'C9' WILL FOLLOW THE APPROPRIATE 'C2' RECORD.
INPUT DATA WILL NOT BE RETURNED ON 'C9' RECORD FOR EXTRACT
QUERY. IN ADDITION TO EXISTING 'C9' ERRORS AND MESSAGES RE-
TURNED, THE FOLLOWING ARE ERRORS SPECIFICALLY RELATED TO THE
EXTRACT INPUT TRANSACTION.

1. POSITIONS 3, 4 & 5 CANNOT ALL BE > SPACES ON INPUT, ELSE WILL
RECEIVE "DUPLICATE C/O REQUEST" OR SIMILAR WORDING. CONVERSELY,
POSITIONS 3, 4 & 5 CANNOT ALL = SPACES, ELSE WILL RECEIVE "NO C/O
REQUEST" OR SIMILAR WORDING.

2. POSITIONS 6 & 7 CANNOT BOTH BE > SPACE, ELSE WILL RECEIVE "DUPLICATE
ACTIVITY REQUEST" OR SIMILAR WORDING. CONVERSELY, BOTH 6 & 7 CANNOT
= SPACES, ELSE WILL RECEIVE "NO ACTIVITY REQUEST" OR SIMILAR
WORDING.

3. IF POSITION 8 IS > SPACE AND ANY POSITION 9-12 IS > SPACE, WILL GET
"DUPLICATE OUTPUT REQUEST" OR SIMILAR WORDING. CONVERSELY, 8 AND 9-
12 CANNOT ALL = SPACES, WILL RECEIVE "NO OUTPUT REQUEST" OR SIMILAR
WORDING. IF POSITION 8 IS = SPACE AND POSITIONS 9-12 ARE ALL >
SPACE, WILL RECEIVE "MULTIPLE OUTPUT REQUEST" OR SIMILAR WORDING.

4. IF NO RECORDS ARE FOUND THAT MEET ANY OF THE INPUT CRITERIA WHEN A
SPECIFIC COUNTRY IS REQUESTED, WILL GET "NO RECORDS FOR COUNTRY/OR-
IGIN" OR SIMILAR WORDING.

QUESTIONS ON THE NEW AD/CVD EXTRACT MAY BE DIRECTED TO YOUR CLIENT
REPRESENTATIVE.

JIM HALPIN
CHIEF, OTHER AGENCY SYSTEMS BRANCH
COMMERCIAL SYSTEMS DEVELOPMENT DIV, ACS