Appendices

Archiving - Export models

The fields used as export criteria are presented in bold.

  • DGIAES - DGI Export - Spy file

    Flag

    Table

    Field code

    Field description

    Data type

    Length

     

    AESPION

    ESPDAT

    Date

    Date

     

     

    AESPION

    ESPTIM

    Hour

    Alphanumeric

     

     

    AESPION

    ESP1

    Parameter

    Alphanumeric

    50

     

    AESPION

    ESP2

    Parameter

    Alphanumeric

    50

     

    AESPION

    ESPFNC

    Role

    Alphanumeric

    10

     

    AESPION

    ESPMOT

    Reason

    Miscellaneous table 81

    20

     

    AESPION

    ESPNAT

    Nature of operation

    Local menu 83

    15

     

    AESPION

    ESPTAB

    Table

    Alphanumeric

    12

     

    AESPION

    ESPUSR

    User record

    Alphanumeric

    5

  • DGIAUD - DGI Export - Audit

    Flag

    Table

    Field code

    Field description

    Data type

    Length

    H

    AUDITH

    /

     

     

     

    H

    AUDITH

    SEQ

    Sequence number

    Long integer

    *8

    H

    AUDITH

    TBL

    Table

    Alphanumeric

    12

    H

    AUDITH

    DAT

    Date

    Date

     

    H

    AUDITH

    HOU

    Hour

    Alphanumeric

    *8

    H

    AUDITH

    EVT

    Events

    Alphanumeric

    10

    H

    AUDITH

    ID1

    Key

    Alphanumeric

    80

    H

    AUDITH

    ID2

    Secondary key

    Alphanumeric

    80

    H

    AUDITH

    ADOUSR

    User record

    Alphanumeric

    5

    H

    AUDITH

    SYSUSR

    System user

    Alphanumeric

    20

    H

    AUDITH

    ADRCLI

    Customer address

    Alphanumeric

    30

    H

    AUDITH

    STA

    Workflow status

    Local menu 947

    10

    H

    AUDITH

    STABI

    BI status

    Local menu 947

    10

    H

    AUDITH

    NUM1

    Numeric key

    Decimal

    9.2

    H

    AUDITH

    NUM2

    Numeric key

    Decimal

    9.2

    H

    AUDITH

    NUM3

    Numeric key

    Decimal

    9.2

    H

    AUDITH

    NUM4

    Numeric key

    Decimal

    9.2

    H

    AUDITH

    NUM5

    Numeric key

    Decimal

    9.2

    H

    AUDITH

    NUM6

    Numeric key

    Decimal

    9.2

    H

    AUDITH

    NUM7

    Numeric key

    Decimal

    9.2

    H

    AUDITH

    NUM8

    Numeric key

    Decimal

    9.2

    H

    AUDITH

    NUM9

    Numeric key

    Decimal

    9.2

    H

    AUDITH

    CHAR1

    Alphanumeric key

    Alphanumeric

    80

    H

    AUDITH

    CHAR2

    Alphanumeric key

    Alphanumeric

    80

    H

    AUDITH

    CHAR3

    Alphanumeric key

    Alphanumeric

    80

    H

    AUDITH

    CHAR4

    Alphanumeric key

    Alphanumeric

    80

    H

    AUDITH

    CHAR5

    Alphanumeric key

    Alphanumeric

    80

    H

    AUDITH

    CHAR6

    Alphanumeric key

    Alphanumeric

    80

    H

    AUDITH

    CHAR7

    Alphanumeric key

    Alphanumeric

    80

    H

    AUDITH

    CHAR8

    Alphanumeric key

    Alphanumeric

    80

    H

    AUDITH

    CHAR9

    Alphanumeric key

    Alphanumeric

    80

    D

    AUDITL

    /

     

     

     

    D

    AUDITL

    SEQ

    Sequence number

    Long integer

    *8

    D

    AUDITL

    COL

    Column

    Alphanumeric

    20

    D

    AUDITL

    OVAL

    Previous value

    Alphanumeric

    250

    D

    AUDITL

    NVAL

    New value

    Alphanumeric

    250

  • DGIBIC - DGI Export - Customer BP invoice

    Flag

    Table

    Field code

    Field description

    Data type

    Length

    H

    SINVOICE

    /

     

     

     

    H

    SINVOICE

    SIVTYP

    Invoice type

    Alphanumeric

    5

    H

    SINVOICE

    INVTYP

    Invoice category

    Local menu 645

     

    H

    SINVOICE

    NUM

    Journal number

    Alphanumeric

    20

    H

    SINVOICE

    ORIMOD 1

    Source module

    Local menu 14

     

    H

    SINVOICE

    BPR

    BP

    Alphanumeric

    15

    H

    SINVOICE

    BPRSAC

    Collective

    Alphanumeric

    4

    H

    SINVOICE

    CPY

    Company

    Alphanumeric

    5

    H

    SINVOICE

    FCY

    Site

    Alphanumeric

    5

    H

    SINVOICE

    GTE

    Entry type

    Alphanumeric

    5

    H

    SINVOICE

    JOU

    Journal

    Alphanumeric

    5

    H

    SINVOICE

    ACCDAT

    Accounting date

    Date

     

    H

    SINVOICE

    ACCNUM

    Internal number

    Long integer

    *8

    H

    SINVOICE

    BPRDAT

    Original date

    Date

     

    H

    SINVOICE

    BPRVCR

    Source document

    Alphanumeric

    20

    H

    SINVOICE

    CUR

    Currency

    Alphanumeric

    3

    H

    SINVOICE

    CURTYP

    Exchange rate type

    Local menu 202

     

    H

    SINVOICE

    LED

    Ledger

    Alphanumeric

    3

    H

    SINVOICE

    CURLED

    Ledger currency

    Alphanumeric

    3

    H

    SINVOICE

    RATMLT

    Multiplying rate

    Decimal

    11

    H

    SINVOICE

    RATDIV

    Dividing rate

    Decimal

    11

    H

    SINVOICE

    LED(1)

    Ledger

    Alphanumeric

    3

    H

    SINVOICE

    CURLED(1)

    Ledger currency

    Alphanumeric

    3

    H

    SINVOICE

    RATMLT(1)

    Multiplying rate

    Decimal

    11

    H

    SINVOICE

    RATDIV(1)

    Dividing rate

    Decimal

    11

    H

    SINVOICE

    LED(2)

    Ledger

    Alphanumeric

    3

    H

    SINVOICE

    CURLED(2)

    Ledger currency

    Alphanumeric

    3

    H

    SINVOICE

    RATMLT(2)

    Multiplying rate

    Decimal

    11

    H

    SINVOICE

    WEB(2)

    Dividing rate

    Decimal

    11

    H

    SINVOICE

    LED(3)

    Ledger

    Alphanumeric

    3

    H

    SINVOICE

    CURLED(3)

    Ledger currency

    Alphanumeric

    3

    H

    SINVOICE

    RATMLT(3)

    Multiplying rate

    Decimal

    11

    H

    SINVOICE

    RATDIV(3)

    Dividing rate

    Decimal

    11

    H

    SINVOICE

    LED(4)

    Ledger

    Alphanumeric

    3

    H

    SINVOICE

    CURLED(4)

    Ledger currency

    Alphanumeric

    3

    H

    SINVOICE

    RATMLT(4)

    Multiplying rate

    Decimal

    11

    H

    SINVOICE

    RATDIV(4)

    Dividing rate

    Decimal

    11

    H

    SINVOICE

    LED(5)

    Ledger

    Alphanumeric

    3

    H

    SINVOICE

    CURLED(5)

    Ledger currency

    Alphanumeric

    3

    H

    SINVOICE

    RATMLT(5)

    Multiplying rate

    Decimal

    11

    H

    SINVOICE

    RATDIV(5)

    Dividing rate

    Decimal

    11

    H

    SINVOICE

    LED(6)

    Ledger

    Alphanumeric

    3

    H

    SINVOICE

    CURLED(6)

    Ledger currency

    Alphanumeric

    3

    H

    SINVOICE

    RATMLT(6)

    Multiplying rate

    Decimal

    11

    H

    SINVOICE

    RATDIV(6)

    Dividing rate

    Decimal

    11

    H

    SINVOICE

    LED(7)

    Ledger

    Alphanumeric

    3

    H

    SINVOICE

    CURLED(7)

    Ledger currency

    Alphanumeric

    3

    H

    SINVOICE

    RATMLT(7)

    Multiplying rate

    Decimal

    11

    H

    SINVOICE

    RATDIV(7)

    Dividing rate

    Decimal

    11

    H

    SINVOICE

    LED(8)

    Ledger

    Alphanumeric

    3

    H

    SINVOICE

    CURLED(8)

    Ledger currency

    Alphanumeric

    3

    H

    SINVOICE

    RATMLT(8)

    Multiplying rate

    Decimal

    11

    H

    SINVOICE

    RATDIV(8)

    Dividing rate

    Decimal

    11

    H

    SINVOICE

    LED(9)

    Ledger

    Alphanumeric

    3

    H

    SINVOICE

    CURLED(9)

    Ledger currency

    Alphanumeric

    3

    H

    SINVOICE

    RATMLT(9)

    Multiplying rate

    Decimal

    11

    H

    SINVOICE

    RATDIV(9)

    Dividing rate

    Decimal

    11

    H

    SINVOICE

    RATDAT

    Rate date

    Date

     

    H

    SINVOICE

    BPRPAY

    Paying BP

    Alphanumeric

    15

    H

    SINVOICE

    BPAPAY

    BP address

    Alphanumeric

    5

    H

    SINVOICE

    BPYNAM

    Company name

    Alphanumeric

    35

    H

    SINVOICE

    BPYNAM(1)

    Company name

    Alphanumeric

    35

    H

    SINVOICE

    BPYADDLIG

    Address line

    Alphanumeric

    40

    H

    SINVOICE

    BPYADDLIG(1)

    Address line

    Alphanumeric

    40

    H

    SINVOICE

    BPYADDLIG(2)

    Address line

    Alphanumeric

    40

    H

    SINVOICE

    BPYPOSCOD

    Postal code

    Alphanumeric

    10

    H

    SINVOICE

    BPYCTY

    City

    Alphanumeric

    40

    H

    SINVOICE

    BPYSAT

    Report

    Alphanumeric

    35

    H

    SINVOICE

    BPYCRY

    Country

    Alphanumeric

    3

    H

    SINVOICE

    BPYCRYNAM

    Country name

    Alphanumeric

    40

    H

    SINVOICE

    BPRFCT

    Factor

    Alphanumeric

    15

    H

    SINVOICE

    FCTVCR

    Voucher

    Alphanumeric

    20

    H

    SINVOICE

    FCTVCRFLG

    Validated voucher

    Short integer

    1

    H

    SINVOICE

    QTCACCNUM

    Voucher acct scr no.

    Long integer

    *8

    H

    SINVOICE

    STRDUDDAT

    Due date basis

    Date

     

    H

    SINVOICE

    PTE

    Payment term

    Alphanumeric

    15

    H

    SINVOICE

    DEP

    Early discounts/Late charges

    Alphanumeric

    3

    H

    SINVOICE

    VAC

    VAT rule

    Miscellaneous table 1

     

    H

    SINVOICE

    STA

    Report

    Local menu 2261

     

    H

    SINVOICE

    DES

    Comments

    Alphanumeric

    30

    H

    SINVOICE

    DES(1)

    Comments

    Alphanumeric

    30

    H

    SINVOICE

    DES(2)

    Comments

    Alphanumeric

    30

    H

    SINVOICE

    DES(3)

    Comments

    Alphanumeric

    30

    H

    SINVOICE

    DES(4)

    Comments

    Alphanumeric

    30

    H

    SINVOICE

    INVNUM

    Invoice number

    Alphanumeric

    20

    H

    SINVOICE

    SNS

    Sens

    Short integer

    2

    H

    SINVOICE

    AMTATI

    Tax incl amount

    Decimal

    13.2

    H

    SINVOICE

    AMTNOT

    Ex-tax amount

    Decimal

    13.2

    H

    SINVOICE

    NBRTAX

    No. of taxes

    Short integer

    2

    H

    SINVOICE

    TAX

    Taxes

    Alphanumeric

    5

    H

    SINVOICE

    TAX(1)

    Taxes

    Alphanumeric

    5

    H

    SINVOICE

    TAX(2)

    Taxes

    Alphanumeric

    5

    H

    SINVOICE

    TAX(3)

    Taxes

    Alphanumeric

    5

    H

    SINVOICE

    TAX(4)

    Taxes

    Alphanumeric

    5

    H

    SINVOICE

    TAX(5)

    Taxes

    Alphanumeric

    5

    H

    SINVOICE

    TAX(6)

    Taxes

    Alphanumeric

    5

    H

    SINVOICE

    TAX(7)

    Taxes

    Alphanumeric

    5

    H

    SINVOICE

    TAX(8)

    Taxes

    Alphanumeric

    5

    H

    SINVOICE

    TAX(9)

    Taxes

    Alphanumeric

    5

    H

    SINVOICE

    BASTAX

    Tax basis

    Decimal

    13.2

    H

    SINVOICE

    BASTAX(1)

    Tax basis

    Decimal

    13.2

    H

    SINVOICE

    BASTAX(2)

    Tax basis

    Decimal

    13.2

    H

    SINVOICE

    BASTAX(3)

    Tax basis

    Decimal

    13.2

    H

    SINVOICE

    BASTAX(4)

    Tax basis

    Decimal

    13.2

    H

    SINVOICE

    BASTAX(5)

    Tax basis

    Decimal

    13.2

    H

    SINVOICE

    BASTAX(6)

    Tax basis

    Decimal

    13.2

    H

    SINVOICE

    BASTAX(7)

    Tax basis

    Decimal

    13.2

    H

    SINVOICE

    BASTAX(8)

    Tax basis

    Decimal

    13.2

    H

    SINVOICE

    BASTAX(9)

    Tax basis

    Decimal

    13.2

    H

    SINVOICE

    AMTTAX

    Tax amount

    Decimal

    13.2

    H

    SINVOICE

    AMTTAX(1)

    Tax amount

    Decimal

    13.2

    H

    SINVOICE

    AMTTAX(2)

    Tax amount

    Decimal

    13.2

    H

    SINVOICE

    AMTTAX(3)

    Tax amount

    Decimal

    13.2

    H

    SINVOICE

    AMTTAX(4)

    Tax amount

    Decimal

    13.2

    H

    SINVOICE

    AMTTAX(5)

    Tax amount

    Decimal

    13.2

    H

    SINVOICE

    AMTTAX(6)

    Tax amount

    Decimal

    13.2

    H

    SINVOICE

    AMTTAX(7)

    Tax amount

    Decimal

    13.2

    H

    SINVOICE

    AMTTAX(8)

    Tax amount

    Decimal

    13.2

    H

    SINVOICE

    AMTTAX(9)

    Tax amount

    Decimal

    13.2

    H

    SINVOICE

    EXEAMTTAX

    Exemption amount

    Decimal

    13.2

    H

    SINVOICE

    EXEAMTTAX(1)

    Exemption amount

    Decimal

    13.2

    H

    SINVOICE

    EXEAMTTAX(2)

    Exemption amount

    Decimal

    13.2

    H

    SINVOICE

    EXEAMTTAX(3)

    Exemption amount

    Decimal

    13.2

    H

    SINVOICE

    EXEAMTTAX(4)

    Exemption amount

    Decimal

    13.2

    H

    SINVOICE

    EXEAMTTAX(5)

    Exemption amount

    Decimal

    13.2

    H

    SINVOICE

    EXEAMTTAX(6)

    Exemption amount

    Decimal

    13.2

    H

    SINVOICE

    EXEAMTTAX(7)

    Exemption amount

    Decimal

    13.2

    H

    SINVOICE

    EXEAMTTAX(8)

    Exemption amount

    Decimal

    13.2

    H

    SINVOICE

    EXEAMTTAX(9)

    Exemption amount

    Decimal

    13.2

    H

    SINVOICE

    DIE

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(1)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(1)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(2)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(2)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(3)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(3)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(4)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(4)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(5)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(5)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(6)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(6)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(7)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(7)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(8)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(8)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(9)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(9)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(10)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(10)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(11)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(11)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(12)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(12)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(13)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(13)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(14)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(14)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(15)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(15)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(16)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(16)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(17)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(17)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(18)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(18)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    DIE(19)

    Dimension code

    Alphanumeric

    3

    H

    SINVOICE

    CCE(19)

    Analytical dimension

    Alphanumeric

    15

    H

    SINVOICE

    BPAINV

    Address

    Alphanumeric

    5

    H

    SINVOICE

    BPRNAM

    Company name

    Alphanumeric

    35

    H

    SINVOICE

    BPRNAM(1)

    Company name

    Alphanumeric

    35

    H

    SINVOICE

    BPAADDLIG

    Address line

    Alphanumeric

    40

    H

    SINVOICE

    BPAADDLIG(1)

    Address line

    Alphanumeric

    40

    H

    SINVOICE

    BPAADDLIG(2)

    Address line

    Alphanumeric

    40

    H

    SINVOICE

    POSCOD

    Postal code

    Alphanumeric

    10

    H

    SINVOICE

    CTY

    City

    Alphanumeric

    40

    H

    SINVOICE

    SAT

    Report

    Alphanumeric

    35

    H

    SINVOICE

    CRY

    Country

    Alphanumeric

    3

    H

    SINVOICE

    CRYNAM

    Country name

    Alphanumeric

    40

    H

    SINVOICE

    BILVCR

    Draft no.

    Alphanumeric

    20

    H

    SINVOICE

    STRDATSVC

    Service provision start

    Date

     

    H

    SINVOICE

    ENDDATSVC

    Service provision end

    Date

     

    H

    SINVOICE

    LASDATSVC

    Posted revenue accruals

    Date

     

    H

    SINVOICE

    SINUM

    Integrale part no.

    Alphanumeric

    1

    H

    SINVOICE

    STARPT

    Print

    Local menu 1

     

    H

    SINVOICE

    CREDAT

    Creation date

    Date

     

    H

    SINVOICE

    CREUSR

    Creation user

    Alphanumeric

    5

    H

    SINVOICE

    UPDDAT

    Update date

    Date

     

    H

    SINVOICE

    UPDUSR

    Update user

    Alphanumeric

    5

    D

    BPCINVLIG

    /

     

     

     

    D

    BPCINVLIG

    NUM

    Journal number

    Alphanumeric

    20

    D

    BPCINVLIG

    LIG

    Line number

    Short integer

    3

    D

    BPCINVLIG

    FCYLIN

    Site

    Alphanumeric

    5

    D

    BPCINVLIG

    SAC

    Collective

    Alphanumeric

    4

    D

    BPCINVLIG

    BPRLIN

    Business partners

    Alphanumeric

    15

    D

    BPCINVLIG

    COA

    Chart code

    Alphanumeric

    3

    D

    BPCINVLIG

    ACC

    General accounts

    Alphanumeric

    15

    D

    BPCINVLIG

    COA(1)

    Chart code

    Alphanumeric

    3

    D

    BPCINVLIG

    ACC(1)

    General accounts

    Alphanumeric

    15

    D

    BPCINVLIG

    COA(2)

    Chart code

    Alphanumeric

    3

    D

    BPCINVLIG

    ACC(2)

    General accounts

    Alphanumeric

    15

    D

    BPCINVLIG

    COA(3)

    Chart code

    Alphanumeric

    3

    D

    BPCINVLIG

    ACC(3)

    General accounts

    Alphanumeric

    15

    D

    BPCINVLIG

    COA(4)

    Chart code

    Alphanumeric

    3

    D

    BPCINVLIG

    ACC(4)

    General accounts

    Alphanumeric

    15

    D

    BPCINVLIG

    COA(5)

    Chart code

    Alphanumeric

    3

    D

    BPCINVLIG

    ACC(5)

    General accounts

    Alphanumeric

    15

    D

    BPCINVLIG

    COA(6)

    Chart code

    Alphanumeric

    3

    D

    BPCINVLIG

    ACC(6)

    General accounts

    Alphanumeric

    15

    D

    BPCINVLIG

    COA(7)

    Chart code

    Alphanumeric

    3

    D

    BPCINVLIG

    ACC(7)

    General accounts

    Alphanumeric

    15

    D

    BPCINVLIG

    COA(8)

    Chart code

    Alphanumeric

    3

    D

    BPCINVLIG

    ACC(8)

    General accounts

    Alphanumeric

    15

    D

    BPCINVLIG

    COA(9)

    Chart code

    Alphanumeric

    3

    D

    BPCINVLIG

    ACC(9)

    General accounts

    Alphanumeric

    15

    D

    BPCINVLIG

    AMTNOTLIN

    Ex-tax amount

    Decimal

    13.2

    D

    BPCINVLIG

    Tax

    Tax 3

    Alphanumeric

    5

    D

    BPCINVLIG

    AMTVAT

    Tax amount

    Decimal

    13.2

    D

    BPCINVLIG

    TAX1

    Tax 1

    Alphanumeric

    5

    D

    BPCINVLIG

    AMTTAX1

    Tax amount

    Decimal

    13.2

    D

    BPCINVLIG

    TAX2

    Tax 2

    Alphanumeric

    5

    D

    BPCINVLIG

    AMTTAX2

    Tax amount

    Decimal

    13.2

    D

    BPCINVLIG

    AMTATILIN

    Tax incl amount

    Decimal

    13.2

    D

    BPCINVLIG

    DES

    Comments

    Alphanumeric

    30

    D

    BPCINVLIG

    FAS

    Fixed asset

    Alphanumeric

    30

    D

    BPCINVLIG

    STRDAT

    Start date

    Date

     

    D

    BPCINVLIG

    ENDDAT

    End date

    Date

     

    D

    BPCINVLIG

    PERNBR

    Frequency

    Short integer

    4

    D

    BPCINVLIG

    PERTYP

    Frequency

    Local menu 635

     

    D

    BPCINVLIG

    STT1

    Statistics

    Alphanumeric

    3

    D

    BPCINVLIG

    STT2

    Statistics

    Alphanumeric

    3

    D

    BPCINVLIG

    STT3

    Statistics

    Alphanumeric

    3

    D

    BPCINVLIG

    QTY

    Quantity

    Decimal

    15

    D

    BPCINVLIG

    DSP

    Allocation

    Alphanumeric

    10

    A

    BPCINVLIGA

    /

     

     

     

    A

    BPCINVLIGA

    NUM

    Journal number

    Alphanumeric

    20

    A

    BPCINVLIGA

    LIG

    Line number

    Short integer

    3

    A

    BPCINVLIGA

    ANALIG

    Order number

    Short integer

    3

    A

    BPCINVLIGA

    COA

    Chart code

    Alphanumeric

    3

    A

    BPCINVLIGA

    ACC

    General accounts

    Alphanumeric

    15

    A

    BPCINVLIGA

    COA(1)

    Chart code

    Alphanumeric

    3

    A

    BPCINVLIGA

    ACC(1)

    General accounts

    Alphanumeric

    15

    A

    BPCINVLIGA

    COA(2)

    Chart code

    Alphanumeric

    3

    A

    BPCINVLIGA

    ACC(2)

    General accounts

    Alphanumeric

    15

    A

    BPCINVLIGA

    COA(3)

    Chart code

    Alphanumeric

    3

    A

    BPCINVLIGA

    ACC(3)

    General accounts

    Alphanumeric

    15

    A

    BPCINVLIGA

    COA(4)

    Chart code

    Alphanumeric

    3

    A

    BPCINVLIGA

    ACC(4)

    General accounts

    Alphanumeric

    15

    A

    BPCINVLIGA

    COA(5)

    Chart code

    Alphanumeric

    3

    A

    BPCINVLIGA

    ACC(5)

    General accounts

    Alphanumeric

    15

    A

    BPCINVLIGA

    COA(6)

    Chart code

    Alphanumeric

    3

    A

    BPCINVLIGA

    ACC(6)

    General accounts

    Alphanumeric

    15

    A

    BPCINVLIGA

    COA(7)

    Chart code

    Alphanumeric

    3

    A

    BPCINVLIGA

    ACC(7)

    General accounts

    Alphanumeric

    15

    A

    BPCINVLIGA

    COA(8)

    Chart code

    Alphanumeric

    3

    A

    BPCINVLIGA

    ACC(9)

    General accounts

    Alphanumeric

    15

    A

    BPCINVLIGA

    COA(9)

    Chart code

    Alphanumeric

    3

    A

    BPCINVLIGA

    AMT

    Amount

    Decimal

    13.2

    A

    BPCINVLIGA

    UOM

    Nonfinancial unit

    Alphanumeric

    3

    A

    BPCINVLIGA

    QTY

    Quantity

    Decimal

    15

    A

    BPCINVLIGA

    DIE

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(1)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(1)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(2)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(2)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(3)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(3)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(4)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(4)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(5)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(5)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(6)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(6)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(7)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(7)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(8)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(8)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(9)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(9)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(10)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(10)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(11)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(11)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(12)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(12)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(13)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(13)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(14)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(14)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(15)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(15)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(16)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(16)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(17)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(17)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(18)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(18)

    Analytical dimension

    Alphanumeric

    15

    A

    BPCINVLIGA

    DIE(19)

    Dimension code

    Alphanumeric

    3

    A

    BPCINVLIGA

    CCE(19)

    Analytical dimension

    Alphanumeric

    15

  • DGIBIS - DGI Export - Supplier BP invoice

    Flag

    Table

    Field code

    Field description

    Data type

    Length

    H

    PINVOICE

    /

     

     

     

    H

    PINVOICE

    PIVTYP

    Invoice type

    Alphanumeric

    5

    H

    PINVOICE

    INVTYP

    Invoice category

    Local menu 645

     

    H

    PINVOICE

    NUM

    Journal number

    Alphanumeric

    20

    H

    PINVOICE

    ORIMOD 2

    Source module

    Local menu 14

     

    H

    PINVOICE

    BPR

    BP

    Alphanumeric

    15

    H

    PINVOICE

    BPRSAC

    Collective

    Alphanumeric

    4

    H

    PINVOICE

    CPY

    Company

    Alphanumeric

    5

    H

    PINVOICE

    FCY

    Site

    Alphanumeric

    5

    H

    PINVOICE

    GTE

    Entry type

    Alphanumeric

    5

    H

    PINVOICE

    JOU

    Journal

    Alphanumeric

    5

    H

    PINVOICE

    ACCDAT

    Accounting date

    Date

     

    H

    PINVOICE

    ACCNUM

    Internal number

    Long integer

    *8

    H

    PINVOICE

    BPRDAT

    Original date

    Date

     

    H

    PINVOICE

    BPRVCR

    Source document

    Alphanumeric

    20

    H

    PINVOICE

    CUR

    Currency

    Alphanumeric

    3

    H

    PINVOICE

    CURTYP

    Exchange rate type

    Local menu 202

     

    H

    PINVOICE

    LED

    Ledger

    Alphanumeric

    3

    H

    PINVOICE

    CURLED

    Ledger currency

    Alphanumeric

    5

    H

    PINVOICE

    RATMLT

    Multiplying rate

    Decimal

    11

    H

    PINVOICE

    RATDIV

    Dividing rate

    Decimal

    11

    H

    PINVOICE

    LED(1)

    Ledger

    Alphanumeric

    3

    H

    PINVOICE

    CURLED(1)

    Ledger currency

    Alphanumeric

    5

    H

    PINVOICE

    RATMLT(1)

    Multiplying rate

    Decimal

    11

    H

    PINVOICE

    RATDIV(1)

    Dividing rate

    Decimal

    11

    H

    PINVOICE

    LED(2)

    Ledger

    Alphanumeric

    3

    H

    PINVOICE

    CURLED(2)

    Ledger currency

    Alphanumeric

    5

    H

    PINVOICE

    RATMLT(2)

    Multiplying rate

    Decimal

    11

    H

    PINVOICE

    WEB(2)

    Dividing rate

    Decimal

    11

    H

    PINVOICE

    LED(3)

    Ledger

    Alphanumeric

    3

    H

    PINVOICE

    CURLED(3)

    Ledger currency

    Alphanumeric

    5

    H

    PINVOICE

    RATMLT(3)

    Multiplying rate

    Decimal

    11

    H

    PINVOICE

    RATDIV(3)

    Dividing rate

    Decimal

    11

    H

    PINVOICE

    LED(4)

    Ledger

    Alphanumeric

    3

    H

    PINVOICE

    CURLED(4)

    Ledger currency

    Alphanumeric

    5

    H

    PINVOICE

    RATMLT(4)

    Multiplying rate

    Decimal

    11

    H

    PINVOICE

    RATDIV(4)

    Dividing rate

    Decimal

    11

    H

    PINVOICE

    LED(5)

    Ledger

    Alphanumeric

    3

    H

    PINVOICE

    CURLED(5)

    Ledger currency

    Alphanumeric

    5

    H

    PINVOICE

    RATMLT(5)

    Multiplying rate

    Decimal

    11

    H

    PINVOICE

    RATDIV(5)

    Dividing rate

    Decimal

    11

    H

    PINVOICE

    LED(6)

    Ledger

    Alphanumeric

    3

    H

    PINVOICE

    CURLED(6)

    Ledger currency

    Alphanumeric

    5

    H

    PINVOICE

    RATMLT(6)

    Multiplying rate

    Decimal

    11

    H

    PINVOICE

    RATDIV(6)

    Dividing rate

    Decimal

    11

    H

    PINVOICE

    LED(7)

    Ledger

    Alphanumeric

    3

    H

    PINVOICE

    CURLED(7)

    Ledger currency

    Alphanumeric

    5

    H

    PINVOICE

    RATMLT(7)

    Multiplying rate

    Decimal

    11

    H

    PINVOICE

    RATDIV(7)

    Dividing rate

    Decimal

    11

    H

    PINVOICE

    LED(8)

    Ledger

    Alphanumeric

    3

    H

    PINVOICE

    CURLED(8)

    Ledger currency

    Alphanumeric

    5

    H

    PINVOICE

    RATMLT(8)

    Multiplying rate

    Decimal

    11

    H

    PINVOICE

    RATDIV(8)

    Dividing rate

    Decimal

    11

    H

    PINVOICE

    LED(9)

    Ledger

    Alphanumeric

    3

    H

    PINVOICE

    CURLED(9)

    Ledger currency

    Alphanumeric

    5

    H

    PINVOICE

    RATMLT(9)

    Multiplying rate

    Decimal

    11

    H

    PINVOICE

    RATDIV(9)

    Dividing rate

    Decimal

    11

    H

    PINVOICE

    RATDAT

    Rate date

    Date

     

    H

    PINVOICE

    BPRPAY

    Paying BP

    Alphanumeric

    15

    H

    PINVOICE

    BPAPAY

    Pay-to BP address

    Alphanumeric

    5

    H

    PINVOICE

    BPYNAM

    Company name

    Alphanumeric

    35

    H

    PINVOICE

    BPYNAM(1)

    Company name

    Alphanumeric

    35

    H

    PINVOICE

    BPYADDLIG

    Address line

    Alphanumeric

    40

    H

    PINVOICE

    BPYADDLIG(1)

    Address line

    Alphanumeric

    40

    H

    PINVOICE

    BPYADDLIG(2)

    Address line

    Alphanumeric

    40

    H

    PINVOICE

    BPYPOSCOD

    Postal code

    Alphanumeric

    10

    H

    PINVOICE

    BPYCTY

    City

    Alphanumeric

    40

    H

    PINVOICE

    BPYSAT

    Report

    Alphanumeric

    35

    H

    PINVOICE

    BPYCRY

    Country

    Alphanumeric

    3

    H

    PINVOICE

    BPYCRYNAM

    Country name

    Alphanumeric

    40

    H

    PINVOICE

    STRDUDDAT

    Due date basis

    Date

     

    H

    PINVOICE

    PTE

    Payment term

    Alphanumeric

    15

    H

    PINVOICE

    DAS2

    DAS2

    Local menu 1

     

    H

    PINVOICE

    PAZ

    Payment approval

    Local menu 510

     

    H

    PINVOICE

    DEP

    Early discounts/Late charges

    Alphanumeric

    3

    H

    PINVOICE

    VAC

    VAT rule

    Miscellaneous table 1

     

    H

    PINVOICE

    STA

    Report

    Local menu 509

     

    H

    PINVOICE

    DES

    Comments

    Alphanumeric

    30

    H

    PINVOICE

    DES(1)

    Comments

    Alphanumeric

    30

    H

    PINVOICE

    DES(2)

    Comments

    Alphanumeric

    30

    H

    PINVOICE

    DES(3)

    Comments

    Alphanumeric

    30

    H

    PINVOICE

    DES(4)

    Comments

    Alphanumeric

    30

    H

    PINVOICE

    INVNUM

    Invoice number

    Alphanumeric

    20

    H

    PINVOICE

    SNS

    Sens

    Short integer

    2

    H

    PINVOICE

    AMTATI

    Tax incl amount

    Decimal

    13.2

    H

    PINVOICE

    AMTNOT

    Ex-tax amount

    Decimal

    13.2

    H

    PINVOICE

    NBRTAX

    No. of taxes

    Short integer

    2

    H

    PINVOICE

    TAX

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(1)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(1)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(1)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(1)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(1)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(2)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(2)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(2)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(2)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(2)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(3)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(3)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(3)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(3)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(3)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(4)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(4)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(4)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(4)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(4)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(5)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(5)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(5)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(5)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(5)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(6)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(6)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(6)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(6)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(6)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(7)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(7)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(7)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(7)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(7)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(8)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(8)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(8)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(8)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(8)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(9)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(9)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(9)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(9)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(9)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(10)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(10)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(10)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(10)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(10)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(11)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(11)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(11)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(11)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(11)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(12)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(12)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(12)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(12)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(12)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(13)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(13)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(13)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(13)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(13)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(14)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(14)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(14)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(14)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(14)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(15)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(15)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(15)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(15)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(15)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(16)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(16)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(16)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(16)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(16)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(17)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(17)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(17)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(17)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(17)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(18)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(18)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(18)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(18)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(18)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    TAX(19)

    Taxes

    Alphanumeric

    5

    H

    PINVOICE

    PURTYP(19)

    Purchase type

    Local menu 646

     

    H

    PINVOICE

    BASTAX(19)

    Tax basis

    Decimal

    13.2

    H

    PINVOICE

    AMTTAX(19)

    Tax amount

    Decimal

    13.2

    H

    PINVOICE

    DEDTAX(19)

    Deductible tax

    Decimal

    13.2

    H

    PINVOICE

    DIE

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(1)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(1)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(2)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(2)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(3)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(3)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(4)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(4)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(5)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(5)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(6)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(6)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(7)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(7)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(8)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(8)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(9)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(9)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(10)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(10)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(11)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(11)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(12)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(12)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(13)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(13)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(14)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(14)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(15)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(15)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(16)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(16)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(17)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(17)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(18)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(18)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    DIE(19)

    Dimension code

    Alphanumeric

    3

    H

    PINVOICE

    CCE(19)

    Analytical dimension

    Alphanumeric

    15

    H

    PINVOICE

    BPAINV

    Address

    Alphanumeric

    5

    H

    PINVOICE

    BPRNAM

    Company name

    Alphanumeric

    35

    H

    PINVOICE

    BPRNAM(1)

    Company name

    Alphanumeric

    35

    H

    PINVOICE

    BPAADDLIG

    Address line

    Alphanumeric

    40

    H

    PINVOICE

    BPAADDLIG(1)

    Address line

    Alphanumeric

    40

    H

    PINVOICE

    BPAADDLIG(2)

    Address line

    Alphanumeric

    40

    H

    PINVOICE

    POSCOD

    Postal code

    Alphanumeric

    10

    H

    PINVOICE

    CTY

    City

    Alphanumeric

    40

    H

    PINVOICE

    SAT

    Report

    Alphanumeric

    35

    H

    PINVOICE

    CRY

    Country

    Alphanumeric

    3

    H

    PINVOICE

    CRYNAM

    Country name

    Alphanumeric

    40

    H

    PINVOICE

    STRDATSVC

    Service provision start

    Date

     

    H

    PINVOICE

    ENDDATSVC

    Service provision end

    Date

     

    H

    PINVOICE

    LASDATSVC

    Posted cost accruals

    Date

     

    H

    PINVOICE

    SINUM

    Integrale part no.

    Alphanumeric

    1

    H

    PINVOICE

    CREDAT

    Creation date

    Date

     

    H

    PINVOICE

    CREUSR

    Creation user

    Alphanumeric

    5

    H

    PINVOICE

    UPDDAT

    Update date

    Date

     

    H

    PINVOICE

    UPDUSR

    Update user

    Alphanumeric

    5

    D

    BPSINVLIG

    /

     

     

     

    D

    BPSINVLIG

    NUM

    Journal number

    Alphanumeric

    20

    D

    BPSINVLIG

    LIG

    Line number

    Short integer

    3

    D

    BPSINVLIG

    FCYLIN

    Site

    Alphanumeric

    5

    D

    BPSINVLIG

    SAC

    Collective

    Alphanumeric

    4

    D

    BPSINVLIG

    BPRLIN

    Business partners

    Alphanumeric

    15

    D

    BPSINVLIG

    COA

    Chart code

    Alphanumeric

    3

    D

    BPSINVLIG

    ACC

    General accounts

    Alphanumeric

    15

    D

    BPSINVLIG

    COA(1)

    Chart code

    Alphanumeric

    3

    D

    BPSINVLIG

    ACC(1)

    General accounts

    Alphanumeric

    15

    D

    BPSINVLIG

    COA(2)

    Chart code

    Alphanumeric

    3

    D

    BPSINVLIG

    ACC(2)

    General accounts

    Alphanumeric

    15

    D

    BPSINVLIG

    COA(3)

    Chart code

    Alphanumeric

    3

    D

    BPSINVLIG

    ACC(3)

    General accounts

    Alphanumeric

    15

    D

    BPSINVLIG

    COA(4)

    Chart code

    Alphanumeric

    3

    D

    BPSINVLIG

    ACC(4)

    General accounts

    Alphanumeric

    15

    D

    BPSINVLIG

    COA(5)

    Chart code

    Alphanumeric

    3

    D

    BPSINVLIG

    ACC(5)

    General accounts

    Alphanumeric

    15

    D

    BPSINVLIG

    COA(6)

    Chart code

    Alphanumeric

    3

    D

    BPSINVLIG

    ACC(6)

    General accounts

    Alphanumeric

    15

    D

    BPSINVLIG

    COA(7)

    Chart code

    Alphanumeric

    3

    D

    BPSINVLIG

    ACC(7)

    General accounts

    Alphanumeric

    15

    D

    BPSINVLIG

    COA(8)

    Chart code

    Alphanumeric

    3

    D

    BPSINVLIG

    ACC(8)

    General accounts

    Alphanumeric

    15

    D

    BPSINVLIG

    COA(9)

    Chart code

    Alphanumeric

    3

    D

    BPSINVLIG

    ACC(9)

    General accounts

    Alphanumeric

    15

    D

    BPSINVLIG

    AMTNOTLIN

    Ex-tax amount

    Decimal

    13.2

    D

    BPSINVLIG

    Tax

    Tax 3

    Alphanumeric

    5

    D

    BPSINVLIG

    AMTVAT

    Tax amount

    Decimal

    13.2

    D

    BPSINVLIG

    DEDVAT

    Deductible VAT

    Decimal

    13.2

    D

    BPSINVLIG

    TAX1

    Tax 1

    Alphanumeric

    5

    D

    BPSINVLIG

    AMTTAX1

    Tax amount

    Decimal

    13.2

    D

    BPSINVLIG

    DEDTAX1

    Deductible tax

    Decimal

    13.2

    D

    BPSINVLIG

    TAX2

    Tax 2

    Alphanumeric

    5

    D

    BPSINVLIG

    AMTTAX2

    Tax amount

    Decimal

    13.2

    D

    BPSINVLIG

    DEDTAX2

    Deductible tax

    Decimal

    13.2

    D

    BPSINVLIG

    AMTATILIN

    Tax incl amount

    Decimal

    13.2

    D

    BPSINVLIG

    DES

    Comments

    Alphanumeric

    30

    D

    BPSINVLIG

    STRDAT

    Start date

    Date

     

    D

    BPSINVLIG

    ENDDAT

    End date

    Date

     

    D

    BPSINVLIG

    PERNBR

    Frequency

    Short integer

    4

    D

    BPSINVLIG

    PERTYP

    Frequency

    Local menu 635

     

    D

    BPSINVLIG

    STT1

    Statistics

    Alphanumeric

    3

    D

    BPSINVLIG

    STT2

    Statistics

    Alphanumeric

    3

    D

    BPSINVLIG

    STT3

    Statistics

    Alphanumeric

    3

    D

    BPSINVLIG

    QTY

    Quantity

    Decimal

    15

    D

    BPSINVLIG

    DSP

    Allocation

    Alphanumeric

    10

    A

    BPSINVLIGA

    /

     

     

     

    A

    BPSINVLIGA

    NUM

    Journal number

    Alphanumeric

    20

    A

    BPSINVLIGA

    LIG

    Line number

    Short integer

    3

    A

    BPSINVLIGA

    ANALIG

    Order number

    Short integer

    3

    A

    BPSINVLIGA

    COA

    Chart code

    Alphanumeric

    3

    A

    BPSINVLIGA

    ACC

    General accounts

    Alphanumeric

    15

    A

    BPSINVLIGA

    COA(1)

    Chart code

    Alphanumeric

    3

    A

    BPSINVLIGA

    ACC(1)

    General accounts

    Alphanumeric

    15

    A

    BPSINVLIGA

    COA(2)

    Chart code

    Alphanumeric

    3

    A

    BPSINVLIGA

    ACC(2)

    General accounts

    Alphanumeric

    15

    A

    BPSINVLIGA

    COA(3)

    Chart code

    Alphanumeric

    3

    A

    BPSINVLIGA

    ACC(3)

    General accounts

    Alphanumeric

    15

    A

    BPSINVLIGA

    COA(4)

    Chart code

    Alphanumeric

    3

    A

    BPSINVLIGA

    ACC(4)

    General accounts

    Alphanumeric

    15

    A

    BPSINVLIGA

    COA(5)

    Chart code

    Alphanumeric

    3

    A

    BPSINVLIGA

    ACC(5)

    General accounts

    Alphanumeric

    15

    A

    BPSINVLIGA

    COA(6)

    Chart code

    Alphanumeric

    3

    A

    BPSINVLIGA

    ACC(6)

    General accounts

    Alphanumeric

    15

    A

    BPSINVLIGA

    COA(7)

    Chart code

    Alphanumeric

    3

    A

    BPSINVLIGA

    ACC(7)

    General accounts

    Alphanumeric

    15

    A

    BPSINVLIGA

    COA(8)

    Chart code

    Alphanumeric

    3

    A

    BPSINVLIGA

    ACC(9)

    General accounts

    Alphanumeric

    15

    A

    BPSINVLIGA

    COA(9)

    Chart code

    Alphanumeric

    3

    A

    BPSINVLIGA

    AMT

    Amount

    Decimal

    13.2

    A

    BPSINVLIGA

    UOM

    Nonfinancial unit

    Alphanumeric

    3

    A

    BPSINVLIGA

    QTY

    Quantity

    Decimal

    15

    A

    BPSINVLIGA

    DIE

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(1)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(1)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(2)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(2)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(3)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(3)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(4)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(4)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(5)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(5)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(6)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(6)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(7)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(7)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(8)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(8)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(9)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(9)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(10)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(10)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(11)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(11)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(12)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(12)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(13)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(13)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(14)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(14)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(15)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(15)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(16)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(16)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(17)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(17)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(18)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(18)

    Analytical dimension

    Alphanumeric

    15

    A

    BPSINVLIGA

    DIE(19)

    Dimension code

    Alphanumeric

    3

    A

    BPSINVLIGA

    CCE(19)

    Analytical dimension

    Alphanumeric

    15

  • DGIBPC - GI Export - Customers

    Flag

    Table

    Field code

    Field description

    Data type

    Length

    BPC

    BPCUSTOMER

    /

     

     

     

    BPC

    BPCUSTOMER

    BPCNUM

    Customer record

    Alphanumeric

    15

    BPC

    BPARTNER

    BPRNAM

    Company name

    Alphanumeric

    35

    BPC

    BPARTNER

    BPRNAM(1)

    Company name

    Alphanumeric

    35

    BPC

    BPARTNER

    BPRSHO

    Short title

    Alphanumeric

    10

    BPC

    BPARTNER

    BPRLOG

    Acronym

    Alphanumeric

    10

    BPC

    BPARTNER

    EECNUM

    EU VAT no.

    Alphanumeric

    20

    BPC

    BPARTNER

    CRN

    Site tax ID number

    Alphanumeric

    20

    BPC

    BPARTNER

    NAF

    NAF code

    Alphanumeric

    10

    BPC

    BPARTNER

    CRY

    Country

    Alphanumeric

    3

    BPC

    BPARTNER

    LAN

    Language

    Alphanumeric

    3

    BPC

    BPCUSTOMER

    CUR

    Currency

    Alphanumeric

    3

    BPC

    BPCUSTOMER

    ACCCOD

    Accounting code

    Alphanumeric

    10

    BPC

    BPCUSTOMER

    VACBPR

    Tax rule

    Miscellaneous table 1

     

    BPC

    BPCUSTOMER

    PTE

    Payment term

    Alphanumeric

    15

    BPC

    BPCUSTOMER

    DEP

    Discount code

    Alphanumeric

    3

    BPC

    BPCUSTOMER

    BCGCOD

    Category

    Alphanumeric

    5

    BPC

    BPCUSTOMER

    BPCGRU

    Group customer

    Alphanumeric

    15

    BPC

    BPCUSTOMER

    BPCINV

    Invoice customer

    Alphanumeric

    15

    BPC

    BPCUSTOMER

    BPCPYR

    Paying BP

    Alphanumeric

    15

    BPC

    BPCUSTOMER

    BPCRSK

    Risk BP

    Alphanumeric

    15

    BPC

    BPCUSTOMER

    FCTNUM

    Factor

    Alphanumeric

    15

    BPC

    BPCUSTOMER

    OSTAUZ

    Authorized credit level

    Decimal

    13.2

    BPC

    BPCUSTOMER

    OSTCTL

    Credit control

    Local menu 234

     

    ADD

    BPADDRESS

    /

     

     

     

    ADD

    BPADDRESS

    BPAADD

    Address

    Alphanumeric

    5

    ADD

    BPADDRESS

    BPADES

    Description

    Alphanumeric

    30

    ADD

    BPADDRESS

    BPAADDFLG

    By default

    Local menu 1

     

    ADD

    BPADDRESS

    BPAADDLIG

    Address line

    Alphanumeric

    40

    ADD

    BPADDRESS

    BPAADDLIG(1)

    Address line

    Alphanumeric

    40

    ADD

    BPADDRESS

    BPAADDLIG(2)

    Address line

    Alphanumeric

    40

    ADD

    BPADDRESS

    POSCOD

    Postal code

    Alphanumeric

    10

    ADD

    BPADDRESS

    CTY

    City

    Alphanumeric

    40

    ADD

    BPADDRESS

    CRY

    Country

    Alphanumeric

    3

    BID

    BID

    /

     

     

     

    BID

    BID

    BPAADD

    Address

    Alphanumeric

    5

    BID

    BID

    BIDNUMFLG

    By default

    Local menu 1

     

    BID

    BID

    PAB1

    Paying bank

    Alphanumeric

    35

    BID

    BID

    PAB2

    Paying bank 2

    Alphanumeric

    35

    BID

    BID

    PAB3

    Paying bank 3

    Alphanumeric

    35

    BID

    BID

    BIDNUM

    Bank ID number

    Alphanumeric

    30

    BID

    BID

    BICCOD

    BIC code

    Alphanumeric

    11

    BID

    BID

    IBAN

    IBAN prefix

    Alphanumeric

    4

    BID

    BID

    CRY

    Country

    Alphanumeric

    3

    BID

    BID

    CUR

    Currency

    Alphanumeric

    3

    BID

    BID

    BNF

    Beneficiary

    Alphanumeric

    35

  • DGIBPS - DGI Export - Suppliers

    Flag

    Table

    Field code

    Field description

    Data type

    Length

    BPS

    BPSUPPLIER

    /

     

     

     

    BPS

    BPSUPPLIER

    BPSNUM

    Supplier

    Alphanumeric

    15

    BPS

    BPARTNER

    BPRNAM

    Company name

    Alphanumeric

    35

    BPS

    BPARTNER

    BPRNAM(1)

    Company name

    Alphanumeric

    35

    BPS

    BPARTNER

    BPRSHO

    Short title

    Alphanumeric

    10

    BPS

    BPARTNER

    BPRLOG

    Acronym

    Alphanumeric

    10

    BPS

    BPARTNER

    EECNUM

    EU VAT no.

    Alphanumeric

    20

    BPS

    BPARTNER

    CRN

    Site tax ID number

    Alphanumeric

    20

    BPS

    BPARTNER

    NAF

    NAF code

    Alphanumeric

    10

    BPS

    BPARTNER

    CRY

    Country

    Alphanumeric

    3

    BPS

    BPARTNER

    LAN

    Language

    Alphanumeric

    3

    BPS

    BPSUPPLIER

    CUR

    Currency

    Alphanumeric

    3

    BPS

    BPSUPPLIER

    ACCCOD

    Accounting code

    Alphanumeric

    10

    BPS

    BPSUPPLIER

    VACBPR

    Tax rule

    Miscellaneous table 1

     

    BPS

    BPSUPPLIER

    PTE

    Payment term

    Alphanumeric

    15

    BPS

    BPSUPPLIER

    DEP

    Discount code

    Alphanumeric

    3

    BPS

    BPSUPPLIER

    BSGCOD

    Category

    Alphanumeric

    5

    BPS

    BPSUPPLIER

    BPSGRU

    Group Supplier

    Alphanumeric

    15

    BPS

    BPSUPPLIER

    BPSINV

    Invoice supplier

    Alphanumeric

    15

    BPS

    BPSUPPLIER

    BPRPAY

    Paid BP

    Alphanumeric

    15

    BPS

    BPSUPPLIER

    BPSRSK

    Risk BP

    Alphanumeric

    15

    BPS

    BPSUPPLIER

    OSTAUZAMT

    Authorized credit

    Decimal

    13.2

    BPS

    BPSUPPLIER

    OSTCTL

    Credit control

    Local menu 234

     

    BPS

    BPSUPPLIER

    PAYBAN

    Payment bank

    Alphanumeric

    5

    ADD

    BPADDRESS

    /

     

     

     

    ADD

    BPADDRESS

    BPAADD

    Address

    Alphanumeric

    5

    ADD

    BPADDRESS

    BPADES

    Description

    Alphanumeric

    30

    ADD

    BPADDRESS

    BPAADDFLG

    By default

    Local menu 1

     

    ADD

    BPADDRESS

    BPAADDLIG

    Address line

    Alphanumeric

    40

    ADD

    BPADDRESS

    BPAADDLIG(1)

    Address line

    Alphanumeric

    40

    ADD

    BPADDRESS

    BPAADDLIG(2)

    Address line

    Alphanumeric

    40

    ADD

    BPADDRESS

    POSCOD

    Postal code

    Alphanumeric

    10

    ADD

    BPADDRESS

    CTY

    City

    Alphanumeric

    40

    ADD

    BPADDRESS

    CRY

    Country

    Alphanumeric

    3

    BID

    BID

    /

     

     

     

    BID

    BID

    BPAADD

    Address

    Alphanumeric

    5

    BID

    BID

    BIDNUMFLG

    By default

    Local menu 1

     

    BID

    BID

    PAB1

    Paying bank

    Alphanumeric

    35

    BID

    BID

    PAB2

    Paying bank 2

    Alphanumeric

    35

    BID

    BID

    PAB3

    Paying bank 3

    Alphanumeric

    35

    BID

    BID

    BIDNUM

    Bank ID number

    Alphanumeric

    30

    BID

    BID

    BICCOD

    BIC code

    Alphanumeric

    11

    BID

    BID

    IBAN

    IBAN prefix

    Alphanumeric

    4

    BID

    BID

    CRY

    Country

    Alphanumeric

    3

    BID

    BID

    CUR

    Currency

    Alphanumeric

    3

    BID

    BID

    BNF

    Beneficiary

    Alphanumeric

    35

  • DGICAC - DGI Export- Accounting codes

    Flag

    Table

    Field code

    Field description

    Data type

    Length

     

    GACCCODE

    TYP

    Code type

    Local menu 602

     

     

    GACCCODE

    ACCCOD

    Accounting code

    Alphanumeric

    3

     

    GACCCODE 3

    COA

    Chart of accounts

    Alphanumeric

    3

     

    GACCCODE

    DES

    Title

    Alphanumeric

    30

     

    GACCCODE

    DESTRA

    Description

    Alphanumeric

    30

     

    GACCCODE

    SHOTRA

    Short title

    Alphanumeric

    12

     

    GACCCODE

    ACC

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(1)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(2)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(3)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(4)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(5)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(6)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(7)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(8)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(9)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(10)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(11)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(12)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(13)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(14)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(15)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(16)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(17)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(18)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(19)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(20)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(21)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(22)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(23)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(24)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(25)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(26)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(27)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(28)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(29)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(30)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(31)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(32)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(33)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(34)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(35)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(36)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(37)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(38)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(39)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(40)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(41)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(42)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(43)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(44)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(45)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(46)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(47)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(48)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(49)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(50)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(51)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(52)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(53)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(54)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(55)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(56)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(57)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(58)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(59)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(60)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(61)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(62)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(63)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(64)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(65)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(66)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(67)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(68)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(69)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(70)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(71)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(72)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(73)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(74)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(75)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(76)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(77)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(78)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(79)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(80)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(81)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(82)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(83)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(84)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(85)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(86)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(87)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(88)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(89)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(90)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(91)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(92)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(93)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(94)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(95)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(96)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(97)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    ACC(98)

    General accounts

    Alphanumeric

    20

     

    GACCCODE

    CREDAT

    Creation date

    Date

     

     

    GACCCODE

    CREUSR

    Creation user

    Alphanumeric

    5

     

    GACCCODE

    UPDDAT

    Update date

    Date

     

     

    GACCCODE

    UPDUSR

    Update user

    Alphanumeric

    5

  • DGIGAS - DGI Export - Entries

    Flag

    Table

    Field code

    Field description

    Data type

    Length

    H

    GACCENTRY

    /

     

     

     

    H

    GACCENTRY

    CPY

    Company

    Alphanumeric

    5

    H

    GACCENTRY

    FCY

    Site

    Alphanumeric

    5

    H

    GACCENTRY

    TYP

    Entry type

    Alphanumeric

    5

    H

    GACCENTRY

    NUM

    Journal number

    Alphanumeric

    20

    H

    GACCENTRY

    ACCDAT

    Accounting date

    Date

     

    H

    GACCENTRY

    FIY

    Fiscal year

    Short integer

    2

    H

    GACCENTRY

    PER

    Period

    Short integer

    2

    H

    GACCENTRY

    JOU

    Journal

    Alphanumeric

    5

    H

    GACCENTRY

    CAT

    Category

    Local menu 618

     

    H

    GACCENTRY

    STA

    Report

    Local menu 617

     

    H

    GACCENTRY

    DACDIA

    Transaction block

    Alphanumeric

    5

    H

    GACCENTRY

    DESVCR

    Title

    Alphanumeric

    30

    H

    GACCENTRY

    CREDAT

    Creation date

    Date

     

    H

    GACCENTRY

    CREUSR

    Creation user

    Alphanumeric

    5

    H

    GACCENTRY

    UPDDAT

    Update date

    Date

     

    H

    GACCENTRY

    UPDUSR

    Update user

    Alphanumeric

    5

    H

    GACCENTRY

    ENTDAT

    Entry date

    Date

     

    H

    GACCENTRY

    DUDDAT

    Due date

    Date

     

    H

    GACCENTRY

    VALDAT

    Value date

    Date

     

    H

    GACCENTRY

    BANDAT

    Bank date

    Date

     

    H

    GACCENTRY

    FNLPSTDAT

    Date

    Date

     

    H

    GACCENTRY

    FNLPSTNUM(0)

    Final number

    Alphanumeric

    20

    H

    GACCENTRY

    FNLPSTNUM(1)

    Final number

    Alphanumeric

    20

    H

    GACCENTRY

    FNLPSTNUM(2)

    Final number

    Alphanumeric

    20

    H

    GACCENTRY

    FNLPSTNUM(3)

    Final number

    Alphanumeric

    20

    H

    GACCENTRY

    FNLPSTNUM(4)

    Final number

    Alphanumeric

    20

    H

    GACCENTRY

    FNLPSTNUM(5)

    Final number

    Alphanumeric

    20

    H

    GACCENTRY

    FNLPSTNUM(6)

    Final number

    Alphanumeric

    20

    H

    GACCENTRY

    FNLPSTNUM(7)

    Final number

    Alphanumeric

    20

    H

    GACCENTRY

    FNLPSTNUM(8)

    Final number

    Alphanumeric

    20

    H

    GACCENTRY

    FNLPSTNUM(9)

    Final number

    Alphanumeric

    20

    H

    GACCENTRY

    BPRVCR

    Source document

    Alphanumeric

    20

    H

    GACCENTRY

    BPRDATVCR

    Document date

    Date

     

    H

    GACCENTRY

    ORIMOD

    Source module

    Local menu 14

     

    H

    GACCENTRY

    BANCIB

    Inter-banking code

    Miscellaneous table 306

     

    H

    GACCENTRY

    FLGDAS

    DAS2

    Local menu 1

     

    H

    GACCENTRY

    FLGFUP

    Reminder

    Local menu 1

     

    H

    GACCENTRY

    FLGPAZ

    Payment approval

    Local menu 510

     

    H

    GACCENTRY

    TYPRAT

    Exchange rate type

    Local menu 202

     

    H

    GACCENTRY

    RATDAT

    Rate date

    Date

     

    H

    GACCENTRY

    CUR

    Document currency

    Alphanumeric

    3

    H

    GACCENTRY

    LED

    Ledger

    Alphanumeric

    3

    H

    GACCENTRY

    CURLED

    Ledger currency

    Alphanumeric

    3

    H

    GACCENTRY

    RATDIV

    Dividing rate

    Decimal

    11

    H

    GACCENTRY

    RATMLT

    Multiplying rate

    Decimal

    11

    H

    GACCENTRY

    LED(1)

    Ledger

    Alphanumeric

    3

    H

    GACCENTRY

    CURLED(1)

    Ledger currency

    Alphanumeric

    3

    H

    GACCENTRY

    RATDIV(1)

    Dividing rate

    Decimal

    11

    H

    GACCENTRY

    RATMLT(1)

    Multiplying rate

    Decimal

    11

    H

    GACCENTRY

    LED(2)

    Ledger

    Alphanumeric

    3

    H

    GACCENTRY

    CURLED(2)

    Ledger currency

    Alphanumeric

    3

    H

    GACCENTRY

    WEB(2)

    Dividing rate

    Decimal

    11

    H

    GACCENTRY

    RATMLT(2)

    Multiplying rate

    Decimal

    11

    H

    GACCENTRY

    LED(3)

    Ledger

    Alphanumeric

    3

    H

    GACCENTRY

    CURLED(3)

    Ledger currency

    Alphanumeric

    3

    H

    GACCENTRY

    WEB(3)

    Dividing rate

    Decimal

    11

    H

    GACCENTRY

    RATMLT(3)

    Multiplying rate

    Decimal

    11

    H

    GACCENTRY

    LED(4)

    Ledger

    Alphanumeric

    3

    H

    GACCENTRY

    CURLED(4)

    Ledger currency

    Alphanumeric

    3

    H

    GACCENTRY

    WEB(4)

    Dividing rate

    Decimal

    11

    H

    GACCENTRY

    RATMLT(4)

    Multiplying rate

    Decimal

    11

    H

    GACCENTRY

    LED(5)

    Ledger

    Alphanumeric

    3

    H

    GACCENTRY

    CURLED(5)

    Ledger currency

    Alphanumeric

    3

    H

    GACCENTRY

    WEB(5)

    Dividing rate

    Decimal

    11

    H

    GACCENTRY

    RATMLT(5)

    Multiplying rate

    Decimal

    11

    H

    GACCENTRY

    LED(6)

    Ledger

    Alphanumeric

    3

    H

    GACCENTRY

    CURLED(6)

    Ledger currency

    Alphanumeric

    3

    H

    GACCENTRY

    WEB(6)

    Dividing rate

    Decimal

    11

    H

    GACCENTRY

    RATMLT(6)

    Multiplying rate

    Decimal

    11

    H

    GACCENTRY

    LED(7)

    Ledger

    Alphanumeric

    3

    H

    GACCENTRY

    CURLED(7)

    Ledger currency

    Alphanumeric

    3

    H

    GACCENTRY

    WEB(7)

    Dividing rate

    Decimal

    11

    H

    GACCENTRY

    RATMLT(7)

    Multiplying rate

    Decimal

    11

    H

    GACCENTRY

    LED(8)

    Ledger

    Alphanumeric

    3

    H

    GACCENTRY

    CURLED(8)

    Ledger currency

    Alphanumeric

    3

    H

    GACCENTRY

    WEB(8)

    Dividing rate

    Decimal

    11

    H

    GACCENTRY

    RATMLT(8)

    Multiplying rate

    Decimal

    11

    H

    GACCENTRY

    LED(9)

    Ledger

    Alphanumeric

    3

    H

    GACCENTRY

    CURLED(9)

    Ledger currency

    Alphanumeric

    3

    H

    GACCENTRY

    WEB(9)

    Dividing rate

    Decimal

    11

    H

    GACCENTRY

    RATMLT(9)

    Multiplying rate

    Decimal

    11

    H

    GACCENTRY

    REF

    Reference

    Alphanumeric

    30

    H

    GACCENTRY

    REFINT

    Internal reference

    Alphanumeric

    25

    H

    GACCENTRY

    REFSIM

    Simulation reference

    Alphanumeric

    20

    H

    GACCENTRY

    FLGGEN

    Auto generation

    Local menu 1

     

    H

    GACCENTRY

    FLGREP

    Carry-forward

    Local menu 1

     

    H

    GACCENTRY

    RVS

    Reversal

    Local menu 619

     

    H

    GACCENTRY

    RVSDAT

    Reversal date

    Date

     

    H

    GACCENTRY

    RVSORITYP

    Source type

    Alphanumeric

    5

    H

    GACCENTRY

    RVSORINUM

    Source number

    Alphanumeric

    20

    D

    GACCENTRYD

    /

     

     

     

    D

    GACCENTRYD

    TYP

    Entry type

    Alphanumeric

    5

    D

    GACCENTRYD

    NUM

    Journal number

    Alphanumeric

    20

    D

    GACCENTRYD

    LIN

    Line number

    Short integer

    3

    D

    GACCENTRYD

    LEDTYP 4

    Ledger type

    Local menu 2644

     

    D

    GACCENTRYD

    IDTLIN

    Identifier

    Alphanumeric

    5

    D

    GACCENTRYD

    FCYLIN

    Site

    Alphanumeric

    5

    D

    GACCENTRYD

    SAC

    Collective

    Alphanumeric

    4

    D

    GACCENTRYD

    ACC

    General accounts

    Alphanumeric

    15

    D

    GACCENTRYD

    BPR

    BP

    Alphanumeric

    15

    D

    GACCENTRYD

    CUR

    Document currency

    Alphanumeric

    3

    D

    GACCENTRYD

    AMTCUR

    Entry amount

    Decimal

    13.2

    D

    GACCENTRYD

    CURLED

    Ledger currency

    Alphanumeric

    3

    D

    GACCENTRYD

    AMTLED

    Ledger amount

    Decimal

    13.2

    D

    GACCENTRYD

    SNS

    Sens

    Short integer

    2

    D

    GACCENTRYD

    AMTFLG

    Forced amount

    Decimal

    13.2

    D

    GACCENTRYD

    AMTLED1

    Forced amount

    Decimal

    13.2

    D

    GACCENTRYD

    DES

    Title

    Alphanumeric

    30

    D

    GACCENTRYD

    FREREF

    Free reference

    Alphanumeric

    30

    D

    GACCENTRYD

    TAX

    Tax

    Alphanumeric

    5

    D

    GACCENTRYD

    CSLFLO

    Flow

    Miscellaneous table 324

     

    D

    GACCENTRYD

    QTY

    Quantity

    Decimal

    15

    D

    GACCENTRYD

    UOM

    Nonfinancial unit

    Alphanumeric

    3

    D

    GACCENTRYD

    DSP

    Allocation

    Alphanumeric

    10

    D

    GACCENTRYD

    STT1

    Statistics

    Miscellaneous table 351

     

    D

    GACCENTRYD

    STT2

    Statistics

    Miscellaneous table 352

     

    D

    GACCENTRYD

    STT3

    Statistics

    Miscellaneous table 353

     

    D

    GACCENTRYD

    MTC

    Matching

    Alphanumeric

    5

    D

    GACCENTRYD

    MTCDAT

    Matching date

    Date

     

    D

    GACCENTRYD

    MTCDATMAX

    Maximum group date

    Date

     

    D

    GACCENTRYD

    MTCDATMIN

    Minimum group date

    Date

     

    D

    GACCENTRYD

    CHK

    Reconciliation

    Alphanumeric

    5

    D

    GACCENTRYD

    CHKDAT

    Reconciliation date

    Date

     

    D

    GACCENTRYD

    AMTVAT

    Declared VAT

    Decimal

    13.2

    D

    GACCENTRYD

    CHRNUM

    Chronological number

    Alphanumeric

    20

    D

    GACCENTRYD

    ACCNUM

    Unique number

    Long integer

    9

    A

    GACCENTRYA

    /

     

     

     

    A

    GACCENTRYA

    TYP

    Entry type

    Alphanumeric

    5

    A

    GACCENTRYA

    NUM

    Journal number

    Alphanumeric

    20

    A

    GACCENTRYA

    LIN

    Line number

    Short integer

    3

    A

    GACCENTRYA

    LEDTYP

    Ledger type

    Local menu 2644

     

    A

    GACCENTRYA

    ANALIN

    Order number

    Short integer

    3

    A

    GACCENTRYA

    IDTLIN

    Identifier

    Alphanumeric

    5

    A

    GACCENTRYA

    FCYLIN

    Site

    Alphanumeric

    5

    A

    GACCENTRYA

    ACC

    General accounts

    Alphanumeric

    15

    A

    GACCENTRYA

    BPR

    BP

    Alphanumeric

    15

    A

    GACCENTRYA

    CUR

    Document currency

    Alphanumeric

    3

    A

    GACCENTRYA

    AMTCUR

    Entry amount

    Decimal

    13.2

    A

    GACCENTRYA

    LED

    Ledger

    Alphanumeric

    3

    A

    GACCENTRYA

    AMTLED

    Ledger amount

    Decimal

    13.2

    A

    GACCENTRYA

    SNS

    Sens

    Short integer

    2

    A

    GACCENTRYA

    UOM

    Nonfinancial unit

    Alphanumeric

    3

    A

    GACCENTRYA

    QTY

    Quantity

    Decimal

    15

    A

    GACCENTRYA

    DIE(0)

    Dimension code

    Alphanumeric

    3

    A

    GACCENTRYA

    CCE(0)

    Analytical dimension

    Alphanumeric

    15

    A

    GACCENTRYA

    DIE(1)

    Dimension code

    Alphanumeric

    3

    A

    GACCENTRYA

    CCE(1)

    Analytical dimension

    Alphanumeric

    15

    A

    GACCENTRYA

    DIE(2)

    Dimension code

    Alphanumeric

    3

    A

    GACCENTRYA

    CCE(2)

    Analytical dimension

    Alphanumeric

    15

    A

    GACCENTRYA

    DIE(3)

    Dimension code

    Alphanumeric

    3

    A

    GACCENTRYA

    CCE(3)

    Analytical dimension

    Alphanumeric

    15

    A

    GACCENTRYA

    DIE(4)

    Dimension code

    Alphanumeric

    3

    A

    GACCENTRYA

    CCE(4)

    Analytical dimension

    Alphanumeric

    15

    A

    GACCENTRYA

    DIE(5)

    Dimension code

    Alphanumeric

    3

    A

    GACCENTRYA

    CCE(5)

    Analytical dimension

    Alphanumeric

    15

    A

    GACCENTRYA

    DIE(6)

    Dimension code

    Alphanumeric

    3

    A

    GACCENTRYA

    CCE(6)

    Analytical dimension

    Alphanumeric

    15

    A

    GACCENTRYA

    DIE(7)

    Dimension code

    Alphanumeric

    3

    A

    GACCENTRYA

    CCE(7)

    Analytical dimension

    Alphanumeric

    15

    A

    GACCENTRYA

    DIE(8)

    Dimension code

    Alphanumeric

    3

    A

    GACCENTRYA

    CCE(8)

    Analytical dimension

    Alphanumeric

    15

  • DGIGAU - DGI Export - Auto. journals

    Flag

    Table

    Field code

    Field description

    Data type

    Length

    H

    GAUTACE

    /

     

     

     

    H

    GAUTACE

    COD

    Document code

    Alphanumeric

    5

    H

    GAUTACE

    TYP

    Type

    Local menu 665

     

    H

    GAUTACE

    DES

    Title

    Alphanumeric

    30

    H

    GAUTACE

    DESSHO

    Short title

    Alphanumeric

    10

    H

    GAUTACE

    DESTRA

    Description

    Alphanumeric

    30

    H

    GAUTACE

    SHOTRA

    Short title

    Alphanumeric

    12

    H

    GAUTACE

    MODULE

    Module

    Local menu 14

     

    H

    GAUTACE

    JOU

    Journal type

    Local menu 660

     

    H

    GAUTACE

    TBL

    Table

    Alphanumeric

    12

    H

    GAUTACE

    KEYTBL

    Key

    Alphanumeric

    10

    H

    GAUTACE

    GRPFLG

    Grouping

    Local menu 669

     

    H

    GAUTACE

    REITBL

    Repetitive table

    Alphanumeric

    12

    H

    GAUTACE

    REIFLD

    Field code

    Alphanumeric

    10

    H

    GAUTACE

    NBRTBL

    No. of tables

    Short integer

    2

    H

    GAUTACE

    LIKTBL

    Linked tables

    Alphanumeric

    12

    H

    GAUTACE

    LIKTBL(1)

    Linked tables

    Alphanumeric

    12

    H

    GAUTACE

    LIKTBL(2)

    Linked tables

    Alphanumeric

    12

    H

    GAUTACE

    LIKTBL(3)

    Linked tables

    Alphanumeric

    12

    H

    GAUTACE

    LIKTBL(4)

    Linked tables

    Alphanumeric

    12

    H

    GAUTACE

    LIKTBL(5)

    Linked tables

    Alphanumeric

    12

    H

    GAUTACE

    LIKTBL(6)

    Linked tables

    Alphanumeric

    12

    H

    GAUTACE

    LIKTBL(7)

    Linked tables

    Alphanumeric

    12

    H

    GAUTACE

    LIKTBL(8)

    Linked tables

    Alphanumeric

    12

    H

    GAUTACE

    LIKTBL(9)

    Linked tables

    Alphanumeric

    12

    H

    GAUTACE

    LIKFLD

    Linked fields

    Alphanumeric

    15

    H

    GAUTACE

    LIKFLD(1)

    Linked fields

    Alphanumeric

    15

    H

    GAUTACE

    LIKFLD(2)

    Linked fields

    Alphanumeric

    15

    H

    GAUTACE

    LIKFLD(3)

    Linked fields

    Alphanumeric

    15

    H

    GAUTACE

    LIKFLD(4)

    Linked fields

    Alphanumeric

    15

    H

    GAUTACE

    LIKFLD(5)

    Linked fields

    Alphanumeric

    15

    H

    GAUTACE

    LIKFLD(6)

    Linked fields

    Alphanumeric

    15

    H

    GAUTACE

    LIKFLD(7)

    Linked fields

    Alphanumeric

    15

    H

    GAUTACE

    LIKFLD(8)

    Linked fields

    Alphanumeric

    15

    H

    GAUTACE

    LIKFLD(9)

    Linked fields

    Alphanumeric

    15

    H

    GAUTACE

    TYPVCR

    Reference document

    Local menu 2626

     

    H

    GAUTACE

    FORCND

    Condition

    Alphanumeric

    120

    H

    GAUTACE

    FORCND(1)

    Condition

    Alphanumeric

    120

    H

    GAUTACE

    FORCND2

    Condition

    Alphanumeric

    120

    H

    GAUTACE

    NEGAMT

    Negative amounts

    Local menu 1

     

    H

    GAUTACE

    DATFLG

    First date

    Local menu 1

     

    H

    GAUTACE

    ACTLIK

    Action

    Alphanumeric

    10

    H

    GAUTACE

    PRGLIK

    Program

    Alphanumeric

    10

    H

    GAUTACE

    ACTAFTVCR

    End item action

    Alphanumeric

    10

    H

    GAUTACE

    PRGAFTVCR

    Program

    Alphanumeric

    10

    H

    GAUTACE

    ACODACT

    Activity code

    Alphanumeric

    5

    H

    GAUTACE

    CREDAT

    Creation date

    Date

     

    H

    GAUTACE

    UPDDAT

    Update date

    Date

     

    H

    GAUTACE

    CREUSR

    Creation user

    Alphanumeric

    5

    H

    GAUTACE

    UPDUSR

    Update user

    Alphanumeric

    5

    D

    GAUTACED

    /

     

     

     

    D

    GAUTACED

    COD

    Code

    Alphanumeric

    5

    D

    GAUTACED

    LINNUM

    Line number

    Short integer

    4

    D

    GAUTACED

    LINNUMCAR

    Line number

    Alphanumeric

    4

    D

    GAUTACED

    DES

    Title

    Alphanumeric

    30

    D

    GAUTACED

    DESTRA

    Description

    Alphanumeric

    30

    D

    GAUTACED

    NBRLED

    No. of ledgers

    Short integer

    2

    D

    GAUTACED

    LEDTYP

    Ledger type

    Local menu 2644

     

    D

    GAUTACED

    LEDTYP(1)

    Ledger type

    Local menu 2644

     

    D

    GAUTACED

    LEDTYP(2)

    Ledger type

    Local menu 2644

     

    D

    GAUTACED

    LEDTYP(3)

    Ledger type

    Local menu 2644

     

    D

    GAUTACED

    LEDTYP(4)

    Ledger type

    Local menu 2644

     

    D

    GAUTACED

    LEDTYP(5)

    Ledger type

    Local menu 2644

     

    D

    GAUTACED

    LEDTYP(6)

    Ledger type

    Local menu 2644

     

    D

    GAUTACED

    LEDTYP(7)

    Ledger type

    Local menu 2644

     

    D

    GAUTACED

    LEDTYP(8)

    Ledger type

    Local menu 2644

     

    D

    GAUTACED

    LEDTYP(9)

    Ledger type

    Local menu 2644

     

    D

    GAUTACED

    LINTYP

    Line type

    Local menu 625

     

    D

    GAUTACED

    LINTBL1

    Table

    Alphanumeric

    12

    D

    GAUTACED

    LINTBL2

    Table 2

    Alphanumeric

    12

    D

    GAUTACED

    LIKTBL2

    Link expression

    Alphanumeric

    200

    D

    GAUTACED

    FORCND

    Condition

    Alphanumeric

    200

    D

    GAUTACED

    FORCND(1)

    Condition

    Alphanumeric

    200

    D

    GAUTACED

    FORCND(2)

    Condition

    Alphanumeric

    200

    D

    GAUTACED

    FORCND(3)

    Condition

    Alphanumeric

    200

    D

    GAUTACED

    NBRTYP

    Number

    Short integer

    2

    D

    GAUTACED

    ACCCND

    Condition

    Alphanumeric

    100

    D

    GAUTACED

    ACCCND(1)

    Condition

    Alphanumeric

    100

    D

    GAUTACED

    ACCCND(2)

    Condition

    Alphanumeric

    100

    D

    GAUTACED

    ACCCND(3)

    Condition

    Alphanumeric

    100

    D

    GAUTACED

    ACCCND(4)

    Condition

    Alphanumeric

    100

    D

    GAUTACED

    ACCCND(5)

    Condition

    Alphanumeric

    100

    D

    GAUTACED

    ACCCND(6)

    Condition

    Alphanumeric

    100

    D

    GAUTACED

    ACCCND(7)

    Condition

    Alphanumeric

    100

    D

    GAUTACED

    ACCCND(8)

    Condition

    Alphanumeric

    100

    D

    GAUTACED

    ACCCND(9)

    Condition

    Alphanumeric

    100

    D

    GAUTACED

    DETCND

    Condition

    Alphanumeric

    80

    D

    GAUTACED

    DETCND(1)

    Condition

    Alphanumeric

    80

    D

    GAUTACED

    DETCND(2)

    Condition

    Alphanumeric

    80

    D

    GAUTACED

    DETCND(3)

    Condition

    Alphanumeric

    80

    D

    GAUTACED

    DETCND(4)

    Condition

    Alphanumeric

    80

    D

    GAUTACED

    DETCND(5)

    Condition

    Alphanumeric

    80

    D

    GAUTACED

    DETCND(6)

    Condition

    Alphanumeric

    80

    D

    GAUTACED

    DETCND(7)

    Condition

    Alphanumeric

    80

    D

    GAUTACED

    DETCND(8)

    Condition

    Alphanumeric

    80

    D

    GAUTACED

    DETCND(9)

    Condition

    Alphanumeric

    80

    D

    GAUTACED

    TYPACCCOD

    Accounting code

    Local menu 602

     

    D

    GAUTACED

    TYPACCCOD(1)

    Accounting code

    Local menu 602

     

    D

    GAUTACED

    TYPACCCOD(2)

    Accounting code

    Local menu 602

     

    D

    GAUTACED

    TYPACCCOD(3)

    Accounting code

    Local menu 602

     

    D

    GAUTACED

    TYPACCCOD(4)

    Accounting code

    Local menu 602

     

    D

    GAUTACED

    TYPACCCOD(5)

    Accounting code

    Local menu 602

     

    D

    GAUTACED

    TYPACCCOD(6)

    Accounting code

    Local menu 602

     

    D

    GAUTACED

    TYPACCCOD(7)

    Accounting code

    Local menu 602

     

    D

    GAUTACED

    TYPACCCOD(8)

    Accounting code

    Local menu 602

     

    D

    GAUTACED

    TYPACCCOD(9)

    Accounting code

    Local menu 602

     

    D

    GAUTACED

    ACCNUM

    Index

    Short integer

    2

    D

    GAUTACED

    ACCNUM(1)

    Index

    Short integer

    2

    D

    GAUTACED

    ACCNUM(2)

    Index

    Short integer

    2

    D

    GAUTACED

    ACCNUM(3)

    Index

    Short integer

    2

    D

    GAUTACED

    ACCNUM(4)

    Index

    Short integer

    2

    D

    GAUTACED

    ACCNUM(5)

    Index

    Short integer

    2

    D

    GAUTACED

    ACCNUM(6)

    Index

    Short integer

    2

    D

    GAUTACED

    ACCNUM(7)

    Index

    Short integer

    2

    D

    GAUTACED

    ACCNUM(8)

    Index

    Short integer

    2

    D

    GAUTACED

    ACCNUM(9)

    Index

    Short integer

    2

    D

    GAUTACED

    ACCKEY

    Identification key

    Alphanumeric

    80

    D

    GAUTACED

    ACCKEY(1)

    Identification key

    Alphanumeric

    80

    D

    GAUTACED

    ACCKEY(2)

    Identification key

    Alphanumeric

    80

    D

    GAUTACED

    ACCKEY(3)

    Identification key

    Alphanumeric

    80

    D

    GAUTACED

    ACCKEY(4)

    Identification key

    Alphanumeric

    80

    D

    GAUTACED

    ACCKEY(5)

    Identification key

    Alphanumeric

    80

    D

    GAUTACED

    ACCKEY(6)

    Identification key

    Alphanumeric

    80

    D

    GAUTACED

    ACCKEY(7)

    Identification key

    Alphanumeric

    80

    D

    GAUTACED

    ACCKEY(8)

    Identification key

    Alphanumeric

    80

    D

    GAUTACED

    ACCKEY(9)

    Identification key

    Alphanumeric

    80

    D

    GAUTACED

    DEBCDT

    Debit / Credit compensation

    Local menu 1

     

    D

    GAUTACED

    FLGMTC

    Matching flag

    Local menu 1

     

    D

    GAUTACED

    FLGDUD

    Manage open items

    Local menu 1

     

    D

    GAUTACED

    CPALIN

    Double entry

    Short integer

    4

    D

    GAUTACED

    NBRTBL

    No. of tables

    Short integer

    2

    D

    GAUTACED

    LIKTBL

    Linked tables

    Alphanumeric

    12

    D

    GAUTACED

    LIKTBL(1)

    Linked tables

    Alphanumeric

    12

    D

    GAUTACED

    LIKTBL(2)

    Linked tables

    Alphanumeric

    12

    D

    GAUTACED

    LIKTBL(3)

    Linked tables

    Alphanumeric

    12

    D

    GAUTACED

    LIKTBL(4)

    Linked tables

    Alphanumeric

    12

    D

    GAUTACED

    LIKFLD

    Linked fields

    Alphanumeric

    15

    D

    GAUTACED

    LIKFLD(1)

    Linked fields

    Alphanumeric

    15

    D

    GAUTACED

    LIKFLD(2)

    Linked fields

    Alphanumeric

    15

    D

    GAUTACED

    LIKFLD(3)

    Linked fields

    Alphanumeric

    15

    D

    GAUTACED

    LIKFLD(4)

    Linked fields

    Alphanumeric

    15

    D

    GAUTACED

    CCEDEF

    Default dimensions

    Alphanumeric

    10

    D

    GAUTACED

    ACTBEFLIN

    Action

    Alphanumeric

    10

    D

    GAUTACED

    PRGBEFLIN

    Program

    Alphanumeric

    10

    D

    GAUTACED

    ACTAFTLIN

    Action

    Alphanumeric

    10

    D

    GAUTACED

    PRGAFTLIN

    Program

    Alphanumeric

    10

    D

    GAUTACED

    ACTAFTLIK

    Action

    Alphanumeric

    10

    D

    GAUTACED

    PRGAFTLIK

    Program

    Alphanumeric

    10

    F

    GAUTACEF

    /

     

     

     

    F

    GAUTACEF

    COD

    Code

    Alphanumeric

    5

    F

    GAUTACEF

    LINNUM

    Line number

    Short integer

    4

    F

    GAUTACEF

    FLD

    Field

    Alphanumeric

    10

    F

    GAUTACEF

    FORCLC

    Formulas

    Alphanumeric

    250

    V

    GVARPARVAL

    /

     

     

     

    V

    GVARPARVAL

    COD

    Code

    Alphanumeric

    5

    V

    GVARPARVAL

    LINNUM

    Line number

    Short integer

    4

    V

    GVARPARVAL

    FLD

    Field

    Alphanumeric

    10

    V

    GVARPARVAL

    CODVAR

    Variable code

    Alphanumeric

    10

    V

    GVARPARVAL

    CODPAR

    Setup code

    Alphanumeric

    10

    V

    GVARPARVAL

    VALPAR

    Setup value

    Alphanumeric

    80

  • DGIITM - DGI Export - Products

    Flag

    Table

    Field code

    Field description

    Data type

    Length

    ITM

    ITMMASTER

    /

     

     

     

    ITM

    ITMMASTER

    ITMREF

    Product

    Alphanumeric

    20

    ITM

    ITMMASTER

    DES1AXX

    Description 1

    Alphanumeric

    30

    ITM

    ITMMASTER

    DES2AXX

    Description 2

    Alphanumeric

    30

    ITM

    ITMMASTER

    DES3AXX

    Description 3

    Alphanumeric

    30

    ITM

    ITMMASTER

    TCLCOD

    Category

    Alphanumeric

    5

    ITM

    ITMMASTER

    STOMGTCOD

    Stock management

    Local menu 215

     

    ITM

    ITMMASTER

    ITMSTA

    Product status

    Local menu 246

     

    ITM

    ITMMASTER

    ACCCOD

    Accounting code

    Alphanumeric

    10

    ITM

    ITMMASTER

    EECGES

    Subject to Intrastat

    Local menu 1

     

    ITM

    ITMMASTER

    CUSREF

    Customs reference

    Alphanumeric

    12

    ITM

    ITMMASTER

    LIFENDDAT

    End of life

    Date

     

    ITM

    ITMMASTER

    VACITM

    Tax level

    Miscellaneous table 2

     

    ITF

    ITMFACILIT

    /

     

     

     

    ITF

    ITMFACILIT

    STOFCY

    Storage site

    Alphanumeric

    5

    ITF

    ITMFACILIT

    VLTCOD

    Valuation method

    Alphanumeric

    3

  • DGIPIH - DGI Export - Purchase invoices

    Flag

    Table

    Field code

    Field description

    Data type

    Length

    E

    PINVOICE

    /

     

     

     

    E

    PINVOICE

    CPY

    Company

    Alphanumeric

    5

    E

    PINVOICE

    FCY

    Site

    Alphanumeric

    5

    E

    PINVOICE

    PIVTYP

    Invoice type

    Alphanumeric

    5

    E

    PINVOICE

    INVTYP

    Invoice category

    Local menu 645

     

    E

    PINVOICE

    PIHTYP

    Purchase invoice category

    Local menu 533

     

    E

    PINVOICEV

    NUM

    Journal number

    Alphanumeric

    20

    E

    PINVOICE

    STA

    Report

    Local menu 509

     

    E

    PINVOICE

    PAZ

    Payment approval

    Local menu 510

     

    E

    PINVOICE

    ACCDAT

    Accounting date

    Date

     

    E

    PINVOICE

    ORIMOD 5

    Source module

    Local menu 14

     

    E

    PINVOICE

    VATDAT

    Tax date on credit

    Date

     

    E

    PINVOICE

    STRDUDDAT

    Due date basis

    Date

     

    E

    PINVOICE

    FIY

    Fiscal year

    Short integer

    2

    E

    PINVOICE

    PER

    Period

    Short integer

    2

    E

    PINVOICE

    GTE

    Entry type

    Alphanumeric

    5

    E

    PINVOICE

    JOU

    Journal

    Alphanumeric

    5

    E

    PINVOICE

    INVREF

    Internal reference

    Alphanumeric

    30

    E

    PINVOICE

    BPRVCR

    Source document

    Alphanumeric

    20

    E

    PINVOICE

    BPRDAT

    Original date

    Date

     

    E

    PINVOICE

    DES

    Comments

    Alphanumeric

    30

    E

    PINVOICE

    DES(1)

    Comments

    Alphanumeric

    30

    E

    PINVOICE

    DES(2)

    Comments

    Alphanumeric

    30

    E

    PINVOICEV

    BPR

    BP

    Alphanumeric

    15

    E

    PINVOICE

    BPRSAC

    Collective

    Alphanumeric

    4

    E

    PINVOICE

    BPRNAM

    Company name

    Alphanumeric

    35

    E

    PINVOICE

    BPRNAM(1)

    Company name

    Alphanumeric

    35

    E

    PINVOICE

    EECNUM

    EU identification

    Alphanumeric

    20

    E

    PINVOICE

    BPAINV

    Address

    Alphanumeric

    5

    E

    PINVOICE

    BPAADDLIG

    Address line

    Alphanumeric

    40

    E

    PINVOICE

    BPAADDLIG(1)

    Address line

    Alphanumeric

    40

    E

    PINVOICE

    BPAADDLIG(2)

    Address line

    Alphanumeric

    40

    E

    PINVOICE

    POSCOD

    Postal code

    Alphanumeric

    10

    E

    PINVOICE

    CTY

    City

    Alphanumeric

    40

    E

    PINVOICE

    CRY

    Country

    Alphanumeric

    3

    E

    PINVOICE

    SAT

    Report

    Alphanumeric

    35

    E

    PINVOICE

    CRYNAM

    Country name

    Alphanumeric

    40

    E

    PINVOICE

    BPRPAY

    Paying BP

    Alphanumeric

    15

    E

    PINVOICE

    BPYNAM

    Company name

    Alphanumeric

    35

    E

    PINVOICE

    BPYNAM(1)

    Company name

    Alphanumeric

    35

    E

    PINVOICE

    BPAPAY

    Pay-to BP address

    Alphanumeric

    5

    E

    PINVOICE

    BPYADDLIG

    Address line

    Alphanumeric

    40

    E

    PINVOICE

    BPYADDLIG(1)

    Address line

    Alphanumeric

    40

    E

    PINVOICE

    BPYADDLIG(2)

    Address line

    Alphanumeric

    40

    E

    PINVOICE

    BPYPOSCOD

    Postal code

    Alphanumeric

    10

    E

    PINVOICE

    BPYCTY

    City

    Alphanumeric

    40

    E

    PINVOICE

    BPYCRY

    Country

    Alphanumeric

    3

    E

    PINVOICE

    BPYCRYNAM

    Country name

    Alphanumeric

    40

    E

    PINVOICE

    BPYSAT

    Report

    Alphanumeric

    35

    E

    PINVOICEV

    LAN

    Language

    Alphanumeric

    3

    E

    PINVOICE

    CUR

    Currency

    Alphanumeric

    3

    E

    PINVOICE

    CURTYP

    Exchange rate type

    Local menu 202

     

    E

    PINVOICE

    RATDAT

    Rate date

    Date

     

    E

    PINVOICE

    RATDIV

    Dividing rate

    Decimal

    11

    E

    PINVOICE

    RATMLT

    Multiplying rate

    Decimal

    11

    E

    PINVOICE

    LED

    Ledger

    Alphanumeric

    3

    E

    PINVOICE

    CURLED

    Ledger currency

    Alphanumeric

    5

    E

    PINVOICE

    AMTNOT

    Ex-tax amount

    Decimal

    13.2

    E

    PINVOICE

    AMTNOTL

    Amt before tax (company)

    Decimal

    13.2

    E

    PINVOICE

    AMTATI

    Tax incl amount

    Decimal

    13.2

    E

    PINVOICE

    AMTATIL

    Amt incl. tax (company)

    Decimal

    13.2

    E

    PINVOICEV

    TOTLINAMT

    Line total ex-tax

    Decimal

    13.2

    E

    PINVOICEV

    TOTTAXAMT

    Tax total

    Decimal

    13.2

    E

    PINVOICEV

    CLCLINAMT

    Calculated line amt ex-tax

    Decimal

    13.2

    E

    PINVOICE

    VAC

    VAT rule

    Miscellaneous table 1

     

    E

    PINVOICE

    PTE

    Payment term

    Alphanumeric

    15

    E

    PINVOICE

    DEP

    Early discounts/Late charges

    Alphanumeric

    3

    E

    PINVOICE

    DAS2

    DAS2

    Local menu 1

     

    E

    PINVOICEV

    BETCPY

    Inter-company

    Local menu 1

     

    E

    PINVOICE

    EECNUMDEB

    DEB

    Short integer

    4

    E

    PINVOICE

    EECNAT

    Transaction Nature

    Miscellaneous table 6

     

    E

    PINVOICE

    EECSCH

    EU rule

    Miscellaneous table 15

     

    E

    PINVOICE

    EECTRN

    EEC transport method

    Local menu 237

     

    E

    PINVOICE

    EECICT

    Freight terms

    Miscellaneous table 5

     

    E

    PINVOICE

    EECLOC

    EEC transport location

    Local menu 236

     

    E

    PINVOICE

    ICTCTY

    Incoterm city

    Alphanumeric

    40

    E

    PINVOICE

    FFWNUM

    Freight agent

    Alphanumeric

    15

    E

    PINVOICE

    FFWADD

    Forwarding agent address

    Alphanumeric

    5

    E

    PINVOICE

    STRDATSVC

    Service provision start

    Date

     

    E

    PINVOICE

    ENDDATSVC

    Service provision end

    Date

     

    E

    PINVOICE

    LASDATSVC

    Posted cost accruals

    Date

     

    E

    PINVOICE

    DIE

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(1)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(2)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(3)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(4)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(5)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(6)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(7)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(8)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(9)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(10)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(11)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(12)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(13)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(14)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(15)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(16)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(17)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(18)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    DIE(19)

    Dimension code

    Alphanumeric

    3

    E

    PINVOICE

    CCE

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(1)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(2)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(3)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(4)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(5)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(6)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(7)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(8)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(9)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(10)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(11)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(12)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(13)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(14)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(15)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(16)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(17)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(18)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICE

    CCE(19)

    Analytical dimension

    Alphanumeric

    15

    E

    PINVOICEV

    QTYLINNBR

    No. of different qty line

    Short integer

    4

    E

    PINVOICEV

    PRILINNBR

    No. of different price line

    Short integer

    4

    E

    PINVOICEV

    SIHNUM

    Sales invoice no.

    Alphanumeric

    20

    E

    PINVOICEV

    BPCINV

    Invoice customer

    Alphanumeric

    15

    E

    PINVOICE

    CREDAT

    Creation date

    Date

     

    E

    PINVOICE

    CREUSR

    Creation user

    Alphanumeric

    5

    E

    PINVOICE

    UPDDAT

    Update date

    Date

     

    E

    PINVOICE

    UPDUSR

    Update user

    Alphanumeric

    5

    E

    PINVOICE

    *71

    Invoice header text

    Alphanumeric

    100

    E

    PINVOICE

    *72

    Invoice header text

    Alphanumeric

    100

    E

    PINVOICE

    *73

    Invoice header text

    Alphanumeric

    100

    E

    PINVOICE

    *74

    Invoice header text

    Alphanumeric

    100

    E

    PINVOICE

    *75

    Invoice header text

    Alphanumeric

    100

    E

    PINVOICE

    *76

    Invoice header text

    Alphanumeric

    100

    E

    PINVOICE

    *77

    Invoice header text

    Alphanumeric

    100

    E

    PINVOICE

    *78

    Invoice header text

    Alphanumeric

    100

    E

    PINVOICE

    *81

    Invoice footer text

    Alphanumeric

    100

    E

    PINVOICE

    *82

    Invoice footer text

    Alphanumeric

    100

    E

    PINVOICE

    *83

    Invoice footer text

    Alphanumeric

    100

    E

    PINVOICE

    *84

    Invoice footer text

    Alphanumeric

    100

    E

    PINVOICE

    *85

    Invoice footer text

    Alphanumeric

    100

    E

    PINVOICE

    *86

    Invoice footer text

    Alphanumeric

    100

    E

    PINVOICE

    *87

    Invoice footer text

    Alphanumeric

    100

    E

    PINVOICE

    *88

    Invoice footer text

    Alphanumeric

    100

    L

    PINVOICED

    /

     

     

     

    L

    PINVOICED

    PIDLIN

    Line

    Long integer

    *8

    L

    PINVOICED

    TYPORI

    Line source

    Local menu 511

     

    L

    PINVOICED

    NUMORI

    Source number

    Alphanumeric

    20

    L

    PINVOICED

    LINORI

    Source line

    Long integer

    *8

    L

    PINVOICED

    SEQORI

    Original sequence

    Long integer

    *8

    L

    PINVOICED

    FCYLIN

    Line site

    Alphanumeric

    5

    L

    PINVOICED

    ITMREF

    Product

    Alphanumeric

    20

    L

    PINVOICED

    ITMDES

    Description

    Alphanumeric

    30

    L

    PINVOICED

    ITMDES1

    Description

    Alphanumeric

    30

    L

    PINVOICED

    UOM

    Invoicing unit

    Alphanumeric

    3

    L

    PINVOICED

    QTYUOM

    Invoiced qty

    Decimal

    15

    L

    PINVOICED

    PUU

    Purchase unit

    Alphanumeric

    3

    L

    PINVOICED

    QTYPUU

    PUR Quantity

    Decimal

    15

    L

    PINVOICED

    UOMPUUCOE

    UOM/PUR factor

    Decimal

    5.6

    L

    PINVOICED

    ORIQTYPUU

    Source quantity

    Decimal

    15

    L

    PINVOICED

    STU

    Stock unit

    Alphanumeric

    3

    L

    PINVOICED

    QTYSTU

    STK quantity

    Decimal

    15

    L

    PINVOICED

    GROPRI

    Gross price

    Decimal

    10.4

    L

    PINVOICED

    PRIREN

    Price reason

    Short integer

    2

    L

    PINVOICED

    NETPRI

    Net price

    Decimal

    10.4

    L

    PINVOICED

    ORINETPRI

    Source net price

    Decimal

    10.4

    L

    PINVOICED

    CPR

    Cost price

    Decimal

    10.8

    L

    PINVOICED

    CPRCUR

    Currency

    Alphanumeric

    3

    L

    PINVOICED

    DISCRGVAL1

    Value1 early discount/late charges

    Decimal

    10.4

    L

    PINVOICED

    DISCRGREN1

    Reason1 early discount/late charges

    Short integer

    2

    L

    PINVOICED

    DISCRGVAL2

    Value2 early discount/late charges

    Decimal

    10.4

    L

    PINVOICED

    DISCRGREN2

    Reason2 early discount/late charges

    Short integer

    2

    L

    PINVOICED

    DISCRGVAL3

    Value3 early discount/late charges

    Decimal

    10.4

    L

    PINVOICED

    DISCRGREN3

    Reason3 early discount/late charges

    Short integer

    2

    L

    PINVOICED

    DISCRGVAL4

    Value4 early discount/late charges

    Decimal

    10.4

    L

    PINVOICED

    DISCRGREN4

    Reason4 early discount/late charges

    Short integer

    2

    L

    PINVOICED

    DISCRGVAL5

    Value5 early discount/late charges

    Decimal

    10.4

    L

    PINVOICED

    DISCRGREN5

    Reason5 early discount/late charges

    Short integer

    2

    L

    PINVOICED

    DISCRGVAL6

    Value6 early discount/late charges

    Decimal

    10.4

    L

    PINVOICED

    DISCRGREN6

    Reason6 early discount/late charges

    Short integer

    2

    L

    PINVOICED

    DISCRGVAL7

    Value7 early discount/late charges

    Decimal

    10.4

    L

    PINVOICED

    DISCRGREN7

    Reason7 early discount/late charges

    Short integer

    2

    L

    PINVOICED

    DISCRGVAL8

    Value8 early discount/late charges

    Decimal

    10.4

    L

    PINVOICED

    DISCRGREN8

    Reason8 early discount/late charges

    Short integer

    2

    L

    PINVOICED

    DISCRGVAL9

    Value9 early discount/late charges

    Decimal

    10.4

    L

    PINVOICED

    DISCRGREN9

    Reason9 early discount/late charges

    Short integer

    2

    L

    PINVOICED

    DISCRGAMT1

    Early discounts/Late charges1

    Decimal

    13.2

    L

    PINVOICED

    DISCRGAMT2

    Early discounts/Late charges2

    Decimal

    13.2

    L

    PINVOICED

    DISCRGAMT3

    Early discounts/Late charges3

    Decimal

    13.2

    L

    PINVOICED

    DISCRGAMT4

    Early discounts/Late charges4

    Decimal

    13.2

    L

    PINVOICED

    DISCRGAMT5

    Early discounts/Late charges5

    Decimal

    13.2

    L

    PINVOICED

    DISCRGAMT6

    Early discounts/Late charges6

    Decimal

    13.2

    L

    PINVOICED

    DISCRGAMT7

    Early discounts/Late charges7

    Decimal

    13.2

    L

    PINVOICED

    DISCRGAMT8

    Early discounts/Late charges8

    Decimal

    13.2

    L

    PINVOICED

    DISCRGAMT9

    Early discounts/Late charges9

    Decimal

    13.2

    L

    PINVOICED

    AMTNOTLIN

    Ex-tax line amount

    Decimal

    13.2

    L

    PINVOICED

    Tax

    Tax

    Alphanumeric

    5

    L

    PINVOICED

    VAT(1)

    Tax

    Alphanumeric

    5

    L

    PINVOICED

    VAT(2)

    Tax

    Alphanumeric

    5

    L

    PINVOICED

    TAXRCP

    Receipt tax

    Alphanumeric

    5

    L

    PINVOICED

    TAXISS

    Issue tax

    Alphanumeric

    5

    L

    PINVOICED

    TAXOTH1

    Other tax 1

    Alphanumeric

    5

    L

    PINVOICED

    TAXOTH2

    Other tax 2

    Alphanumeric

    5

    L

    PINVOICED

    BASTAXLIN1

    Tax basis 1

    Decimal

    13.2

    L

    PINVOICED

    DISBASLIN1

    Rebate tax basis 1

    Decimal

    13.2

    L

    PINVOICED

    CLCAMT1

    Tax calculation basis 1

    Decimal

    13.2

    L

    PINVOICED

    CLCAMT2

    Tax calculation basis 2

    Decimal

    13.2

    L

    PINVOICED

    CLCAMT3

    Tax calculation basis 3

    Decimal

    13.2

    L

    PINVOICED

    CLCAMT4

    Tax calculation basis 4

    Decimal

    13.2

    L

    PINVOICED

    CLCAMT5

    Tax calculation basis 5

    Decimal

    13.2

    L

    PINVOICED

    CLCAMT6

    Tax calculation basis 6

    Decimal

    13.2

    L

    PINVOICED

    CLCAMT7

    Tax calculation basis 7

    Decimal

    13.2

    L

    PINVOICED

    AMTTAXLIN1

    Tax amount 1

    Decimal

    13.2

    L

    PINVOICED

    AMTTAXLIN2

    Tax amount 2

    Decimal

    13.2

    L

    PINVOICED

    AMTTAXLIN3

    Tax amount 3

    Decimal

    13.2

    L

    PINVOICED

    AMTTAXRCP

    Receipt tax amount

    Decimal

    13.2

    L

    PINVOICED

    AMTTAXISS

    Issue tax amount

    Decimal

    13.2

    L

    PINVOICED

    AMTTAXOTH1

    Other tax amount 1

    Decimal

    13.2

    L

    PINVOICED

    AMTTAXOTH2

    Other tax amount 2

    Decimal

    13.2

    L

    PINVOICED

    DEDTAXLIN1

    Deductible tax 1

    Decimal

    13.2

    L

    PINVOICED

    DEDTAXLIN2

    Deductible tax 2

    Decimal

    13.2

    L

    PINVOICED

    DEDTAXLIN3

    Deductible tax 3

    Decimal

    13.2

    L

    PINVOICED

    DEDTAXRCP

    Deductible tax

    Decimal

    13.2

    L

    PINVOICED

    DEDTAXISS

    Deductible tax

    Decimal

    13.2

    L

    PINVOICED

    DEDTAXOTH1

    Deductible tax

    Decimal

    13.2

    L

    PINVOICED

    DEDTAXOTH2

    Deductible tax

    Decimal

    13.2

    L

    PINVOICED

    AMTATILIN

    Line amount incl. tax

    Decimal

    13.2

    L

    PINVOICED

    POHNUM

    Order no.

    Alphanumeric

    20

    L

    PINVOICED

    POPLIN

    Purchase order line

    Long integer

    *8

    L

    PINVOICED

    POQSEQ

    Sequence number

    Long integer

    *8

    L

    PINVOICED

    PTHNUM

    Receipt no.

    Alphanumeric

    20

    L

    PINVOICED

    PTDLIN

    Line

    Long integer

    *8

    L

    PINVOICED

    PNHNUM

    Return no.

    Alphanumeric

    20

    L

    PINVOICED

    PNDLIN

    Line

    Long integer

    *8

    L

    PINVOICED

    INVNUM

    Invoice number

    Alphanumeric

    20

    L

    PINVOICED

    INVLIN

    Line

    Long integer

    *8

    L

    PINVOICED

    SIDLIN

    Sales invoice line

    Long integer

    *8

    L

    PINVOICED

    CMMNUM

    Commitment no.

    Alphanumeric

    20

    L

    PINVOICED

    FASREF

    Fixed asset ref.

    Alphanumeric

    30

    L

    PINVOICED

    LINTYP

    Line type

    Local menu 570

     

    L

    PINVOICED

    LIKQTYCOE

    Link quantity coeff.

    Decimal

    5.6

    L

    PINVOICED

    LINPURTYP

    Purchase type

    Local menu 646

     

    L

    PINVOICED

    GLU

    Nonfinancial unit

    Alphanumeric

    3

    L

    PINVOICED

    QTYGLU

    Completed quantity

    Decimal

    15

    L

    PINVOICED

    QTYBUDLIN

    Qty to be decommitted

    Decimal

    15

    L

    PINVOICED

    STRDAT

    Start date

    Date

     

    L

    PINVOICED

    ENDDAT

    End date

    Date

     

    L

    PINVOICED

    PERNBR

    Frequency

    Short integer

    4

    L

    PINVOICED

    PERTYP

    Frequency

    Local menu 635

     

    L

    PINVOICED

    BPSNUM

    Supplier

    Alphanumeric

    15

    L

    PINVOICED

    PJT

    Project

    Alphanumeric

    20

    L

    PINVOICED

    RCPDAT

    Receipt date

    Date

     

    L

    PINVOICED

    SATISS

    Issue province

    Alphanumeric

    35

    L

    PINVOICED

    SATRCP

    Receipt province

    Alphanumeric

    35

    L

    PINVOICED

    PRTFLG

    Partial inv.

    Local menu 1

     

    L

    PINVOICED

    LINEECFLG

    Debit line

    Local menu 1

     

    L

    PINVOICED

    EECFLOPHY

    Physical flow

    Local menu 1

     

    L

    PINVOICED

    *91

    Invoice line text

    Alphanumeric

    100

    L

    PINVOICED

    *92

    Invoice line text

    Alphanumeric

    100

    L

    PINVOICED

    *93

    Invoice line text

    Alphanumeric

    100

    L

    PINVOICED

    *94

    Invoice line text

    Alphanumeric

    100

    L

    PINVOICED

    *95

    Invoice line text

    Alphanumeric

    100

    L

    PINVOICED

    *96

    Invoice line text

    Alphanumeric

    100

    L

    PINVOICED

    *97

    Invoice line text

    Alphanumeric

    100

    L

    PINVOICED

    *98

    Invoice line text

    Alphanumeric

    100

    LC

    CPTANALIN

    /

     

     

     

    LC

    CPTANALIN

    LED

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(1)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(2)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(3)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(4)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(5)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(6)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(7)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(8)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(9)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    COA

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(1)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(2)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(3)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(4)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(5)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(6)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(7)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(8)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(9)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    ACC

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(1)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(2)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(3)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(4)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(5)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(6)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(7)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(8)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(9)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    DIE

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(1)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(2)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(3)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(4)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(5)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(6)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(7)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(8)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(9)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(10)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(11)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(12)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(13)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(14)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(15)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(16)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(17)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(18)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(19)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    CCE

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(1)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(2)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(3)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(4)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(5)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(6)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(7)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(8)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(9)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(10)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(11)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(12)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(13)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(14)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(15)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(16)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(17)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(18)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(19)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    GLU

    Nonfinancial unit

    Alphanumeric

    3

    LC

    CPTANALIN

    QTY

    Quantity

    Decimal

    15

    LC

    CPTANALIN

    CUR

    Currency

    Alphanumeric

    3

    LC

    CPTANALIN

    DSP

    Allocation

    Alphanumeric

    10

    F

    PVCRFOOT

    /

     

     

     

    F

    PVCRFOOT

    IND

    Index

    Long integer

    *8

    F

    PVCRFOOT

    INVDTA

    Invoicing element

    Short integer

    3

    F

    PVCRFOOT

    INVDTAAMT

    Entered element amt

    Decimal

    13.2

    F

    PVCRFOOT

    INVORDAMT

    Calculated element amt

    Decimal

    13.2

    F

    PVCRFOOT

    INVLINAMT

    Line element amt

    Decimal

    13.2

    F

    PVCRFOOT

    INVCPLAMT

    Invoiced amt

    Decimal

    13.2

    F

    PVCRFOOT

    RCPCPLAMT

    Received amt

    Decimal

    13.2

    F

    PVCRFOOT

    INVDTAFLG

    Addition flag

    Local menu 1

     

    F

    PVCRFOOT

    INVLINFLG

    Presence on line

    Short integer

    1

    F

    PVCRFOOT

    INVORDFLG

    Presence on order

    Local menu 1

     

    F

    PVCRFOOT

    DISVATFLG

    Rebate on VAT

    Local menu 1

     

    F

    PVCRFOOT

    DEBCDT

    Debit/Credit

    Local menu 626

     

    F

    PVCRFOOT

    INVDTAVAT

    Tax

    Alphanumeric

    5

    F

    PVCRFOOT

    DTADISBAS

    Rebate tax basis

    Decimal

    13.2

    F

    PVCRFOOT

    DTAAMTTAX

    Tax amount

    Decimal

    13.2

    F

    PVCRFOOT

    DTADEDTAX

    Deductible tax

    Decimal

    13.2

    F

    PVCRFOOT

    AMTCOD

    Amount code

    Local menu 269

     

    F

    PVCRFOOT

    AMTCODLIB

    Amount label

    Alphanumeric

    10

    F

    PVCRFOOT

    FORMAT

    Format

    Alphanumeric

    15

    F

    PVCRFOOT

    CLCORD

    Calculation order

    Short integer

    3

    F

    PVCRFOOT

    CLCBAS

    Calculation basis

    Local menu 537

     

    FC

    CPTFOOTLNK

    /

     

     

     

    FC

    CPTFOOTLNK

    LED

    Ledger

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    LED(1)

    Ledger

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    LED(2)

    Ledger

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    LED(3)

    Ledger

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    LED(4)

    Ledger

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    LED(5)

    Ledger

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    LED(6)

    Ledger

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    LED(7)

    Ledger

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    LED(8)

    Ledger

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    LED(9)

    Ledger

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    COA

    Chart code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    COA(1)

    Chart code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    COA(2)

    Chart code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    COA(3)

    Chart code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    COA(4)

    Chart code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    COA(5)

    Chart code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    COA(6)

    Chart code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    COA(7)

    Chart code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    COA(8)

    Chart code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    COA(9)

    Chart code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    ACC

    General accounts

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    ACC(1)

    General accounts

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    ACC(2)

    General accounts

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    ACC(3)

    General accounts

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    ACC(4)

    General accounts

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    ACC(5)

    General accounts

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    ACC(6)

    General accounts

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    ACC(7)

    General accounts

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    ACC(8)

    General accounts

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    ACC(9)

    General accounts

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    DIE

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(1)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(2)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(3)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(4)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(5)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(6)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(7)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(8)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(9)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(10)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(11)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(12)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(13)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(14)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(15)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(16)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(17)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(18)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    DIE(19)

    Dimension code

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    CCE

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(1)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(2)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(3)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(4)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(5)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(6)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(7)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(8)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(9)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(10)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(11)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(12)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(13)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(14)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(15)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(16)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(17)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(18)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    CCE(19)

    Analytical dimension

    Alphanumeric

    15

    FC

    CPTFOOTLNK

    GLU

    Nonfinancial unit

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    QTY

    Quantity

    Decimal

    15

    FC

    CPTFOOTLNK

    CUR

    Currency

    Alphanumeric

    3

    FC

    CPTFOOTLNK

    AMT

    Amount

    Decimal

    13.2

    FC

    CPTFOOTLNK

    DSP

    Allocation

    Alphanumeric

    10

    T

    PVCRVAT

    /

     

     

     

    T

    PVCRVAT

    IND

    Index

    Long integer

    *8

    T

    PVCRVAT

    TAX

    Taxes

    Alphanumeric

    5

    T

    PVCRVAT

    DISBAS

    Rebate tax basis

    Decimal

    13.2

    T

    PVCRVAT

    BASTAX

    Tax basis

    Decimal

    13.2

    T

    PVCRVAT

    AMTTAX

    Tax amount

    Decimal

    13.2

    T

    PVCRVAT

    DEDTAX

    Deductible tax

    Decimal

    13.2

    T

    PVCRVAT

    PURTYP

    Purchase type

    Local menu 646

     

    T

    PVCRVAT

    VATTYP

    Tax type

    Local menu 232

     

    T

    PVCRVAT

    VATRAT

    Rate

    Decimal

    3.6

    T

    PVCRVAT

    DEDRAT

    % Deductible

    Decimal

    3.6

  • DGISIH - DGI Export - Sales invoice

    Flag

    Table

    Field code

    Field description

    Data type

    Length

    V

    SINVOICEV

    /

     

     

     

    V

    SINVOICEV

    CPY

    Company

    Alphanumeric

    5

    V

    SINVOICEV

    SALFCY

    Sales site

    Alphanumeric

    5

    V

    SINVOICEV

    SIVTYP

    Sales invoice type

    Alphanumeric

    5

    V

    SINVOICEV

    INVTYP

    Invoice category

    Local menu 645

     

    V

    SINVOICEV

    NUM

    Invoice no.

    Alphanumeric

    20

    V

    SINVOICEV

    INVSTA

    Report

    Local menu 2261

     

    V

    SINVOICE

    STARPT

    Print

    Local menu 1

     

    V

    SINVOICE

    ACCDAT

    Accounting date

    Date

     

    V

    SINVOICE

    ORIMOD 6

    Source module

    Local menu 14

     

    V

    SINVOICE

    VATDAT

    Tax date on credit

    Date

     

    V

    SINVOICE

    STRDUDDAT

    Due date basis

    Date

     

    V

    SINVOICE

    FIY

    Fiscal year

    Short integer

    2

    V

    SINVOICE

    PER

    Period

    Short integer

    2

    V

    SINVOICE

    GTE

    Entry type

    Alphanumeric

    5

    V

    SINVOICE

    JOU

    Journal

    Alphanumeric

    5

    V

    SINVOICE

    BPRDAT

    Original date

    Date

     

    V

    SINVOICE

    BPRVCR

    Source document

    Alphanumeric

    20

    V

    SINVOICEV

    INVREF

    Reference

    Alphanumeric

    30

    V

    SINVOICE

    DES

    Comments

    Alphanumeric

    30

    V

    SINVOICE

    DES(1)

    Comments

    Alphanumeric

    30

    V

    SINVOICE

    DES(2)

    Comments

    Alphanumeric

    30

    V

    SINVOICEV

    BPCINV

    Invoice customer

    Alphanumeric

    15

    V

    SINVOICE

    BPRSAC

    Collective

    Alphanumeric

    4

    V

    SINVOICEV

    BPINAM

    Bill-to customer name

    Alphanumeric

    35

    V

    SINVOICEV

    BPINAM(1)

    Bill-to customer name

    Alphanumeric

    35

    V

    SINVOICEV

    BPIEECNUM

    EU identification

    Alphanumeric

    20

    V

    SINVOICE

    BPAINV

    Address

    Alphanumeric

    5

    V

    SINVOICE

    BPAADDLIG

    Address line

    Alphanumeric

    40

    V

    SINVOICE

    BPAADDLIG(1)

    Address line

    Alphanumeric

    40

    V

    SINVOICE

    BPAADDLIG(2)

    Address line

    Alphanumeric

    40

    V

    SINVOICE

    POSCOD

    Postal code

    Alphanumeric

    10

    V

    SINVOICE

    CTY

    City

    Alphanumeric

    40

    V

    SINVOICE

    CRY

    Country

    Alphanumeric

    3

    V

    SINVOICE

    CRYNAM

    Country name

    Alphanumeric

    40

    V

    SINVOICE

    SAT

    Report

    Alphanumeric

    35

    V

    SINVOICEV

    CNINAM

    Invoice contact

    Alphanumeric

    15

    V

    SINVOICEV

    BPCORD

    Sold-to customer

    Alphanumeric

    15

    V

    SINVOICEV

    BPAADD

    Delivery address

    Alphanumeric

    5

    V

    SINVOICEV

    BPDADDLIG

    Delivery address

    Alphanumeric

    40

    V

    SINVOICEV

    BPDADDLIG(1)

    Delivery address

    Alphanumeric

    40

    V

    SINVOICEV

    BPDADDLIG(2)

    Delivery address

    Alphanumeric

    40

    V

    SINVOICEV

    BPDPOSCOD

    Delivery postal code

    Alphanumeric

    10

    V

    SINVOICEV

    BPDCTY

    Delivery city

    Alphanumeric

    40

    V

    SINVOICEV

    BPDCRY

    Delivery country

    Alphanumeric

    3

    V

    SINVOICEV

    BPDCRYNAM

    Delivery country name

    Alphanumeric

    40

    V

    SINVOICEV

    BPDSAT

    Delivery status

    Alphanumeric

    35

    V

    SINVOICEV

    CNDNAM

    Delivery contact

    Alphanumeric

    15

    V

    SINVOICE

    BPRPAY

    Paying BP

    Alphanumeric

    15

    V

    SINVOICE

    BPAPAY

    BP address

    Alphanumeric

    5

    V

    SINVOICE

    BPYNAM

    Company name

    Alphanumeric

    35

    V

    SINVOICE

    BPYNAM(1)

    Company name

    Alphanumeric

    35

    V

    SINVOICE

    BPYADDLIG

    Address line

    Alphanumeric

    40

    V

    SINVOICE

    BPYADDLIG(1)

    Address line

    Alphanumeric

    40

    V

    SINVOICE

    BPYADDLIG(2)

    Address line

    Alphanumeric

    40

    V

    SINVOICE

    BPYPOSCOD

    Postal code

    Alphanumeric

    10

    V

    SINVOICE

    BPYCTY

    City

    Alphanumeric

    40

    V

    SINVOICE

    BPYCRY

    Country

    Alphanumeric

    3

    V

    SINVOICE

    BPYCRYNAM

    Country name

    Alphanumeric

    40

    V

    SINVOICE

    BPYSAT

    Report

    Alphanumeric

    35

    V

    SINVOICE

    BPRFCT

    Factor

    Alphanumeric

    15

    V

    SINVOICEV

    BPCGRU

    Group customer

    Alphanumeric

    15

    V

    SINVOICEV

    LAN

    Language

    Alphanumeric

    3

    V

    SINVOICEV

    CUR

    Currency

    Alphanumeric

    3

    V

    SINVOICE

    CURTYP

    Exchange rate type

    Local menu 202

     

    V

    SINVOICE

    RATDAT

    Rate date

    Date

     

    V

    SINVOICE

    RATDIV

    Dividing rate

    Decimal

    11

    V

    SINVOICE

    RATMLT

    Multiplying rate

    Decimal

    11

    V

    SINVOICE

    LED

    Ledger

    Alphanumeric

    3

    V

    SINVOICE

    CURLED

    Ledger currency

    Alphanumeric

    3

    V

    SINVOICE

    AMTNOT

    Ex-tax amount

    Decimal

    13.2

    V

    SINVOICE

    AMTNOTL

    Amt before tax (company)

    Decimal

    13.2

    V

    SINVOICE

    AMTATI

    Tax incl amount

    Decimal

    13.2

    V

    SINVOICE

    AMTATIL

    Amt incl. tax (company)

    Decimal

    13.2

    V

    SINVOICE

    VAC

    VAT rule

    Miscellaneous table 1

     

    V

    SINVOICE

    PTE

    Payment term

    Alphanumeric

    15

    V

    SINVOICE

    DEP

    Early discounts/Late charges

    Alphanumeric

    3

    V

    SINVOICEV

    PJT

    Project

    Alphanumeric

    20

    V

    SINVOICEV

    PRITYP

    Price +tax/-tax

    Local menu 243

     

    V

    SINVOICEV

    PLISTC

    Structure code

    Alphanumeric

    10

    V

    SINVOICEV

    REP

    Sales representative

    Alphanumeric

    15

    V

    SINVOICEV

    REP(1)

    Sales representative

    Alphanumeric

    15

    V

    SINVOICEV

    STOMVTFLG

    Stock movement

    Local menu 1

     

    V

    SINVOICEV

    STOFCY

    Shipping site

    Alphanumeric

    5

    V

    SINVOICEV

    SRGLOCDEF

    Dock location

    Alphanumeric

    10

    V

    SINVOICE

    TRSFAM

    Movement group

    Miscellaneous table 9

     

    V

    SINVOICEV

    TRSCOD

    Movement code

    Miscellaneous table 14

     

    V

    SINVOICEV

    ENTCOD

    Stock auto journal

    Alphanumeric

    5

    V

    SINVOICEV

    SIHORI

    Document origin

    Local menu 413

     

    V

    SINVOICEV

    SIHORINUM

    Source document no.

    Alphanumeric

    20

    V

    SINVOICEV

    SIHORIDAT

    Original date

    Date

     

    V

    SINVOICEV

    CNOREN

    Credit memo reason

    Miscellaneous table 8

     

    V

    SINVOICEV

    BETCPY

    Inter-company

    Local menu 1

     

    V

    SINVOICEV

    BETFCY

    Intersite

    Local menu 1

     

    V

    SINVOICEV

    ORIFCY

    Original site

    Alphanumeric

    5

    V

    SINVOICEV

    PIHNUM

    Purchase invoice no.

    Alphanumeric

    20

    V

    SINVOICE

    EECNUMDEB

    DEB

    Short integer

    4

    V

    SINVOICEV

    EECNAT

    Transaction Nature

    Miscellaneous table 6

     

    V

    SINVOICEV

    EECNATR

    Transaction Nature

    Miscellaneous table 6

     

    V

    SINVOICEV

    EECSCH

    EU rule

    Miscellaneous table 15

     

    V

    SINVOICEV

    EECSCHR

    EU rule

    Miscellaneous table 15

     

    V

    SINVOICEV

    EECLOC

    EEC transport location

    Local menu 236

     

    V

    SINVOICEV

    EECTRN

    EEC transport method

    Local menu 237

     

    V

    SINVOICEV

    EECICT

    Freight terms

    Miscellaneous table 5

     

    V

    SINVOICEV

    ICTCTY

    Incoterm city

    Alphanumeric

    40

    V

    SINVOICEV

    FFWNUM

    Freight agent

    Alphanumeric

    15

    V

    SINVOICEV

    FFWADD

    Forwarding agent address

    Alphanumeric

    5

    V

    SINVOICEV

    INVDTA

    Invoicing element

    Short integer

    3

    V

    SINVOICEV

    INVDTA(1)

    Invoicing element

    Short integer

    3

    V

    SINVOICEV

    INVDTA(2)

    Invoicing element

    Short integer

    3

    V

    SINVOICEV

    INVDTA(3)

    Invoicing element

    Short integer

    3

    V

    SINVOICEV

    INVDTA(4)

    Invoicing element

    Short integer

    3

    V

    SINVOICEV

    INVDTA(5)

    Invoicing element

    Short integer

    3

    V

    SINVOICEV

    INVDTA(6)

    Invoicing element

    Short integer

    3

    V

    SINVOICEV

    INVDTA(7)

    Invoicing element

    Short integer

    3

    V

    SINVOICEV

    INVDTA(8)

    Invoicing element

    Short integer

    3

    V

    SINVOICEV

    INVDTA(9)

    Invoicing element

    Short integer

    3

    V

    SINVOICEV

    INVDTAAMT

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(1)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(2)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(3)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(4)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(5)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(6)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(7)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(8)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(9)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(10)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(11)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(12)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(13)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(14)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(15)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(16)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(17)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(18)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(19)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(20)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(21)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(22)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(23)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(24)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(25)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(26)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(27)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(28)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTAAMT(29)

    Invoicing % or amt

    Decimal

    11.4

    V

    SINVOICEV

    INVDTATYP

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(1)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(2)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(3)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(4)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(5)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(6)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(7)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(8)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(9)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(10)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(11)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(12)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(13)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(14)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(15)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(16)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(17)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(18)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(19)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(20)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(21)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(22)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(23)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(24)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(25)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(26)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(27)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(28)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    INVDTATYP(29)

    Value type

    Local menu 2227

     

    V

    SINVOICEV

    PAM

    Payment method

    Miscellaneous table 3

     

    V

    SINVOICEV

    PAM(1)

    Payment method

    Miscellaneous table 3

     

    V

    SINVOICEV

    PAM(2)

    Payment method

    Miscellaneous table 3

     

    V

    SINVOICEV

    PAM(3)

    Payment method

    Miscellaneous table 3

     

    V

    SINVOICEV

    INSATI

    Prepayment amt +tax

    Decimal

    13.2

    V

    SINVOICEV

    INSATI(1)

    Prepayment amt +tax

    Decimal

    13.2

    V

    SINVOICEV

    INSATI(2)

    Prepayment amt +tax

    Decimal

    13.2

    V

    SINVOICEV

    INSATI(3)

    Prepayment amt +tax

    Decimal

    13.2

    V

    SINVOICEV

    INSORDNUM

    Order no.

    Alphanumeric

    20

    V

    SINVOICEV

    INSORDNUM(1)

    Order no.

    Alphanumeric

    20

    V

    SINVOICEV

    INSORDNUM(2)

    Order no.

    Alphanumeric

    20

    V

    SINVOICEV

    INSORDNUM(3)

    Order no.

    Alphanumeric

    20

    V

    SINVOICEV

    INSLIN

    Line

    Short integer

    3

    V

    SINVOICEV

    INSLIN(1)

    Line

    Short integer

    3

    V

    SINVOICEV

    INSLIN(2)

    Line

    Short integer

    3

    V

    SINVOICEV

    INSLIN(3)

    Line

    Short integer

    3

    V

    SINVOICE

    STRDATSVC

    Service provision start

    Date

     

    V

    SINVOICE

    ENDDATSVC

    Service provision end

    Date

     

    V

    SINVOICE

    LASDATSVC

    Posted revenue accruals

    Date

     

    V

    SINVOICE

    DIE

    Dimension code

    Alphanumeric

    3

    V

    SINVOICE

    DIE(1)

    Dimension code

    Alphanumeric

    3

    V

    SINVOICE

    DIE(2)

    Dimension code

    Alphanumeric

    3

    V

    SINVOICE

    DIE(3)

    Dimension code

    Alphanumeric

    3

    V

    SINVOICE

    DIE(4)

    Dimension code

    Alphanumeric

    3

    V

    SINVOICE

    DIE(5)

    Dimension code

    Alphanumeric

    3

    V

    SINVOICE

    DIE(6)

    Dimension code

    Alphanumeric

    3

    V

    SINVOICE

    DIE(7)

    Dimension code

    Alphanumeric

    3

    V

    SINVOICE

    DIE(8)

    Dimension code

    Alphanumeric

    3

    V

    SINVOICE

    DIE(9)

    Dimension code

    Alphanumeric

    3

    V

    SINVOICE

    CCE(0)

    Analytical dimension

    Alphanumeric

    15

    V

    SINVOICE

    CCE(1)

    Analytical dimension

    Alphanumeric

    15

    V

    SINVOICE

    CCE(2)

    Analytical dimension

    Alphanumeric

    15

    V

    SINVOICE

    CCE(3)

    Analytical dimension

    Alphanumeric

    15

    V

    SINVOICE

    CCE(4)

    Analytical dimension

    Alphanumeric

    15

    V

    SINVOICE

    CCE(5)

    Analytical dimension

    Alphanumeric

    15

    V

    SINVOICE

    CCE(6)

    Analytical dimension

    Alphanumeric

    15

    V

    SINVOICE

    CCE(7)

    Analytical dimension

    Alphanumeric

    15

    V

    SINVOICE

    CCE(8)

    Analytical dimension

    Alphanumeric

    15

    V

    SINVOICE

    CCE(9)

    Analytical dimension

    Alphanumeric

    15

    V

    SINVOICEV

    COPNBR

    No. of invoice copies

    Short integer

    1

    V

    SINVOICEV

    COPNBE

    No. of credit memo copies

    Short integer

    1

    V

    SINVOICE

    FCTVCR

    Voucher

    Alphanumeric

    20

    V

    SINVOICE

    FCTVCRFLG

    Validated voucher

    Short integer

    1

    V

    SINVOICE

    QTCACCNUM

    Voucher acct scr no.

    Long integer

    *8

    V

    SINVOICE

    CREUSR

    Creation user

    Alphanumeric

    5

    V

    SINVOICE

    CREDAT

    Creation date

    Date

     

    V

    SINVOICE

    UPDUSR

    Update user

    Alphanumeric

    5

    V

    SINVOICE

    UPDDAT

    Update date

    Date

     

    V

    SINVOICEV

    *71

    Invoice header text

    Alphanumeric

    100

    V

    SINVOICEV

    *72

    Invoice header text

    Alphanumeric

    100

    V

    SINVOICEV

    *73

    Invoice header text

    Alphanumeric

    100

    V

    SINVOICEV

    *74

    Invoice header text

    Alphanumeric

    100

    V

    SINVOICEV

    *75

    Invoice header text

    Alphanumeric

    100

    V

    SINVOICEV

    *76

    Invoice header text

    Alphanumeric

    100

    V

    SINVOICEV

    *77

    Invoice header text

    Alphanumeric

    100

    V

    SINVOICEV

    *78

    Invoice header text

    Alphanumeric

    100

    V

    SINVOICEV

    *81

    Invoice footer text

    Alphanumeric

    100

    V

    SINVOICEV

    *82

    Invoice footer text

    Alphanumeric

    100

    V

    SINVOICEV

    *83

    Invoice footer text

    Alphanumeric

    100

    V

    SINVOICEV

    *84

    Invoice footer text

    Alphanumeric

    100

    V

    SINVOICEV

    *85

    Invoice footer text

    Alphanumeric

    100

    V

    SINVOICEV

    *86

    Invoice footer text

    Alphanumeric

    100

    V

    SINVOICEV

    *87

    Invoice footer text

    Alphanumeric

    100

    V

    SINVOICEV

    *88

    Invoice footer text

    Alphanumeric

    100

    L

    SINVOICED

    /

     

     

     

    L

    SINVOICED

    SIDLIN

    Invoice line

    Long integer

    *8

    L

    SINVOICED

    ITMREF

    Product

    Alphanumeric

    20

    L

    SINVOICED

    ITMDES

    Description

    Alphanumeric

    30

    L

    SINVOICED

    ITMDES1

    Description

    Alphanumeric

    30

    L

    SINVOICED

    QTY

    Invoiced qty

    Decimal

    15

    L

    SINVOICED

    SAU

    Sales unit

    Alphanumeric

    3

    L

    SINVOICED

    QTYSTU

    STK invoiced qty

    Decimal

    15

    L

    SINVOICED

    STU

    Stock unit

    Alphanumeric

    3

    L

    SINVOICED

    SAUSTUCOE

    SAL-STK coefficient

    Decimal

    5.6

    L

    SINVOICED

    GROPRI

    Gross price

    Decimal

    10.4

    L

    SINVOICED

    PRIREN

    Price reason

    Short integer

    2

    L

    SINVOICED

    NETPRI

    Net price

    Decimal

    10.4

    L

    SINVOICED

    NETPRINOT

    Ex-tax net price

    Decimal

    10.4

    L

    SINVOICED

    NETPRIATI

    Ex-tax net price

    Decimal

    10.4

    L

    SINVOICED

    CPRPRI

    Cost price

    Decimal

    10.4

    L

    SINVOICED

    PFM

    Margin

    Decimal

    13.2

    L

    SINVOICED

    DISCRGVAL1

    Value1 early discount/late charges

    Decimal

    10.4

    L

    SINVOICED

    DISCRGREN1

    Reason1 early discount/late charges

    Short integer

    2

    L

    SINVOICED

    DISCRGVAL2

    Value2 early discount/late charges

    Decimal

    10.4

    L

    SINVOICED

    DISCRGREN2

    Reason2 early discount/late charges

    Short integer

    2

    L

    SINVOICED

    DISCRGVAL3

    Value3 early discount/late charges

    Decimal

    10.4

    L

    SINVOICED

    DISCRGREN3

    Reason3 early discount/late charges

    Short integer

    2

    L

    SINVOICED

    DISCRGVAL4

    Value4 early discount/late charges

    Decimal

    10.4

    L

    SINVOICED

    DISCRGREN4

    Reason4 early discount/late charges

    Short integer

    2

    L

    SINVOICED

    DISCRGVAL5

    Value5 early discount/late charges

    Decimal

    10.4

    L

    SINVOICED

    DISCRGREN5

    Reason5 early discount/late charges

    Short integer

    2

    L

    SINVOICED

    DISCRGVAL6

    Value6 early discount/late charges

    Decimal

    10.4

    L

    SINVOICED

    DISCRGREN6

    Reason6 early discount/late charges

    Short integer

    2

    L

    SINVOICED

    DISCRGVAL7

    Value7 early discount/late charges

    Decimal

    10.4

    L

    SINVOICED

    DISCRGREN7

    Reason7 early discount/late charges

    Short integer

    2

    L

    SINVOICED

    DISCRGVAL8

    Value8 early discount/late charges

    Decimal

    10.4

    L

    SINVOICED

    DISCRGREN8

    Reason8 early discount/late charges

    Short integer

    2

    L

    SINVOICED

    DISCRGVAL9

    Value9 early discount/late charges

    Decimal

    10.4

    L

    SINVOICED

    DISCRGREN9

    Reason9 early discount/late charges

    Short integer

    2

    L

    SINVOICED

    AMTNOTLIN

    Ex-tax amount

    Decimal

    13.2

    L

    SINVOICED

    VACITM(0)

    Tax level

    Miscellaneous table 2

     

    L

    SINVOICED

    VACITM(1)

    Tax level

    Miscellaneous table 2

     

    L

    SINVOICED

    VACITM(2)

    Tax level

    Miscellaneous table 2

     

    L

    SINVOICED

    VAT(0)

    Tax

    Alphanumeric

    5

    L

    SINVOICED

    VAT(1)

    Tax

    Alphanumeric

    5

    L

    SINVOICED

    VAT(2)

    Tax

    Alphanumeric

    5

    L

    SINVOICED

    RATTAXLIN

    Tax rate

    Decimal

    3.2

    L

    SINVOICED

    AMTTAXLIN

    Tax amount

    Decimal

    13.2

    L

    SINVOICED

    AMTTAXLIN(1)

    Tax amount

    Decimal

    13.2

    L

    SINVOICED

    AMTTAXLIN(2)

    Tax amount

    Decimal

    13.2

    L

    SINVOICED

    BASTAXLIN

    Taxable amount

    Decimal

    13.2

    L

    SINVOICED

    CLCAMT1

    Tax calculation basis 1

    Decimal

    13.2

    L

    SINVOICED

    CLCAMT2

    Tax calculation basis 2

    Decimal

    13.2

    L

    SINVOICED

    AMTATILIN

    Tax incl amount

    Decimal

    13.2

    L

    SINVOICED

    DDTANUM

    Invoice line allocation elmt

    Short integer

    3

    L

    SINVOICED

    DDTANUM(1)

    Invoice line allocation elmt

    Short integer

    3

    L

    SINVOICED

    DDTANUM(2)

    Invoice line allocation elmt

    Short integer

    3

    L

    SINVOICED

    DDTANUM(3)

    Invoice line allocation elmt

    Short integer

    3

    L

    SINVOICED

    DDTANUM(4)

    Invoice line allocation elmt

    Short integer

    3

    L

    SINVOICED

    DDTANUM(5)

    Invoice line allocation elmt

    Short integer

    3

    L

    SINVOICED

    DDTANUM(6)

    Invoice line allocation elmt

    Short integer

    3

    L

    SINVOICED

    DDTANUM(7)

    Invoice line allocation elmt

    Short integer

    3

    L

    SINVOICED

    DDTANUM(8)

    Invoice line allocation elmt

    Short integer

    3

    L

    SINVOICED

    DDTANOT

    Invoice line allocation elmt

    Decimal

    13.2

    L

    SINVOICED

    DDTANOT(1)

    Invoice line allocation elmt

    Decimal

    13.2

    L

    SINVOICED

    DDTANOT(2)

    Invoice line allocation elmt

    Decimal

    13.2

    L

    SINVOICED

    DDTANOT(3)

    Invoice line allocation elmt

    Decimal

    13.2

    L

    SINVOICED

    DDTANOT(4)

    Invoice line allocation elmt

    Decimal

    13.2

    L

    SINVOICED

    DDTANOT(5)

    Invoice line allocation elmt

    Decimal

    13.2

    L

    SINVOICED

    DDTANOT(6)

    Invoice line allocation elmt

    Decimal

    13.2

    L

    SINVOICED

    DDTANOT(7)

    Invoice line allocation elmt

    Decimal

    13.2

    L

    SINVOICED

    DDTANOT(8)

    Invoice line allocation elmt

    Decimal

    13.2

    L

    SINVOICED

    REP1

    Sales representative 1

    Alphanumeric

    15

    L

    SINVOICED

    REP2

    Sales representative 2

    Alphanumeric

    15

    L

    SINVOICED

    REPRAT1

    Rate commission 1

    Decimal

    3.2

    L

    SINVOICED

    REPRAT2

    Rate commission 2

    Decimal

    3.2

    L

    SINVOICED

    REPBAS1

    Base commission 1

    Decimal

    13.2

    L

    SINVOICED

    REPBAS2

    Base commission 2

    Decimal

    13.2

    L

    SINVOICED

    REPAMT1

    Amount commission 1

    Decimal

    13.2

    L

    SINVOICED

    REPAMT2

    Amount commission 2

    Decimal

    13.2

    L

    SINVOICED

    REPCOE

    Commission factor

    Decimal

    1.2

    L

    SINVOICED

    SOHNUM

    Order no.

    Alphanumeric

    20

    L

    SINVOICED

    SOPLIN

    Line

    Long integer

    *8

    L

    SINVOICED

    SOQSEQ

    Sequence number

    Long integer

    *8

    L

    SINVOICED

    SDHNUM

    Delivery no.

    Alphanumeric

    20

    L

    SINVOICED

    SDDLIN

    Delivery line

    Long integer

    *8

    L

    SINVOICED

    SRHNUM

    Return no.

    Alphanumeric

    20

    L

    SINVOICED

    SRDLIN

    Return line

    Long integer

    *8

    L

    SINVOICED

    CONNUM

    Service contract no.

    Alphanumeric

    20

    L

    SINVOICED

    SRENUM

    Service request

    Alphanumeric

    20

    L

    SINVOICED

    SGHNUM

    Transfer document

    Alphanumeric

    20

    L

    SINVOICED

    SIHORINUM

    Invoice no.

    Alphanumeric

    20

    L

    SINVOICED

    SIDORILIN

    Invoice line

    Long integer

    *8

    L

    SINVOICED

    PIDLIN

    Purchase invoice line

    Long integer

    *8

    L

    SINVOICED

    LINTYP

    Line type

    Local menu 423

     

    L

    SINVOICED

    FOCFLG

    Free item

    Local menu 439

     

    L

    SINVOICED

    ORILIN

    Free line source

    Long integer

    *8

    L

    SINVOICED

    STRDAT

    Start date

    Date

     

    L

    SINVOICED

    ENDDAT

    End date

    Date

     

    L

    SINVOICED

    PERNBR

    Frequency

    Short integer

    4

    L

    SINVOICED

    PERTYP

    Frequency

    Local menu 635

     

    L

    SINVOICED

    LINEECFLG

    Debit line

    Local menu 1

     

    L

    SINVOICED

    EECFLOPHY

    Physical flow

    Local menu 1

     

    L

    SINVOICED

    *91

    Invoice line text

    Alphanumeric

    100

    L

    SINVOICED

    *92

    Invoice line text

    Alphanumeric

    100

    L

    SINVOICED

    *93

    Invoice line text

    Alphanumeric

    100

    L

    SINVOICED

    *94

    Invoice line text

    Alphanumeric

    100

    L

    SINVOICED

    *95

    Invoice line text

    Alphanumeric

    100

    L

    SINVOICED

    *96

    Invoice line text

    Alphanumeric

    100

    L

    SINVOICED

    *97

    Invoice line text

    Alphanumeric

    100

    L

    SINVOICED

    *98

    Invoice line text

    Alphanumeric

    100

    LC

    CPTANALIN

    /

     

     

     

    LC

    CPTANALIN

    LED

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(1)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(2)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(3)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(4)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(5)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(6)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(7)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(8)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    LED(9)

    Ledger

    Alphanumeric

    3

    LC

    CPTANALIN

    COA

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(1)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(2)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(3)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(4)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(5)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(6)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(7)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(8)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    COA(9)

    Chart code

    Alphanumeric

    3

    LC

    CPTANALIN

    ACC

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(1)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(2)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(3)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(4)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(5)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(6)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(7)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(8)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    ACC(9)

    General accounts

    Alphanumeric

    15

    LC

    CPTANALIN

    DIE(0)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(1)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(2)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(3)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(4)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(5)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(6)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(7)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(8)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(9)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(10)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(11)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(12)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(13)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(14)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(15)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(16)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(17)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(18)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    DIE(19)

    Dimension code

    Alphanumeric

    3

    LC

    CPTANALIN

    CCE(0)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(1)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(2)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(3)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(4)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(5)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(6)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(7)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(8)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(9)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(10)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(11)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(12)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(13)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(14)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(15)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(16)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(17)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(18)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    CCE(19)

    Analytical dimension

    Alphanumeric

    15

    LC

    CPTANALIN

    DSP

    Allocation

    Alphanumeric

    10

    LC

    CPTANALIN

    GLU

    Nonfinancial unit

    Alphanumeric

    3

    LC

    CPTANALIN

    QTY

    Quantity

    Decimal

    15

    LC

    CPTANALIN

    CUR

    Currency

    Alphanumeric

    3

    LC

    CPTANALIN

    AMT

    Amount

    Decimal

    13.2

    A

    SVCRVAT

    /

     

     

     

    A

    SVCRVAT

    Tax

    Tax

    Alphanumeric

    5

    A

    SVCRVAT

    VATTYP

    Tax type

    Local menu 232

     

    A

    SVCRVAT

    BASTAX

    Tax basis

    Decimal

    13.2

    A

    SVCRVAT

    AMTTAX

    Tax amount

    Decimal

    13.2

    A

    SVCRVAT

    VATNET

    Subject basis

    Decimal

    13.2

    A

    SVCRVAT

    VATGRO

    Gross basis

    Decimal

    13.2

    A

    SVCRVAT

    VATRAT

    Rate

    Decimal

    3.6

    A

    SVCRVAT

    VATAMT

    Tax amount

    Decimal

    13.2

    A

    SVCRVAT

    VATSUPAMT

    Extra tax amount

    Decimal

    13.2

    A

    SVCRVAT

    EXEAMTTAX

    Exemption amount

    Decimal

    13.2

    F

    SVCRFOOT

    /

     

     

     

    F

    SVCRFOOT

    DTA

    Invoicing element

    Short integer

    3

    F

    SVCRFOOT

    CLCORD

    Calculation order

    Short integer

    2

    F

    SVCRFOOT

    AMTCOD

    Amount code

    Local menu 269

     

    F

    SVCRFOOT

    DTAAMT

    Invoicing % or amt

    Short integer

    9.2

    F

    SVCRFOOT

    DTATYP

    Value type

    Local menu 243

     

    F

    SVCRFOOT

    DTANOT

    Element ex-tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTANET(0)

    Subject amount elt

    Decimal

    13.2

    F

    SVCRFOOT

    DTANET(1)

    Subject amount elt

    Decimal

    13.2

    F

    SVCRFOOT

    DTANET(2)

    Subject amount elt

    Decimal

    13.2

    F

    SVCRFOOT

    DTANET(3)

    Subject amount elt

    Decimal

    13.2

    F

    SVCRFOOT

    DTANET(4)

    Subject amount elt

    Decimal

    13.2

    F

    SVCRFOOT

    DTANET(5)

    Subject amount elt

    Decimal

    13.2

    F

    SVCRFOOT

    DTANET(6)

    Subject amount elt

    Decimal

    13.2

    F

    SVCRFOOT

    DTANET(7)

    Subject amount elt

    Decimal

    13.2

    F

    SVCRFOOT

    DTANET(8)

    Subject amount elt

    Decimal

    13.2

    F

    SVCRFOOT

    DTANET(9)

    Subject amount elt

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATNOT(0)

    Element ex-tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATNOT(1)

    Element ex-tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATNOT(2)

    Element ex-tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATNOT(3)

    Element ex-tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATNOT(4)

    Element ex-tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATNOT(5)

    Element ex-tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATNOT(6)

    Element ex-tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATNOT(7)

    Element ex-tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATNOT(8)

    Element ex-tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATNOT(9)

    Element ex-tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVAT(0)

    Tax

    Alphanumeric

    5

    F

    SVCRFOOT

    DTAVAT(1)

    Tax

    Alphanumeric

    5

    F

    SVCRFOOT

    DTAVAT(2)

    Tax

    Alphanumeric

    5

    F

    SVCRFOOT

    DTAVAT(3)

    Tax

    Alphanumeric

    5

    F

    SVCRFOOT

    DTAVAT(4)

    Tax

    Alphanumeric

    5

    F

    SVCRFOOT

    DTAVAT(5)

    Tax

    Alphanumeric

    5

    F

    SVCRFOOT

    DTAVAT(6)

    Tax

    Alphanumeric

    5

    F

    SVCRFOOT

    DTAVAT(7)

    Tax

    Alphanumeric

    5

    F

    SVCRFOOT

    DTAVAT(8)

    Tax

    Alphanumeric

    5

    F

    SVCRFOOT

    DTAVAT(9)

    Tax

    Alphanumeric

    5

    F

    SVCRFOOT

    DTAVATRAT(0)

    Rate

    Decimal

    3.2

    F

    SVCRFOOT

    DTAVATRAT(1)

    Rate

    Decimal

    3.2

    F

    SVCRFOOT

    DTAVATRAT(2)

    Rate

    Decimal

    3.2

    F

    SVCRFOOT

    DTAVATRAT(3)

    Rate

    Decimal

    3.2

    F

    SVCRFOOT

    DTAVATRAT(4)

    Rate

    Decimal

    3.2

    F

    SVCRFOOT

    DTAVATRAT(5)

    Rate

    Decimal

    3.2

    F

    SVCRFOOT

    DTAVATRAT(6)

    Rate

    Decimal

    3.2

    F

    SVCRFOOT

    DTAVATRAT(7)

    Rate

    Decimal

    3.2

    F

    SVCRFOOT

    DTAVATRAT(8)

    Rate

    Decimal

    3.2

    F

    SVCRFOOT

    DTAVATRAT(9)

    Rate

    Decimal

    3.2

    F

    SVCRFOOT

    DTAVATAMT(0)

    Tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATAMT(1)

    Tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATAMT(2)

    Tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATAMT(3)

    Tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATAMT(4)

    Tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATAMT(5)

    Tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATAMT(6)

    Tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATAMT(7)

    Tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATAMT(8)

    Tax amount

    Decimal

    13.2

    F

    SVCRFOOT

    DTAVATAMT(9)

    Tax amount

    Decimal

    13.2

  • DGISTJ - DGI Export - Stock movements

    Flag

    Table

    Field code

    Field description

    Data type

    Length

     

    STOJOU

    STOFCY

    Storage site

    Alphanumeric

    5

     

    STOJOU

    IPTDAT

    Allocation date

    Date

     

     

    STOJOU

    TRSTYP

    Transaction type

    Local menu 704

     

     

    STOJOU

    VCRTYP

    Journal type

    Local menu 701

     

     

    STOJOU

    ITMREF

    Product

    Alphanumeric

    20

     

    STOJOU

    QTYSTU

    STK quantity

    Decimal

    15

     

    STOJOU

    STU

    Stock unit

    Alphanumeric

    3

     

    STOJOU

    VARORD

    Order variation

    Decimal

    11.4

     

    STOJOU

    VARVAL

    Movement variance

    Decimal

    11.4

     

    STOJOU

    AMTDEV

    Non absorbed variance

    Decimal

    13.2

     

    STOJOU

    NUMVCR

    Accounting journal

    Alphanumeric

    20

     

    STOJOU

    FINRSPFCY

    Financial site

    Alphanumeric

    5

     

    STOJOU

    UPDCOD

    Update

    Local menu 1

     

     

    STOJOU

    MVTSEQ

    Sequence

    Long integer

    *8

     

    STOJOU

    MVTIND

    Index

    Long integer

    *8

     

    STOJOU

    AMTORD

    Order amount

    Decimal

    11.4

     

    STOJOU

    AMTVAL

    Transaction amount

    Decimal

    11.4

     

    STOJOU

    CREDAT

    Creation date

    Date

     

     

    STOJOU

    CRETIM

    Hour

    Alphanumeric

    5

     

    STOJOU

    CREUSR

    Creation user

    Alphanumeric

    5

     

    STOJOU

    ENTCOD

    Auto journal code

    Alphanumeric

    5

     

    STOJOU

    GTE

    Entry type

    Alphanumeric

    5

     

    STOJOU

    PRIORD

    Order price

    Decimal

    11.4

     

    STOJOU

    PRIREGFLG

    Adjustment flag

    Local menu 1

     

     

    STOJOU

    REGFLG

    Adjusted movement

    Local menu 1

     

     

    STOJOU

    UPDDAT

    Update date

    Date

     

     

    STOJOU

    VCRLIN

    Journal line no

    Long integer

    *8

     

    STOJOU

    VCRLINORI

    Original journal line no

    Long integer

    *8

     

    STOJOU

    VCRLINREG

    Journal line no. adjusted

    Long integer

    *8

     

    STOJOU

    VCRNUMORI

    Original document

    Alphanumeric

    20

     

    STOJOU

    VCRNUMREG

    Journal adjustment

    Alphanumeric

    20

     

    STOJOU

    VCRSEQORI

    Source document sequence no.

    Long integer

    *8

     

    STOJOU

    VCRTYPORI

    Original journal type

    Local menu 701

     

     

    STOJOU

    VCRTYPREG

    Journal adjustm type

    Local menu 701

     

  • DGITFO - DGI Export - Journal formulas

    Flag

    Table

    Field code

    Field description

    Data type

    Length

     

    TABFOR

    FORTYP 7

    Formula type

    Local menu 213

     

     

    TABFOR

    FORCOD

    Formula code

    Alphanumeric

    3

     

    TABFOR

    DES

    Title

    Alphanumeric

    30

     

    TABFOR

    DESSHO

    Short title

    Alphanumeric

    12

     

    TABFOR

    LEG

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(1)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(1)

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(2)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(2)

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(3)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(3)

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(4)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(4)

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(5)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(5)

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(6)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(6)

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(7)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(7)

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(8)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(8)

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(9)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(9)

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(10)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(10)

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(11)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(11)

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(12)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(12)

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(13)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(13)

    Formula

    Alphanumeric

    250

     

    TABFOR

    LEG(14)

    Legislation

    Miscellaneous table 909

     

     

    TABFOR

    FORFOR(14)

    Formula

    Alphanumeric

    250

     

    TABFOR

    CREUSR

    Creation user

    Alphanumeric

    5

     

    TABFOR

    CREDAT

    Creation date

    Date

     

     

    TABFOR

    UPDUSR

    Update user

    Alphanumeric

    5

     

    TABFOR

    UPDDAT

    Update date

    Date

     

  • DGITVT - DGI Export - Taxes

    Flag

    Table

    Field code

    Field description

    Data type

    Length

    H

    TABVAT

    /

     

     

     

    H

    TABVAT

    Tax

    Tax

    Alphanumeric

    5

    H

    TABVAT

    DESAXX

    Description

    Alphanumeric

    30

    H

    TABVAT

    SHOAXX

    Short title

    Alphanumeric

    12

    H

    TABVAT

    LEG

    Legislation

    Miscellaneous table 909

     

    H

    TABVAT

    GRP

    Group

    Alphanumeric

    5

    H

    TABVAT

    VATTYP

    Tax type

    Local menu 232

     

    H

    TABVAT

    VATCHA

    Subject to VAT

    Local menu 1

     

    H

    TABVAT

    VATVAC

    Tax rule

    Miscellaneous table 1

     

    H

    TABVAT

    VATPAY

    Invoice tax due

    Local menu 204

     

    H

    TABVAT

    ACCCOD

    Accounting code

    Alphanumeric

    10

    H

    TABVAT

    TEXAXX

    Mention on invoice

    Alphanumeric

     

    D

    TABRATVAT

    /

     

     

     

    D

    TABRATVAT

    CPY

    Company

    Alphanumeric

    5

    D

    TABRATVAT

    STRDAT

    Validity start date

    Date

     

    D

    TABRATVAT

    VATRAT

    Rate

    Decimal

    3.6

    D

    TABRATVAT

    VATEXEFLG

    Exemption flag

    Local menu 1

     

    D

    TABRATVAT

    DEDRAT

    % Deductible

    Decimal

    3.6

