| 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 | * | MANDT | Allow NULL? |
| 2 | GENKEY | Key for Table PTRV_CCC (Sequential Number) | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PTRV_CCC_GENKEY | Allow NULL? |
| 3 | LINETYPE | Line Type in Credit Card File | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_CCC_LINETYPE | Allow NULL? |
| 4 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | P_PERNR | Allow NULL? |
| 5 | PNAME | Name of Employee From Credit Card Clearing | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | PTRV_CCC_NAME | Allow NULL? |
| 6 | CARDNUM | Credit Card Number | nvarchar | 19 | 0 | CHAR | (N' ') | Yes | | C_NUM | Allow NULL? |
| 7 | CARDFLAG | Indicator: Employee Credit Card/ Corporate Credit Card | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_CCC_CARDFLAG | Allow NULL? |
| 8 | UMSDATUM | Date of Credit Card Transaction | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_CCC_PURCHASE_DATE | Allow NULL? |
| 9 | UMS_ZEIT | Time Of Credit Card Transaction | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | PTRV_CCC_PURCHASE_TIME | Allow NULL? |
| 10 | SP_KATEG | Credit Card Transaction Category | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_CCC_CATEGORY | Allow NULL? |
| 11 | SPESTEXT | Transaction Key (Supplied by Credit Card Company) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CEKEY | Allow NULL? |
| 12 | S_H_FLAG | Indicator Credit/Debit Credit Card Clearing | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_CCC_DEBIT_CREDIT | Allow NULL? |
| 13 | UMSBETRG | Numerical Amount in Original Currency (Credit Card Clearing) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | PTRV_CCC_ORG_AMOUNT | Allow NULL? |
| 14 | UMSNACHK | Number of Decimal Places For Currency (Credit Card Clearing) | char | 1 | 0 | NUMC | (N'0') | Yes | | PTRV_CCC_DECIMALS | Allow NULL? |
| 15 | UMSWAEHR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 16 | UMS_LAND | Country Where Credit Card Transaction Took Place (ISO Code) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | PTRV_CCC_PURCHASE_COUNTRY | Allow NULL? |
| 17 | UMS_MWST | Value-Added Tax Rate (Amount) in Credit Card Clearing | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ABRMWSTS | Allow NULL? |
| 18 | UMS_KURS | Numerical Exchange Rate (7 Dec. Places) in Credit Card File | nvarchar | 11 | 0 | NUMC | (N'00000000000') | Yes | | PTRV_CCC_EXCHANGE_RATE | Allow NULL? |
| 19 | UMS_HEIM | Nummerical Amount in Accounting Currency (Credit Card Clear) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | PTRV_CCC_ACC_AMOUNT | Allow NULL? |
| 20 | UMSGEBUR | Nummerical Additional Charges Amount (Credit Card Clearing) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | PTRV_CCC_ADD_CHARGE | Allow NULL? |
| 21 | UMSTOTAL | Numerical Total Amount (Credit Card Clearing) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | PTRV_CCC_TOTAL_AMOUNT | Allow NULL? |
| 22 | ADDCOUNT | No. of Additional Information Lines for Credit Card Trans. | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PTRV_CCC_ADD_COUNT | Allow NULL? |
| 23 | TEXT_LANG | Delivered Description of a Credit Card Transaction | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | C_TXT | Allow NULL? |
| 24 | UMSDOKNR | Document Number of Credit Card Receipt | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | C_DOC | Allow NULL? |
| 25 | TRIPNO | Trip Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | REINR | Allow NULL? |
| 26 | DATE_IN | Date in CHAR Format | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PTRV_CCC_DATEC | Allow NULL? |
| 27 | DATE_OUT | Date in CHAR Format | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PTRV_CCC_DATEC | Allow NULL? |
| 28 | VERSION_NR | Number of Credit Card Accounting Run | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PTRV_CCC_RUN | Allow NULL? |
| 29 | E_DESCRIPTION | Error Description for Credit Card Transaction | nvarchar | 132 | 0 | CHAR | (N' ') | Yes | | PTRV_CCC_ERROR_TEXT | Allow NULL? |
| 30 | CARDCOMP | Code of Payment Card Company | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | CCOMP | Allow NULL? |
| 31 | COMPCODE | Company ID for Credit Card Clearing | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | COMPCODE | Allow NULL? |
| 32 | ABRWAEHR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 33 | ABRNACHK | Number of Decimal Places For Currency (Credit Card Clearing) | char | 1 | 0 | NUMC | (N'0') | Yes | | PTRV_CCC_DECIMALS | Allow NULL? |
| 34 | CARDNUM_GUID | GUID of a Payment Card | varbinary | 16 | 0 | RAW | | Yes | | CARD_GUID | |
| 35 | IMAGE_LINK | Contains the UUID for a Document on the Archive Server | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | PTRA_IMAGE_LINK | Allow NULL? |
| 36 | REVERSE_CHARGE_T | Reverse Charge Tax Indicator (X = Reverse Charge Tax) | char | 1 | 0 | CHAR | (N' ') | Yes | | REVERSE_CHARGE_TAX | Allow NULL? |
| 37 | REVERSE_CHARGE_C | Country In Which Reverse Charge Tax Is Paid | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | REVERSE_CHARGE_COUNTRY | Allow NULL? |
