i-effect Manual

ZF2INVBR - Detailed information on the booking reference

Header

Column name

In use?

Status

Column definition

Column description

Technical term

Example

UDRKEY

x


 VARCHAR(15)

Internal pagination number

Internal invoice number (i-effect column)


UDRREF

x


 DECIMAL(5, 0)

Reference ID to the Specified Table

Reference to table

0 = Document header/footer

UDRLFD

x


 DECIMAL(5, 0)

Order of the included Products

 Order

1

BRTAAII

x

required

VARCHAR(25)

Booking reference

Booking reference of the buyer


BRTAAIIT



VARCHAR(25)

Booking reference type

Type of booking reference (code)



Positions

Column name

In use?

Status

Column definition

Column description

Technical term

Example

UDRKEY

x


 VARCHAR(15)

Internal pagination number

Internal invoice number (i-effect column)


UDRREF

x


 DECIMAL(5, 0)

Reference ID to the Specified Table

Reference to table

ZFINVOICPI (PIREF)


UDRLFD

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



VARCHAR(25)

Booking reference type

Type of booking reference (code)