| PRIMARY KEY |
|
AD_ImpFormat_Row_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL |
| |
|
Created
DATE default: SYSDATE NOT NULL |
| |
|
CreatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Updated
DATE default: SYSDATE NOT NULL |
| |
|
UpdatedBy
NUMBER (10, 0) NOT NULL |
| |
|
AD_ImpFormat_ID
NUMBER (10, 0) NOT NULL |
| AD_ImpFormat |
|
SeqNo
NUMBER (10, 0) NOT NULL |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
AD_Column_ID
NUMBER (10, 0) NOT NULL |
| AD_Column |
|
StartNo
NUMBER (10, 0) |
| |
|
EndNo
NUMBER (10, 0) |
| |
|
DataType
CHAR (1) NOT NULL |
(S)tring, (N)umber, (D)ate
| |
|
DataFormat
NVARCHAR2 (20) |
ddMMyy - Java Date Format String
| |
|
DecimalPoint
CHAR (1) NOT NULL |
Default .
| |
|
DivideBy100
CHAR (1) default: 'N' CHECK ( DivideBy100 in ( 'Y' , 'N' )) NOT NULL |
If number - divide by 100
| |
|
ConstantValue
NVARCHAR2 (60) |
| |
|
Callout
NVARCHAR2 (60) |
| |
|
Script
NVARCHAR2 (2000) |
| |
FOREIGN KEY
ADColumn_ADImpFormatRow: AD_Column_ID => AD_Column
ADImpFormat_ADImpFormatRow: AD_ImpFormat_ID => AD_ImpFormat
|