Sample json data of Sales Order Index

{
    "accidentDate": "Jan 1, 1 12:00:00 AM",
    "amountCommission": 0,
    "billingAdd1": "",
    "billingAdd2": "",
    "billingAdd3": "",
    "billingCity": "",
    "billingCompanyName": "",
    "billingCountry": "",
    "billingEmail": "",
    "billingFax": "",
    "billingHandphone": "",
    "billingPhone1": "",
    "billingPhone2": "",
    "billingState": "",
    "billingZip": "",
    "claimAmount": 0,
    "codeDealer": "",
    "codeDept": "",
    "codeProject": "",
    "codeSalesman": "",
    "codeSupplier": "",
    "consignmentId": 0,
    "custSource": "CIMB Bank Credit Card",
    "expDeliveryTimeStart": "Oct 24, 2013 2:16:33 PM",
    "groupDiscount": 0,
    "incoterms": "",
    "label_id": 0,
    "loyaltyCardPkid": 0,
    "loyaltyCardStatus": "",
    "loyaltyJTxnReversalStatus": "",
    "loyaltyJTxnStatus": "",
    "loyaltyPointsAwarded": 0,
    "loyaltyPointsRedeemed": 0,
    "loyaltyProcessReversalStatus": "",
    "loyaltyProcessStatus": "",
    "mCostOfGoodsSold": 0,
    "mCurrency": "MYR",
    "mCurrency2": "",
    "mCustSvcCtrId": 1,
    "mDefaultRowsNumber": 15,
    "mDeliveryOrder": 0,
    "mDescription": "",
    "mDisplayFormat": "it1",
    "mDocType": "cust_sales_order_index",
    "mEntityCode": "",
    "mEntityContactPerson": "",
    "mEntityGuid": "",
    "mEntityKey": 1011,
    "mEntityName": "ALLIANCE COMPOSITE ENGINEERING SDN BHD",
    "mEntityTable": "cust_account_index",
    "mForeignKey": 0,
    "mForeignTable": "",
    "mForeignText": "",
    "mGuid": "1BF9C733-05B6-4906-8548-72DA816F3CE1",
    "mIdInvoice": 0,
    "mIdentityNumber": "",
    "mLastUpdate": "Oct 24, 2013 2:16:25 PM",
    "mLocationId": 1000,
    "mOutstandingAmt": 141000,
    "mOutstandingAmt2": 0,
    "mOutstandingBfPdc": 0,
    "mPCCenter": 1,
    "mPaymentTermsId": 0,
    "mPkid": 100001,
    "mReceiptId": 0,
    "mReferenceNo": "",
    "mRemarks": "",
    "mSalesTxnId": 0,
    "mState": "created",
    "mStatus": "active",
    "mStmtNumber": 0,
    "mStmtType": "",
    "mTimeIssued": "Oct 24, 2013 10:14:14 PM",
    "mTotalAmt": 301000,
    "mTotalAmt2": 0,
    "mTxnType": "",
    "mUserIdUpdate": 536,
    "mWorkOrder": 0,
    "membershipCardPkid": 0,
    "permitDoc1": "",
    "permitDoc2": "",
    "permitDoc3": "",
    "permitNo": "",
    "policyNumber": "",
    "posId": 101,
    "rebate1Consume": 0,
    "rebate1Date": "Jan 1, 1 12:00:00 AM",
    "rebate1Gain": 0,
    "rebate1Option": "",
    "rebate2Consume": 0,
    "rebate2Date": "Jan 1, 1 12:00:00 AM",
    "rebate2Gain": 0,
    "rebate2Option": "",
    "receiverAdd1": "",
    "receiverAdd2": "",
    "receiverAdd3": "",
    "receiverCity": "",
    "receiverCompanyName": "",
    "receiverCountry": "",
    "receiverEmail": "",
    "receiverFax": "",
    "receiverHandphone": "",
    "receiverKey": 0,
    "receiverName": "",
    "receiverPhone1": "",
    "receiverPhone2": "",
    "receiverState": "",
    "receiverTable": "",
    "receiverTitle": "",
    "receiverZip": "",
    "runningNo": "",
    "salesId": 0,
    "subtype1": "",
    "subtype2": "",
    "subtype3": "",
    "synchroKey": "1BF9C733-05B6-4906-8548-72DA816F3CE1",
    "taxAmount": 0,
    "taxAmount2": 0,
    "taxDateConverted": "Jan 1, 1 12:00:00 AM",
    "taxEntityName": "",
    "taxFilingCycle": "",
    "taxFilingDate": "Jan 1, 1 12:00:00 AM",
    "taxFilingPkid": 0,
    "taxFilingStatus": "",
    "taxRunningNo1": "",
    "taxRunningNo2": "",
    "taxRunningNoDate": "Jan 1, 1 12:00:00 AM",
    "taxRunningNoType": "",
    "taxType": "",
    "tcCreateTime": "Jan 1, 1 12:00:00 AM",
    "tcDocPkid": 100001,
    "terms1Date": "Jan 1, 1 12:00:00 AM",
    "terms1DiscAmt": 0,
    "terms1DiscPct": 0,
    "terms1Option": "",
    "terms2Date": "Jan 1, 1 12:00:00 AM",
    "terms2DiscAmt": 0,
    "terms2DiscPct": 0,
    "terms2Option": "",
    "timeCreate": "Oct 24, 2013 2:16:33 PM",
    "trackingNo": "",
    "tradersRemarks": "",
    "transportDate": "Jan 1, 1 12:00:00 AM",
    "transportDoc1": "",
    "transportDoc2": "",
    "transportDoc3": "",
    "txnDoc1": "",
    "txnDoc2": "",
    "txnDoc3": "",
    "userId": 0,
    "vecDocLink": [
        {
            "amount": 70000,
            "amount2": 0,
            "currency": "MYR",
            "currency2": "",
            "guid": "9064D99C-9DC3-41AC-B550-84661126C8DB",
            "lastUpdate": "Oct 24, 2013 2:10:19 PM",
            "namespace": "customer",
            "pkid": 0,
            "reference": "",
            "relType": "pmt_so",
            "remarks": "",
            "srcAmount": 70000,
            "srcAmount2": 0,
            "srcDocGuid": "15E4E704-4B15-4DE1-8A60-D66BB412995D",
            "srcDocId": 0,
            "srcDocRef": "acc_receipt_index",
            "srcTimeCreated": "Oct 24, 2013 12:00:00 AM",
            "srcTimeTxn": "Oct 24, 2013 12:00:00 AM",
            "status": "active",
            "tgtAmount": 301000,
            "tgtAmount2": 0,
            "tgtDocGuid": "1BF9C733-05B6-4906-8548-72DA816F3CE1",
            "tgtDocId": 0,
            "tgtDocRef": "cust_sales_order_index",
            "tgtTimeCreated": "Oct 24, 2013 12:00:00 AM",
            "tgtTimeTxn": "Oct 24, 2013 12:00:00 AM",
            "userIdUpdate": 536
        }
    ],
    "vecRct": [
        {
            "amount": 70000,
            "amount2": 0,
            "amountCard": 0,
            "amountCash": 70000,
            "amountCheque": 0,
            "amountCoupon": 0,
            "amountOther": 0,
            "amountPDCheque": 0,
            "branch": 1,
            "cardApprovalCode": "",
            "cardApprovalParty": "",
            "cardApprovalTime": "Jan 1, 1 12:00:00 AM",
            "cardBank": "",
            "cardBatch": "",
            "cardCB": 0,
            "cardCharges": 0,
            "cardId": 0,
            "cardIssuerBank": "Select",
            "cardName": "",
            "cardNumber": "",
            "cardPctCharges": 0,
            "cardSecurityNum": "",
            "cardSurcharge": 0,
            "cardType": "",
            "cardValidFrom": "Oct 24, 2013 2:09:47 PM",
            "cardValidThru": "Oct 24, 2013 2:09:47 PM",
            "cashDrawer": "",
            "cashNotesChange": 0,
            "cashNotesReceived": 0,
            "cbCard": 1017,
            "cbCash": 1000,
            "cbCheque": 1001,
            "cbChequeCharges": 1001,
            "cbCoupon": 1018,
            "cbOther": 1018,
            "cbPDCheque": 1001,
            "chequeBankInCb": 0,
            "chequeChargesAmount": 0,
            "chequeNumber": "",
            "chequeNumberPD": "",
            "chequeStatus": "",
            "codeDealer": "",
            "codeDepartment": "",
            "codeProject": "",
            "codeSalesman": "",
            "couponNumber": "",
            "currency": "MYR",
            "currency2": "",
            "datePDCheque": "Oct 24, 2013 2:09:47 PM",
            "eTfrAmount": 0,
            "eTfrBank": "",
            "eTfrCashbook": 0,
            "eTfrCharges": 0,
            "eTfrDate": "Jan 1, 1 12:00:00 AM",
            "eTfrReference": "",
            "eTfrRmks": "",
            "entityKey": 1011,
            "entityName": "ALLIANCE COMPOSITE ENGINEERING SDN BHD",
            "entityTable": "cust_account_index",
            "format": "",
            "guid": "15E4E704-4B15-4DE1-8A60-D66BB412995D",
            "intReserved1": 0,
            "label_id": 0,
            "lastUpdate": "Oct 24, 2013 2:10:18 PM",
            "openBalance": 0,
            "paymentMethod": "",
            "paymentRemarks": "",
            "paymentTime": "Oct 24, 2013 12:00:00 AM",
            "pcCenter": 1,
            "pdChequeBankInCb": 0,
            "pdChequeStatus": "",
            "whtTaxType": "",
            "whtTaxRate": 0,
            "pic1": 0,
            "pic2": 0,
            "pic3": 0,
            "pkid": 1001,
            "posReceiptPkid": 1001,
            "remarksReverse": "",
            "reversePayment": 0,
            "state": "",
            "status": "active",
            "statusPayment": "",
            "stmtNumber": 0,
            "strReserved1": "terminal_bank_cc_bank_diff",
            "synchroKey": "15E4E704-4B15-4DE1-8A60-D66BB412995D",
            "taxAmount": 0,
            "taxCode": "",
            "taxFilingCycle": "",
            "taxFilingDate": "Jan 1, 1 12:00:00 AM",
            "taxFilingPkid": 0,
            "taxFilingStatus": "",
            "taxFilingStatus2": "",
            "taxRate": 0,
            "taxType": "",
            "userIdUpdate": 536,
            "vecEntry": [],
            "whtTaxAmount": 0,
            "whtTaxCert": "",
            "whtTaxCode": "",
            "pdcExist": false,
            "pdcClear": false
        }
    ],
    "whtFilingCycle": "",
    "whtFilingDate": "Jan 1, 1 12:00:00 AM",
    "whtFilingStatus": "",
    "whtTaxAmount": 0,
    "whtTaxBalance": 0,
    "whtTaxCode": "",
    "whtTaxRate": 0,
    "whtTaxType": "",
    "xrate": 0
}