CustomerOrderTenderPreAuthorization

Entity Definition

Logical Name : CustomerOrderTenderPreAuthorization
Physical Name : DO_CTOLTM_TND_AZN

A line item component of a Customer placed order, recording any Credit or Debit Card pre-authorization that is performed at the time the order is taken.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerOrderID (FK)(PK) A unique system assigned identifier for the CustomerOrder. ID_ORD Identity integer
CustomerOrderLineItemSequenceNumber (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. IC_OR_LTM LineNumber smallint
TenderAuthorizationID (FK) A unique sequence number for this TenderAuthorization. Required because a particular TenderLineItem may have more than one TenderAuthorization attempt. AI_TND_AZN LineNumber smallint TenderAuthorization(CO_AZN_TND)

Relationships

Parent Entity Verb Phrase Child Entity
TenderAuthorization pre authorizes CustomerOrderTenderPreAuthorization
CustomerOrderLineItem can be a CustomerOrderTenderPreAuthorization

Logical Views containing CustomerOrderTenderPreAuthorization

Logical View
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 07600 - Customer Order - Macro View
Logical 07610 - Customer Order - Maintenance View