Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
---|---|---|---|---|---|---|---|---|---|---|

42: Sales Management | ||||||||||

1 | F4211 | Sales Order Detail File | 237 | SD | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

2 | F42119 | Sales Order History File | 237 | SD | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

3 | F42199 | S.O. Detail Ledger File | 237 | SL | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

4 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 102 | ZD | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

5 | F47027T | Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound | 39 | UZ | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

6 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 87 | UZ | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

7 | F47047T | Tag for F47047- EDI Invoice Detail (Sales) - Outbound | 39 | UZ | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

8 | F47107T | Tag for F47107- EDI Response to RFQ Detail - Outbound | 39 | UZ | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

9 | F47147T | Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound | 39 | UZ | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

42B: Sales Order Entry | ||||||||||

10 | F4011ZT | Batch Receiver File - Order Details Tag | 40 | UZ | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

11 | F42420 | Audit Log Transaction | 102 | AL | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

12 | F47012T | EDI Purchase Order Detail Tag - Inbound | 40 | UZ | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

13 | F47092T | EDI Request for Quote Detail Tag - Inbound | 40 | UZ | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

14 | F47132T | EDI Purchase Order Change Detail Tag - Inbound | 40 | UZ | XCTO | Cross Dock Order Type | String | UDC | 2 | 0 |

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

# UDC 00 / DT (Document Type - All Documents) stock values

Value | Description | Special Handling Code | Hard Coded | |
---|---|---|---|---|

1 | ## | Prior Year Transactions | Y | |

2 | $A | Eventual Withholdings | N | |

3 | $B | Gross Income Withholdings | N | |

4 | $G | Profit Withholdings | N | |

5 | $I | V.A.T Withholdings | N | |

6 | $L | Cleaning Services Withholding | N | |

7 | $P | Security Withholdings | Y | |

8 | $Q | General SUSS | Y | |

9 | $S | Contract Withholdings | N | |

10 | % | Percentage Journal Entry | Y | |

11 | @O | Payment order | N | |

12 | A | Inv. Cnv. - Adjustments | N | |

13 | AC | Lease Accrual / Deferral | N | |

14 | AD | Asset Disposal | Y | |

15 | AE | Automatic Entries | Y | |

16 | AF | Adjusting Entries | Y | |

17 | AJ | Service Billing Adjustments | Y | |

18 | AR | Asset Revaluation | Y | |

19 | AS | Asset Split | Y | |

20 | AT | Asset Transfer | Y | |

21 | AU | Units - Committed | Y | |

22 | BA | Billing Adjustments | Y | |

23 | BB | Bulk - Simple Blend | N | |

24 | BC | Base Agreement Contract | N | |

25 | BD | Bulk- Decant | N | |

26 | BE | Billing Entries | N | |

27 | BF | Balance Forward/Summarize | Y | |

28 | BG | Regrade/GSM | N | |

29 | BI | Bulk/Packed Invoice | N | |

30 | BJ | Bulk - Adjustment | N | |

31 | BL | Bulk-Filling | N | |

32 | BM | Bill of Lading | N | |

33 | BO | Bulk-Consumed in Operations | N | |

34 | BP | Bulk-Repacking | N | |

35 | BR | Bulk-Rebrand or Regrade | N | |

36 | BT | Bulk-Tank to Tank Transfer | N | |

37 | BX | Budget Change Order | N | |

38 | C% | TDS Withholding | N | |

39 | C1 | Contract Level | Y | |

40 | C2 | Invoice Level | Y | |

41 | C3 | Funding Level | Y | |

42 | C4 | Credit Order - Transportation | N | |

43 | CC | USER | N | |

44 | CD | Container Deposits | N | |

45 | CF | Journal Entry From Conversion | N | |

46 | CG | Lot Grade Change | Y | |

47 | CL | Call | N | |

48 | CM | Service Contracts - CSMS | N | N |

49 | CO | Credit Order | N | |

50 | CP | Lot Potency Change | Y | |

51 | CS | RFx | N | |

52 | CT | Transportation Confirmation | N | |

53 | CW | HomeBuilder Closing Worksheet | N | |

54 | CX | Change Request | Y | |

55 | CZ | Cash Basis | Y | |

56 | DA | Debit Note | N | |

57 | DD | Sale Order | N | |

58 | DL | Delivery Ticket | N | |

59 | DN | Credit Note | N | |

60 | DP | Depreciation Journal | Y | |

