V_QUERY_POSTTOGLPROCESSSTANDARD_5
View used for Peachtree output for the post to GL process
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| GLTRANSACTIONID | uniqueidentifier | GL Transaction ID | |
| REFERENCE | nvarchar(255) | Reference | |
| ROWNUMBER | smallint | yes | Row number |
| NUMBEROFRECORD | smallint | yes | Number of records |
| ACCOUNTSTRING | nvarchar(100) | Account | |
| ACCOUNTNUMBER | nvarchar(100) | Account number | |
| JOURNAL | nvarchar(255) | Journal | |
| AMOUNT | money | Amount | |
| POSTDATE | datetime | yes | PostDate |
| TRANTYPE | varchar(1) | TranType | |
| DEBITCREDIT | varchar(1) | Debit or credit | |
| BATCH | nvarchar(36) | yes | Batch |
| GLACCOUNTID | uniqueidentifier | Account id | |
| POSTEDWHEN | nvarchar(300) | yes | When posted |
| PARENTID | nvarchar(36) | yes | |
| TABLENAMECODE | smallint | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:30:39 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_POSTTOGLPROCESSSTANDARD_5 AS
select
T1.ID as GLTRANSACTIONID,
REFERENCE,
cast('' as smallint) as ROWNUMBER,
cast('' as smallint) as NUMBEROFRECORD,
ACCOUNT as ACCOUNTSTRING,
T2.ACCOUNTNUMBER as ACCOUNTNUMBER,
JOURNAL,
AMOUNT,
POSTDATE,
'R' as TRANTYPE,
case TRANSACTIONTYPECODE when 0 then 'D' else 'C' end as DEBITCREDIT,
cast('' as nvarchar(36)) as BATCH,
T2.ID as GLACCOUNTID,
cast(' - Posted - ' + convert(varchar(8),getdate(),1) as nvarchar(300)) as POSTEDWHEN,
cast('' as nvarchar(36)) as PARENTID,
cast('' as smallint) as TABLENAMECODE
from
dbo.GLTRANSACTION T1
join dbo.GLACCOUNT T2 on T1.GLACCOUNTID = T2.ID