User Defined Fields on SAP Business One tables


Table ACRD

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_CARISBO:Alpha1'C'
NULL => NULL
'C' => 'Take setting from company'
'N' => 'No'
'Y' => 'Yes'
Check to add returnable items
U_PMX_DFCUSBO:Alpha3Default Currency
U_PMX_DLCASBO:Alpha50Default log. car.
U_PMX_EPNRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Enter specific pallet nr.?
U_PMX_GPDLSBO:Alpha1'C'
NULL => NULL
'C' => 'Take setting from company'
'Y' => 'Group delivery'
'N' => 'Do not group delivery'
Group purchase delivery to 1 delivery
U_PMX_GSDLSBO:Alpha1'C'
NULL => NULL
'C' => 'Take setting from company'
'Y' => 'Group delivery'
'N' => 'Do not group delivery'
Group sales delivery to 1 delivery
U_PMX_ILURSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Has no identical logistic units?
U_PMX_LBPASBO:Alpha15Linked business partner
U_PMX_LCARSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Has no logistic carriers at reception?
U_PMX_LLSRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Has no labels at reception?
U_PMX_MPORSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Never delivers mixed logistic units?
U_PMX_PLTYSBO:Alpha50Pick list type
U_PMX_PPTYSBO:Alpha3'P'
NULL => NULL
'P' => 'Pallet'
'MP' => 'Multiple Pallet'
'PMC' => 'Pallet - Multiple Carton'
'ASK' => 'Ask user'
Pallet packing type
U_PMX_SPRMSBO:MemoSales/purchase remark
U_PMX_SPRPSBO:Alpha1<no default>
NULL => NULL
'Y' => 'True'
'N' => 'False'
Show sales/purchase remark pop-up

