V_QUERY_POSTTOGLPROCESSSTANDARD_6
View used for Peachtree output for the post to GL process
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| GLTRANSACTIONID | uniqueidentifier | GL Transaction ID | |
| TRNSTYPE | varchar(15) | Transaction type | |
| ROWTYPE | varchar(4) | Row type | |
| ROWNUMBER | smallint | yes | Row number |
| REFERENCE | nvarchar(255) | Reference | |
| 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 |
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_6 AS
select
T1.ID as GLTRANSACTIONID,
'GENERAL JOURNAL' as TRNSTYPE,
'TRNS' as ROWTYPE,
cast('' as smallint) as ROWNUMBER,
REFERENCE,
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
from
dbo.GLTRANSACTION T1
join dbo.GLACCOUNT T2 on T1.GLACCOUNTID = T2.ID