|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | AR_RECEIPT_PAYMENT_A |
| Schema | dbo |
| Row Count | 2966182 |
| Data Size | 231448 KB |
| Index Size | 44280 KB |
| Create Date | 3/4/2015 10:09 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
AUTHORIZATION_BATCH |
varchar(8) |
True |
False |
False |
|||
|
|
AUTHORIZATION_LINE_NO |
int(10, 0) |
True |
False |
False |
|||
|
|
CASHIER_SESSION_KEY |
varchar(19) |
True |
False |
False |
|||
|
|
CHARGE_AUTH |
varchar(6) |
True |
False |
False |
|||
|
|
CHARGE_EXP |
varchar(6) |
True |
False |
False |
|||
|
|
CHARGE_GUID |
varchar(19) |
True |
False |
False |
|||
|
|
CHARGE_NUM |
varchar(16) |
True |
False |
False |
|||
|
|
CHARGE_TYPE |
varchar(2) |
True |
False |
False |
|||
|
|
CHECK_ACCOUNT |
varchar(19) |
True |
False |
False |
|||
|
|
CHECK_NUM |
varchar(16) |
True |
False |
False |
|||
|
|
ISN_AR_RECEIPT_PAYMENT_A |
int(10, 0) |
False |
False |
False |
|||
|
|
PAYMENT_AMOUNT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
PAYMENT_NAME |
varchar(40) |
True |
False |
False |
|||
|
|
PAYMENT_SEQ |
int(10, 0) |
True |
False |
False |
|||
|
|
PAYMENT_TYPE |
varchar(2) |
True |
False |
False |
|||
|
|
RECEIPT_SEQ |
int(10, 0) |
True |
False |
False |
|||
|
|
REF_NBR |
varchar(6) |
True |
False |
False |
|||
|
|
REFUNDED_AMT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
|
|
STDNT_ID |
varchar(9) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_AR_RECEIPT_PAYMENT_A |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.AR_RECEIPT_PAYMENT_A depends on)
| Name | Type |
View |
|
StoredProcedure |
Child Dependencies (objects that depend on dbo.AR_RECEIPT_PAYMENT_A)
| Name | Type |
STOREDPROCEDURE |
|
VIEW |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[AR_RECEIPT_PAYMENT_A] Script Date: 03/09/2017 16:45:01 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[AR_RECEIPT_PAYMENT_A]( [ISN_AR_RECEIPT_PAYMENT_A] [int] NOT NULL, [CASHIER_SESSION_KEY] [varchar](19) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RECEIPT_SEQ] [int] NULL, [PAYMENT_SEQ] [int] NULL, [PAYMENT_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAYMENT_AMOUNT] [numeric](17, 2) NULL, [PAYMENT_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CHECK_ACCOUNT] [varchar](19) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CHECK_NUM] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CHARGE_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CHARGE_NUM] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CHARGE_EXP] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CHARGE_AUTH] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [AUTHORIZATION_BATCH] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [AUTHORIZATION_LINE_NO] [int] NULL, [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [REFUNDED_AMT] [numeric](17, 2) NULL, [REF_NBR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CHARGE_GUID] [varchar](19) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| AUTHORIZATION_BATCH | AUTHORIZATION_LINE_NO | CASHIER_SESSION_KEY | CHARGE_AUTH | CHARGE_EXP | CHARGE_GUID | CHARGE_NUM | CHARGE_TYPE | CHECK_ACCOUNT | CHECK_NUM | ISN_AR_RECEIPT_PAYMENT_A | PAYMENT_AMOUNT | PAYMENT_NAME | PAYMENT_SEQ | PAYMENT_TYPE | RECEIPT_SEQ | REF_NBR | RowUpdatedOn | STDNT_ID |
| 20161213 | 15582 | E088582 20161213001 | 045834 | 201712 | 027EKP57397A26GN369 | 4233 | VS | 2938808 | 20.00 | TWEEDALE/MAXX J | 1 | CR | 10 | 2017-02-06T09:50:44.753-05:00 | M13656053 | |||
| SKEAR 20011119001 | 230619 | 421737 | 30.00 | BAHAMIAN M.O. | 1 | CK | 64 | 2017-02-06T09:47:46.132-05:00 | ||||||||||
| 1 20040113003 | 797212 | 30.00 | 1 | OC | 52 | 2017-02-06T09:48:11.732-05:00 | K11858693 | |||||||||||
| E004483 20100629001 | 160242 | 201310 | 5199 | VS | 1877357 | 15.00 | 1 | CR | 23 | 2017-02-06T09:49:27.595-05:00 | R13596333 | |||||||
| JWHIDDEN20011009001 | 074084 | 200307 | 0157 | VS | 408897 | 99.42 | 1 | CR | 3 | 2017-02-06T09:47:45.29-05:00 | ||||||||
| 20150616 | 17412 | WEB0000520150616001 | 72621B | 201812 | 03BD8RAL664MQKZMVL1 | 3149 | MC | 1104242 | 900.00 | 1 | CR | 195 | 2017-02-06T09:48:32.542-05:00 | Z14788426 | ||||
| E001650 20040816001 | 01 | 881946 | 552.00 | 1 | CK | 100 | 2017-02-06T09:48:17.566-05:00 | J11184306 | ||||||||||
| 5 20060926001 | 1237536 | 607.50 | 1 | OC | 21 | 2017-02-06T09:48:41.949-05:00 | M07952674 | |||||||||||
| 1 20100106009 | 1794638 | 700.00 | 1 | OC | 76 | 2017-02-06T09:49:21.854-05:00 | J13312749 | |||||||||||
| E000925 20100224001 | 1818505 | 20.00 | 1 | CA | 8 | 2017-02-06T09:49:23.508-05:00 | J13467006 |
| Powered by BI Documenter |
