View: Outgoing Document Processing

RotoID: EI0500
Table: EIODOC
Protocol: Flat, Ordered revisions
DLL:EIODOC

Keys: 4

Title Fields

Document IDINVCIDVEND
Customer/Document IDCUSTIDINVC
Type/Customer/Document TRXTYPETXTIDCUSTIDINVC
UUID UUID

Fields: 25

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 
IDCUST 3 String*12 Customer Number E A 
TRXTYPETXT 4 Integer Document Type E A  List:4 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
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:9 entries
0 = Not Sent
1 = Sent
9 = Error
11 = Received
12 = Processing
13 = Transmitted
14 = Failed to transmit
15 = Pending response from LHDN
16 = Rejected by LHDN
PPLMSG 11 String*250 Peppol Transaction Message E A 
PPLDATE1 12 Date Submission Date E A 
PPLTIME1 13 String*60 Submission Date Time E A 
PPLDATE2 14 Date Last Sync Date E A 
PPLTIME2 15 String*60 Last Sync Date Time E A 
SELECTED 16 Integer Selected E A  List:3 entries
0 = No
1 = Yes
2 =
DOCPRINTED 17 Integer Document Printed E A 
UUID 18 String*150 UUID E A 
LONGID 19 String*150 LONGID E A 
HASH 20 String*50 Hash Key E A 
DOCTOTAL 21 BCD*10.3 Document Total E A 
ENTEREDBY 22 String*8 Entered By E A 
CURID 23 String*3 Sage 300 Currency Code E A  Mask: %-3N
SESSIONID 50 String*36 Session ID / GUID E A 
BILLTYPE 51 Integer Billing Type E A  List:2 entries
0 = Standard
1 = Self-Billed