Table ADO1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table ADO7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table ADOC

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table AITM

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PIPSBO:Float, Price1963PL inbound price per inventory unit
U_PMX_3POPSBO:Float, Price1963PL outbound price per inventory unit
U_PMX_ALUSSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Auto. oplijning selectie
U_PMX_AMBSSBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches on sales document
U_PMX_APDPSBO:Numeric100'0'The allowed deviation for production (Percentage)
U_PMX_APPPSBO:Numeric100'0'The additional quantity picking for production (Percentage)
U_PMX_AQILSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Ask quantity on item label printing?
U_PMX_ASLASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow stock to be locked in advance?
U_PMX_BCTYSBO:Alpha1'G'
NULL => NULL
'F' => 'Free'
'G' => 'GTIN'
'V' => 'Variable GTIN'
Barcode type
U_PMX_BUPQSBO:Float, Quantity196Bulk pick qty
U_PMX_CSORSBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Requires creation SSSC on reception?
U_PMX_CSU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Correct stock uom2?
U_PMX_CSUMSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Correct stock uom?
U_PMX_CUDESBO:Alpha254Custom item descr. Updated automatically!
U_PMX_CWQCSBO:Float, Quantity196'0'Quantity in case (catch weight)
U_PMX_CWSCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Scan weight for each case? (Catch weight)
U_PMX_CWTOSBO:Float, [%]196'0'Tolerance (%) for catch weight
U_PMX_DLCPSBO:Alpha50Default logistic carrier production
U_PMX_DLCSSBO:Alpha50Default logistic carrier picking
U_PMX_DPQTSBO:Float, Quantity196The default production quantity
U_PMX_DQLUSBO:Float, Quantity196Default qty on log. unit
U_PMX_DQU2SBO:Float, Quantity196Def qty in Uom2
U_PMX_DQUMSBO:Float, Quantity196Def weight for piece
U_PMX_ESQMSBO:Float, Quantity196The estimated sales quantity by month (replenishment)
U_PMX_EXDPSBO:Alpha50Expiry def. for production
U_PMX_EXDRSBO:Alpha50Expiry def. for reception
U_PMX_FSNCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Force serial number scanning during cycle count?
U_PMX_HBBDSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Article with Best Before Date?
U_PMX_HBN2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Has second batch number?
U_PMX_HNVASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Does the item have no value?
U_PMX_HSERSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Article with serial number?
U_PMX_ICAWSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is catch weight item?
U_PMX_ICRISBO:Alpha50Article code not inv.ret.item
U_PMX_ILRCSBO:Numeric100Label report # copies
U_PMX_ILRPSBO:Numeric100Label report key
U_PMX_ISLTSBO:Alpha50Item location type
U_PMX_LOCASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is article logistic carrier?
U_PMX_LOUNSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is article logistic unit?
U_PMX_LSPTSBO:Alpha8Lowest sellable packaging type
U_PMX_NIOPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Add non inventory item on pick list?
U_PMX_NRSNSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Needs reason for return?
U_PMX_NRSRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Needs reason for sales return?
U_PMX_PBCOSBO:Alpha16Purchase barcode
U_PMX_PBCTSBO:Alpha1'G'
NULL => NULL
'F' => 'Free'
'G' => 'GTIN'
'V' => 'Variable GTIN'
Purchase barcode type
U_PMX_PCPUSBO:Alpha1'P'
NULL => NULL
'P' => 'Price by pieces'
'W' => 'Price by weight'
Price calculation for purchase
U_PMX_PCSASBO:Alpha1'P'
NULL => NULL
'P' => 'Price by pieces'
'W' => 'Price by weight'
Price calculation for sales
U_PMX_PIBPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Print item labels by packaging type?
U_PMX_PILPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Print label during picking?
U_PMX_PILRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Print label at reception?
U_PMX_PIMGSBO:Alpha, [I]200Packing image
U_PMX_PITYSBO:Alpha50Pick Type
U_PMX_PREMSBO:MemoPacking remarks
U_PMX_PRMRSBO:MemoProduction remarks
U_PMX_PRWDSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Record weight details during picking?
U_PMX_PTY2SBO:Alpha50Pick Type 2
U_PMX_PURMSBO:MemoPurchase remark
U_PMX_PURPSBO:Alpha1<no default>
NULL => NULL
'Y' => 'True'
'N' => 'False'
Show purchase remark pop-up
U_PMX_QSCRSBO:Alpha8Quarantined quality status reception
U_PMX_QSPRSBO:Alpha8Quality status Production
U_PMX_QSRCSBO:Alpha8Quality status reception controller
U_PMX_QSSRSBO:Alpha8Quality stat. sal.return
U_PMX_RETRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is article returnable item?
U_PMX_RQPLSBO:Float, Quantity196The quantity on pick locations (replenishment)
U_PMX_RQSRSBO:Alpha8Released quality status reception
U_PMX_SARMSBO:MemoSales remark
U_PMX_SARPSBO:Alpha1<no default>
NULL => NULL
'Y' => 'True'
'N' => 'False'
Show sales remark pop-up
U_PMX_SBCOSBO:Alpha16Sales barcode
U_PMX_SBCPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Scan base component?
U_PMX_SBCTSBO:Alpha1'G'
NULL => NULL
'F' => 'Free'
'G' => 'GTIN'
'V' => 'Variable GTIN'
Sales barcode type
U_PMX_SEVESBO:Alpha8Seveso class code
U_PMX_SLDRSBO:Numeric100'0'Reception: Shelf life of article in days
U_PMX_SLIDSBO:Numeric100'0'Shelf life of article in days
U_PMX_SNFOSBO:Alpha50Serial number format
U_PMX_SQTYSBO:Float, Quantity196Sample quantity
U_PMX_TLSNSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Track location serial number?
U_PMX_U2MTSBO:Alpha8'31'
NULL => NULL
'37' => 'Count'
'31' => 'Net weight kilo'
'32' => 'Net weight pound'
GS1 Type for uom2
U_PMX_UFTRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Use for time registration?
U_PMX_UM2DSBO:Numeric100'0'Uom2 decimals
U_PMX_UMITSBO:Alpha1'1'
NULL => NULL
'1' => 'Pieces (UOM1)'
'2' => 'Weight (UOM2)'
'A' => 'UOM1 and UOM2'
Uom For Inv. Trans.
U_PMX_UMMTSBO:Alpha8'37'
NULL => NULL
'37' => 'Count'
'31' => 'Net weight kilo'
'32' => 'Net weight pound'
GS1 Type for uom
U_PMX_UMPUSBO:Alpha1'1'
NULL => NULL
'1' => 'Pieces (UOM1)'
'2' => 'Weight (UOM2)'
'A' => 'UOM1 and UOM2'
Uom For purchase
U_PMX_UMSASBO:Alpha1'1'
NULL => NULL
'1' => 'Pieces (UOM1)'
'2' => 'Weight (UOM2)'
'A' => 'UOM1 and UOM2'
Uom For Sales
U_PMX_UOM2SBO:Alpha8Uom2
U_PMX_UOMDSBO:Numeric100'0'Uom decimals
U_PMX_UWAFSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Use in WA functionality?
U_PMX_VIDESBO:Alpha100Vendor item descr.
U_PMX_WCRESBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Weight capture needed during reception?
U_PMX_WOSTSBO:Alpha1'O'
NULL => NULL
'O' => 'ByOrder'
'I' => 'ByItem'
Weigh Order Strategy

