tableAdministration & Setupofficial - Microsoftderived - from the source, no model text

Table 47033 "SL POTran"

HybridSL · Microsoft.DataMigration.SL

Across versions

  1. BC23-28not present
  2. BC29-30present

HybridSL · Microsoft.DataMigration.SL · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property Value
Access Internal
DataClassification CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
1 Acct Text[10] —
2 AcctDist Integer —
3 AddlCost Decimal —
4 AddlCostPct Decimal —
5 AddlCostVouch Decimal —
6 AlternateID Text[30] —
7 AltIDType Text[1] —
8 APLineID Integer —
9 APLineRef Text[5] —
10 BatNbr Text[10] —
11 BMICuryID Text[4] —
12 BMIEffDate DateTime —
13 BMIExtCost Decimal —
14 BMIMultDiv Text[1] —
15 BMIRate Decimal —
16 BMIRtTp Text[6] —
17 BMITranAmt Decimal —
18 BMIUnitCost Decimal —
19 BMIUnitPrice Decimal —
20 BOMLineRef Text[5] —
21 BOMSequence Integer —
22 CnvFact Decimal —
23 CostVouched Decimal —
24 CpnyID Text[10] —
25 Crtd_DateTime DateTime —
26 Crtd_Prog Text[8] —
27 Crtd_User Text[10] —
28 CuryAddlCost Decimal —
29 CuryAddlCostVouch Decimal —
30 CuryCostVouched Decimal —
31 CuryExtCost Decimal —
32 CuryID Text[4] —
33 CuryMultDiv Text[1] —
34 CuryRate Decimal —
35 CuryTranAmt Decimal —
36 CuryUnitCost Decimal —
37 DrCr Text[1] —
38 ExtCost Decimal —
39 ExtWeight Decimal —
40 FlatRateLineNbr Integer —
41 InvtID Text[30] —
42 JrnlType Text[3] —
43 Labor_Class_Cd Text[4] —
44 LineID Integer —
45 LineNbr Integer —
46 LineRef Text[5] —
47 LUpd_DateTime DateTime —
48 LUpd_Prog Text[8] —
49 LUpd_User Text[10] —
50 NoteID Integer —
51 OrigRcptDate DateTime —
52 OrigRcptNbr Text[10] —
53 OrigRetRcptNbr Text[10] —
54 PC_Flag Text[1] —
55 PC_ID Text[20] —
56 PC_Status Text[1] —
57 PerEnt Text[6] —
58 PerPost Text[6] —
59 POLineID Integer —
60 POLineNbr Integer —
61 POLIneRef Text[5] —
62 PONbr Text[10] —
63 POOriginal Text[1] —
64 ProjectID Text[16] —
65 PurchaseType Text[2] —
66 Qty Decimal —
67 QtyVouched Decimal —
68 RcptConvFact Decimal —
69 RcptDate DateTime —
70 RcptLineRefOrig Text[5] —
71 RcptMultDiv Text[1] —
72 RcptNbr Text[10] —
73 RcptNbrOrig Text[10] —
74 RcptQty Decimal —
75 RcptUnitDescr Text[6] —
76 ReasonCd Text[6] —
77 Refnbr Text[10] —
78 S4Future01 Text[30] —
79 S4Future02 Text[30] —
80 S4Future03 Decimal —
81 S4Future04 Decimal —
82 S4Future05 Decimal —
83 S4Future06 Decimal —
84 S4Future07 DateTime —
85 S4Future08 DateTime —
86 S4Future09 Integer —
87 S4Future10 Integer —
88 S4Future11 Text[10] —
89 S4Future12 Text[10] —
90 ServiceCallID Text[10] —
91 SiteID Text[10] —
92 SOLineID Integer —
93 SOLineRef Text[5] —
94 SOOrdNbr Text[15] —
95 SOTypeID Text[4] —
96 SpecificCostID Text[25] —
97 StepNbr Integer —
98 Sub Text[24] —
99 SvcContractID Text[10] —
100 SvcLineNbr Integer —
101 TaskID Text[32] —
102 TaxCat Text[10] —
103 TaxIDDflt Text[10] —
104 TranAmt Decimal —
105 TranDate DateTime —
106 TranDesc Text[60] —
107 TranType Text[2] —
108 UnitCost Decimal —
109 UnitDescr Text[6] —
110 UnitMultDiv Text[1] —
111 UnitWeight Decimal —
112 User1 Text[30] —
113 User2 Text[30] —
114 User3 Decimal —
115 User4 Decimal —
116 User5 Text[10] —
117 User6 Text[10] —
118 User7 DateTime —
119 User8 DateTime —
120 VendId Text[15] —
121 VouchStage Text[1] —
122 WhseLoc Text[10] —
123 WIP_COGS_Acct Text[10] —
124 WIP_COGS_Sub Text[24] —
125 WOBomRef Text[5] —
126 WOCostType Text[2] —
127 WONbr Text[10] —
128 WOStepNbr Text[5] —

Keys

  • Key1: RcptNbr, LineRef (clustered)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "SL POTran"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources