Table SINVOICE @ L.V. Expertise X3

Column

Normal title

Dim.

Type

Length

Menu

Link expression

Cancellation

Act

ACCDAT

Accounting date

 

D

 

 

 

 

 

ACCNUM

Internal number

 

L

8

 

 

 

 

ADRVAL

Address

 

M

4

1

 

 

LTA

AMTATI

Amount + tax

 

MD1

 

 

 

 

 

AMTATIL

Invoice amt. + tax (co)

 

MD1

 

 

 

 

 

AMTNOT

Amount – tax

 

MD1

 

 

 

 

 

AMTNOTL

Amount – tax (co)

 

MD1

 

 

 

 

 

AMTTAX

Tax amount

10

MD1

 

 

 

 

 

AMTTAXUSA

Tax amount

10

MD1

 

 

 

 

KUS

AUUID

Single identifier

 

AUUID

 

 

 

 

 

BASDEP

Early disc/late charge calc basis

 

MD1

 

 

 

 

 

BASTAX

Tax basis

10

MD1

 

 

 

 

 

BELVCS

VCS number

 

VCS

 

 

 

 

KBE

BILVCR

Draft no.

 

VCR

 

 

 

 

 

BPAADDLIG

Address line

3

ADL

 

 

 

 

 

BPAINV

Address

 

ADR

 

 

 

 

 

BPAPAY

Business partner address

 

ADR

 

 

 

 

 

BPR

BP

 

BPR

 

 

[BPR]BPR0=[SIH]BPR

Block

 

BPRDAT

Source date

 

D

 

 

 

 

 

BPRFCT

Factor

 

FCT

 

 

[FCT]FCT0=[SIH]BPRFCT

Block

FCT

BPRNAM

Company name

2

NAM

 

 

 

 

 

BPRPAY

Pay-by

 

BPR

 

 

[BPR]BPR0=[SIH]BPRPAY

Block

 

BPRSAC

Control

 

SAC

 

 

 

 

 

BPRVCR

Source document

 

A

30

 

 

 

 

BPYADDLIG

Address line

3

ADL

 

 

 

 

 

BPYCRY

Country

 

CRY

 

 

[TCY]TCY0=[SIH]BPYCRY

Block

 

BPYCRYNAM

Country name

 

NCY

 

 

 

 

 

BPYCTY

City

 

CTY

 

 

 

 

 

BPYNAM

Company name

2

NAM

 

 

 

 

 

BPYPOSCOD

Postal code

 

POS

 

 

 

 

 

BPYSAT

County

 

SAT

 

 

 

 

 

BVRREFNUM

Reference number

 

A

27

 

 

 

KSW

CAI

CAI number

 

A

10

 

 

 

KAG

CCE

Dimension

 

CCE

 

 

[CCE]CCE0=DIE(indice);CCE(indice)

Block

ANA

CPY

Company

 

CPY

 

 

[CPY]CPY0=[SIH]CPY

Block

 

CREDAT

Date created

 

D

 

 

 

 

 

CREDATTIM

Date time

 

ADATIM

 

 

 

 

 

CREUSR

Creation author

 

A

5

 

 

 

 

CRN

Site tax ID no.

 

CRT

 

 

 

 

 

CRY

Country

 

CRY

 

 

[TCY]TCY0=[SIH]CRY

Block

 

CRYNAM

Country name

 

NCY

 

 

 

 

 

CSHVAT

Cash VAT tax rule

 

M

4

1

 

 

KSP

CTY

City

 

CTY

 

 

 

 

 

CUR

Currency

 

CUR

 

 

[TCU]TCU0=[SIH]CUR

Block

 

CURLED

Ledger currency

10

CUR

 

 

[TCU]TCU0=[SIH]CURLED

Block

 

CURTYP

Rate type

 

M

15

202

 

 

 

DATVLYCAI

CAI validity date

 

D

1

 

 

 

KAG

DCLEECNUM

VAT declaration no.

 

EEC

 

 

 

 

VATTN

DEP

Early discount/Late charge

 

TDA

 

 

[TDA]TDA0=DEP;[V]GSUPCLE

Block

 

DEPRAT

Early discount rate

 

RAT

 

 

 

 

 

DES

Comments

5

DES

 

 

 

 

 

DIE

Dimension type code

 

DIE

 

 

[DIE]DIE0=[SIH]DIE

Block

ANA

DIRINVFLG

Direct inv

 

M

4

1

 

 

 

EECNUMDEB

EU Intrastat

 

C

4

 

 

 

DEB

ENDDATSVC

End service

 

D

 

 

 

 

SVC

EXEAMTTAX

Exemption amount

10

MD1

 

 

 

 

 

EXPNUM

Export number

 

L

8

 

 

 

 

FCTVCR