Table AITT

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_SNMMSBO:Alpha1'N'
NULL => NULL
'N' => 'None'
'P' => 'Pool'
Serial number management method

Table AITW

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_UOM2QTY_AVSBO:Alpha20UOM2 qty available
U_PMX_UOM2QTY_CFSBO:Alpha20UOM2 qty confirmed
U_PMX_UOM2QTY_ORSBO:Alpha20UOM2 qty ordered
U_PMX_UOM2QTY_WHSBO:Alpha20UOM2 qty warehouse

Table AMR1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_PRPWSBO:Float, Price196Price by weight

Table AMR3

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_PRPWSBO:Float, Price196Price by weight

Table APLN

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_SALDOC_DEFSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Default in Sales Line Detail Form
U_PMX_SALDOC_VISSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Visible in Sales Line Detail Form
U_PMX_UOM2PRICEUDFSBO:Alpha20UOM2 Item Price UDF
U_PMX_UOM2PRUD_UDFSBO:Alpha20UOM2 Item Price update date UDF
U_PMX_VALIDFROM_UDFSBO:Alpha20Pricelist valid from UDF
U_PMX_VALIDTILL_UDFSBO:Alpha20Pricelist valid till UDF

Table ARSC

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_UFTRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Use for time registration

Table ATT1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_APLUSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow to pick for line up?
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDOSBO:Alpha1'D'
NULL => NULL
'D' => 'Due date and shelf life'
'P' => 'Pick date'
'B' => 'Beste before date of finished product and shelf life'
Best before date option
U_PMX_BCMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is base component?
U_PMX_HBLUSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Has to be lined up?
U_PMX_OPTISBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the item optional?
U_PMX_OWORSTARTCONDSBO:Alpha1'N'
NULL => NULL
'N' => 'No condition'
'Q' => 'Component part. weighed'
'W' => 'Component weighed'
Prod. order start condition
U_PMX_QTYTOLPCTSBO:Float, [%]196Qty tolerance %
U_PMX_WENESBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Weighing needed?
U_PMX_WOBQSBO:Numeric100Weigh order batch quantity

Table AUSR

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_LANGSBO:Numeric100Language
U_PMX_USGRSBO:Alpha50Pmx User group

Table AWHS

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_IMBPSBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is managed by Produmex?
U_PMX_ITWHSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is transit WHS?

Table AWO1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_APLUSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow to pick for line up?
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDOSBO:Alpha1'D'
NULL => NULL
'D' => 'Due date and shelf life'
'P' => 'Pick date'
'B' => 'Beste before date of finished product and shelf life'
Best before date option
U_PMX_BTPKSBO:MemoBatch(es) to pick
U_PMX_HBLUSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Has to be lined up?
U_PMX_OPTISBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the item optional?
U_PMX_OWORSTARTCONDSBO:Alpha1<no default>
NULL => NULL
'N' => 'No condition'
'Q' => 'Component part. weighed'
'W' => 'Component weighed'
Prod. order start condition
U_PMX_QTYPSBO:Float, Quantity196Quantity Picked
U_PMX_QTYTOLPCTSBO:Float, [%]196Qty tolerance %
U_PMX_WENESBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Weighing needed?
U_PMX_WOBQSBO:Numeric100Weigh order batch quantity

