TenderAuthorization

Entity Definition

Logical Name : TenderAuthorization
Physical Name : CO_AZN_TND

A request to an external agency to authorize the use of some form of tender to complete a RetailTransaction. Eg: Cheques, Credit & Debit Cards, Gift Certificates or Vouchers.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TenderAuthorizationID (PK) A token identifier for a TenderAuthorization instance. AI_TND_AZN LineNumber smallint
TenderAuthorizationTerminalID (FK) A unique identifier (usually assigned by an external agency that provides TenderAuthorizations) that identifies the terminal performing the TenderAuthorization. ID_AZN_TND_TML Identity integer TenderAuthorizationTerminal(AS_AZN_TND_TML)
AuthorizationDeclineReasonCode (FK) A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query CD_RSN Code varchar(20) Reason(CO_CD_RSN)
TenderAuthorizationProviderID (FK) A unique identifier for the external agency that is providing this TenderAuthorization ID_PRV Identity integer TenderAuthorizationProvider(PA_TND_AZN_PVR)
PreAuthorizationID (FK) A unique sequence number for this TenderAuthorization. Required because a particular TenderLineItem may have more than one TenderAuthorization attempt. ID_AZN_PRE LineNumber smallint TenderAuthorization(CO_AZN_TND)
RequestedAmount The monetary value of the purchases for which an authorization is being requested. MO_RQS MoneyShortRetail decimal(7,2)
RequestedChangeAmount The monetary value cash-back for which an authorization is being requested MO_RQS_CHN MoneyShortRetail decimal(7,2)
AdjudicationCode The adjudication code returned by the external agency to this TenderAuthorizationRequest LU_ADJN_TND_AZN IdentityAlphaNumeric varchar(20)
AuthorizedChangeAmount The monetary value cash-back which was approved in the response to the Authorization request. MO_AZN_CHG MoneyShortRetail decimal(7,2)
ReferenceNumber A unique identifier (which may be assigned by the external authorization agency) for this TenderAuthorization ID_RFC_TND_AZN IdentityAlphaNumeric varchar(20)
AuthorizationDatetime The Date and Time the TenderAuthorization was made. This may be assigned by the external agency that is providing the TenderAuthorization. TS_TM_DT AuditDateTime datetime
HostAuthorizedFlag A flag denoting that this TenderAuthorization was authorized by an external agency. FL_HOS_AZN Flag integer
MissingElectronicSignatureReasonCode A code that defines a general explanation for why a tender authorization signature is missing. CD_RSN_ELSG_MSSG Code4 char(4)
ElectronicSignature A bitmap image of the customer's signature that was captured as part of the TenderAuthorization process. BM_SGN BitMap binary(128)
HostText Narrative text provided by the external agency for inclusion on any reciepts printed as a result of the TenderAuthorization NA_HOS DescriptionShort varchar(255)
CustomerPresentFlag A flag denoting whether the Customer was or was not present during the transaction. This flag would be False for Phone, Web & Mail-Order sales. FL_CT_PRST Flag integer
ForceOnlineFlag Denotes that the Tender was authorized within the retail enterprise (usually because the connection to the host was down) and this TenderAuthorization must be approved by the host when it comes online. FL_FRCOL Flag integer
MerchantNumber A financial institution assigned identifier for ther Retail Enterprise or RetailStore that is conducting theTenderAuthorization. ID_MRCH Name varchar(40)
CardHolderVerificationTypeCode (FK) A code denoting how a CardHolder was verified during a TenderAuthorization. Eg: Signature, PIN, Biometric, Photo. CD_TYP_CTVR Code varchar(20) CardHolderVerificationType(CO_TYP_CTVR)
CardPresentFlag Boolean indicator that tells of the customer had their account card or not when retailer is authorizing their card. FL_CRD_PRSNT Flag integer
ISOCurrencyCode (FK) Currency code designated by ISO to identify national currency CD_CNY_ISO_4217 ISO_4217_CurrencyCode_char(3) char(3) ISO4217-CurrencyType(LU_CNY_ISO_4217)

Relationships

Parent Entity Verb Phrase Child Entity
CardHolderVerificationType classifies TenderAuthorization
TenderAuthorization is pre-authorized by TenderAuthorization
TenderAuthorizationProvider provides TenderAuthorization
TenderAuthorizationTerminal performs TenderAuthorization
ISO4217-CurrencyType is used in TenderAuthorization
Reason classifies TenderAuthorization
TenderAuthorization is reversed by TenderAuthorizationReversal
TenderAuthorization authorizes StoredValueInstrumentActivationAuthorization
TenderAuthorization is pre-authorized by TenderAuthorization
TenderAuthorization pre authorizes CustomerOrderTenderPreAuthorization
TenderAuthorization authorizes TenderLineItemAuthorization

Logical Views containing TenderAuthorization

Logical View
Logical 01420 - Prepaid and Stored Value Payment Instruments
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 02336 - Retail Transaction - Tender - Authorization View
Logical 02339 - Retail Transaction - Tender - Account View
Logical 02390 - Retail Transaction - Stored Value Instrument
Logical 10104 - Enterprise Currency