SAP ABAP Table DIAN_A_1009_07 (Cached Data of DIAN Format 1009 version 07)
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_1009_07   Table Relationship Diagram
Short Description Cached Data of DIAN Format 1009 version 07    
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 CONCEPT DIAN_D_CONCEPT   NUMC 4   0   DIAN Concept  
5 DOCUMENT_TYPE DIAN_D_DOC_TYPE DIAN_D_DOC_TYPE CHAR 2   0   DIAN Identification Type  
6 IDENTIFICATION_NUMBER DIAN_D_NIT   CHAR 20   0   DIAN Identification number  
7 VERIFICATION_DIGIT DIAN_D_VERIFICATION_DIGIT   NUMC 1   0   DIAN Verification Digit  
8 LAST_NAME DIAN_D_LAST_NAME   CHAR 40   0   Last Name  
9 MIDDLE_NAME DIAN_D_MIDDLE_NAME   CHAR 40   0   DIAN Middle Name  
10 NAME DIAN_D_NAME   CHAR 40   0   DIAN Name  
11 OTHER_NAMES DIAN_D_OTHER_NAMES   CHAR 40   0   Other Name  
12 RAZ DIAN_D_RAZ   CHAR 40   0   Corporate Name  
13 DIR DIAN_D_DIR DIAN_D_DIR CHAR 200   0   DIAN Adress  
14 DEPARTMENT_CODE DIAN_D_DEPARTMENT_CODE DIAN_D_DEPARTMENT_CODE NUMC 2   0   DIAN Departament Code  
15 CITY_CODE DIAN_D_CITY_CODE   NUMC 3   0   DIAN City Code  
16 COUNTRY DIAN_D_COUNTRY_KEY NUMC04 NUMC 4   0   DIAN Residence number  
17 WAERS WAERS WAERS CUKY 5   0   Currency Key *
18 BALANCE DIAN_D_ACCOUNT_PAYABLES DIAN_D_AMOUNT CURR 22   2   Account payables balance  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 DIAN_A_1009_07 LINE_ID DIAN_A_EXTRACT LINE_ID 1 1
History
Last changed by/on SAP  20130529 
SAP Release Created in 617