Audit - Audited fields

Table

Audit type and Fields

ADOPAR

Parameter definition table

 

Audit type

Modification

 

 

 

Deletion

 

 

Audited fields

PARAM

Description

 

 

CHAPITRE

Chapter

 

 

GRPPAR

Group

 

 

MODIF

Modifiable Yes/No

 

 

CNDMOD

Condition

ADOVAL

Parameter value table

 

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

PARAM

Description

 

 

CMP

Company

 

 

FCY

Site

 

 

JEU

Set of values

 

 

VALEUR

Value

ADOVALAUS

Table of user parameter values

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

PARAM

Description

 

 

CODUSR

User record

 

 

JEU

Set of values

 

 

VALEUR

Value

ATABLE

Table dictionary

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

CODFIC

Table code

 

 

AUDCRE

Audit creation

 

 

AUDUPD

Audit modification

 

 

AUDDEL

Audit deletion

ATABAUD

Audited fields

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

CODFIC

Table code

 

 

FLD

Field

 

 

NUMLIG

Line no.

 

 

OPE

Operator

 

 

VALEUR

Value

TABVAT

Tax code table 

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

Tax

Tax

 

 

VATVAC

Tax rule

 

 

VATPAY

Invoice tax due

 

 

VATTYP

Tax type

 

 

