|
|
|
bw:sales_order_hana_json [2019/04/04 16:05]
runger created |
— (current) |
| JSON structure for SAP Business One Sales Order | |
| |
| <code> | |
| { | |
| "odata.metadata" : "https://18.208.56.251:50000/b1s/v1/$metadata#Orders/@Element", | |
| "DocEntry" : 1228, | |
| "DocNum" : 1191, | |
| "DocType" : "dDocument_Items", | |
| "HandWritten" : "tNO", | |
| "Printed" : "psNo", | |
| "DocDate" : "2019-02-21", | |
| "DocDueDate" : "2019-02-28", | |
| "CardCode" : "C20000", | |
| "CardName" : "Maxi-Tech", | |
| "Address" : "4417 Stonebridge Rd\rSuite 500\rNorthampton PA 18067\rUSA", | |
| "NumAtCard" : null, | |
| "DocTotal" : 412.080, | |
| "AttachmentEntry" : null, | |
| "DocCurrency" : "$", | |
| "DocRate" : 1.0, | |
| "Reference1" : "1191", | |
| "Reference2" : null, | |
| "Comments" : "", | |
| "JournalMemo" : "Sales Orders - C20000", | |
| "PaymentGroupCode" : 1, | |
| "DocTime" : "10:41:00", | |
| "SalesPersonCode" : 1, | |
| "TransportationCode" : 1, | |
| "Confirmed" : "tYES", | |
| "ImportFileNum" : null, | |
| "SummeryType" : "dNoSummary", | |
| "ContactPersonCode" : 1, | |
| "ShowSCN" : "tNO", | |
| "Series" : 5, | |
| "TaxDate" : "2019-02-21", | |
| "PartialSupply" : "tYES", | |
| "DocObjectCode" : "oOrders", | |
| "ShipToCode" : "Ship to", | |
| "Indicator" : null, | |
| "FederalTaxID" : "US25-987634", | |
| "DiscountPercent" : 0.0, | |
| "PaymentReference" : null, | |
| "CreationDate" : "2019-02-21", | |
| "UpdateDate" : "2019-02-21", | |
| "FinancialPeriod" : 172, | |
| "TransNum" : null, | |
| "VatSum" : 23.330, | |
| "VatSumSys" : 23.330, | |
| "VatSumFc" : 0.0, | |
| "NetProcedure" : "tNO", | |
| "DocTotalFc" : 0.0, | |
| "DocTotalSys" : 412.080, | |
| "Form1099" : null, | |
| "Box1099" : null, | |
| "RevisionPo" : "tNO", | |
| "RequriedDate" : "2019-02-28", | |
| "CancelDate" : "2019-03-30", | |
| "BlockDunning" : "tNO", | |
| "Submitted" : "tNO", | |
| "Segment" : 0, | |
| "PickStatus" : "tNO", | |
| "Pick" : "tNO", | |
| "PaymentMethod" : "Incoming BT 02", | |
| "PaymentBlock" : "tNO", | |
| "PaymentBlockEntry" : null, | |
| "CentralBankIndicator" : null, | |
| "MaximumCashDiscount" : "tNO", | |
| "Reserve" : "tNO", | |
| "Project" : null, | |
| "ExemptionValidityDateFrom" : null, | |
| "ExemptionValidityDateTo" : null, | |
| "WareHouseUpdateType" : "dwh_CustomerOrders", | |
| "Rounding" : "tNO", | |
| "ExternalCorrectedDocNum" : null, | |
| "InternalCorrectedDocNum" : null, | |
| "NextCorrectingDocument" : null, | |
| "DeferredTax" : "tNO", | |
| "TaxExemptionLetterNum" : null, | |
| "WTApplied" : 0.0, | |
| "WTAppliedFC" : 0.0, | |
| "BillOfExchangeReserved" : "tNO", | |
| "AgentCode" : null, | |
| "WTAppliedSC" : 0.0, | |
| "TotalEqualizationTax" : 0.0, | |
| "TotalEqualizationTaxFC" : 0.0, | |
| "TotalEqualizationTaxSC" : 0.0, | |
| "NumberOfInstallments" : 1, | |
| "ApplyTaxOnFirstInstallment" : "tNO", | |
| "WTNonSubjectAmount" : 0.0, | |
| "WTNonSubjectAmountSC" : 0.0, | |
| "WTNonSubjectAmountFC" : 0.0, | |
| "WTExemptedAmount" : 0.0, | |
| "WTExemptedAmountSC" : 0.0, | |
| "WTExemptedAmountFC" : 0.0, | |
| "BaseAmount" : 0.0, | |
| "BaseAmountSC" : 0.0, | |
| "BaseAmountFC" : 0.0, | |
| "WTAmount" : 0.0, | |
| "WTAmountSC" : 0.0, | |
| "WTAmountFC" : 0.0, | |
| "VatDate" : null, | |
| "DocumentsOwner" : null, | |
| "FolioPrefixString" : null, | |
| "FolioNumber" : null, | |
| "DocumentSubType" : "bod_None", | |
| "BPChannelCode" : null, | |
| "BPChannelContact" : null, | |
| "Address2" : "4417 Stonebridge Rd\rSuite 500\rNorthampton PA 18067\rUSA", | |
| "DocumentStatus" : "bost_Open", | |
| "PeriodIndicator" : "Default", | |
| "PayToCode" : "Bill To", | |
| "ManualNumber" : null, | |
| "UseShpdGoodsAct" : "tNO", | |
| "IsPayToBank" : "tNO", | |
| "PayToBankCountry" : null, | |
| "PayToBankCode" : null, | |
| "PayToBankAccountNo" : null, | |
| "PayToBankBranch" : null, | |
| "BPL_IDAssignedToInvoice" : null, | |
| "DownPayment" : 0.0, | |
| "ReserveInvoice" : "tNO", | |
| "LanguageCode" : 3, | |
| "TrackingNumber" : null, | |
| "PickRemark" : null, | |
| "ClosingDate" : null, | |
| "SequenceCode" : null, | |
| "SequenceSerial" : null, | |
| "SeriesString" : null, | |
| "SubSeriesString" : null, | |
| "SequenceModel" : "0", | |
| "UseCorrectionVATGroup" : "tNO", | |
| "TotalDiscount" : 0.0, | |
| "DownPaymentAmount" : 0.0, | |
| "DownPaymentPercentage" : 0.0, | |
| "DownPaymentType" : "dptInvoice", | |
| "DownPaymentAmountSC" : 0.0, | |
| "DownPaymentAmountFC" : 0.0, | |
| "VatPercent" : 0.0, | |
| "ServiceGrossProfitPercent" : 0.0, | |
| "OpeningRemarks" : null, | |
| "ClosingRemarks" : null, | |
| "RoundingDiffAmount" : 0.0, | |
| "RoundingDiffAmountFC" : 0.0, | |
| "RoundingDiffAmountSC" : 0.0, | |
| "Cancelled" : "tNO", | |
| "SignatureInputMessage" : null, | |
| "SignatureDigest" : null, | |
| "CertificationNumber" : null, | |
| "PrivateKeyVersion" : null, | |
| "ControlAccount" : "_SYS00000000010", | |
| "InsuranceOperation347" : "tNO", | |
| "ArchiveNonremovableSalesQuotation" : "tNO", | |
| "GTSChecker" : null, | |
| "GTSPayee" : null, | |
| "ExtraMonth" : 0, | |
| "ExtraDays" : 30, | |
| "CashDiscountDateOffset" : 0, | |
| "StartFrom" : "pdt_None", | |
| "NTSApproved" : "tNO", | |
| "ETaxWebSite" : null, | |
| "ETaxNumber" : null, | |
| "NTSApprovedNumber" : null, | |
| "EDocGenerationType" : "edocNotRelevant", | |
| "EDocSeries" : null, | |
| "EDocNum" : null, | |
| "EDocExportFormat" : null, | |
| "EDocStatus" : "edoc_Ok", | |
| "EDocErrorCode" : null, | |
| "EDocErrorMessage" : null, | |
| "DownPaymentStatus" : "so_Open", | |
| "GroupSeries" : null, | |
| "GroupNumber" : null, | |
| "GroupHandWritten" : "tNO", | |
| "ReopenOriginalDocument" : null, | |
| "ReopenManuallyClosedOrCanceledDocument" : null, | |
| "CreateOnlineQuotation" : "tNO", | |
| "POSEquipmentNumber" : null, | |
| "POSManufacturerSerialNumber" : null, | |
| "POSCashierNumber" : null, | |
| "ApplyCurrentVATRatesForDownPaymentsToDraw" : "tNO", | |
| "ClosingOption" : "coByCurrentSystemDate", | |
| "SpecifiedClosingDate" : null, | |
| "OpenForLandedCosts" : "tYES", | |
| "AuthorizationStatus" : "dasWithout", | |
| "TotalDiscountFC" : 0.0, | |
| "TotalDiscountSC" : 0.0, | |
| "RelevantToGTS" : "tNO", | |
| "BPLName" : null, | |
| "VATRegNum" : null, | |
| "AnnualInvoiceDeclarationReference" : null, | |
| "Supplier" : null, | |
| "Releaser" : null, | |
| "Receiver" : null, | |
| "BlanketAgreementNumber" : null, | |
| "IsAlteration" : "tNO", | |
| "CancelStatus" : "csNo", | |
| "AssetValueDate" : null, | |
| "DocumentDelivery" : "ddtNoneSeleted", | |
| "AuthorizationCode" : null, | |
| "StartDeliveryDate" : null, | |
| "StartDeliveryTime" : null, | |
| "EndDeliveryDate" : null, | |
| "EndDeliveryTime" : null, | |
| "VehiclePlate" : null, | |
| "ATDocumentType" : null, | |
| "ElecCommStatus" : null, | |
| "ElecCommMessage" : null, | |
| "ReuseDocumentNum" : "tNO", | |
| "ReuseNotaFiscalNum" : "tNO", | |
| "PrintSEPADirect" : "tNO", | |
| "FiscalDocNum" : null, | |
| "POSDailySummaryNo" : null, | |
| "POSReceiptNo" : null, | |
| "PointOfIssueCode" : null, | |
| "Letter" : null, | |
| "FolioNumberFrom" : null, | |
| "FolioNumberTo" : null, | |
| "InterimType" : "boidt_None", | |
| "RelatedType" : -1, | |
| "RelatedEntry" : null, | |
| "DocumentTaxID" : null, | |
| "DateOfReportingControlStatementVAT" : null, | |
| "ReportingSectionControlStatementVAT" : null, | |
| "ExcludeFromTaxReportControlStatementVAT" : "tNO", | |
| "POS_CashRegister" : null, | |
| "UpdateTime" : "10:41:41", | |
| "PriceMode" : null, | |
| "ShipFrom" : "Ship to", | |
| "CommissionTrade" : "ct_Empty", | |
| "CommissionTradeReturn" : "tNO", | |
| "UseBillToAddrToDetermineTax" : null, | |
| "Document_ApprovalRequests" : [], | |
| "DocumentLines" : [ | |
| { | |
| "LineNum" : 0, | |
| "ItemCode" : "I00001", | |
| "ItemDescription" : "Blu-Ray Disc 10-Pack", | |
| "Quantity" : 9.0, | |
| "ShipDate" : "2019-02-28", | |
| "Price" : 3.750, | |
| "PriceAfterVAT" : 3.970, | |
| "Currency" : "$", | |
| "Rate" : 0.0, | |
| "DiscountPercent" : 16.6670, | |
| "VendorNum" : null, | |
| "SerialNum" : null, | |
| "WarehouseCode" : "01", | |
| "SalesPersonCode" : -1, | |
| "CommisionPercent" : 0.0, | |
| "TreeType" : "iNotATree", | |
| "AccountCode" : "_SYS00000000081", | |
| "UseBaseUnits" : "tNO", | |
| "SupplierCatNum" : null, | |
| "CostingCode" : null, | |
| "ProjectCode" : null, | |
| "BarCode" : null, | |
| "VatGroup" : null, | |
| "Height1" : 0.0, | |
| "Hight1Unit" : null, | |
| "Height2" : 0.0, | |
| "Height2Unit" : null, | |
| "Lengh1" : 0.0, | |
| "Lengh1Unit" : null, | |
| "Lengh2" : 0.0, | |
| "Lengh2Unit" : null, | |
| "Weight1" : 0.0, | |
| "Weight1Unit" : null, | |
| "Weight2" : 0.0, | |
| "Weight2Unit" : null, | |
| "Factor1" : 1.0, | |
| "Factor2" : 1.0, | |
| "Factor3" : 1.0, | |
| "Factor4" : 1.0, | |
| "BaseType" : -1, | |
| "BaseEntry" : null, | |
| "BaseLine" : null, | |
| "Volume" : 0.0, | |
| "VolumeUnit" : 5, | |
| "Width1" : 0.0, | |
| "Width1Unit" : null, | |
| "Width2" : 0.0, | |
| "Width2Unit" : null, | |
| "Address" : null, | |
| "TaxCode" : "PA", | |
| "TaxType" : "tt_Yes", | |
| "TaxLiable" : "tYES", | |
| "PickStatus" : "tNO", | |
| "PickQuantity" : 0.0, | |
| "PickListIdNumber" : null, | |
| "OriginalItem" : null, | |
| "BackOrder" : "tYES", | |
| "FreeText" : null, | |
| "ShippingMethod" : 3, | |
| "POTargetNum" : null, | |
| "POTargetEntry" : null, | |
| "POTargetRowNum" : null, | |
| "CorrectionInvoiceItem" : "ciis_ShouldBe", | |
| "CorrInvAmountToStock" : 0.0, | |
| "CorrInvAmountToDiffAcct" : 0.0, | |
| "AppliedTax" : 0.0, | |
| "AppliedTaxFC" : 0.0, | |
| "AppliedTaxSC" : 0.0, | |
| "WTLiable" : "tNO", | |
| "DeferredTax" : "tNO", | |
| "EqualizationTaxPercent" : 0.0, | |
| "TotalEqualizationTax" : 0.0, | |
| "TotalEqualizationTaxFC" : 0.0, | |
| "TotalEqualizationTaxSC" : 0.0, | |
| "NetTaxAmount" : 2.030, | |
| "NetTaxAmountFC" : 0.0, | |
| "NetTaxAmountSC" : 2.030, | |
| "MeasureUnit" : null, | |
| "UnitsOfMeasurment" : 1.0, | |
| "LineTotal" : 33.750, | |
| "TaxPercentagePerRow" : 6.0, | |
| "TaxTotal" : 2.030, | |
| "ConsumerSalesForecast" : "tYES", | |
| "ExciseAmount" : 0.0, | |
| "TaxPerUnit" : 0.0, | |
| "TotalInclTax" : 0.0, | |
| "CountryOrg" : null, | |
| "SWW" : null, | |
| "TransactionType" : null, | |
| "DistributeExpense" : "tYES", | |
| "ShipToCode" : "Ship to", | |
| "RowTotalFC" : 0.0, | |
| "RowTotalSC" : 33.750, | |
| "LastBuyInmPrice" : 0.0, | |
| "LastBuyDistributeSumFc" : 0.0, | |
| "LastBuyDistributeSumSc" : 0.0, | |
| "LastBuyDistributeSum" : 0.0, | |
| "StockDistributesumForeign" : 0.0, | |
| "StockDistributesumSystem" : 0.0, | |
| "StockDistributesum" : 0.0, | |
| "StockInmPrice" : 0.0, | |
| "PickStatusEx" : "dlps_NotPicked", | |
| "TaxBeforeDPM" : 0.0, | |
| "TaxBeforeDPMFC" : 0.0, | |
| "TaxBeforeDPMSC" : 0.0, | |
| "CFOPCode" : null, | |
| "CSTCode" : null, | |
| "Usage" : null, | |
| "TaxOnly" : "tNO", | |
| "VisualOrder" : 0, | |
| "BaseOpenQuantity" : 0.0, | |
| "UnitPrice" : 4.50, | |
| "LineStatus" : "bost_Open", | |
| "PackageQuantity" : 9.0, | |
| "Text" : null, | |
| "LineType" : "dlt_Regular", | |
| "COGSCostingCode" : null, | |
| "COGSAccountCode" : "_SYS00000000088", | |
| "ChangeAssemlyBoMWarehouse" : "N", | |
| "GrossBuyPrice" : 2.180, | |
| "GrossBase" : -5, | |
| "GrossProfitTotalBasePrice" : 19.650, | |
| "CostingCode2" : null, | |
| "CostingCode3" : null, | |
| "CostingCode4" : null, | |
| "CostingCode5" : null, | |
| "ItemDetails" : "", | |
| "LocationCode" : null, | |
| "ActualDeliveryDate" : null, | |
| "RemainingOpenQuantity" : 9.0, | |
| "OpenAmount" : 33.750, | |
| "OpenAmountFC" : 0.0, | |
| "OpenAmountSC" : 33.750, | |
| "ExLineNo" : null, | |
| "RequiredDate" : null, | |
| "RequiredQuantity" : 0.0, | |
| "COGSCostingCode2" : null, | |
| "COGSCostingCode3" : null, | |
| "COGSCostingCode4" : null, | |
| "COGSCostingCode5" : null, | |
| "CSTforIPI" : null, | |
| "CSTforPIS" : null, | |
| "CSTforCOFINS" : null, | |
| "CreditOriginCode" : null, | |
| "WithoutInventoryMovement" : "tNO", | |
| "AgreementNo" : null, | |
| "AgreementRowNumber" : null, | |
| "ShipToDescription" : "4417 Stonebridge Rd\rSuite 500\rNorthampton PA 18067\rUSA", | |
| "ActualBaseEntry" : null, | |
| "ActualBaseLine" : null, | |
| "DocEntry" : 1228, | |
| "Surpluses" : 0.0, | |
| "DefectAndBreakup" : 0.0, | |
| "Shortages" : 0.0, | |
| "ConsiderQuantity" : "tNO", | |
| "PartialRetirement" : "tNO", | |
| "RetirementQuantity" : 0.0, | |
| "RetirementAPC" : 0.0, | |
| "ThirdParty" : "tNO", | |
| "ExpenseType" : null, | |
| "ReceiptNumber" : null, | |
| "ExpenseOperationType" : null, | |
| "FederalTaxID" : null, | |
| "StgSeqNum" : null, | |
| "StgEntry" : null, | |
| "StgDesc" : null, | |
| "UoMEntry" : -1, | |
| "UoMCode" : "Manual", | |
| "InventoryQuantity" : 9.0, | |
| "RemainingOpenInventoryQuantity" : 9.0, | |
| "ParentLineNum" : null, | |
| "Incoterms" : 0, | |
| "TransportMode" : 0, | |
| "ItemType" : "dit_Item", | |
| "ChangeInventoryQuantityIndependently" : "tNO", | |
| "FreeOfChargeBP" : "tNO", | |
| "SACEntry" : null, | |
| "HSNEntry" : null, | |
| "GrossPrice" : 4.770, | |
| "GrossTotal" : 35.730, | |
| "GrossTotalFC" : 0.0, | |
| "GrossTotalSC" : 35.730, | |
| "NCMCode" : -1, | |
| "LineTaxJurisdictions" : [ | |
| { | |
| "JurisdictionCode" : "PA", | |
| "JurisdictionType" : -3, | |
| "TaxAmount" : 2.030, | |
| "TaxAmountSC" : 2.030, | |
| "TaxAmountFC" : 0.0, | |
| "TaxRate" : 6.0, | |
| "DocEntry" : 1228, | |
| "LineNumber" : 0, | |
| "RowSequence" : 0 | |
| } | |
| ], | |
| "DocumentLineAdditionalExpenses" : [], | |
| "WithholdingTaxLines" : [], | |
| "SerialNumbers" : [], | |
| "BatchNumbers" : [], | |
| "DocumentLinesBinAllocations" : [] | |
| }, | |
| { | |
| "LineNum" : 1, | |
| "ItemCode" : "I00002", | |
| "ItemDescription" : "Blu-Ray DL Disc 10-Pack", | |
| "Quantity" : 7.0, | |
| "ShipDate" : "2019-02-28", | |
| "Price" : 15.0, | |
| "PriceAfterVAT" : 15.90, | |
| "Currency" : "$", | |
| "Rate" : 0.0, | |
| "DiscountPercent" : 16.6670, | |
| "VendorNum" : null, | |
| "SerialNum" : null, | |
| "WarehouseCode" : "01", | |
| "SalesPersonCode" : -1, | |
| "CommisionPercent" : 0.0, | |
| "TreeType" : "iNotATree", | |
| "AccountCode" : "_SYS00000000081", | |
| "UseBaseUnits" : "tNO", | |
| "SupplierCatNum" : null, | |
| "CostingCode" : null, | |
| "ProjectCode" : null, | |
| "BarCode" : null, | |
| "VatGroup" : null, | |
| "Height1" : 0.0, | |
| "Hight1Unit" : null, | |
| "Height2" : 0.0, | |
| "Height2Unit" : null, | |
| "Lengh1" : 0.0, | |
| "Lengh1Unit" : null, | |
| "Lengh2" : 0.0, | |
| "Lengh2Unit" : null, | |
| "Weight1" : 0.0, | |
| "Weight1Unit" : null, | |
| "Weight2" : 0.0, | |
| "Weight2Unit" : null, | |
| "Factor1" : 1.0, | |
| "Factor2" : 1.0, | |
| "Factor3" : 1.0, | |
| "Factor4" : 1.0, | |
| "BaseType" : -1, | |
| "BaseEntry" : null, | |
| "BaseLine" : null, | |
| "Volume" : 0.0, | |
| "VolumeUnit" : 5, | |
| "Width1" : 0.0, | |
| "Width1Unit" : null, | |
| "Width2" : 0.0, | |
| "Width2Unit" : null, | |
| "Address" : null, | |
| "TaxCode" : "PA", | |
| "TaxType" : "tt_Yes", | |
| "TaxLiable" : "tYES", | |
| "PickStatus" : "tNO", | |
| "PickQuantity" : 0.0, | |
| "PickListIdNumber" : null, | |
| "OriginalItem" : null, | |
| "BackOrder" : "tYES", | |
| "FreeText" : null, | |
| "ShippingMethod" : 3, | |
| "POTargetNum" : null, | |
| "POTargetEntry" : null, | |
| "POTargetRowNum" : null, | |
| "CorrectionInvoiceItem" : "ciis_ShouldBe", | |
| "CorrInvAmountToStock" : 0.0, | |
| "CorrInvAmountToDiffAcct" : 0.0, | |
| "AppliedTax" : 0.0, | |
| "AppliedTaxFC" : 0.0, | |
| "AppliedTaxSC" : 0.0, | |
| "WTLiable" : "tNO", | |
| "DeferredTax" : "tNO", | |
| "EqualizationTaxPercent" : 0.0, | |
| "TotalEqualizationTax" : 0.0, | |
| "TotalEqualizationTaxFC" : 0.0, | |
| "TotalEqualizationTaxSC" : 0.0, | |
| "NetTaxAmount" : 6.30, | |
| "NetTaxAmountFC" : 0.0, | |
| "NetTaxAmountSC" : 6.30, | |
| "MeasureUnit" : null, | |
| "UnitsOfMeasurment" : 1.0, | |
| "LineTotal" : 105.0, | |
| "TaxPercentagePerRow" : 6.0, | |
| "TaxTotal" : 6.30, | |
| "ConsumerSalesForecast" : "tYES", | |
| "ExciseAmount" : 0.0, | |
| "TaxPerUnit" : 0.0, | |
| "TotalInclTax" : 0.0, | |
| "CountryOrg" : null, | |
| "SWW" : null, | |
| "TransactionType" : null, | |
| "DistributeExpense" : "tYES", | |
| "ShipToCode" : "Ship to", | |
| "RowTotalFC" : 0.0, | |
| "RowTotalSC" : 105.0, | |
| "LastBuyInmPrice" : 0.0, | |
| "LastBuyDistributeSumFc" : 0.0, | |
| "LastBuyDistributeSumSc" : 0.0, | |
| "LastBuyDistributeSum" : 0.0, | |
| "StockDistributesumForeign" : 0.0, | |
| "StockDistributesumSystem" : 0.0, | |
| "StockDistributesum" : 0.0, | |
| "StockInmPrice" : 0.0, | |
| "PickStatusEx" : "dlps_NotPicked", | |
| "TaxBeforeDPM" : 0.0, | |
| "TaxBeforeDPMFC" : 0.0, | |
| "TaxBeforeDPMSC" : 0.0, | |
| "CFOPCode" : null, | |
| "CSTCode" : null, | |
| "Usage" : null, | |
| "TaxOnly" : "tNO", | |
| "VisualOrder" : 1, | |
| "BaseOpenQuantity" : 0.0, | |
| "UnitPrice" : 18.0, | |
| "LineStatus" : "bost_Open", | |
| "PackageQuantity" : 7.0, | |
| "Text" : null, | |
| "LineType" : "dlt_Regular", | |
| "COGSCostingCode" : null, | |
| "COGSAccountCode" : "_SYS00000000088", | |
| "ChangeAssemlyBoMWarehouse" : "N", | |
| "GrossBuyPrice" : 8.650, | |
| "GrossBase" : -5, | |
| "GrossProfitTotalBasePrice" : 60.530, | |
| "CostingCode2" : null, | |
| "CostingCode3" : null, | |
| "CostingCode4" : null, | |
| "CostingCode5" : null, | |
| "ItemDetails" : "", | |
| "LocationCode" : null, | |
| "ActualDeliveryDate" : null, | |
| "RemainingOpenQuantity" : 7.0, | |
| "OpenAmount" : 105.0, | |
| "OpenAmountFC" : 0.0, | |
| "OpenAmountSC" : 105.0, | |
| "ExLineNo" : null, | |
| "RequiredDate" : null, | |
| "RequiredQuantity" : 0.0, | |
| "COGSCostingCode2" : null, | |
| "COGSCostingCode3" : null, | |
| "COGSCostingCode4" : null, | |
| "COGSCostingCode5" : null, | |
| "CSTforIPI" : null, | |
| "CSTforPIS" : null, | |
| "CSTforCOFINS" : null, | |
| "CreditOriginCode" : null, | |
| "WithoutInventoryMovement" : "tNO", | |
| "AgreementNo" : null, | |
| "AgreementRowNumber" : null, | |
| "ShipToDescription" : "4417 Stonebridge Rd\rSuite 500\rNorthampton PA 18067\rUSA", | |
| "ActualBaseEntry" : null, | |
| "ActualBaseLine" : null, | |
| "DocEntry" : 1228, | |
| "Surpluses" : 0.0, | |
| "DefectAndBreakup" : 0.0, | |
| "Shortages" : 0.0, | |
| "ConsiderQuantity" : "tNO", | |
| "PartialRetirement" : "tNO", | |
| "RetirementQuantity" : 0.0, | |
| "RetirementAPC" : 0.0, | |
| "ThirdParty" : "tNO", | |
| "ExpenseType" : null, | |
| "ReceiptNumber" : null, | |
| "ExpenseOperationType" : null, | |
| "FederalTaxID" : null, | |
| "StgSeqNum" : null, | |
| "StgEntry" : null, | |
| "StgDesc" : null, | |
| "UoMEntry" : -1, | |
| "UoMCode" : "Manual", | |
| "InventoryQuantity" : 7.0, | |
| "RemainingOpenInventoryQuantity" : 7.0, | |
| "ParentLineNum" : null, | |
| "Incoterms" : 0, | |
| "TransportMode" : 0, | |
| "ItemType" : "dit_Item", | |
| "ChangeInventoryQuantityIndependently" : "tNO", | |
| "FreeOfChargeBP" : "tNO", | |
| "SACEntry" : null, | |
| "HSNEntry" : null, | |
| "GrossPrice" : 19.080, | |
| "GrossTotal" : 111.30, | |
| "GrossTotalFC" : 0.0, | |
| "GrossTotalSC" : 111.30, | |
| "NCMCode" : -1, | |
| "LineTaxJurisdictions" : [ | |
| { | |
| "JurisdictionCode" : "PA", | |
| "JurisdictionType" : -3, | |
| "TaxAmount" : 6.30, | |
| "TaxAmountSC" : 6.30, | |
| "TaxAmountFC" : 0.0, | |
| "TaxRate" : 6.0, | |
| "DocEntry" : 1228, | |
| "LineNumber" : 1, | |
| "RowSequence" : 1 | |
| } | |
| ], | |
| "DocumentLineAdditionalExpenses" : [], | |
| "WithholdingTaxLines" : [], | |
| "SerialNumbers" : [], | |
| "BatchNumbers" : [], | |
| "DocumentLinesBinAllocations" : [] | |
| }, | |
| { | |
| "LineNum" : 2, | |
| "ItemCode" : "I00003", | |
| "ItemDescription" : "USB Flashdrive 128GB", | |
| "Quantity" : 10.0, | |
| "ShipDate" : "2019-02-28", | |
| "Price" : 25.0, | |
| "PriceAfterVAT" : 26.50, | |
| "Currency" : "$", | |
| "Rate" : 0.0, | |
| "DiscountPercent" : 16.6670, | |
| "VendorNum" : null, | |
| "SerialNum" : null, | |
| "WarehouseCode" : "01", | |
| "SalesPersonCode" : -1, | |
| "CommisionPercent" : 0.0, | |
| "TreeType" : "iNotATree", | |
| "AccountCode" : "_SYS00000000081", | |
| "UseBaseUnits" : "tNO", | |
| "SupplierCatNum" : null, | |
| "CostingCode" : null, | |
| "ProjectCode" : null, | |
| "BarCode" : null, | |
| "VatGroup" : null, | |
| "Height1" : 0.0, | |
| "Hight1Unit" : null, | |
| "Height2" : 0.0, | |
| "Height2Unit" : null, | |
| "Lengh1" : 0.0, | |
| "Lengh1Unit" : null, | |
| "Lengh2" : 0.0, | |
| "Lengh2Unit" : null, | |
| "Weight1" : 0.0, | |
| "Weight1Unit" : null, | |
| "Weight2" : 0.0, | |
| "Weight2Unit" : null, | |
| "Factor1" : 1.0, | |
| "Factor2" : 1.0, | |
| "Factor3" : 1.0, | |
| "Factor4" : 1.0, | |
| "BaseType" : -1, | |
| "BaseEntry" : null, | |
| "BaseLine" : null, | |
| "Volume" : 0.0, | |
| "VolumeUnit" : 5, | |
| "Width1" : 0.0, | |
| "Width1Unit" : null, | |
| "Width2" : 0.0, | |
| "Width2Unit" : null, | |
| "Address" : null, | |
| "TaxCode" : "PA", | |
| "TaxType" : "tt_Yes", | |
| "TaxLiable" : "tYES", | |
| "PickStatus" : "tNO", | |
| "PickQuantity" : 0.0, | |
| "PickListIdNumber" : null, | |
| "OriginalItem" : null, | |
| "BackOrder" : "tYES", | |
| "FreeText" : null, | |
| "ShippingMethod" : 3, | |
| "POTargetNum" : null, | |
| "POTargetEntry" : null, | |
| "POTargetRowNum" : null, | |
| "CorrectionInvoiceItem" : "ciis_ShouldBe", | |
| "CorrInvAmountToStock" : 0.0, | |
| "CorrInvAmountToDiffAcct" : 0.0, | |
| "AppliedTax" : 0.0, | |
| "AppliedTaxFC" : 0.0, | |
| "AppliedTaxSC" : 0.0, | |
| "WTLiable" : "tNO", | |
| "DeferredTax" : "tNO", | |
| "EqualizationTaxPercent" : 0.0, | |
| "TotalEqualizationTax" : 0.0, | |
| "TotalEqualizationTaxFC" : 0.0, | |
| "TotalEqualizationTaxSC" : 0.0, | |
| "NetTaxAmount" : 15.0, | |
| "NetTaxAmountFC" : 0.0, | |
| "NetTaxAmountSC" : 15.0, | |
| "MeasureUnit" : null, | |
| "UnitsOfMeasurment" : 1.0, | |
| "LineTotal" : 250.0, | |
| "TaxPercentagePerRow" : 6.0, | |
| "TaxTotal" : 15.0, | |
| "ConsumerSalesForecast" : "tYES", | |
| "ExciseAmount" : 0.0, | |
| "TaxPerUnit" : 0.0, | |
| "TotalInclTax" : 0.0, | |
| "CountryOrg" : null, | |
| "SWW" : null, | |
| "TransactionType" : null, | |
| "DistributeExpense" : "tYES", | |
| "ShipToCode" : "Ship to", | |
| "RowTotalFC" : 0.0, | |
| "RowTotalSC" : 250.0, | |
| "LastBuyInmPrice" : 0.0, | |
| "LastBuyDistributeSumFc" : 0.0, | |
| "LastBuyDistributeSumSc" : 0.0, | |
| "LastBuyDistributeSum" : 0.0, | |
| "StockDistributesumForeign" : 0.0, | |
| "StockDistributesumSystem" : 0.0, | |
| "StockDistributesum" : 0.0, | |
| "StockInmPrice" : 0.0, | |
| "PickStatusEx" : "dlps_NotPicked", | |
| "TaxBeforeDPM" : 0.0, | |
| "TaxBeforeDPMFC" : 0.0, | |
| "TaxBeforeDPMSC" : 0.0, | |
| "CFOPCode" : null, | |
| "CSTCode" : null, | |
| "Usage" : null, | |
| "TaxOnly" : "tNO", | |
| "VisualOrder" : 2, | |
| "BaseOpenQuantity" : 0.0, | |
| "UnitPrice" : 30.0, | |
| "LineStatus" : "bost_Open", | |
| "PackageQuantity" : 10.0, | |
| "Text" : null, | |
| "LineType" : "dlt_Regular", | |
| "COGSCostingCode" : null, | |
| "COGSAccountCode" : "_SYS00000000088", | |
| "ChangeAssemlyBoMWarehouse" : "N", | |
| "GrossBuyPrice" : 14.670, | |
| "GrossBase" : -5, | |
| "GrossProfitTotalBasePrice" : 146.70, | |
| "CostingCode2" : null, | |
| "CostingCode3" : null, | |
| "CostingCode4" : null, | |
| "CostingCode5" : null, | |
| "ItemDetails" : "", | |
| "LocationCode" : null, | |
| "ActualDeliveryDate" : null, | |
| "RemainingOpenQuantity" : 10.0, | |
| "OpenAmount" : 250.0, | |
| "OpenAmountFC" : 0.0, | |
| "OpenAmountSC" : 250.0, | |
| "ExLineNo" : null, | |
| "RequiredDate" : null, | |
| "RequiredQuantity" : 0.0, | |
| "COGSCostingCode2" : null, | |
| "COGSCostingCode3" : null, | |
| "COGSCostingCode4" : null, | |
| "COGSCostingCode5" : null, | |
| "CSTforIPI" : null, | |
| "CSTforPIS" : null, | |
| "CSTforCOFINS" : null, | |
| "CreditOriginCode" : null, | |
| "WithoutInventoryMovement" : "tNO", | |
| "AgreementNo" : null, | |
| "AgreementRowNumber" : null, | |
| "ShipToDescription" : "4417 Stonebridge Rd\rSuite 500\rNorthampton PA 18067\rUSA", | |
| "ActualBaseEntry" : null, | |
| "ActualBaseLine" : null, | |
| "DocEntry" : 1228, | |
| "Surpluses" : 0.0, | |
| "DefectAndBreakup" : 0.0, | |
| "Shortages" : 0.0, | |
| "ConsiderQuantity" : "tNO", | |
| "PartialRetirement" : "tNO", | |
| "RetirementQuantity" : 0.0, | |
| "RetirementAPC" : 0.0, | |
| "ThirdParty" : "tNO", | |
| "ExpenseType" : null, | |
| "ReceiptNumber" : null, | |
| "ExpenseOperationType" : null, | |
| "FederalTaxID" : null, | |
| "StgSeqNum" : null, | |
| "StgEntry" : null, | |
| "StgDesc" : null, | |
| "UoMEntry" : -1, | |
| "UoMCode" : "Manual", | |
| "InventoryQuantity" : 10.0, | |
| "RemainingOpenInventoryQuantity" : 10.0, | |
| "ParentLineNum" : null, | |
| "Incoterms" : 0, | |
| "TransportMode" : 0, | |
| "ItemType" : "dit_Item", | |
| "ChangeInventoryQuantityIndependently" : "tNO", | |
| "FreeOfChargeBP" : "tNO", | |
| "SACEntry" : null, | |
| "HSNEntry" : null, | |
| "GrossPrice" : 31.80, | |
| "GrossTotal" : 265.0, | |
| "GrossTotalFC" : 0.0, | |
| "GrossTotalSC" : 265.0, | |
| "NCMCode" : -1, | |
| "LineTaxJurisdictions" : [ | |
| { | |
| "JurisdictionCode" : "PA", | |
| "JurisdictionType" : -3, | |
| "TaxAmount" : 15.0, | |
| "TaxAmountSC" : 15.0, | |
| "TaxAmountFC" : 0.0, | |
| "TaxRate" : 6.0, | |
| "DocEntry" : 1228, | |
| "LineNumber" : 2, | |
| "RowSequence" : 2 | |
| } | |
| ], | |
| "DocumentLineAdditionalExpenses" : [], | |
| "WithholdingTaxLines" : [], | |
| "SerialNumbers" : [], | |
| "BatchNumbers" : [], | |
| "DocumentLinesBinAllocations" : [] | |
| } | |
| ], | |
| "DocumentAdditionalExpenses" : [], | |
| "WithholdingTaxDataWTXCollection" : [], | |
| "WithholdingTaxDataCollection" : [], | |
| "DocumentSpecialLines" : [], | |
| "TaxExtension" : { | |
| "TaxId0" : null, | |
| "TaxId1" : null, | |
| "TaxId2" : null, | |
| "TaxId3" : null, | |
| "TaxId4" : null, | |
| "TaxId5" : null, | |
| "TaxId6" : null, | |
| "TaxId7" : null, | |
| "TaxId8" : null, | |
| "TaxId9" : null, | |
| "State" : null, | |
| "County" : null, | |
| "Incoterms" : null, | |
| "Vehicle" : null, | |
| "VehicleState" : null, | |
| "NFRef" : null, | |
| "Carrier" : null, | |
| "PackQuantity" : null, | |
| "PackDescription" : null, | |
| "Brand" : null, | |
| "ShipUnitNo" : null, | |
| "NetWeight" : 0.0, | |
| "GrossWeight" : 0.0, | |
| "StreetS" : "4417 Stonebridge Rd", | |
| "BlockS" : "Suite 500", | |
| "BuildingS" : "", | |
| "CityS" : "Northampton", | |
| "ZipCodeS" : "18067", | |
| "CountyS" : "Northampton County", | |
| "StateS" : "PA", | |
| "CountryS" : "US", | |
| "StreetB" : "4417 Stonebridge Rd", | |
| "BlockB" : "Suite 500", | |
| "BuildingB" : "", | |
| "CityB" : "Northampton", | |
| "ZipCodeB" : "18067", | |
| "CountyB" : "Northampton County", | |
| "StateB" : "PA", | |
| "CountryB" : "US", | |
| "ImportOrExport" : null, | |
| "MainUsage" : null, | |
| "GlobalLocationNumberS" : null, | |
| "GlobalLocationNumberB" : null, | |
| "TaxId12" : null, | |
| "TaxId13" : null, | |
| "BillOfEntryNo" : null, | |
| "BillOfEntryDate" : null, | |
| "OriginalBillOfEntryNo" : null, | |
| "OriginalBillOfEntryDate" : null, | |
| "ImportOrExportType" : "et_IpmortsOrExports", | |
| "PortCode" : null | |
| }, | |
| "AddressExtension" : { | |
| "ShipToStreet" : "4417 Stonebridge Rd", | |
| "ShipToStreetNo" : null, | |
| "ShipToBlock" : "Suite 500", | |
| "ShipToBuilding" : "", | |
| "ShipToCity" : "Northampton", | |
| "ShipToZipCode" : "18067", | |
| "ShipToCounty" : "Northampton County", | |
| "ShipToState" : "PA", | |
| "ShipToCountry" : "US", | |
| "ShipToAddressType" : null, | |
| "BillToStreet" : "4417 Stonebridge Rd", | |
| "BillToStreetNo" : null, | |
| "BillToBlock" : "Suite 500", | |
| "BillToBuilding" : "", | |
| "BillToCity" : "Northampton", | |
| "BillToZipCode" : "18067", | |
| "BillToCounty" : "Northampton County", | |
| "BillToState" : "PA", | |
| "BillToCountry" : "US", | |
| "BillToAddressType" : null, | |
| "ShipToGlobalLocationNumber" : null, | |
| "BillToGlobalLocationNumber" : null, | |
| "ShipToAddress2" : null, | |
| "ShipToAddress3" : null, | |
| "BillToAddress2" : null, | |
| "BillToAddress3" : null, | |
| "PlaceOfSupply" : null | |
| } | |
| } | |
| </code> | |
| |