Receipt

 

VCR

 

 

 

 

FCT

FCTVCRFLG

Validated receipt

 

C

1

 

 

 

FCT

FCY

Site

 

FCY

 

 

[FCY]FCY0=[SIH]FCY

Block

 

FIY

Fiscal year

 

C

2

 

 

 

 

FLD40REN

Field 40 – reason

 

ADI

 

 

[ADI]CODE=8300;FLD40REN

Block

KPO

FLD41REN

Field 41 – reason

 

ADI

 

 

[ADI]CODE=8301;FLD41REN

Block

KPO

GTE

Entry type

 

GTE

 

 

[GTE]GTE0=GTE;[V]GSUPCLE

Block

 

INVNUM

Invoice number

 

VCR

 

 

 

 

 

INVTYP

Invoice category

 

M

15

645

 

 

 

INVTYPSPA

Spanish invoice type

 

M

20

2109

 

 

KSP

ISEXTDOC

External document

 

M

4

1

 

 

DKS

JOU

Journal

 

JOU

 

 

[JOU]JOU0=JOU;[V]GSUPCLE

Block

 

LASDATSVC

Accruals. revn. pstd

 

D

 

 

 

 

SVC

LED

Ledger

10

LED

 

 

[LED]LED0=[SIH]LED

Block

 

METCOR

Method of correction

 

M

20

2069

 

 

KSP

NBRCPY

Number of companies

 

C

2

 

 

 

 

NBRTAX

Number of taxes

 

C

2

 

 

 

 

NUM

Document no.

 

VCR

 

 

 

 

 

ORIDOCNUM

Original document no.

 

A

30

 

 

 

KPO

ORIMOD

Source module

 

M

10

14

 

 

 

PAYBAN

Payment bank

 

BAN

 

 

[BAN]BAN0=[SIH]PAYBAN

Block

KSW

PER

Period

 

C

2

 

 

 

 

PERDEB

Period start date

 

D

 

 

 

 

KPO

PERFIN

To

 

D

 

 

 

 

KPO

PJTH

Project

 

PJT

 

 

[PIM]PIM0=PJTH

Block

PJM

POREXPDCL

Export declaration

 

VCR

 

 

 

 

KPO

POSCOD

Postal code

 

POS

 

 

 

 

 

PTE

Payment term

 

PTE

 

 

[TPT]TPT0=PTE;[V]GCURLEG;1

Block

 

QTCACCNUM

Receipt actng. entry no.

 

L

8

 

 

 

FCT

RATDAT

Rate date

 

D

 

 

 

 

 

RATDIV

Dividing rate

10

RCU

 

 

 

 

 

RATMLT

Multiplying rate

10

RCU

 

 

 

 

 

RCRDAT

Recurrence date

 

D

 

 

 

 

 

RCRNUM

Recurring number

 

VCR

 

 

 

 

 

REVCANSTA

Cancellation status

 

C

1

 

 

 

INVCA

SALPRITYP

Amount type

 

M

10

243

 

 

 

SAT

County

 

SAT

 

 

 

 

 

SINUM

Integrale part no.

 

A

10

 

 

 

SMI

SIVTYP

Invoice type

 

TSV

 

 

[TSV]TSV0=SIVTYP;[V]GSUPCLE

Block

 

SNS

Sign

 

C

2

 

 

 

 

SPADERNUM

DER code

 

A

60

 

 

 

KSP

SSTENTCOD

Entity/Use

 

ADI

 

 

[ADI]CODE=202;SSTENTCOD

Block

LTA

STA

Status

 

M

15

2261

 

 

 

STARPT

Printing

 

M

4

1

 

 

 

STRDATSVC

Start service

 

D

 

 

 

 

SVC

STRDUDDAT

Due date basis

 

D

 

 

 

 

 

TAX

Taxes

10

VAT

 

 

[TVT]TVT0=TAX(indice);[V]GSUPCLE

Block

 

THEAMTTAX

Theor. tax amt

 

DCB

19.8

 

 

 

KAG

TRSFAM

Transaction group

 

ADI

 

 

[ADI]CODE=9;TRSFAM

RTZ

 

UMRNUM

Mandate reference

 

MDT

 

 

[MDT]MDT0=CPY;UMRNUM

Block

SDD

UPDDAT

Change date

 

D

 

 

 

 

 

UPDDATTIM

Date time

 

ADATIM

 

 

 

 

 

UPDUSR

Change author

 

A

5

 

 

 

 

VAC

Tax rule

 

TVB

 

 

[TVB]TVB0=VAC;[V]GSUPCLE

Block

 

VATDAT

Tax date on credit

 

D

 

 

 

 

 

WRHE

Warehouse

 

WRH

 

 

[WRH]WRH0=WRH

Other

WRH