ORDRLSTTLS

Store release level charges.

Column Descriptions:

NameTypeDescription
ORDERS_IDBIGINT NOT NULLOrder ID
ORDRELEASENUMINTEGER NOT NULLThe number of the order release
CHARGETYPECHAR (70) NOT NULLThe type of charge
AMOUNTDECIMAL (20,5)The total of the charges for the order release
LASTCREATEDTIMESTAMPThe date and time when the release was created
FIELD1INTEGERCustomizable.
FIELD2VARCHAR (250)Customizable.
FIELD3VARCHAR (250)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERS_ID+ORDRELEASENUM+CHARGETYPEPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1087ORDERS_ID+ORDRELEASENUMORDRELEASEORDERS_ID+ORDRELEASENUMCascade