| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | BSTRUCT | JV Billing Structure | nvarchar | 4 | 0 | CHAR | (N' ') | No | | JV_BILLSTR | Allow NULL? |
| 3 | INT_US | Joint Venture Region | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_INTER | Allow NULL? |
| 4 | FL_JIBCL | Flag - Selection of JIB Class | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_FLJIBCL | Allow NULL? |
| 5 | FL_JIBSA | Flag - Selection of JIB Subclass A | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_FLJIBSA | Allow NULL? |
| 6 | FL_JIBSB | Flag - Selection of JIB Subclass B | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_FLJIBSB | Allow NULL? |
| 7 | FL_CEIND | Flag - Selection of Capex/Opex Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_FLCEIND | Allow NULL? |
| 8 | FL_AFEIN | Flag - Selection of AFE/non-AFE Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_FLAFEIN | Allow NULL? |
| 9 | FL_AFENM | Flag - Selection of AFE/non-AFE | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_FLAFENM | Allow NULL? |
| 10 | FL_COBJT | Flag - Selection of Cost Objects | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_FLCOBJT | Allow NULL? |
| 11 | FL_ACCNT | Flag - Selection of Accounts | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_FLACCNT | Allow NULL? |
| 12 | FL_TANGI | Flag - Selection of Tangible/Other Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_FLTANGI | Allow NULL? |
| 13 | FL_SUPPL | Flag - Selection of Supplemental Detail Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_FLSUPPL | Allow NULL? |
| 14 | INVLEVEL | Joint Venture Invoice Level | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_INVLVL | Allow NULL? |
| 15 | EDI_COBJT | JV EDI Cost Object Detail | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_EDCOBJT | Allow NULL? |
| 16 | PROP_EG | JV Equity Group in Property Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_PROP_EG | Allow NULL? |
| 17 | PROP_COMP | JV Component Identifier | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | JV_COMPON | Allow NULL? |
| 18 | CAP_DERI | JV Capital derivation from JIBE master | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_CAP_DER | Allow NULL? |