Table AWOR

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_BBDTSBO:DateBest before date
U_PMX_BTC2SBO:Alpha36Batch Number 2
U_PMX_BTCHSBO:Alpha36Batch Number
U_PMX_CUPBSBO:Numeric100Current Prod. batch
U_PMX_NRPBSBO:Numeric50Prod. batches
U_PMX_PBSZSBO:Float, Quantity196Prod. batch size
U_PMX_PLCDSBO:Alpha50Prod. Line Code
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PPRDSBO:Numeric100Parent Production Order
U_PMX_PPRNSBO:Numeric100Parent Production Order DocNum
U_PMX_PRSTSBO:Alpha1'P'
NULL => NULL
'C' => 'Closed'
'P' => 'Planned'
'S' => 'Started'
'H' => 'On hold'
Prod. Status
U_PMX_PRUNSBO:Numeric100Production run
U_PMX_PSLKSBO:Numeric100Production Order Step list key
U_PMX_QTYPSBO:Float, Quantity196Quantity Picked
U_PMX_QYSCSBO:Alpha8Quality status code
U_PMX_SNMMSBO:Alpha1'N'
NULL => NULL
'N' => 'None'
'P' => 'Pool'
Serial number management method
U_PMX_SNPCSBO:Alpha50Serial number pool code

Table CIN1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table CIN7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table CPI1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table CPI7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table CPV1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table CPV7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table CSI1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table CSI7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table CSV1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table CSV7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table DLN1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table DLN7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table DPI1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table DPI7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table DPO1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table DPO7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table DRF1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table DRF7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table IEI1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table IEI7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table IGE1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table IGE7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table IGN1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table IGN7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table INV1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table INV7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table ITT1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_APLUSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow to pick for line up?
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDOSBO:Alpha1'D'
NULL => NULL
'D' => 'Due date and shelf life'
'P' => 'Pick date'
'B' => 'Beste before date of finished product and shelf life'
Best before date option
U_PMX_BCMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is base component?
U_PMX_HBLUSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Has to be lined up?
U_PMX_OPTISBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the item optional?
U_PMX_OWORSTARTCONDSBO:Alpha1'N'
NULL => NULL
'N' => 'No condition'
'Q' => 'Component part. weighed'
'W' => 'Component weighed'
Prod. order start condition
U_PMX_QTYTOLPCTSBO:Float, [%]196Qty tolerance %
U_PMX_WENESBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Weighing needed?
U_PMX_WOBQSBO:Numeric100Weigh order batch quantity

Table MRV1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_PRPWSBO:Float, Price196Price by weight

Table MRV3

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_PRPWSBO:Float, Price196Price by weight

Table OCIN

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OCPI

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OCPV

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OCRD

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_CARISBO:Alpha1'C'
NULL => NULL
'C' => 'Take setting from company'
'N' => 'No'
'Y' => 'Yes'
Check to add returnable items
U_PMX_DFCUSBO:Alpha3Default Currency
U_PMX_DLCASBO:Alpha50Default log. car.
U_PMX_EPNRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Enter specific pallet nr.?
U_PMX_GPDLSBO:Alpha1'C'
NULL => NULL
'C' => 'Take setting from company'
'Y' => 'Group delivery'
'N' => 'Do not group delivery'
Group purchase delivery to 1 delivery
U_PMX_GSDLSBO:Alpha1'C'
NULL => NULL
'C' => 'Take setting from company'
'Y' => 'Group delivery'
'N' => 'Do not group delivery'
Group sales delivery to 1 delivery
U_PMX_ILURSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Has no identical logistic units?
U_PMX_LBPASBO:Alpha15Linked business partner
U_PMX_LCARSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Has no logistic carriers at reception?
U_PMX_LLSRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Has no labels at reception?
U_PMX_MPORSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Never delivers mixed logistic units?
U_PMX_PLTYSBO:Alpha50Pick list type
U_PMX_PPTYSBO:Alpha3'P'
NULL => NULL
'P' => 'Pallet'
'MP' => 'Multiple Pallet'
'PMC' => 'Pallet - Multiple Carton'
'ASK' => 'Ask user'
Pallet packing type
U_PMX_SPRMSBO:MemoSales/purchase remark
U_PMX_SPRPSBO:Alpha1<no default>
NULL => NULL
'Y' => 'True'
'N' => 'False'
Show sales/purchase remark pop-up