61 | DR | Job Cost Draw Splits | Y | |

62 | E | Energy | N | |

63 | EA | Lease Cost Adjusting Entries | N | |

64 | EC | Revenue Checks | N | |

65 | EG | Engineering Change Request | R | N |

66 | EN | Engineering Change Order | N | |

67 | EP | Revenue J/E`s 8/8`s | N | |

68 | EQ | Revenue J/E`s Subledger | N | |

69 | ER | Revenue J/E`s Net Company | N | |

70 | ES | Revenue Suspense Entries | N | |

71 | ET | Engineer to Order | N | N |

72 | EU | Service Billing Revenue | Y | |

73 | EV | Revenue Manual/Void Checks | N | |

74 | EX | Currency Conversion Offsets | Y | |

75 | FA | Invoice | N | |

76 | FC | Forecast | N | |

77 | FE | Revenue Fees | N | |

78 | FJ | Revenue Fees - Jrnl Entry Only | N | |

79 | FO | Firm Work Order W/Parts List | N | |

80 | FP | Field Progress Reporting | N | |

81 | FR | Firm Rate Order W/Parts List | Y | |

82 | FS | FRW Created Doc. Types | N | |

83 | FT | Freight | N | |

84 | G2 | Inbound Completions | N | |

85 | GF | General Ledger Transferred | N | |

86 | GG | Environmental Document | Y | |

87 | GL | Bulk Product Gain/Loss | N | |

88 | HP | Purchase Order | N | |

89 | HS | Hours Service | N | |

90 | HT | Purchase Transfer Order | N | |

91 | I | Inv Cnv - Issues | N | |

92 | I1 | Interbranch Sales | ||

93 | I2 | Sorties de Stock- Obsolescence | N | |

94 | I3 | Sorties de Stock - Vol | N | |

95 | I4 | Sorties de Stock - Dommages | N | |

96 | IA | Inventory Adjustments | N | |

97 | IB | Item Cost Changes | N | |

98 | IC | Completed W.O.`s To Inventory | N | |

99 | ID | Inventory Issue To Blend Mgmt | Y | |

100 | IH | Labor Charged To W.O.`s | N | |

101 | II | Inventory Issue | N | |

102 | IJ | Inventory Adjustments | ||

103 | IL | Inventory Issue | ||

104 | IM | Material Charged To W.O.`s | N | |

105 | IO | Component Scrap to W.O.`s | N | |

106 | IP | Physical Inventory | Y | |

107 | IQ | Inventory Quantity Only | Y | |

108 | IR | Inventory Receipt | N | |

109 | IS | Scrapped W.O.`s To Inventory | N | |

110 | IT | Inventory Transfers | N | |

111 | IV | Variance Calculated for W.O.`s | N | |

112 | IX | Recalculate Average Cost | Y | |

113 | IZ | Lot Hold/Release | Y | |

114 | JA | Budget or Cost Allocation | Y | |

115 | JB | Joint Interest Billing | N | |

116 | JC | Job Cost % Complete | N | |

117 | JD | JIB Detail Owner Entries | N | |

118 | JE | Journal Entry | Y | |

119 | JF | Journals Brought Forward | N | |

120 | JK | A/P Redistribute Payments | Y | |

121 | JM | AR VAT Redistribution | Y | |

122 | JP | Subscription Sales | N | |

123 | JQ | Sub. Sales Net Ledger | N | |

124 | JR | Subscription Sales Commissions | N | |

125 | JT | Accrued Property Taxes | N | |

126 | JV | A/P Redistribute Prepayments | Y | |

127 | JX | Foreign Currency Revaluation | Y | |

128 | JZ | Cash Basis Journal Entry | Y | |

129 | K1 | Kanban Type 1 | Y | |

130 | K2 | Kanban Type 2 | Y | |

131 | K3 | Kanban Type 3 | Y | |

132 | K4 | Kanban Type 4 | Y | |

133 | LB | Labels | N | |

134 | LC | Completed Lean Trans to Inv | L3 | N |

135 | LH | Work Order Labor Hours | N | |

136 | LL | Labor charged to Lean Trans | L2 | N |

137 | LM | Material charged to Lean Trans | L1 | N |

138 | LO | Component Scrap to Lean Trans | L | N |

139 | LP | Scrapped Lean Trans to Inv | L4 | N |

140 | LS | Property Management Lease | N | |

141 | LV | Variance calculated for Lean T | L | N |

142 | MP | Another Purchase Order | N | |

