View: Outgoing Document Processing

RotoID: EC0500
Table: ECODOC
Protocol: Flat, Ordered revisions
DLL:ECODOC

Keys: 4

Title Fields

Document IDINVC, IDVEND
Customer/Document IDCUST, IDINVC
Type/Customer/Document TRXTYPETXT, IDCUST, IDINVC
UUID UUID

Fields: 37

Field Index Type Title Attributes Presentation

IDINVC 1 String*22 Document Number E A K R 
IDVEND 2 String*12 Vendor Number E A K R  Mask: %-12C
IDCUST 3 String*12 Customer Number E A  Mask: %-12C
TRXTYPETXT 4 Integer Document Type E A  List:5 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
5 = Purchase Order
SRCEAPPL 5 String*2 Source Application E A 
DATEINVC 6 Date Document Date E A 
PPLACPNT 7 String*30 Peppol Access Point E A 
PPLTRANS 8 String*50 Peppol Transaction ID E A 
PPLSTATUS 9 Integer Peppol Transaction Status E A  List:3 entries
0 = Not Sent
1 = Sent
9 = Error
PPLAPSTT 10 Integer Peppol Transaction AP Status E A  List:7 entries
0 = Not Sent
1 = Sent
9 = Error
11 = Received
12 = Processing
13 = Transmitted
14 = Failed to transmit
HASDTLMSG 11 Integer Has Detail Messages E A  List:2 entries
0 = No
1 = Yes
APSUBDATE 12 Date Access Point Submission Date E A 
APSUBTIME 13 String*30 Access Point Submission Time E A 
SELECTED 14 Integer Selected E A  List:3 entries
0 = No
1 = Yes
2 =
DOCPRINTED 15 Integer Document Printed E A 
UUID 16 String*150 UUID E A 
HASH 17 String*50 Hash Key E A 
DOCTOTAL 18 BCD*10.3 Document Total E A 
ENTEREDBY 19 String*8 Entered By E A 
LASTAUDSEQ 20 Long Last Audit Sequence Number E A 
CURID 21 String*3 Sage 300 Currency Code E A  Mask: %-3N
RESCODE 22 String*10 Response Code E A 
RESDT 23 Date Response Date E A 
RESTM 24 String*30 Response Time E A 
HASRESMSG 25 Integer Has Response Messages E A  List:2 entries
0 = No
1 = Yes
C5PROGRESS 26 String*10 C5 Progress E A 
C5CORRELID 27 String*36 C5 Correlation ID E A 
C5TRANSMID 28 String*36 C5 Transmission ID E A 
C5ACKNOWID 29 String*50 C5 Acknowledgement ID E A 
C5SUBDATE 30 Date C5 Submission Date E A 
C5SUBTIME 31 String*30 C5 Submission Time E A 
RESCDDESC 50 String*60 Response Code Description E A 
SESSIONID 51 String*36 Session ID / GUID E A 
TOC4 52 Boolean Sent to C4? E A 
TOC5 53 Boolean Sent to C5? E A 
PEPC5PUR 54 Boolean Peppol C5 Purchase? E A 
AGD 55 Integer Accountant-General's Department? E A  List:2 entries
0 = No
1 = Yes