AP
APPaymentProcessorPaymentTran
AP external payment processor payment history
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BillingType | nvarchar(50) | Billing Type | - | |
Description:Billing type | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
DisbursementAcctNbr | nvarchar(20) | Disbursement Account Nbr. | - | |
Description:Funding account amount | ||||
DisbursementAmount | decimal | Disbursement Amount | - | |
Description:Disbursement amount | ||||
DisbursementArriveDate | datetime | Arrives by Date | - | |
Description:Disbursement arrive date | ||||
DisbursementCuryID | nvarchar(3) | Disbursement Currency | - | |
Description:Disbursement currency id | ||||
DisbursementType | nvarchar(25) | Disbursement Method | - | |
Description:Disbursement type | ||||
DocType | nchar(3) | Doc Type | APRegister | |
Description:Document type | ||||
ExternalComment | nvarchar(512) | Response Comment | - | |
Description:External comment | ||||
ExternalPaymentID | nvarchar(50) | Payment ID | - | |
Description:External payment id | ||||
ExternalPaymentProcessorID | nvarchar(10) | Processor ID | APExternalPaymentProcessor | |
Description:External payment processor ID | ||||
ExternalUpdatedDateTime | datetime | Updated At | - | |
Description:External updated date time | ||||
ExternalUserID | nvarchar(50) | User ID | - | |
Description:External user id | ||||
ExternalVendorID | nvarchar(50) | Vendor ID | - | |
Description:External vendor id | ||||
FundingAcctID | nvarchar(50) | Funding Account | - | |
Description:Funding account id | ||||
FundingCuryID | nvarchar(3) | Funding Currency | - | |
Description:Funding account currency id | ||||
ProcessDate | datetime | Process Date | - | |
Description:Process date | ||||
RefNbr | nvarchar(15) | Ref Nbr | APRegister | |
Description:Document reference number | ||||
Status | nvarchar(50) | Processing Status | - | |
Description:External payment status | ||||
TranNbr | int | Tran. Nbr. | - | |
Description:Transaction Number | ||||
TransactionNumber | nvarchar(50) | Transaction Number | - | |
Description:Transaction number | ||||
TransactionState | char(1) | Transaction State | - | |
Description:State | ||||
Tstamp | timestamp | Tstamp | - | |
Description:No description available | ||||