ACCCOD

Accounting code

TABRATVAT

Tax rate table 

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

Tax

Tax

 

 

CPY

Company

 

 

STRDAT

Validity start date

 

 

VATRAT

Rate

 

 

DEDRAT

% deductible

 

 

VATEXEFLG

Exemption flag

GACCCODE

Accounting codes 

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

GAUTACE

Automatic journals 

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

GAUTACED

Automatic journals (lines) 

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

GAUTACEF

Automatic journals (formulas) 

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

GVARPARVAL

Parameter values 

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

ACODNUM

Document serial number sequences 

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

NIVDEF

Definition level

 

 

NIVRAZ

RTZ level

 

 

CTLCHR

Chronological control

GTYPACCENT

Document types

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

COU

Sequence number

 

 

MANNUM

Manual numbers

 

 

VCRREA

Actual journals

 

 

VCRSIM

Simulation journals

 

 

AUZLED

Authorized ledger

 

 

AUZJOU

Authorizations

 

 

Tax

TVA on debits

 

 

VATPAI

VAT on payment

 

 

ESDTRK

Service provisions

 

 

FLGEXPCRE

Expense creation

TABPIVTYP

Supplier invoice type table

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

PIVTYP

Supplier invoice type

 

 

INVTYP

Invoice category

 

 