Table OCSI

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OCSV

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OCTG

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AUTOGEN_PLSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Auto. generate pick list

Table ODLN

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table ODPI

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table ODPO

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table ODRF

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OEI1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table OEI7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table OIEI

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OIGE

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OIGN

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OINV

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OITM

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PIPSBO:Float, Price1963PL inbound price per inventory unit
U_PMX_3POPSBO:Float, Price1963PL outbound price per inventory unit
U_PMX_ALUSSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Auto. oplijning selectie
U_PMX_AMBSSBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches on sales document
U_PMX_APDPSBO:Numeric100'0'The allowed deviation for production (Percentage)
U_PMX_APPPSBO:Numeric100'0'The additional quantity picking for production (Percentage)
U_PMX_AQILSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Ask quantity on item label printing?
U_PMX_ASLASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow stock to be locked in advance?
U_PMX_BCTYSBO:Alpha1'G'
NULL => NULL
'F' => 'Free'
'G' => 'GTIN'
'V' => 'Variable GTIN'
Barcode type
U_PMX_BUPQSBO:Float, Quantity196Bulk pick qty
U_PMX_CSORSBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Requires creation SSSC on reception?
U_PMX_CSU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Correct stock uom2?
U_PMX_CSUMSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Correct stock uom?
U_PMX_CUDESBO:Alpha254Custom item descr. Updated automatically!
U_PMX_CWQCSBO:Float, Quantity196'0'Quantity in case (catch weight)
U_PMX_CWSCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Scan weight for each case? (Catch weight)
U_PMX_CWTOSBO:Float, [%]196'0'Tolerance (%) for catch weight
U_PMX_DLCPSBO:Alpha50Default logistic carrier production
U_PMX_DLCSSBO:Alpha50Default logistic carrier picking
U_PMX_DPQTSBO:Float, Quantity196The default production quantity
U_PMX_DQLUSBO:Float, Quantity196Default qty on log. unit
U_PMX_DQU2SBO:Float, Quantity196Def qty in Uom2
U_PMX_DQUMSBO:Float, Quantity196Def weight for piece
U_PMX_ESQMSBO:Float, Quantity196The estimated sales quantity by month (replenishment)
U_PMX_EXDPSBO:Alpha50Expiry def. for production
U_PMX_EXDRSBO:Alpha50Expiry def. for reception
U_PMX_FSNCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Force serial number scanning during cycle count?
U_PMX_HBBDSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Article with Best Before Date?
U_PMX_HBN2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Has second batch number?
U_PMX_HNVASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Does the item have no value?
U_PMX_HSERSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Article with serial number?
U_PMX_ICAWSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is catch weight item?
U_PMX_ICRISBO:Alpha50Article code not inv.ret.item
U_PMX_ILRCSBO:Numeric100Label report # copies
U_PMX_ILRPSBO:Numeric100Label report key
U_PMX_ISLTSBO:Alpha50Item location type
U_PMX_LOCASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is article logistic carrier?
U_PMX_LOUNSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is article logistic unit?
U_PMX_LSPTSBO:Alpha8Lowest sellable packaging type
U_PMX_NIOPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Add non inventory item on pick list?
U_PMX_NRSNSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Needs reason for return?
U_PMX_NRSRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Needs reason for sales return?
U_PMX_PBCOSBO:Alpha16Purchase barcode
U_PMX_PBCTSBO:Alpha1'G'
NULL => NULL
'F' => 'Free'
'G' => 'GTIN'
'V' => 'Variable GTIN'
Purchase barcode type
U_PMX_PCPUSBO:Alpha1'P'
NULL => NULL
'P' => 'Price by pieces'
'W' => 'Price by weight'
Price calculation for purchase
U_PMX_PCSASBO:Alpha1'P'
NULL => NULL
'P' => 'Price by pieces'
'W' => 'Price by weight'
Price calculation for sales
U_PMX_PIBPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Print item labels by packaging type?
U_PMX_PILPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Print label during picking?
U_PMX_PILRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Print label at reception?
U_PMX_PIMGSBO:Alpha, [I]200Packing image
U_PMX_PITYSBO:Alpha50Pick Type
U_PMX_PREMSBO:MemoPacking remarks
U_PMX_PRMRSBO:MemoProduction remarks
U_PMX_PRWDSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Record weight details during picking?
U_PMX_PTY2SBO:Alpha50Pick Type 2
U_PMX_PURMSBO:MemoPurchase remark
U_PMX_PURPSBO:Alpha1<no default>
NULL => NULL
'Y' => 'True'
'N' => 'False'
Show purchase remark pop-up
U_PMX_QSCRSBO:Alpha8Quarantined quality status reception
U_PMX_QSPRSBO:Alpha8Quality status Production
U_PMX_QSRCSBO:Alpha8Quality status reception controller
U_PMX_QSSRSBO:Alpha8Quality stat. sal.return
U_PMX_RETRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is article returnable item?
U_PMX_RQPLSBO:Float, Quantity196The quantity on pick locations (replenishment)
U_PMX_RQSRSBO:Alpha8Released quality status reception
U_PMX_SARMSBO:MemoSales remark
U_PMX_SARPSBO:Alpha1<no default>
NULL => NULL
'Y' => 'True'
'N' => 'False'
Show sales remark pop-up
U_PMX_SBCOSBO:Alpha16Sales barcode
U_PMX_SBCPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Scan base component?
U_PMX_SBCTSBO:Alpha1'G'
NULL => NULL
'F' => 'Free'
'G' => 'GTIN'
'V' => 'Variable GTIN'
Sales barcode type
U_PMX_SEVESBO:Alpha8Seveso class code
U_PMX_SLDRSBO:Numeric100'0'Reception: Shelf life of article in days
U_PMX_SLIDSBO:Numeric100'0'Shelf life of article in days
U_PMX_SNFOSBO:Alpha50Serial number format
U_PMX_SQTYSBO:Float, Quantity196Sample quantity
U_PMX_TLSNSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Track location serial number?
U_PMX_U2MTSBO:Alpha8'31'
NULL => NULL
'37' => 'Count'
'31' => 'Net weight kilo'
'32' => 'Net weight pound'
GS1 Type for uom2
U_PMX_UFTRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Use for time registration?
U_PMX_UM2DSBO:Numeric100'0'Uom2 decimals
U_PMX_UMITSBO:Alpha1'1'
NULL => NULL
'1' => 'Pieces (UOM1)'
'2' => 'Weight (UOM2)'
'A' => 'UOM1 and UOM2'
Uom For Inv. Trans.
U_PMX_UMMTSBO:Alpha8'37'
NULL => NULL
'37' => 'Count'
'31' => 'Net weight kilo'
'32' => 'Net weight pound'
GS1 Type for uom
U_PMX_UMPUSBO:Alpha1'1'
NULL => NULL
'1' => 'Pieces (UOM1)'
'2' => 'Weight (UOM2)'
'A' => 'UOM1 and UOM2'
Uom For purchase
U_PMX_UMSASBO:Alpha1'1'
NULL => NULL
'1' => 'Pieces (UOM1)'
'2' => 'Weight (UOM2)'
'A' => 'UOM1 and UOM2'
Uom For Sales
U_PMX_UOM2SBO:Alpha8Uom2
U_PMX_UOMDSBO:Numeric100'0'Uom decimals
U_PMX_UWAFSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Use in WA functionality?
U_PMX_VIDESBO:Alpha100Vendor item descr.
U_PMX_WCRESBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Weight capture needed during reception?
U_PMX_WOSTSBO:Alpha1'O'
NULL => NULL
'O' => 'ByOrder'
'I' => 'ByItem'
Weigh Order Strategy

