View: Posting Journals - Details

RotoID: OE0100
Table: OEAUDD
Protocol: Detail, Ordered revisions
DLL:OEAUDD

Compositions: 3

RotoID Tables Title DLL
OE0120 OEAUDH Posting Journals OEAUDH
OE0110 OEAUDDP Posting Jnls Detail Opt. Fields OEAUDDP
OE0105 OEAUDDD Posting Journals - Detail-Details OEAUDDD

Keys: 2

Title Fields
Day End Number TRANSTYPE, DAYENDNUM, ENTRYNUM, LINENUM
Day End No./Entry No./Line No. DAYENDNUM, ENTRYNUM, LINENUM

Fields: 111

Field Index Type Title Attributes Presentation
TRANSTYPE 1 Integer Transaction Type E A K R  List:5 entries
1 = Invoice
2 = Credit Note
3 = Shipment
4 = Debit Note
5 = Order
DAYENDNUM 2 Long Day End Number E A K R 
ENTRYNUM 3 Long Entry Number E A K R 
LINENUM 4 Integer Line Number E A K R 
LINETYPE 5 Integer Line Type E A  List:2 entries
1 = Item
2 = Miscellaneous
ITEM 6 String*24 Item Number E A 
MISCCHARGE 7 String*6 Miscellaneous Charge Code E A 
DESC 8 String*60 Description E A 
PRICELIST 9 String*6 Price List E A 
CATEGORY 10 String*6 Category E A  Mask: %-6N
LOCATION 11 String*6 Location E A  Mask: %-6N
QTYSHIPPED 12 BCD*10.4 Quantity Shipped E A 
INVUNIT 13 String*10 Unit of Measure E A 
UNITPRICE 14 BCD*10.6 Unit Price E A 
PRICEOVER 15 Boolean Price Override E A 
UNITCOST 16 BCD*10.6 Unit Cost E A 
EXTCOSTH 17 BCD*10.3 Extended Cost (Functional) E A 
EXTCOSTS 18 BCD*10.3 Extended Cost (Source) E A 
COSTVARH 19 BCD*10.3 Cost Variance (Functional) E A 
COSTVARS 20 BCD*10.3 Cost Variance (Source) E A 
EXTOVER 21 Boolean Extended Amount Override E A 
EXTINVMISC 22 BCD*10.3 Extended Amount E A 
REVAMTH 23 BCD*10.3 Revenue (Functional) E A 
REVAMTS 24 BCD*10.3 Revenue (Source) E A 
UNITWEIGHT 25 BCD*10.4 Unit Weight E A 
EXTWEIGHT 26 BCD*10.4 Extended Weight E A 
TAUTH1 27 String*12 Tax Authority 1 E A  Mask: %-12N
TAUTH2 28 String*12 Tax Authority 2 E A  Mask: %-12N
TAUTH3 29 String*12 Tax Authority 3 E A  Mask: %-12N
TAUTH4 30 String*12 Tax Authority 4 E A  Mask: %-12N
TAUTH5 31 String*12 Tax Authority 5 E A  Mask: %-12N
TCLASS1 32 Integer Tax Class 1 E A 
TCLASS2 33 Integer Tax Class 2 E A 
TCLASS3 34 Integer Tax Class 3 E A 
TCLASS4 35 Integer Tax Class 4 E A 
TCLASS5 36 Integer Tax Class 5 E A 
TINCLUDED1 37 Boolean Tax Included 1 E A 
TINCLUDED2 38 Boolean Tax Included 2 E A 
TINCLUDED3 39 Boolean Tax Included 3 E A 
TINCLUDED4 40 Boolean Tax Included 4 E A 
TINCLUDED5 41 Boolean Tax Included 5 E A 
TBASE1 42 BCD*10.3 Tax Base 1 E A 
TBASE2 43 BCD*10.3 Tax Base 2 E A 
TBASE3 44 BCD*10.3 Tax Base 3 E A 
TBASE4 45 BCD*10.3 Tax Base 4 E A 
TBASE5 46 BCD*10.3 Tax Base 5 E A 
TAMOUNT1 47 BCD*10.3 Tax Amount 1 E A 
TAMOUNT2 48 BCD*10.3 Tax Amount 2 E A 
TAMOUNT3 49 BCD*10.3 Tax Amount 3 E A 
TAMOUNT4 50 BCD*10.3 Tax Amount 4 E A 
TAMOUNT5 51 BCD*10.3 Tax Amount 5 E A 
REVENUACCT 52 String*45 Revenue Account E A  Mask: %-45C
COGSACCT 53 String*45 Cost of Goods Sold Account E A  Mask: %-45C
VARIANACCT 54 String*45 Variance Account E A  Mask: %-45C
INVACCT 55 String*45 Inventory Control Account E A  Mask: %-45C
RETURNTYPE 56 Integer Return Type E A  List:3 entries
1 = Items Returned to Inventory
2 = Damaged Items
3 = Price Adjustment
SHPCLRACCT 57 String*45 Shipment Clearing Account E A  Mask: %-45C
EXTCSTADJH 58 BCD*10.3 Functional Adjusted Ext.Cost E A 
EXTCSTADJS 59 BCD*10.3 Source Adjusted Ext. Cost E A 
CSTVARADJH 60 BCD*10.3 Functional Adjusted Cost Variance E A 
CSTVARADJS 61 BCD*10.3 Source Adjusted Cost Variance E A 
INVDISC 62 BCD*10.3 Invoice Discount E A 
FROMDOC 63 String*22 From Document E A 
DDTLNO 64 String*6 Kit No. E A  Mask: %-6N
VALUES 65 Long Optional Fields E A C 
TERMDISCBL 66 Integer Discountable E A  List:2 entries
0 = No
1 = Yes
WEIGHTUNIT 67 String*10 Weight Unit of Measure E A 
DEFUWEIGHT 68 BCD*10.4 Def. Weight UOM Unit Weight E A 
DEFEXTWGHT 69 BCD*10.4 Def. Weight UOM Ext. Unit Weight E A 
PRPRICEBY 70 Integer Price By E A  List:2 entries
1 = Quantity
2 = Weight
CAPPROVEBY 71 String*8 Price Approved By E A  Mask: %-8N
TRAMOUNT1 72 BCD*10.3 Tax Reporting Amount 1 E A 
TRAMOUNT2 73 BCD*10.3 Tax Reporting Amount 2 E A 
TRAMOUNT3 74 BCD*10.3 Tax Reporting Amount 3 E A 
TRAMOUNT4 75 BCD*10.3 Tax Reporting Amount 4 E A 
TRAMOUNT5 76 BCD*10.3 Tax Reporting Amount 5 E A 
JOBRELATED 77 Boolean Job Related E A 
CONTRACT 78 String*16 Contract Code E A  Mask: %-16C
PROJECT 79 String*16 Project Code E A  Mask: %-16N
CCATEGORY 80 String*16 Category Code E A  Mask: %-16N
COSTCLASS 81 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
PROJSTYLE 82 Integer Project Style E A  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 83 Integer Project Type E A  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 84 Integer Accounting Method E A  List:9 entries
0 =
1 = Completed Project
2 = Total Cost Percentage Complete
3 = Labor Hours Percentage Complete
4 = Billings and Costs
5 = Project Percentage Complete
6 = Category Percentage Complete
7 = Completed Contract
8 = Accrual-Basis
BILLTYPE 85 Integer Billing Type E A  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
ARITEMNO 86 String*16 A/R Item Number E A 
ARUNIT 87 String*10 A/R Item Unit E A 
RTGAMOUNT 88 BCD*10.3 Retainage Amount E A 
RTGPERCENT 89 BCD*5.5 Retainage Percent E A 
RTGDAYS 90 Integer Retainage Days E A 
RTGDATEDUE 91 Date Retainage Due Date E A 
RTGDDTOVR 92 Boolean Retainage Due Date Override E A 
RTGAMTOVR 93 Boolean Retainage Amount Override E A 
RTGTXBASE1 94 BCD*10.3 Retainage Tax Base 1 E A 
RTGTXBASE2 95 BCD*10.3 Retainage Tax Base 2 E A 
RTGTXBASE3 96 BCD*10.3 Retainage Tax Base 3 E A 
RTGTXBASE4 97 BCD*10.3 Retainage Tax Base 4 E A 
RTGTXBASE5 98 BCD*10.3 Retainage Tax Base 5 E A 
RTGTXAMT1 99 BCD*10.3 Retainage Tax Amount 1 E A 
RTGTXAMT2 100 BCD*10.3 Retainage Tax Amount 2 E A 
RTGTXAMT3 101 BCD*10.3 Retainage Tax Amount 3 E A 
RTGTXAMT4 102 BCD*10.3 Retainage Tax Amount 4 E A 
RTGTXAMT5 103 BCD*10.3 Retainage Tax Amount 5 E A 
OVERHDACCT 104 String*45 Overhead Account E A  Mask: %-45C
OVERHDH 105 BCD*10.3 Overhead (Functional) E A 
OVERHDS 106 BCD*10.3 Overhead (Source) E A 
LABORACCT 107 String*45 Labor Account E A  Mask: %-45C
LABORH 108 BCD*10.3 Labor (Functional) E A 
LABORS 109 BCD*10.3 Labor (Source) E A 
PMTRANSNBR 110 Long PM Transaction Number E A 
EDN 111 String*30 Export Declaration Number E A 

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).