COD

Auto purchase journal

 

 

COD2

Auto BP journal

 

 

JOU

Journal

 

 

GTE

Entry type

TABSIVTYP

Customer invoice type table 

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

SIVTYP

Customer invoice type

 

 

INVTYP

Invoice category

 

 

COD

Auto sales journal

 

 

COD2

Auto BP journal

 

 

JOU

Journal

 

 

GTE

Journal type

TYPACE

Types of accounting entries

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

ENAFLG

Active

 

 

ACETYP

Entry type

 

 

DES

Title

 

 

LEG

Legislation

 

 

CPY

Company

 

 

ACEGRP 

Group

 

 

SRCTYP 

Source

 

 

EVTTYP 

Event type

 

 

EVTPLN 

Chart

 

 

TABCPT 

Table to browse

 

 

TRTSPE 

Specific processing

 

 

TABOBJ 

Table

 

 

DPRPLN 

Depreciation plan

 

 

PERCLOFLG 

Closed period

 

 

PERCOUFLG 

Current period

 

 

PEROPEFLG 

Open period

 

 

DIVCRIT 

Criterion

 

 

NBCRIT 

No. of fields

 

 

SORTFLDTAB 

Table for sort field

 

 

SORTFLD 

Sort criteria

 

 

RUPPCEFLG 

