This function is used to define the loading rules of the various segments.

The checks carried out on the 1099 file by the French Administration are extensive. Compliance with the standard is strict, and Sage X3 does not carry out all the checks. There are web sites that can be used to download checking tools that should be implemented before sending the file to the administration.

Here are a few useful Internet sites:

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

The header used to identify the parameterization group:

The table specifies the loading rules of the segments to be managed:

  • Meaning (Description),
  • Use (Mandatory/Optional),
  • Nature (Alphanumerical, numerical, date),
  • Length,
  • Loading condition (Formula),
  • Options (Zero accepted, length control).

The classes that can be used in the formulas are the following:

Abbreviation

°Type

Object 

Contents

[M:DIA]

Screen

FTD1

Launching parameters of the generation of the 1099 file

[F:CPY]

Table

COMPANY

Current company (Company table as a parameter of the generation)

[F:FCY]

Table

FACILITY

Issuing site as a parameter of the generation

[F:PRV]

Table

 HONPRV

Service provider against fees

[F:HLN]

Table

 HONLIN

Fees lines coming from the fees extraction

[F:PRM]

Table

PRMDADSU

Extraction parameters of the 1099 file

[F:FTD]

Table

FILTDS

Structure of the 1099 file

[F:FIY]

Table

FISCALYEAR

Financial year

[F:TCY]

Table

TABCOUNTRY

Country

[F:FCD]

Table

FACILITY

Site to which the CRE report is sent

[F:BPD]

Table

BPADDRESS

Address of the site to which the CRE report is sent

[F:AID]

Table

CONTACTCRM

Contact at the site to which the CRE report is sent

[F:FCX]

Table

FACILITY

Reporting site

[F:BPX]

Table

BPADDRESS

Address of the reporting site

[F:AIX]

Table

CONTACTCRM

Contact at the reporting site

[F:FCS]

Table

FACILITY

Headquarters site

[F:BPS]

Table

BPADDRESS

Address of the headquarters site

[F:AIS]

Table

CONTACTCRM

Contact at the headquarters site


The following specific functions can be used:

  • TABLE(NUMERO, VALEUR) : Returns the content of the alphanumerical field 1 (A1) of the NUMERO miscellaneous table for the value of the VALEUR code
  • MENU(NOMZONE): Returns values calculated on the basis of the NOMZONE processed field and its value:

NOMZONE

Result

[F:DFC]TAXWAG

"02" if NOMZONE=1, "01" otherwise

[M:DIA]TEST

"02" if NOMZONE=1, "01" if NOMZONE=2, "01" otherwise

[F:PRM]DENCODCOM

"03" if NOMZONE=1, "05" if NOMZONE=2, "" otherwise

[M:DIA]CNTCODCOM

"0"+NOMZONE if NOMZONE ranging from 1 and 5, "" otherwise






Header

Group (field GRP)

Code identifying the parameterization.

Description (field DES)

Enter the description of the relevant record.

This long description is used as a title in screens and reports.
File prefix (field FILREF)

Used to define the file name extension. The file is generated on the server, in the BQE directory. It is called "1099_+date_hour.extension.
Legislation (field LEG)

Grid Structure

Record no. (field NUMREC)

Code of the segment that corresponds to the processed information.
Heading name (field DESREC)

Clear meaning of the processed segment.

Transmission (field FLGREC)

Data presence check:

  • Mandatory: The data is necessarily present and entered if the structure that contains it is present.
  • Conditional: The data is present in case of a particular conditon.
  • Optional: The data is requested by the recipient.
Type (field TYPREC)

Data format:

  • Alphanumerical: All characters are authorized depending on the set of characters being used (ISO/IEC 8859-1).
  • Numerical: Without decimal, rounded to the unit. The value 0 is considered to be blank, unless otherwise specified ("Zero accepted" parameter).
  • Date: DDMMYYYY format
Length (field LNGREC)

Data length. The "Length control" parameter stipulates whether this length is fixed or variable.

Formula (field XPSRES)
Zero accepted (field VALNUL)

Stipulates if the 0 value is significant and must therefore be used or not in the file.

Length control (field CTLLNG)

Stipulates if the data must have a strict length (then, it is equal to the value of the "Length" parameter) or a variable length (in that case, it is less than or equal to the value of the "Length" parameter).

Specific Buttons

Copy

This button makes it possible to recopy the current record to another folder.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation