V_QUERY_POSTTOGLPROCESSSTANDARD_2
View used for Financial Edge 7 output for the post to GL process.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| GLTRANSACTIONID | uniqueidentifier | GL Transaction ID | |
| ACCOUNTSTRING | nvarchar(100) | Account | |
| ACCOUNTNUMBER | nvarchar(100) | Account number | |
| POSTDATE | datetime | yes | PostDate |
| POSTDATE2 | datetime | yes | PostDate |
| TRANTYPE | varchar(1) | TranType | |
| ENCUMBRANCESTATUS | nvarchar(7) | yes | Encumbrance status |
| DEBITCREDIT | varchar(1) | Debit or credit | |
| TYPE | nvarchar(6) | yes | Type |
| AMOUNT | money | Amount | |
| JOURNAL | nvarchar(255) | Journal | |
| REFERENCE | nvarchar(255) | Reference | |
| JOURNALREFERENCE | nvarchar(255) | yes | Journal Reference |
| BATCH | nvarchar(36) | yes | Batch |
| PROJECT | nvarchar(100) | Project | |
| GLACCOUNTID | uniqueidentifier | account id |
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_2 AS
select
T1.ID as GLTRANSACTIONID,
ACCOUNT as ACCOUNTSTRING,
T2.ACCOUNTNUMBER as ACCOUNTNUMBER,
POSTDATE,
cast('' as datetime) as POSTDATE2,
'R' as TRANTYPE,
cast('Regular' as nvarchar(7)) as ENCUMBRANCESTATUS,
case TRANSACTIONTYPECODE when 0 then 'D' else 'C' end as DEBITCREDIT,
cast (case TRANSACTIONTYPECODE when 0 then 'Debit' else 'Credit' end as nvarchar(6)) as TYPE,
AMOUNT,
JOURNAL,
REFERENCE,
cast('' as nvarchar(255)) as JOURNALREFERENCE,
cast('' as nvarchar(36)) as BATCH,
PROJECT,
T2.ID as GLACCOUNTID
from
dbo.GLTRANSACTION T1
join dbo.GLACCOUNT T2 on T1.GLACCOUNTID = T2.ID