Entry

 

 

GAU 

Automatic journal

 

 

GTE 

Entry type

 

 

GTEPRO 

Entry type

 

 

JOU 

Journal

 

 

JOUPRO 

Journal

 

 

ACCDATRUL 

Accounting date

 

 

ACCDATFIX 

Accounting date

 

 

SORTCCE 

Preliminary analytical sorting

 

 

DIRCPTFLG 

Immediate accounting

 

 

DIRCPTTRA 

Log file

 

 

CPTREF 

Accounting ledger

 

 

CREDAT 

Creation date

 

 

CREUSR 

Creation user

 

 

UPDDAT 

Update date

 

 

UPDUSR 

Update user

 

 

TRTINT 

Process

 

 

DBGMOD 

Debugger

TYPACEINT

Types of accounting entries

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

ACETYP 

Entry type

 

 

TMPIND 

Index

 

 

ORITAB 

Source table

 

 

ORIFLD 

Source field

 

 

ORIEXP 

Source expression

 

 

ORICND 

Source condition

 

 

ENALIG 

Active

 

 

NUMLIG 

Line no.

 

 

CREDAT 

Creation date

 

 

CREUSR 

Creation user

 

 

UPDDAT 

Update date

 

 

UPDUSR 

Update user

ITMFACILIT

Products - Sites

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

VLTCOD

Valuation method

TABCOSTMET

Valuation methods

 

Audit type

Creation

 

 

 

Modification

 

 

 

Deletion

 

 

Audited fields

VLTCOD

Valuation method

 

 

TCMDES

Description

 

 

TCMSHO

Short title

 

 

RCPVLTCOD

Receipt valuation

 

 

RCPVLT2

Fall value

 

 

ISSVLTCOD

Issue valuation

 

 

ISSVLT2

Fall value

 

 

VLTINT

Internal mvt valuation

 

 

CUNPOS

Variance>0

 

 

CUNPOS2

Fall value

 

 

CUNNEG

Variance<0

 

 

CUNNEG2

Fall value

 

 

PRIREG

Price adjustment

 

 

PRIREGS

Price adjustment

 

 

NULPRI

Zero price authorized

 

 

AVCPER

Average cost frequency

 

 

PFMCLCBAS

Margin calculation basis

 

 

PFMCLC2

Fall value

 

 

EXPNUM

Export no.