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. |