Hi guys.
Sorry to reawaken this thread but I'm finally going to start attempting this and have question on column length.
Before I create my E1 table, can someone have a look at the create table SQL for the external table I've pasted below.
In particular, this guy EDIDOCNO_EDOC
Now that's clearly EDOC right? but it's 22 long on the external table as it's length was not defined (like EDIUSER is at 10)
So when I create my table in E1, what alias would I use to mimic EDIDOCNO_EDOC?
Would I use EDOC (which is 9 math numeric) or would I create a new alias that 22 math numeric?
There are a few columns listed below that have not had their length specified.
CREATE TABLE
B2BHEADEROB
(
EDIUSER_EDUS NCHAR(10),
EDIBATCHNO_EDBT NCHAR(15),
EDITRANSNO_EDTN NCHAR(22),
EDIDOCKEYCO_EKCO NCHAR(5) NOT NULL,
EDIDOCNO_EDOC NUMBER NOT NULL,
EDIDOCTYPE_EDCT NCHAR(2) NOT NULL,
EDILINENO_EDLN NUMBER NOT NULL,
EDISUBLINE_LINS NUMBER NOT NULL,
ZTYPENAME_TYTN NCHAR(8),
ZFILENAME_FILE NCHAR(10),
ZENVIRONMENT_ENHV NCHAR(10),
EDIRECORDTYPE_EDTY NCHAR(1),
EDISEQUENCE_EDSQ NUMBER,
EDITRANSSET_EDST NCHAR(6),
EDITRANSFORMAT_EDFT NCHAR(10),
EDITRANSDATE_EDDT NUMBER(6),
EDISENDRCV_EDER NCHAR(1),
EDIDETLINES_EDDL NUMBER,
EDIPROCESSED_EDSP NCHAR(1),
TRADINGPARTNER_PNID NCHAR(15),
TRANSPURPOSE_TPUR NCHAR(2),
TRANSACTION_TNAC NCHAR(2),
TRANSDIRECTION_DRIN NCHAR(1),
HIERARCHYLEVEL_HLVL NUMBER,
HIERARCHYCODE_HL03 NCHAR(2),
REFERENCE1_VR01 NCHAR(25),
REFERENCE2_VR02 NCHAR(25),
REFERENCE3_VR03 NCHAR(25),
ADDRESSNO_AN8 NUMBER,
ORDERDOCKEYCO_KCOO NCHAR(5),
ORDERDOCNO_DOCO NUMBER,
ORDERDOCTYPE_DCTO NCHAR(2),
ORDERDOCSUFFIX_SFXO NCHAR(3),
ORDERDOCLINENO_LNID NUMBER,
BUSINESSUNT_MCU NCHAR(12),
TRANREF_$TRF NCHAR(30),
PALLETNO_$PAL NCHAR(30),
CARTONNO_$CTN NCHAR(30),
DATASTRUCTURE_DSNM NCHAR(6),
BATCHDATEJUL_DICJ NUMBER(6),
BATCHTIME_TME0 NUMBER(6),
BATCHDATE_DATE DATE,
SHIPMENTID_SPID NCHAR(20),
SHIPDATEJUL_SHPJ NUMBER(6),
SHIPRELTIME_RDT NUMBER(6),
SHIPDATE_DATE DATE,
DELCONFIRMDATEJUL_DTCT NUMBER(6),
DELCONFIRMTIME_DLTM NUMBER(6),
DELCONFIRMDATE_DATE DATE,
LOCALRETCODE_LCR1 NCHAR(2),
FORECASTTYPE_TYPF NCHAR(2),
FORESCHEDTYPQUAL_STQC NCHAR(2),
FORESCHEDQTYQUAL_SQQC NCHAR(1),
SETGROUPING_SET NCHAR(3),
BANKREFNAME_RFNM NCHAR(18),
ALLOWEDMAXVALUE_AMAX NCHAR(15),
TYPECRITERIA_TYPC NCHAR(2),
RECORDTYPE_IRT NCHAR(2),
DEFAULTREASON_BDDR NCHAR(2),
ALPHASPEC18_AA18 NCHAR(18),
OPENQTY1_POQ1 NUMBER(15),
OPENQTY1UOM_UM NCHAR(2),
OPENQTY2_POQ2 NUMBER(15),
OPENQTY2UOM_UOM1 NCHAR(2),
INVOICENO_IN NCHAR(12),
VERSION10_VER0 NCHAR(10),
ORIGORDERNO_OORN NCHAR(8),
PONUMBER_$PO1 NCHAR(25),
REFERENCEORDER2_ONR2 NCHAR(10),
ASSISTANCETYPE_AADT NCHAR(2),
NEXTNUMBER_NNBR NUMBER,
TRANSACTIONDATE_XTND NUMBER(6),
TRANSACTIONDATE_DATE DATE,
ALPHASPEC02_AA02 NCHAR(2),
LINEEXTENDCODE_EXTL NCHAR(2),
ITEMSHORT_ITM NUMBER,
ITEMSECOND_LITM NCHAR(25),
ITEMTHIRD_AITM NCHAR(25),
ITEMCUSTOMER_CITM NCHAR(25),
DESCRIPTION00_DL0 NCHAR(30),
DESCRIPTION01_DL01 NCHAR(30),
DESCRIPTION02_DL02 NCHAR(30),
DESCRIPTION03_DL03 NCHAR(30),
DESCRIPTION04_DL04 NCHAR(30),
DESCRIPTION05_DL05 NCHAR(30),
DESCRIPTION06_DL06 NCHAR(30),
DESCRIPTION07_DL07 NCHAR(30),
DESCRIPTION08_DL08 NCHAR(30),
DESCRIPTION09_DL09 NCHAR(30),
DESCRIPTION10_DL10 NCHAR(30),
DESCRIPTION11_DL11 NCHAR(30),
DESCRIPTION12_DL12 NCHAR(30),
DESCRIPTION13_DL13 NCHAR(30),
DESCRIPTION14_DL14 NCHAR(30),
DESCRIPTION15_DL15 NCHAR(30),
DESCRIPTION16_DL16 NCHAR(30),
USERCODE_URCD NCHAR(2),
USERDATE_URDT NUMBER(6),
USERAMOUNT_URAT NUMBER,
USERNUMBER_URAB NUMBER,
USERREFRENCE_URRF NCHAR(15),
ORIGINUSER_TORG NCHAR(10),
AUDITUSER_USER NCHAR(10),
AUDITPROGRAM_PID NCHAR(10),
AUDITVERSION_VERS NCHAR(10),
AUDITJOB_JOBN NCHAR(10),
AUDITDATEJUL_UPMJ NUMBER(6),
AUDITTIME_UPMT NUMBER(6),
AUDITDATE_DATE DATE,
CONSTRAINT B2BHEADEROB_PK PRIMARY KEY (EDIDOCKEYCO_EKCO, EDIDOCNO_EDOC, EDIDOCTYPE_EDCT,
EDILINENO_EDLN, EDISUBLINE_LINS)
)
Thanks
John