Table OITT

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_SNMMSBO:Alpha1'N'
NULL => NULL
'N' => 'None'
'P' => 'Pool'
Serial number management method

Table OITW

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_UOM2QTY_AVSBO:Alpha20UOM2 qty available
U_PMX_UOM2QTY_CFSBO:Alpha20UOM2 qty confirmed
U_PMX_UOM2QTY_ORSBO:Alpha20UOM2 qty ordered
U_PMX_UOM2QTY_WHSBO:Alpha20UOM2 qty warehouse

Table OLNG

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_CULTSBO:Alpha20Culture name

Table OOEI

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OPCH

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OPDN

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OPLN

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_SALDOC_DEFSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Default in Sales Line Detail Form
U_PMX_SALDOC_VISSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Visible in Sales Line Detail Form
U_PMX_UOM2PRICEUDFSBO:Alpha20UOM2 Item Price UDF
U_PMX_UOM2PRUD_UDFSBO:Alpha20UOM2 Item Price update date UDF
U_PMX_VALIDFROM_UDFSBO:Alpha20Pricelist valid from UDF
U_PMX_VALIDTILL_UDFSBO:Alpha20Pricelist valid till UDF

Table OPOR

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OPQT

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OPRQ

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OPRR

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OQUT

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table ORDN

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table ORDR

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table ORIN

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table ORPC

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table ORPD

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table ORRR

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table ORSC

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_UFTRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Use for time registration