143 | MS | Material Issue Service | N | |

144 | MU | Mileage (Meter) Update | N | |

145 | N | Other Values | N | N |

146 | NA | Stand Alone Nota Fiscal | N | |

147 | ND | Ship-To Nota Fiscal Return | N | |

148 | NF | Purchasing Nota Fiscal | N | |

149 | NI | Non Stock Nota Fiscal | N | |

150 | NL | Preliminary Order | N | |

151 | NN | Nota Fiscal Reverse/Void | N | |

152 | NO | Netting Transactions | Y | |

153 | NP | Partial NSF | Y | |

154 | NR | Ship-From Nota Fiscal Return | N | |

155 | NS | Nota Fiscal Sales | N | |

156 | O | Ordering Document Types | N | |

157 | O1 | Order Document Type Fixed Asse | N | |

158 | O4 | Purchase Order -Transportation | N | |

159 | OA | Do Not Use | Y | |

160 | OB | Blanket Order | N | |

161 | OC | Construction Work Order | N | |

162 | OD | Direct Ship Order | N | |

163 | OE | Do Not Use--Exchange Rate Var. | Y | |

164 | OI | Interoperability Direct P.O. | N | |

165 | OK | Purchase Intercompany Order | N | |

166 | OM | Purchase Order RMA | N | |

167 | OO | Outside Operations | ||

168 | OP | Purchase Order | N | |

169 | OQ | Purchase Quote or Bid | N | |

170 | OR | Purchase Requisition | N | |

171 | OS | Subcontract | N | |

172 | OT | Transfer Order | N | |

173 | OU | Requisition Self Service | Y | |

174 | OV | Do Not Use--Receiving Document | Y | |

175 | OX | Change Order | N | |

176 | OY | EDI Purchase Order Quote | ||

177 | OZ | EDI Purchase Order | ||

178 | P | Payables | N | |

179 | P1 | A/P Drafts | Y | |

180 | P7 | Alternate Currency Payment | Y | |

181 | P9 | Voucher | Y | |

182 | PA | Credit Note Reimbursements | Y | |

183 | PB | BACS Electronic Funds Transfer | Y | |

184 | PC | Percent Complete FASTR Entry | N | |

185 | PD | Debit Memo | Y | |

186 | PE | Change to Voucher Amount | Y | |

187 | PF | Recurring Billing | N | |

188 | PG | Gain/Loss on Exchange Rate | Y | |

189 | PI | Physical Inventory | Y | |

190 | PJ | Sales Overage | N | |

191 | PK | Automated Check | Y | |

192 | PL | Voucher Logging | Y | |

193 | PM | Manual Voucher | Y | |

194 | PN | Manual Check | Y | |

195 | PO | Void Check | Y | |

196 | PP | Periodic Invoice | Y | |

197 | PQ | Manual Billing | N | |

198 | PR | Recurring Voucher | Y | |

199 | PT | Electronic Funds Transfer | Y | |

200 | PV | Voucher | Y | |

201 | PW | Withholding | Y | |

202 | PY | Payment Order - EDI Only | Y | |

203 | PZ | A/P Cash Basis | Y | |

204 | Q7 | Suspended VAT - Recognized | N | |

205 | Q8 | Suspended and Recognized VAT | N | |

206 | Q9 | Suspended VAT | N | |

207 | QA | Non-Comformance Report | N | |

208 | QO | Quote Order | N | |

209 | QR | Quote Request | N | |

210 | R | Receivables | N | |

211 | R% | TDS Withholding | N | |

212 | R1 | A/R Drafts | Y | |

213 | R2 | Contract Billing | Y | |

214 | R3 | Draft Invoice | Y | |

215 | R4 | Final Invoice | Y | |

216 | R5 | Deduction | Y | |

217 | R6 | RMA - Sales Order | Y | |

218 | R7 | Alternate Currency Receipt | Y | |

219 | R8 | Return Material Authorization | N | |

220 | R9 | RMA Credit Order | N | |

221 | RA | Adjustment | Y | |

222 | RB | Chargeback | Y | |

223 | RC | Receipts - A/R | Y | |

224 | RD | Recurring Billing | N | |

225 | RE | Change to Invoice Amount | Y | |

226 | RF | Finance Charge | Y | |

227 | RG | Gain/Loss on Exchange Rate | Y | |

228 | RH | Expense Participation | N | |

229 | RI | Invoice | Y | |

