Files content
Header
Data structure
| Field | Column | Data type | Required | Business rules |
|---|---|---|---|---|
Company code |
companyCode |
String |
X |
2 characters max |
Establishment code |
establishmentCode |
String |
X |
2 characters max |
Batch number |
batch |
String |
X |
20 characters max |
Item code |
itemCode |
String |
X |
20 characters max |
Record type |
recordType |
String |
X |
Within (CRITERION, STATUS) |
Generation date |
generationDate |
String (ISO 8601) |
X |
YYYY-MM-DDTHH:MM:SSZ |
Effective date |
effectiveDate |
String (ISO 8601) |
YYYY-MM-DDTHH:MM:SSZ |
|
Status code |
statusCode |
String |
5 characters max |
|
Criteria code |
criterionCode |
String |
10 characters max |
|
Measure date |
measureDate |
String (8601) |
YYYY-MM-DDTHH:MM:SSZ |
|
Criterion value |
criterionValue |
String |
50 characters max |
Examples
companyCode;establishmentCode;batch;itemCode;generationDate;recordType;criterionCode;measureDate;criterionValue 01;01;11;01;2012-10-09T00:00:00Z;CRITERION;C1;2012-10-09T00:00:00Z;V1 01;01;11;01;2012-10-09T00:00:00Z;CRITERION;$DATEFAB;2012-10-09T00:00:00Z;2012-10-09
companyCode;establishmentCode;batch;itemCode;generationDate;recordType;effectiveDate;statusCode 01;01;11;01;2012-10-09T00:00:00Z;STATUS;2012-10-09T00:00:00Z;S1 01;01;11;01;2012-10-09T00:00:00Z;STATUS;2012-12-01T00:00:00Z;S2
companyCode;establishmentCode;batch;itemCode;generationDate;recordType;effectiveDate;statusCode;criterionCode;measureDate;criterionValue 01;01;11;01;2012-10-09T00:00:00Z;CRITERION;;;C1;2012-10-09T00:00:00Z;V1 01;01;11;01;2012-10-09T00:00:00Z;CRITERION;;;$DATEFAB;2012-10-09T00:00:00Z;2012-10-09 01;01;11;01;2012-10-09T00:00:00Z;STATUS;2012-10-09T00:00:00Z;S1;;; 01;01;11;01;2012-10-09T00:00:00Z;STATUS;2012-12-01T00:00:00Z;S2;;;