dbo.tbl_acc_ap

Description

Properties

Name	Value
Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	False
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	209710
Created	10/31/2019 13:31:43
Last Modified	10/31/2019 13:31:44

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_apar	bigint	8	19	0	True	1 - 1	False	False
seq_no	bigint	8	19	0	False		False	False
DataType	int	4	10	0	False		False	False
INVNO	varchar	50	0	0	False		False	False
INVDATE	date	3	10	0	False		False	False
GL_ACC	varchar	50	0	0	False		False	False
PERIOD	varchar	50	0	0	False		False	False
SAP_SOURCE	varchar	50	0	0	False		False	False
JOURNAL_ID	varchar	50	0	0	False		False	False
JOURNAL_DATE	date	3	10	0	False		False	False
JOURNAL_DESC	varchar	50	0	0	False		False	False
POSTING_KEY	varchar	50	0	0	False		False	False
CURR	varchar	50	0	0	False		False	False
DEBIT	decimal	9	18	2	False		False	False
CREDIT	decimal	9	18	2	False		False	False
BALANCE	decimal	9	18	2	False		False	False
DEBIT_USD	decimal	9	18	2	False		False	False
CREDIT_USD	decimal	9	18	2	False		False	False
BALANCE_USD	decimal	9	18	2	False		False	False
IMPORT_DATE	datetime	8	23	3	False		False	False
EXTRACT_DATE	datetime	8	23	3	False		False	False
id_bc	bigint	8	19	0	False		False	False
bc_type	varchar	50	0	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_acc_apar	id_apar	True

SQL Script

CREATE TABLE dbo.tbl_acc_ap_ar (
  id_apar bigint IDENTITY,
  seq_no bigint NULL,
  DataType int NULL,
  INVNO varchar(50) NULL,
  INVDATE date NULL,
  GL_ACC varchar(50) NULL,
  PERIOD varchar(50) NULL,
  SAP_SOURCE varchar(50) NULL,
  JOURNAL_ID varchar(50) NULL,
  JOURNAL_DATE date NULL,
  JOURNAL_DESC varchar(50) NULL,
  POSTING_KEY varchar(50) NULL,
  CURR varchar(50) NULL,
  DEBIT decimal(18, 2) NULL,
  CREDIT decimal(18, 2) NULL,
  BALANCE decimal(18, 2) NULL,
  DEBIT_USD decimal(18, 2) NULL,
  CREDIT_USD decimal(18, 2) NULL,
  BALANCE_USD decimal(18, 2) NULL,
  IMPORT_DATE datetime NULL,
  EXTRACT_DATE datetime NULL,
  id_bc bigint NULL,
  bc_type varchar(50) NULL,
  CONSTRAINT PK_tbl_acc_apar PRIMARY KEY CLUSTERED (id_apar)
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_acc_ap_ar