V_QUERY_POSTTOGLPROCESSSTANDARD_4
View used for segmented account output for the post to GL process.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| GLTRANSACTIONID | uniqueidentifier | GL Transaction ID | |
| ACCOUNTSTRING | nvarchar(100) | Account | |
| SEG1 | nvarchar(100) | yes | segment 1 |
| SEG2 | nvarchar(100) | yes | segment 2 |
| SEG3 | nvarchar(100) | yes | segment 3 |
| SEG4 | nvarchar(100) | yes | segment 4 |
| SEG5 | nvarchar(100) | yes | segment 5 |
| SEG6 | nvarchar(100) | yes | segment 6 |
| SEG7 | nvarchar(100) | yes | segment 7 |
| SEG8 | nvarchar(100) | yes | segment 8 |
| SEG9 | nvarchar(100) | yes | segment 9 |
| SEG10 | nvarchar(100) | yes | segment 10 |
| SEG11 | nvarchar(100) | yes | segment 11 |
| SEG12 | nvarchar(100) | yes | segment 12 |
| SEG13 | nvarchar(100) | yes | segment 13 |
| SEG14 | nvarchar(100) | yes | segment 14 |
| SEG15 | nvarchar(100) | yes | segment 15 |
| SEG16 | nvarchar(100) | yes | segment 16 |
| SEG17 | nvarchar(100) | yes | segment 17 |
| SEG18 | nvarchar(100) | yes | segment 18 |
| SEG19 | nvarchar(100) | yes | segment 19 |
| SEG20 | nvarchar(100) | yes | segment 20 |
| SEG21 | nvarchar(100) | yes | segment 21 |
| SEG22 | nvarchar(100) | yes | segment 22 |
| SEG23 | nvarchar(100) | yes | segment 23 |
| SEG24 | nvarchar(100) | yes | segment 24 |
| SEG25 | nvarchar(100) | yes | segment 25 |
| SEG26 | nvarchar(100) | yes | segment 26 |
| SEG27 | nvarchar(100) | yes | segment 27 |
| SEG28 | nvarchar(100) | yes | segment 28 |
| SEG29 | nvarchar(100) | yes | segment 29 |
| SEG30 | nvarchar(100) | yes | segment 30 |
| POSTDATE | datetime | yes | PostDate |
| TRANTYPE | varchar(1) | TranType | |
| DEBITCREDIT | varchar(1) | Debit or credit | |
| AMOUNT | money | Amount | |
| JOURNAL | nvarchar(255) | Journal | |
| REFERENCE | nvarchar(255) | Reference | |
| BATCH | nvarchar(36) | yes | Batch |
| GLACCOUNTID | uniqueidentifier | account id | |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
| BASECURRENCY | nvarchar(3) | yes | Base currency |
| BASEEXCHANGERATE | decimal(20, 8) | yes | Base exchange rate |
| TRANSACTIONAMOUNT | money | Transaction amount | |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | Transaction currency ID |
| TRANSACTIONCURRENCY | nvarchar(3) | yes | Transaction currency |
| ORGANIZATIONAMOUNT | money | Organization amount | |
| ORGANIZATIONEXCHANGERATE | decimal(20, 8) | yes | Organization exchange rate |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:36:07 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_POSTTOGLPROCESSSTANDARD_4 AS
select
T1.ID as GLTRANSACTIONID,
ACCOUNT as ACCOUNTSTRING,
cast('' as nvarchar(100)) as SEG1,
cast('' as nvarchar(100)) as SEG2,
cast('' as nvarchar(100)) as SEG3,
cast('' as nvarchar(100)) as SEG4,
cast('' as nvarchar(100)) as SEG5,
cast('' as nvarchar(100)) as SEG6,
cast('' as nvarchar(100)) as SEG7,
cast('' as nvarchar(100)) as SEG8,
cast('' as nvarchar(100)) as SEG9,
cast('' as nvarchar(100)) as SEG10,
cast('' as nvarchar(100)) as SEG11,
cast('' as nvarchar(100)) as SEG12,
cast('' as nvarchar(100)) as SEG13,
cast('' as nvarchar(100)) as SEG14,
cast('' as nvarchar(100)) as SEG15,
cast('' as nvarchar(100)) as SEG16,
cast('' as nvarchar(100)) as SEG17,
cast('' as nvarchar(100)) as SEG18,
cast('' as nvarchar(100)) as SEG19,
cast('' as nvarchar(100)) as SEG20,
cast('' as nvarchar(100)) as SEG21,
cast('' as nvarchar(100)) as SEG22,
cast('' as nvarchar(100)) as SEG23,
cast('' as nvarchar(100)) as SEG24,
cast('' as nvarchar(100)) as SEG25,
cast('' as nvarchar(100)) as SEG26,
cast('' as nvarchar(100)) as SEG27,
cast('' as nvarchar(100)) as SEG28,
cast('' as nvarchar(100)) as SEG29,
cast('' as nvarchar(100)) as SEG30,
POSTDATE,
'R' as TRANTYPE,
case TRANSACTIONTYPECODE when 0 then 'D' else 'C' end as DEBITCREDIT,
AMOUNT,
JOURNAL,
REFERENCE,
cast('' as nvarchar(36)) as BATCH,
--PROJECT,
T2.ID as GLACCOUNTID,
T1.BASECURRENCYID,
dbo.UFN_CURRENCY_GETISO(T1.BASECURRENCYID) as BASECURRENCY,
dbo.UFN_CURRENCYEXCHANGERATE_GETRATE(T1.BASEEXCHANGERATEID) as BASEEXCHANGERATE,
T1.TRANSACTIONAMOUNT,
T1.TRANSACTIONCURRENCYID,
--dbo.UFN_CURRENCY_GETISO(T1.TRANSACTIONCURRENCYID) as TRANSACTIONCURRENCY,
CURRENCY.ISO4217 as TRANSACTIONCURRENCY,
T1.ORGANIZATIONAMOUNT,
--dbo.UFN_CURRENCYEXCHANGERATE_GETRATE(T1.ORGANIZATIONEXCHANGERATEID) as ORGANIZATIONEXCHANGERATE
CURRENCYEXCHANGERATE.RATE as ORGANIZATIONEXCHANGERATE
from
dbo.GLTRANSACTION T1
join dbo.GLACCOUNT T2 on T1.GLACCOUNTID = T2.ID
left join dbo.CURRENCY on T1.TRANSACTIONCURRENCYID = CURRENCY.ID
left join dbo.CURRENCYEXCHANGERATE on T1.ORGANIZATIONEXCHANGERATEID = CURRENCYEXCHANGERATE.ID