View: Incoming Document Processing

RotoID: EC0250
Table: ECIDOC
Protocol: Flat, Ordered revisions, Key auto generate
DLL:ECIDOC

Keys: 4

Title Fields

Peppol Transaction ID SEQUENCE
Vendor/Doc Date/Doc Number IDVENDDATEINVCIDINVC
Vendor/Doc Number IDVENDIDINVC
UUID UUID

Fields: 40

Field Index Type Title Attributes Presentation

SEQUENCE 1 Long Transaction Sequence Number E A K R 
PPLIDVEN 2 String*50 Vendor Peppol ID E A 
PPLIDCUS 3 String*50 Customer Peppol ID E A 
PPLCURID 4 String*20 Document Currency E A 
DTLMSG 5 String*250 Detail Message E A 
TRXTYPETXT 6 Integer Document Type E A  List:4 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
5 = Purchase Order
IDINVC 7 String*22 Document Number E A 
DATEINVC 8 Date Document Date E A 
DATEDUE 9 Date Document Due Date E A 
CNTBTCH 10 BCD*5.0 Document Batch Number E A 
CNTITEM 11 BCD*4.0 Document Entry Number E A 
DOCPRINTED 12 Integer Document Printed E A 
PROCDTTM 13 String*30 Time Processed E A 
PROCESSDT 14 Date Date Processed E A 
DWNLDDT 15 Date Date Downloaded E A 
IMPORTAPP 16 String*10 Import App E A 
IMPORTSTT 17 Integer Import Status E A  List:4 entries
0 = Not Imported
1 = Imported
2 = Failed
3 = Not Applicable
IMPORTMSG 18 String*250 Import Message E A 
IMPORTDT 19 Date Import Date E A 
IMPORTTM 20 String*30 Import Time E A 
IMPORTBY 21 String*30 Import By E A 
SELECTED 22 Integer Selected E A  List:3 entries
0 = No
1 = Yes
2 =
DELETED 23 Integer Deleted/Rejected E A 
HASH 24 String*50 Hash Key E A 
IDVEND 25 String*12 Imported Vendor Number E A  Mask: %-12C
UUID 26 String*150 UUID E A 
DOCTOTAL 27 BCD*10.3 Incoming Document Total E A 
ORDUNIQ 28 BCD*10.0 O/E Order Uniquifier E A 
ORDNUMBER 29 String*22 O/E Order Number E A 
IMPORTTOT 30 BCD*10.3 Imported Document Total E A 
RESCODE 31 String*10 Response Code E A 
RESSTT 32 Integer Response Status E A  List:4 entries
0 = Not Sent
1 = Sent but not confirmed by SESAMi
2 = Sent and confirmed by SESAMi
3 = Not Applicable
RESID 33 String*50 Response ID E A 
RESDT 34 Date Response Date E A 
RESTM 35 String*30 Response Time E A 
REJREASON 36 String*3 Rejection Reason E A 
REJDETAIL 37 String*250 Rejection Details E A 
RESCDDESC 50 String*60 Response Code Description E A 
REJDESC 51 Integer Rejection Description E A  List:14 entries
0 =
1 = NON - No Issue
2 = REF - References incorrect
3 = LEG - Legal information incorrect
4 = REC - Receiver unknown
5 = QUA - Item quality insufficient
6 = DEL - Delivery issues
7 = PRI - Prices incorrect
8 = QTY - Quantity incorrect
9 = ITM - Items incorrect
10 = PAY - Payment terms incorrect
11 = UNR - Not recognized
12 = FIN - Finance incorrect
14 = OTH - Other
SESSIONID 52 String*36 Session ID / GUID E A