|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | AP_PAYABLE_GL_EXPENSES |
| Schema | dbo |
| Row Count | 1525016 |
| Data Size | 102328 KB |
| Index Size | 25808 KB |
| Create Date | 10/24/2012 9:40 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
BATCH_ID |
varchar(8) |
True |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
GL_ACCT_NO |
varchar(25) |
True |
False |
False |
|||
|
|
GL_AMT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
GL_EXPENSES_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ISN_AP_PAYABLE |
int(10, 0) |
False |
False |
False |
|||
|
|
PAYMENT_TYPE |
varchar(3) |
True |
False |
False |
|||
|
|
PRD_TRN_JN_LINE |
varchar(18) |
True |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_AP_PAYABLE, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.AP_PAYABLE_GL_EXPENSES depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.AP_PAYABLE_GL_EXPENSES)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[AP_PAYABLE_GL_EXPENSES] Script Date: 03/09/2017 16:44:51 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[AP_PAYABLE_GL_EXPENSES]( [ISN_AP_PAYABLE] [int] NOT NULL, [GL_EXPENSES_COUNT] [smallint] NOT NULL, [BATCH_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAYMENT_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [GL_ACCT_NO] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [GL_AMT] [numeric](17, 2) NULL, [PRD_TRN_JN_LINE] [varchar](18) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| BATCH_ID | cnxarraycolumn | GL_ACCT_NO | GL_AMT | GL_EXPENSES_COUNT | ISN_AP_PAYABLE | PAYMENT_TYPE | PRD_TRN_JN_LINE | RowUpdatedOn |
| 01040-1 | 1 | 111806001806001065501 | 59.00 | 2 | 143327 | CHK | 2017-02-06T10:02:10.908-05:00 | |
| 99196-1 | 0 | 111210001210002065501 | 75.99 | 1 | 42363 | CHK | 2017-02-06T10:02:03.716-05:00 | |
| 12257-2 | 0 | 10000000 0022500 | 1291.25 | 1 | 1102671 | CHK | 2017-02-06T10:03:30.281-05:00 | |
| 12166-1 | 0 | 151020005102023064510 | 458.00 | 1 | 1084184 | CHK | 201206AP0142500001 | 2017-02-06T10:03:28.924-05:00 |
| 07142-1 | 0 | 112202002202029565502 | 16.00 | 1 | 336713 | CHK | 200705AP0399300001 | 2017-02-06T10:02:27.85-05:00 |
| 08018-1 | 0 | 10000000 0021101 | 236.77 | 1 | 656263 | CHK | 2017-02-06T10:02:53.84-05:00 | |
| 09162-1 | 0 | 10000000 0022500 | 40.86 | 1 | 779725 | EFT | 2017-02-06T10:03:04.822-05:00 | |
| 14051-2 | 0 | 10000000 0022500 | 750.00 | 1 | 1259331 | EFT | 2017-02-06T10:03:41.186-05:00 | |
| 04195-1 | 0 | 779900637012011075031 | 50.00 | 1 | 389698 | CHK | 200407AP0078600001 | 2017-02-06T10:02:32.109-05:00 |
| 14139-1 | 1 | 324200002420919166503 | 15.63 | 2 | 1272853 | CHK | 201405AP0182800002 | 2017-02-06T10:03:42.169-05:00 |
| Powered by BI Documenter |
