Data Structure of Part II
Data Structure of Part II
Definition
The table below shows the data structure of the file that the system creates when you download the data from Part II.
In case of Part II entries for debit and credit (except for capital goods), if the excise invoice contains multiple chapter IDs, then the excise value per chapter ID is shown in the lines immediately following the Part II entry. These entries have the same Part II serial number. Only the fields REGTYP, TRNTYP, EXGRP, SNO, SYEAR, EXNUM, EXDAT, BED, SED, AED, CESS, CURR, and CHAPID will have valid values.
In case of the Part II credit entries for capital goods, after the Part II entry, the excise amount is shown per excise invoice. These entries have the same Part II serial number. Only the fields REGTYP, TRNTYP, EXGRP, SNO, SYEAR, EXNUM, NAME1, ORT01, PSTLZ, BED, SED, AED, CESS, CURR will have valid values.
Structure
Field |
Length |
Use | |
REGTYP |
1 |
Register type | |
A |
RG23A | ||
C |
RG23C | ||
P |
PLA | ||
TRNTYP |
4 |
Transaction type | |
57CM |
57F4 completion | ||
57FC |
57F4 subcontractor goods issue | ||
57NR |
Non receipt of 57F4 | ||
CAPE |
Capital goods | ||
CEIV |
Canceling the generated excise invoice | ||
DIEX |
Differential excise posting | ||
DLFC |
Factory sale and stock transfer | ||
GRPO |
Goods receipt (raw material) | ||
MRDY |
Reversal without reference | ||
MRRD |
Reversal in case of consumption other than production | ||
MRWO |
CENVAT reversal for write of cases | ||
TR6C |
PLA account adjustment through TR6 challan | ||
OTHR |
Excise paid on other movements | ||
EWPO |
Excise invoice without PO | ||
EXGRP |
2 |
Excise group | |
SNO |
10 |
Part II serial number | |
SYEAR |
4 |
Year of the serial number | |
PDATE |
8 |
Posting date | |
EXNUM |
10 |
Excise invoice number | |
EXDAT |
8 |
Excise invoice date | |
NAME1 |
35 |
Vendor/customer/subcontractor name | |
ORT01 |
35 |
City | |
PSTLZ |
10 |
Pin code | |
EXCCD |
20 |
Excise code number of vendor/customer/subcontractor | |
EXCRN |
20 |
Excise registration number of vendor/customer/subcontractor | |
EXCRG |
40 |
Excise range number (in case of credit entries) | |
EXCDI |
20 |
Division number (in case of credit entries) | |
EXCCO |
20 |
Excise collectorate of vendor/customer/subcontractor | |
BED |
19 |
BED | |
SED |
19 |
SED | |
AED |
19 |
AED | |
CESS |
19 |
CESS | |
CURR |
3 |
Currency | |
CHAPID |
12 |
Chapter id | |
P1NO |
10 |
Corresponding part I entry number (in case of credit entries) | |
PREPRN |
10 |
Preprinted excise invoice number | |
CVDIND |
1 |
CVD indicator (X = CVD) | |
EXPIND |
1 |
Export indicator in sales | |
Blank |
Local sale | ||
B |
Export under bond | ||
D |
Deemed export | ||
N |
Export without bond | ||
CAPIND |
1 |
Capital goods indicator | |
A |
Assets | ||
T |
Tools | ||
C |
Consumable | ||
CERTNO |
20 |
(Capital goods only) Field use depends on material type: | |
Assets |
Installation certificate number | ||
Consumable |
Intimation document number | ||
Tools |
Intimation document number | ||
CERTDT |
8 |
Intimation/certificate date (capital goods only) | |
ANLN1 |
12 |
Asset number (for capital goods: assets only) | |
REMARKS |
50 |
Remarks | |
PROCES |
50 |
Process for subcontracting challan | |
STATUS |
1 |
Status | |
Space |
Normal | ||
R |
Reversed | ||
RDOC1 |
10 |
Reference document number | |
RYEAR1 |
4 |
Reference document year | |
LIFNR |
10 |
Vendor number | |
MBLNR |
10 |
Material document number | |
MJAHR |
4 |
Material document year | |