1. Invoice
The follow sections describe the format of the Sales Invoice XML file.
|
XML |
Mandatory |
Description |
|
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> |
Y |
XML Declaration. |
|
<ociac10> |
Y |
Root Tag. Only 1 per file. |
|
<ocaciv> |
Y |
Invoice Tag. Allow more than 1 per file. Each tag will represent 1 invoice |
|
<ocacivhead> |
Y |
Header Tag. Only 1 per Invoice Tag. If there is more than 1, only the first tag will be used. |
|
<sivnum>TEXT(20)</sivnum> |
Y |
Invoice Number. |
|
<dtivdate>DATE(YYYY-MM-DD)</dtivdate> |
N |
Invoice Date. If missing Tag/Value, system will use current PC date |
|
<dtivduedate>DATE(YYYY-MM-DD)</dtivduedate> |
N |
Invoice Due Date. If missing Tag/Value, system will use Invoice Date |
|
<sbpcode>TEXT(20)</sbpcode> |
Y |
Business Partner Code. *Code must be in system. |
|
<sbplocationcode>TEXT(10)</sbplocationcode> |
N |
Business Partner Location Code. If missing Tag/Value, system will use Business Partner default Location Code. *Code must be in system. |
|
<sbplocationcode2>TEXT(10)</sbplocationcode2> |
N |
Business Partner 2nd Location Code. *Code must be in system. |
|
<sbplocationcode3>TEXT(10)</sbplocationcode3> |
N |
Business Partner 3rd Location Code. *Code must be in system. |
|
<sbplocationcode4>TEXT(10)</sbplocationcode4> |
N |
Business Partner 4th Location Code. *Code must be in system. |
|
<sivref>TEXT(50)</sivref> |
N |
Invoice Reference. |
|
<sivsubject>TEXT(100)</sivsubject> |
N |
Invoice Subject. |
|
<semployeecode>TEXT(20)</semployeecode> |
N |
Employee Code. *Code must be in system. |
|
<sivremark>TEXT(4000)</sivremark> |
N |
Invoice Remark. |
|
<sivcomment>TEXT(4000)</sivcomment> |
N |
Internal Comment. |
|
<scurrencycode>TEXT(3)</scurrencycode> |
Y |
Currency Code. *Code must be in system. |
|
<nivexchange>DECIMAL(18,6)</nivexchange> |
N |
Exchange Rate. If missing Tag/Value, system will use default exchange rate of the Currency Code |
|
<sivpayterm>TEXT(4)</sivpayterm> |
N |
Payment Terms Code. If missing Tag/Value, system will use Business Partner default Payment Terms Code. *Code must be in system. |
|
<sivterms>TEXT(50)</sivterms> |
N |
Payment Terms Text. If missing Tag/Value, system will use Payment Terms default text. |
|
<isivinclusive>TRUE/FALSE</isivinclusive> |
N |
Is invoice transaction price inclusive of GST? Not required for non-gst company. If missing Tag/Value, system will set the value to false. |
|
<isivcashsale>TRUE/FALSE</isivcashsale> |
N |
Is invoice transaction a cash sales? If missing Tag/Value, system will set the value to false. |
|
<nivcashamount>DECIMAL(18,6)</nivcashamount> |
*N |
Cash Sales Amount. *If < isivcashsale> is TRUE, this value is required. |
|
<sivcashmode>TEXT(10)</sivcashmode> |
*N |
Cash Mode. *If < isivcashsale> is TRUE, this value is required. *Code must be in system. |
|
<sdocutitle>TEXT(50)</sdocutitle> |
N |
Invoice Title. If missing Tag/Value, system will use the default invoice title |
|
<sdocuref1>TEXT(50)</</sdocuref1> |
N |
Additional Reference Field |
|
<sdocuref2>TEXT(50)</</sdocuref2> |
N |
Additional Reference Field |
|
<sdocuref3>TEXT(50)</</sdocuref3> |
N |
Additional Reference Field |
|
<sdocuref4>TEXT(50)</</sdocuref4> |
N |
Additional Reference Field |
|
<sdocuref5>TEXT(50)</</sdocuref5> |
N |
Additional Reference Field |
|
<dtpostdate>DATE(YYYY-MM-DD)</dtpostdate> |
N |
Account Post Date. If missing Tag/Value, system will use Invoice Date |
|
</ocacivhead> |
Y |
Closing of Header Tag |
|
<ocacivdtl> |
Y |
Detail Tag. Allow more than 1 per Invoice tag. |
|
<sivdtlsn>TEXT(5)</sivdtlsn> |
N |
Detail Serial Number. |
|
<sitemcode>TEXT(50)</sitemcode> |
Y |
Item Code. *Code must be in system. |
|
<sivdtldescription>TEXT(1000)</sivdtldescription> |
N |
Item Description. If missing Tag/Value, system will use Item default description |
|
<nivdtlqty>DECIMAL(18,6)</nivdtlqty> |
Y |
Item Quantity. Cannot be 0 |
|
<nivdtlprice>DECIMAL(18,6)</nivdtlprice> |
Y |
Item Unit Price. Cannot be 0 |
|
<sivdtluom>TEXT(20)</sivdtluom> |
N |
Item UOM. If missing Tag/Value, system will use Item default UOM |
|
<nivdtldiscpct>DECIMAL(5,2)</nivdtldiscpct> |
N |
Discount Percentage |
|
<nivdtldiscamt>DECIMAL(18,6)</nivdtldiscamt> |
N |
Discount Amount |
|
<staxcode>TEXT(10)</staxcode> |
N |
Tax Code. Not required for non-gst company. If missing Tag/Value, system will set Business Partner default Tax Code. *Code must be in system. |
|
<nivdtltamt>DECIMAL(18,6)</nivdtltamt> |
N |
Detail Transaction Amount. If missing Tag/Value, system will calculate the value automatically. |
|
<nivdtltgst>DECIMAL(18,6)</nivdtltgst> |
N |
Detail Gst Transaction Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically. |
|
<nivdtlttotal>DECIMAL(18,6)</nivdtlttotal> |
N |
Detail Transaction Amount After Gst. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically. |
|
<nivdtlaamt>DECIMAL(18,6)</nivdtlaamt> |
N |
Detail Account Amount. If missing Tag/Value, system will calculate the value automatically. |
|
<nivdtlagst>DECIMAL(18,6)</nivdtlagst> |
N |
Detail Gst Account Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically. |
|
<nivdtllamt>DECIMAL(18,6)</nivdtllamt> |
N |
Detail Local Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically. |
|
<nivdtllgst>DECIMAL(18,6)</nivdtllgst> |
N |
Detail Gst Local Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically. |
|
<swarehousecode>TEXT(10)</swarehousecode> |
N |
Warehouse Code.*Code must be in system. |
|
<sstocklocation>TEXT(10)</sstocklocation> |
*N |
Warehouse Location Code. Can only be use if there is Warehouse Code. *Code must be in system. |
|
<sstocklot>TEXT(10)</sstocklot> |
N |
Stock Lot Number. |
|
<sjobcode>TEXT(20)</sjobcode> |
N |
Job Code.*Code must be in system. |
|
<sivdtlremark>TEXT(4000)</sivdtlremark> |
N |
Detail Remark |
|
</ocacivdtl> |
Y |
Closing of Detail Tag |
|
</ocaciv> |
Y |
Closing of Invoice Tag |
|
</ociac10> |
Y |
Closing of Root Tag |
2. Supplier Invoice
The
following sections describe the format of the Supplier Invoice XML file.
*Document Running number is using the running number name. eg Default
|
XML |
Mandatory |
Description |
|
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> |
Y |
XML Declaration. |
|
<ociac10> |
Y |
Root Tag. Only 1 per file. |
|
<ocacsi> |
Y |
Invoice Tag. Allow more than 1 per file. Each tag will represent 1 invoice |
|
<ocacsihead> |
Y |
Header Tag. Only 1 per Invoice Tag. If there is more than 1, only the first tag will be used. |
|
<ssinum>TEXT</ssinum> |
Y |
Document Running Number Code. *Code must be in system. Eg "Default" |
|
<dtsidate>DATE(YYYY-MM-DD)</dtsidate> |
N |
Invoice Date. If missing Tag/Value, system will use current PC date |
|
<dtsiduedate>DATE(YYYY-MM-DD)</dtsiduedate> |
N |
Invoice Due Date. If missing Tag/Value, system will use Invoice Date |
|
<sbpcode>TEXT(20)</sbpcode> |
Y |
Business Partner Code. *Code must be in system. |
|
<sbplocationcode>TEXT(10)</sbplocationcode> |
N |
Business Partner Location Code. If missing Tag/Value, system will use Business Partner default Location Code. *Code must be in system. |
|
<sbplocationcode2>TEXT(10)</sbplocationcode2> |
N |
Business Partner 2nd Location Code. *Code must be in system. |
|
<sbplocationcode3>TEXT(10)</sbplocationcode3> |
N |
Business Partner 3rd Location Code. *Code must be in system. |
|
<sbplocationcode4>TEXT(10)</sbplocationcode4> |
N |
Business Partner 4th Location Code. *Code must be in system. |
|
<ssiref>TEXT(50)</ssiref> |
Y |
Supplier Invoice Number. * Duplicate number cannot exist on system |
|
<ssisubject>TEXT(100)</ssisubject> |
N |
Invoice Subject. |
|
<semployeecode>TEXT(20)</semployeecode> |
N |
Employee Code. *Code must be in system. |
|
<ssiremark>TEXT(4000)</ssiremark> |
N |
Invoice Remark. |
|
<ssicomment>TEXT(4000)</ssicomment> |
N |
Internal Comment. |
|
<scurrencycode>TEXT(3)</scurrencycode> |
Y |
Currency Code. *Code must be in system. |
|
<nsiexchange>DECIMAL(18,6)</nsiexchange> |
N |
Exchange Rate. If missing Tag/Value, system will use default exchange rate of the Currency Code |
|
<ssipayterm>TEXT(4)</ssipayterm> |
N |
Payment Terms Code. If missing Tag/Value, system will use Business Partner default Payment Terms Code. *Code must be in system. |
|
<ssiterms>TEXT(50)</ssiterms> |
N |
Payment Terms Text. If missing Tag/Value, system will use Payment Terms default text. |
|
<issiinclusive>true/false</issiinclusive> |
N |
Is invoice transaction price inclusive of GST? Not required for non-gst company. If missing Tag/Value, system will set the value to false. |
|
<sdocutitle>TEXT(50)</sdocutitle> |
N |
Invoice Title. If missing Tag/Value, system will use the default invoice title |
|
<sdocuref1>TEXT(50)</sdocuref1> |
N |
Additional Reference Field |
|
<sdocuref2>TEXT(50)</sdocuref2> |
N |
Additional Reference Field |
|
<sdocuref3>TEXT(50)</sdocuref3> |
N |
Additional Reference Field |
|
<sdocuref4>TEXT(50)</sdocuref4> |
N |
Additional Reference Field |
|
<sdocuref5>TEXT(50)</sdocuref5> |
N |
Additional Reference Field |
|
<dtpostdate>DATE(YYYY-MM-DD)</dtpostdate> |
N |
Account Post Date. If missing Tag/Value, system will use Invoice Date |
|
</ocacsihead> |
Y |
Closing of Header Tag |
|
<ocacsidtl> |
Y |
Detail Tag. Allow more than 1 per Invoice tag. |
|
<ssidtlsn>TEXT(5)</ssidtlsn> |
N |
Detail Serial Number. |
|
<sitemcode>TEXT(50)</sitemcode> |
Y |
Item Code. *Code must be in system. |
|
<ssidtldescription>TEXT(1000)</ssidtldescription> |
N |
Item Description. If missing Tag/Value, system will use Item default description |
|
<nsidtlqty>DECIMAL(18,6)</nsidtlqty> |
Y |
Item Quantity. Cannot be 0 |
|
<nsidtlprice>DECIMAL(18,6)</nsidtlprice> |
Y |
Item Unit Price. Cannot be 0 |
|
<ssidtluom>TEXT(20)</ssidtluom> |
N |
Item UOM. If missing Tag/Value, system will use Item default UOM |
|
<staxcode>TEXT(10)</staxcode> |
N |
Tax Code. Not required for non-gst company. If missing Tag/Value, system will set Business Partner default Tax Code. *Code must be in system. |
|
<nsidtltamt>DECIMAL(18,6)</nsidtltamt> |
N |
Detail Transaction Amount. If missing Tag/Value, system will calculate the value automatically. |
|
<nsidtltgst>DECIMAL(18,6)</nsidtltgst> |
N |
Detail Gst Transaction Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically. |
|
<nsidtlttotal>DECIMAL(18,6)</nsidtlttotal> |
N |
Detail Transaction Amount After Gst. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically. |
|
<nsidtlaamt>DECIMAL(18,6)</nsidtlaamt> |
N |
Detail Account Amount. If missing Tag/Value, system will calculate the value automatically. |
|
<nsidtlagst>DECIMAL(18,6)</nsidtlagst> |
N |
Detail Gst Account Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically. |
|
<nsidtllamt>DECIMAL(18,6)</nsidtllamt> |
N |
Detail Local Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically. |
|
<nsidtllgst>DECIMAL(18,6)</nsidtllgst> |
N |
Detail Gst Local Amount. Not required for non-gst company. If missing Tag/Value, system will calculate the value automatically. |
|
<swarehousecode>TEXT(10)</swarehousecode> |
N |
Warehouse Code.*Code must be in system. |
|
<sstocklocation>TEXT(10)</sstocklocation> |
*N |
Warehouse Location Code. Can only be use if there is Warehouse Code. *Code must be in system. |
|
<sstocklot>TEXT(10)</sstocklot> |
N |
Stock Lot Number. |
|
<sjobcode>TEXT(20)</sjobcode> |
N |
Job Code.*Code must be in system. |
|
<ssidtlremark>TEXT(4000)</ssidtlremark> |
N |
Detail Remark |
|
</ocacsidtl> |
Y |
Closing of Detail Tag |
|
</ocacsi> |
Y |
Closing of Invoice Tag |
|
</ociac10> |
Y |
Closing of Root Tag |