Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table SilentPosts
- {
- SilentPostId int not null identity primary key,
- ResponseCode int null, -- 1
- ResponseSubcode int null, -- 1
- ResponseReasonCode int null, -- 1
- ResponseReasonText nvarchar(100) null, -- This transaction has been approved.
- AuthCode , --
- AVSCode , -- P
- TransId , -- 1821199455
- InvoiceNum , -- --
- Description , --
- Amount , -- 9.95
- Method , -- CC
- Type , -- auth_capture
- CustId , -- 1
- FirstName , -- John
- LastName , -- Smith
- Company , --
- Address , --
- City , --
- State , --
- Zip , --
- Country , --
- Phone , --
- Fax , --
- Email , --
- ShipToFirstName , --
- ShipToLastName , --
- ShipToCompany , --
- ShipToAddress , --
- ShipToCity , --
- ShipToState , --
- ShipToZip , --
- ShipToCountry , --
- Tax , -- 0.0000
- Duty , -- 0.0000
- Freight , -- 0.0000
- Tax_exempt , -- FALSE
- PONum , --
- MD5Hash , -- A375D35004547A91EE3B7AFA40B1E727
- CAVVResponse , --
- TestRequest , -- false
- SubscriptionId , -- 365314
- SubscriptionPaynum -- 1
- }
Add Comment
Please, Sign In to add comment