/
Sample Data of Sales Order Index Collection
Sample Data of Sales Order Index Collection
{ "userValidation": true, "resultJSON": [ { "mGuid": "1DDF649C-7F00-0101-5312-0104721018BB", "mPkid": 100826, "mStmtNumber": 0, "mSalesTxnId": 0, "mPaymentTermsId": 0, "mTimeIssued": "Feb 13, 2014 1:52:23 AM", "mCurrency": "MYR", "mTotalAmt": 2458.5, "mOutstandingAmt": 2458.5, "mOutstandingBfPdc": 0, "mRemarks": "", "mState": "cre", "mStatus": "act", "mLastUpdate": "Dec 23, 2013 1:14:28 PM", "mUserIdUpdate": 500, "mEntityTable": "cust_account_index", "mEntityGuid": "", "mEntityKey": 1001, "mEntityName": " ", "mEntityCode": "", "mIdentityNumber": "", "mEntityContactPerson": "", "mForeignTable": "", "mForeignKey": 0, "mForeignText": "", "mCustSvcCtrId": 1, "mLocationId": 1000, "mPCCenter": 1, "mTxnType": "", "mStmtType": "", "mReferenceNo": "", "mDescription": "", "mWorkOrder": 0, "mDeliveryOrder": 0, "mReceiptId": 0, "mDisplayFormat": "it1", "mDocType": "", "billingHandphone": "", "billingPhone1": "", "billingPhone2": "", "billingFax": "", "billingEmail": "", "billingCompanyName": "JET MACHINERY powersungguh SDN BHD", "billingAdd1": "", "billingAdd2": "", "billingAdd3": "", "billingCity": "", "billingZip": "", "billingState": "", "billingCountry": "", "receiverName": " ", "receiverHandphone": "", "receiverPhone1": "", "receiverPhone2": "", "receiverFax": "", "receiverEmail": "", "receiverCompanyName": "", "receiverAdd1": "", "receiverAdd2": "", "receiverAdd3": "", "receiverCity": "", "receiverZip": "", "receiverState": "", "receiverCountry": "", "terms1Option": "", "terms1Date": "Jan 1, 0001 12:00:00 AM", "terms1DiscPct": 0, "terms1DiscAmt": 0, "terms2Option": "", "terms2Date": "Jan 1, 0001 12:00:00 AM", "terms2DiscPct": 0, "terms2DiscAmt": 0, "rebate1Option": "", "rebate1Date": "Jan 1, 0001 12:00:00 AM", "rebate1Gain": 0, "rebate1Consume": 0, "rebate2Option": "", "rebate2Date": "Jan 1, 0001 12:00:00 AM", "rebate2Gain": 0, "rebate2Consume": 0, "codeDept": "", "codeProject": "", "codeSupplier": "", "codeSalesman": "", "codeDealer": "", "subtype1": "", "subtype2": "", "subtype3": "", "accidentDate": "Jan 1, 0001 12:00:00 AM", "policyNumber": "", "loyaltyCardStatus": "", "loyaltyCardPkid": 0, "claimAmount": 0, "salesId": 0, "userId": 500, "trackingNo": "", "taxAmount": 0, "taxType": "", "loyaltyProcessStatus": "", "loyaltyProcessReversalStatus": "", "loyaltyJTxnStatus": "", "loyaltyJTxnReversalStatus": "", "loyaltyPointsAwarded": 0, "loyaltyPointsRedeemed": 0, "expDeliveryTimeStart": "Feb 13, 2014 1:52:23 AM", "mCurrency2": "", "mTotalAmt2": 0, "mOutstandingAmt2": 0, "taxAmount2": 0, "xrate": 0, "mCostOfGoodsSold": 0, "vecInvoiceItems": [], "mDefaultRowsNumber": 15, "incoterms": "", "permitNo": "", "permitDoc1": "", "permitDoc2": "", "permitDoc3": "", "txnDoc1": "", "txnDoc2": "", "txnDoc3": "", "transportDoc1": "", "transportDoc2": "", "transportDoc3": "", "transportDate": "Jan 1, 0001 12:00:00 AM", "tradersRemarks": "", "membershipCardPkid": 0, "groupDiscount": 0, "synchroKey": "", "consignmentId": 0, "tcDocPkid": 0, "posId": 0, "tcCreateTime": "Jan 1, 0001 12:00:00 AM", "taxRunningNo1": "", "taxRunningNo2": "", "runningNo": "", "taxRunningNoType": "", "taxRunningNoDate": "Jan 1, 0001 12:00:00 AM", "taxFilingPkid": 0, "taxFilingDate": "Jan 1, 0001 12:00:00 AM", "taxFilingCycle": "", "taxFilingStatus": "", "whtTaxType": "", "whtTaxCode": "", "whtTaxRate": 0, "whtTaxAmount": 0, "whtTaxBalance": 0, "whtFilingDate": "Jan 1, 0001 12:00:00 AM", "whtFilingCycle": "", "whtFilingStatus": "", "taxEntityName": "", "taxDateConverted": "Jan 1, 0001 12:00:00 AM", "label_id": 0, "amountCommission": 0, "timeCreate": "Dec 23, 2013 1:13:36 PM", "receiverTable": "cust_user_index", "receiverKey": 0, "receiverTitle": "", "vecDocLink": [], "custSource": "" }, { "mGuid": "1E567DC7-7F00-0101-57D3-B0C7FC065058", "mPkid": 100827, "mStmtNumber": 0, "mSalesTxnId": 0, "mPaymentTermsId": 0, "mTimeIssued": "Feb 13, 2014 1:52:23 AM", "mCurrency": "MYR", "mTotalAmt": 1470, "mOutstandingAmt": 1470, "mOutstandingBfPdc": 0, "mRemarks": "", "mState": "cre", "mStatus": "act", "mLastUpdate": "Dec 23, 2013 3:24:26 PM", "mUserIdUpdate": 500, "mEntityTable": "cust_account_index", "mEntityGuid": "", "mEntityKey": 1001, "mEntityName": " ", "mEntityCode": "", "mIdentityNumber": "", "mEntityContactPerson": "", "mForeignTable": "", "mForeignKey": 0, "mForeignText": "", "mCustSvcCtrId": 1, "mLocationId": 1000, "mPCCenter": 1, "mTxnType": "", "mStmtType": "", "mReferenceNo": "", "mDescription": "", "mWorkOrder": 0, "mDeliveryOrder": 0, "mReceiptId": 0, "mDisplayFormat": "it1", "mDocType": "", "billingHandphone": "", "billingPhone1": "", "billingPhone2": "", "billingFax": "", "billingEmail": "", "billingCompanyName": "JET MACHINERY powersungguh SDN BHD", "billingAdd1": "", "billingAdd2": "", "billingAdd3": "", "billingCity": "", "billingZip": "", "billingState": "", "billingCountry": "", "receiverName": " ", "receiverHandphone": "", "receiverPhone1": "", "receiverPhone2": "", "receiverFax": "", "receiverEmail": "", "receiverCompanyName": "", "receiverAdd1": "", "receiverAdd2": "", "receiverAdd3": "", "receiverCity": "", "receiverZip": "", "receiverState": "", "receiverCountry": "", "terms1Option": "", "terms1Date": "Jan 1, 0001 12:00:00 AM", "terms1DiscPct": 0, "terms1DiscAmt": 0, "terms2Option": "", "terms2Date": "Jan 1, 0001 12:00:00 AM", "terms2DiscPct": 0, "terms2DiscAmt": 0, "rebate1Option": "", "rebate1Date": "Jan 1, 0001 12:00:00 AM", "rebate1Gain": 0, "rebate1Consume": 0, "rebate2Option": "", "rebate2Date": "Jan 1, 0001 12:00:00 AM", "rebate2Gain": 0, "rebate2Consume": 0, "codeDept": "", "codeProject": "", "codeSupplier": "", "codeSalesman": "", "codeDealer": "", "subtype1": "", "subtype2": "", "subtype3": "", "accidentDate": "Jan 1, 0001 12:00:00 AM", "policyNumber": "", "loyaltyCardStatus": "", "loyaltyCardPkid": 0, "claimAmount": 0, "salesId": 0, "userId": 500, "trackingNo": "", "taxAmount": 0, "taxType": "", "loyaltyProcessStatus": "", "loyaltyProcessReversalStatus": "", "loyaltyJTxnStatus": "", "loyaltyJTxnReversalStatus": "", "loyaltyPointsAwarded": 0, "loyaltyPointsRedeemed": 0, "expDeliveryTimeStart": "Feb 13, 2014 1:52:23 AM", "mCurrency2": "", "mTotalAmt2": 0, "mOutstandingAmt2": 0, "taxAmount2": 0, "xrate": 0, "mCostOfGoodsSold": 0, "vecInvoiceItems": [], "mDefaultRowsNumber": 15, "incoterms": "", "permitNo": "", "permitDoc1": "", "permitDoc2": "", "permitDoc3": "", "txnDoc1": "", "txnDoc2": "", "txnDoc3": "", "transportDoc1": "", "transportDoc2": "", "transportDoc3": "", "transportDate": "Jan 1, 0001 12:00:00 AM", "tradersRemarks": "", "membershipCardPkid": 0, "groupDiscount": 0, "synchroKey": "", "consignmentId": 0, "tcDocPkid": 0, "posId": 0, "tcCreateTime": "Jan 1, 0001 12:00:00 AM", "taxRunningNo1": "", "taxRunningNo2": "", "runningNo": "", "taxRunningNoType": "", "taxRunningNoDate": "Jan 1, 0001 12:00:00 AM", "taxFilingPkid": 0, "taxFilingDate": "Jan 1, 0001 12:00:00 AM", "taxFilingCycle": "", "taxFilingStatus": "", "whtTaxType": "", "whtTaxCode": "", "whtTaxRate": 0, "whtTaxAmount": 0, "whtTaxBalance": 0, "whtFilingDate": "Jan 1, 0001 12:00:00 AM", "whtFilingCycle": "", "whtFilingStatus": "", "taxEntityName": "", "taxDateConverted": "Jan 1, 0001 12:00:00 AM", "label_id": 0, "amountCommission": 0, "timeCreate": "Dec 23, 2013 3:23:41 PM", "receiverTable": "cust_user_index", "receiverKey": 0, "receiverTitle": "", "vecDocLink": [], "custSource": "" } ], "msgCode": 0, "msg": "2014-02-13 01:51:10.0" }
Private & Confidential