| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| TransId |
Transaction Key |
Int |
11 |
OJDT |
|
|
|
| Line_ID |
Row Number |
Int |
11 |
- |
0 |
|
|
| Account |
Account Code |
nVarChar |
15 |
OACT |
|
|
|
| Debit |
Debit Amount |
Num |
19.6 |
- |
|
|
|
| Credit |
Credit Amount |
Num |
19.6 |
- |
|
|
|
| SYSCred |
System Credit Amount |
Num |
19.6 |
- |
|
|
|
| SYSDeb |
System Debit Amount |
Num |
19.6 |
- |
|
|
|
| FCDebit |
Debit Amount (FC) |
Num |
19.6 |
- |
|
|
|
| FCCredit |
Credit Amount (FC) |
Num |
19.6 |
- |
|
|
|
| FCCurrency |
Foreign Currency |
nVarChar |
3 |
- |
|
|
|
| DueDate |
Due Date |
Date |
8 |
- |
|
|
|
| SourceID |
Source Key |
Int |
11 |
- |
|
|
|
| SourceLine |
Source Row Number |
Int |
6 |
- |
|
|
|
| ShortName |
BP/Account Code |
nVarChar |
15 |
- |
|
|
|
| IntrnMatch |
Internal Reconciliation No. |
Int |
11 |
- |
0 |
|
|
| ExtrMatch |
External Reconciliation No. |
Int |
11 |
- |
0 |
|
|
| ContraAct |
Offset Account |
nVarChar |
15 |
- |
|
|
|
| LineMemo |
Row Details |
nVarChar |
254 |
- |
|
|
|
| Ref3Line |
Reference 3 |
nVarChar |
200 |
- |
|
|
|
| TransType |
Original Journal |
nVarChar |
20 |
- |
-1 |
15 |
Delivery |
| |
|
|
|
|
|
16 |
Returns |
| |
|
|
|
|
|
203 |
A/R Down Payment |
| |
|
|
|
|
|
13 |
A/R Invoice |
| |
|
|
|
|
|
14 |
A/R Credit Memo |
| |
|
|
|
|
|
132 |
Correction Invoice |
| |
|
|
|
|
|
20 |
Goods Receipt |
| |
|
|
|
|
|
21 |
Goods Return |
| |
|
|
|
|
|
204 |
A/P Down Payment |
| |
|
|
|
|
|
18 |
A/P Invoice |
| |
|
|
|
|
|
19 |
A/P Credit Memo |
| |
|
|
|
|
|
69 |
Landed Costs |
| |
|
|
|
|
|
163 |
A/P Correction Invoice |
| |
|
|
|
|
|
24 |
Incoming Payment |
| |
|
|
|
|
|
25 |
Deposit |
| |
|
|
|
|
|
46 |
Vendor Payment |
| |
|
|
|
|
|
57 |
Checks for Payment |
| |
|
|
|
|
|
76 |
Postdated Deposit |
| |
|
|
|
|
|
182 |
BoE Transaction |
| |
|
|
|
|
|
-2 |
Opening Balance |
| |
|
|
|
|
|
-3 |
Closing Balance |
| |
|
|
|
|
|
30 |
Journal Entry |
| |
|
|
|
|
|
58 |
Stock Update |
| |
|
|
|
|
|
59 |
Goods Receipt |
| |
|
|
|
|
|
60 |
Goods Issue |
| |
|
|
|
|
|
67 |
Inventory Transfers |
| |
|
|
|
|
|
68 |
Work Instructions |
| |
|
|
|
|
|
162 |
Inventory Valuation |
| |
|
|
|
|
|
-1 |
All Transactions |
| |
|
|
|
|
|
321 |
Internal Reconciliation |
| |
|
|
|
|
|
140000009 |
Outgoing Excise Invoice |
| |
|
|
|
|
|
10000079 |
TDS Adjustment |
| |
|
|
|
|
|
164 |
A/P Correction Invoice Reversal |
| |
|
|
|
|
|
165 |
A/R Correction Invoice |
| |
|
|
|
|
|
166 |
A/R Correction Invoice Reversal |
| |
|
|
|
|
|
140000010 |
Incoming Excise Invoice |
| |
|
|
|
|
|
202 |
Production Order |
| RefDate |
Posting Date |
Date |
8 |
- |
|
|
|
| Ref2Date |
Posting Date 3 |
Date |
8 |
- |
|
|
|
| Ref1 |
Reference 1 |
nVarChar |
200 |
- |
|
|
|
| Ref2 |
Reference 2 |
nVarChar |
200 |
- |
|
|
|
| CreatedBy |
Origin |
Int |
11 |
- |
|
|
|
| BaseRef |
Base Reference |
nVarChar |
11 |
- |
|
|
|
| Project |
Project Code |
nVarChar |
20 |
OPRJ |
|
|
|
| TransCode |
Transaction Code |
nVarChar |
4 |
OTRC |
|
|
|
| ProfitCode |
Distribution Rule |
nVarChar |
8 |
OOCR |
|
|
|
| TaxDate |
Document Date |
Date |
8 |
- |
|
|
|
| SystemRate |
System Price |
Num |
19.6 |
- |
|
|
|
| MthDate |
Reconciliation Date |
Date |
8 |
- |
|
|
|
| ToMthSum |
Reconciliation Total |
Num |
19.6 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| BatchNum |
Journal Voucher No. |
Int |
11 |
OBTD |
|
|
|
| FinncPriod |
Posting Period |
Int |
11 |
OFPR |
|
|
|
| RelTransId |
Linked Transaction Key |
Int |
11 |
- |
-1 |
|
|
| RelLineID |
Linked Row No. |
Int |
11 |
- |
-1 |
|
|
| RelType |
Link Type |
VarChar |
1 |
- |
N |
N |
Without Link |
| |
|
|
|
|
|
D |
WTax Deduction - Correction |
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| VatGroup |
Tax Group |
nVarChar |
8 |
OVTG |
|
|
|
| BaseSum |
Base Amount |
Num |
19.6 |
- |
|
|
|
| VatRate |
Tax % |
Num |
19.6 |
- |
|
|
|
| Indicator |
Indicator Code |
nVarChar |
2 |
OIDC |
|
|
|
| AdjTran |
Adjusting Trans. (Period 13) |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RevSource |
Revaluation Source |
VarChar |
1 |
- |
N |
F |
Foreign Currency |
| |
|
|
|
|
|
S |
System |
| |
|
|
|
|
|
N |
No |
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
30 |
|
|
| VatDate |
Document Date |
Date |
8 |
- |
|
|
|
| PaymentRef |
Payment Reference No. |
nVarChar |
27 |
- |
|
|
|
| SYSBaseSum |
System Base Amount |
Num |
19.6 |
- |
|
|
|
| MultMatch |
Multiple BP Reconciliation No. |
Int |
11 |
- |
0 |
|
|
| VatLine |
VAT Row |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| VatAmount |
VAT Amount |
Num |
19.6 |
- |
|
|
|
| SYSVatSum |
System VAT Amount |
Num |
19.6 |
- |
|
|
|
| Closed |
Closed |
VarChar |
1 |
- |
N |
|
|
| GrossValue |
Gross Value |
Num |
19.6 |
- |
|
|
|
| CheckAbs |
Internal Check Number |
Int |
11 |
- |
|
|
|
| LineType |
Line Type |
Int |
11 |
- |
0 |
|
|
| DebCred |
Debit Credit Line Indicator |
VarChar |
1 |
- |
|
D |
Debit |
| |
|
|
|
|
|
C |
Credit |
| SequenceNr |
Assigned Sequence No. |
Int |
11 |
- |
0 |
|
|
| StornoAcc |
Storno Account Code |
nVarChar |
15 |
OACT |
|
|
|
| BalDueDeb |
Balance Due - Debit |
Num |
19.6 |
- |
|
|
|
| BalDueCred |
Balance Due - Credit |
Num |
19.6 |
- |
|
|
|
| BalFcDeb |
Balance Due (FC) - Debit |
Num |
19.6 |
- |
|
|
|
| BalFcCred |
Balance Due (FC) - Credit |
Num |
19.6 |
- |
|
|
|
| BalScDeb |
Balance Due (SC) - Debit |
Num |
19.6 |
- |
|
|
|
| BalScCred |
Balance Due (SC) - Credit |
Num |
19.6 |
- |
|
|
|
| IsNet |
Use Net Amount |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DunWizBlck |
Wizard Dunning Block |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| |
|
|
|
|
|
|
|
| DunnLevel |
Dunning Level |
Int |
11 |
ODUN |
0 |
|
|
| DunDate |
Last Dunning Date |
Date |
8 |
- |
|
|
|
| TaxType |
Tax Type |
Int |
6 |
- |
0 |
|
|
| TaxPostAcc |
Tax Posting Account |
VarChar |
1 |
- |
N |
N |
|
| |
|
|
|
|
|
R |
Sales Tax Account |
| |
|
|
|
|
|
P |
Purchasing Tax Account |
| StaCode |
Authority Code |
nVarChar |
8 |
OSTA |
|
|
|
| StaType |
Authority Type |
Int |
11 |
OSTT |
|
|
|
| TaxCode |
Tax Code |
nVarChar |
8 |
OSTC |
|
|
|
| ValidFrom |
Valid From |
Date |
8 |
- |
19000101 |
|
|
| GrossValFc |
Gross Value (FC) |
Num |
19.6 |
- |
|
|
|
| LvlUpdDate |
Dunning Level Update Date |
Date |
8 |
- |
|
|
|
| OcrCode2 |
Costing Code 2 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode3 |
Costing Code 3 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode4 |
Costing Code 4 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode5 |
Costing Code 5 |
nVarChar |
8 |
OOCR |
|
|
|
| MIEntry |
MI Entry when include this OB |
Int |
11 |
OMIN |
0 |
|
|
| MIVEntry |
A/P Monthly Invoice |
Int |
11 |
OMIV |
0 |
|
|
| ClsInTP |
Tax Payment Wizard |
Int |
11 |
OTPW |
0 |
|
|
| CenVatCom |
CENVAT Component |
Int |
11 |
- |
-1 |
|
|
| MatType |
Material Type |
Int |
11 |
- |
-1 |
|
|
| PstngType |
Posting Type |
Int |
11 |
- |
0 |
|
|
| ValidFrom2 |
Valid from2 |
Date |
8 |
- |
19000101 |
|
|
| ValidFrom3 |
Valid from3 |
Date |
8 |
- |
19000101 |
|
|
| ValidFrom4 |
Valid from4 |
Date |
8 |
- |
19000101 |
|
|
| ValidFrom5 |
Valid from5 |
Date |
8 |
- |
19000101 |
|
|
| Location |
Loc. |
Int |
11 |
OLCT |
|
|
|
| WTaxCode |
Withholding Tax Code |
nVarChar |
4 |
OWHT |
|
|
|
| EquVatRate |
Equalization Tax % |
Num |
19.6 |
- |
|
|
|
| EquVatSum |
Equalization Tax Amount |
Num |
19.6 |
- |
|
|
|
| SYSEquSum |
System Equalization Tax Amount |
Num |
19.6 |
- |
|
|
|
| TotalVat |
Total Tax |
Num |
19.6 |
- |
|
|
|
| SYSTVat |
System Total Tax |
Num |
19.6 |
- |
|
|
|
| WTLiable |
WTax-Liable |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| WTLine |
WTax Row |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| WTApplied |
Applied WTax |
Num |
19.6 |
- |
|
|
|
| WTAppliedS |
Applied WTax (SC) |
Num |
19.6 |
- |
|
|
|
| WTAppliedF |
Applied WTax (FC) |
Num |
19.6 |
- |
|
|
|
| WTSum |
WTax Amount |
Num |
19.6 |
- |
|
|
|
| WTSumFC |
WTax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| WTSumSC |
WTax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| PayBlock |
Payment Block |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PayBlckRef |
Payment Block Abs Entry |
Int |
11 |
OPYB |
|
|
|
| LicTradNum |
Federal Tax ID |
nVarChar |
32 |
- |
|
|
|
| InterimTyp |
Interim Account Type |
Int |
11 |
- |
0 |
|
|
| DprId |
Down Payment Request Key |
Int |
11 |
- |
|
|
|
| MatchRef |
Reconciliation Reference |
nVarChar |
20 |
- |
|
|
|
| Ordered |
Payment Ordered |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CUP |
Unique Code of Project |
Int |
11 |
OCUP |
|
|
|
| CIG |
Contract Code Identification |
Int |
11 |
OCIG |
|
|
|
| BPLId |
Branch |
Int |
11 |
OBPL |
|
|
|
| BPLName |
Branch Name |
nVarChar |
200 |
- |
|
|
|
| VatRegNum |
VAT Reg. Number |
nVarChar |
32 |
- |
|
|
|
| SLEDGERF |
Subledger Flag |
VarChar |
1 |
- |
|
|
|
| InitRef2 |
Initial Reference 2 |
nVarChar |
100 |
- |
|
|
|
| InitRef3Ln |
Initial Reference 3 |
nVarChar |
27 |
- |
|
|
|
| ExpUUID |
Expense UUID |
nVarChar |
50 |
- |
|
|
|
| ExpOPType |
Expense Operation Type |
VarChar |
1 |
- |
|
P |
Professional Services |
| |
|
|
|
|
|
R |
Renting Assets |
| |
|
|
|
|
|
O |
Others |
| |
|
|
|
|
|
|
|
| ExTransId |
Exposed Transaction ID |
Int |
11 |
- |
|
|
|
| DocArr |
Source of Posting |
Int |
6 |
- |
|
|
|
| DocLine |
Source Line Internal ID |
Int |
11 |
- |
|
|
|
| MYFtype |
MYF type |
nVarChar |
2 |
- |
|
S1 |
MYF Wholesale Sales |
| |
|
|
|
|
|
S2 |
Retail Sales |
| |
|
|
|
|
|
P1 |
MYF Wholesale Purchases |
| |
|
|
|
|
|
P3 |
Other Expense Transactions |
| DocEntry |
Source Document Entry |
Int |
11 |
- |
|
|
|
| DocNum |
Source Document Number |
Int |
11 |
- |
|
|
|
| DocType |
Source Document Type |
nVarChar |
20 |
- |
|
|
|
| DocSubType |
Document Subtype |
nVarChar |
2 |
- |
|
|
|
| RmrkTmpt |
Remark Text Template |
Int |
11 |
OTTR |
|
|
|
| CemCode |
Cost Element Code |
nVarChar |
20 |
OCEM |
|
|
|
| InClassCat |
Income Classification Category |
Int |
11 |
- |
|
|
|
| InClassTyp |
Income Classification Type |
Int |
11 |
- |
|
|
|
| ExClassCat |
Expense Classification Category |
Int |
11 |
- |
|
|
|
| ExClassTyp |
Expense Classification Type |
Int |
11 |
- |
|
|
|
| VATClassCa |
VAT Classification Category |
Int |
11 |
- |
|
|
|
| VATClassTy |
VAT Classification Type |
Int |
11 |
- |
|
|
|
| EVatCate |
VAT Category |
Int |
11 |
- |
|
|
|
| EWtPercCat |
Withheld Percentage Category |
Int |
11 |
- |
|
|
|
| EWtAmount |
Withheld Amount |
Num |
19.6 |
- |
|
|
|
| EBVatExCau |
VAT Exemption Cause |
Int |
11 |
OVEC |
|
|
|
| OrgBPName |
BP name at time of creation. |
nVarChar |
200 |
- |
|
|
|
| OrgAccName |
Account name at time of creation. |
nVarChar |
200 |
- |
|
|
|