V_QUERY_POSTALFIELDS_USA
Includes US postal mailing fields for use in an export definition.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FINDERNUMBER | bigint | yes | Finder number |
| FLD_RECORD_ID | nvarchar(255) | yes | Record ID |
| FLD_PRESORT_ID | bigint | yes | Presort ID |
| FLD_DP_BARCODE | nvarchar(255) | yes | Address barcode |
| FLD_ENDORSEMENT_LINE | nvarchar(255) | yes | Endorsement line |
| FLD_USER_DEFINED_1 | nvarchar(255) | yes | Name |
| FLD_ADDRESS_BLOCK | nvarchar(255) | yes | Address block |
| FLD_BLANK_LINE | nvarchar(255) | yes | Blank line |
| FLD_CASSDATE | nvarchar(255) | yes | CASS Date |
| FLD_ERRORCODE | nvarchar(255) | yes | Error code |
| FLD_IM_BARCODE | nvarchar(255) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/1/2024 11:51:39 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3800.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_POSTALFIELDS_USA AS
select
cast(0 as bigint) as [FINDERNUMBER],
cast('' as nvarchar(255)) as [FLD_RECORD_ID],
cast(0 as bigint) as [FLD_PRESORT_ID],
cast('' as nvarchar(255)) as [FLD_DP_BARCODE],
cast('' as nvarchar(255)) as [FLD_ENDORSEMENT_LINE],
cast('' as nvarchar(255)) as [FLD_USER_DEFINED_1],
cast('' as nvarchar(255)) as [FLD_ADDRESS_BLOCK],
cast('' as nvarchar(255)) as [FLD_BLANK_LINE],
cast('' as nvarchar(255)) as [FLD_CASSDATE],
cast('' as nvarchar(255)) as [FLD_ERRORCODE],
cast('' as nvarchar(255)) as [FLD_IM_BARCODE]