V_QUERY_POSTTOGLPROCESSSTANDARD
View used for standard output for the post to GL process.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| GLTRANSACTIONID | uniqueidentifier | GL Transaction ID | |
| ACCOUNTSTRING | nvarchar(100) | Account | |
| 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 |
| PROJECT | nvarchar(100) | Project | |
| 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:35:32 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_POSTTOGLPROCESSSTANDARD AS
select
GLTRANSACTION.ID as GLTRANSACTIONID,
ACCOUNT as ACCOUNTSTRING,
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,
GLTRANSACTION.BASECURRENCYID,
BASECURRENCY.ISO4217 as BASECURRENCY,
BASEEXCHANGERATE.RATE as BASEEXCHANGERATE,
GLTRANSACTION.TRANSACTIONAMOUNT,
GLTRANSACTION.TRANSACTIONCURRENCYID,
TRANSACTIONCURRENCY.ISO4217 as TRANSACTIONCURRENCY,
GLTRANSACTION.ORGANIZATIONAMOUNT,
ORGANIZATIONEXCHANGERATE.RATE as ORGANIZATIONEXCHANGERATE
from
dbo.GLTRANSACTION
left join dbo.CURRENCY as TRANSACTIONCURRENCY on GLTRANSACTION.TRANSACTIONCURRENCYID = TRANSACTIONCURRENCY.ID
left join dbo.CURRENCY as BASECURRENCY on GLTRANSACTION.BASECURRENCYID = BASECURRENCY.ID
left join dbo.CURRENCYEXCHANGERATE as ORGANIZATIONEXCHANGERATE on GLTRANSACTION.ORGANIZATIONEXCHANGERATEID = ORGANIZATIONEXCHANGERATE.ID
left join dbo.CURRENCYEXCHANGERATE as BASEEXCHANGERATE on GLTRANSACTION.BASEEXCHANGERATEID = BASEEXCHANGERATE.ID