Table OSCN

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_SIDESBO:Alpha100Substitute descr.

Table OSFC

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OSFI

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OSHP

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_ADRNSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Ask driver name during shipping?
U_PMX_ALIPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Ask license plate during shipping?
U_PMX_ATLNSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Ask trailer number during shipping?
U_PMX_ATNRSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Ask tracking number during shipping?
U_PMX_AUINSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Automatic invoicing?
U_PMX_AUSHSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Automatic shipping?
U_PMX_CUCOSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the customer coming to collect goods?
U_PMX_MailReportODSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Mail report on document add

Table OUSR

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_LANGSBO:Numeric100Language
U_PMX_USGRSBO:Alpha50Pmx User group

Table OWHS

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_IMBPSBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is managed by Produmex?
U_PMX_ITWHSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is transit WHS?

Table OWOR

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_BBDTSBO:DateBest before date
U_PMX_BTC2SBO:Alpha36Batch Number 2
U_PMX_BTCHSBO:Alpha36Batch Number
U_PMX_CUPBSBO:Numeric100Current Prod. batch
U_PMX_NRPBSBO:Numeric50Prod. batches
U_PMX_PBSZSBO:Float, Quantity196Prod. batch size
U_PMX_PLCDSBO:Alpha50Prod. Line Code
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PPRDSBO:Numeric100Parent Production Order
U_PMX_PPRNSBO:Numeric100Parent Production Order DocNum
U_PMX_PRSTSBO:Alpha1'P'
NULL => NULL
'C' => 'Closed'
'P' => 'Planned'
'S' => 'Started'
'H' => 'On hold'
Prod. Status
U_PMX_PRUNSBO:Numeric100Production run
U_PMX_PSLKSBO:Numeric100Production Order Step list key
U_PMX_QTYPSBO:Float, Quantity196Quantity Picked
U_PMX_QYSCSBO:Alpha8Quality status code
U_PMX_SNMMSBO:Alpha1'N'
NULL => NULL
'N' => 'None'
'P' => 'Pool'
Serial number management method
U_PMX_SNPCSBO:Alpha50Serial number pool code

Table OWTQ

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table OWTR

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_3PLPSBO:Date3PL Period
U_PMX_CMRNSBO:Alpha20The CMR number
U_PMX_DDTASBO:Alpha2<no default>
NULL => NULL
'24' => '24'
'AM' => 'AM'
'PM' => 'PM'
Due date - AM/PM
U_PMX_DDTHSBO:Numeric100Due date - hour
U_PMX_DDTMSBO:Numeric100Due date - minute
U_PMX_DRNASBO:Alpha100The name of the driver
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_INFCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is the order interfaced?
U_PMX_ISMPSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is sample order?
U_PMX_LIPLSBO:Alpha100The license plate
U_PMX_PLTYSBO:Alpha50Pmx pick list type
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_PRQYSBO:Float, Quantity196Production run quantity
U_PMX_PSSDSBO:Numeric100The PMX sales shipping number
U_PMX_REDASBO:DateReturn date
U_PMX_TRNRSBO:Alpha100The trailer number

