Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
RECORD_NUMBER |
|
NUMERIC(10, 0) |
YES |
Name: Record Number. Description: Record number of the Visa transaction. |
FIELD_NUMBER |
|
NUMERIC(10, 0) |
YES |
Name: Field Number. Description: The field number of the Visa transaction. |
LOAD_TRANSACTION_CODE |
|
NUMERIC(10, 0) |
YES |
Name: Load Transaction Code. Description: The Load Transaction Code of the Visa Transaction. |
ACCOUNT_NUMBER |
|
VARCHAR(44) |
YES |
Name: Account Number. Description: The Account Number of the Visa Transaction. |
POSTING_DATE |
|
VARCHAR(8) |
YES |
Name: Posting Date. Description: The Posting Date of the Visa Transaction. |
TRANSACTION_REFERENCE_NUMBER |
|
VARCHAR(24) |
YES |
Name: Transaction Reference Number. Description: The Transaction Reference Number of the Visa Transaction |
SEQUENCE_NUMBER |
|
VARCHAR(10) |
YES |
Name: Sequence Number. Description: The Sequence Number of the Visa Transaction. |
LEG_NUMBER |
|
VARCHAR(2) |
YES |
Name: Leg Number. Description: The Leg Number of the Visa Transaction. |
FIELD_NAME |
|
VARCHAR(50) |
YES |
Name: Field Name. Description: The Field Name of the Visa Transaction. |
FIELD_VALUE |
|
VARCHAR(100) |
YES |
Name: Field Value. Description: The Field Value of the Visa Transaction. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMERIC(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |
VISA_ACCOUNT_ID_LAST4_S |
|
VARCHAR(4) |
YES |
Name: Last 4 Digits. Description: Last 4 digits of the Visa Account |