Factura Electronica | Introducción al conector de texto (txt 5.1)

Inicio | Emisión | Connector | Types of connectors | Connector-TXT 5.1 for purchase order

La LCO fue actualizada por última vez el 10/feb./2026

Chapters content

Connector-TXT 5.1 for purchase order

Connector-TXT 5.1 for purchase order

File

The end of line (EOL), new line or linebreak can be any one used in common operative systems: CR, LF or CR+LF.

Field separation

The default character used to separate each field is "pipe" (|, ASCII 124), if you need another character, it needs to be specified in your implementation´s configuration. However we suggest not to choose simple characters like comma "," or semicolon ";" because this may interfere with the field's data extraction if the data contains such characters.

File structure

The first line of the file does not contain the definition of the columns. The file can have as many lines as necessary and can include as many purchase orders as required.

It is necessary to respect the order indicated in the data directory, so it will be necessary to attend to the requirements to avoid errors in the process.

Txt 5.1 chain structure for purchase order

Example

|9001|OCN|ABIERTA|FALSE|32321321|Proveedor|ABASTECEDORA S.A. DE C.V.|AMA0101019N0|Juarez|122|B|Centro|Guadalajara|Guadalajara|Jalisco|MEX|45400||||||||||10012023|11022023|proyecto|prueba|Notas de orden|30 dias|MXN|1|||100||16|16|||116|TRUE01010101|produto|PZA|1|100|116|||||||||||||||||

Data dictionary

