AR
CCProcTran
PX.Objects.AR39 of 39 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
TranNbr | int | Tran. Nbr. | CCProcTran | |
Description:No description available | ||||
Amount | decimal(19, 4) | Tran. Amount | - | |
Description:No description available | ||||
AuthNumber | nvarchar(50) | Proc. Center Auth. Nbr. | - | |
Description:No description available | ||||
CommerceTranNumberNonexistent in DB | nvarchar(50) | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CVVVerificationStatus | char(3) | CVV Verification | - | |
Description:No description available | ||||
DocType | varchar(3) | Doc. Type | - | |
Description:No description available | ||||
EndTime | datetime2 | - | ||
Description:No description available | ||||
ErrorSource | char(3) | Error Source | - | |
Description:No description available | ||||
ErrorText | nvarchar(255) | Error Text | - | |
Description:No description available | ||||
ExpirationDate | datetime2 | - | ||
Description:No description available | ||||
FundHoldExpDateNonexistent in DB | datetime | Expire On (Est.) | - | |
Description:No description available | ||||
Imported | bit | Imported | - | |
Description:No description available | ||||
MaskedCardNumberNonexistent in DB | nvarchar(50) | Card/Account Nbr. | - | |
Description:Masked card number. | ||||
OrigDocType | varchar(3) | Orig. Doc. Type | - | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Orig. Doc. Ref. Nbr. | - | |
Description:No description available | ||||
PCResponse | nvarchar(2048) | - | ||
Description:No description available | ||||
PCResponseCode | nvarchar(10) | - | ||
Description:No description available | ||||
PCResponseReasonCode | nvarchar(20) | - | ||
Description:No description available | ||||
PCResponseReasonText | nvarchar(512) | Proc. Center Response Reason | - | |
Description:No description available | ||||
PCTranApiNumberNonexistent in DB | nvarchar(50) | - | ||
Description:Transaction identifier assigned by an external service other than the processing center. | ||||
PCTranNumber | nvarchar(50) | Proc. Center Tran. Nbr. | - | |
Description:No description available | ||||
PMInstanceID | int | CustomerPaymentMethod | ||
Description:No description available | ||||
ProcessingCenterID | nvarchar(10) | Proc. Center | CCProcessingCenter | |
Description:No description available | ||||
ProcStatus | char(3) | Proc. Status | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Doc. Reference Nbr. | ARPayment | |
Description:No description available | ||||
RefPCTranNumber | nvarchar(50) | Proc. Center Ref. Tran. Nbr. | - | |
Description:No description available | ||||
RefTranNbr | int | Referenced Tran. Nbr. | - | |
Description:No description available | ||||
StartTime | datetime2 | Tran. Time | - | |
Description:No description available | ||||
SubtotalAmount | decimal(19, 4) | Subtotal Amount | - | |
Description:Amount before tax. | ||||
Tax | decimal(19, 4) | Tax | - | |
Description:Total tax amount. | ||||
TerminalIDNonexistent in DB | nvarchar(36) | Terminal ID | - | |
Description:Terminal ID | ||||
TransactionID | int | Ext. Tran. ID | ExternalTransaction | |
Description:No description available | ||||
TranStatus | char(3) | Tran. Status | - | |
Description:No description available | ||||
TranType | char(3) | Tran. Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||