Table: Posting Journals - Detail-Details

Table: OEAUDDD
View: OE0105
Record length: 490
Flags: A R 

Keys: 2

Title  Flags  Fields

Day End Number  TRANSTYPE, DAYENDNUM, ENTRYNUM, LINENUM, COMPNUM
Day End/Entry/Line/Component No.  DAYENDNUM, ENTRYNUM, LINENUM, COMPNUM

Fields: 34

Field  Type  Title  Presentation 

TRANSTYPE  Integer  Transaction Type  List: 5 entries
1=Invoice
2=Credit Note
3=Shipment
4=Debit Note
5=Order
DAYENDNUM  Long  Day End Number   
ENTRYNUM  Long  Entry Number   
LINENUM  Integer  Line Number   
COMPNUM  Long  Component Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
COMPONENT  String*24  Component Item   
DESC  String*60  Description   
LOCATION  String*6  Location  Mask: %-6N
QTYSHIPPED  BCD*10.4  Quantity Shipped   
INVUNIT  String*10  Unit of Measure   
UNITCOST  BCD*10.6  Unit Cost   
EXTCOSTH  BCD*10.3  Extended Cost (Functional)   
EXTCOSTS  BCD*10.3  Extended Cost (Source)   
COSTVARH  BCD*10.3  Cost Variance (Functional)   
COSTVARS  BCD*10.3  Cost Variance (Source)   
UNITWEIGHT  BCD*10.4  Unit Weight   
EXTWEIGHT  BCD*10.4  Extended Weight   
COGSACCT  String*45  Cost of Goods Sold Account  Mask: %-45C
VARIANACCT  String*45  Variance Account  Mask: %-45C
INVACCT  String*45  Inventory Control Account  Mask: %-45C
SHPCLRACCT  String*45  Shipment Clearing Account  Mask: %-45C
EXTCSTADJH  BCD*10.3  Functional Adjusted Ext.Cost   
EXTCSTADJS  BCD*10.3  Source Adjusted Ext. Cost   
CSTVARADJH  BCD*10.3  Functional Adjusted Cost Variance   
CSTVARADJS  BCD*10.3  Source Adjusted Cost Variance   
WEIGHTUNIT  String*10  Weight Unit of Measure   
WEIGHTCONV  BCD*10.6  Weight Conversion Factor   
PRNWGTCONV  BCD*10.6  Parent Weight Conversion Factor   
PRNUWEIGHT  BCD*10.4  Parent Weight UOM Unit Weight   
PRNEXTWGHT  BCD*10.4  Parent WUOM Extended Unit Weight   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.