Name	Description	Options
NUMERO_COMPRA	Purchase Order Number	String
NOMBRE_SERIE	Purchase order series	String
STATUS	The status of the Purchase Order is indicated	0(Open), 1(Partially stocked), 2(Closed).
IS_CLOSED	It indicates whether the purchase order is open or closed.	TRUE, FALSE
NUM_PROVEEDOR	Number assigned to the proveedor (supplier)	Numeric
TIPO_PROVEEDOR	Supplier type	Supplier, Contact, Customer
PROVEEDOR	Supplier name	Alphanumeric
RFC_PROVEEDOR	Supplier RFC	13 character Física person, 12 character Moral person. "[A-Z,Ñ,&]{3,4}[0-9]{2}[0-1][0- 9][0-3][0-9][A-Z,0-9]?[A-Z,0- 9]?[0-9,A-Z]?"
CALLE_FISCAL	Attribute to specify the avenue, street, road or highway where the location is given	String
NUMERO_EXT_FISCAL	Attribute is used to express the particular number where the location on a given street is given.	String
NUMERO_INT_FISCAL	Attribute is used to express additional information to specify the location when street and exterior number (noExterior) are not sufficient to determine the location accurately.	String
COLONIA_FISCAL	Attribute is used to specify the colony where the location is given when you want to be more specific in cases of urban locations.	String
CIUDAD_FISCAL	Attribute used to specify the city or town where the location is given.	String
MUNICIPIO_FISCAL	Attribute used to specify the municipality or delegation where the location is given.	String
ESTADO_FISCAL	Attribute used to specify the state or federal entity where the location occurs.	String
PAIS_FISCAL	Atributo requerido que sirve para precisar el país donde se da la ubicación.	String
CP_FISCAL	Attribute used to establish the postal code where the location is given.	String
CALLE_EMBARQUE	Required attribute is used to specify the avenue, street, road or highway where the location occurs.	String
NUMERO_EXT_EMBARQUE	Attribute is used to express the particular number where the location on a given street is given.	String
NUMERO_INT_EMBARQUE	Attribute is used to express additional information to specify the location when street and exterior number (noExterior) are not sufficient to determine the location accurately.	String
COLONIA_EMBARQUE	Attribute is used to specify the colony where the location is given when you want to be more specific in cases of urban locations.	String
CIUDAD_EMBARQUE	Attribute used to specify the city or town where the location is given.	String
MUNICIPIO_EMBARQUE	Required attribute used to specify the municipality or delegation where the location is given.	String
ESTADO_EMBARQUE	Required attribute used to specify the state or federal entity where the location occurs.	String
PAIS_EMBARQUE	Required attribute used to specify the country where the location is given.	String
CP_EMBARQUE	Required attribute used to establish the postal code where the location is given.	String
FECHA_ORDEN	Purchase Order Creation Date	yyyymmdd
FECHA_EMBARQUE	Boarding date	yyyymmdd
OBJETO_RELACION	The relationship is indicated whether it is a project or an opportunity.	13(Project), 2(Opportunity).
NAME_OBJETO_RELACION	Project Name or Opportunity	String
NOTAS	Purchase Order Notes	String
TERMINOS	The terms of the purchase are indicated	30 days, 15 days, etc.
MONEDA	Attribute to express the currency used to express the amounts	MXN, USD
TIPO_CAMBIO	Attribute to represent the exchange rate according to the currency used	Decimal ”[09]{1,18}(.[0-9]{1,6})?”
TIPO_DESCUENTO	Discount type
DESCUENTO	Attribute to represent the total amount of applicable discounts before taxes.	Decimal ”[0-9]{1,18}(.[0- 9]{1,6})?”
SUBTOTAL_ORDEN	Required attribute to represent the sum of amounts before discounts and taxes.	Decimal ”[0-9]{1,18}(.[0- 9]{1,6})?”
TOTAL_DESCUENTOS	Attribute to represent the total amount of applicable discounts before taxes.	Decimal ”[0-9]{1,18}(.[0- 9]{1,6})?”
TOTAL_TRASLADOS	Attribute to express the total of the transferred taxes that arise from the concepts expressed in the Purchase Order.	Decimal ”[0-9]{1,18}(.[0- 9]{1,6})?”
TOTAL_IVA	Required attribute to indicate the amount of IVA transferred.	Decimal ”[0-9]{1,18}(.[0- 9]{1,6})?”
TOTAL_IEPS	Required attribute to indicate the amount of IEPS tax transferred.	Decimal ”[0-9]{1,18}(.[0- 9]{1,6})?”
TOTAL_RETENCIONES	Attribute to express the total of the withheld taxes that arise from the concepts expressed in the Purchase Order.	Decimal ”[0-9]{1,18}(.[0- 9]{1,6})?”
TOTAL_ORDEN	Required attribute to represent the sum of the subtotal, less applicable discounts, plus taxes carried forward, less taxes withheld.	Decimal ”[0-9]{1,18}(.[0- 9]{1,6})?”
LINEA_AISLADO	Manual capture of concepts is indicated.	(true)
LINEA_CODIGO	Attribute to express the code of the good or identifier of the service covered by this concept.	String
LINEA_NAME	Node to enter detailed information about a good or service.	String
LINEA_UNIDAD	Attribute required to specify the applicable unit of measurement for the quantity expressed in the concept.	String PZA, CJA, TON
LINEA_PRECIO	Attribute required to specify the value or unit price of the good or service covered by this concept.	Decimal ”[0-9]{1,18}(.[0- 9]{1,6})?”
LINEA_IMPORTE	Required attribute to specify the total amount of the goods or services in this concept. It must be equivalent to the result of multiplying the quantity by the unit value expressed in the concept.	Decimal ”[0-9]{1,18}(.[0- 9]{1,6})?”
LINEA_TASA_DESCUENTO	Required attribute to indicate the discount rate that is added for each concept.	Decimal
LINEA_MONTO_UNIT_DESCUENTO	Product discount unit amount per line.	Decimal ”[0-9]{1,18}(.[0- 9]{1,6})?”
LINEA_TASA_IEPS	Required attribute to indicate the IEPS tax rate that is transferred for each concept.	Decimal
LINEA_MONTO_UNIT_IEPS	Required attribute to indicate the amount of IEPS tax transferred.	Decimal ”[0-9]{1,18}(.[0- 9]{1,6})?”
LINEA_TASA_IVA	Required attribute to indicate the IVA tax rate that is transferred for each concept.	Decimal
LINEA_TASA_RET_IVA	Required attribute to indicate the IVA tax rate that is withheld for each concept.	Decimal
LINEA_TASA_RET_ISR	Required attribute to indicate the ISR tax rate that is withheld for each concept.	Decimal
LINEA_FECHA_EMBARQUE	Shipping Date	yyyymmdd
LINEA_OBJETO_RELACION
LINEA_NAME_OBJETO_RELACION
LINEA_ALMACEN	Product warehouse name by line	String
LINEA_COMENTARIO	Product review by line	String
LINEA_OVERRIDE
LINEA_FRACCIONABLE
LINEA_CODIGO_DE_COMPRADOR	Product Buyer Product Code by Line	String
LINEA_CANTIDAD_POR_EMPAQUE	Quantity per product package per line	Decimal

Solución Factible®:Integration Center [SF:IC]