# View: Transaction Posting

RotoID: GP0950
Table:
DLL: GPGLPO

## Compositions: 0

## Keys: 0

## Fields: 49

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
CDEFER | 1 | Boolean | Deferring GL Post? | E A |
CFINDBATCH | 2 | Integer | Append Mode | E A | List: 5 entries
0 | = | New
1 | = | Any
2 | = | Specified
3 | = | Specified / New
4 | = | Specified / Any
CCONSOL | 3 | Integer | Consolidation | E A | List: 4 entries
1 | = | Post All Details
2 | = | Account/Fiscal Period
3 | = | Account/Fiscal Period/Source Code
9 | = | All Fields Matching (except Amounts)
CCONSOLST | 4 | String*2 | Consolidation Transaction Type | E A |
CDETAILPST | 5 | Boolean | Post Summary? | E A |
CRATEGIVEN | 6 | Boolean | Rate Given? | E A |
CBSEQUENCE | 7 | BCD*10.0 | Append-To Sequence | E A |
BSOURCEAPP | 11 | String*2 | Source Application | E A |
BDESC | 12 | String*60 | Batch Description | E A |
BCOMPANYID | 13 | String*8 | Company ID | E A |
BFUNCCUR | 14 | String*3 | Functional Currency | E A |
BFUNCDEC | 15 | Integer | Functional Currency Decimals | E A |
BSWPOSTGL | 16 | Integer | Post Created GL Batch? | E A | List: 2 entries
0 | = | No
1 | = | Yes
HSOURCETYP | 21 | String*2 | Transaction Type | E A |
HPSEQUENCE | 22 | BCD*10.0 | Posting Sequence | E A |
HABATCHNUM | 23 | BCD*5.0 | Batch Number | E A |
HAENTRYNUM | 24 | BCD*4.0 | Entry Number | E A |
HTRANSDATE | 25 | Date | Entry Transaction Date | E A |
HFISCYEAR | 26 | String*4 | Fiscal Year | E A |
HFISCPERIO | 27 | Integer | Fiscal Period | E A |
HDESC | 28 | String*60 | Entry Description | E A |
DACCOUNT | 31 | String*45 | Account Code | E A |
DDESC | 32 | String*60 | Detail Description | E A |
DREFERENCE | 33 | String*60 | Reference | E A |
DTRANSAMT | 34 | BCD*10.3 | Functional Amount | E A |
DTRANSQTY | 35 | BCD*10.3 | Quantity | E A |
DSRCEAMT | 36 | BCD*10.3 | Source Amount | E A |
DZEROPOST | 37 | Boolean | Post If Amounts Zero? | E A |
DSRCECUR | 38 | String*3 | Source Currency | E A |
DSRCEDEC | 39 | Integer | Source Currency Decimals | E A |
DRATETYPE | 40 | String*2 | Rate Type | E A |
DRATEDATE | 41 | Date | Rate Date | E A |
DCONVRATE | 42 | BCD*8.7 | Rate | E A |
DRATESPREA | 43 | BCD*8.7 | Rate Spread | E A |
DRATEMTCHC | 44 | Integer | Rate Matching Code | E A | List: 3 entries
1 | = | Exact
2 | = | Later
3 | = | Earlier
DRATEOPER | 45 | Integer | Rate Operation | E A | List: 2 entries
1 | = | Multiply
2 | = | Divide
HDRILSRCTY | 46 | Integer | Drill Down Type | E A |
HDRILDWNLK | 47 | BCD*10.0 | Drill Down Link Number | E A |
HDRILAPP | 48 | String*2 | Drill Down Application Source | E A |
DTRANSDATE | 49 | Date | Detail Transaction Date | E A |
RBSEQUENCE | 51 | BCD*10.0 | Batch Sequence | A |
OOPTFIELD | 61 | String*12 | Optional Field | E A |
OVALUE | 62 | String*60 | Optional Field Value | E A |
OTYPE | 63 | Integer | Optional Field Type | E A | List: 7 entries
1 | = | Text
100 | = | Amount
6 | = | Number
8 | = | Integer
9 | = | Yes/No
3 | = | Date
4 | = | Time
OLENGTH | 64 | Integer | Optional Field Length | E A |
ODECIMALS | 65 | Integer | Optional Field Decimals | E A |
OALLOWNULL | 66 | Boolean | Optional Field Allow Blank | E A | List: 2 entries
0 | = | No
1 | = | Yes
OVALIDATE | 67 | Boolean | Optional Field Validate | E A | List: 2 entries
0 | = | No
1 | = | Yes
DCOMMENT | 71 | String*250 | Comment | E A |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.