230 | RJ | Sales Overage | N | |

231 | RK | Receipt - Summarized | Y | |

232 | RL | Escalation | N | |

233 | RM | Credit Memo | Y | |

234 | RN | Manual Billing | Y | |

235 | RO | Reversing or Void Entry | Y | |

236 | RP | Direct Payments | Y | |

237 | RQ | Chargeback Amount Created | Y | |

238 | RR | Recurring Invoice | Y | |

239 | RS | Spread Adjustments | Y | |

240 | RT | A/R Fee & Interest | Y | |

241 | RU | Unapplied Cash | Y | |

242 | RV | Non-sufficient Funds | Y | |

243 | RW | Receipt Journal Entry | Y | |

244 | RX | Sales Contracts | N | |

245 | RY | EDI Receipt | Y | |

246 | RZ | A/R Cash Basis | Y | |

247 | S | Sales Order Document Types | N | |

248 | S1 | Counter Sales | N | |

249 | S2 | Phone Sales | N | |

250 | S3 | Sales Order - ECS | N | |

251 | S4 | Sales Order - Transportation | 10 | N |

252 | SB | Blanket Sales Order | N | |

253 | SC | Actual Rate Schedule | Y | |

254 | SD | Direct Ship | N | |

255 | SE | Extended Warr. Service | N | N |

256 | SH | Supplier Recovery | N | |

257 | SI | Interbranch Sales | N | |

258 | SK | Sales Intercompany Order | N | |

259 | SN | Nonwarranty Service | N | N |

260 | SO | Sales Order | SO | N |

261 | SP | Price List | N | |

262 | SQ | Sales Quote | N | |

263 | SR | Sales Order - Rush | N | |

264 | SS | Do Not Use--Summary Records | Y | |

265 | ST | Transfer Sale | N | |

266 | SV | Base Warranty Service | N | N |

267 | SW | Sales with Trans. & Warehouse | N | |

268 | SY | EDI Sales Order Quote | N | |

269 | SZ | EDI Sales Order | N | |

270 | T | Time and Pay | N | |

271 | T1 | Payroll Disbursement Entries | N | |

272 | T2 | Payroll Labor Distribution | N | |

273 | T3 | Actual Burden Journal Entries | N | |

274 | T4 | Labor Billing Distribution | N | |

275 | T5 | Equipment Distribution | N | |

276 | T6 | Payroll Accruals / Deferrals | N | |

277 | T7 | Payroll Vouchers | N | |

278 | TE | Time Sheet Entry | N | |

279 | TJ | Payroll Journal | N | |

280 | TM | Enterprise Treasury Management | Y | |

281 | TO | Takeoff | N | |

282 | U1 | U1 through U9 client reserved | N | |

283 | UA | UA through UZ client reserved | N | |

284 | UP | Used Produt | N | |

285 | V1 | Versand Service | N | |

286 | VC | Sales Order Reverse | N | |

287 | VD | Delivery ocument for Service | N | |

288 | VL | Nota Fiscal Batch Return | N | |

289 | VN | Vendor Notice | ||

290 | VO | Sales Order | N | |

291 | VR | Sales Order Return | N | |

292 | VS | Purchase Order Return | N | |

293 | VT | Sales Transfer Order | N | |

294 | W1 | Work Order Other | N | |

295 | WA | Work order for A | N | |

296 | WC | Warranty Claim | N | |

297 | WD | Write Downs | ||

298 | WH | Equipment Work Order | N | |

299 | WM | Maintenance Work Order | N | |

300 | WO | Real (firm) Work Orders | N | |

301 | WP | Planning Work Orders | N | |

302 | WT | Wire Transfer | N | |

303 | X1 | User-defined Doc Type X1 | ||

304 | X2 | User-defined Doc Type X2 | ||

305 | X3 | User-defined Doc Type X3 | ||

306 | X4 | User-defined Doc Type X4 | ||

307 | XR | Rental Contracts | Y | |

308 | Y1 | User-defined Doc Type Y1 | ||

309 | Y2 | User-defined Doc Type Y2 | ||

310 | Y3 | User-defined Doc Type Y3 | ||

311 | Y4 | User-defined Doc Type Y4 | ||

312 | Y5 | User-defined Doc Type Y5 | ||

313 | Z | Inv Cnv - Month End Summary | N | |

314 | ZC | Document ZC | N | |

315 | ZD | Document ZD | N | |

316 | ZZ | Unrecognized Version E Trans. | N |