i-effect Manual

ZF2INVUDR - UltimateCustomerOrderReferencedDocument

Header - UltimateCustomerOrderReferencedDocument

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

UDRISSID

x

optional

VARCHAR(50)

OrderReferencedDocument IssuerAssignedID

IssuerAssignedID


UDRLINID



VARCHAR(50)

OrderReferencedDocument Line ID

LineID


UDRDOCDATE

x

optional

DATE '0001-01-01'

OrderReferencedDocument Date

Date


Position - EndgültigeKundenbestellungReferenzdokument

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

UDRISSID

x

optional

VARCHAR(50)

OrderReferencedDocument IssuerAssignedID

IssuerAssignedID


UDRLINID

x

optional

VARCHAR(50)

OrderReferencedDocument Line ID

LineID


UDRDOCDATE

x

optional

DATE '0001-01-01'

OrderReferencedDocument Date

Date