Table PCH1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table PCH7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table PDN1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table PDN7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table POR1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table POR7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table PQT1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table PQT7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table PRQ1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table PRQ7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table PRR1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table PRR7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table QUT1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type
U_PMX_PQY2SBO:MemoPmx quantity uom2
U_PMX_PRDBSBO:Numeric100The Production batch
U_PMX_PRDESBO:Numeric100The PRD doc entry
U_PMX_PRDLSBO:Numeric100The PRD line num
U_PMX_PRDRSBO:Numeric100The production run
U_PMX_QTY2SBO:Float, Quantity196Qty for uom2
U_PMX_QUANSBO:MemoPmx quantity
U_PMX_QYSCSBO:MemoQuality status code
U_PMX_RIPISBO:Float, Price196Ret.Items.Price
U_PMX_RLCOSBO:Alpha50The reason location code
U_PMX_RSNCSBO:Alpha8Reason code. Reference to PMX_REAS.Code.
U_PMX_SENUSBO:MemoPMX Serial number
U_PMX_SHLFSBO:Numeric100Shelf life
U_PMX_SLOCSBO:MemoSource Storage location code
U_PMX_SLUISBO:MemoThe source LUID
U_PMX_SPNRSBO:Alpha100Supplier pallet number
U_PMX_SQOPSBO:Alpha50Shipping quality option
U_PMX_SQSCSBO:MemoSource quality status code
U_PMX_SSCCSBO:MemoSSCC's
U_PMX_SULRSBO:Alpha40Supplier line ref.
U_PMX_U2TUSBO:Float, Quantity196Uom2 to Uom factor
U_PMX_UFTXSBO:Alpha254The reason's extra information
U_PMX_UOM2SBO:Alpha8Uom 2

Table QUT7

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_MSSCSBO:Alpha18The master SSCC
U_PMX_SSCCSBO:Alpha18The SSCC

Table RDN1

SAP Business One or other table.

NameData typeChar.len.Num.prec.Num.scaleDefault / allowed valuesDescription
U_PMX_AMBASBO:Alpha1'Y'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Allow multiple batches
U_PMX_BAC1SBO:Alpha50Batch attribute 1
U_PMX_BAC2SBO:Alpha50Batch attribute 2
U_PMX_BAC3SBO:Alpha50Batch attribute 3
U_PMX_BAENSBO:Numeric100The pmx base entry
U_PMX_BALISBO:Numeric100The pmx base line
U_PMX_BAT2SBO:Memo2nd batch number
U_PMX_BATCSBO:Memo1st batch number
U_PMX_BATYSBO:Alpha20The pmx base type
U_PMX_BAV1SBO:Alpha254Batch attribute value 1
U_PMX_BAV2SBO:Alpha254Batch attribute value 2
U_PMX_BAV3SBO:Alpha254Batch attribute value 3
U_PMX_BBDTSBO:MemoBest before date
U_PMX_EX3PSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Exclude from 3PL calculation?
U_PMX_FREESBO:Float, Quantity196PMX free stock
U_PMX_IQTYSBO:Float, Quantity196Input quantity
U_PMX_ISLCSBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is logistic carrier?
U_PMX_ISWASBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Is waste?
U_PMX_LOCOSBO:MemoStorage location code
U_PMX_LUIDSBO:MemoLUID's
U_PMX_MLUISBO:MemoThe master LUID
U_PMX_MQU2SBO:Alpha1'N'
NULL => NULL
'Y' => 'True'
'N' => 'False'
Minimum quantity uom 2 required?
U_PMX_PATQSBO:Float, Quantity196Packaging type quantity
U_PMX_PATYSBO:Alpha20Packaging type