SAP ABAP Table DIAN_A_1001_08 (Cached Data of DIAN Format 1001 version 08)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-DIAN-CO (Package) DIAN: Magnetic Meida for Columbia

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DIAN_A_1001_08	Table Relationship Diagram
Short Description	Cached Data of DIAN Format 1001 version 08

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	RUN_ID	☑	GUID		RAW	16	0	Globally Unique Identifier
3	LINE_ID	☑	GUID		RAW	16	0	Globally Unique Identifier	DIAN_A_EXTRACT
4	COMPANY_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
5	CONCEPT	☐	DIAN_D_CONCEPT		NUMC	4	0	DIAN Concept
6	DOCUMENT_TYPE	☐	DIAN_D_DOC_TYPE	DIAN_D_DOC_TYPE	CHAR	2	0	DIAN Identification Type
7	IDENTIFICATION_NUMBER	☐	DIAN_D_NIT		CHAR	20	0	DIAN Identification number
8	VERIFICATION_DIGIT	☐	DIAN_D_VERIFICATION_DIGIT		NUMC	1	0	DIAN Verification Digit
9	LAST_NAME	☐	DIAN_D_LAST_NAME		CHAR	40	0	Last Name
10	MIDDLE_NAME	☐	DIAN_D_MIDDLE_NAME		CHAR	40	0	DIAN Middle Name
11	NAME	☐	DIAN_D_NAME		CHAR	40	0	DIAN Name
12	OTHER_NAMES	☐	DIAN_D_OTHER_NAMES		CHAR	40	0	Other Name
13	RAZ	☐	DIAN_D_RAZ		CHAR	40	0	Corporate Name
14	DIR	☐	DIAN_D_DIR	DIAN_D_DIR	CHAR	200	0	DIAN Adress
15	DEPARTMENT_CODE	☐	DIAN_D_DEPARTMENT_CODE	DIAN_D_DEPARTMENT_CODE	NUMC	2	0	DIAN Departament Code
16	CITY_CODE	☐	DIAN_D_CITY_CODE		NUMC	3	0	DIAN City Code
17	COUNTRY	☐	DIAN_D_COUNTRY_KEY	NUMC04	NUMC	4	0	DIAN Residence number
18	PAYMENT_DEDUCTIBLE	☐	DIAN_D_PAYMENT_DEDUCTIBLE	DIAN_D_AMOUNT	CURR	22	2	Credit or debit posting deductible
19	PAYMENT_NON_DEDUCTIBLE	☐	DIAN_D_PAYMENT_NON_DEDUCTIBLE	DIAN_D_AMOUNT	CURR	22	2	Credit or debit posting non deductible
20	HIGHER_DEDUCTIBLE_TAX_VALUE	☐	DIAN_D_HIGHER_DEDUCTIBLE_TAX_V	DIAN_D_AMOUNT	CURR	22	2	VAT on purchase deductible
21	HIGHER_NO_DEDUCTIBLE_TAX_VALUE	☐	DIAN_D_HIGHER_NO_DEDUCTIBLE_TV	DIAN_D_AMOUNT	CURR	22	2	VAT on purchase non deductible
22	RETP	☐	DIAN_D_RETP	DIAN_D_AMOUNT	CURR	22	2	Withholding source income actual
23	RETA	☐	DIAN_D_RETA	DIAN_D_AMOUNT	CURR	22	2	Withholding source income assumed
24	COMUN	☐	DIAN_D_COMUN	DIAN_D_AMOUNT	CURR	22	2	VAT Withholding common regime actual
25	SIMP	☐	DIAN_D_SIMP	DIAN_D_AMOUNT	CURR	22	2	VAT Withholding Simple Regime Assumed
26	NDOM	☐	DIAN_D_NDOM	DIAN_D_AMOUNT	CURR	22	2	VAT Withholding Non-domiciled Actual
27	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DIAN_A_1001_08	LINE_ID	DIAN_A_EXTRACT	LINE_ID		1	1

History

Last changed by/on	SAP	20130529
SAP Release Created in	617