|
Field
|
Data Type
|
Description
|
Note
|
<tr style={{height: "34px"}}>
<td style={{width: "190px", height: "34px"}}>
<p>warehouse_id</p>
</td>
<td style={{width: "149px", height: "34px"}}>
<p>string(30)</p>
</td>
<td style={{width: "198px", height: "34px"}}>
<p>Warehouse Code</p>
</td>
<td style={{width: "138px", height: "34px"}}>
<p>Mandatory</p>
</td>
</tr>
<tr style={{height: "60px"}}>
<td style={{width: "190px", height: "60px"}}>
<p>po_type</p>
</td>
<td style={{width: "149px", height: "60px"}}>
<p>string(20)</p>
</td>
<td style={{width: "198px", height: "60px"}}>
<p>Normal PO (CG),</p>
<p>Return to warehouse (RT)</p>
</td>
<td style={{width: "138px", height: "60px"}}>
<p>Mandatory</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>doc_no</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(20)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Purchase Order No or Inbound Return No</p>
<p>Example:</p>
<p>SO21090300003</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Mandatory</p>
</td>
</tr>
<tr style={{height: "34px"}}>
<td style={{width: "190px", height: "34px"}}>
<p>po_creation_time</p>
</td>
<td style={{width: "149px", height: "34px"}}>
<p>yyyy-MM-ddThh:mm:ssZ</p>
</td>
<td style={{width: "198px", height: "34px"}}>
<p>Doc Created Date Timestam</p>
<p>Example: </p>
<p>2021-01-01:22:23:24Z</p>
</td>
<td style={{width: "138px", height: "34px"}}>
<p>Mandatory</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_id</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(30)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Registered Supplier Identification</p>
<p>Example:</p>
<p>SHIPPEROUTLETTUJUH</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Mandatory</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>po_reference_a</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(50)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Purchase Order Reference No</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>po_reference_b</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(50)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Purchase Order Reference No</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>po_reference_c</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(50)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Purchase Order Reference No</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>po_reference_d</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(50)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Purchase Order Reference No</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>expected_arrive_time_1</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>Datetime</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>PO Expected Arrived Time 1</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>expected_arrive_time_2</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>Datetime</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>PO Expected Arrived Time 2</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>hedi_01</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>EDI Related Information</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>hedi_02</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>EDI Related Information</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_name</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>PO Supplier Name</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_address_1</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Supplier Address 1</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_address_2</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Supplier Address 2</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_country</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(2)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Supplier Country code Location</p>
<p>Example : ID</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_province</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(50)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Supplier Province Location</p>
<p>Example : DKI Jakarta</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_city</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(50)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Supplier City Name</p>
<p>Example : Jakarta Selatan</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_district</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(50)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Supplier District Name</p>
<p>Example : Gambir</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_street</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(50)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Supplier Street Name</p>
<p>Example: Jalan Gambir No. 01</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_contact</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Supplier Contact Name</p>
<p>Example : Mr.Brown </p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_fax</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(20)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Supplier Fax No</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_mail</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Supplier Email Address</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_tel_1</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(40)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Supplier Contact Phone</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_tel_2</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(100)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Supplier Contact Phone 2</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>supplier_zip</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(10)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Supplier ZIP Location</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>issue_party_id</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(30)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>-</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>issue_party_name</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>-</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>user_define_1</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Defined by Shipper</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>user_define_2</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p> Defined by Shipper</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>user_define_3</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Defined by Shipper</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>notes</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(500)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>More note about the supplier</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "34px"}}>
<td style={{width: "675px", height: "34px"}} colspan="4">
<p><strong>Details</strong></p>
</td>
</tr>
<tr style={{height: "34px"}}>
<td style={{width: "190px", height: "34px"}}>
<p>line_no</p>
</td>
<td style={{width: "149px", height: "34px"}}>
<p>Integer</p>
</td>
<td style={{width: "198px", height: "34px"}}>
<p>Line Number</p>
</td>
<td style={{width: "138px", height: "34px"}}>
<p>Mandatory</p>
</td>
</tr>
<tr style={{height: "61px"}}>
<td style={{width: "190px", height: "61px"}}>
<p>customer_id</p>
</td>
<td style={{width: "149px", height: "61px"}}>
<p>string(30)</p>
</td>
<td style={{width: "198px", height: "61px"}}>
<p>Customer ID, will be registered by Shipper Technical Team for new client</p>
</td>
<td style={{width: "138px", height: "61px"}}>
<p>Mandatory</p>
</td>
</tr>
<tr style={{height: "34px"}}>
<td style={{width: "190px", height: "34px"}}>
<p>sku</p>
</td>
<td style={{width: "149px", height: "34px"}}>
<p>string(50)</p>
</td>
<td style={{width: "198px", height: "34px"}}>
<p>Product Identifier Code</p>
<p>Example: SK18319U</p>
</td>
<td style={{width: "138px", height: "34px"}}>
<p>Mandatory</p>
</td>
</tr>
<tr style={{height: "34px"}}>
<td style={{width: "190px", height: "34px"}}>
<p>ordered_qty</p>
</td>
<td style={{width: "149px", height: "34px"}}>
<p>decimal(18, 8)</p>
</td>
<td style={{width: "198px", height: "34px"}}>
<p>QTY Order</p>
</td>
<td style={{width: "138px", height: "34px"}}>
<p>Mandatory</p>
</td>
</tr>
<tr style={{height: "34px"}}>
<td style={{width: "190px", height: "34px"}}>
<p>pack_id</p>
</td>
<td style={{width: "149px", height: "34px"}}>
<p>string(30)</p>
</td>
<td style={{width: "198px", height: "34px"}}>
<p>UoM Conversion ID, please use "EA"</p>
<p>Ea = each = unit<br />Box = per box<br />Pallet = per pallet<br />Inner packs = In 1 box there are how many</p>
</td>
<td style={{width: "138px", height: "34px"}}>
<p>Mandatory</p>
</td>
</tr>
<tr style={{height: "34px"}}>
<td style={{width: "190px", height: "34px"}}>
<p>mfg_date</p>
</td>
<td style={{width: "149px", height: "34px"}}>
<p>yyyy-MM-dd</p>
</td>
<td style={{width: "198px", height: "34px"}}>
<p>Manufacturing Date</p>
<p>Example : 2021-01-01</p>
</td>
<td style={{width: "138px", height: "34px"}}>
<p>Optional</p>
</td>
</tr>
<tr style={{height: "34px"}}>
<td style={{width: "190px", height: "34px"}}>
<p>exp_date</p>
</td>
<td style={{width: "149px", height: "34px"}}>
<p>yyyy-MM-dd</p>
</td>
<td style={{width: "198px", height: "34px"}}>
<p>Expire Date</p>
<p>Example : 2021-01-01</p>
</td>
<td style={{width: "138px", height: "34px"}}>
<p>Available, Optional</p>
</td>
</tr>
<tr style={{height: "34px"}}>
<td style={{width: "190px", height: "34px"}}>
<p>batch_no</p>
</td>
<td style={{width: "149px", height: "34px"}}>
<p>string(100)</p>
</td>
<td style={{width: "198px", height: "34px"}}>
<p>Batch Number</p>
</td>
<td style={{width: "138px", height: "34px"}}>
<p>Optional</p>
</td>
</tr>
<tr style={{height: "34px"}}>
<td style={{width: "190px", height: "34px"}}>
<p>serial_no</p>
</td>
<td style={{width: "149px", height: "34px"}}>
<p>string(100)</p>
</td>
<td style={{width: "198px", height: "34px"}}>
<p>Serial Number</p>
</td>
<td style={{width: "138px", height: "34px"}}>
<p>Optional</p>
</td>
</tr>
<tr style={{height: "34px"}}>
<td style={{width: "190px", height: "34px"}}>
<p>notes</p>
</td>
<td style={{width: "149px", height: "34px"}}>
<p>text(200)</p>
</td>
<td style={{width: "198px", height: "34px"}}>
<p>Remarks</p>
</td>
<td style={{width: "138px", height: "34px"}}>
<p>Optional</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>receipt_date</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>Date</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Goods Receipt Date</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>product_condition</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(10)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Goods Product Condition</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>total_price</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>decimal(18, 8)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Goods Total Price</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with 0 (Zero)</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>dedi_04</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>EDI Related Information</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>dedi_05</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>EDI Related Information</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>user_define_1</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Defined by Shipper</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
<tr style={{height: "48px"}}>
<td style={{width: "190px", height: "48px"}}>
<p>user_define_2</p>
</td>
<td style={{width: "149px", height: "48px"}}>
<p>string(200)</p>
</td>
<td style={{width: "198px", height: "48px"}}>
<p>Defined by Shipper</p>
</td>
<td style={{width: "138px", height: "48px"}}>
<p>Please Fill with Empty String</p>
</td>
</tr>
</tbody>