i-effect Manual

ZF2INVBR - Detailed information on the booking reference

Header - detailed information on the posting reference

Column name

In use?

Status

Column definition

Column description

Technical term

Example

BRKEY

x


 VARCHAR(15)

Internal pagination number

Internal invoice number (i-effect column)


BRREF

x


 DECIMAL(5, 0)

Reference ID to the Specified Table

Reference to table

0 = Document header/footer

BRLFD

x


 DECIMAL(5, 0)

Order of the included Products

Order

1

BRTAAII

x

required

VARCHAR(25)

Booking reference

Booking reference of the buyer


BRTAAIIT

x

optional

VARCHAR(25)

Booking reference type

Type of booking reference (code)



Position - Detailed information on the posting reference

Column name

Use?

Status

Column definition

Column description

Technical term

Example

BRKEY

x


 VARCHAR(15)

Internal pagination number

Internal invoice number (i-effect column)


BRREF

x


 DECIMAL(5, 0)

Reference ID to the Specified Table

Reference to table

ZF2INVCPI (PIREF)


BRRLFD

x


 DECIMAL(5, 0)

Order of the included Products

 Order

1

BRTAAII

x

required

VARCHAR(25)

Booking reference

Posting reference of the buyer for the invoice item


BRTAAIIT

x

optional

VARCHAR(25)

Booking reference type

Type of booking reference (code)